flipside

    account that only have COSG
    arctic-night-foxaccount that only have COSG
    Updated 2022-07-15
    WITH COSG_holders as (

    SELECT
    ADDRESS,
    SUM(AMOUNT) as sum_amount
    FROM
    flipside_prod_db.algorand.account_asset

    WHERE ASSET_ID = '571576867'
    GROUP BY ADDRESS
    HAVING sum_amount > 1)

    SELECT
    COUNT (ADDRESS) as COSG_holder
    FROM
    COSG_holders
    Run a query to Download Data