CoinConverseVelodrome Locks most often voted pool daily num voting
Updated 2022-07-16
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
›
⌄
with top_10 as (select CONCAT('0x', SUBSTRING(INPUT_DATA, 291, 40)) AS pool_address, case when pool_address = '0xe8537b6ff1039cb9ed0b71713f697ddbadbb717d' then 'VolatileV1 AMM - VELO/USDC'
when pool_address = '0x47029bc8f5cbe3b464004e87ef9c9419a48018cd' then 'VolatileV1 AMM - OP/USDC'
when pool_address = '0xd16232ad60188b68076a235c65d692090caba155' then 'StableV1 AMM - USDC/sUSD'
when pool_address = '0xffd74ef185989bff8752c818a53a47fc45388f08' then 'VolatileV1 AMM - VELO/OP'
when pool_address = '0x79c912fef520be002c2b6e57ec4324e260f38e50' then 'VolatileV1 AMM - WETH/USDC'
when pool_address = '0xfd7fddfc0a729ecf45fb6b12fa3b71a575e1966f' then 'StableV1 AMM - WETH/sETH'
when pool_address = '0x4f7ebc19844259386dbddb7b2eb759eefc6f8353' then 'StableV1 AMM - USDC/DAI'
when pool_address = '0x207addb05c548f262219f6bfc6e11c02d0f7fdbe' then 'StableV1 AMM - USDC/LUSD'
when pool_address = '0x9355292f66552ea5717b274d27eefc8254011d83' then 'VolatileV1 AMM - THALES/USDC'
when pool_address = '0xcdd41009e74bd1ae4f7b2eecf892e4bc718b9302' then 'VolatileV1 AMM - WETH/OP' end as pool_name, count(tx_hash) as num_txs
from optimism.core.fact_transactions
where origin_function_signature = '0x7ac09bf7'
and to_address = '0x09236cff45047dbee6b921e00704bed6d6b8cf7e'
group by 1, 2
order by num_txs desc
limit 10)
select block_timestamp::date as dt, CONCAT('0x', SUBSTRING(INPUT_DATA, 291, 40)) AS pool_address, case when pool_address = '0xe8537b6ff1039cb9ed0b71713f697ddbadbb717d' then 'VolatileV1 AMM - VELO/USDC'
when pool_address = '0x47029bc8f5cbe3b464004e87ef9c9419a48018cd' then 'VolatileV1 AMM - OP/USDC'
when pool_address = '0xd16232ad60188b68076a235c65d692090caba155' then 'StableV1 AMM - USDC/sUSD'
when pool_address = '0xffd74ef185989bff8752c818a53a47fc45388f08' then 'VolatileV1 AMM - VELO/OP'
when pool_address = '0x79c912fef520be002c2b6e57ec4324e260f38e50' then 'VolatileV1 AMM - WETH/USDC'
when pool_address = '0xfd7fddfc0a729ecf45fb6b12fa3b71a575e1966f' then 'StableV1 AMM - WETH/sETH'
when pool_address = '0x4f7ebc19844259386dbddb7b2eb759eefc6f8353' then 'StableV1 AMM - USDC/DAI'
when pool_address = '0x207addb05c548f262219f6bfc6e11c02d0f7fdbe' then 'StableV1 AMM - USDC/LUSD'
when pool_address = '0x9355292f66552ea5717b274d27eefc8254011d83' then 'VolatileV1 AMM - THALES/USDC'
when pool_address = '0xcdd41009e74bd1ae4f7b2eecf892e4bc718b9302' then 'VolatileV1 AMM - WETH/OP' end as pool_name, count(tx_hash) as num_txs
from optimism.core.fact_transactions
where origin_function_signature = '0x7ac09bf7'
and to_address = '0x09236cff45047dbee6b921e00704bed6d6b8cf7e'
and pool_address in (select pool_address from top_10)
group by 1, 2, 3
Run a query to Download Data