aor67n6
Updated 2022-11-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
WITH c1 AS (
SELECT * FROM ethereum.core.ez_nft_sales
WHERE event_type = 'sale'
AND NFT_ADDRESS= lower('0xFDe881c7B76ad10B59a82247E1cD3CBAd0d739F3')
AND buyer_address <> '0x0000000000000000000000000000000000000000'
AND price <> '0'
)
SELECT tokenid, sum(price_usd)as total_volume_usd
FROM c1
where price_usd is not null
group by 1
ORDER BY 2 DESC
LIMIT 10
Run a query to Download Data