Query editor
SELECTdate_trunc('day',block_time) as date_time,-- project,COUNT(DISTINCT(tx_id)) as total_transactions,SUM(amount_usd) as total_sol_volume_usd,COUNT(DISTINCT(trader_id)) as total_addresses,SUM(SUM(amount_usd)) OVER (ORDER BY date_trunc('day',block_time)) as total_sol_volume_usd_all_timeFROM dex_solana.tradesWHERE project = 'pumpdotfun'--,'pumpswap'and DATE(block_time) > DATE(now()) - interval '365' dayGROUP BY 1--,2ORDER BY 1 DESC