DDATE | MONTH_NAME | CUMULATIVE_TRADES | CUMULATIVE_ITEMS | CUMULATIVE_VOLUME_USD | CUMULATIVE_BUYERS | |
|---|---|---|---|---|---|---|
1 | 2025-01-01 00:00:00.000 | Janth | 1559 | 68735 | 40881.78 | 788 |
2 | 2025-01-02 00:00:00.000 | Janth | 3899 | 171146 | 103156.5 | 1896 |
3 | 2025-01-03 00:00:00.000 | Janth | 6194 | 244197 | 201655.21 | 3044 |
4 | 2025-01-04 00:00:00.000 | Janth | 8287 | 298240 | 290804.48 | 4100 |
5 | 2025-01-05 00:00:00.000 | Janth | 10265 | 376471 | 355879.18 | 5071 |
6 | 2025-01-06 00:00:00.000 | Janth | 12341 | 486666 | 423335.36 | 6040 |
7 | 2025-01-07 00:00:00.000 | Janth | 14439 | 567871 | 515800.27 | 7123 |
8 | 2025-01-08 00:00:00.000 | Janth | 16086 | 621991 | 565696.06 | 8023 |
9 | 2025-01-09 00:00:00.000 | Janth | 18005 | 690171 | 610679.12 | 8969 |
10 | 2025-01-10 00:00:00.000 | Janth | 19992 | 768668 | 708703.53 | 9989 |
11 | 2025-01-11 00:00:00.000 | Janth | 22019 | 824231 | 789617.33 | 11005 |
12 | 2025-01-12 00:00:00.000 | Janth | 24399 | 880503 | 984941.79 | 12226 |
13 | 2025-01-13 00:00:00.000 | Janth | 26868 | 981908 | 1081060.88 | 13334 |
14 | 2025-01-14 00:00:00.000 | Janth | 29571 | 1066985 | 1273784.9 | 14551 |
15 | 2025-01-15 00:00:00.000 | Janth | 31680 | 1193641 | 1438552.67 | 15724 |
16 | 2025-01-16 00:00:00.000 | Janth | 33582 | 1260289 | 1534445.96 | 16750 |
17 | 2025-01-17 00:00:00.000 | Janth | 35947 | 1340113 | 1723510.98 | 17926 |
18 | 2025-01-18 00:00:00.000 | Janth | 38063 | 1396868 | 1841870.05 | 18931 |
19 | 2025-01-19 00:00:00.000 | Janth | 40579 | 1466671 | 2079436.62 | 20117 |
20 | 2025-01-20 00:00:00.000 | Janth | 42804 | 1562692 | 2198742.73 | 21255 |
permaryNft Q1 volume #0461e1
Updated 2025-04-01
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
from ronin.nft.ez_nft_transfers
Last run: 20 days ago
90
6KB
33s