msafadoostHop bridge volume to Arbitrum
    Updated 2022-06-19
    WITH bridge_to_opti AS (
    SELECT TX_HASH
    FROM ethereum.core.fact_event_logs
    WHERE ORIGIN_TO_ADDRESS IN (
    lower('0xb8901acB165ed027E32754E0FFe830802919727f'),
    lower('0x3666f603Cc164936C1b87e207F36BEBa4AC5f18a'),
    lower('0x3E4a3a4796d16c0Cd582C382691998f7c06420B6'),
    lower('0x3d4Cc8A61c7528Fd86C55cfe061a78dCBA48EDd1'),
    lower('0x22B1Cbb8D98a01a3B71D034BB899775A76Eb1cc2'),
    lower('0xb98454270065A31D71Bf635F6F7Ee6A518dFb849')
    )
    AND EVENT_INPUTS:chainId = '42161'
    --AND EVENT_NAME = 'TransferSentToL2'
    GROUP by 1

    ),
    eth_vol AS (
    SELECT sum(AMOUNT_USD) as eth_usd
    FROM ethereum.core.ez_eth_transfers
    WHERE TX_HASH IN (
    SELECT TX_HASH FROM bridge_to_opti
    )
    ),
    token_vol AS (
    SELECT sum(AMOUNT_USD) as token_usd
    FROM ethereum.core.ez_token_transfers
    WHERE
    TX_HASH IN (
    SELECT TX_HASH FROM bridge_to_opti
    )
    )
    SELECT eth_usd+token_usd as totalusd_vol
    FROM eth_vol FULL JOIN token_vol
    Run a query to Download Data