sum(price) as "Sale Volume",

date_trunc('day', block_timestamp::date) as TIME,

row_number() over (partition by TIME order by "Sale Volume" DESC) as rank,

case

when nft_collection = 'A.0b2a3299cc857e29.TopShot' then 'TopShots'

when nft_collection = 'A.329feb3ab062d289.UFC_NFT' then 'UFC'

when nft_collection = 'A.e4cf4bdc1751c65d.AllDay' then 'AllDay'

when nft_collection = 'A.f2af175e411dfff8.MetaPanda' then 'MetaPanda'

when nft_collection = 'A.e4cf4bdc1751c65d.PackNFT' then 'Pact'

when nft_collection = 'A.6c3ff40b90b928ab.RCRDSHPNFT' then 'RCRDSHP'

end as collection_name

from flow.core.fact_nft_sales

where block_timestamp > '2022-05-09'

and currency in (

'A.b19436aae4d94622.FiatToken',

'A.3c5959b568896393.FUSD',

'A.ead892083b3e2c6c.DapperUtilityCoin',

'A.4eded0de73020ca5.FazeUtilityCoin')

group by TIME, nft_collection

qualify rank <= 3