flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
Identify any noticeable patterns in transaction fees based on the time of day or day of the week in March 2024
gigiokoba
Identify any noticeable patterns in transaction fees based on the time of day or day of the week in March 2024
Updated 2024-04-04
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
›
⌄
SELECT
EXTRACT
(
HOUR
FROM
BLOCK_TIMESTAMP
)
AS
hour_of_day
,
AVG
(
FEE
)
AS
average_fee
FROM
bitcoin
.
core
.
fact_transactions
WHERE
EXTRACT
(
MONTH
FROM
BLOCK_TIMESTAMP
)
=
3
AND
EXTRACT
(
YEAR
FROM
BLOCK_TIMESTAMP
)
=
2024
GROUP
BY
hour_of_day
ORDER
BY
hour_of_day
;
Results
QueryRunArchived: QueryRun has been archived