DATE | TOTAL_TRANSACTIONS | BUY_VOLUME | SELL_VOLUME | |
|---|---|---|---|---|
1 | 2025-02-03 00:00:00.000 | 4 | 1.1211 | -0.99 |
2 | 2025-02-05 00:00:00.000 | 8 | 4.3531 | -0.495 |
3 | 2025-02-06 00:00:00.000 | 1 | 0 | -3.169816696 |
4 | 2025-02-09 00:00:00.000 | 21 | 4.99041 | -5.4549 |
5 | 2025-02-10 00:00:00.000 | 46 | 10.9585 | -4.689104442 |
6 | 2025-02-11 00:00:00.000 | 61 | 98.19523 | -157.338256286 |
7 | 2025-02-12 00:00:00.000 | 25 | 16.15 | -77.335103629 |
8 | 2025-02-13 00:00:00.000 | 7 | 33.522 | -21.625058771 |
9 | 2025-02-14 00:00:00.000 | 6 | 4.141 | -0.5063021298 |
10 | 2025-02-15 00:00:00.000 | 13 | 9.322401 | -1.2078 |
11 | 2025-02-16 00:00:00.000 | 18 | 43.0432 | -1.683500467 |
12 | 2025-02-17 00:00:00.000 | 5 | 0.9292 | 0 |
13 | 2025-02-18 00:00:00.000 | 52 | 15.72671 | -11.969167429 |
14 | 2025-02-19 00:00:00.000 | 617 | 264.062697331 | -76.976202065 |
15 | 2025-02-20 00:00:00.000 | 50715 | 451917.206465468 | -443130.732796653 |
16 | 2025-02-21 00:00:00.000 | 62206 | 765553.480201538 | -765219.369357114 |
17 | 2025-02-22 00:00:00.000 | 16167 | 168997.811109484 | -172734.372084012 |
18 | 2025-02-23 00:00:00.000 | 72060 | 168606.743047871 | -167915.577660369 |
19 | 2025-02-24 00:00:00.000 | 51548 | 96181.280028197 | -95366.173095801 |
20 | 2025-02-25 00:00:00.000 | 70454 | 106442.118353341 | -108344.99354714 |
Monad Metrics GuildVolume on Nad.Fun
Updated 2025-03-15
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 raw AS (
SELECT
block_timestamp,
tx_hash,
topic_1,
topic_3,
regexp_substr_all(SUBSTR(data, 3), '.{64}') AS segmented
FROM monad.testnet.fact_event_logs
WHERE contract_address = '0x60216fb3285595f4643f9f7cddab842e799bd642'
AND topic_0 = '0x962c5f466b5c14a23d5aa7d7f1cd96153b1fd74124062d77ef00352a9812daf5'
),
almost AS (
SELECT
block_timestamp,
tx_hash,
segmented,
'0x' || SUBSTR(topic_1, 27) AS creator,
DATEDIFF('day', block_timestamp, CURRENT_DATE()) AS created_interval,
'0x' || SUBSTR(topic_3, 27) AS Token_address,
CASE
WHEN livequery.utils.udf_hex_to_int(segmented[9]) <= POWER(10, 38) THEN livequery.utils.udf_hex_to_int(segmented[9]) * 2
ELSE NULL
END AS array_two,
CASE
WHEN livequery.utils.udf_hex_to_int(segmented[11]) <= POWER(10, 38) THEN livequery.utils.udf_hex_to_int(segmented[11]) * 2
ELSE NULL
END AS array_three
FROM raw
),
names AS (
SELECT
block_timestamp,
tx_hash,
created_interval,
Last run: 1 day ago
62
4KB
311s