jhonpa40MockUSDC Claimed Per Wallet
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
›
⌄
with mock_usdc_claims as (
SELECT
TX_ID
from
solana.core.fact_events
where
succeeded
and block_timestamp >= '2024-01-01'
and program_id = 'airAGpcuhdRWpR9mqtBhmHk1bxsshEgG8ACC7nN5BY8'
),
claims_as_transfers as (
SELECT
*
from
solana.core.fact_transfers
where
block_timestamp >= '2024-01-01'
and mint = 'UxxvnMnUGoXJig9wc8phE1mYJZMFq3hpfr259zMWcq4'
and TX_ID IN (
SELECT
TX_ID
FROM
mock_usdc_claims
)
)
select
tx_to as wallet_address,
count(*) as nr_claims,
sum(amount) as total_claimed_from_faucet
from
claims_as_transfers
group by tx_to
order by total_claimed_from_faucet