TIME | PLATFORM_NAME | AGGREGATOR_NAME | volume (ETH) | volume (USD) | floor price (ETH) | floor price (USD) | TRADES | NFTS | |
|---|---|---|---|---|---|---|---|---|---|
1 | 2025-03-10 13:00:00.000 | opensea | Blur | 0.001 | 2.12773 | 0.001 | 2.12773 | 1 | 1 |
HessishAnticipation - trds
Updated 2025-03-13
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT date_trunc('hour',block_timestamp) as time, PLATFORM_NAME,
AGGREGATOR_NAME, sum(PRICE) as "volume (ETH)",
sum(PRICE_USD) as "volume (USD)",
min(PRICE) as "floor price (ETH)",
min(PRICE_USD) as "floor price (USD)",
count(DISTINCT TX_HASH) as trades,
count(DISTINCT TOKENID) as nfts
from ethereum.nft.ez_nft_sales
where NFT_ADDRESS = '0x15c905dec8da0a90fa05f8121e8f8285d30ef1f4'
and BLOCK_TIMESTAMP::date >= current_date - 7
group by all
Last run: 29 days ago
1
78B
2s