with succeeded_txs as (

select tx_hash as tx

from near.core.fact_transactions

where tx_succeeded=true

),

pools_list as (

select '1207' as pool, 'ETH-wNEAR' as pool_name

union all

select '4179', '4-Pool'--, 'USDt', 'USDC', 'USDT.e', 'USDC.e'

union all

select '1910', '3-Pool'--, 'USDT.e', 'USDC.e', 'DAI',''

union all

select '4512', 'USDC-wNEAR'

union all

select '3879', 'wNEAR-USDt'

union all

select '3', 'USDC.e-wNEAR'

union all

select '4', 'USDT.e-wNEAR'

union all

select '4513', 'USDt-USDC'

union all

select '4514', 'FRAX-USDC'

union all

select '4525', 'FRAX-wNEAR'

union all

select '79', 'wNEAR-REF'

union all

select '3667', 'SWEAT-wNEAR'

union all

select '4314', 'LONK-wNEAR'

union all

select '4276', 'BLACKDRAGON-wNEAR'