SELECT

block_timestamp,

tx_hash,

origin_from_address AS swapper,

symbol_in,

symbol_out,

platform,

COALESCE(amount_in_usd, amount_out_usd) AS swap_amount_usd

FROM avalanche.defi.ez_dex_swaps

WHERE origin_to_address = '0x1dac23e41fc8ce857e86fd8c1ae5b6121c67d96d'

AND block_timestamp >= '2024-01-01'

AND swap_amount_usd is not null

SELECT DATE_TRUNC('Month', Block_timestamp) AS swap_date,

platform,

COUNT(DISTINCT tx_hash) AS tx_count,

COUNT(DISTINCT swapper) AS unique_swappers,

SUM(swap_amount_usd) AS volume_usd,

FROM okx_aggregator_swaps

GROUP BY platform, swap_date

order by swap_date desc