flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Basepaint total volume copy
seneca
Basepaint total volume copy
Updated 2024-02-21
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
EXTRACT
(
YEAR
FROM
BLOCK_TIMESTAMP
)
AS
year
,
EXTRACT
(
WEEK
FROM
BLOCK_TIMESTAMP
)
AS
week
,
COUNT
(
*
)
AS
num_rows
FROM
base
.
nft
.
ez_nft_sales
WHERE
NFT_ADDRESS
=
'0xba5e05cb26b78eda3a2f8e3b3814726305dcac83'
GROUP
BY
year
,
week
ORDER
BY
year
,
week
;
Results