eslamis-darkataction axl 1
    Updated 2022-09-28
    select date_trunc('hour',BLOCK_TIMESTAMP) as date,count(tx_id) as number_of_actions
    ,count(DISTINCT LIQUIDITY_PROVIDER_ADDRESS ) as number_of_unique_address
    from osmosis.core.fact_liquidity_provider_actions
    where POOL_ID= '812' and CURRENCY !='uosmo' and TX_STATUS='SUCCEEDED'
    GROUP BY date
    Run a query to Download Data