keshanThe typical minter - 3
Updated 2022-06-09
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with minters as (select
case when mint_price_eth=0 then 'Cantina crew(including FlipSide team)' else 'Allowlist' end as minter_type,
nft_to_address as minter
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' -- Only the first hour of the mint
and nft_address='0x903e2f5d42ee23156d548dd46bb84b7873789e44'
and nft_to_address not in ('0x2d81713c58452c92c19b2917e1c770eecf53fe41', '0x65d079b57844fca66df262523a0b1934bead712b', '0xdc23c31c57747ee7cb2bb4b06af2ceab29e33cdb')
and event_type ='nft_mint')
select minter_type, minter, balance, case when balance > 0.1 then 'At least 0.1 ETH' else 'Less than 0.1 ETH' end as had_balance, 1 as cnt
from minters left join flipside_prod_db.ethereum.erc20_balances on user_address=minter and contract_address='ETH' and balance_date='2022-6-6'
where minter_type='Allowlist'
Run a query to Download Data