SELECT

token_id,

sum(price_usd) as trading_volume

FROM ethereum.nft_events

WHERE event_platform = 'art_blocks'

AND event_type = 'sale'

and not price_usd is NULL

GROUP BY 1

ORDER by 2 DESC

LIMIT 5

), tab2 as (

SELECT

token_id,

max(price_usd) as max_price,

count(*) as total_trades

FROM ethereum.nft_events

where token_id in (SELECT token_id from tab1)

GROUP BY 1

SELECT

avg(max_price) as max_price,

avg(total_trades) as total_trades,

token_name

FROM tab2 left outer join ethereum.nft_metadata on tab2.token_id = ethereum.nft_metadata.token_id

GROUP by 3