ramishoowUntitled Query
Updated 2022-09-13Copy Reference Fork
9
1
2
3
›
⌄
SELECT block_timestamp::date as date, sum(price) AS volume, COUNT(DISTINCT tx_id) AS num_sales, COUNT(DISTINCT buyer) AS uniqe_buyers, COUNT(DISTINCT seller) AS uniqe_sellers, SUM(volume) OVER (ORDER BY date) as cumulative_volume,
SUM(num_sales) OVER (ORDER BY date) as cumulative_num_sales, SUM(uniqe_buyers) OVER (ORDER BY date) as cumulative_uniqe_buyers, SUM(uniqe_sellers) OVER (ORDER BY date) as cumulative_uniqe_sellers
FROM flow.core.fact_nft_sales WHERE nft_collection='A.e4cf4bdc1751c65d.AllDay' AND tx_succeeded='TRUE' AND date >= '2022-08-01' GROUP BY date ORDER BY date DESC
Run a query to Download Data