bhavaniGetting Started
    Updated 2024-11-05
    WITH RecentWithdrawals AS (
    SELECT
    LIQUIDITY_POOL_ADDRESS,
    LIQUIDITY_PROVIDER,
    SUM(AMOUNT) AS TOTAL_WITHDRAWN,
    COUNT(*) AS NUM_WITHDRAWALS
    FROM
    solana.defi.fact_liquidity_pool_actions
    WHERE
    SUCCEEDED = TRUE
    AND ACTION = 'withdraw'
    AND BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '365 DAY'
    GROUP BY
    LIQUIDITY_POOL_ADDRESS, LIQUIDITY_PROVIDER
    ),
    RecentDeposits AS (
    SELECT
    LIQUIDITY_POOL_ADDRESS,
    LIQUIDITY_PROVIDER,
    SUM(AMOUNT) AS TOTAL_DEPOSITED
    FROM
    solana.defi.fact_liquidity_pool_actions
    WHERE
    SUCCEEDED = TRUE
    AND ACTION = 'deposit'
    AND BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '365 DAY'
    GROUP BY
    LIQUIDITY_POOL_ADDRESS, LIQUIDITY_PROVIDER
    )
    SELECT
    w.LIQUIDITY_POOL_ADDRESS,
    w.LIQUIDITY_PROVIDER,
    w.TOTAL_WITHDRAWN,
    d.TOTAL_DEPOSITED,
    w.NUM_WITHDRAWALS,
    w.TOTAL_WITHDRAWN / NULLIF(d.TOTAL_DEPOSITED, 0) AS WITHDRAW_TO_DEPOSIT_RATIO,
    QueryRunArchived: QueryRun has been archived