WALLET | ATLAS | |
---|---|---|
1 | HajLgwYKTvxuJVg8GhWhx1GkeqQ4P3wWk9SHbZJPvJnh | 20540431.89 |
2 | 7szk9kq77N8qj6M1wVgTWLHz1ijZ6ar2tDF8w4mXUM48 | 16873069.6 |
3 | E9XsGpXLHw6NyA6jraFdzLHWksDCBV6X1b3nrnRYg7AN | 11600395.51 |
4 | 6LVuNtS4BHc5bdXr6V5v1fFUyRnWwYPF4bDABoh3evrt | 9727033.26 |
5 | H7C39WVE2teJgDwj8xsCW2XZGFnreRdp7njY3SzDkr7G | 8312817.87 |
6 | 8fvJhm5p7QQFLRofFHeT1bjNDa8FppZZwLkb6MR257Cp | 8225539.57 |
7 | DoM5yS39H8Vam3FnWMgAJGRfxByqXv5rB9PmGSC5iVfr | 7420149.68 |
8 | HFb6x3wLLp9CrJP9eGgvi9TBnJkqkKGoDeGP61b1EHUD | 6960403.72 |
9 | ESrRf8M6G5gV5xAEHmEeUPBffzXXxU4fb9Hq5iY4ZNC9 | 6467558.68 |
10 | G29mGtMUX2WqJ5zqjfUHBxqFZDWWG4bW9SM86tKrgGCw | 5297237.03 |
11 | FK2nVHmxSNGY6DSoohurCPABeyK5teH6pnfysnYdh1dQ | 4948432.47 |
12 | BcNjxc5BJG6NS5wfa6NnkvEo5qU8D8YZzTA4Y4NU9WG3 | 4463198.27 |
13 | 5pTZytiQTSedoWMUD4XGQkbM3RqkJWCkWShsApNUW7ex | 3924840.02 |
14 | 6bQFKL5AAY6xYPSbajfxa9c88jqPBfh7w4MwisFrdrp1 | 3622068.84 |
15 | AM6vdxe2PDjNWBWyGFd3p3h2yXxb5UnHvQiyahcijcyC | 3551770.37 |
16 | 4BD3wry4uzBbqBc6Fok1pM3YPASyakvMtbzG4ueijnHs | 3060221.43 |
17 | 7Z74tABrm7ob2RqXVj399nKijaWh8nFs4Vd9gUJJ9kwg | 2965135.56 |
18 | HoJEaf2b6i7aRrswA3BHXDpVDZ2eDUcKqpQXNXUSFSAx | 2951441.86 |
19 | DtuhBQ6eZ8p2jGBKHWW5VUmcco5rg66E3iWA4bF56wDW | 2948467.37 |
20 | 7edjdvKdivY18HpYkSic2mMcvwqeGw2ni19GYXhyi3nn | 2902873.44 |
ludicrousCrafting fee total USE
Updated 8 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- forked from Crafting fee USE @ https://flipsidecrypto.xyz/studio/queries/a82e0c66-232c-45ef-9e7c-8d8438107943
SELECT
CASE when signers[0] = 'FEEPAYye6DtaJhSXFR65ENXMroiseL1jqYT4QxHKRoZr'
then signers[1] else signers[0] end AS WALLET
,ROUND(zeroifnull(sum(CASE when value:parsed:info:destination = '5XJei3jBZi8WuqDGUQ5KCe8t72vMRMTWLr6ok3hhXE2R'
AND value:parsed:type = 'transfer'
then value:parsed:info:amount / POW(10,8)
end)),2) AS ATLAS
FROM solana.core.fact_events, lateral flatten(input => inner_instruction:instructions)
WHERE program_id IN ('SAGE2HAwep459SNq61LHvjxPk4pLPEJLoMETef7f7EE')
AND block_timestamp > '2024-04-01' AND block_timestamp < '2025-05-01'
AND wallet != 'FEEPAYye6DtaJhSXFR65ENXMroiseL1jqYT4QxHKRoZr'
GROUP BY 1
ORDER BY 2 DESC
Last run: 8 days ago
...
14090
725KB
195s