Query editor
WITH daily_tokens AS (SELECTdate_trunc('day', created_at) as day,token_version,count(*) as tokens_createdFROM tokens_solana.fungible--WHERE created_at >= timestamp '2023-05-01'--WHERE created_at >= timestamp '2023-12-01'WHERE created_at >= timestamp '2024-08-01'and created_at < timestamp '2025-03-01'GROUP BY 1, 2),daily_totals AS (SELECTday,sum(tokens_created) as total_daily_tokensFROM daily_tokensGROUP BY 1)SELECTdt.day,dt.token_version,dt.tokens_created,dt.tokens_created / cast(tot.total_daily_tokens as double) as daily_share,tot.total_daily_tokens as total_tokensFROM daily_tokens dtJOIN daily_totals totON tot.day = dt.dayORDER BY day DESC, tokens_created DESC;