sum(SALES_AMOUNT*40) as volume_usd,--- 40 is price of sol

count (TX_ID) as number_transaction

from solana.core.fact_nft_sales

where SUCCEEDED = 'TRUE'

group by 1

order by 2 desc

limit 30),

whale_buy_volume as (select PURCHASER ,

sum(SALES_AMOUNT*40) as volume_usd,

count (TX_ID) as number_transaction

from solana.core.fact_nft_sales

where SUCCEEDED = 'TRUE'

group by 1

order by 2 desc

limit 30)

select 'sale whale volume'as type , * from whale_sell_volume

union all

select ' buy whale volume'as type ,

* from whale_buy_volume