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