Holder | Balance at Timestamp | |
|---|---|---|
1 | 0x07aabd925866e8353407e67c1d157836f7ad923e | 29,075.95 |
2 | 0x15935ec6176290369194c9d73cb82c2f2400f8a7 | 14,398.46 |
3 | 0x13ffeeb209e7adc70e550508ed4bd09bf79108d3 | 2,482.90 |
4 | 0xf30ed549df7f78c660b20c388712f295da5f257a | 2,238.35 |
5 | 0x6147aea777f72e5343ea1be54c3e8f5be193db6c | 1,581.54 |
6 | 0xad08506e384bd79e2a0f647c49d436f921483460 | 1,542.63 |
7 | 0x469381d77b755e5b92246a29c9ab586d15b6ebc9 | 1,314.82 |
8 | 0x5096879b9c0422455387a3761b3d5ef07099d3b3 | 1,185.48 |
9 | 0x8a13e42c58b63f31fc26f51a978249fa2fa6a6dd | 1,092.36 |
10 | 0xcac4f9d03002e095df3cabfe625e93bbb7260363 | 1,075.89 |
11 | 0x5d84ea0c0f70911ccd81e7655734335e35479f7e | 1,032.82 |
12 | 0x2e4a1b39168da8a341e08c65cf8f27589c88e32c | 1,029.86 |
13 | 0x8bb49f464834009ed438a60c60d5999792e0f5f4 | 1,025.80 |
14 | 0x19bf4fe746c370e2930cd8c1b3dcfa55270c8ed7 | 1,024.00 |
15 | 0xcd1a849c64f52e852f508cebdceef642ec5d0330 | 1,020.20 |
16 | 0x47cddfbc26da2df3b10f360b32c52a33e309023d | 1,014.01 |
17 | 0x7fac5c5b7e6d24614d7db1489486142d680abbc8 | 1,009.48 |
18 | 0xc14bd232e92b6fe829bca575e69939644248d9e9 | 1,007.47 |
19 | 0x582e6caadf06d7b4ceda46d85215381dcf67361a | 1,006.51 |
20 | 0xe09227dda220efa85c96f9e4ab8fbd01859da708 | 1,001.57 |
bgbz-8j1pHvsMON holders at timestamp
Updated 9 days ago
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
›
⌄
WITH token_transfers AS (
SELECT
'0x' || SUBSTRING(TOPICS[1], 27) AS sender,
'0x' || SUBSTRING(TOPICS[2], 27) AS receiver,
CAST(ethereum.public.udf_hex_to_int(data) AS NUMERIC) / 1e18 AS amountx
FROM monad.testnet.fact_event_logs
WHERE
topics[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef' -- Transfer event topic
AND CONTRACT_ADDRESS = '0x07aabd925866e8353407e67c1d157836f7ad923e'
AND TX_SUCCEEDED = 'TRUE'
AND block_timestamp <= '{{timestamp}}'
),
balances AS (
SELECT
receiver AS holder,
SUM(amountx) AS balance
FROM token_transfers
GROUP BY receiver
UNION ALL
SELECT
sender AS holder,
-SUM(amountx) AS balance
FROM token_transfers
GROUP BY sender
)
SELECT
holder AS "Holder",
TO_VARCHAR(SUM(balance), '999,999,999,999.00') AS "Balance at Timestamp",
FROM balances
GROUP BY holder
HAVING SUM(balance) >= 0.01
ORDER BY SUM(balance) DESC;
Last run: 9 days ago
...
100000
7MB
15s