date_trunc('day', block_timestamp) Date,

origin_from_address,

amount_in_usd,

platform,

symbol_in,

tx_hash,

FROM ethereum.defi.ez_dex_swaps

WHERE event_name = 'Swap'

AND amount_in_usd IS NOT NULL

AND platform = 'uniswap-v3'

AND DATE(block_timestamp) >= '2024-01-01'

ORDER BY 3 DESC

LIMIT 100