Query editor
SELECTsum(COALESCE(input_usd,output_usd)) as volume, sum(case when log_index = 1 then 1 else 0 end) as swaps, count(distinct tx_signer) as traders, sum(case when block_time >= now() - interval '24' hour then COALESCE(input_usd,output_usd) else null end) as volume_24, sum(case when block_time >= now() - interval '24' hour and log_index = 1 then 1 else 0 end) as swaps_24, count(distinct case when block_time >= now() - interval '24' hour then tx_signer else null end) as traders_24FROM jupiter_solana.aggregator_swaps