Moespf 7
Updated 2022-12-21Copy Reference Fork
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 pools as
(SELECT
column1 as pool_id , column2 as pool_name from (values
( '1' , 'ATOM/OSMO')
,( '678', 'USDC/OSMO')
,( '704', 'WETH/OSMO')
,( '712', 'WBTC/OSMO')
,( '674', 'DAI/OSMO')
,( '722', 'EVMOS/OSMO')
,( '9', 'CRO/OSMO')
,( '604', 'STARS/OSMO')
,( '497', 'JUNO/OSMO')
,( '812', 'AXL/OSMO')
,( '584', 'SCRT/OSMO')
,( '3', 'AKT/OSMO')
,( '481', 'EEUR/OSMO')
,( '42', 'REGEN/OSMO')
,( '463', 'NGM/OSMO')
,( '5', 'XPRT/OSMO')))
,raw as (select
pool_id, concat('#' , pool_id , ' (',pool_name,')') as pool,
sum( AMOUNT/1e18) as del_amount,
count (distinct DELEGATOR_ADDRESS) as DELEGATORs,
count (distinct VALIDATOR_ADDRESS) as VALIDATORs,
del_amount/DELEGATORs as osmo_per_delegator,
del_amount/VALIDATORs as osmo_per_VALIDATOR,
del_amount/count (distinct block_timestamp::date) as osmo_per_day,
DELEGATORs/count (distinct block_timestamp::date) as DELEGATORs_per_day,
VALIDATORs/count (distinct block_timestamp::date) as VALIDATORs_per_day,
row_number()over(order by del_amount) as n
from osmosis.core.fact_superfluid_staking s , pools p
where action = 'delegate'
and split(CURRENCY,'/')[2] = pool_id
Run a query to Download Data