mrnnptrcParallel Avatars - Sales - Volume
Updated 2024-10-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
select
block_timestamp :: date as sale_date,
count(*) as quantity,
sum(price_usd) as amt_usd,
min(price_usd) as min_price_usd,
avg(price_usd) as avg_price_usd,
percentile_cont(0.5) within group (
order by
price_usd
) as median_price_usd
from
ethereum.nft.ez_nft_sales
where
nft_address = '0x0fc3dd8c37880a297166bed57759974a157f0e74'
and sale_date >= dateadd('day', - {{n_days}}, current_date)
and sale_date < current_date
and price_usd > 0
group by
1
order by
1 desc
QueryRunArchived: QueryRun has been archived