--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;