TRANSACTION_DAY | DAILY_TRANSACTIONS | DAILY_FEES_IN_APT | DAILY_FEES_IN_USD | AVG_FEE_PER_TRANSACTION_IN_APT | AVG_FEE_PER_TRANSACTION_IN_USD | |
|---|---|---|---|---|---|---|
1 | 2025-05-01 00:00:00.000 | 3904385 | 415.910068 | 2272.082042312 | 0.000106523836 | 0.0005819308391 |
2 | 2025-05-02 00:00:00.000 | 3667592 | 350.705259 | 1920.403547407 | 0.000095622757 | 0.0005236142802 |
3 | 2025-05-03 00:00:00.000 | 3129522 | 165.42125 | 878.938241667 | 0.000052858312 | 0.0002808538311 |
4 | 2025-05-04 00:00:00.000 | 3327192 | 167.439055 | 862.380899523 | 0.000050324434 | 0.0002591918036 |
5 | 2025-05-05 00:00:00.000 | 3319816 | 177.955492 | 908.314490417 | 0.000053604023 | 0.0002736038674 |
6 | 2025-05-06 00:00:00.000 | 3452418 | 187.429208 | 901.53449048 | 0.000054289257 | 0.0002611313262 |
7 | 2025-05-07 00:00:00.000 | 3256336 | 168.971324 | 803.03621731 | 0.000051890015 | 0.0002466072963 |
8 | 2025-05-08 00:00:00.000 | 4072669 | 456.245064 | 2316.20410824 | 0.000112026061 | 0.0005687189697 |
9 | 2025-05-09 00:00:00.000 | 3857808 | 416.101244 | 2321.671566002 | 0.000107859501 | 0.0006018110741 |
10 | 2025-05-10 00:00:00.000 | 3796514 | 331.921016 | 1896.652005593 | 0.000087427839 | 0.0004995772434 |
11 | 2025-05-11 00:00:00.000 | 3918334 | 414.855212 | 2476.512759302 | 0.000105875408 | 0.000632032071 |
12 | 2025-05-12 00:00:00.000 | 1469721 | 194.338411 | 1154.953176573 | 0.000132228097 | 0.0007858315805 |
datavortexAptos
Updated 2025-05-12
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
29
30
31
32
33
34
35
36
›
⌄
WITH DailyFees AS (
SELECT
DATE_TRUNC('day', block_timestamp) AS transaction_day,
SUM((gas_used * gas_unit_price) / 1e8) AS daily_fees_in_apt,
COUNT(DISTINCT TX_HASH) AS daily_transactions
FROM aptos.core.fact_transactions
WHERE success = 'true'
AND block_timestamp >= DATE_TRUNC('month', CURRENT_DATE)
AND block_timestamp < DATE_TRUNC('month', CURRENT_DATE) + INTERVAL '1 MONTH'
GROUP BY transaction_day
),
APTPrice AS (
SELECT
DATE_TRUNC('day', hour) AS price_day,
avg(price) AS apt_price
FROM aptos.price.ez_prices_hourly
WHERE symbol = 'APT'
AND hour >= DATE_TRUNC('month', CURRENT_DATE)
AND hour < DATE_TRUNC('month', CURRENT_DATE) + INTERVAL '1 MONTH'
GROUP BY price_day
)
SELECT
df.transaction_day,
df.daily_transactions,
df.daily_fees_in_apt,
df.daily_fees_in_apt * ap.apt_price AS daily_fees_in_usd,
df.daily_fees_in_apt / df.daily_transactions AS avg_fee_per_transaction_in_apt,
(df.daily_fees_in_apt / df.daily_transactions) * ap.apt_price AS avg_fee_per_transaction_in_usd
FROM
DailyFees df
JOIN
APTPrice ap
ON
df.transaction_day = ap.price_day
ORDER BY
df.transaction_day;
Last run: 12 days ago
12
1KB
15s