with ethereum_whale as (

select top 50

buyer_address,

count(DISTINCT tx_hash) as sale_eth_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 as (

select

block_timestamp::date as date,

count(DISTINCT tx_hash) as sale_eth_count,

sum(sale_eth_count) over (order by date asc) as cum_sales

, sum(PRICE_USD) as volume

from ethereum.core.ez_nft_sales

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

and buyer_address in (select buyer_address from ethereum_whale)

group by 1

order by 1

)

, price as (

select

hour::date as date_,

avg(price) as price

from flipside_prod_db.ethereum_core.fact_hourly_token_prices

where token_address = lower('0xD31a59c85aE9D8edEFeC411D448f90841571b89c')

and hour::date >= '2022-01-01'

group by 1

)

, solana_whale as (

select top 50

purchaser,

count(DISTINCT tx_id) as sale_sol_count,