pimi1356-HdnUm3Pool #833
Updated 2022-12-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with pricee as (
select
DATE_TRUNC('day', recorded_at) as day,
address as address,
symbol as symbol,
avg (price) as USDPrice
from osmosis.core.dim_prices a join osmosis.core.dim_labels b on a.symbol = b.project_name
where symbol NOT in ('IOV')
group by 1,2,3
union all
select DATE_TRUNC('day', recorded_at) as day,
'ibc/D176154B0C63D1F9C6DCFB4F70349EBF2E2B5A87A05902F57A6AE92B863E9AEC' as address,
'stOSMO' as symbol,
avg (price) as USDPrice
from osmosis.core.dim_prices a join osmosis.core.dim_labels b on a.symbol = b.project_name where symbol = 'OSMO'
and symbol NOT in ('IOV')
group by 1,2,3),
newLPer as (
select
liquidity_provider_address as New_LP_provider,
min (block_timestamp) as mindate
from osmosis.core.fact_liquidity_provider_actions
where tx_status = 'SUCCEEDED'
and pool_id = [833]
and action = 'pool_joined'
group by 1)
select
case when block_timestamp < '2022-11-11' then 'Before Pool Of The Week day'
when block_timestamp >= '2022-11-11' then 'After Pool Of The Week day'
end as span,
count (distinct tx_id) as TX,
Run a query to Download Data