ChiefUsers
    Updated 2023-05-01
    -- grab all unqiue signers[0]from sub_daos, data_credits, deviced minted, goverance, entity managager
    -- info from: https://docs.helium.com/solana/
    -- hdaoVTCqhfHHo75XdAMxBKdUqvq1i5bF23sisBqVgGR -- sub_daos
    -- hntyVP6YFm1Hg25TN9WGLqM12b8TQmcknKrdu1oxWux -- HNT
    -- iotEVVZLEywoTn1QdwNPddxPWszn3zFhEot3MfL9fns -- IOT
    -- 8K38wjyEXdUX8w6GPida3X9BQhcSJ9fnVjRyUaotkqAs -- MOBILE
    -- circAbx64bbsscPbQzZAUvuXpHqrCe6fLMzc2uKXz9g -- circuit breaker
    -- credMBJhYFzfn7NxBMdU4aUqFggAjgztaCcv2Fo6fPT -- date credits
    -- hemjuPXBpNvggtaUnN1MwT3wrdhttKEfosTcc2P9Pg8 -- entity manager
    -- 1azyuavdMyvsivtNxPoz6SucD18eDHeXzFCUPq5XU7w -- lazy_distributer
    -- treaf4wWBBty3fHdyBpo35Mz84M8k3heKXmjmi9vFt5 -- treasury managment
    -- hvsrNC3NKbcryqDs2DocYHZ9yPKEVzdSjQG6RVtK1s8 -- voter_stake_registry

    total_wallets as (
    SELECT
    DISTINCT e.signers[0] as wallets
    -- CASE
    -- WHEN program_id = 'hdaoVTCqhfHHo75XdAMxBKdUqvq1i5bF23sisBqVgGR' THEN 'sub_daos'
    -- WHEN program_id = 'hntyVP6YFm1Hg25TN9WGLqM12b8TQmcknKrdu1oxWux' THEN 'HNT'
    -- WHEN program_id = 'iotEVVZLEywoTn1QdwNPddxPWszn3zFhEot3MfL9fns' THEN 'IOT'
    -- WHEN program_id = '8K38wjyEXdUX8w6GPida3X9BQhcSJ9fnVjRyUaotkqAs' THEN 'MOBILE'
    -- WHEN program_id = 'credMBJhYFzfn7NxBMdU4aUqFggAjgztaCcv2Fo6fPT' THEN 'data_credits'
    -- WHEN program_id = '1azyuavdMyvsivtNxPoz6SucD18eDHeXzFCUPq5XU7w' THEN 'lazy_distributer'
    -- WHEN program_id = 'treaf4wWBBty3fHdyBpo35Mz84M8k3heKXmjmi9vFt5' THEN 'treasury managment '
    -- WHEN program_id = 'hvsrNC3NKbcryqDs2DocYHZ9yPKEVzdSjQG6RVtK1s8' THEN 'voter_stake_registry'
    -- ELSE NULL
    -- END as Type
    FROM solana.core.fact_events e
    WHERE e.program_id IN (
    'hdaoVTCqhfHHo75XdAMxBKdUqvq1i5bF23sisBqVgGR',
    'hntyVP6YFm1Hg25TN9WGLqM12b8TQmcknKrdu1oxWux',
    'iotEVVZLEywoTn1QdwNPddxPWszn3zFhEot3MfL9fns',
    '8K38wjyEXdUX8w6GPida3X9BQhcSJ9fnVjRyUaotkqAs',
    'hvsrNC3NKbcryqDs2DocYHZ9yPKEVzdSjQG6RVtK1s8',
    '1azyuavdMyvsivtNxPoz6SucD18eDHeXzFCUPq5XU7w',
    'credMBJhYFzfn7NxBMdU4aUqFggAjgztaCcv2Fo6fPT',
    Run a query to Download Data