freemartianBase Criteria - kimia
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
22
23
24
25
26
27
28
›
⌄
with delegators as (
select delegator_address, sum (event_amount) as amount, date_trunc('day', block_timestamp) as date
from terra.staking
group by delegator_address, date
),
Fdelefators as(
select delegator_address
from delegators
WHERE amount > 1
),
traders as (
select trader, count (tx_id) as count, date_trunc('day', block_timestamp) as date
from terra.swaps
group by trader, date
),
ftraders as (
select trader
from traders
where count > 10
)
select count(delegator_address), date_trunc('day', block_timestamp) as date
from Fdelefators
inner join ftraders on Fdelefators.delegator_address = ftraders.trader
Run a query to Download Data