mansaPool addresses
Updated 2022-07-17
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
›
⌄
SELECT
sum(case when CONTRACT_ADDRESS = lower('0x4F7ebc19844259386DBdDB7b2eB759eeFc6F8353') then +1 end) as StableV1AMM_USDC_DAI,
sum(case when CONTRACT_ADDRESS = lower('0xd16232ad60188B68076a235c65d692090caba155') then +1 end) as StableV1AMM_USDC_sUSD,
sum(case when CONTRACT_ADDRESS = lower('0x79c912FEF520be002c2B6e57EC4324e260f38E50') then +1 end) as VolatileV1AMM_WETH_USDC,
sum(case when CONTRACT_ADDRESS = lower('0x47029bc8f5CBe3b464004E87eF9c9419a48018cd') then +1 end) as VolatileV1AMM_OP_USDC,
sum(case when CONTRACT_ADDRESS = lower('0xFd7FddFc0A729eCF45fB6B12fA3B71A575E1966F') then +1 end) as StableV1AMM_WETH_sETH,
sum(case when CONTRACT_ADDRESS = lower('0xd62C9D8a3D4fd98b27CaaEfE3571782a3aF0a737') then +1 end) as StableV1AMM_USDC_MAI,
sum(case when CONTRACT_ADDRESS = lower('0xAdF902b11e4ad36B227B84d856B229258b0b0465') then +1 end) as StableV1AMM_FRAX_USDC,
sum(case when CONTRACT_ADDRESS = lower('0xe8537b6FF1039CB9eD0B71713f697DDbaDBb717d') then +1 end) as VolatileV1AMM_VELO_USDC,
sum(case when CONTRACT_ADDRESS = lower('0x207AddB05C548F262219f6bFC6e11c02d0f7fDbe') then +1 end) as StableV1AMM_USDC_LUSD,
sum(case when CONTRACT_ADDRESS = lower('0x587233CE63D7C1e081Ce9D94d9940544758f6D01') then +1 end) as VolatileV1AMM_FRAX_USDC,
sum(case when CONTRACT_ADDRESS = lower('0xEc24EB97cEc2F0F6A2D61254990B0f163BbbFe1d') then +1 end) as StableV1AMM_sUSD_DAI,
sum(case when CONTRACT_ADDRESS = lower('0x6fD5BEe1Ddb4dbBB0b7368B080Ab99b8BA765902') then +1 end) as StableV1AMM_alETH_WETH,
sum(case when CONTRACT_ADDRESS = lower('0x6C5019D345Ec05004A7E7B0623A91a0D9B8D590d') then +1 end) as StableV1AMM_USDC_DOLA,
sum(case when CONTRACT_ADDRESS = lower('0xe75a3f4Bf99882aD9f8aeBAB2115873315425D00') then +1 end) as StableV1AMM_USDC_alUSD,
sum(case when CONTRACT_ADDRESS = lower('0xFFD74EF185989BFF8752c818A53a47FC45388F08') then +1 end) as VolatileV1AMM_VELO_OP,
sum(case when CONTRACT_ADDRESS = lower('0xDEE1856D7B75Abf4C1bDf986da4e1C6c7864d640') then +1 end) as VolatileV1AMM_LYRA_USDC,
sum(case when CONTRACT_ADDRESS = lower('0x43Ce87A1ad20277b78CAE52C7bCD5FC82A297551') then +1 end) as VolatileV1AMM_WETH_DOLA,
sum(case when CONTRACT_ADDRESS = lower('0x9C8a59934fbA9aF82674EFf5D13a24e7c7E7A1f1') then +1 end) as VolatileV1AMM_USDC_PERP,
sum(case when CONTRACT_ADDRESS = lower('0x9355292f66552ea5717B274d27EEFc8254011d83') then +1 end) as VolatileV1AMM_THALES_USDC,
sum(case when CONTRACT_ADDRESS = lower('0x43C3f2d0aA0EbC433d654BB6ebf67F0C03f8D8d9') then +1 end) as VolatileV1AMM_OP_DAI,
sum(case when CONTRACT_ADDRESS = lower('0x588443c932b45F47e936b969eB5AA6b5Fd4F3369') then +1 end) as VolatileV1AMM_HND_USDC,
sum(case when CONTRACT_ADDRESS = lower('0xc2058Aa3b3f96075cC33946bcd1963bfa660315b') then +1 end) as VolatileV1AMM_sUSD_DAI,
sum(case when CONTRACT_ADDRESS = lower('0xaC49498B97312A6716EF312F389B7e4D183A2A7C') then +1 end) as StableV1AMM_FRAX_sUSD,
sum(case when CONTRACT_ADDRESS = lower('0xE2EA57FDF87624f4384EF6Da5f3844e8E9e5d878') then +1 end) as VolatileV1AMM_FRAX_FXS,
sum(case when CONTRACT_ADDRESS = lower('0xcdd41009E74bD1AE4F7B2EeCF892e4bC718b9302') then +1 end) as VolatileV1AMM_WETH_OP,
sum(case when CONTRACT_ADDRESS = lower('0xffB6c35960b23989037C8c391faCebC8a17De970') then +1 end) as VolatileV1AMM_WETH_SNX,
sum(case when CONTRACT_ADDRESS = lower('0x85FF5b70de43FeE34F3fA632adDD9F76a0f6bAA9') then +1 end) as VolatileV1AMM_SNX_sUSD,
sum(case when CONTRACT_ADDRESS = lower('0x986d353A3700530BE4e75794830f57e657bc68cB') then +1 end) as VolatileV1AMM_FRAX_OP,
sum(case when CONTRACT_ADDRESS = lower('0xFDAd8F85C0f3895C85301F549d124cE526479bf8') then +1 end) as StableV1AMM_WBTC_renBTC,
sum(case when CONTRACT_ADDRESS = lower('0x06141423DCF1A5a4C137039063aC873cDC1E363A') then +1 end) as VolatileV1AMM_VELO_WETH,
sum(case when CONTRACT_ADDRESS = lower('0xaC49498B97312A6716EF312F389B7e4D183A2A7C') then +1 end) as StableV1AMM_FRAX_sUSD,
sum(case when CONTRACT_ADDRESS = lower('0x4C8B195d33c6F95A8262D56Ede793611ee7b5AAD') then +1 end) as VolatileV1AMM_WBTC_USDC,
sum(case when CONTRACT_ADDRESS = lower('0xe8633Ce5d216EBfDdDF6875067DFb8397dedcaF3') then +1 end) as StableV1AMM_OP_USDC,
sum(case when CONTRACT_ADDRESS = lower('0x335Bd4ffA921160fC86cE3843f80A9941E7456c6') then +1 end) as StableV1_AMM_VELO_USDC
Run a query to Download Data