aycgmonthly sales
Updated 2024-04-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
DATE_TRUNC('month', BLOCK_TIMESTAMP) as Date,
COUNT(*) as Total_Sales,
t.project_name,
t.NFT_ADDRESS
FROM
ethereum.nft.ez_nft_sales t
WHERE
t.NFT_ADDRESS = lower('0xBd3531dA5CF5857e7CfAA92426877b022e612cf8') OR
t.NFT_ADDRESS = lower('0xBC4CA0EdA7647A8aB7C2061c2E118A18a936f13D')
GROUP BY
t.NFT_ADDRESS, t.project_name, Date;
QueryRunArchived: QueryRun has been archived