msafadoostArbitrum native bridge volume
    Updated 2022-06-19
    WITH eth_vol AS (
    SELECT sum(AMOUNT_USD) as eth_usd
    FROM ethereum.core.ez_eth_transfers
    WHERE ORIGIN_TO_ADDRESS = lower('0x72Ce9c846789fdB6fC1f34aC4AD25Dd9ef7031ef')
    ),
    token_vol AS (
    SELECT sum(AMOUNT_USD) as token_usd
    FROM ethereum.core.ez_token_transfers
    WHERE ORIGIN_TO_ADDRESS = lower('0x72Ce9c846789fdB6fC1f34aC4AD25Dd9ef7031ef')
    )
    SELECT eth_usd+token_usd as totalusd_vol
    FROM eth_vol FULL JOIN token_vol
    Run a query to Download Data