intellidegentGroup by Month
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH top_10 as (
SELECT (nft_to_address) as Minter,
COUNT(tx_hash) numberof_NFT_minted
FROM ethereum.core.ez_nft_mints
WHERE date_trunc('month', block_timestamp) = '2022-10-01'
OR date_trunc('month', block_timestamp) = '2023-01-01'
GROUP BY Minter
ORDER BY numberof_NFT_minted DESC
limit 10)
SELECT SUM(numberof_NFT_minted)
FROM top_10
SELECT
DATE_TRUNC('MONTH', BLOCK_TIMESTAMP) "Month",
COUNT(TX_HASH),
COUNT(DISTINCT(TX_HASH))
FROM ethereum.core.ez_nft_mints
WHERE DATE_TRUNC('MONTH', BLOCK_TIMESTAMP) = '2023-01-01'
OR DATE_TRUNC('MONTH', BLOCK_TIMESTAMP) = '2022-10-01'
GROUP BY "Month"
ORDER BY "Month"
SELECT
DATE_TRUNC('MONTH', BLOCK_TIMESTAMP) "Month",
COUNT(TX_HASH),
COUNT(DISTINCT(TX_HASH))
FROM ethereum.core.ez_nft_mints
WHERE block_timestamp::date BETWEEN '2021-01-01' AND '2023-01-31'
GROUP BY "Month"
ORDER BY "Month"
with nft_sales AS
Run a query to Download Data