freemartianGodMode Secondary Purchaser
Updated 2022-06-09
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
with minters as (
SELECT distinct NFT_TO_ADDRESS as minter
FROM ethereum.core.ez_nft_mints
WHERE NFT_ADDRESS = LOWER('0x903E2F5d42EE23156D548DD46bb84B7873789E44')
AND BLOCK_TIMESTAMP < '2022-06-07 17:00:00.000'
)
select count(distinct buyer_address) as "Secondary Purchaser"
from ethereum.core.ez_nft_sales
where block_timestamp::date >= '2022-01-01'
and buyer_address in (select minter from minters)
and nft_address = '0x903e2f5d42ee23156d548dd46bb84b7873789e44'
Run a query to Download Data