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),

nft_sales_to as (

select *

from ethereum.core.ez_nft_sales

where buyer_address in (select minters from addresses)

and block_timestamp >= '2022-01-07'

),

nft_sales_from as (

select distinct origin_from_address as minter,

--platform_name as marketplace,

--event_type,

--sum (1) as sales,

sum (price_usd) as sale_vol

--sum(total_fees_usd) as fees_vol,

--sum (tx_fee_usd) as gas_fees_vol

from ethereum.core.ez_nft_sales s right join addresses a on a.minters = s.seller_address

where a.minters is not null and block_timestamp >= '2022-01-07'

group by 1--,2,3

),