MoeCopy of osmfp-LP-in
Updated 2023-05-24
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
›
⌄
with scr_prices as (select
date(recorded_at) as days,
avg(price) as price,
sum(VOLUME_24H) as vol
from
osmosis.core.dim_prices
where
symbol in ('ARB' )
group by 1
order by 1)
select
pool_id,
count (distinct tx_id) as txs,
count (distinct LIQUIDITY_PROVIDER_ADDRESS) as LPers,
sum (AMOUNT/1e18) as native_volume,
sum ((AMOUNT/1e18)*price) as USD_Volume,
'Deposit' as type
from osmosis.core.fact_liquidity_provider_actions sw
inner join scr_prices pr on sw.block_timestamp::date = pr.days
where
currency = 'ibc/10E5E5B06D78FFBB61FD9F89209DEE5FD4446ED0550CBB8E3747DA79E10D9DC6'
-- and
-- block_timestamp >= CURRENT_DATE - 7
and
ACTION = 'pool_joined'
group by 1 order by 2 desc limit 10
Run a query to Download Data