Query editor
SELECTdate_trunc('week', block_date) AS week,'solana' AS blockchain,COUNT(*) AS estimated_swap_count,COUNT(DISTINCT from_owner) AS active_users,SUM(amount_usd) AS estimated_swap_volume_usd,SUM(SUM(amount_usd)) OVER (ORDER BY date_trunc('week', block_date)) AS cum_volFROM tokens_solana.transfersWHEREto_owner IN ('BEochrdGhm5pcKVF73DURYrGo1DLzxq6bBcUBphQR64d')AND block_date >= DATE '2024-01-01'GROUP BY 1, 2ORDER BY week DESC;