case

when input_data ilike '%047029bc8f5cbe3b464004e87ef9c9419a48018cd%' then ' OP/USDC' when input_data ilike '%0fd7fddfc0a729ecf45fb6b12fa3b71a575e1966f%' then ' WETH/sETH'

when input_data ilike '%0ffd74ef185989bff8752c818a53a47fc45388f08%' then ' VELO/OP' when input_data ilike '%085ff5b70de43fee34f3fa632addd9f76a0f6baa9%' then ' SNX/sUSD'

when input_data ilike '%0e8537b6ff1039cb9ed0b71713f697ddbadbb717d%' then ' VELO/USDC' when input_data ilike '%0adf902b11e4ad36b227b84d856b229258b0b0465%' then ' FRAX/USDC'

when input_data ilike '%0d16232ad60188b68076a235c65d692090caba155%' then ' USDC/USD' when input_data ilike '%079c912fef520be002c2b6e57ec4324e260f38e5%' then ' WETH/USDC'

when input_data ilike '%04f7ebc19844259386dbddb7b2eb759eefc6f8353%' then ' USDC/DAI' when input_data ilike '%06fd5bee1ddb4dbbb0b7368b080ab99b8ba765902%' then ' alETH/WETH'

when input_data ilike '%0207addb05c548f262219f6bfc6e11c02d0f7fdbe%' then ' USDC/LUSD'when input_data ilike '%0fdad8f85c0f3895c85301f549d124ce526479bf8%' then ' WBTC/renBTC'

when input_data ilike '%0335bd4ffa921160fc86ce3843f80a9941e7456c6%' then ' VELO/USDC'when input_data ilike '%0cdd41009e74bd1ae4f7b2eecf892e4bc718b9302%' then ' WETH/OP'

when input_data ilike '%006141423dcf1a5a4c137039063ac873cdc1e363a%' then ' VELO/WETH'when input_data ilike '%0cdd41009e74bd1ae4f7b2eecf892e4bc718b9302%' then ' WETH/OP'

end as pool_name,

case

when input_data ilike '%047029bc8f5cbe3b464004e87ef9c9419a48018cd%' then 'Volatile ' when input_data ilike '%0fd7fddfc0a729ecf45fb6b12fa3b71a575e1966f%' then 'Stable '

when input_data ilike '%0ffd74ef185989bff8752c818a53a47fc45388f08%' then 'Volatile ' when input_data ilike '%085ff5b70de43fee34f3fa632addd9f76a0f6baa9%' then 'Volatile '

when input_data ilike '%0e8537b6ff1039cb9ed0b71713f697ddbadbb717d%' then 'Volatile ' when input_data ilike '%0adf902b11e4ad36b227b84d856b229258b0b0465%' then 'Stable '

when input_data ilike '%0d16232ad60188b68076a235c65d692090caba155%' then 'Stable ' when input_data ilike '%079c912fef520be002c2b6e57ec4324e260f38e5%' then 'Volatile '

when input_data ilike '%04f7ebc19844259386dbddb7b2eb759eefc6f8353%' then 'Stable ' when input_data ilike '%06fd5bee1ddb4dbbb0b7368b080ab99b8ba765902%' then 'Stable '

when input_data ilike '%0207addb05c548f262219f6bfc6e11c02d0f7fdbe%' then 'Stable 'when input_data ilike '%0fdad8f85c0f3895c85301f549d124ce526479bf8%' then 'Stable '

when input_data ilike '%0335bd4ffa921160fc86ce3843f80a9941e7456c6%' then 'Stable 'when input_data ilike '%0cdd41009e74bd1ae4f7b2eecf892e4bc718b9302%' then 'Volatile '

when input_data ilike '%006141423dcf1a5a4c137039063ac873cdc1e363a%' then 'Volatile 'when input_data ilike '%0cdd41009e74bd1ae4f7b2eecf892e4bc718b9302%' then 'Volatile '

end as pool_type,

count (distinct tx_hash) as transactions

from optimism.core.fact_transactions

where to_address ='0x09236cff45047dbee6b921e00704bed6d6b8cf7e'

and origin_function_signature ='0x7ac09bf7'

group by 1,2 having pool_type is not null

order by 2 desc

limit 10