kiacryptotype of pools
Updated 2022-08-26
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
›
⌄
-- creddit to 0xHaM☰d#8391
With main_pools_Reserve as (
select column1 AS token, column2 AS Contract
from ( VALUES
('Sol', '8PbodeaosQP19SjYFx855UMqWxH2HynZLdBXmsrbac36')
,('USDC','BgxfHJDzm44T7XG68MYKx7YisTjZu73tVovyZSjJMpmw')
,('soETH', '3PArRsZQ6SLkr1WERZWyC6AqsajtALMq4C66ZMYz4dKQ')
,('BTC','GYzjMCXTDue12eUGKKWAqtF5jcBYNmewr6Db6LaguEaX')
,('SRM', '5suXmvdbKQ98VonxGCXqViuWRu8k4zgZRxndYKsH2fJg')
,('USDT', '8K9WC8xoh2rtQNY7iEGXtPvfbDCi563SdWhCAhuMP2xE')
,('soFTT', '2dC4V23zJxuv521iYQj8c471jrxYLNQFaGS6YPwtTHMd')
,('RAY', '9n2exoMQwMTzfw6NFoFFujxYPndWVLtKREJePssrKb36')
,('SBR', 'Hthrt4Lab21Yz1Dx9Q4sFW4WVihdBUTtWRQBjPsYHCor')
,('MER', '5Sb6wDpweg6mtYksPJ2pfGbSyikrhR8Ut8GszcULQ83A')
,('mSOL', 'CCpirWrgNuBVLdkP2haxLTbD6XqEgaYuVXixbbpxUB6')
,('ETH', 'CPDiKagfozERtJ33p7HHhEfJERjvfk1VAjMXAFLrvrKP')
,('SLND', 'CviGNzD2C9ZCMmjDt5DKCce5cLV4Emrcm3NFvwudBFKA')
,('scnSOL', 'DUExYJG5sc1SQdMMdq6LdUYW9ULXbo2fFFTbedywgjNN')
,('stSOL', '5sjkv6HD8wycocJ4tC4U36HHbvgcXYqcyiPRUkncnwWs')
,('UST', 'Ab48bKsiEzdm481mGaNVmv9m9DmXsWWxcYHM588M59Yd')
,('FTT', '8bDyV3N7ctLKoaSVqUoEwUzw6msS2F65yyNPgAVUisKm')
,('USDT-USDC','9mZsd1b9cN7JyqJvkbqhVuTfg8PAuKjuhPxpcsVNjYoC')
,('mSOL-SOL', '6ve8XyELbecPdbzSTsyhYKiWr7wg3JpjfxE1cqoN9qhN')
))
, Isolated_Pools_Reserve as (
select column1 AS token, column2 AS Contract
from ( VALUES
('SOL (TURBO SOL)', 'UTABCRXirrbpCNDogCoqEECtM3V44jXGCsK23ZepV3Z')
,('USDC (TURBO SOL)', 'EjUgEaPpKMg2nqex9obb46gZQ6Ar9mWSdVKbw9A6PyXA')
,('lsIN (Invictus)', '4XYbgZJirfnwjmpJKQgMQEvjncYFi2CsPTFzBguCjCjG')
,('USDC (Invictus)', 'AuT5vA4bScsaJBiyNHnAttKToTCHj4Kwi4sg8bCyPPr8')
,('UST (Invictus)', '7MymBKwTPPMC4A9Ktwc1F2V5Xw7Kj3DqvRYUvLk2SF4h')
,('xSTEP (Step)', 'HH9Aig5MAvMNcivGfAbWU5Da9nfiTwBaYJBK2KZyZppn')
,('STEP (Step)', 'C5ozcRb4PJeJvakPeGgm9bgwcL6rPcKPfV95d2owW86C')
,('SOL (Step)', '7trBAMkVU8dcPQVdScz7VNywZwqnD1rwXkwkVPQJ95bT')
,('USDC (Step)', 'FCU2wpx3ED1dY7bKszzcyxUVNTduLurUEmCGGv2w3Lfm')
Run a query to Download Data