flipside

    The number of holders of each token
    rezarwzThe number of holders of each token
    Updated 2022-10-27
    SELECT
    PROJECT_NAME,
    count(DISTINCT bl.ADDRESS) as number_of_holders
    FROM osmosis.core.fact_daily_balances bl inner join osmosis.core.dim_labels lb on lb.address=bl.currency
    where date=CURRENT_DATE-1
    GROUP by 1
    Run a query to Download Data