NakedCollectorWEB2: Adidas
Updated 2024-08-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
select
date_trunc({{Day_or_Month}}, block_timestamp) as date,
nft_address,
case
when nft_address = '0x28472a58a490c5e09a238847f66a68a47cc76f0f' then 'Adidas Into the Metaverse'
when nft_address = '0x455c732fee7b5c3b09531439b598ead4817d5274' then 'Adidas IMPOSSIBLE BOX'
when nft_address = '0xba0c9cf4da821dba98407cc4f9c11f6c7a5f9bbc' then 'Adidas Virtual Gear - Genesis Collection'
when nft_address = '0xf9cb96dbd94652f00f3a2aec5539fb4ebe45ee38' then 'adidas Originals x BAPE — Fresh Forum Access Pass'
when nft_address = '0x4ba00fb6a24b2813a9f515de01a9f65f48fefe89' then 'adidas x Crazyfast Bugatti Access Pass'
when nft_address = '0x49afd53d774fb63d13065ebfc112e5bbfa078a07' then 'Moncler x adidas Originals: The Explorer'
when nft_address = '0xbc5115770841141c58b8807e2ac4161bd76cd639' then 'adidas Originals x BAPE® — Fresh Forum Digital Twin'
when nft_address = '0xc6a1f929b7ca5d76e0fa21eb44da1e48765990c5' then 'adidas Onchain: Summer of Sports'
when nft_address = '0x261deb25d07699865c99f2147f839ec49739b541' then 'adidas x DearNostalgia - soles / souls / seoul'
when nft_address = '0x8bf0ca07d85c886cd7d56587c0cdc4306f871726' then 'adidas Golden Ticket'
when nft_address = '0x55ad4e148394212be7b952ebeaa6e24f8a43bb2c' then 'adidas Golden Ticket'
when nft_address = '0xbf42c1972877f39e102807e5e80ed2ff5d16aa5f' then 'Rift Valley Motel Coin'
when nft_address = '0xbdad1d1fd4d1e26668c60d2a81e75dd114ffa243' then 'adidas x MonkeeMoto - Moto x Decos'
when nft_address = '0xa9bdbd7c17658f9ced9a8a8939f3f71d917d4a97' then 'adidas X Crazyfast Bugatti — Digital Twin'
when nft_address = '0x749f5ddf5ab4c1f26f74560a78300563c34b417d' then 'ALTS by Adidas'
when nft_address = '0x7dec38e3874ecbc842cc61e66c1386aca0c0ea1f' then 'adidas for Prada re-source'
else project_name
end as project_name,
count(distinct buyer_address) as buyers,
count(distinct seller_address) as sellers,
count(seller_address) as trades,
count(buyer_address) / count(distinct buyer_address) as trades_per_buyer,
sum(creator_fee_usd) as royalties,
count(distinct buyer_address) / count(distinct seller_address) as Buyer_v_Seller,
sum(price) as "ETH Volume",
sum(price_usd) as "USD Volume",
avg(price_usd) as "Average Price USD",
sum(price_usd * 0.1) as "ROYALTIES (approximated)"
from
ethereum.nft.ez_nft_sales
where
block_timestamp > current_date - interval '{{DAYS}} days'
Auto-refreshes every 12 hours
QueryRunArchived: QueryRun has been archived