andurilsuccessive-fuchsia
Updated 2024-10-08
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
›
⌄
/*
1
11111111111111111111111111111111 663210
2
CoREENxT6tW1HoK8ypY1SxRMZTcVPm7R94rH4PZNhX7d 46623
3
675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8 42758
4
TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA 17300
with one_time_fee_payers as (
select
signers[0] as fee_payer,
count(tx_id) as txns
from
solana.core.fact_events
WHERE
date(block_timestamp) between '2024-09-01' and '2024-09-30'
and program_id = '11111111111111111111111111111111'
group by 1
having txns = 1
)
select * from one_time_fee_payers limit 1000
unique - tx_from = 81845732
unique - tx_to = 129312824
MINT
COUNT(DISTINCT TX_FROM)
1
So11111111111111111111111111111111111111111 82825369
2
So11111111111111111111111111111111111111112 6569482
QueryRunArchived: QueryRun has been archived