SELECT
block_timestamp,
purchaser,
nft_marketplace,
nft_asset_id,
asset_name,
number_of_nfts,
total_sales_amount
from algorand.nft_sales
join algorand.asset t2 on nft_asset_id = t2.asset_id
WHERE
block_timestamp > CURRENT_DATE - 31
order by total_sales_amount desc
limit 10