where date >='2022-05-09'

group by date)

,uniqbuyer_solana_overtime as (select count(distinct PURCHASER) as buyer_count,block_timestamp::date as date from solana.fact_nft_sales

where date >='2022-05-09'

group by date)

,uniqbuyer_eth_overtime as (select count(distinct BUYER_ADDRESS) as buyer_count,block_timestamp::date as date from ethereum_core.ez_nft_sales

where date >='2022-05-09'

group by date)

, flow_whale as (select count(*) as buy_count ,buyer from flow.core.fact_nft_sales

where block_timestamp::date >='2022-05-09'

group by buyer

having buy_count > 1000)

, solana_whale as (select count(*) as buy_count ,PURCHASER from solana.fact_nft_sales

where block_timestamp::date >='2022-05-09'

group by PURCHASER

having buy_count > 1000)

, eth_whale as (select count(*) as buy_count ,BUYER_ADDRESS from ethereum_core.ez_nft_sales

where block_timestamp::date >='2022-05-09'

group by BUYER_ADDRESS

having buy_count > 1000)

, flow_whale_sales as (select count(*) as sale_count from flow.core.fact_nft_sales where seller in (select buyer from flow_whale))

, flow_whale_buys as (select count(*) as buy_count from flow.core.fact_nft_sales where buyer in (select buyer from flow_whale))

, eth_whale_sales as (select count(*) as sale_count from ethereum_core.ez_nft_sales where SELLER_ADDRESS in (select BUYER_ADDRESS from eth_whale))

, eth_whale_buys as (select count(*) as buy_count from ethereum_core.ez_nft_sales where BUYER_ADDRESS in (select BUYER_ADDRESS from eth_whale))

, sol_whale_sales as (select count(*) as sale_count from solana.fact_nft_sales where PURCHASER in (select PURCHASER from solana_whale))

, sol_whale_buys as (select count(*) as buy_count from solana.fact_nft_sales where mint in (select mint from solana.fact_nft_sales

where PURCHASER in (select PURCHASER from solana_whale)))

select count(*),'flow' from flow_whale

select count(*),'solana' from solana_whale

select count(*),'etherum' from eth_whale