SELECT

block_timestamp::date AS swap_date,

origin_from_address,

CASE

WHEN token_in = lower ('0x44108f0223A3C3028F5Fe7AEC7f9bb2E66beF82F') THEN 'Buyer'

WHEN token_out = lower ('0x44108f0223A3C3028F5Fe7AEC7f9bb2E66beF82F') THEN 'Seller'

END AS swap_type

FROM

ethereum.defi.ez_dex_swaps

WHERE

token_in = lower ('0x44108f0223A3C3028F5Fe7AEC7f9bb2E66beF82F')

OR token_out = lower ('0x44108f0223A3C3028F5Fe7AEC7f9bb2E66beF82F')

swap_date,

swap_type,

COUNT(DISTINCT origin_from_address) AS num_swappers

token_swaps

where swap_date >= '2024-01-01'

GROUP BY

swap_date,

swap_type

ORDER BY

swap_date,

swap_type;