DATE | TRADES | N_SELLERS | N_BUYERS | N_TOKENS | VOLUME | AVG_VOLUME | MEDIAN_VOLUME | MAX_VOLUME | AVG_PRICE_PER_TOKEN | TOTAL_TRADES | TOTAL_VOLUME | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2025-03-20 00:00:00.000 | 1904 | 708 | 1228 | 1131 | 54609.02 | 3.577869357 | 3.25 | 147.57 | 48.283837312 | 484543 | 7260101.63 |
2 | 2025-03-19 00:00:00.000 | 5247 | 1586 | 3094 | 2976 | 108729.33 | 5.394390256 | 2.93 | 1468.13 | 36.535393145 | 482639 | 7205492.61 |
3 | 2025-03-18 00:00:00.000 | 5242 | 1588 | 3143 | 2744 | 43789.08 | 4.335123255 | 2.87 | 1372.21 | 15.958119534 | 477392 | 7096763.28 |
4 | 2025-03-17 00:00:00.000 | 5415 | 1669 | 3076 | 2642 | 42648.77 | 4.69441607 | 2.9 | 3134.25 | 16.142607873 | 472150 | 7052974.2 |
5 | 2025-03-16 00:00:00.000 | 5321 | 1713 | 2764 | 2880 | 55349.36 | 5.688526208 | 2.8 | 7444.87 | 19.218527778 | 466735 | 7010325.43 |
6 | 2025-03-15 00:00:00.000 | 5237 | 1722 | 2935 | 2666 | 41869.63 | 5.129196374 | 2.88 | 3088.69 | 15.705037509 | 461414 | 6954976.07 |
7 | 2025-03-14 00:00:00.000 | 5464 | 1751 | 3105 | 2688 | 52894.3 | 5.01225244 | 2.85 | 3040.4 | 19.677938988 | 456177 | 6913106.44 |
8 | 2025-03-13 00:00:00.000 | 5978 | 1918 | 3327 | 3129 | 61143.24 | 5.139383038 | 2.84 | 3061.02 | 19.540824545 | 450713 | 6860212.14 |
9 | 2025-03-12 00:00:00.000 | 6915 | 2212 | 3651 | 3625 | 54064.42 | 4.257711451 | 2.74 | 926.2 | 14.914322759 | 444735 | 6799068.9 |
10 | 2025-03-11 00:00:00.000 | 6768 | 2330 | 3448 | 3929 | 94050.73 | 4.655285354 | 2.56 | 9056.21 | 23.937574446 | 437820 | 6745004.48 |
11 | 2025-03-10 00:00:00.000 | 6825 | 2310 | 3529 | 3938 | 115103.1 | 4.090082439 | 3.05 | 1409.84 | 29.228821737 | 431052 | 6650953.75 |
12 | 2025-03-09 00:00:00.000 | 5641 | 1966 | 2889 | 2837 | 80304.51 | 4.586470387 | 3.01 | 3527.92 | 28.306136764 | 424227 | 6535850.65 |
13 | 2025-03-08 00:00:00.000 | 5812 | 2039 | 2789 | 3036 | 58341.77 | 5.481703467 | 3.08 | 3900.41 | 19.216656785 | 418586 | 6455546.14 |
14 | 2025-03-07 00:00:00.000 | 5930 | 2206 | 3092 | 2939 | 94543.82 | 5.269413666 | 3.09 | 3695.93 | 32.168703641 | 412774 | 6397204.37 |
15 | 2025-03-06 00:00:00.000 | 7123 | 2092 | 3554 | 3071 | 95730.78 | 7.030756463 | 2.98 | 4170.86 | 31.172510583 | 406844 | 6302660.55 |
16 | 2025-03-05 00:00:00.000 | 4996 | 1605 | 2839 | 2746 | 58404.53 | 5.347420802 | 2.66 | 8143.42 | 21.26894756 | 399721 | 6206929.77 |
17 | 2025-03-04 00:00:00.000 | 4936 | 1632 | 2719 | 2696 | 38738.61 | 4.13388219 | 2.45 | 921.17 | 14.368920623 | 394725 | 6148525.24 |
18 | 2025-03-03 00:00:00.000 | 5130 | 1458 | 3017 | 2420 | 45140.74 | 4.44298622 | 2.73 | 3547.98 | 18.653198347 | 389789 | 6109786.63 |
19 | 2025-03-02 00:00:00.000 | 4473 | 1485 | 2365 | 2478 | 58927.74 | 4.261787806 | 3.34 | 1556.89 | 23.780363196 | 384659 | 6064645.89 |
20 | 2025-03-01 00:00:00.000 | 4852 | 1760 | 2369 | 2702 | 43915.86 | 5.14357695 | 2.93 | 3363.44 | 16.253094004 | 380186 | 6005718.15 |
0xHaM-dAxie NFT Sales
Updated 2025-03-20
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
›
⌄
select
trunc(nt.BLOCK_TIMESTAMP, 'd') as date,
count(distinct nt.TX_HASH) as trades,
count(distinct nt.FROM_ADDRESS) as n_sellers,
count(distinct tt.ORIGIN_FROM_ADDRESS) as n_buyers,
count(distinct TOKEN_ID) as n_tokens,
sum(AMOUNT_USD)as volume,
avg(AMOUNT_USD)as avg_volume,
median(AMOUNT_USD)as median_volume,
max(AMOUNT_USD)as max_volume,
volume/n_tokens avg_price_per_token,
sum(trades) over (order by date) as total_trades,
sum(volume) over (order by date) as total_volume
from ronin.nft.ez_nft_transfers nt
join ronin.core.ez_token_transfers tt on nt.TX_HASH = tt.TX_HASH and nt.TO_ADDRESS = tt.ORIGIN_FROM_ADDRESS
where nt.NAME ilike 'Axie%'
and tt.ORIGIN_FROM_ADDRESS = tt.FROM_ADDRESS
and nt.BLOCK_TIMESTAMP::date>='2025-01-01'
group by 1
order by 1 desc
Last run: 14 days ago
79
9KB
13s