flipside

    solend 1
    Abolfazl_771025solend 1
    Updated 2022-08-25
    with main_pools as (
    select
    column1 AS token,
    column2 AS contract
    from ( VALUES
    ('Sol', '8PbodeaosQP19SjYFx855UMqWxH2HynZLdBXmsrbac36'),
    ('RAY', '9n2exoMQwMTzfw6NFoFFujxYPndWVLtKREJePssrKb36'),
    ('USDC','BgxfHJDzm44T7XG68MYKx7YisTjZu73tVovyZSjJMpmw'),
    ('BTC','GYzjMCXTDue12eUGKKWAqtF5jcBYNmewr6Db6LaguEaX'),
    ('SRM', '5suXmvdbKQ98VonxGCXqViuWRu8k4zgZRxndYKsH2fJg'),
    ('USDT', '8K9WC8xoh2rtQNY7iEGXtPvfbDCi563SdWhCAhuMP2xE'),
    ('SLND', 'CviGNzD2C9ZCMmjDt5DKCce5cLV4Emrcm3NFvwudBFKA'),
    ('FTT', '8bDyV3N7ctLKoaSVqUoEwUzw6msS2F65yyNPgAVUisKm'),
    ('stSOL', '5sjkv6HD8wycocJ4tC4U36HHbvgcXYqcyiPRUkncnwWs'),
    ('mSOL', 'CCpirWrgNuBVLdkP2haxLTbD6XqEgaYuVXixbbpxUB6'),
    ('ETH', 'CPDiKagfozERtJ33p7HHhEfJERjvfk1VAjMXAFLrvrKP'))
    ),Permissionless_Pools as (
    select
    column1 AS token,
    column2 AS contract
    from ( VALUES
    ('SOL', '4Uzuzwuh1CAV4y6cg9BeQc6U3GU8dHPSJN6dfjmBwuu8'),
    ('USDC', '7xW8MBuRgys1bxaS6sLzUdAQhrrfw6QpLmT1ikmEUF1B'),
    ('mSOL', '4S5TTM7Eig5y8zZPCxiw3GEu8zeDDuHNrUrEE6hHz1rc'),
    ('CRP', 'CiS2rat4VVCwe8QEVaXm1T5LqbKx6var4mazBrxwg7iE'),
    ('DUST', 'R1MGtytnkZqHVJFKwG6HzhUuDbhgLorojGRcdyrGoEL'),
    ('USDC', 'H2d9j9CHZRXUQE2cHpkvnfgg7vMw8ysyALX5dTeT6CQk'),
    ('SOL', '3csx7zsNWT139JgnvQzL3y3UNqjzdZjQRcfBZJo7X6FP'))
    ),Isolated_Pools as (
    select
    column1 AS token,
    column2 AS contract
    from ( VALUES
    ('SOL (TURBO SOL)', 'UTABCRXirrbpCNDogCoqEECtM3V44jXGCsK23ZepV3Z'),
    ('USDC (TURBO SOL)', 'EjUgEaPpKMg2nqex9obb46gZQ6Ar9mWSdVKbw9A6PyXA'),
    ('ATLAS (ATLAS)', '8RX5oDxnydPPsA92epWnyXrrM26w7JgAQoVVt9kbiZwq'),
    Run a query to Download Data