soheyl-aleAll about Cryptopunks trade
Updated 2022-08-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
Select
Sum (Price_USD) As USD_Volume, Sum (Price) As ETH_Volume ,
Count (Distinct tx_hash) As Number_of_transactions ,
Count (Distinct Seller_Address) As Number_of_Sellers ,
Count (Distinct Buyer_Address) As Number_of_Buyers ,
Date_trunc (Month,Block_timestamp) As Time
FROM
Ethereum.core.ez_nft_sales
WHERE Project_Name In ('cryptopunks')
And Event_Type In ('sale')
And Block_timestamp >= '2017-06-01'
Group by Time
Order By Time
Run a query to Download Data