SELECT

date_trunc('day', block_timestamp) as day,

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