Hour | Day Name | TX_COUNT | |
|---|---|---|---|
1 | 0 | 1 - Mon | 2799086 |
2 | 0 | 2 - Tue | 2537665 |
3 | 0 | 3 - Wed | 2693263 |
4 | 0 | 4 - Thu | 2763594 |
5 | 0 | 5 - Fri | 2614849 |
6 | 0 | 6 - Sat | 2734001 |
7 | 0 | 7 - Sun | 2814152 |
8 | 1 | 1 - Mon | 3270219 |
9 | 1 | 2 - Tue | 3495236 |
10 | 1 | 3 - Wed | 3220017 |
11 | 1 | 4 - Thu | 3390159 |
12 | 1 | 5 - Fri | 3212030 |
13 | 1 | 6 - Sat | 3298956 |
14 | 1 | 7 - Sun | 3492341 |
15 | 2 | 1 - Mon | 798580 |
16 | 2 | 2 - Tue | 982142 |
17 | 2 | 3 - Wed | 939720 |
18 | 2 | 4 - Thu | 882957 |
19 | 2 | 5 - Fri | 1231959 |
20 | 2 | 6 - Sat | 1052516 |
elsinaTime Pattern
Updated 8 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
›
⌄
with base as (
SELECT
e.block_timestamp,
e.origin_from_address,
e.tx_hash,
tx_fee,
from
ronin.core.fact_event_logs e
left join ronin.core.fact_transactions t on e.tx_hash = t.tx_hash
where
e.tx_succeeded = TRUE
and origin_to_address in (
'0xb806028b6ebc35926442770a8a8a7aeab6e2ce5c',
'0x02790f32ad7e7eaaecfb0ad21950829932f1a2ee',
'0x7eae20d11ef8c779433eb24503def900b9d28ad7',
'0x1b918543b518e34902e1e8dd76052bee43c762ff'
)
)
SELECT
date_part('hour', block_timestamp) as "Hour",
case when dayofweek(block_timestamp)=0 then 7 else dayofweek(block_timestamp) end||' - '||dayname(block_timestamp) as "Day Name",
COUNT(DISTINCT tx_hash) AS tx_count
FROM base
GROUP BY 1, 2
ORDER BY 1,2 asc
Last run: 8 days ago
...
168
3KB
28s