select nft_to_address,

case mint_price_eth

when 0 then 'Freebie'

when 0.1 then 'Allow list'

else 'Monster'

end as minter_type

from ethereum.core.ez_nft_mints

where nft_address = lower('0x903E2F5d42EE23156D548DD46bb84B7873789E44')

and block_timestamp < '2022-06-07 17:00:00'

and minter_type = 'Allow list'

order by block_timestamp),

addresses as (select nft_to_address as minters

from early_minter

group by 1),

min_ETH_transfer_before as (

select distinct eth_to_address as ETH_transfers

from ethereum.core.ez_eth_transfers

where eth_to_address in (select minters from addresses)

and block_timestamp >= '2022-06-06' and block_timestamp < '2022-06-07 16:00:00'

and amount >= 0.1

),

min_ETH_transfer_during as (

select distinct eth_to_address as ETH_transfers

from ethereum.core.ez_eth_transfers

where eth_to_address in (select minters from addresses)

and block_timestamp >= '2022-06-07 16:00:00' and block_timestamp < '2022-06-07 17:00:00'

and amount >= 0.1

),

min_ETH_balance as (

select distinct user_address as ETH_balance

from flipside_prod_db.ethereum.erc20_balances