binhachon1. Daily bETH Volume: Volume bridge from Terra to Ethereum
    Updated 2021-10-07
    WITH BRIDGE_FROM_LIDO AS(
    SELECT BLOCK_TIMESTAMP, TX_ID, ORIGIN_ADDRESS AS ADDRESS, AMOUNT FROM ethereum.udm_events
    WHERE ORIGIN_FUNCTION_SIGNATURE = '0x9e63798d' -- Send from LIDO using submit function
    AND TO_ADDRESS = '0xf9dcf31ee6eb94ab732a43c2fba1dc6179c98965' -- bETH Shuttle Vault
    AND CONTRACT_ADDRESS = '0x707f9118e33a9b8998bea41dd0d46f38bb963fc8' -- bETH contract
    ),

    BRIDGE_FROM_TERRA_BRIDGE AS (
    SELECT BLOCK_TIMESTAMP, TX_ID, ORIGIN_ADDRESS AS ADDRESS, AMOUNT FROM ethereum.udm_events
    WHERE ORIGIN_FUNCTION_SIGNATURE = '0xbcf64e05' -- Burn function
    AND TO_ADDRESS = '0xf9dcf31ee6eb94ab732a43c2fba1dc6179c98965' -- bETH Shuttle Vault
    AND CONTRACT_ADDRESS = '0x707f9118e33a9b8998bea41dd0d46f38bb963fc8' -- bETH contract
    ),

    BRIDGE_FROM_TERRA_SIDE AS (
    SELECT BLOCK_TIMESTAMP, TX_ID, TO_ADDRESS AS ADDRESS, AMOUNT FROM ethereum.udm_events
    WHERE ORIGIN_FUNCTION_SIGNATURE = '0xedeb09c7' -- Mint function
    AND FROM_ADDRESS = '0xf9dcf31ee6eb94ab732a43c2fba1dc6179c98965' -- bETH Shuttle Vault
    AND CONTRACT_ADDRESS = '0x707f9118e33a9b8998bea41dd0d46f38bb963fc8' -- bETH contract
    ),
    TOTAL_BRIDGE_TO_TERRA AS(
    SELECT 'LIDO_TO_TERRA' AS SYMBOL, DATE_TRUNC('Day', BLOCK_TIMESTAMP) AS BLOCKTIME, ADDRESS, AMOUNT FROM BRIDGE_FROM_LIDO
    UNION ALL
    SELECT 'TERRA_BRIDGE_TO_TERRA' AS SYMBOL, DATE_TRUNC('Day', BLOCK_TIMESTAMP) AS BLOCKTIME, ADDRESS, AMOUNT FROM BRIDGE_FROM_TERRA_BRIDGE
    ),

    TOTAL_BRIDGE_TO_ETH AS(
    SELECT 'TO_ETHEREUM' AS SYMBOL, DATE_TRUNC('Day', BLOCK_TIMESTAMP) AS BLOCKTIME, ADDRESS, AMOUNT FROM BRIDGE_FROM_TERRA_SIDE
    ),
    TOTAL_BRIDGE AS(
    SELECT SYMBOL, BLOCKTIME, SUM(AMOUNT) AS AMOUNT FROM TOTAL_BRIDGE_TO_TERRA
    GROUP BY SYMBOL, BLOCKTIME
    UNION ALL SELECT SYMBOL, BLOCKTIME, SUM(AMOUNT) AS AMOUNT FROM TOTAL_BRIDGE_TO_ETH
    GROUP BY SYMBOL, BLOCKTIME
    ORDER BY BLOCKTIME DESC, AMOUNT -- Final table
    Run a query to Download Data