mehrancrypto-dxoepqQ70-1
Updated 2022-10-21
9
1
2
3
4
5
6
7
8
›
⌄
SELECT block_timestamp::date as daily , sum(price) as volume ,
count(DISTINCT BUYER) as buyers , count(tx_id ) as tx_number , COUNT(DISTINCT NFT_ID) as NFT ,
sum(volume) over (order by daily) as cumulative_volume ,
sum(tx_number) over (order by daily) as cumulative_tx_number
from flow.core.ez_nft_sales
where NFT_COLLECTION ilike '%raceday%'
and TX_SUCCEEDED ilike '%TRUE%'
group by 1
Run a query to Download Data