--image method forked from Saleh (https://flipsidecrypto.xyz/studio/queries/d43c03da-0211-444f-bd72-293b1223ba05) with imaget as ( select 'HOT Collection' as nft_name, '

DoubleDog ' as image union all select 'USMen' as nft_name, '

USMen ' as image union all select 'Pitch Talk NFT' as nft_name, '

PitchTalk ' as image union all select 'NEARVidia Exclusive' as nft_name, '

NEARvidia ' as image union all select 'Near Tinker Union' as nft_name, '

Tinker Union ' as image union all select 'ShardDog' as nft_name, '

Harvest Moon Union ' as image union all select 'Harvest Moon Relics' as nft_name, '

Harvest Moon Relics ' as image union all select 'HERE early user collection' as nft_name, '

HERE early user collection ' as image union all select 'Harvest Moon' as nft_name, '

Harvest Moon ' as image union all select 'HAPI NEARonaut' as nft_name, '

HAPI NEARonaut ' as image union all select 'DeltaDisk' as nft_name, '

DeltaDisk ' as image ) select * --image from( select --date_trunc('week', BLOCK_TIMESTAMP) as date, distinct NFT_ADDRESS, Name, --LOG:market_data:nft_contract_id as NFT, --distinct NFT_ADDRESS, --distinct PLATFORM_NAME, /*case when PLATFORM_NAME = 'Mitte' then '

Mitte ' when PLATFORM_NAME = 'Paras' then '

Paras ' when PLATFORM_NAME = 'Mintbase' then '

Mintbase ' when PLATFORM_NAME = 'TradePort' then '

TradePort ' --when PLATFORM_NAME = 'FewAndFar' then '

FewAndFar ' end as image,*/ count(distinct tx_hash) as sales, count(distinct buyer_address) as buyers, count(distinct seller_address) as sellers, --count(distinct nft_address) as collections, count(distinct TOKEN_ID) as tokens, round(sum(price),1) as amount, round(sum(price_usd),1) as usd_amount from near.nft.ez_nft_sales join near.nft.dim_nft_contract_metadata on NFT_ADDRESS = CONTRACT_ADDRESS where BLOCK_TIMESTAMP::date >= '2024-01-01' --and PLATFORM_NAME != 'Apollo42' group by 1,2 order by amount desc --limit 10 ) join imaget on nft_name = Name order by AMOUNT DESC limit 10

NEAR || NFT MarketPlaces