mboveiriCrypto Punk 8
Updated 2022-08-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
select
CONCAT('ϾPunk ',tokenid) as Punks,
sum(price) as volume_amount,
rank () over (order by volume_amount desc ) as rank
from
ethereum.core.ez_nft_sales
where nft_address in (lower('0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb') , lower('0xb7f7f6c52f2e2fdb1963eab30438024864c313f6'))
and event_type = 'sale'
and buyer_address != lower('0x0000000000000000000000000000000000000000')
and tx_hash != '0x92488a00dfa0746c300c66a716e6cc11ba9c0f9d40d8c58e792cc7fcebf432d0' -- Falsely raise the price transaction hash.
group by 1
qualify rank <= 10
Run a query to Download Data