Tobi_1guilty-emerald
Updated 2024-08-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
⌄
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS date,
PLATFORM_NAME,
COUNT(TX_HASH) AS transaction_count
FROM
polygon.nft.ez_nft_sales;
WHERE
BLOCK_TIMESTAMP >= DATEADD(day, -30, CURRENT_TIMESTAMP)
GROUP BY
DATE_TRUNC('day', BLOCK_TIMESTAMP),
PLATFORM_NAME
ORDER BY
DATE_TRUNC('day', BLOCK_TIMESTAMP),
PLATFORM_NAME;
QueryRunArchived: QueryRun has been archived