date_trunc('{{interval}}', block_timestamp) as date,

count(DISTINCT tx_hash) as n_swaops,

count(DISTINCT sender) as unique_senders,

count(DISTINCT tx_to) as unique_recivers,

sum(CASE when token_in = '0x2791bca1f2de4661ed88a30c99a7a9449aa84174' then amount_in else 0 end) as flow_in,

sum(CASE when token_out = '0x2791bca1f2de4661ed88a30c99a7a9449aa84174' then amount_out else 0 end) as flow_out,

flow_in - flow_out as net_flow,

flow_in + flow_out as total_flow

FROM polygon.core.ez_dex_swaps

WHERE

( token_in like '0x2791bca1f2de4661ed88a30c99a7a9449aa84174' OR

token_out like '0x2791bca1f2de4661ed88a30c99a7a9449aa84174'

)

AND block_timestamp >= DATEADD('{{interval}}', -1*{{last_n_period}}, CURRENT_DATE)

AND block_timestamp <= CURRENT_DATE-1

GROUP BY 1

ORDER BY 1 DESC