Query editor
WITH weekly_tokens AS (SELECTdate_trunc('week', created_at) as week,token_version,count(*) as tokens_createdFROM tokens_solana.fungibleGROUP BY 1, 2),weekly_totals AS (SELECTweek,sum(tokens_created) as total_weekly_tokensFROM weekly_tokensGROUP BY 1)SELECTwt.week,wt.token_version,wt.tokens_created,wt.tokens_created / cast(tot.total_weekly_tokens as double) as weekly_share,tot.total_weekly_tokens as total_tokensFROM weekly_tokens wtJOIN weekly_totals totON tot.week = wt.weekORDER BY week DESC, tokens_created DESC;