Query editor
SELECT sum(case when trade_category = 'mint' then eth_amount else 0 end) as volume, 'mint' as type FROM query_3974151 where block_time<=timestamp'2024-08-14'union allselect sum(case when trade_category != 'mint' then eth_amount else 0 end) as volume, 'secondary' as type FROM query_3974151 where block_time<=timestamp '2024-08-14'