GAME_HOUR | GAMES_PER_HOUR | MOVING_AVERAGE | KILLED_BY_IDLE_COUNT | |
|---|---|---|---|---|
1 | 2024-01-31 09:00:00.000 | 246 | 246 | 106 |
2 | 2024-01-31 10:00:00.000 | 242 | 244 | 33 |
3 | 2024-01-31 11:00:00.000 | 227 | 238.333 | 4 |
4 | 2024-01-31 12:00:00.000 | 212 | 227 | 83 |
5 | 2024-01-31 13:00:00.000 | 211 | 216.666 | 2 |
6 | 2024-01-31 14:00:00.000 | 194 | 205.666 | 3 |
7 | 2024-01-31 15:00:00.000 | 123 | 176 | 1 |
8 | 2024-01-31 16:00:00.000 | 117 | 144.666 | 3 |
9 | 2024-01-31 17:00:00.000 | 144 | 128 | 1 |
10 | 2024-01-31 18:00:00.000 | 123 | 128 | 1 |
11 | 2024-01-31 19:00:00.000 | 128 | 131.666 | 1 |
12 | 2024-01-31 20:00:00.000 | 124 | 125 | 1 |
13 | 2024-01-31 21:00:00.000 | 42 | 98 | 0 |
frontboatIdle death counter with hiurly game counter
Updated 2024-01-31
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 base_data AS (
SELECT
de.EVENT_ID,
de.TIMESTAMP,
f.value as death_detail
FROM
external.tokenflow_starknet.decoded_events de,
LATERAL FLATTEN(input => de.PARAMETERS) f
WHERE
de.CHAIN_ID = 'testnet'
AND de.NAME = 'AdventurerDied'
AND de.CONTRACT IN ('0x071d07b1217cdcc334739a3f28da75db05d62672ad04b9204ee11b88f2f9f61c')
),
flattened_parameters AS (
SELECT
bd.EVENT_ID,
bd.TIMESTAMP,
fp.value:name as detail_name,
fp.value:value as detail_value
FROM
base_data bd,
LATERAL FLATTEN(input => bd.death_detail:value) fp
),
killed_by_idle_events AS (
SELECT
EVENT_ID,
TIMESTAMP
FROM
flattened_parameters
WHERE
detail_name IN ('killed_by_beast', 'killed_by_obstacle')
AND detail_value = '0'
GROUP BY
EVENT_ID, TIMESTAMP
HAVING
COUNT(DISTINCT detail_name) = 2
Last run: about 1 year ago
13
517B
2s