WITH all_addresses AS (

-- Union all addresses from Ethereum and Binance

SELECT 'ethereum' as chain,

to_address,

DATE_TRUNC('month', block_timestamp)::date AS Month,

symbol

FROM

ethereum.core.ez_token_transfers

WHERE

(block_timestamp::date BETWEEN '2023-01-01' AND '2024-12-31' AND contract_address = LOWER('0x1294f4183763743c7c9519Bec51773fb3aCD78FD'))

UNION ALL

SELECT 'binance' as chain,

to_address,

DATE_TRUNC('month', block_timestamp)::date AS Month,

symbol

FROM

bsc.core.ez_token_transfers

WHERE

(block_timestamp >= '2023-01-01' AND contract_address = LOWER('0x1294f4183763743c7c9519Bec51773fb3aCD78FD'))

),

first_seen_addresses AS (

-- Find the first month each address appears

SELECT

to_address,

MIN(Month) AS first_seen_month

FROM

all_addresses

GROUP BY

to_address

SELECT chain,

first_seen_month AS Month,