nits3- Art Gobbler BAYC Comparison Past 30 days
Updated 2023-04-13
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT date(block_timestamp) as day, min(price_usd) as floor_price, avg(price_usd) as avg_sale_price, max(price_usd) as max_sale_price,
count(DISTINCT tx_hash) as total_txs, sum(price_usd) as sale_usd, sum(sale_usd) over (order by day) as cumulative_sale_usd,
min(floor_price) over (order by day rows between 6 preceding and CURRENT row) as moving_avg_min_floor,
avg(avg_sale_price) over (order by day rows between 6 preceding and CURRENT row) as moving_avg_price,
max(max_sale_price) over (order by day rows between 6 preceding and CURRENT row) as moving_avg_max_price
from ethereum.core.ez_nft_sales
where nft_address = lower('0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d')
GROUP by 1
order by 1 desc
LIMIT 30
Run a query to Download Data