campکیف پول ها با توکن های قفل شده خود بیشتر به کدام استخرها رأی می دهند؟
    Updated 2022-07-17
    -- Which pools are wallets voting for with their locked tokens most often?
    SELECT

    COUNT (DISTINCT TX_HASH) as number_of_transaction,
    COUNT (DISTINCT FROM_ADDRESS) as number_of_wallets,
    CASE CONCAT('0x', SUBSTR(INPUT_DATA :: STRING, 291, 40))
    WHEN LOWER('0x4F7ebc19844259386DBdDB7b2eB759eeFc6F8353') THEN 'StableV1 AMM - USDC/DAI'
    WHEN LOWER('0xd16232ad60188B68076a235c65d692090caba155') THEN 'StableV1 AMM - USDC/sUSD'
    WHEN LOWER('0x79c912FEF520be002c2B6e57EC4324e260f38E50') THEN 'VolatileV1 AMM - WETH/USDC'
    WHEN LOWER('0x47029bc8f5CBe3b464004E87eF9c9419a48018cd') THEN 'VolatileV1 AMM - OP/USDC'
    WHEN LOWER('0xFd7FddFc0A729eCF45fB6B12fA3B71A575E1966F') THEN 'StableV1 AMM - WETH/sETH'
    WHEN LOWER('0xd62C9D8a3D4fd98b27CaaEfE3571782a3aF0a737') THEN 'StableV1 AMM - USDC/MAI'
    WHEN LOWER('0xAdF902b11e4ad36B227B84d856B229258b0b0465') THEN 'StableV1 AMM - FRAX/USDC'
    WHEN LOWER('0xe8537b6FF1039CB9eD0B71713f697DDbaDBb717d') THEN 'VolatileV1 AMM - VELO/USDC'
    WHEN LOWER('0x207AddB05C548F262219f6bFC6e11c02d0f7fDbe') THEN 'StableV1 AMM - USDC/LUSD'
    WHEN LOWER('0x587233CE63D7C1e081Ce9D94d9940544758f6D01') THEN 'VolatileV1 AMM - FRAX/USDC'
    WHEN LOWER('0xEc24EB97cEc2F0F6A2D61254990B0f163BbbFe1d') THEN 'StableV1 AMM - sUSD/DAI'
    WHEN LOWER('0x6fD5BEe1Ddb4dbBB0b7368B080Ab99b8BA765902') THEN 'StableV1 AMM - alETH/WETH'
    WHEN LOWER('0x6C5019D345Ec05004A7E7B0623A91a0D9B8D590d') THEN 'StableV1 AMM - USDC/DOLA'
    WHEN LOWER('0xe75a3f4Bf99882aD9f8aeBAB2115873315425D00') THEN 'StableV1 AMM - USDC/alUSD'
    WHEN LOWER('0xFFD74EF185989BFF8752c818A53a47FC45388F08') THEN 'VolatileV1 AMM - VELO/OP'
    WHEN LOWER('0xDEE1856D7B75Abf4C1bDf986da4e1C6c7864d640') THEN 'VolatileV1 AMM - LYRA/USDC'
    WHEN LOWER('0x43Ce87A1ad20277b78CAE52C7bCD5FC82A297551') THEN 'VolatileV1 AMM - WETH/DOLA'
    WHEN LOWER('0x9C8a59934fbA9aF82674EFf5D13a24e7c7E7A1f1') THEN 'VolatileV1 AMM - USDC/PERP'
    WHEN LOWER('0x9355292f66552ea5717B274d27EEFc8254011d83') THEN 'VolatileV1 AMM - THALES/USDC'
    WHEN LOWER('0x43C3f2d0aA0EbC433d654BB6ebf67F0C03f8D8d9') THEN 'VolatileV1 AMM - OP/DAI'
    WHEN LOWER('0x588443c932b45F47e936b969eB5AA6b5Fd4F3369') THEN 'VolatileV1 AMM - HND/USDC'
    WHEN LOWER('0xc2058Aa3b3f96075cC33946bcd1963bfa660315b') THEN 'VolatileV1 AMM - sUSD/DAI'
    WHEN LOWER('0xaC49498B97312A6716EF312F389B7e4D183A2A7C') THEN 'StableV1 AMM - FRAX/sUSD'
    WHEN LOWER('0xE2EA57FDF87624f4384EF6Da5f3844e8E9e5d878') THEN 'VolatileV1 AMM - FRAX/FXS'
    WHEN LOWER('0xcdd41009E74bD1AE4F7B2EeCF892e4bC718b9302') THEN 'VolatileV1 AMM - WETH/OP'
    WHEN LOWER('0xffB6c35960b23989037C8c391faCebC8a17De970') THEN 'VolatileV1 AMM - WETH/SNX'
    WHEN LOWER('0x85FF5b70de43FeE34F3fA632adDD9F76a0f6bAA9') THEN 'VolatileV1 AMM - SNX/sUSD'
    WHEN LOWER('0x986d353A3700530BE4e75794830f57e657bc68cB') THEN 'VolatileV1 AMM - FRAX/OP'
    WHEN LOWER('0xFDAd8F85C0f3895C85301F549d124cE526479bf8') THEN 'StableV1 AMM - WBTC/renBTC'
    WHEN LOWER('0x06141423DCF1A5a4C137039063aC873cDC1E363A') THEN 'VolatileV1 AMM - VELO/WETH'
    Run a query to Download Data