mrnnptrcParallel Alpha - Sales - Volume (exc Assets)
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
23
24
25
26
27
28
›
⌄
select
block_timestamp :: date as sale_date,
sum(erc1155_value) as quantity,
sum(price_usd) as amt_usd,
min(price_usd) as min_price_usd,
avg(price_usd) as avg_price_usd,
sum(price_usd) / sum(erc1155_value) as avg_price_usd2,
percentile_cont(0.5) within group (
order by
price_usd
) as median_price_usd,
percentile_cont(0.5) within group (
order by
price_usd / erc1155_value
) as median_price_usd2
from
ethereum.nft.ez_nft_sales
where
nft_address = '0x76be3b62873462d2142405439777e971754e8e77'
and event_type != 'redeem'
and sale_date >= dateadd('day', - {{n_days}}, current_date)
and sale_date < current_date
and price_usd > 0
and tokenid not in ('87', '10092', '10306', '10464', '10485', '10646', '10782', '10933', '11087', '11099')
group by
1
order by
1 desc
QueryRunArchived: QueryRun has been archived