Delamir-6014osm01 3 th week -day of week in
Updated 2022-12-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
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