ACTIVITY | TOTAL_EVENTS | |
---|---|---|
1 | Card Upgrades | 14789 |
2 | Card Burns | 4737 |
3 | Bids Accepted | 36516 |
4 | Total Listings | 514653 |
5 | Total Cancelled Listings | 155661 |
6 | Card Mints | 749102 |
7 | Cards bought | 1249788 |
8 | Other | 11661801 |
permaryTransaction Activity Breakdown
Updated 2025-03-07
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
›
⌄
SELECT
'Card Upgrades' AS activity, COUNT(*) AS total_events
FROM monad.testnet.fact_event_logs
WHERE topic_0 = LOWER('0xb896ef750ff1f78e491078417b01c8e59749b5eaa5d5531af12b01c7571a7f06')
AND contract_address = LOWER('0x9077D31A794D81c21b0650974d5F581F4000CD1a')
UNION ALL
SELECT
'Card Burns' AS activity, COUNT(*) AS total_events
FROM monad.testnet.fact_event_logs
WHERE origin_function_signature = '0x7bad2380'
AND contract_address = LOWER('0x9077D31A794D81c21b0650974d5F581F4000CD1a')
UNION ALL
SELECT
'Bids Accepted' AS activity, COUNT(*) AS total_events
FROM monad.testnet.fact_event_logs
WHERE topic_0 = '0xd787cf372c9f960b5be92b833473c375b88b8ed771eb0430c148dd0d5394ae49'
AND contract_address = LOWER('0xfA4D5a9ceA2822BA08d0266F121011aC527ced64')
UNION ALL
SELECT
'Total Listings' AS activity, COUNT(*)
FROM monad.testnet.fact_event_logs
WHERE topic_0 = '0x17307eab39ab6107e8899845ad3d59bd9653f200f220920489ca2b5937696c31'
AND contract_address = LOWER('0x04edB399CC24a95672BF9B880EE550dE0b2D0B1e')
UNION ALL
SELECT
'Total Cancelled Listings' AS activity, COUNT(*)
FROM monad.testnet.fact_event_logs
Last run: about 2 months ago
8
197B
10s