mrwildcatosmo arb pool liquidity
    Updated 2023-05-25
    --SELECT *
    --FROM osmosis.core.fact_liquidity_provider_actions
    --WHERE pool_id = ARRAY_CONSTRUCT(1011)

    SELECT
    DATE_TRUNC('day', BLOCK_TIMESTAMP) AS date,
    ACTION,
    COUNT(*) AS transaction_count
    FROM osmosis.core.fact_liquidity_provider_actions
    WHERE POOL_ID = ARRAY_CONSTRUCT(1011)
    GROUP BY 1, ACTION
    ORDER BY 1;


    Run a query to Download Data