DATE | VOL | AVERAGE | SALES | |
---|---|---|---|---|
1 | 2025-02-16 00:00:00.000 | 3.66 | 3.66 | 1 |
2 | 2025-02-15 00:00:00.000 | 0.045950001 | 0.045950001 | 1 |
3 | 2025-02-14 00:00:00.000 | 1.267086 | 0.1055905 | 12 |
4 | 2025-02-13 00:00:00.000 | 5.062786 | 0.7232551429 | 7 |
5 | 2025-02-12 00:00:00.000 | 0.33882 | 0.16941 | 2 |
6 | 2025-02-11 00:00:00.000 | 1.416688 | 0.177086 | 8 |
7 | 2025-02-10 00:00:00.000 | 1.124465 | 0.224893 | 5 |
8 | 2025-02-09 00:00:00.000 | 0.81 | 0.27 | 3 |
9 | 2025-02-08 00:00:00.000 | 2.396098 | 0.1409469412 | 17 |
10 | 2025-02-07 00:00:00.000 | 1.230119 | 0.1366798889 | 9 |
11 | 2025-02-06 00:00:00.000 | 0.180994 | 0.06033133333 | 3 |
12 | 2025-02-05 00:00:00.000 | 0.883 | 0.2943333333 | 3 |
13 | 2025-02-04 00:00:00.000 | 1.2405 | 0.12405 | 10 |
14 | 2025-02-03 00:00:00.000 | 0.490475 | 0.1634916667 | 3 |
15 | 2025-02-02 00:00:00.000 | 1.1506 | 0.143825 | 8 |
16 | 2025-02-01 00:00:00.000 | 0.252748 | 0.0505496 | 5 |
17 | 2025-01-31 00:00:00.000 | 0.549966 | 0.091661 | 6 |
18 | 2025-01-30 00:00:00.000 | 0.942098 | 0.11776225 | 8 |
19 | 2025-01-29 00:00:00.000 | 1.209546 | 0.201591 | 6 |
20 | 2025-01-28 00:00:00.000 | 0.5432990002 | 0.1810996667 | 3 |
banterlyticscom-sales
Updated 22 hours ago
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT block_timestamp::date as date,sum(price) as vol,avg(price) as average,count(*) as sales
FROM ethereum.nft.ez_nft_sales
WHERE block_timestamp > '2021-04-01'
and nft_address in (lower('0x57a204AA1042f6E66DD7730813f4024114d74f37'), lower('0x7EA3Cca10668B8346aeC0bf1844A49e995527c8B') , lower('0x1F7c16FCe4fC894143aFB5545Bf04f676bf7DCf3'))
and CURRENCY_SYMBOL in ('ETH', 'WETH')
group by 1
order by 1 DESC
Last run: about 22 hours agoAuto-refreshes every 24 hours
...
1381
70KB
3s