block_timestamp::date AS date

, sum(iff(token_out = lower('{{base_token}}') AND '{{have_terms_conditions_been_accept}}' = 'Yes', amount_in, 0)) AS buy_volume

, sum(iff(token_in = lower('{{base_token}}') AND '{{have_terms_conditions_been_accept}}' = 'Yes', amount_out, 0)) AS sell_volume

, count(DISTINCT (CASE WHEN token_out = lower('{{base_token}}') AND '{{have_terms_conditions_been_accept}}' = 'Yes' then tx_hash end)) AS buys

, count(DISTINCT (CASE WHEN token_in = lower('{{base_token}}') AND '{{have_terms_conditions_been_accept}}' = 'Yes' then tx_hash end)) AS sells

, count(DISTINCT (CASE WHEN token_out = lower('{{base_token}}') AND '{{have_terms_conditions_been_accept}}' = 'Yes' then origin_from_address end)) AS buyers

, count(DISTINCT (CASE WHEN token_in = lower('{{base_token}}') AND '{{have_terms_conditions_been_accept}}' = 'Yes' then origin_from_address end)) AS sellers

, buy_volume + sell_volume AS volume

, buy_volume - sell_volume as delta

, sum(volume) OVER (ORDER BY date) AS cumulative_volume

FROM ethereum.core.ez_dex_swaps

WHERE block_timestamp > '2023-07-01'

AND (token_in = lower('{{base_token}}') OR token_out = lower('{{base_token}}'))

GROUP BY 1

ORDER BY 1