DATE | BUYERS | SELLERS | NFT_SALES | COUNT(DISTINCT TOKENID) | PRICE_ETH | PRICE_USD | |
|---|---|---|---|---|---|---|---|
1 | 2024-03-20 00:00:00.000 | 208 | -326 | 329 | 351 | 232.293093989 | 771482.464906076 |
2 | 2024-03-13 00:00:00.000 | 198 | -708 | 535 | 717 | 40.889631888 | 162988.679059506 |
3 | 2024-03-14 00:00:00.000 | 197 | -562 | 441 | 590 | 65.496397877 | 259019.520295648 |
4 | 2024-03-16 00:00:00.000 | 187 | -352 | 334 | 409 | 119.619558788 | 438102.576203678 |
5 | 2024-03-12 00:00:00.000 | 132 | -418 | 308 | 413 | 6.4953662 | 25903.686857319 |
6 | 2024-03-31 00:00:00.000 | 129 | -153 | 170 | 180 | 320.912997989 | 1156066.74949165 |
7 | 2024-03-15 00:00:00.000 | 125 | -297 | 240 | 313 | 42.499316 | 159058.068392512 |
8 | 2024-03-26 00:00:00.000 | 123 | -132 | 156 | 156 | 164.56475969 | 593457.868709627 |
9 | 2024-03-17 00:00:00.000 | 106 | -181 | 192 | 210 | 95.442760999 | 340067.787631414 |
10 | 2024-03-27 00:00:00.000 | 93 | -94 | 110 | 110 | 160.123034432 | 570758.477562511 |
11 | 2024-04-01 00:00:00.000 | 86 | -97 | 112 | 134 | 266.35280149 | 953069.994013035 |
12 | 2024-03-18 00:00:00.000 | 81 | -108 | 116 | 115 | 48.1963351 | 172500.816638549 |
13 | 2024-03-22 00:00:00.000 | 79 | -92 | 104 | 104 | 92.304639 | 316884.25143733 |
14 | 2024-03-19 00:00:00.000 | 76 | -92 | 105 | 104 | 34.88798456 | 115709.247620139 |
15 | 2024-03-21 00:00:00.000 | 69 | -79 | 86 | 98 | 72.04053 | 252751.90228749 |
16 | 2025-01-05 00:00:00.000 | 68 | -90 | 104 | 160 | 269.22432998 | 981313.050905703 |
17 | 2024-03-25 00:00:00.000 | 64 | -68 | 81 | 82 | 87.42623999 | 307572.822511199 |
18 | 2024-03-29 00:00:00.000 | 64 | -61 | 96 | 88 | 120.717196 | 426549.53344349 |
19 | 2024-04-07 00:00:00.000 | 59 | -69 | 73 | 83 | 145.332749 | 492601.061751316 |
20 | 2024-03-23 00:00:00.000 | 56 | -75 | 69 | 81 | 82.777228 | 277697.304501144 |
Drsimonbuyers and sellers
Updated 2025-03-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
DATE_TRUNC('{{Time_frame}}', block_timestamp) AS DATE,
count(distinct BUYER_ADDRESS) AS BUYERS ,
count(distinct SELLER_ADDRESS ) * -1 AS SELLERS ,
count(distinct tx_hash) as nft_sales ,
count(distinct tokenid) ,
sum(price) as price_eth,
sum(price_usd) as price_usd
from base.nft.ez_nft_sales
where nft_address = lower('0xA449b4f43D9A33FcdCF397b9cC7Aa909012709fD')
group by 1
order by 2 desc
Last run: 16 days agoAuto-refreshes every 12 hours
...
375
23KB
5s