adriaparcerisasEthereum profile of first Godmode minters 4
Updated 2022-06-08
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
›
⌄
-- Analyze the Ethereum profile of those who minted during the first hour after launch.
-- How many of them moved the minimum .1 ETH into their minting wallet vs. already had at least .1 ETH in that wallet?
-- How many of them have been active in NFT purchases over the past six months? Can you construct a “typical minter” profile/profiles based on their wallet behavior?
with
minters as (
select
distinct nft_to_address as minters
from ethereum.core.ez_nft_mints
where
block_timestamp between '2022-06-07 16:00:00.000' and '2022-06-07 17:00:00.000'
and nft_address='0x903e2f5d42ee23156d548dd46bb84b7873789e44' and nft_from_address='0x0000000000000000000000000000000000000000' and event_type ='nft_mint'
--and mint_price_eth>0 --excluding cantina members cause dont have 0.1ETH
group by 1
order by 1 asc
),
behaviour as (
SELECT
distinct buyer_address,
count(distinct tx_hash) as n_purchases,
count(distinct project_name) as n_projects,
sum(price_usd) as volume
from ethereum.core.ez_nft_sales where block_timestamp between CURRENT_DATE-INTERVAL '6 MONTHS' and CURRENT_DATE-2 and buyer_address in (select * from minters)
group by 1
)
SELECT
count(distinct buyer_address) as previous_NFT_purchasers,
count(distinct minters)-previous_NFT_purchasers as non_previous_NFT_purchasers
from behaviour,minters
--group by 1
--order by 1 asc
Run a query to Download Data