block_timestamp, tx_hash, from_address AS user, amount, amount_usd, symbol

FROM base.core.ez_token_transfers

WHERE to_address = '0xa035e7fa5e4704c2ecb2f7f8c1eeff09c550fdc5'

AND block_timestamp::date >= '2025-02-10'

AND has_price

UNION ALL

SELECT

block_timestamp, tx_hash, from_address AS user, amount, amount_usd, 'ETH' AS symbol

FROM base.core.ez_native_transfers

WHERE to_address = '0xa035e7fa5e4704c2ecb2f7f8c1eeff09c550fdc5'

AND block_timestamp::date >= '2025-02-10'

SELECT

count(tx_hash) AS transactions,

count(DISTINCT user) AS users,

SUM(amount_usd) AS usd_amount

FROM transfers