dan-smithfrxETH Curve Pool: Deposits and Withdrawals of ETH/frxETH
    Updated 2023-06-20
    WITH
    addliquidity AS (
    SELECT
    DECODED_LOG:provider AS provider
    ,SUM(DECODED_LOG:token_amounts[0] / 1e18) AS eth_add
    ,SUM(DECODED_LOG:token_amounts[1] / 1e18) AS frxETH_add
    ,SUM(DECODED_LOG:invariant / 1e18) AS lp_add
    FROM ethereum.core.fact_decoded_event_logs
    WHERE
    (EVENT_NAME = 'AddLiquidity')
    AND CONTRACT_ADDRESS = '0xa1f8a6807c402e4a15ef4eba36528a3fed24e577'
    GROUP BY 1
    ),

    removeliquidity AS (
    SELECT
    DECODED_LOG:provider AS provider
    ,-SUM(DECODED_LOG:token_amounts[0] / 1e18) AS eth_rem
    ,-SUM(DECODED_LOG:token_amounts[1] / 1e18) AS frxETH_rem
    ,-SUM(DECODED_LOG:coin_amount / 1e18) AS lp_rem
    FROM ethereum.core.fact_decoded_event_logs
    WHERE
    (EVENT_NAME = 'RemoveLiquidity')
    AND CONTRACT_ADDRESS = '0xa1f8a6807c402e4a15ef4eba36528a3fed24e577'
    GROUP BY 1
    ),

    removeLiquidityOne AS (
    SELECT
    DECODED_LOG:provider AS provider
    ,-SUM(CASE WHEN eth_value > 0 THEN DECODED_LOG:coin_amount / 1e18
    ELSE 0
    END) AS eth_rem_one
    ,-SUM(CASE WHEN eth_value > 0 THEN 0
    ELSE DECODED_LOG:coin_amount / 1e18
    END) AS frxETH_rem_one
    Run a query to Download Data