ramishoowUntitled Query
    Updated 2022-11-16
    SELECT "TIME", count(DISTINCT LIQUIDITY_PROVIDER_ADDRESS) as "Liquidity Providers" FROM ( SELECT date_trunc('week', day) as "TIME",
    LIQUIDITY_PROVIDER_ADDRESS, count(*) as actvie_days FROM ( SELECT date_trunc('day', block_timestamp) as day, LIQUIDITY_PROVIDER_ADDRESS
    --LIQUIDITY_PROVIDER_ADDRESS, count(*) as actvie_days FROM ( SELECT date_trunc('day', block_timestamp) as day, LIQUIDITY_PROVIDER_ADDRESS
    fROM osmosis.core.fact_liquidity_provider_actions GROUP BY 1,2 )GROUP BY 1,2 ) WHERE actvie_days >= 4 GROUP BY 1
    Run a query to Download Data