TIME | Volume | Comultive volume | Traded beta pass NFTs | Deals (txs) | Floor price | Avg price | Record price | |
|---|---|---|---|---|---|---|---|---|
1 | 2025-02-26 00:00:00.000 | 2861.9234 | 73186.3465037 | 339 | 327 | 0.001 | 8.752059327 | 49.99 |
2 | 2025-02-28 00:00:00.000 | 1451.423 | 76116.6022047 | 194 | 184 | 2 | 7.888168478 | 85.44 |
3 | 2025-02-22 00:00:00.000 | 8930.5672 | 8930.5672 | 415 | 376 | 0.0002 | 23.751508511 | 642.5 |
4 | 2025-03-01 00:00:00.000 | 1282.699 | 77399.3012047 | 156 | 156 | 4 | 8.222429487 | 11 |
5 | 2025-02-24 00:00:00.000 | 27116.1107777 | 65520.8199317 | 1391 | 1338 | 0.000001 | 20.266151553 | 230.75 |
6 | 2025-02-23 00:00:00.000 | 29474.141954 | 38404.709154 | 1967 | 1829 | 0.0001 | 16.114894453 | 827.8 |
7 | 2025-02-27 00:00:00.000 | 1478.832701 | 74665.1792047 | 204 | 199 | 0.0016 | 7.431320106 | 27.7 |
8 | 2025-02-25 00:00:00.000 | 4803.603172 | 70324.4231037 | 512 | 474 | 0.0001 | 10.134183907 | 100.1 |
Hessishkintsu - pass 2
Updated 2025-02-27
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 trfs_direct as (SELECT
BLOCK_TIMESTAMP as TIMEx,
ORIGIN_FROM_ADDRESS as buyer,
'0x'||SUBSTRING( TOPICS[2], 27) as seller,
CAST(ethereum.public.udf_hex_to_int( data) AS NUMERIC) AS traded_nfts,
tx_hash as tx
from monad.testnet.fact_event_logs
where --Tx_hash = '0xa63d2c298430b4210fcc207919d92087935f5767f5a2ab7c31677cf3d1550521' and
CONTRACT_ADDRESS = '0x51e6da0e284609cd96e3134b12e94b4c4f0ca241' and
TOPICS[0] = '0xc3d58168c5ae7397731d063d5bbf3d657854427343f4c083240f7aacaa2d0f62'
and TOPICS[1] = '0x000000000000000000000000fbf166299d3c012de9efec0240d12756c1f4c0fc'),
trfs_offers as (SELECT
BLOCK_TIMESTAMP as timex,
'0x'||SUBSTRING( TOPICS[3], 27) as buyer,
TOPICS[3] as buyer_raw,
'0x'||SUBSTRING( TOPICS[2], 27) as seller,
CAST(ethereum.public.udf_hex_to_int( data) AS NUMERIC) AS traded_nfts,
tx_hash as tx
from monad.testnet.fact_event_logs
where --Tx_hash = '0x4d0a70e1cbcd782624479fb99ba9b8fcda8ca95fb3dff7d99a2a5e88a146adef' and
CONTRACT_ADDRESS = '0x51e6da0e284609cd96e3134b12e94b4c4f0ca241' and
TOPICS[0] = '0xc3d58168c5ae7397731d063d5bbf3d657854427343f4c083240f7aacaa2d0f62'
and TOPICS[1] = '0x0000000000000000000000000000000000000068f116a894984e2db1123eb395'),
trades as (select value as volume,
buyer,
tx,
sum(traded_nfts) as nfts,
TIMEx
from trfs_direct
join monad.testnet.fact_traces
on tx_hash = tx and buyer = FROM_ADDRESS
and TO_ADDRESS = '0x0000000000000068f116a894984e2db1123eb395'
Last run: 19 days ago
8
681B
24s