dannerCopy of NFT Project Overview
Updated 2022-09-02
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
›
⌄
with buy as
(
select
nft_address as contract_address,
buyer_address as wallet,
count(tokenid) as purchases,
max(price_usd) as most_paid,
min(price_usd) as least_paid,
sum(price_usd) as total_paid
from
ethereum.core.ez_nft_sales
where
---- put the nft projects here
nft_address in (
lower('0xCcc441ac31f02cD96C153DB6fd5Fe0a2F4e6A68d'),
lower('0x1AFEF6b252cc35Ec061eFe6a9676C90915a73F18'),
lower('0xe51Aac67b09EaEd6d3D43e794D6bAe679Cbe09D8'),
lower('0x6faD73936527D2a82AEA5384D252462941B44042'),
lower('0x575EC01a9e70bf3e192a774Eb265c46ec993E4CC'),
lower('0x35471f47c3C0BC5FC75025b97A19ECDDe00F78f8'),
lower('0xaAF03a65CbD8f01b512Cd8d530a675b3963dE255'),
lower('0x020cdC4775366aE436f13A7D333143432e884934'),
lower('0x26437d312fB36BdD7AC9F322A6D4cCFe0c4FA313'),
lower('0xD0318da435DbcE0B347cc6faA330B5A9889e3585'),
lower('0x86599B800E23036D761f43D7516092447295659f'),
lower('0x96bE46c50E882dbd373081d08E0CDE2B055Adf6c')
)
----
group by 1,2
),
sales as
(
select
nft_address as contract_address,
seller_address as wallet,
Run a query to Download Data