nsa2000nfts8
Updated 2023-01-05
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
›
⌄
---credit to Ali3N: https://app.flipsidecrypto.com/dashboard/RH4QME
with mintable as (
select nft_address,
min (date_trunc(month,block_timestamp)) as mindate
from ethereum.core.ez_nft_sales
where block_timestamp::date >= '2022-01-01' and block_timestamp::date < '2023-01-01'
group by 1),
maxtable as (
select nft_address,
max (date_trunc(month,block_timestamp)) as maxdate
from ethereum.core.ez_nft_sales
where block_timestamp::date >= '2022-01-01' and block_timestamp::date < '2023-01-01'
group by 1),
previous_table as (
select t1.nft_address,
coalesce (initcap(project_name),initcap(address_name),initcap(t1.nft_address)) as Project_Title,
median (price_usd) as Previous_Price
from ethereum.core.ez_nft_sales t1 left outer join ethereum.core.dim_labels t2 on t1.nft_address = t2.address
join mintable t3 on t1.nft_address = t3.nft_address
where price_usd > 0
and date_trunc(month,block_timestamp) = mindate
group by 1,2)
select Project_Title,
case when project_title = '0x45b5e0a3c6dae8c8170fd78268f807758226b67f' then 'AnifruktNFT (AFT)'
when project_title = '0x6d1b09ae12adeaa3aa5d6b574dbcfaf7343a0b04' then 'Space Eggs (SPACE EGGS)'
when project_title = '0x3f427073af2e9a26b0d5897435af9edd8b00efa6' then 'Ethnology (ETL)'
when project_title = '0xb77bb4bda2e4cfec036f214594e758ac380d0f45' then 'Cool Cats Research Lab (CCLAB)'
when project_title = '0xf22b1af401ff439728f426190e0b3e7b354ff9fa' then 'Gates Of Oxya - Colony (GoOC)'
when project_title = '0x4483fcb6c4ba5614b5a3b9a2ebf2410901ebe507' then 'MKSM'
when project_title = '0x8d25f9f4cd1c42d817e619f334848db47ccc8dca' then 'Tiny Tears (CRY)'
when project_title = '0xa18cb1cdeb75eda5ad4a0922331723451dbcf5ed' then 'TheSaudisGoblin (TSG)'
when project_title = '0x7a48e016122b4786e3b96414598fc608c8dc3ad4' then 'Hype Pass (HYPE)'
when project_title = '0x4a33f4f14989f5841a0807166bc43a7a7ec17c0c' then '0xy Utility Token'
Run a query to Download Data