Delamir-6014OSMO02 single side: amount and usd over time
Updated 2022-11-28
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 single as (
select
tx_id,
pool_id,
count (tx_id) as TXs_1
from osmosis.core.fact_liquidity_provider_actions
where action = 'pool_joined'
and TX_STATUS = 'SUCCEEDED'
group by 1,2
having count (tx_id)<2
)
, pair as (
select
tx_id,
pool_id,
count (tx_id) as TXs_2
from osmosis.core.fact_liquidity_provider_actions
where action = 'pool_joined'
and TX_STATUS = 'SUCCEEDED'
group by 1,2
having count (tx_id)>=2
)
, Price as (
select
date(RECORDED_AT) as date,
avg(price) as Price,
address,
symbol
from osmosis.core.dim_prices a
join osmosis.core.dim_labels b on a.symbol = b.PROJECT_NAME
where symbol != 'IOV'
group by 1,3,4
)
select
a.BLOCK_TIMESTAMP::date as datee,
Run a query to Download Data