Query editor
with timeframe as (selectcasewhen '{{DEX Granularity}}' = 'yearly' then now() - interval '5' yearwhen '{{DEX Granularity}}' = 'monthly' then now() - interval '14' monthwhen '{{DEX Granularity}}' = 'daily' then now() - interval '14' monthend as start_date,casewhen '{{DEX Granularity}}' = 'yearly' then 'year'when '{{DEX Granularity}}' = 'monthly' then 'month'when '{{DEX Granularity}}' = 'daily' then 'day'end as interval)SELECTdate_trunc((select interval from timeframe),block_time) as time,SUM(amount_usd) as volume,count(distinct trader_id) as traderFROM dex_solana.tradesWHERE amount_usd <1000000000 --ignore anomalyAND date(block_time) >= (select start_date from timeframe)group by 1