flipside

    Total USDC claimed (so far)
    DB_Total USDC claimed (so far)
    Updated 2022-12-21
    SELECT
    'claimed' AS category,
    SUM(raw_amount / 1000000) AS value
    FROM
    ethereum.core.fact_token_transfers
    WHERE
    from_address = LOWER('0x8B799381ac40b838BBA4131ffB26197C432AFe78')

    UNION ALL

    SELECT
    'Unclaimed' AS category,
    5000000 - SUM(raw_amount / 1000000) AS value
    FROM
    ethereum.core.fact_token_transfers
    WHERE
    from_address = LOWER('0x8B799381ac40b838BBA4131ffB26197C432AFe78')

    Run a query to Download Data