pouya_22Inflows and Outflows (redux) - ETH to OP General
    Updated 2022-11-01
    with eth_to_op as (select
    'ETH' as asset,
    tx_hash,
    origin_from_address,
    amount_usd
    from ethereum.core.ez_eth_transfers
    where origin_to_address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'

    union all

    select
    symbol as asset,
    tx_hash,
    origin_from_address,
    amount_usd
    from ethereum.core.ez_token_transfers
    where origin_to_address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'
    and amount_usd is not null)

    select
    count(distinct tx_hash) as bridges,
    count(distinct origin_from_address) as users,
    sum(amount_usd) as usd_vol
    from eth_to_op
    Run a query to Download Data