Delamir-6014osm01 3 th week -day of week in
    Updated 2022-12-04
    with pool_1 as (
    select
    dayname(to_date(block_timestamp::date)) as Day_of_week,
    tx_id,
    pool_id,
    count (tx_id) as TXs_1Week
    from osmosis.core.fact_liquidity_provider_actions
    where POOL_ID = '840'
    and action = 'pool_joined'
    and BLOCK_TIMESTAMP::date > '2022-11-21' and BLOCK_TIMESTAMP::date < '2022-11-29'
    and TX_STATUS = 'SUCCEEDED'
    group by 1,2,3
    )

    select
    Day_of_week,
    count(distinct b.tx_id) as TXs,
    count(distinct liquidity_provider_address) as Providers
    from osmosis.core.fact_liquidity_provider_actions a
    join pool_1 b on a.tx_id = b.Tx_id
    group by 1
    Run a query to Download Data