Updated 2025-02-02
    --------------- Supply------------------
    WITH supply_data AS (
    SELECT
    value:total_supply / POW(10, 18) :: FLOAT AS total_supply
    FROM (SELECT chainbase_utils.get(
    '/v1/token/metadata',
    PARSE_JSON(
    '{"chain_id": 43114, "contract_address": "0xFFFF003a6BAD9b743d658048742935fFFE2b6ED7"}'
    )) AS resp
    ),
    LATERAL FLATTEN(input => resp:data)
    WHERE
    value:total_supply IS NOT NULL
    ),
    ---------------- Price------------------
    price_data AS (
    SELECT AVG(PRICE) AS current_usd_price
    FROM crosschain.price.ez_prices_hourly
    WHERE
    TOKEN_ADDRESS = LOWER('0xFFFF003a6BAD9b743d658048742935fFFE2b6ED7')
    AND HOUR::DATE = CURRENT_DATE
    )
    --------------- Market Cap--------------------
    SELECT
    supply_data.total_supply,
    price_data.current_usd_price,
    supply_data.total_supply * price_data.current_usd_price AS marketcap
    FROM
    supply_data,
    price_data;


    Last run: 13 days ago
    TOTAL_SUPPLY
    CURRENT_USD_PRICE
    MARKETCAP
    1
    10000000000.1389742143138974214.285714
    1
    44B
    24s