BLOCK_TIMESTAMP | TOKEN_ID | SALE_PRICE | SELLER | BUYER | EFFECTIVE_EARNING | TX_HASH | |
|---|---|---|---|---|---|---|---|
1 | 2025-04-03 11:13:20.000 | 7136 | 1.95 | 0x2bbc234a09e578375b47a190249cbe694bf32d19 | 0x5077adafe953b7a98463f11ba5b524889ccae55e | 1.755 | 0x72e54bd7d7aa1a7e76496e61946a3003c49875ff14082343767e3402383f0274 |
2 | 2025-04-03 11:09:38.000 | 7277 | 3 | 0x218a42065f3b08e5a9f6ba276423f388d4fee4f3 | 0xfcf36bec411e10f150b66eaa728e2185c8c15891 | 2.7 | 0xb27072174a4fee4b0293407a82c2d72ea9de36dac77ce15d301679c4f3a63b9d |
3 | 2025-04-03 11:07:56.000 | 7278 | 3 | 0x218a42065f3b08e5a9f6ba276423f388d4fee4f3 | 0x6a4f7384a96afba0ad8df79c8803bcb85c906ca3 | 2.7 | 0x2fd856446a7b4140bd82e3e8f135dd662db1f2ffea5de7f2bd1f860d399f205b |
4 | 2025-04-03 11:04:26.000 | 6787 | 3 | 0xa420a551f6833347c5111e555a8a65c3334588ee | 0x2174a530145f863ddd010437e84241058e653478 | 2.7 | 0x37f31c5a775a596bca664ac8402d65d524e749adae984f82d868ad02553cbc92 |
5 | 2025-04-03 11:00:41.000 | 7273 | 5 | 0x3b83600679a2e9c984883f32d3305b4c47dcc149 | 0x2174a530145f863ddd010437e84241058e653478 | 4.5 | 0x515e544cadf2039681e68b85a046c23fbee312b27f91d0c7c3c43f58af8b085e |
6 | 2025-04-03 10:55:50.000 | 7292 | 6 | 0x3b83600679a2e9c984883f32d3305b4c47dcc149 | 0x7d3006183a9e44fdb8caf688fdb9290850b9fa62 | 5.4 | 0x8f52520996f00982a5ef83f60c08e2d76e04ab70b0d9e32f8a8a5943a0f153f4 |
7 | 2025-04-03 10:53:53.000 | 6869 | 3 | 0x989244e4d15bafacbc78a87128876ae9041006b8 | 0x2174a530145f863ddd010437e84241058e653478 | 2.7 | 0x660a4fa0373eb3e4702c8830c45c0f833bc0c90a4051806558845ff60ac878d7 |
8 | 2025-04-03 10:53:17.000 | 7100 | 35 | 0xbf433f0ec58295bebe7df8f0798e5c95e1603ede | 0x2bc256c5dfc2031b32e069b2eb13cf6c4d7ba43c | 31.5 | 0x2413b218699e3b63ce612134023ecffed5b5e645c8d6161f60cbddb43c5ed567 |
9 | 2025-04-03 10:49:26.000 | 6562 | 50 | 0x8f7282fe799c0fc44d09d06a1456b70f08344279 | 0x2bc256c5dfc2031b32e069b2eb13cf6c4d7ba43c | 45 | 0x5d17e04b042438d77d8f61eb98aeaa915aee2a8df2afb7e43d2c7b8c67a9626e |
10 | 2025-04-03 10:48:41.000 | 4854 | 3 | 0xf62b3071f0107f6f3ff4f643de03fb2fd401086e | 0x0287825755f5e98849f8611f023e4b4459714503 | 2.7 | 0xff302b204b8d2064a8fbeebc055f0707731713cc06c277cb2e3f624a52b74722 |
11 | 2025-04-03 10:48:26.000 | 7072 | 5 | 0xe7973c18b3f64f95feca42d493d626558b713209 | 0x689115fe4f0a320a05beda8a57ed22ed54692470 | 4.5 | 0xc651c98d8c822744891bf6bdda1b94a2a6604adaf2110b6b59fb2018d5f45ea1 |
12 | 2025-04-03 10:47:44.000 | 7281 | 5 | 0x3b83600679a2e9c984883f32d3305b4c47dcc149 | 0x83625f96d84bdae5665b1add91e711db63a388e9 | 4.5 | 0xd97ff055c544c21be4a32a0c740a04158bbabb3925c7a9fea9bb12d4a458ba88 |
13 | 2025-04-03 10:47:23.000 | 7146 | 10 | 0x9eb888e16a8467472fd1a0c3acdd32fdb05ca811 | 0x5f751dc6b22945e5eb4e437dd69bd623ed540842 | 9 | 0x60fe8136e97918b723887fa25f9207e6a68539ce527851b4fc441863be8fc119 |
14 | 2025-04-03 10:47:08.000 | 6934 | 8 | 0xf67464bec00e9b2c314c97b3c0aac7adfcecb005 | 0x2bc256c5dfc2031b32e069b2eb13cf6c4d7ba43c | 7.2 | 0x818e2ac5678ba4f020d4bb85b73945416dfa04e63f3360e38b018d7f6c677ea2 |
15 | 2025-04-03 10:45:38.000 | 7331 | 10 | 0x4178ecc93391f9de0325b70cb6094d1ddb2d9c8b | 0x2bc256c5dfc2031b32e069b2eb13cf6c4d7ba43c | 9 | 0xac130e209e8adae35cb76aed1f2db5f07b9ea8f8971d5b5fb62a49c7ff65732d |
16 | 2025-04-03 10:45:17.000 | 7300 | 5.99 | 0xef8a862993180f2e207cc803bd97385f9783d3b1 | 0x3e081c575ffa6e5a22f5e3e1d28df268efb2bb0a | 5.391 | 0xde19288ff585e76ab6f044f95402a4e85cdd9d17378233485a7f264ede8e09b0 |
17 | 2025-04-03 10:44:35.000 | 7161 | 8 | 0xbc87cfd6c017905bd47e5ad7e6ce2f99cc5bead3 | 0x2bc256c5dfc2031b32e069b2eb13cf6c4d7ba43c | 7.2 | 0x578defb4afc614ae3ae5bc037dfb702d2a90d6187aecb07d61d5baa9020545a9 |
18 | 2025-04-03 10:44:20.000 | 6348 | 3 | 0x459d489d91eec1cb329962dd0e96307b55acd3a1 | 0x0bdd7dfef04cd26cc86cc30a5c68ef282de38fd9 | 2.7 | 0x61a0d51b9a3fa4dba2091c43fed41a77b12302512f06968b4053103c9f4d42db |
19 | 2025-04-03 10:43:05.000 | 6390 | 5 | 0xe72c379659bf238e7b7da5ad9e3035b5bd4db0bf | 0x2bc256c5dfc2031b32e069b2eb13cf6c4d7ba43c | 4.5 | 0xb59abf25dce163cd6ae71b5a495b43f50f8c39c9b04731fb2d45428f31b5f6f8 |
20 | 2025-04-03 10:33:47.000 | 6734 | 19 | 0x09766c482a6119a564b10d6048076e81a59426df | 0x5188bf4c747fcdfdd7736d772aa42e3d2f9ece98 | 17.1 | 0x4e988dfcfce148ee0c2090c24a1d05037ac8ea880d9cd062735d01e8e692b6fb |
LittlerDataronin ragnarok landverse genesis marketplace all nft sales
Updated 23 hours 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 marketplace_sales as (
select
tx_hash
,block_timestamp
,decoded_log:matcher::STRING AS buyer
,decoded_log:order[0][0]::STRING AS seller
,decoded_log:order[0][1]::NUMBER AS order_kind
,decoded_log:order[0][2][0][1]::STRING AS nft_address
,decoded_log:order[0][2][0][2]::NUMBER AS token_id
,decoded_log:order[0][2][0][3]::NUMBER AS token_quantity
,decoded_log:order[0][3]::NUMBER AS order_expiredAt
,decoded_log:order[0][4]::STRING AS order_paymentToken
,decoded_log:order[0][6]::NUMBER / 1e6 AS sale_price
,decoded_log:order[0][12]::BOOLEAN AS order_verified
,decoded_log:order[3]::STRING AS order_recipient
,decoded_log:order[4]::STRING AS order_refunder
,decoded_log:receivedAllocs[1][1]::STRING AS receivedAllocs_recipient2 -- no idea who
,decoded_log:receivedAllocs[1][3]::NUMBER / 1e2 AS receivedAllocs_ratio2
,decoded_log:receivedAllocs[1][4]::NUMBER / 1e6 AS receivedAllocs_amount2
,decoded_log:receivedAllocs[2][1]::STRING AS receivedAllocs_recipient3 --axie community treasury no idea why is here but it doesn't get anything
,decoded_log:receivedAllocs[2][3]::NUMBER / 1e2 AS receivedAllocs_ratio3
,decoded_log:receivedAllocs[2][4]::NUMBER / 1e6 AS receivedAllocs_amount3
,decoded_log:receivedAllocs[3][1]::STRING AS receivedAllocs_recipient4 --contract: Ronin Treasury
,decoded_log:receivedAllocs[3][3]::NUMBER / 1e2 AS receivedAllocs_ratio4
,decoded_log:receivedAllocs[3][4]::NUMBER / 1e6 AS receivedAllocs_amount4
,decoded_log:receivedAllocs[4][1]::STRING AS receivedAllocs_recipient5
,decoded_log:receivedAllocs[4][3]::NUMBER / 1e2 AS receivedAllocs_ratio5 --unknown contract
,decoded_log:receivedAllocs[4][4]::NUMBER / 1e6 AS receivedAllocs_amount5
,decoded_log:receivedAllocs[5][1]::STRING AS seller_address
,decoded_log:receivedAllocs[5][3]::NUMBER / 1e2 AS seller_ratio
,decoded_log:receivedAllocs[5][4]::NUMBER / 1e6 AS effective_earning
from ronin.core.ez_decoded_event_logs
where 1=1
and block_timestamp > '2025-03-03'
and event_name = 'OrderMatched'
and origin_to_address = '0x3b3adf1422f84254b7fbb0e7ca62bd0865133fe3'
Last run: about 23 hours ago
100
20KB
2s