Query editor
WITH hourly AS (SELECT *FROM "query_8112609")SELECTDATE_TRUNC('day', hour) AS day,SUM(volume_usd) AS daily_volume_usd,SUM(volume_eth) AS daily_volume_eth,SUM(gross_trading_fees_usd) AS daily_gross_fees_usd,SUM(creator_revenue_usd) AS daily_creator_revenue_usd,SUM(protocol_trading_revenue_usd)AS daily_protocol_trading_revenue_usd,SUM(launch_fees_usd) AS daily_launch_fees_usd,SUM(total_protocol_revenue_usd)AS daily_protocol_revenue_usd,SUM(buyback_allocation_usd)AS daily_buyback_allocation_usd,SUM(operations_allocation_usd)AS daily_operations_allocation_usd,SUM(launches) AS daily_launchesFROM hourlyWHERE hour >= DATE_TRUNC('day', CURRENT_TIMESTAMP)- INTERVAL '6' DAYGROUP BY 1ORDER BY 1;