BLOCK_TIMESTAMP | LABEL | TX_HASH | BUYER | SELLER | SYMBOL | AMOUNT | AMOUNT_USD | COLLECTION | NFT_CONTRACT | TOKEN_IDS | QUANTITY | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2025-03-10 13:56:47.000 | listing-bulk | 0xa011c18d73cc336562bb1011bc073f594b4ed3b01e83d7d59fdbca029d570d9f | 0x5e1a5b758790151f9de130331fd012b775c50cbf | 5 | RON | 2.844 | 2.31 | Wild Forest Units | 0xa038c593115f6fcd673f6833e15462b475994879 | 25 | 25 |
2 | 2025-03-09 06:32:44.000 | listing-bulk | 0x7a28873a2a3fbce60a045be6e4245e3bdd9c4501d6adb98cbb48496f7f0ec13b | 0x447acbd690182676f36c1dfabc55f0b00323011b | 1 | SLP | 487 | 0.91 | Axie Material | 0x12b707c3d2786570cfdc3a998a085b62acdba4b3 | 1 | 6 |
3 | 2025-03-14 05:56:04.000 | listing-bulk | 0x93578df77a403f887af168e5d854be8cb0f3526ae0ed430ec81dbb110edf3c8b | 0x7e5a1cfb1a8fd4d235ce3e5196170212778e80af | 3 | WETH | 0.001861956 | 3.52 | Axie Material | 0x12b707c3d2786570cfdc3a998a085b62acdba4b3 | 1 | 100 |
4 | 2025-03-10 22:10:05.000 | listing-bulk | 0x8e99424396556c9f7691ff41e889d30a65b6b8915ae3ca63d6976392d12f7386 | 0xb318692bb4ead115591d0911aeba7afa4dec1a68 | 2 | RON | 5.09 | 3.62 | Ragnarok Monsters | 0x029bb759353f6547fbe387e97869057849ab4d23 | 6 | 6 |
5 | 2025-03-14 23:23:45.000 | listing-bulk | 0x6b43ca273ee0598770755b3ed4b2e590ddcf99fede812a9e7e71f90a170624bd | 0x8dc524fffac9c2966e2d62e89da8f5992e18fe74 | 1 | RON | 640 | 539.82 | Kojin Genesis | 0x7766f63c9e921ea97f1b688af27348f2139724a7 | 2 | 2 |
6 | 2025-03-12 10:24:47.000 | listing-bulk | 0x358ddd34e0865e41e5b9e9c038a35658a36f1c5f423ab6ce15669beef2c1ec6f | 0x2d8315aa94f0272437341a6e09ea44b2b853b17f | 2 | WETH | 0.005006274 | 9.66 | Axie Material | 0x12b707c3d2786570cfdc3a998a085b62acdba4b3 | 1 | 225 |
7 | 2025-03-16 12:03:45.000 | listing-bulk | 0xc704f355aa8ad4b6cdb82d66b17ed346e03fa8f5fd6fb685f4597d6d78cd09e1 | 0x90ea2a2122cb272f46471e8d5b7d15b93656e21b | 1 | WETH | 0.002 | 3.81 | Axie | 0x32950db2a7164ae833121501c797d79e7b79d74c | 1 | 1 |
8 | 2025-03-10 12:58:38.000 | listing-bulk | 0x022f3a307d1516d366dbf60da4af90456139ab45e75ed3354ba26d604a86c9a9 | 0xa2fed38ec435a4fc16df73da9da953a0bbc9c717 | 2 | RON | 19.2 | 15.38 | Realms Tickets | 0xf7d2ef2124837fe5c7ebf28635c2853db5964778 | 1 | 20 |
9 | 2025-03-10 12:49:50.000 | listing-bulk | 0x3e723c242286a25a4be6c4bb05b6eee3b27319364e114bf93e8fdb0e11bee846 | 0xa9dbb3914bfa84bfe4940ba477b70765cb6a13fb | 2 | RON | 4.856295821 | 3.89 | Axie Material | 0x12b707c3d2786570cfdc3a998a085b62acdba4b3 | 1 | 100 |
10 | 2025-03-09 23:51:29.000 | listing-bulk | 0x66a6388babf5ac55fbfaec1ab9c0895a499e8c0fddc2d2182660bf65fd560f72 | 0x9c5b1965cfa1681134b833de2e9d2a0aad28a36b | 1 | RON | 5 | 4 | The Sovereigns of Elite Pact | 0xdea00a9663e4ff6151cc9c970fb522e9695d2769 | 2 | 2 |
11 | 2025-03-12 14:55:42.000 | listing-bulk | 0x7d9af1b7409224ccda69a7beba8747b05ac1f7293c594ed91776b385b1124a5d | 0x5dec79b441a028cdebda456949a049b09cfb97e6 | 1 | RON | 151.98 | 124.16 | Ronkeverse | 0x810b6d1374ac7ba0e83612e7d49f49a13f1de019 | 1 | 1 |
12 | 2025-03-11 04:47:15.000 | listing-bulk | 0x781190a3fe6f1db23a9e4f2dd00c5c8e3cc0b1024668f66d23ffe297b387ed84 | 0x2d4df9716185a47be4b5ba9d1565fcb4cfa8c171 | 1 | AXS | 1.162385532 | 3.36 | Axie Material | 0x12b707c3d2786570cfdc3a998a085b62acdba4b3 | 1 | 62 |
13 | 2025-03-10 17:40:39.000 | listing-bulk | 0x8129b873a0b72a78bde0259dc0c78d17d885d767eeaf0c0c27ff844cd2c881a9 | 0x759c65cc7d062615dc2a8bcdeb25e6b06e7d1912 | 1 | WETH | 0.008394396459 | 17.02 | 0x09736b41ba78633d435e06019dc1a79b1545babc | 1 | 1 | |
14 | 2025-03-09 13:08:21.000 | listing-bulk | 0x2192c3100cb2573b1b7d814e91c6c5e700678e1954a140ccaef446121f812573 | 0x500544776b14a1f5537c84eb5dbe91c65cfb8fca | 8 | RON | 60.47 | 51.57 | Primal HeroZ | 0x72288a7f32bec9de4a42bd19a746b9e7798996bb | 15 | 15 |
15 | 2025-03-13 19:20:05.000 | listing-bulk | 0x76ff262d18171b1ef5cd29b28b429422719781270c7dd5be76b2da92ec5062e7 | 0x759c65cc7d062615dc2a8bcdeb25e6b06e7d1912 | 6 | WETH | 0.009316212293 | 17.04 | Primal HeroZ | 0x72288a7f32bec9de4a42bd19a746b9e7798996bb | 7 | 7 |
16 | 2025-03-14 00:46:10.000 | listing-bulk | 0xefd3ba317b57c73f1ec14673540c46d730b957d5f3536adbcecb9ac4de41f6f3 | 0x72ac1521af382be4b44fc89a9805c94483f0391c | 2 | WETH | 0.002157999 | 4.06 | Axie Rune | 0xc25970724f032af21d801978c73653c440cf787c | 1 | 2 |
17 | 2025-03-15 17:25:59.000 | listing-bulk | 0x590a8df95795c677fbc289bf19a44b8a4386e274d230b2a9a868ee03ebdacf08 | 0xac1ef6ed4f3608d792aa29b5f6df6762c165d37f | 2 | RON | 0.3 | 0.24 | Wild Forest Units | 0xa038c593115f6fcd673f6833e15462b475994879 | 2 | 2 |
18 | 2025-03-11 01:10:09.000 | listing-bulk | 0x5451448f718d275fcf6cff9e54e5f09e89c6d160c53bf71d2ca27ee50e9936e2 | 0xbd2e4e52b26dfa9a9e9087ac65ff0792a3cc6cad | 1 | RON | 210 | 148.6 | Sabong Saga Chickens | 0x322b3d98ddbd589dc2e8dd83659bb069828231e0 | 3 | 3 |
19 | 2025-03-11 04:26:57.000 | listing-bulk | 0x7a5f1316c34bb78a7d65099c430515af81fd740a19fc558160d481cbef7daed1 | 0x052627587c7fedb75210e3f8f30ea8e6d6bbaf23 | 2 | RON | 2.682751272 | 1.89 | Axie Consumable Item | 0x737b80335a9396a8658405d7adcbc57343ff0558 | 1 | 2 |
20 | 2025-03-10 17:43:36.000 | listing-bulk | 0xd848088074280a80fc9de5f156982d40efdfcc4dec6e3151bf13531a4a4f1957 | 0x0bee1033bcb19dfa282ed50b95900d219dda9078 | 2 | WETH | 0.000578976 | 1.17 | Axie Consumable Item | 0x737b80335a9396a8658405d7adcbc57343ff0558 | 1 | 20 |
D3 AnalyticsNFT Trades
Updated 14 hours ago
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
›
⌄
-- forked from TLM https://flipsidecrypto.xyz/TheLaughingMan/q/zd9PrybB0sGM/daily-stats
with offer_sales as (
SELECT
logs.block_timestamp
, 'collection-offer' as label
, logs.tx_hash
, buyer
, seller
, symbol
, amount -- payment token amount
, amount_usd
, collection
, nft_contract
, token_id
, quantity
from ronin.core.fact_event_logs logs
----------------------------------------
--- Extract USD values for the trade ---
----------------------------------------
LEFT JOIN (
SELECT
tx_hash
, from_address as buyer
, symbol
, amount
, amount_usd
from ronin.core.ez_token_transfers
WHERE 1=1
--AND tx_hash = '0xb93daf89d0a2a32e00382888ce2425e058319751fc481768cd5fc53f82f5f86e'
AND to_address = '0x3ef234bc2a04d86f6041e419458d9acbd077f2c1' --Collection Offer Proxy
) pays on logs.tx_hash = pays.tx_hash
----------------------------------------
--- Extract traded NFT contract ---
----------------------------------------
LEFT JOIN (
SELECT
Last run: about 14 hours ago
...
6357
1MB
7s