No Data to Display
Monad Metrics Guildnfts_nadscope
Updated 2025-03-18
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
›
⌄
-- select limited_cyan from unlimited_cyan
-- select array_size(regexp_substr_all('0000000000000000000000000000000000000000000000000000000000000029', '0'))
-- select
-- origin_from_address
-- , origin_to_address
-- , topics
-- , regexp_substr_all(substr(data, 3), '.{64}') as segmented
-- from monad.testnet.fact_event_logs
-- where 1=1
-- and tx_hash = '0xd8a5c29b8fb89b931f467b9fa57cea6a3992362d13ed2f67ff8cf182da66f8d0'
-- and contract_address = '0x0000000000000068f116a894984e2db1123eb395'
with magic_eden_table as (
select
regexp_substr_all(substr(data, 3), '.{64}') as segments
, case
when substr(segments[6], 25) = '760afe86e5de5fa0ee542fc7b7b713e1c5425701'
then concat('0x', substr(segments[1], 25))
else concat('0x', substr(segments[14], 25))
end as seller
, case
when substr(segments[6], 25) = '760afe86e5de5fa0ee542fc7b7b713e1c5425701'
then concat('0x', substr(segments[14], 25))
else concat('0x', substr(segments[1], 25))
end as buyer
, case
when substr(segments[6], 25) = '760afe86e5de5fa0ee542fc7b7b713e1c5425701'
then concat('0x', substr(segments[11], 25))
else concat('0x', substr(segments[6], 25))
end as collection
, case
when substr(segments[6], 25) = '760afe86e5de5fa0ee542fc7b7b713e1c5425701'
then
case
Last run: 24 days ago
0
2B
12s