date_trunc(day, block_timestamp) as date,

platform,

amount_usd

FROM crosschain.defi.ez_bridge_activity

WHERE amount_usd IS NOT NULL

and amount_usd <1e9

and date >= '2023-01-01'

ORDER BY 3 DESC, 1 ASC

LIMIT 1000