Updated 2022-06-08
    select
    date(BLOCK_TIMESTAMP) as dt,
    ACTION,
    sum(AMOUNT/1e18) as vol,
    count(distinct tx_id) as no_txn,
    count(distinct LIQUIDITY_PROVIDER_ADDRESS) as users
    from osmosis.core.fact_liquidity_provider_actions

    where BLOCK_TIMESTAMP>='2022-01-01'
    and TX_STATUS='SUCCEEDED'
    and POOL_ID=704--wETH
    and CURRENCY='ibc/EA1D43981D5C9A1C4AAEA9C23BB1D4FA126BA9BC7020A25E0AE4AA841EA25DC5'
    group by 1,2
    Run a query to Download Data