msafadoostvolume bridged in the past 6 month
    Updated 2022-06-17
    WITH eth_vol AS (
    SELECT DATE(BLOCK_TIMESTAMP) as e_date,
    sum(AMOUNT_USD) as eth_usd
    FROM ethereum.core.ez_eth_transfers
    WHERE ETH_TO_ADDRESS = lower('0xb8901acB165ed027E32754E0FFe830802919727f')
    AND BLOCK_TIMESTAMP >= CURRENT_DATE - 180
    GROUP BY 1
    ),
    token_vol AS (
    SELECT DATE(BLOCK_TIMESTAMP) AS t_date,
    sum(AMOUNT_USD) as token_usd
    FROM ethereum.core.ez_token_transfers
    WHERE TO_ADDRESS = lower('0xb8901acB165ed027E32754E0FFe830802919727f')
    OR TO_ADDRESS = lower('0x3666f603Cc164936C1b87e207F36BEBa4AC5f18a') -- usdc bridge
    OR TO_ADDRESS = lower('0x3E4a3a4796d16c0Cd582C382691998f7c06420B6') -- usdt bridge
    OR TO_ADDRESS = lower('0x3d4Cc8A61c7528Fd86C55cfe061a78dCBA48EDd1') -- dai bridge
    OR TO_ADDRESS = lower('0x22B1Cbb8D98a01a3B71D034BB899775A76Eb1cc2') -- matic bridge
    OR TO_ADDRESS = lower('0xb98454270065A31D71Bf635F6F7Ee6A518dFb849') -- wbtc bridge
    AND BLOCK_TIMESTAMP >= CURRENT_DATE - 180
    GROUP BY 1
    )
    SELECT
    e_date,
    sum(eth_usd)+sum(token_usd) as totalusd_vol
    FROM eth_vol FULL JOIN token_vol
    GROUP by 1
    ORDER by 1
    Run a query to Download Data