date_trunc ( day ,block_timestamp) as date ,

tx_hash,

origin_from_address,

contract_address,

amount_in_usd,

ADDRESS

FROM ethereum.defi.ez_dex_swaps A

JOIN ethereum.core.dim_labels B

ON A.CONTRACT_ADDRESS = B.ADDRESS

WHERE platform ILIKE 'uniswap%'

AND AMOUNT_IN_USD IS NOT NULL

ORDER BY 5 DESC

limit 100