Query editor
SELECTDATE(block_time) AS date,COUNT(DISTINCT trader_id) AS "DAU"FROM (SELECT block_time, trader_id FROM raydium_v3.tradesWHERE block_time BETWEEN TIMESTAMP '2024-01-01 00:00:00' AND TIMESTAMP '2025-01-31 23:59:59'UNION ALLSELECT block_time, trader_id FROM raydium_v4.tradesWHERE block_time BETWEEN TIMESTAMP '2024-01-01 00:00:00' AND TIMESTAMP '2025-01-31 23:59:59') AS combined_tradesGROUP BY DATE(block_time)ORDER BY date;