nitsUntitled Query
Updated 2022-12-08
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 pricet as (
select recorded_at::date as day,
address,
symbol,
avg (price) as USDPrice
from osmosis.core.dim_prices t1 join osmosis.core.dim_labels t2 on t1.symbol = t2.project_name
where symbol != 'IOV'
group by 1,2,3
union all
select recorded_at::date as day,
'ibc/D176154B0C63D1F9C6DCFB4F70349EBF2E2B5A87A05902F57A6AE92B863E9AEC' as address1,
'stOSMO' as symbol1,
avg (price) as USDPrice
from osmosis.core.dim_prices t1 join osmosis.core.dim_labels t2 on t1.symbol = t2.project_name
where symbol = 'OSMO'
group by 1,2,3)
,
newtable as (
select liquidity_provider_address as New_LPer,
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 * from newtable LIMIT 100
-- select block_Timestamp::date as date,
-- case when date < '2022-11-11' then 'Before Being Chosen as Pool Of The Week'
-- when date >= '2022-11-11' then 'After Being Chosen as Pool Of The Week'
-- end as timespan,
-- action,
Run a query to Download Data