ramishoowUntitled Query
Updated 2022-10-20
9
1
2
3
4
5
›
⌄
with ramishow as ( select block_timestamp, tx_hash, seller_address, buyer_address, nft_address,
currency_symbol, price_usd from optimism.core.ez_nft_sales where event_type = 'sale' and block_timestamp::date <= current_date - 1 and price_usd is not null
) select buyer_address, count(distinct tx_hash) as "Number of NFT Sales", sum(price_usd) as "Total Sales Volume (USD)" from ramishow
group by buyer_address order by "Total Sales Volume (USD)" desc limit 5
Run a query to Download Data