hkeyEclipse Sol
    Updated 2024-10-19
    SELECT
    (
    (
    (
    SELECT
    COALESCE(SUM(MINT_AMOUNT), 0)
    FROM
    eclipse.defi.fact_token_mint_actions
    WHERE
    MINT = 'BeRUj3h7BqkbdfFU7FBNYbodgf8GCHodzKvF9aVjNNfL'
    ) - (
    SELECT
    COALESCE(SUM(BURN_AMOUNT), 0)
    FROM
    eclipse.defi.fact_token_burn_actions
    WHERE
    MINT = 'BeRUj3h7BqkbdfFU7FBNYbodgf8GCHodzKvF9aVjNNfL'
    )
    ) / 1e9
    ) * (
    SELECT
    PRICE
    FROM
    solana.price.ez_prices_hourly
    WHERE
    SYMBOL = 'SOL'
    ORDER BY
    HOUR DESC
    LIMIT
    1
    ) AS final_result;
    QueryRunArchived: QueryRun has been archived