DATE | N_SALES | BUYERS | SELLERS | N_COLLECTION | SALES_VOLUME_USD | AVG_VOL_PER_COLLECTION | AVG_N_SALES_PER_COLLECTION | AVG_PRICE_USD | MEDIAN_PRICE_USD | MAX_PRICE_USD | FLOOR_PRICE_USD | TOTAL_N_SALES | TOTAL_VOLUME_USD | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2025-04-03 00:00:00.000 | 534 | 278 | 429 | 49 | 18650.246368546 | 380.617272827 | 10.897959 | 11.562459001 | 0.15021182 | 1184.0265 | 6.8274e-13 | 157676 | 11192512.3221809 |
2 | 2025-04-02 00:00:00.000 | 2237 | 872 | 1410 | 69 | 90402.962075726 | 1310.18785617 | 32.42029 | 10.934078626 | 0.1275740291 | 3200.3496 | 4.081182647e-20 | 157142 | 11173862.0758124 |
3 | 2025-04-01 00:00:00.000 | 2813 | 994 | 1646 | 68 | 108434.070902661 | 1594.618689745 | 41.367647 | 10.872763552 | 0.1078662 | 1320.809518 | 4.53915101e-20 | 154905 | 11083459.1137367 |
4 | 2025-03-31 00:00:00.000 | 1673 | 735 | 1077 | 66 | 85103.090454919 | 1289.440764468 | 25.348485 | 23.125839798 | 0.93090068 | 7943.672 | 1.71763758e-17 | 152092 | 10975025.042834 |
5 | 2025-03-30 00:00:00.000 | 1700 | 711 | 1027 | 59 | 52276.100916149 | 886.035608748 | 28.813559 | 12.885408163 | 0.355638 | 2088.777 | 3.928112808e-20 | 150419 | 10889921.9523791 |
6 | 2025-03-29 00:00:00.000 | 1660 | 748 | 938 | 66 | 56013.54636543 | 848.690096446 | 25.151515 | 13.99988662 | 1.14601635 | 1175.4976 | 1.815444768e-17 | 148719 | 10837645.8514629 |
7 | 2025-03-28 00:00:00.000 | 1650 | 770 | 960 | 68 | 55998.413194909 | 823.506076396 | 24.264706 | 14.105393752 | 0.6536214 | 1290.67785 | 7.52535e-20 | 147059 | 10781632.3050975 |
8 | 2025-03-27 00:00:00.000 | 1834 | 873 | 1006 | 70 | 63504.363022027 | 907.205186029 | 26.2 | 12.400773877 | 0.92621032 | 3510.2375 | 2.01454555e-17 | 145409 | 10725633.8919026 |
9 | 2025-03-26 00:00:00.000 | 2031 | 993 | 1097 | 63 | 121525.47966447 | 1928.97586769 | 32.238095 | 27.071837751 | 0.85221138 | 46235.809474506 | 1.981212764e-17 | 143575 | 10662129.5288806 |
10 | 2025-03-25 00:00:00.000 | 2883 | 1262 | 1587 | 61 | 93694.459926244 | 1535.974752889 | 47.262295 | 13.461847691 | 0.79823284 | 3535.728 | 2.911725128e-20 | 141544 | 10540604.0492161 |
11 | 2025-03-24 00:00:00.000 | 2737 | 1148 | 1381 | 61 | 80422.32160844 | 1318.398714892 | 44.868852 | 13.435068762 | 0.639797695 | 9966.34562826 | 1.915454629e-17 | 138661 | 10446909.5892899 |
12 | 2025-03-23 00:00:00.000 | 2766 | 1206 | 1171 | 57 | 42798.144006982 | 750.844631701 | 48.526316 | 7.974314143 | 0.7329944149 | 3977.8113 | 3.20187389e-20 | 135924 | 10366487.2676814 |
13 | 2025-03-22 00:00:00.000 | 2898 | 1172 | 1312 | 56 | 47388.474046166 | 846.222750824 | 51.75 | 7.395205063 | 0.574059315 | 1369.849351961 | 1.546452e-19 | 133158 | 10323689.1236744 |
14 | 2025-03-21 00:00:00.000 | 2987 | 1159 | 1407 | 50 | 67312.098369997 | 1346.2419674 | 59.74 | 10.529031499 | 1.00053561 | 10638.352145865 | 1.817790865e-17 | 130260 | 10276300.6496283 |
15 | 2025-03-20 00:00:00.000 | 1657 | 693 | 1002 | 58 | 52580.731876256 | 906.564342694 | 28.568966 | 11.778837786 | 0.4458055502 | 2777.4248 | 6.28609278e-20 | 127273 | 10208988.5512583 |
16 | 2025-03-19 00:00:00.000 | 1221 | 673 | 949 | 56 | 59536.792001548 | 1063.157000028 | 21.803571 | 20.340550735 | 0.5061664 | 2807.042 | 1.83152249e-17 | 125616 | 10156407.819382 |
17 | 2025-03-18 00:00:00.000 | 1084 | 584 | 755 | 51 | 45537.841255439 | 892.898848146 | 21.254902 | 19.10144348 | 0.8154474875 | 7588.04 | 6.02848376e-18 | 124395 | 10096871.0273805 |
18 | 2025-03-17 00:00:00.000 | 1219 | 557 | 882 | 54 | 37381.227752724 | 692.244958384 | 22.574074 | 10.723243762 | 1.581702 | 3136.49730687 | 3.31230315e-20 | 123311 | 10051333.186125 |
19 | 2025-03-16 00:00:00.000 | 1325 | 553 | 789 | 54 | 52300.845280718 | 968.534171865 | 24.537037 | 19.29208605 | 0.31877992 | 7444.8686 | 6.404523614e-20 | 122092 | 10013951.9583723 |
20 | 2025-03-15 00:00:00.000 | 1373 | 646 | 834 | 53 | 45622.458993913 | 860.801113093 | 25.90566 | 16.687073516 | 1.03966132 | 3088.1934 | 1.8645648e-17 | 120767 | 9961651.11309159 |
0xHaM-dOver Time
Updated 1 day 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 eventTb as (
select
block_timestamp,
tx_hash,
tr.from_address as seller_add,
tr.to_address as buyer_add,
tr.contract_address as contract_address,
tr.name as collection,
p.symbol,
token_id,
log.decoded_log:acceptedSettlePrice / 1e18 as nft_price,
(log.decoded_log:acceptedSettlePrice / 1e18)*price as amount_usd,
((log.decoded_log:acceptedSettlePrice / 1e18)*price)/quantity as price_usd,
log.decoded_log:settleToken as token_add
from ronin.nft.ez_nft_transfers tr
join ronin.core.ez_decoded_event_logs log using (tx_hash, block_timestamp)
left join ronin.price.ez_prices_hourly p on date_trunc('hour', block_timestamp) = hour and log.decoded_log:settleToken = token_address
where event_name = 'OrderMatched'
and decoded_log:order[0]:extraData[0][2] = token_id
and tx_succeeded
)
select
date_trunc('d', block_timestamp) as date,
count(distinct tx_hash) as n_sales,
count(distinct buyer_add) as buyers,
count(distinct seller_add) as sellers,
count(distinct collection) n_collection,
sum(price_usd) as sales_volume_usd,
sales_volume_usd/n_collection as avg_vol_per_collection,
n_sales/n_collection as avg_n_sales_per_collection,
avg(price_usd) as avg_price_usd,
median(price_usd) as median_price_usd,
max(price_usd) as max_price_usd,
min(price_usd) as floor_price_usd,
sum(n_sales) over (order by date) as total_n_sales,
sum(sales_volume_usd) over (order by date) as total_volume_usd
Last run: 1 day ago
93
14KB
25s