from optimism.core.dim_contracts union

select 'WETH' as token0,'0x4200000000000000000000000000000000000006' as token0_address,18 as token0_decimal,'USDC' as token1,'0x7f5c764cbc14f9669b88837ca1490cca17c31607' as token1_address,6 as token1_decimal,'WETH/USDC' as pair_name ,'0x1E31A2c6e6614273D740358AFFB46beF180EFB7B' as pair_address

from optimism.core.dim_contracts union

select 'CRV' as token0,'0x0994206dfe8de6ec6920ff4d779b0d950605fb53' as token0_address,18 as token0_decimal,'WETH' as token1,'0x4200000000000000000000000000000000000006' as token1_address,18 as token1_decimal,'CRV/WETH' as pair_name ,'0x3e87635b7BF86E62991C1BF2867150eee0C0d65A' as pair_address

from optimism.core.dim_contracts union

select 'WETH' as token0,'0x4200000000000000000000000000000000000006' as token0_address,18 as token0_decimal,'DAI' as token1,'0xda10009cbd5d07dd0cecc66161fc93d7c9000da1' as token1_address,18 as token1_decimal,'WETH/DAI' as pair_name ,'0x249C5A2B55522295500848910550D0539E1d673d' as pair_address

from optimism.core.dim_contracts union

select 'WETH' as token0,'0x4200000000000000000000000000000000000006' as token0_address,18 as token0_decimal,'OP' as token1,'0x4200000000000000000000000000000000000042' as token1_address,18 as token1_decimal,'WETH/OP' as pair_name ,'0xAE8bf5a9cA4e980637526ba1e5B68462D3880D49' as pair_address

from optimism.core.dim_contracts union

select 'WETH' as token0,'0x4200000000000000000000000000000000000006' as token0_address,18 as token0_decimal,'USDT' as token1,'0x94b008aa00579c1307b0ef2c499ad98a8ce58e58' as token1_address,6 as token1_decimal,'WETH/USDT' as pair_name ,'0x3E096286ffd113C51cde56f22361a6849F67A0f1' as pair_address

from optimism.core.dim_contracts union

select 'USDC' as token0,'0x7f5c764cbc14f9669b88837ca1490cca17c31607' as token0_address,6 as token0_decimal,'DAI' as token1,'0xda10009cbd5d07dd0cecc66161fc93d7c9000da1' as token1_address,18 as token1_decimal,'USDC/DAI' as pair_name ,'0x5231C20AF03fD827005E652AFee1B6576589F968' as pair_address

from optimism.core.dim_contracts union

select 'WETH' as token0,'0x4200000000000000000000000000000000000006' as token0_address,18 as token0_decimal,'USDC' as token1,'0x7f5c764cbc14f9669b88837ca1490cca17c31607' as token1_address,6 as token1_decimal,'WETH/USDC' as pair_name ,'0xf5484AD6c3a69C0ff33dfEd4Fdf5A4c7EEa13634' as pair_address

from optimism.core.dim_contracts union

select 'OP' as token0,'0x4200000000000000000000000000000000000042' as token0_address,18 as token0_decimal,'USDC' as token1,'0x7f5c764cbc14f9669b88837ca1490cca17c31607' as token1_address,6 as token1_decimal , 'OP/USDC' as pair_name ,'0x8C02104f6f5C60957318455CDc2c5e7db207aE47' as pair_address

from optimism.core.dim_contracts union

select 'WETH' as token0,'0x4200000000000000000000000000000000000006' as token0_address,18 as token0_decimal,'USDC' as token1,'0x7f5c764cbc14f9669b88837ca1490cca17c31607' as token1_address,6 as token1_address,'WETH/USDC ' as pair_name , '0x7086622E6Db990385B102D79CB1218947fb549a9' as pair_address

from optimism.core.dim_contracts union

select 'WETH' as token0,'0x4200000000000000000000000000000000000006' as token0_address,18 as token0_decimal,'USDC' as token1,'0x7f5c764cbc14f9669b88837ca1490cca17c31607' as token1_address,6 as token1_address,'WETH/USDC ' as pair_name , '0xc3FAfa11DC8555d1404e7a1046019fF892bDA2B7' as pair_address

from optimism.core.dim_contracts union

select 'USDC' as token0,'0x7f5c764cbc14f9669b88837ca1490cca17c31607' as token0_address,6 as token0_decimal,'DAI' as token1,'0xda10009cbd5d07dd0cecc66161fc93d7c9000da1' as token1_address,18 as token1_address,'USDC/DAI ' as pair_name , '0x67A381D449750056f3250c73161da1365dce8781' as pair_address

from optimism.core.dim_contracts union

select 'WETH' as token0,'0x4200000000000000000000000000000000000006' as token0_address,18 as token0_decimal,'USDC' as token1,'0x7f5c764cbc14f9669b88837ca1490cca17c31607' as token1_address,6 as token1_address,'WETH/USDC ' as pair_name , '0x11B072C5259ebd68E888a79c49BFff0BcF742983' as pair_address

from optimism.core.dim_contracts union

select 'WETH' as token0,'0x4200000000000000000000000000000000000006' as token0_address,18 as token0_decimal,'sSDC' as token1,'0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9' as token1_address,18 as token1_address,'WETH/sSDC ' as pair_name , '0x7170BD6f5Ab1aC44a1ba7a0Beb5f3f06c2D4a898' as pair_address

from optimism.core.dim_contracts union

select 'OP ' as token0 ,'0x4200000000000000000000000000000000000042' as token0_address,18 as token0_decimal,'USDC' as token1,'0x7f5c764cbc14f9669b88837ca1490cca17c31607' as token1_address,6 as token1_address,'OP/USDC ' as pair_name , '0x3b3fADBbB82530408Ec67a9F3a314b51B5B65574' as pair_address

from optimism.core.dim_contracts union

select 'OP ' as token0 ,'0x4200000000000000000000000000000000000042' as token0_address,18 as token0_decimal,'sSDC' as token1,'0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9' as token1_address,18 as token1_address,'OP/sSDC ' as pair_name , '0x0e736045CF438d813848ffD7C9f1443dAC3E2A3D' as pair_address

from optimism.core.dim_contracts union

select 'WETH' as token0,'0x4200000000000000000000000000000000000006' as token0_address,18 as token0_decimal,'WBTC' as token1,'0x68f180fcce6836688e9084f035309e29bf0a2095' as token1_address,8 as token1_address,'WETH/WBTC ' as pair_name , '0x19847400661159f297cbEf8a6fe567dd89a44BED' as pair_address

from optimism.core.dim_contracts union

select 'USDC ' as token0 , '0x7f5c764cbc14f9669b88837ca1490cca17c31607' as token0_address,6 as token0_decimal,'USDT' as token1,'0x94b008aa00579c1307b0ef2c499ad98a8ce58e58' as token1_address,6 as token1_address,'USDC/USDT ' as pair_name , '0x5F46F0f03db438459D4CDaFb61826061a93504FC' as pair_address

from optimism.core.dim_contracts union