mehrancrypto-dxoepqQ67-10
Updated 2022-10-19
9
1
2
3
4
5
6
7
8
›
⌄
SELECT ADDRESS_NAME , sum(price) as price , count(tx_hash) as number
FROM Ethereum.core.ez_nft_sales A
left outer join ethereum.core.dim_labels B on A.nft_address= B.address
where CURRENCY_SYMBOL ilike '%ETH%'
and ADDRESS_NAME is not NULL
and LABEL_TYPE ilike '%NFT%'
GROUP BY 1
order by 2 DESC
Run a query to Download Data