tavoBlock Trends Analysis
Updated 2024-08-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
DATE_TRUNC('day', block_timestamp) AS date,
AVG(gas_used) AS avg_gas_used,
AVG(tx_count) AS avg_transactions_per_block,
AVG(difficulty) AS avg_difficulty
FROM
kaia.core.fact_blocks
WHERE
block_timestamp >= CURRENT_DATE - INTERVAL '2 months'
GROUP BY
DATE_TRUNC('day', block_timestamp)
ORDER BY
date DESC;
QueryRunArchived: QueryRun has been archived