mlhUntitled Query
Updated 2022-11-03Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select trunc(block_timestamp,'day') as date, count(DISTINCT(tx_hash)) as total_tx,
count(DISTINCT(buyer_address)) as total_buyer, count(DISTINCT(seller_address)) as total_seller,
count(DISTINCT(tokenid)) as total_nft, sum(price_usd) as volume, avg(price_usd) as avg_volume,
avg(volume) over (order by date rows between 7 preceding and 0 following) as ma_7_volume,
min(price_usd) as min_price, max(price_usd) as max_price, median(price_usd) as median_price,
sum(total_nft) over (order by date asc) as cum_nft
from ethereum.core.ez_nft_sales
where nft_address = lower('0x60bb1e2AA1c9ACAfB4d34F71585D7e959f387769')
group by 1
Run a query to Download Data