permaryunique 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
›
⌄
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
COUNT(DISTINCT claimer_wallet) AS unique_claimers,
COUNT(tx_id) AS total_claims,
SUM(amount) AS total_claimed_amount
FROM
claims
;
QueryRunArchived: QueryRun has been archived