binhachonSwap Pairs on Optimism
    Updated 2022-07-17
    with json as (
    select
    parse_json('[
    {
    "POOL_ADDRESS": "0x1ffa8f0e0d11f0d0aefb155c54bd5b02573d3a5f",
    "TOKEN0": "0xe265fc71d45fd791c9ebf3ee0a53fbb220eb8f75",
    "TOKEN0_SYMBOL": "DDD",
    "TOKEN0_DECIMALS": "18",
    "TOKEN1": "0x4200000000000000000000000000000000000006",
    "TOKEN1_SYMBOL": "WETH",
    "TOKEN1_DECIMALS": "18"
    },
    {
    "POOL_ADDRESS": "0x5f46f0f03db438459d4cdafb61826061a93504fc",
    "TOKEN0": "0x94b008aa00579c1307b0ef2c499ad98a8ce58e58",
    "TOKEN0_SYMBOL": "USDT",
    "TOKEN0_DECIMALS": "6",
    "TOKEN1": "0x7f5c764cbc14f9669b88837ca1490cca17c31607",
    "TOKEN1_SYMBOL": "USDC",
    "TOKEN1_DECIMALS": "6"
    },
    {
    "POOL_ADDRESS": "0x3e096286ffd113c51cde56f22361a6849f67a0f1",
    "TOKEN0": "0x94b008aa00579c1307b0ef2c499ad98a8ce58e58",
    "TOKEN0_SYMBOL": "USDT",
    "TOKEN0_DECIMALS": "6",
    "TOKEN1": "0x4200000000000000000000000000000000000006",
    "TOKEN1_SYMBOL": "WETH",
    "TOKEN1_DECIMALS": "18"
    },
    {
    "POOL_ADDRESS": "0x7559aa3c295cb0db37c1d5780de3d3f865d95131",
    "TOKEN0": "0x94b008aa00579c1307b0ef2c499ad98a8ce58e58",
    "TOKEN0_SYMBOL": "USDT",
    "TOKEN0_DECIMALS": "6",
    "TOKEN1": "0xda10009cbd5d07dd0cecc66161fc93d7c9000da1",
    Run a query to Download Data