CyberaResearch$ME Total
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
35
36
›
⌄
-- 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
-- Forked from Masi / Total: @ https://flipsidecrypto.xyz/Masi/q/z9zWArY947il/total
WITH tb1 AS (
SELECT
TRUNC(block_timestamp, 'hour') AS hourly,
tx_to AS user,
SUM(amount) AS me_amounts
FROM
solana.core.fact_transfers
WHERE
tx_from IN (
'132m2hj64RBJ915YrhiyDCSheBNqcBHS9Dm6tkQvHADZ',
'9kV4XM3TNaQNUNGAkb9Ms8co4CZgn6Ltqv167BmEvc3a',
'FZvzAQ3tq8j74WaRG67en4RfxaGQwrY454cBvyuCGVBD',
'DuR7d8fcNUaWsxR5zw1CS4HqCxkwGfM8jsgE3VK4jqC3',
'9UrAzvvgpppHW3S1c5Qz4jyvFN8A4i2S1qQGdqTtE7iy',
'5V8TmAxrfRHNZUm2NGdaaBUc4Vk5MVrB5GX5Hqt5qMzY',
'6XMokydBgv2NjNHP2dUYH4EgifkUcSa8RVUgLfc332Yc',
'2MfLKDwsc495RTiyUmVaczqGhK8Tr3kcxFN5XBGStQWZ',
'5au9iSGNum7GgXj14YkQW4vhNQCpq4tFR5g6XMYthdEb',
'Cb6V1GFutegfWABr2n8c9VTgeL8MFsepgoQJCiSnLU5o',
'AUSsvcxdN3qxe9Z5YJBxwTqmDf7fQxnXDyy9xKkxPa1p',
'6AtEjaCbwAVk4rtFmNUBqqJ4BytjnSrDWM8WqanFKwXK',
'EgMf9XzMSYdywhp58ZgU964386DZP8tAwzWrg4regPuo',
'DyE7sAZjkmj5XGaSrge5FUehPUXcHKx1FifpjrPsVMK3'
)
AND mint = 'MEFNBXixkEbait3xn9bkm8WsJzXtVsaJEn4c8Sam21u'
AND block_timestamp::date >= '2023-11-20'
GROUP BY
1, 2
)
SELECT
QueryRunArchived: QueryRun has been archived