Day of Week | Hour of Day | STPM | |
|---|---|---|---|
1 | 1 Monday | 23 | 0.0630774 |
2 | 1 Monday | 22 | 0.1076681 |
3 | 1 Monday | 21 | 0.1182853 |
4 | 1 Monday | 20 | 0.0620126 |
5 | 1 Monday | 19 | 0.0646303 |
6 | 1 Monday | 18 | 0.0573757 |
7 | 1 Monday | 17 | 0.0727321 |
8 | 1 Monday | 16 | 0.0843754 |
9 | 1 Monday | 15 | 0.0815033 |
10 | 1 Monday | 14 | 0.0989292 |
11 | 1 Monday | 13 | 0.0767278 |
12 | 1 Monday | 12 | 0.1446136 |
13 | 1 Monday | 11 | 0.0798726 |
14 | 1 Monday | 10 | 0.0617311 |
15 | 1 Monday | 9 | 0.0635861 |
16 | 1 Monday | 8 | 0.0626535 |
17 | 1 Monday | 7 | 0.0765381 |
18 | 1 Monday | 6 | 0.1187048 |
19 | 1 Monday | 5 | 0.0640048 |
20 | 1 Monday | 4 | 0.0552114 |
Lordking arbi copy
Updated 2024-05-06
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
›
⌄
WITH n_ as (
SELECT
dayofweek(block_timestamp) as "Day of Week"
, HOUR(block_timestamp) as "Hour of Day"
, avg(round(GAS_PRICE_paid,1)) as gas
from arbitrum.core.fact_transactions
where STATUS ='SUCCESS'
and block_timestamp::date > '{{From_date}}'
GROUP BY 1, 2
)
SELECT
CASE
WHEN "Day of Week" = 0 THEN '7 Sunday'
WHEN "Day of Week" = 1 THEN '1 Monday'
WHEN "Day of Week" = 2 THEN '2 Tuesday'
WHEN "Day of Week" = 3 THEN '3 Wednesday'
WHEN "Day of Week" = 4 THEN '4 Thursday'
WHEN "Day of Week" = 5 THEN '5 Friday'
WHEN "Day of Week" = 6 THEN '6 Saturday'
END as "Day of Week"
, "Hour of Day"
, gas as stpm
FROM n_
ORDER by 1, 2 desc
Last run: 11 days ago
...
168
4KB
94s