select top 100

buyer,

count(DISTINCT tx_id) as sale_flow_count,

sum(price) as volume

from flow.core.fact_nft_sales

group by 1

order by 3 desc

)

, flow as (

select

block_timestamp::date as date,

count(DISTINCT tx_id) as sales,

sum(sales) over (order by date asc) as cum_sales,

sum(price) as volume

from flow.core.fact_nft_sales

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

and buyer in ( select buyer from flow_whale)

group by 1

order by 1

)

, ethereum_whale as (

select top 100

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-01-01'

group by 1

order by 3 desc

)

, ethereum as (

select

block_timestamp::date as date,

count(DISTINCT tx_hash) as sales,

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