flipside

    Price Analysis
    feyikemiPrice Analysis
    Updated 2025-03-23
    WITH BlackDragon as (
    WITH json as (
    SELECT
    livequery.live.udf_api(
    'https://api.coingecko.com/api/v3/coins/markets?vs_currency=usd&ids=black-dragon&order=market_cap_desc&per_page=100&page=1&sparkline=false&locale=en'
    ) as resp
    )

    SELECT
    value:current_price as current_price,
    value : ath as ATH,
    value : atl as ATL,
    value:price_change_percentage_24h as price_change_percentage_24h,
    value:market_cap as market_cap,
    value:total_supply as total_supply,
    value:circulating_supply as circulating_supply,
    value : fully_diluted_valuation as FDV
    FROM json,
    LATERAL FLATTEN(input => json.resp:data) as value
    )

    SELECT
    current_price,
    ATH,
    ATL,
    round(price_change_percentage_24h, 2) as price_change_percentage_24h,
    round(market_cap, 2) as Marketcap,
    total_supply as TotalSupply,
    circulating_supply as CirculatingSupply,
    FDV
    FROM BlackDragon
    Last run: 2 months ago
    CURRENT_PRICE
    ATH
    ATL
    PRICE_CHANGE_PERCENTAGE_24H
    MARKETCAP
    TOTALSUPPLY
    CIRCULATINGSUPPLY
    FDV
    1
    1.9677e-8
    1.44374e-7
    8.555e-9
    		1.21524594
    77596600000000.1
    77596600000000.1
    1524594
    1
    87B
    2s