0xaimanCumulative Total Sales, (USD)
Updated 2023-04-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select date_trunc('day',block_timestamp) as day, count(distinct buyer_address) as "Number of Unique Buyer", count(distinct seller_address) as "Number of Unique Seller",
sum(price) as "Total Sales (ETH)",median(price) as "Median Sales (ETH)", count(distinct tokenid) as "Number of xHamster NFT Sold", sum(PRICE_USD) as "Total Sales (USD)", median(PRICE_USD) as "Median Sales (USD)",
sum("Total Sales (ETH)") OVER(ORDER BY day asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS "Cumulative Total Sales (ETH)",
sum("Total Sales (USD)") OVER(ORDER BY day asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS "Cumulative Total Sales (USD)"
from ethereum.core.ez_nft_sales where nft_address = '0xeb0ddc0579cf3894c78ae2c4a7d5ec3b36bfa13a'
and CURRENCY_SYMBOL='ETH'
group by 1
Run a query to Download Data