eferPunks
Updated 2023-04-13
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 BALANCES AS (
SELECT
BLOCK_NUMBER, USER_ADDRESS, CURRENT_BAL_UNADJ
FROM
ethereum.core.ez_balance_deltas
WHERE
CONTRACT_ADDRESS = '0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb'
), LAST_SNAPSHOT AS (
SELECT
TB1.USER_ADDRESS AS HOLDER,
TB1.CURRENT_BAL_UNADJ AS PUNKS
FROM
BALANCES TB1
LEFT OUTER JOIN BALANCES TB2
ON (
TB1.USER_ADDRESS = TB2.USER_ADDRESS
AND
TB1.BLOCK_NUMBER < TB2.BLOCK_NUMBER
)
WHERE
TB2.USER_ADDRESS IS NULL
AND
PUNKS!=0
ORDER BY
PUNKS DESC
)
SELECT
TB2.ADDRESS_NAME,
TB1.HOLDER AS ADDRESS,
CONCAT(LEFT(TB1.HOLDER, 6), '***', RIGHT(TB1.HOLDER, 4)) AS HOLDER,
TB1.PUNKS
FROM
LAST_SNAPSHOT TB1
LEFT JOIN (
Run a query to Download Data