HOUR | EVENT_NAME | PLAYERS | TRANSACTIONS | |
|---|---|---|---|---|
1 | 2025-03-24 17:00:00.000 | Cooked | 4 | 4 |
2 | 2025-03-24 17:00:00.000 | FishMintedBatch | 8 | 8 |
3 | 2025-03-24 17:00:00.000 | NFTStakedFish | 4 | 4 |
4 | 2025-03-24 17:00:00.000 | NFTStakedRod | 12 | 12 |
5 | 2025-03-24 17:00:00.000 | NFTUnstakedRod | 6 | 6 |
6 | 2025-03-24 17:00:00.000 | RodMintedBatch | 1 | 68 |
7 | 2025-03-24 16:00:00.000 | Cooked | 8 | 8 |
8 | 2025-03-24 16:00:00.000 | FishMintedBatch | 23 | 29 |
9 | 2025-03-24 16:00:00.000 | NFTStakedFish | 6 | 6 |
10 | 2025-03-24 16:00:00.000 | NFTStakedRod | 44 | 46 |
11 | 2025-03-24 16:00:00.000 | NFTUnstakedRod | 25 | 25 |
12 | 2025-03-24 16:00:00.000 | RodMintedBatch | 1 | 287 |
13 | 2025-03-24 15:00:00.000 | Cooked | 14 | 23 |
14 | 2025-03-24 15:00:00.000 | FishMintedBatch | 40 | 43 |
15 | 2025-03-24 15:00:00.000 | NFTStakedFish | 12 | 22 |
16 | 2025-03-24 15:00:00.000 | NFTStakedRod | 57 | 66 |
17 | 2025-03-24 15:00:00.000 | NFTUnstakedRod | 39 | 42 |
18 | 2025-03-24 15:00:00.000 | RodMintedBatch | 1 | 288 |
19 | 2025-03-24 14:00:00.000 | Cooked | 10 | 24 |
20 | 2025-03-24 14:00:00.000 | FishMintedBatch | 40 | 45 |
dannyamahWallets and tx by Event
Updated 2025-03-24
999
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 event_data AS (
-- OpenedChest events
SELECT
block_timestamp,
tx_hash,
event_name,
full_decoded_log:data[0]:value::VARCHAR AS wallet
FROM ronin.core.ez_decoded_event_logs
WHERE 1 = 1
AND full_decoded_log:data[0]:name = 'from'
AND event_name = 'OpenedChest'
AND contract_address = '0xc69f7434d4b336e68acbbde4101b7990e7d6b3b3'
AND tx_succeeded
AND block_timestamp >= '2025-03-21'
UNION ALL
-- NFTStakedRod events
SELECT
block_timestamp,
tx_hash,
event_name,
full_decoded_log:data[0]:value::VARCHAR AS wallet
FROM ronin.core.ez_decoded_event_logs
WHERE 1 = 1
AND full_decoded_log:data[0]:name = 'from'
AND event_name = 'NFTStakedRod'
AND contract_address = '0xc69f7434d4b336e68acbbde4101b7990e7d6b3b3'
AND tx_succeeded
AND block_timestamp >= '2025-03-21'
UNION ALL
-- NFTUnstakedRod events
SELECT
Last run: 3 months ago
...
631
30KB
3s