SECTOR | AVG_GAS_FEE_APT | TOTAL_GAS_FEE_APT | |
|---|---|---|---|
1 | NFT | 0.001585859533 | 29.767708 |
2 | DeFi | 0.001444602064 | 1.259693 |
3 | token | 0.001241333333 | 0.014896 |
4 | dApps | 0.000811130147 | 23.895083 |
5 | DEX | 0.0002725146035 | 1565.21296914 |
6 | cex | 0.0002141059419 | 239.68903269 |
7 | Transfer | 0.0001768178239 | 4376.49010003 |
8 | Others | 0.0001732541375 | 9870.90066835 |
9 | chadmin | 0.0001145 | 0.000229 |
10 | Bridge | 0.000057975623 | 3.1291183 |
11 | operator | 0.00004905175983 | 0.023692 |
12 | games | 0.000024125 | 0.002123 |
aureasarsanedesaptos gas 2
Updated 2 days ago
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 all_categorized_txs AS (
-- DEX transactions
SELECT
tx_hash,
'DEX' as sector
FROM aptos.defi.ez_dex_swaps
WHERE block_timestamp >= CURRENT_DATE - INTERVAL '{{days}} days'
UNION ALL
-- Bridge transactions
SELECT
tx_hash,
'Bridge' as sector
FROM aptos.defi.ez_bridge_activity
WHERE block_timestamp >= CURRENT_DATE - INTERVAL '{{days}} days'
UNION ALL
-- Native Transfer transactions
SELECT
tx_hash,
'Transfer' as sector
FROM aptos.core.ez_native_transfers
WHERE block_timestamp >= CURRENT_DATE - INTERVAL '{{days}} days'
UNION ALL
-- NFT Mints
SELECT
tx_hash,
'NFT' as sector
FROM aptos.nft.ez_nft_mints
WHERE block_timestamp >= CURRENT_DATE - INTERVAL '{{days}} days'
UNION ALL
Last run: 2 days ago
12
432B
23s