ACTIVITY_WEEK | ACTIVITY_TYPE | TRANSACTION_COUNT | WEEKLY_TOTAL | PERCENTAGE_OF_WEEKLY | |
|---|---|---|---|---|---|
1 | 2025-03-03 00:00:00.000 | Card Mints | 2620534 | 3416190 | 76.71 |
2 | 2025-03-03 00:00:00.000 | Card Sales | 321466 | 3416190 | 9.41 |
3 | 2025-03-03 00:00:00.000 | Card Listings | 195777 | 3416190 | 5.73 |
4 | 2025-03-03 00:00:00.000 | Card Burns | 163041 | 3416190 | 4.77 |
5 | 2025-03-03 00:00:00.000 | Card Bid Cancelled | 57181 | 3416190 | 1.67 |
6 | 2025-03-03 00:00:00.000 | Owner Interaction | 19422 | 3416190 | 0.57 |
7 | 2025-03-03 00:00:00.000 | Special Card Burn | 13805 | 3416190 | 0.4 |
8 | 2025-03-03 00:00:00.000 | Accepted Card Bids | 13803 | 3416190 | 0.4 |
9 | 2025-03-03 00:00:00.000 | Card Upgrades | 11158 | 3416190 | 0.33 |
10 | 2025-03-03 00:00:00.000 | Other | 3 | 3416190 | 0 |
11 | 2025-02-24 00:00:00.000 | Card Mints | 5879372 | 6881449 | 85.44 |
12 | 2025-02-24 00:00:00.000 | Card Burns | 310944 | 6881449 | 4.52 |
13 | 2025-02-24 00:00:00.000 | Card Sales | 310092 | 6881449 | 4.51 |
14 | 2025-02-24 00:00:00.000 | Card Listings | 257675 | 6881449 | 3.74 |
15 | 2025-02-24 00:00:00.000 | Card Bid Cancelled | 78816 | 6881449 | 1.15 |
16 | 2025-02-24 00:00:00.000 | Owner Interaction | 22794 | 6881449 | 0.33 |
17 | 2025-02-24 00:00:00.000 | Accepted Card Bids | 14924 | 6881449 | 0.22 |
18 | 2025-02-24 00:00:00.000 | Card Upgrades | 6825 | 6881449 | 0.1 |
19 | 2025-02-24 00:00:00.000 | Other | 7 | 6881449 | 0 |
20 | 2025-02-17 00:00:00.000 | Card Mints | 3040793 | 3430414 | 88.64 |
permaryfun-moccasin
Updated 2025-03-08
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,
DATE_TRUNC('week', block_timestamp) AS activity_week,
COUNT(*) AS transaction_count
FROM monad.testnet.fact_event_logs
WHERE topic_0 IN (
'0x7a7be958aedb09208ae6ed49fc0841ccb7f951498c9afc1c2bfa4abbd0e3ff82',
'0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
)
AND contract_address IN (
LOWER('0x9077D31A794D81c21b0650974d5F581F4000CD1a'),
LOWER('0x04edB399CC24a95672BF9B880EE550dE0b2D0B1e')
)
GROUP BY DATE_TRUNC('week', block_timestamp)
UNION ALL
-- Sales Transactions (excluding special burns)
SELECT
'Card Sales' AS activity_type,
DATE_TRUNC('week', block_timestamp) AS activity_week,
COUNT(*) AS transaction_count
FROM monad.testnet.fact_event_logs
WHERE topic_0 IN (
'0x1c00f7c02cc752f52ca92cf2b6897abad5e66fa9a43920cad9e44f5ccb4a8a4e',
'0xb197f0b7d29f585d30223a9c287a1309a7c3371a57036eb30995ae25ba906dae',
'0xd650132a7cad9fe7456a6d9bde31152a79c0f8e136974063a84e045a2cdb7842'
)
AND contract_address IN (LOWER('0xfA4D5a9ceA2822BA08d0266F121011aC527ced64'))
-- Exclude transactions from the special burn address
AND origin_from_address != LOWER('0x366694cdef0A8c55b60e2cB28AaF6C2c1958313a')
GROUP BY DATE_TRUNC('week', block_timestamp)
UNION ALL
Last run: about 2 months ago
39
2KB
24s