Transaction Date | Daily Gas Used | Daily Avg. Running Total | |
|---|---|---|---|
1 | 2025-01-01 00:00:00.000 | 0.012 | 0.012 |
2 | 2025-01-02 00:00:00.000 | 0.0115 | 0.01175 |
3 | 2025-01-03 00:00:00.000 | 0.012 | 0.011833333333 |
4 | 2025-01-04 00:00:00.000 | 0.012 | 0.011875 |
5 | 2025-01-05 00:00:00.000 | 0.012 | 0.0119 |
6 | 2025-01-06 00:00:00.000 | 0.011 | 0.01175 |
7 | 2025-01-07 00:00:00.000 | 0.125 | 0.027928571429 |
8 | 2025-01-08 00:00:00.000 | 0.0169 | 0.02655 |
9 | 2025-01-09 00:00:00.000 | 0.012 | 0.024933333333 |
10 | 2025-01-10 00:00:00.000 | 0.012 | 0.02364 |
11 | 2025-01-11 00:00:00.000 | 0.012 | 0.022581818182 |
12 | 2025-01-12 00:00:00.000 | 0.012 | 0.0217 |
13 | 2025-01-13 00:00:00.000 | 0.012 | 0.020953846154 |
14 | 2025-01-14 00:00:00.000 | 0.0115 | 0.020278571429 |
15 | 2025-01-15 00:00:00.000 | 0.0098 | 0.01958 |
16 | 2025-01-16 00:00:00.000 | 0.0358 | 0.02059375 |
17 | 2025-01-17 00:00:00.000 | 0.012 | 0.020088235294 |
18 | 2025-01-18 00:00:00.000 | 0.012 | 0.019638888889 |
19 | 2025-01-19 00:00:00.000 | 0.011 | 0.019184210526 |
20 | 2025-01-20 00:00:00.000 | 0.012 | 0.018825 |
Kruys-Collins Daily and Running Average GAs Usage copy
Updated 2025-05-07
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
›
⌄
-- forked from Daily and Running Average GAs Usage @ https://flipsidecrypto.xyz/studio/queries/4120830a-778f-4b81-b8da-fc8399b73c84
WITH DailyGas AS (
SELECT
DATE(block_timestamp) AS transaction_date,
SUM(gas_used/1e6 * gas_unit_price) as gas_fee
FROM movement.core.fact_transactions
WHERE tx_type = 'user_transaction'
AND block_timestamp > '2025-01-01'
GROUP BY transaction_date
),
RunningCumulative AS (
SELECT
transaction_date,
gas_fee,
SUM(gas_fee) OVER (ORDER BY transaction_date) AS cumulative_gas_used
FROM DailyGas
)
SELECT
transaction_date as "Transaction Date",
gas_fee AS "Daily Gas Used",
cumulative_gas_used / ROW_NUMBER() OVER (ORDER BY transaction_date) AS "Daily Avg. Running Total"
FROM RunningCumulative
ORDER BY "Transaction Date";
Last run: 2 months ago
...
108
6KB
20s