SELECT
block_timestamp,
purchaser,
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
nft_marketplace = 'rand gallery' AND
block_timestamp > CURRENT_DATE - 31
order by total_sales_amount desc
limit 10