peteerTop 10 NFT collections on Optimism chain
Updated 2022-09-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
select
case
when contract_address = '0x81b30ff521d1feb67ede32db726d95714eb00637' then 'Supnerds'
when contract_address = '0xc36442b4a4522e871399cd717abdd847ab11fe88' then 'Uniswap V3 Positions'
when contract_address = '0x6f54391fe0386d506b51d69deeb8b04e0544e088' then 'Mean Finance DCA Positions'
when contract_address = '0x0110bb5739a6f82eafc748418e572fc67d854a0f' then 'Early Optimists'
when contract_address = '0xa95579592078783b409803ddc75bb402c217a924' then 'Introducing the Optimism Collective'
when contract_address = '0x9c7305eb78a432ced5c4d14cac27e8ed569a2e26' then 'veNFT (velodrome)'
when contract_address = '0x2da61a0ec93e3209c0046397ba9aa3e2bcc339f9' then 'Optical Xplosions'
when contract_address = '0xb96113b576d58f848382a501c7f3b532a8edc3e8' then 'Alpha Gal'
when contract_address = '0x8e56343adafa62dac9c9a8ac8c742851b0fb8b03' then 'Bored Town'
when contract_address = '0xf804d537c2530c79453c1cdbdd728a68f340cd9f' then 'Layer2DAO Early Adopter - Level 1'
else contract_address
end as label,
count(distinct origin_from_address) as total
from
optimism.core.fact_event_logs
where
topics[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
and
event_inputs:tokenId is not null
group by 1 order by 2 desc limit 10
Run a query to Download Data