gigiokobaonly-white
    Updated 2025-02-06
    WITH supply AS (
    SELECT
    '199999995'::NUMERIC AS circulating_supply,
    '1000000000'::NUMERIC AS maximum_supply,
    price
    FROM solana.price.ez_prices_hourly
    WHERE token_address = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN'
    ORDER BY hour DESC
    LIMIT 1
    )

    SELECT
    circulating_supply * price AS market_cap,
    maximum_supply * price AS fdv
    FROM supply;

    QueryRunArchived: QueryRun has been archived