PapasotLiquidity: USD Volume - Daily
    Updated 2022-03-14
    WITH liquidity_pool AS (
    SELECT
    tx_id,
    date_trunc('day', block_timestamp) AS date,
    action,
    pool_address,
    pool_name,
    token0_address,
    token1_address,
    token0_symbol,
    token1_symbol,
    amount0_adjusted,
    amount1_adjusted,
    amount0_usd,
    amount1_usd,
    (amount0_usd + amount1_usd) AS add_amount_total
    FROM uniswapv3.lp_actions
    ),
    add_liquidity AS (
    SELECT
    date,
    SUM(add_amount_total) AS total_deposit
    FROM liquidity_pool
    WHERE action = 'INCREASE_LIQUIDITY'
    GROUP BY 1
    ),
    remove_liquidity AS (
    SELECT
    date,
    -SUM(add_amount_total) AS total_withdrawl
    FROM liquidity_pool
    WHERE action = 'DECREASE_LIQUIDITY'
    GROUP BY 1
    )

    SELECT
    Run a query to Download Data