Hadisehnon-lp holder
Updated 2022-07-13
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 t1 as ( select LIQUIDITY_PROVIDER_ADDRESS
from osmosis.core.fact_liquidity_provider_actions
where currency = 'uosmo' and block_timestamp::date >= CURRENT_DATE - 90),
ts as ( select DISTINCT TX_CALLER_ADDRESS
from osmosis.core.fact_staking
where action = 'delegate' and blockchain = 'osmosis' and TX_STATUS = 'SUCCEEDED'),
t2 as ( select trunc(block_timestamp,'day') as day ,
sum(to_amount/pow(10,to_decimal)) as amount,
count(DISTINCT tx_id) as transactions ,
count(DISTINCT trader) as traders
from osmosis.core.fact_swaps
where trader in (select receiver
from osmosis.core.fact_transfers where currency = 'uosmo' and block_timestamp::date >= CURRENT_DATE - 90) and block_timestamp::date >= CURRENT_DATE - 90
and trader not in ( select LIQUIDITY_PROVIDER_ADDRESS from t1 ) and trader not in ( select TX_CALLER_ADDRESS from ts)
group by 1),
t3 as ( select trunc(block_timestamp,'day') as day ,
sum(to_amount/pow(10,to_decimal)) as amount,
count(DISTINCT tx_id) as transactions ,
count(DISTINCT trader) as traders
from osmosis.core.fact_swaps
where trader in (select LIQUIDITY_PROVIDER_ADDRESS from t1 where block_timestamp::date >= CURRENT_DATE - 90) and
trader not in ( select TX_CALLER_ADDRESS from ts) and block_timestamp::date >= CURRENT_DATE - 90
group by 1),
t4 as ( select trunc(block_timestamp,'day') as day ,
sum(to_amount/pow(10,to_decimal)) as amount,
count(DISTINCT tx_id) as transactions ,
count(DISTINCT trader) as traders
from osmosis.core.fact_swaps
where trader in (select TX_CALLER_ADDRESS from ts) and trader not in (select LIQUIDITY_PROVIDER_ADDRESS from t1) and
block_timestamp::date >= CURRENT_DATE - 90
group by 1)
Run a query to Download Data