mehrancrypto-dxoepqQ65-9
Updated 2022-08-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with tx1 as (
SELECT ADDRESS
from ethereum.core.dim_labels
where LABEL_TYPE = 'nft'
and LABEL ilike '%cryptopunk%'
)
SELECT BUYER_ADDRESS , COUNT(*) as "Number of transaction" ,
sum(A.PRICe) as "Volume in ETH" ,sum(A.PRICe_USD) as "Volume in USD"
from tx1 B , ethereum.core.ez_nft_sales A
where NFT_ADDRESS = ADDRESS
and ( BUYER_ADDRESS <> '0x0000000000000000000000000000000000000000' )
and (CURRENCY_SYMBOL = 'ETH'
or CURRENCY_SYMBOL = 'WETH')
and SELLER_ADDRESS <> '0x9b5a5c5800c91af9c965b3bf06ad29caa6d00f9b'
and PRICe_USD is not null
group by 1
order by 2 desc
limit 10
Run a query to Download Data