ACTIVITY_TYPE | TRANSACTION_COUNT | TOTAL_TX_FEE | AVG_TX_FEE | MAX_TX_FEE | MIN_TX_FEE | PERCENTAGE_OF_TOTAL_FEES | |
|---|---|---|---|---|---|---|---|
1 | Card Mints | 2621993 | 53315.909516749 | 0.02033411589 | 6.212148644 | 0 | 63.366119006 |
2 | Card Sales | 626413 | 15287.694897764 | 0.0244051367 | 0.2307662985 | 0 | 18.16947142 |
3 | Owner Interaction | 163617 | 4505.258514057 | 0.02753539372 | 0.228252768 | 0 | 5.35451331 |
4 | Card Burns | 202809 | 4246.218784231 | 0.02093703329 | 6.212148644 | 0 | 5.046643811 |
5 | Special Card Burn | 94184 | 2425.1865 | 0.0257494532 | 0.02575 | 0 | 2.882341458 |
6 | Accepted Card Bids | 155724 | 1435.543374342 | 0.009218510791 | 0.011077547 | 0 | 1.706147623 |
7 | Card Listings | 807034 | 1315.109606093 | 0.001629559109 | 0.273 | 0 | 1.563011727 |
8 | Card Bid Cancelled | 448996 | 1180.186845111 | 0.002628501913 | 0.00328354 | 0 | 1.402655619 |
9 | Card Upgrades | 54839 | 428.133007415 | 0.00780708998 | 0.0081497205 | 0 | 0.5088373685 |
10 | Other | 15 | 0.2176318374 | 0.01450878916 | 0.152831277 | 0.003766975 | 0.0002586560941 |
permarytx_fee by activity
Updated 2025-04-05
999
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 activity_data AS (
-- Minting Transactions
SELECT
'Card Mints' AS activity_type,
tx_hash,
tx_fee
FROM monad.testnet.fact_transactions t
WHERE tx_hash IN (
SELECT tx_hash
FROM monad.testnet.fact_event_logs
WHERE topic_0 IN (
'0x7a7be958aedb09208ae6ed49fc0841ccb7f951498c9afc1c2bfa4abbd0e3ff82',
'0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
)
AND contract_address IN (
LOWER('0x9077D31A794D81c21b0650974d5F581F4000CD1a'),
LOWER('0x04edB399CC24a95672BF9B880EE550dE0b2D0B1e')
)
)
UNION ALL
-- Sales Transactions (excluding special burns)
SELECT
'Card Sales' AS activity_type,
tx_hash,
tx_fee
FROM monad.testnet.fact_transactions t
WHERE tx_hash IN (
SELECT tx_hash
FROM monad.testnet.fact_event_logs
WHERE topic_0 IN (
'0x1c00f7c02cc752f52ca92cf2b6897abad5e66fa9a43920cad9e44f5ccb4a8a4e',
'0xb197f0b7d29f585d30223a9c287a1309a7c3371a57036eb30995ae25ba906dae',
'0xd650132a7cad9fe7456a6d9bde31152a79c0f8e136974063a84e045a2cdb7842'
)
Last run: 2 months ago
10
798B
179s