DATE | GAS_FEE_APT | NUM_TRANSACTIONS | |
|---|---|---|---|
1 | 2025-03-15 00:00:00.000 | 0.00019339 | 3952920 |
2 | 2025-03-16 00:00:00.000 | 0.00013374 | 3930643 |
3 | 2025-03-17 00:00:00.000 | 0.00012662 | 4425663 |
4 | 2025-03-18 00:00:00.000 | 0.00016707 | 4259818 |
5 | 2025-03-19 00:00:00.000 | 0.00017713 | 4001135 |
6 | 2025-03-20 00:00:00.000 | 0.00022933 | 3932327 |
7 | 2025-03-21 00:00:00.000 | 0.00021289 | 3922924 |
8 | 2025-03-22 00:00:00.000 | 0.00018898 | 3857536 |
9 | 2025-03-23 00:00:00.000 | 0.00016042 | 3571148 |
10 | 2025-03-24 00:00:00.000 | 0.00019381 | 4159316 |
11 | 2025-03-25 00:00:00.000 | 0.0001972 | 3850296 |
12 | 2025-03-26 00:00:00.000 | 0.00017782 | 4622519 |
13 | 2025-03-27 00:00:00.000 | 0.00023349 | 4511877 |
14 | 2025-03-28 00:00:00.000 | 0.00022869 | 4371726 |
15 | 2025-03-29 00:00:00.000 | 0.00020618 | 4095727 |
16 | 2025-03-30 00:00:00.000 | 0.00029263 | 4255503 |
17 | 2025-03-31 00:00:00.000 | 0.00026156 | 4197005 |
18 | 2025-04-01 00:00:00.000 | 0.00023811 | 4076892 |
19 | 2025-04-02 00:00:00.000 | 0.00017657 | 3908406 |
20 | 2025-04-03 00:00:00.000 | 0.00019945 | 4332637 |
aureasarsanedesaptos gas 1.2
Updated 12 hours ago
9
1
2
3
4
5
6
7
8
›
⌄
SELECT
DATE_TRUNC('day', block_timestamp) AS date,
ROUND(avg(gas_used * gas_unit_price / POW(10, 8)), 8) AS gas_fee_apt,
COUNT(*) AS num_transactions
FROM aptos.core.fact_transactions
WHERE block_timestamp >= CURRENT_DATE - INTERVAL '{{days}} days'
GROUP BY 1
ORDER BY 1 asc
Last run: about 12 hours ago
31
1KB
12s