rajsNFL All Day Stats
Updated 2022-09-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT
-- date_trunc('day', block_timestamp) as date,
count(distinct tx_id) as no_of_txs,
sum(price) as volume,
count(distinct buyer) as no_of_buyers,
count(distinct seller) as no_of_sellers,
min(price) as min_price,
max(price) as max_price,
median(price) as median_price,
avg(price) as avg_price
-- distinct currency
-- count(*)
from flow.core.ez_nft_sales
where nft_collection = 'A.e4cf4bdc1751c65d.AllDay'
-- group by 1
-- order by 1 desc
-- limit 1
Run a query to Download Data