ChiefUsers
Updated 2023-05-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- 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