SELECT

'ethereum' as chain,

tx_hash,

block_timestamp,

from_address AS sender,

to_address AS receiver,

amount

FROM ethereum.core.ez_token_transfers

where CONTRACT_ADDRESS = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'

and from_address != '0x0000000000000000000000000000000000000000'

and to_address != '0x0000000000000000000000000000000000000000'

and amount > 0

and block_timestamp >= CURRENT_DATE - interval '{{ data_first_day }} days'

and block_timestamp < CURRENT_DATE

),

usdc_solana as (

SELECT

'solana' as chain,

tx_id,

block_timestamp,

tx_from AS sender,

tx_to AS receiver,

amount

FROM solana.core.fact_transfers

where MINT = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'

and TX_FROM NOT IN ('F8Vyqk3unwxkXukZFQeYyGmFfTG3CAX4v24iyrjEYBJV',

'3uTzTX5GBSfbW7eM9R9k95H7Txe32Qw3Z25MtyD2dzwC',

'FGBvMAu88q9d1Csz7ZECB5a2gbWwp6qicNxN2Mo7QhWG',

'FG3z1H2BBsf5ekEAxSc1K6DERuAuiXpSdUGkYecQrP5v',

'GVV4ZT9pccwy9d17STafFDuiSqFbXuRTdvKQ1zJX6ttX',

'9BVcYqEQxyccuwznvxXqDkSJFavvTyheiTYk231T1A8S',

'CuieVDEDtLo7FypA9SbLM9saXFdb1dsshEkyErMqkRQq',

'5Q544fKrFoe6tsEbD7S8EmxGTJYAKtTVhAW5Q5pge4j1',

'FmhXe9uG6zun49p222xt3nG1rBAkWvzVz7dxERQ6ouGw'