ACTIVITY_TYPE | TOTAL_TRANSACTIONS | TOTAL_TX_FEE_USED | TOTAL_CUMULATIVE_GAS_USED | |
---|---|---|---|---|
1 | shortBTC market activity | 1 | 0.02107118 | 6774881 |
2 | stakedETH market activity | 1 | 0.02026275 | 31821946 |
3 | longBTC market activity | 4 | 0.063935098 | 25374876 |
4 | CVE interaction activity | 3 | 0.24518755 | 57589834 |
5 | Uncategorized | 63 | 1.43524666 | 1168276044 |
realistcurvance activity guage
Updated 2025-07-11Copy Reference Fork
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 categorized_transactions AS (
SELECT
from_address,
to_address,
origin_function_signature,
COUNT(*) AS transaction_count,
SUM(tx_fee_precise) AS total_tx_fee_used,
SUM(cumulative_gas_used) AS total_cumulative_gas_used,
CASE
WHEN to_address = '0x2555223a15a931a71951707cb32a541f14e2c730'
AND origin_function_signature = '0xbe0cdee6' THEN 'CVE interaction activity'
WHEN to_address = '0xe6db1fb846a59e0780124b659358b6d2ccb45a81'
AND origin_function_signature = '0xe8bbf5d7' THEN 'stakedETH market activity'
WHEN to_address = '0x9e7ebd0f8255f3a910bc77fd006a410e9d54ee36'
AND origin_function_signature = '0xe8bbf5d7' THEN 'shortBTC market activity'
WHEN to_address = '0xcda16e9c25f429f4b01a87ff302ee7943f2d5015'
AND origin_function_signature = '0xe8bbf5d7' THEN 'longBTC market activity'
ELSE 'Uncategorized'
END AS activity_type
FROM
monad.testnet.fact_transactions
WHERE
from_address = lower('{{Address}}') --lower ('{0x8b4f8DF21c989d5FDa5a24B7cdDf501A095D6aB8}')
GROUP BY
from_address,
to_address,
origin_function_signature
)
SELECT
activity_type,
SUM(transaction_count) AS total_transactions,
SUM(total_tx_fee_used) AS total_tx_fee_used,
SUM(total_cumulative_gas_used) AS total_cumulative_gas_used
FROM
categorized_transactions
GROUP BY
Last run: 2 months ago
5
248B
163s