MLDZMNBridge Whales
    Updated 2023-03-26
    with tb1 as (select
    'Ethereum-> Optimism' as bridge_path,
    BLOCK_TIMESTAMP,
    tx_hash,
    ORIGIN_FROM_ADDRESS,
    amount_usd,
    SYMBOL as token
    from ethereum.core.ez_token_transfers
    where to_address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'
    and symbol in ('USDC','USDT','DAI','LUSD')
    union
    select
    'Ethereum-> Optimism' as bridge_path,
    BLOCK_TIMESTAMP,
    tx_hash,
    ORIGIN_FROM_ADDRESS,
    amount_usd,
    'ETH' as token
    from ethereum.core.ez_eth_transfers
    where eth_to_address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'),

    tb2 as (select
    'Optimism-> Ethereum' as bridge_path,
    BLOCK_TIMESTAMP,
    tx_hash,
    ORIGIN_FROM_ADDRESS,
    amount_usd,
    SYMBOL as token
    from ethereum.core.ez_token_transfers
    where origin_to_address = '0x25ace71c97b33cc4729cf772ae268934f7ab5fa1'
    and symbol in ('USDC','USDT','DAI','LUSD')
    union
    select
    'Optimism-> Ethereum' as bridge_path,
    BLOCK_TIMESTAMP,
    tx_hash,
    Run a query to Download Data