with ethereum_whale as (

select top 50

buyer_address ,

count(DISTINCT tx_hash) as sale_count,

sum(price_usd) as volume

from ethereum.core.ez_nft_sales

where price_usd is not null

and block_timestamp::date >= '2022-08-01'

group by 1

order by 3 desc

)

,ethereum_nft as (

select min(block_timestamp::date) as date ,

NFT_ADDRESS as nft

from ethereum.core.ez_nft_sales

group by 2

)

,ethereum as (

select

date ,

buyer_address ,

NFT_ADDRESS

from ethereum.core.ez_nft_sales a join ethereum_nft b on a.NFT_ADDRESS = b.nft

where buyer_address in ( select buyer_address from ethereum_whale)

,solana_whale as (

select top 50

purchaser ,

count(DISTINCT tx_id) as sale_count,

sum(sales_amount) as volume

from solana.core.fact_nft_sales

where sales_amount is not null

and block_timestamp::date >= '2022-08-01'

group by 1

order by 3 desc