freemartianActive Monthly Wallets - kian
Updated 2022-05-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with delegators as (
select delegator_address, sum (event_amount) as amount, date_trunc('month', block_timestamp) as time
from terra.staking
group by delegator_address, time
),
traders as (
select trader, count (tx_id) as count, date_trunc('month', block_timestamp) as date
from terra.swaps
group by trader, date
)
select count(delegator_address), date
from delegators d
inner join traders t on d.delegator_address = t.trader
where d.amount > 1
and t.count > 10
group by date
Run a query to Download Data