OWNER | CLONE | Total Staked | Total Unstaked | REMAINING | |
|---|---|---|---|---|---|
1 | 0x287bdf8c332d44bb015f8b4deb6513010c951f39 | 0x934087489393ed93c606dd19ad7fe26a383a5274 | 0.01 | 0 | 0.01 |
2 | 0x5fd016aea1b79d18f4eff802cc588516d3de4fdb | 0x44aa67ae416dc8c0c68af127f5dff46e99dca84f | 0.007 | 0 | 0.007 |
3 | 0x5198fb2c7a6764bb464d1829e185ffe63d90d7e7 | 0x245d3e59b115060c4f9e1c4f3b8ec5a927a0c20e | 0.002 | 0.001 | 0.001 |
4 | 0x87ea8ae579ab007d46e66b3bd2bd045ea9cc30c1 | 0x9ca36979695eb3de13b437e0173375e3517a129a | 0.0008 | 0 | 0.0008 |
5 | 0xeaa2fb4b28bd37202ab1eb648b1c8d18b9943ae3 | 0x1724745b716912b480322dd9a3c17b10e1111a13 | 0.0001 | 0 | 0.0001 |
6 | 0x6aa80fdfe7b9bfdcdf5c7a1ffd778a85d956258c | 0xc7f882178251ce8c72bfc89470058cba74d4f9c2 | 0.00005 | 0 | 0.00005 |
7 | 0x752579c6cb68f413eaa193478d984ef84773fd76 | 0xc82e5813d3c6a3ecdedb4925a64705f5db8dd884 | 0 | 0 | 0 |
8 | 0x40c8ab6362ec57cf24ff003f0a0cd77080873edb | 0xbcce7a41764d2d0aebb7929d88d5a24e3d57dfbd | 0.0001 | 0.0001 | 0 |
9 | 0x001198a08def2498cebe678b88b0529e5f91dac1 | 0xd2cd75a5c937fa17982f237070bcda27c564281a | 0.085 | 0.085 | 0 |
10 | 0x5695422463d39ad9e6b944261e4a585becfd9423 | 0x7379b216c3b794daa1ec4b74979717572acb2760 | 0 | 0 | 0 |
11 | 0xca959b7ba660d6039567cfce445199b1fe94cba2 | 0x7eab8b31789a22bb4bd0cd60c5aea853e9c546a6 | 0 | 0 | 0 |
12 | 0xb4f2babfac3f4bd287fee8bc416c7ffd91a38525 | 0x0afb6624ba66e4e75fb20e30df10b1dda4299fa2 | 0.052 | 0.052 | 0 |
13 | 0x6c55ec503404ac44479bad77d52daba95ffc9191 | 0x41616d175ee2d95676ee40efced58c2b4fcbfd8a | 0.06 | 0.06 | 0 |
14 | 0x3d97aa9290e30edabbdbd72f96c1d52e814e13d2 | 0x9921c62c7cde3923292dd180947eb7c1ab756f5e | 0.01 | 0.01 | 0 |
15 | 0xdba9648ff976995bd31d9ee9a76d2a95813d6b6b | 0xf31baa04008af200e93e281a542913284c4bd5ac | 0 | 0 | 0 |
16 | 0xab769309ebceeda984e666ab727b36211ba02a8a | 0x51820925358b7923782d9853fe46ca0997baa12a | 0 | 0 | 0 |
17 | 0x21b71b39c08b2c0c86bcfc9d90539c9a7d733feb | 0xc9d0d51c99aa7f8f0c447fdbb9ba1ceeb2db3bc7 | 0.1 | 0.1 | 0 |
18 | 0x4764e2d1f34406cbfcbb91759103db97d8327e36 | 0x39ae535d7876dad7bb1001de3bebce4fc59552cb | 1.5 | 1.5 | 0 |
19 | 0xefb564f5623978f68ff3546b0769ed564a9058ec | 0x955afc74967eda8dcfcb194ded1e8143153540a3 | 0 | 0 | 0 |
20 | 0xe19843e8ec8ee6922731801cba48e2de6813963a | 0x8fd49226cb93c0788ef251347f007a2935108577 | 0 | 0 | 0 |
PXU TeamVOXGameStakingClones
Updated 2025-04-01
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
›
⌄
with clones AS (
(
SELECT
ORIGIN_FROM_ADDRESS AS owner,
CONCAT('0x', SUBSTRING(TOPICS [2], 27)) AS clone
from
blast.core.fact_event_logs
WHERE
CONTRACT_ADDRESS = '0x8546795c2d8149a4d2b178ab6290dad9c6c580fb'
AND ORIGIN_FUNCTION_SIGNATURE = '0xe4de98b5'
AND TX_STATUS = 'SUCCESS'
AND length(TOPICS) > 208
ORDER BY
BLOCK_TIMESTAMP ASC
)
),
totalStaked AS (
(
SELECT
TO_ADDRESS AS clone,
SUM(VALUE) AS totalStaked
FROM
blast.core.fact_transactions
WHERE
TO_ADDRESS IN(
SELECT
clone
FROM
clones
)
AND ORIGIN_FUNCTION_SIGNATURE = '0x3a4b66f1'
AND STATUS = 'SUCCESS'
GROUP BY
TO_ADDRESS
)
),
Last run: 24 days ago
78
8KB
8s