steven-sabol-dir-of-economyPOLIS Holdings [TX-FROM] [for API][Broader][Newer]
Updated 2024-10-30
999
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
›
⌄
-- forked from POLIS Holdings [TX-FROM] [for API] @ https://flipsidecrypto.xyz/studio/queries/8e08212f-8e83-40ca-b396-0a16ba21a8f1
-- forked from POLIS Holdings [TX-FROM] @ https://flipsidecrypto.xyz/studio/queries/87f0e893-c466-4c3a-bd26-2ee8f743c4c2
WITH WALLET_LIST AS (
select
$1 as ADDRESS,
$2 as NAME,
$3 as ROLE
from
values
-- ('A6LAX8hhGM5U9gbjLfvPo7BDx5EHwpkyGmLSx6TXrt2x','Mint Wallet (Old - Deprecated)','OG Wallet'), -- original mint
-- ('GgYtnDJMHQG4gpVzy2KHukSvHfFJcs1jLXASsBCQE83P','Corporate Treasury','OG Wallet'),
('5MPLVoZ2cJHy8gkvFu9tCTuqu9P8Fm8xz8Swpo6TfjDu','Rewards','Rewards'),
('zuFYna5aq6Bhf9LRj692Udm14VFrUGFM1uDhueVwqbP','Rewards','Rewards'),
('BVJESvrDeXZcSX5UVdK2Tt57Lur9gyakgCfdX45pVQ1V','DAO Rewards','Rewards'),
('2Jo8wqijXveVjra1DAknfoH1imS7XaJqLA1eQF5hzRUE','POLIS Locker Rewards Wallet','Rewards'),
('J5GhV1WKcEU98c1kZt36ixjaErrrPNWbZhg3JQDg114E','ATLAS Locker Rewards','Rewards'),
('3oAYkw4SHTTwgQ9fX5WqZYCBAF1MF1MRUjHaay33hCCv','SA Team Wallet (Locker Participant)','Team'),
-- ('3ENn1UaMpH9u5GSKsMvUBZLCMGa6ahW5vHyDvXcdAzmP','Team Locker Account','Team Locker'),
('2cg6Sbbpxpzk7bd4bGL4s1CHWm28VbDx6VReruKdKvZT','Team','Team'),
--- these are like corporate trading accounts?
('B5hX2Aj8FYmdYjXQFVF1jpz7BkrdpLXgSPs92G6DFGjA','ATMTA Treasury Trades','Team Treasury'),
('BTFfKDtnQoq6UdqNSqDqVieahZvbBunQWLXkTyb59fbW','Corporate Treasury','Team Treasury'),
('7kuKG4MaGvAKXoYRKzaoKqzbJS2oXD8F3bB5QFf1pDqc','Market Making','Liquidity'),
('7UuusqdRCHwdJaKrxuKzP2j6xnYzTtJRxHEGt1xZNEVs','Market Making','Liquidity'),
('A5QxugFH3noahNvYfrF6d2yxdLb5hjHkdvYZTMpk34Gd','Liquidity','Liquidity'),
('AFY3a7gVLcLjBihb8AyakQshZGSCrwhPuzyGx3RuyXJS','Liquidity','Liquidity'),
('u6PJ8DtQuPFnfmwHbGFULQ4u4EgjDiyYKjVEsynXq2w','Gate.io','Liquidity'),
('FWznbcNXWQuHTawe9RxvQ2LdCENssh12dsznf4RiouN5','Kraken Hot Wallet','Liquidity'),
('9cNE6KBg2Xmf34FPMMvzDF8yUHMrgLRzBV3vD7b1JnUS','Kraken Deposit Address','Liquidity'),
QueryRunArchived: QueryRun has been archived