DATE | SECTOR | DAILY_TRANSACTIONS | AVG_GAS_FEE_APT | TOTAL_GAS_FEE_APT | |
|---|---|---|---|---|---|
1 | 2025-04-25 00:00:00.000 | Bridge | 108 | 0.00009096666667 | 0.0098244 |
2 | 2025-04-25 00:00:00.000 | DEX | 43445 | 0.0002841931668 | 17.80185997 |
3 | 2025-04-25 00:00:00.000 | NFT | 28 | 0.0003777294118 | 0.064214 |
4 | 2025-04-25 00:00:00.000 | Others | 1069634 | 0.000215098237 | 142.49053654 |
5 | 2025-04-25 00:00:00.000 | Transfer | 213260 | 0.000128540542 | 29.54350109 |
6 | 2025-04-25 00:00:00.000 | cex | 9269 | 0.0002071767429 | 1.92032123 |
7 | 2025-04-25 00:00:00.000 | dApps | 278 | 0.0006436690647 | 0.17894 |
8 | 2025-04-25 00:00:00.000 | operator | 8 | 0.000182 | 0.001456 |
9 | 2025-04-24 00:00:00.000 | Bridge | 479 | 0.00008966931106 | 0.0429516 |
10 | 2025-04-24 00:00:00.000 | DEX | 153246 | 0.0002470406887 | 49.48768485 |
11 | 2025-04-24 00:00:00.000 | DeFi | 92 | 0.0009109673913 | 0.083809 |
12 | 2025-04-24 00:00:00.000 | NFT | 236 | 0.0006508815029 | 0.3378075 |
13 | 2025-04-24 00:00:00.000 | Others | 2912707 | 0.0001359805656 | 214.54510515 |
14 | 2025-04-24 00:00:00.000 | Transfer | 583972 | 0.0001518754325 | 96.84822956 |
15 | 2025-04-24 00:00:00.000 | cex | 44201 | 0.0002272557248 | 10.04493029 |
16 | 2025-04-24 00:00:00.000 | dApps | 801 | 0.0008633121099 | 0.691513 |
17 | 2025-04-24 00:00:00.000 | operator | 15 | 0.00007666666667 | 0.00115 |
18 | 2025-04-23 00:00:00.000 | Bridge | 447 | 0.0001046729306 | 0.0467888 |
19 | 2025-04-23 00:00:00.000 | DEX | 161005 | 0.0002574844194 | 51.84809262 |
20 | 2025-04-23 00:00:00.000 | DeFi | 9 | 0.00004733333333 | 0.000426 |
aureasarsanedesaptos gas 2.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,
DATE_TRUNC('day', block_timestamp) as date
FROM aptos.defi.ez_dex_swaps
WHERE block_timestamp >= CURRENT_DATE - INTERVAL '{{days}} days'
UNION ALL
-- Bridge transactions
SELECT
tx_hash,
'Bridge' as sector,
DATE_TRUNC('day', block_timestamp) as date
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,
DATE_TRUNC('day', block_timestamp) as date
FROM aptos.core.ez_native_transfers
WHERE block_timestamp >= CURRENT_DATE - INTERVAL '{{days}} days'
UNION ALL
-- NFT Mints
SELECT
tx_hash,
'NFT' as sector,
DATE_TRUNC('day', block_timestamp) as date
Last run: 2 days ago
...
274
18KB
24s