select

block_timestamp::date as date,

BUYER as flow_buyers,

count (TX_ID) as flow_sales

from flow.core.fact_nft_sales

where TX_SUCCEEDED= 'TRUE'

group by 2

),

sol as (

SELECT

block_timestamp::date as date,

PURCHASER as sol_buyers,

count ( TX_ID) as sol_sales

from solana.core.fact_nft_sales

where SUCCEEDED= 'true'

group by 2

),

eth as (

SELECT

block_timestamp::date as date,

BUYER_ADDRESS as eth_buyers,

count (TX_HASH) as eth_sales

from ethereum.core.ez_nft_sales

group by 2

),

flowb as (

select

block_timestamp::date as date,

CASE

WHEN BUYER in (SELECT flow_buyers FROM flow where flow_sales > 30)

THEN 'Whale'

ELSE 'Normal' END as "Status",

count (*) as sales

from flow

GROUP by 1