msafadoostThose who buy nft in last 6 month
Updated 2022-06-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
WITH minters AS (
SELECT NFT_TO_ADDRESS
FROM ethereum.core.ez_nft_mints
WHERE BLOCK_TIMESTAMP >= '2022-06-07 16:00:00.000'
AND BLOCK_TIMESTAMP <= '2022-06-07 17:00:00.000'
AND MINT_PRICE_ETH = '0.1'
AND NFT_ADDRESS = '0x903e2f5d42ee23156d548dd46bb84b7873789e44'
GROUP BY 1
)
SELECT
COUNT(DISTINCT(BUYER_ADDRESS)) AS nft_buyers
FROM ethereum.core.ez_nft_sales
WHERE BLOCK_TIMESTAMP >= CURRENT_DATE - 180
AND BLOCK_TIMESTAMP <= '2022-06-07 16:00:00.000'
AND BUYER_ADDRESS IN (
SELECT NFT_TO_ADDRESS FROM minters
)
AND PRICE > '0'
Run a query to Download Data