OneDataAnalystDaily Volume of Bridge ETH to and From Polygon
    Updated 2022-07-31
    WITH t1 AS(
    SELECT Date_trunc('day',BLOCK_TIMESTAMP) AS Date, SUM(RAW_AMOUNT)/1e18 AS Bridge_IN
    FROM polygon.core.fact_token_transfers
    WHERE CONTRACT_ADDRESS = LOWER('0x7ceB23fD6bC0adD59E62ac25578270cFf1b9f619')
    AND FROM_ADDRESS = '0x0000000000000000000000000000000000000000'
    GROUP BY 1
    ),

    t2 AS(
    SELECT Date_trunc('day',BLOCK_TIMESTAMP) AS Date2, SUM(RAW_AMOUNT)/1e18 AS Bridge_OUT
    FROM polygon.core.fact_token_transfers
    WHERE CONTRACT_ADDRESS = LOWER('0x7ceB23fD6bC0adD59E62ac25578270cFf1b9f619')
    AND TO_ADDRESS = '0x0000000000000000000000000000000000000000'
    AND ORIGIN_FUNCTION_SIGNATURE = '0x2e1a7d4d'
    GROUP BY 1
    )


    SELECT Date,Bridge_IN,Bridge_OUT
    FROM t1
    FULL JOIN t2 ON t1.date = t2.date2
    Run a query to Download Data