CyberaResearch$ME leaderboard
Updated 2024-12-12
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
›
⌄
-- For $testME claimers, you need all publicKeys of accounts with mint:"MEFNBXixkEbait3xn9bkm8WsJzXtVsaJEn4c8Sam21u" from program disGCfSiJKFigEphfou4PGHn1rukMfbs9cg9GpTM6oe. https://solscan.io/account/disGCfSiJKFigEphfou4PGHn1rukMfbs9cg9GpTM6oe?accountName=MerkleDistributor#accountsData
-- For non-$testME claimers need publicKey of accounts with mint:"MEFNBXixkEbait3xn9bkm8WsJzXtVsaJEn4c8Sam21u" from program veTbq5fF2HWYpgmkwjGKTYLVpY6miWYYmakML7R7LRf. https://solscan.io/account/veTbq5fF2HWYpgmkwjGKTYLVpY6miWYYmakML7R7LRf?accountName=DistributionClaim#accountsData
SELECT
tx_to AS claimer_address,
COUNT(*) AS number_of_claims,
TO_CHAR(SUM(amount), 'FM999,999,999,999') AS ME_claimed
--MIN(block_timestamp) AS first_claim_timestamp,
--MAX(block_timestamp) AS last_claim_timestamp
FROM
solana.core.fact_transfers
WHERE
mint = 'MEFNBXixkEbait3xn9bkm8WsJzXtVsaJEn4c8Sam21u'
AND tx_from IN (
'132m2hj64RBJ915YrhiyDCSheBNqcBHS9Dm6tkQvHADZ', -- non-$testME claimers
'9kV4XM3TNaQNUNGAkb9Ms8co4CZgn6Ltqv167BmEvc3a', -- non-$testME claimers
'FZvzAQ3tq8j74WaRG67en4RfxaGQwrY454cBvyuCGVBD', -- $testME claimers
'DuR7d8fcNUaWsxR5zw1CS4HqCxkwGfM8jsgE3VK4jqC3', -- $testME claimers
'9UrAzvvgpppHW3S1c5Qz4jyvFN8A4i2S1qQGdqTtE7iy', -- $testME claimers
'5V8TmAxrfRHNZUm2NGdaaBUc4Vk5MVrB5GX5Hqt5qMzY', -- $testME claimers
'6XMokydBgv2NjNHP2dUYH4EgifkUcSa8RVUgLfc332Yc', -- $testME claimers
'2MfLKDwsc495RTiyUmVaczqGhK8Tr3kcxFN5XBGStQWZ', -- $testME claimers
'5au9iSGNum7GgXj14YkQW4vhNQCpq4tFR5g6XMYthdEb', -- $testME claimers
'Cb6V1GFutegfWABr2n8c9VTgeL8MFsepgoQJCiSnLU5o', -- $testME claimers
'AUSsvcxdN3qxe9Z5YJBxwTqmDf7fQxnXDyy9xKkxPa1p', -- $testME claimers
'6AtEjaCbwAVk4rtFmNUBqqJ4BytjnSrDWM8WqanFKwXK', -- $testME claimers
'EgMf9XzMSYdywhp58ZgU964386DZP8tAwzWrg4regPuo', -- $testME claimers
'DyE7sAZjkmj5XGaSrge5FUehPUXcHKx1FifpjrPsVMK3' -- $testME claimers
)
GROUP BY
tx_to
ORDER BY
SUM(amount) DESC;
QueryRunArchived: QueryRun has been archived