permarytop claimers
Updated 2024-10-29
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
›
⌄
WITH claims AS (
SELECT
tx_id,
block_timestamp,
tx_to AS claimer_wallet,
amount
FROM
solana.core.fact_transfers
WHERE
tx_from = 'BaSyeVdcaKy3mx4qPv2tX25fFxKBq9g3iys2QwfhPsp7'
AND amount > 0
)
SELECT
claimer_wallet,
COUNT(tx_id) AS claim_count,
SUM(amount) AS total_claimed
FROM
claims
GROUP BY
claimer_wallet
ORDER BY
total_claimed DESC;
QueryRunArchived: QueryRun has been archived