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
QueryRunArchived: QueryRun has been archived