shreexSales
Updated 2023-03-13
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
date_trunc('day',block_timestamp) as date,
sum(price) as daily_volume,
sum(daily_volume) over (order by date) as sales_volume_cumulative,
count(distinct buyer) as distinct_buyers,
sum(distinct_buyers) over (order by date) as cumulative_buyers,
count(distinct seller) as distinct_sellers,
sum(distinct_sellers) over (order by date) as cumulative_buyers
from flow.core.ez_nft_sales where nft_collection='A.e4cf4bdc1751c65d.AllDay' and tx_succeeded='TRUE'
GROUP BY date
ORDER BY date
Run a query to Download Data