pimi1356-HdnUm3 Pool #634 - wETH.grv / OSMO
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/65381C5F3FD21442283D56925E62EA524DED8B6927F0FF94E21E0020954C40B5' as address1,
'WETH.grv' as symbol1,
avg (price) as USDPrice
from osmosis.core.dim_prices
where symbol = 'WETH'
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 = [634]
and action = 'pool_joined'
group by 1)
select DATE_TRUNC('day', block_timestamp) AS date,
case when date < '2022-11-29' then 'Before Pool Of The Week day'
when date >= '2022-11-29' then 'After Pool Of The Week day'
end as span,
action as ACTION,
Run a query to Download Data