-- forked from Total Stats @ https://flipsidecrypto.xyz/edit/queries/285a724d-514e-4c8c-8077-41c5818614e2

with

eth_transfers AS (

select

TX_HASH,

AMount_USD,

ETH_FROM_ADDRESS AS From_Address,

'ETH' AS SYMBOL

from

ethereum.core.ez_eth_transfers

where

ETH_TO_ADDRESS != '0x8731d54E9D02c286767d56ac03e8037C07e01e98'

union ALL

select

TX_HASH,

AMount_USD,

From_Address,

SYMBOL

from

ethereum.core.ez_token_transfers

),

OP_transfers AS (

select

TX_HASH,

AMount_USD,

ETH_FROM_ADDRESS AS From_Address,

'ETH' AS SYMBOL

from

optimism.core.ez_eth_transfers

where

ETH_TO_ADDRESS != '0xb0d502e938ed5f4df2e681fe6e419ff29631d62b'

union ALL

select