WITH trans AS (

SELECT block_timestamp, origin_from_address AS sender, origin_to_address AS receiver

, amount, symbol, amount_usd

, CASE

WHEN symbol IN ('USDC', 'USDT') THEN 'Fiat Backed'

WHEN symbol = 'WETH' THEN 'Native Currency'

WHEN symbol = 'WBTC' THEN 'Derivative Token'

END AS type

, date_trunc('day', block_timestamp) AS day, date_trunc('month', block_timestamp) AS month

FROM ethereum.core.ez_token_transfers

WHERE contract_address IN (

lower('0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48'),

lower('0xdAC17F958D2ee523a2206206994597C13D831ec7'),

lower('0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2'),

lower('0x2260FAC5E5542a773Aa44fBCfeDf7C193bc2C599')

)

QUALIFY RANK () OVER (PARTITION BY receiver, symbol ORDER BY block_timestamp) = 1

UNION

SELECT block_timestamp, eth_from_address AS sender, eth_to_address AS receiver

, amount, 'ETH' AS symbol, amount_usd, 'Native Currency' AS type

, date_trunc('day', block_timestamp) AS day, date_trunc('month', block_timestamp) AS month

FROM ethereum.core.ez_eth_transfers

QUALIFY RANK () OVER (PARTITION BY receiver, symbol ORDER BY block_timestamp) = 1

SELECT month, type, count(*) AS trades

FROM trans

GROUP BY 1,2

ORDER BY month