DDATE | LABEL | TOTAL_TRADES | TOTAL_ITEMS | TOTAL_VOLUME_USD | UNIQUE_BUYERS | TOTAL_VOLUME_RON | |
|---|---|---|---|---|---|---|---|
1 | 2025-02-17 00:00:00.000 | collection-offer | 2 | 2 | 2710.18 | 2 | 3487.204125549 |
2 | 2025-03-04 00:00:00.000 | listing | 3 | 3 | 2935.91 | 3 | 3777.652209167 |
3 | 2024-12-01 00:00:00.000 | listing | 1 | 1 | 3780 | 1 | 4863.747645756 |
4 | 2025-02-04 00:00:00.000 | listing | 2 | 2 | 3550.747 | 2 | 4568.766497863 |
5 | 2024-10-08 00:00:00.000 | listing | 3 | 3 | 5886.26 | 1 | 7573.884449022 |
6 | 2024-11-03 00:00:00.000 | listing | 5 | 5 | 9386.69 | 4 | 12077.907774851 |
7 | 2025-03-13 00:00:00.000 | listing | 7 | 7 | 6483.77 | 4 | 8342.703987598 |
8 | 2025-02-19 00:00:00.000 | collection-offer | 5 | 5 | 5307.45 | 1 | 6829.12630753 |
9 | 2025-02-24 00:00:00.000 | listing-bulk | 1 | 1 | 1320 | 1 | 1698.451558835 |
10 | 2024-12-30 00:00:00.000 | listing | 4 | 4 | 13593.72 | 4 | 17491.117366947 |
11 | 2025-03-11 00:00:00.000 | listing | 7 | 7 | 7195.84 | 6 | 9258.928534189 |
12 | 2025-01-05 00:00:00.000 | listing | 1 | 1 | 2500 | 1 | 3216.764315976 |
13 | 2025-01-17 00:00:00.000 | listing | 1 | 1 | 2353 | 1 | 3027.618574197 |
14 | 2025-02-14 00:00:00.000 | listing | 9 | 9 | 13613.88 | 5 | 17517.057354391 |
15 | 2025-02-19 00:00:00.000 | listing | 2 | 2 | 3265.64 | 2 | 4201.917688329 |
16 | 2025-01-01 00:00:00.000 | listing | 1 | 1 | 3102.06 | 1 | 3991.438365606 |
17 | 2025-03-19 00:00:00.000 | listing | 4 | 5 | 9273.43 | 5 | 11932.17548428 |
18 | 2024-10-09 00:00:00.000 | listing | 2 | 3 | 8668.75 | 3 | 11154.130265646 |
19 | 2025-03-01 00:00:00.000 | listing | 4 | 4 | 5321.51 | 4 | 6847.217390044 |
20 | 2024-10-05 00:00:00.000 | listing | 1 | 1 | 2318.4 | 1 | 2983.098556063 |
permaryDaily land sales
Updated 2025-03-20
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 offer_sales as (
SELECT
logs.block_timestamp
, 'collection-offer' as label
, logs.tx_hash
, buyer
, seller
, symbol
, amount
, amount_usd
, collection
, nft_contract
, token_id
, quantity
from ronin.core.fact_event_logs logs
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
LEFT JOIN (
SELECT
tx_hash
, from_address as seller
, contract_address as nft_contract
, name as collection
, token_id
, quantity
Last run: about 1 month ago
...
153
10KB
28s