with raw_tx as(

select

block_timestamp::date day,

tx_hash,

token_in,

amount_in_usd,

token_out,

amount_out_usd

from {{blockchain}}.defi.ez_dex_swaps

where block_timestamp::date >= current_date - {{days_back}}

and (

token_in = lower('{{token_address}}')

or token_out = lower('{{token_address}}'))

),

sell as (

select

day,

'Sell' type,

sum(case

when token_in = lower('{{token_address}}') then amount_in_usd

end) volume

from raw_tx

group by day

),

buy as(

select

day,

'Buy' type,

sum(case

when token_out = lower('{{token_address}}') then amount_out_usd

end) volume

from raw_tx

group by day