MLDZMNaur-user2
Updated 2023-04-26
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
›
⌄
with t1 AS (
SELECT
block_timestamp,
tx_hash,
tx_signer
from near.core.fact_transactions
where tx_status = 'Success'
and tx_receiver = 'aurora'
and tx_signer <> 'aurora'
)
SELECT
CASE
WHEN EXTRACT(DOW FROM block_timestamp) = 0 THEN 'Sunday'
WHEN EXTRACT(DOW FROM block_timestamp) = 1 THEN 'Monday'
WHEN EXTRACT(DOW FROM block_timestamp) = 2 THEN 'Tuesday'
WHEN EXTRACT(DOW FROM block_timestamp) = 3 THEN 'Wednesday'
WHEN EXTRACT(DOW FROM block_timestamp) = 4 THEN 'Thursday'
WHEN EXTRACT(DOW FROM block_timestamp) = 5 THEN 'Friday'
WHEN EXTRACT(DOW FROM block_timestamp) = 6 THEN 'Saturday'
END AS "Day",
DATE_PART(hour, block_timestamp) AS "Hour",
count(distinct tx_hash) as no_txn,
count(distinct tx_signer) as no_stakers
FROM t1
group by 1,2 having "Day" is not null
Run a query to Download Data