FANTASY_USERS | TOTAL_USERS | PERCENTAGE_USERS | FANTASY_TRANSACTIONS | TOTAL_TRANSACTIONS | PERCENTAGE_TRANSACTIONS | FANTASY_FEES | TOTAL_FEES | PERCENTAGE_FEES | |
|---|---|---|---|---|---|---|---|---|---|
1 | 682264 | 15399534 | 4.43 | 2497816 | 351518572 | 0.71 | 3527202.81593988 | 3156392.04614818 | 111.75 |
permaryComparisons
Updated 5 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 fantasy_users AS (
-- Count distinct users who interacted with Fantasy Card contracts
SELECT
COUNT(DISTINCT ft.from_address) AS fantasy_user_count
FROM monad.testnet.fact_event_logs fel
JOIN monad.testnet.fact_transactions ft
ON fel.tx_hash = ft.tx_hash
WHERE fel.contract_address IN (
LOWER('0x9077D31A794D81c21b0650974d5F581F4000CD1a'),
LOWER('0x04edB399CC24a95672BF9B880EE550dE0b2D0B1e'),
LOWER('0xfA4D5a9ceA2822BA08d0266F121011aC527ced64')
)
),
fantasy_transactions AS (
-- Total transactions from Fantasy Card contracts
SELECT
COUNT(DISTINCT ft.tx_hash) AS fantasy_count
FROM monad.testnet.fact_event_logs fel
JOIN monad.testnet.fact_transactions ft
ON fel.tx_hash = ft.tx_hash
WHERE fel.contract_address IN (
LOWER('0x9077D31A794D81c21b0650974d5F581F4000CD1a'),
LOWER('0x04edB399CC24a95672BF9B880EE550dE0b2D0B1e'),
LOWER('0xfA4D5a9ceA2822BA08d0266F121011aC527ced64')
)
),
fantasy_fees AS (
-- Total transaction fees from Fantasy Card transactions
SELECT
SUM(ft.tx_fee) AS fantasy_fee_total
FROM monad.testnet.fact_event_logs fel
JOIN monad.testnet.fact_transactions ft
ON fel.tx_hash = ft.tx_hash
WHERE fel.contract_address IN (
LOWER('0x9077D31A794D81c21b0650974d5F581F4000CD1a'),
LOWER('0x04edB399CC24a95672BF9B880EE550dE0b2D0B1e'),
Last run: 5 days ago
1
88B
84s