DATE | SELLERS | BUYERS | TRADES | AMOUNT_USD | CUM_AMOUNT_USD | |
|---|---|---|---|---|---|---|
1 | 2025-05-09 00:00:00.000 | 278 | 520 | 675 | 8813.101923817 | 2733131.22790958 |
2 | 2025-05-08 00:00:00.000 | 272 | 432 | 721 | 6297.14840885 | 2724318.12598577 |
3 | 2025-05-07 00:00:00.000 | 290 | 475 | 683 | 4089.711126642 | 2718020.97757692 |
4 | 2025-05-06 00:00:00.000 | 322 | 621 | 926 | 3855.963926284 | 2713931.26645028 |
5 | 2025-05-05 00:00:00.000 | 218 | 479 | 700 | 3378.813598658 | 2710075.30252399 |
6 | 2025-05-04 00:00:00.000 | 217 | 508 | 774 | 4081.313265062 | 2706696.48892533 |
7 | 2025-05-03 00:00:00.000 | 247 | 829 | 1260 | 2864.817428893 | 2702615.17566027 |
8 | 2025-05-02 00:00:00.000 | 399 | 1139 | 1458 | 7344.52094623 | 2699750.35823138 |
9 | 2025-05-01 00:00:00.000 | 354 | 1376 | 1809 | 5229.200069665 | 2692405.83728515 |
10 | 2025-04-30 00:00:00.000 | 298 | 1979 | 2446 | 4305.179215453 | 2687176.63721548 |
11 | 2025-04-29 00:00:00.000 | 342 | 2168 | 2623 | 2350.777956949 | 2682871.45800003 |
12 | 2025-04-28 00:00:00.000 | 385 | 1229 | 1486 | 2328.816474338 | 2680520.68004308 |
13 | 2025-04-27 00:00:00.000 | 324 | 863 | 1116 | 3805.021432347 | 2678191.86356874 |
14 | 2025-04-26 00:00:00.000 | 145 | 616 | 764 | 5789.90938238 | 2674386.8421364 |
15 | 2025-04-25 00:00:00.000 | 178 | 375 | 438 | 2068.168497116 | 2668596.93275402 |
16 | 2025-04-24 00:00:00.000 | 141 | 185 | 234 | 2734.697654047 | 2666528.7642569 |
17 | 2025-04-23 00:00:00.000 | 139 | 169 | 230 | 4307.35461746 | 2663794.06660285 |
18 | 2025-04-22 00:00:00.000 | 139 | 201 | 268 | 2413.84206044 | 2659486.71198539 |
19 | 2025-04-21 00:00:00.000 | 150 | 231 | 315 | 4359.876298565 | 2657072.86992495 |
20 | 2025-04-20 00:00:00.000 | 146 | 304 | 430 | 4732.92238407 | 2652712.99362639 |
hrst79tot
Updated 2025-05-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select
date_trunc('day',block_timestamp) as date,
count(distinct SELLER_ADDRESS ) as sellers,
count(distinct BUYER_ADDRESS ) as buyers,
count(distinct tx_hash) as trades,
sum(PRICE_usd) as amount_usd,
sum(amount_usd) over (order by date) as cum_amount_usd
from avalanche.nft.ez_nft_sales
where block_timestamp >= current_date - 180
group by 1
order by 1 desc
--select * from avalanche.nft.ez_nft_sales limit 100
Last run: about 1 month ago
...
181
13KB
5s