bachiNFT project that has gained the most value this year
    Updated 2023-01-05
    with min_date as (
    select
    NFT_ADDRESS,
    min(BLOCK_TIMESTAMP) as Minimum_date
    from
    ethereum.core.ez_nft_sales
    where
    1 = 1
    and PRICE_USD is not NULL
    and EVENT_TYPE = 'sale'
    and BLOCK_TIMESTAMP ilike '2022%'
    group by
    1
    ),
    max_date as (
    select
    NFT_ADDRESS,
    max(BLOCK_TIMESTAMP) as Maximum_date
    from
    ethereum.core.ez_nft_sales
    where
    1 = 1
    and PRICE_USD is not NULL
    and EVENT_TYPE = 'sale'
    and BLOCK_TIMESTAMP ilike '2022%'
    group by
    1
    ),
    first_price as (
    select
    a.NFT_ADDRESS,
    coalesce(
    initcap(project_name),
    initcap(address_name),
    initcap(a.NFT_ADDRESS)
    ) as Project_Name,
    Run a query to Download Data