ngxuan885Holders of the Headline NFTs & Token(3)
    Updated 2022-06-16
    with NFTs as (SELECT ASSET_ID, ASSET_NAME,
    CASE WHEN TOTAL_SUPPLY = 1 THEN 'Astros'
    else 'Pixel Astros' end as kind, TOTAL_SUPPLY
    from flipside_prod_db.algorand.asset
    where CREATOR_ADDRESS = 'NIN73GEWDWBU3HHEPGWGIQZMOITN4PU3YVTKMR3ESI7DCH5ME4E5TLB4XU'
    and ASSET_DELETED = FALSE),
    -----------------------------------------------------------------------------------
    initial as ( SELECT kind, min(BLOCK_TIMESTAMP)::date as intial_sale
    from flipside_prod_db.algorand.asset_transfer_transaction t
    JOIN NFTS n on n.ASSET_ID = t.ASSET_ID GROUP by 1)
    -----------------------------------------------------------------------------------
    SELECT BLOCK_HOUR::date as date,
    case WHEN BLOCK_HOUR::date in (SELECT intial_sale from initial) THEN 'launch day'
    else 'ordinary' end as kind,
    avg(PRICE_USD) as price
    from flipside_prod_db.algorand.prices_swap
    where ASSET_ID = '137594422'
    and BLOCK_HOUR::date >= '2021-11-01'
    GROUP by 1,2 order by 1
    Run a query to Download Data