SELECT

block_timestamp as date,

sum(CASE WHEN symbol_in LIKE '%token%' then amount_in_usd END) volume_sold,

sum(CASE WHEN symbol_out LIKE '%token%' then amount_in_usd END) volume_bought,

sum(CASE WHEN symbol_in LIKE '%token%' then -1 * amount_in_usd

WHEN symbol_out LIKE '%token%' then amount_in_usd END) as net_volume,

count(*) as swap_evetns

FROM ethereum.core.ez_dex_swaps

where block_timestamp > CURRENT_DATE - 30

GROUP by 1