mattkstewHumans on Solana 4
Updated 2022-06-19Copy 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 tab1 as (
select
date_trunc('day', block_timestamp),
tx_from,
count(*) as count1
from solana.core.fact_transfers
group by 1, 2 )
, tab3_2 as (
select
date_trunc('day', block_timestamp),
tx_from as from_addy,
count(*) as count1
from solana.core.fact_transfers
where block_timestamp > current_date - 60
group by 1, 2
)
, tab2 as (
select
tx_from as addy,
max(count1)
from tab1
where tx_from in (select from_addy from tab3_2)
group by 1
having max(count1) < 201
order by 2 DESC )
select
date_trunc('day', block_timestamp) ,
CASE
when mint like 'So11111111111111111111111111111111111111112' then 'SOL'
when mint like 'kinXdEcpDQeHPEuQnqmUgtYykqKGVFq6CeVX5iAHJq6' then 'KIN'
Run a query to Download Data