i_dan2024-05-30 01:26 AM
Updated 2024-05-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
WITH Daily_Costs AS (
SELECT
DATE_TRUNC('day', block_timestamp_hour) AS day,
SUM(total_fees_usd) AS total_fees_sum,
COUNT(*) AS transaction_count
FROM
aptos.stats.ez_core_metrics_hourly
WHERE
block_timestamp_hour >= '2023-01-10' -- Filter starting from May 10, 2024
GROUP BY
day
)
SELECT
AVG(total_fees_sum / transaction_count) AS avg_cost_per_transaction
FROM
Daily_Costs
QueryRunArchived: QueryRun has been archived