SENDER_RECIPENT_GROUP | SENDERS | |
|---|---|---|
1 | d/ 10K-100K | 15 |
2 | f/ 1M+ | 4 |
3 | e/ 100K-1M | 8 |
4 | c/ 1K-10K | 4 |
Pine Analyticsv3 domain spammer (tx_lookup) copy copy copy
Updated 2025-04-24
999
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
›
⌄
-- forked from v3 domain spammer (tx_lookup) copy copy @ https://flipsidecrypto.xyz/studio/queries/7e7e049f-c39f-4da7-8677-a570b46030c4
with tab0 as (
select
tx_id,
count(distinct tx_to) as wallets_sent_to,
count(*) as transfer_events,
sum(amount) as total_sol_transfered,
max(amount) max_sol_amt
from solana.core.fact_transfers
where block_timestamp > current_date - interval '14 days'
and mint like 'So11111111111111111111111111111111111111111'
group by 1
having max_sol_amt < 0.000005
), tab00 as (
select
distinct tx_id
from solana.core.fact_transfers
where block_timestamp > current_date - interval '14 days'
and not mint like 'So11111111111111111111111111111111111111111'
), tab1 as (
select
tx_from,
count(distinct tx_to) as wallets_sent_to,
count(distinct tx_id) as transaction_sent,
count(*) as transfer_events,
sum(amount) as total_sol_transfered,
count(distinct tx_id) * 0.000005 as min_gas_fees_sol
from solana.core.fact_transfers
where block_timestamp > current_date - interval '14 days'
and mint like 'So11111111111111111111111111111111111111111'
and tx_id in (select tx_id from tab0)
and not tx_id in (select tx_id from tab00)
Last run: about 2 months ago
4
66B
264s