Query editor
withpairs as (SELECTproject, token_bought_mint_address, min(block_time) as first_trade_timeFROM dex_solana.trades trGROUP BY 1,2)SELECTdate_trunc('week',first_trade_time) as week_created, project, count(*) as pairsFROM pairsWHERE first_trade_time > timestamp '{{start date}}'GROUP BY 1,2