sunslingerfynn
Updated 2021-06-22
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
›
⌄
WITH balance AS (
SELECT
date,
address,
sum (balance_usd) as total_balance
FROM terra.daily_balances
WHERE date > getdate() - interval'2 weeks'
GROUP BY 1,2
),
address_class as(
SELECT
date,
address,
CASE
WHEN total_balance >= 100000 THEN 'Whale'
ELSE 'Smaller Wallet'
END AS address_tag,
total_balance
FROM balance
-- ORDER BY total_balance DESC
)
select
date_trunc('day', s.block_timestamp) as date,
a.address_tag,
count(s.tx_id) as tx_count,
count(distinct s.trader) as trader_count,
tx_count/trader_count as av_trades
from terra.swaps s left join address_class a on (s.trader = a.address)
where s.trader in (select address from balance) and date_trunc('day', s.block_timestamp) > getdate() - interval'2 weeks'
group by 1,2
order by 1
Run a query to Download Data