select

BLOCK_TIMESTAMP,

'Ethereum' as blockchains,

tx_hash,

FROM_ADDRESS,

--to_address,

RAW_AMOUNT/pow(10,decimals) as Volume

from ethereum.core.ez_token_transfers

where 1=1

and CONTRACT_ADDRESS = lower('0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48')

and to_address != '0x0000000000000000000000000000000000000000'

and from_address != '0x0000000000000000000000000000000000000000'

and block_timestamp >= current_date - {{Period}}

and RAW_AMOUNT > 0

and RAW_AMOUNT is not NULL

and decimals is not null

union ALL

select

BLOCK_TIMESTAMP,

'Solana' as blockchains,

TX_ID as TX_hash,

TX_FROM as from_address,

--TX_TO as To_address,

AMOUNT as Volume

from solana.core.fact_transfers

where 1=1

and MINT = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'

and block_timestamp >= current_date - {{Period}}

and AMOUNT is not NULL

and AMOUNT > 0

union all