flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Near Daily Sales Volume From 1st July 2024
Crypticyl
Near Daily Sales Volume From 1st July 2024
Updated 2024-08-12
Copy Reference
Fork
9
1
2
3
4
5
›
⌄
SELECT
DATE_TRUNC
(
'day'
,
BLOCK_TIMESTAMP
)
AS
Sale_Date
,
COUNT
(
*
)
AS
Sales_Volume
FROM
near
.
nft
.
ez_nft_sales
WHERE
BLOCK_TIMESTAMP
>=
'2024-07-01'
AND
BLOCK_TIMESTAMP
<
'2024-08-01'
GROUP
BY
Sale_Date
ORDER
BY
Sale_Date
;
Results
QueryRunArchived: QueryRun has been archived