trader_wawaStable Balances - Tokens In Pools
    Updated 2022-11-20
    WITH contracts (pool_address, pool_name, type, protocol, token_address, token, decimals,index) AS
    (SELECT '0x2a8a315e82f85d1f0658c5d66a452bbdd9356783','USDC-USDC.e_JoeV1','Stables','trader_joe','0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e','USDC','1e6',1 UNION ALL
    SELECT '0x2a8a315e82f85d1f0658c5d66a452bbdd9356783','USDC-USDC.e_JoeV1','Stables','trader_joe','0xa7d7079b0fead91f3e65f86e8915cb59c1a4c664','USDC.e','1e6',2 UNION ALL
    SELECT '0x74b651eff97871ea99fcc14423e611d85eb0ea93','USDT-USDT.e_JoeV1','Stables','trader_joe','0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7','USDT','1e6',3 UNION ALL
    SELECT '0x74b651eff97871ea99fcc14423e611d85eb0ea93','USDT-USDT.e_JoeV1','Stables','trader_joe','0xc7198437980c041c805a1edcba50c1ce5db95118','USDT.e','1e6',4 UNION ALL
    SELECT '0xfe15c2695f1f920da45c30aae47d11de51007af9','WETH.e-WAVAX_JoeV1','major','trader_joe','0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab','WETH.e','1e18',5 UNION ALL
    SELECT '0xfe15c2695f1f920da45c30aae47d11de51007af9','WETH.e-WAVAX_JoeV1','major','trader_joe','0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7','WAVAX','1e18',6 UNION ALL
    SELECT '0xa389f9430876455c36478deea9769b7ca4e3ddb1','USDC.e-WAVAX_JoeV1','major','trader_joe','0xa7d7079b0fead91f3e65f86e8915cb59c1a4c664','USDC.e','1e6',7 UNION ALL
    SELECT '0xa389f9430876455c36478deea9769b7ca4e3ddb1','USDC.e-WAVAX_JoeV1','major','trader_joe','0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7','WAVAX','1e18',8 UNION ALL
    SELECT '0xbb4646a764358ee93c2a9c4a147d5aded527ab73','USDT-WAVAX_JoeV1','major','trader_joe','0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7','USDT','1e6',9 UNION ALL
    SELECT '0xbb4646a764358ee93c2a9c4a147d5aded527ab73','USDT-WAVAX_JoeV1','major','trader_joe','0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7','WAVAX','1e18',10 UNION ALL
    SELECT '0xd5a37dc5c9a396a03dd1136fc76a1a02b1c88ffa','WBTC.e-WAVAX_JoeV1','major','trader_joe','0x50b7545627a5162f82a992c33b87adc75187b218','WBTC.e','1e8',11 UNION ALL
    SELECT '0xd5a37dc5c9a396a03dd1136fc76a1a02b1c88ffa','WBTC.e-WAVAX_JoeV1','major','trader_joe','0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7','WAVAX','1e18',12 UNION ALL
    SELECT '0x781655d802670bba3c89aebaaea59d3182fd755d','MIM-WAVAX_JoeV1','major','trader_joe','0x130966628846bfd36ff31a822705796e8cb8c18d','MIM','1e18',13 UNION ALL
    SELECT '0x781655d802670bba3c89aebaaea59d3182fd755d','MIM-WAVAX_JoeV1','major','trader_joe','0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7','WAVAX','1e18',14 UNION ALL
    SELECT '0xf4003f4efbe8691b60249e6afbd307abe7758adb','USDC-WAVAX_JoeV1','major','trader_joe','0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e','USDC','1e6',15 UNION ALL
    SELECT '0xf4003f4efbe8691b60249e6afbd307abe7758adb','USDC-WAVAX_JoeV1','major','trader_joe','0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7','WAVAX','1e18',16 UNION ALL
    SELECT '0x2fd81391e30805cc7f2ec827013ce86dc591b806','BTC.b-WAVAX_JoeV1','major','trader_joe','0x152b9d0fdc40c096757f570a51e494bd4b943e50','BTC.b','1e8',17 UNION ALL
    SELECT '0x2fd81391e30805cc7f2ec827013ce86dc591b806','BTC.b-WAVAX_JoeV1','major','trader_joe','0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7','WAVAX','1e18',18 UNION ALL
    SELECT '0x1da20ac34187b2d9c74f729b85acb225d3341b25','YUSD Pool','Stables','curve','0x111111111111ed1d73f860f57b2798b683f2d325','YUSD','1e18',19 UNION ALL
    SELECT '0x1da20ac34187b2d9c74f729b85acb225d3341b25','YUSD Pool','Stables','curve','0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e','USDC','1e6',20 UNION ALL
    SELECT '0x1da20ac34187b2d9c74f729b85acb225d3341b25','YUSD Pool','Stables','curve','0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7','USDT','1e6',21 UNION ALL
    SELECT '0x3a43a5851a3e3e0e25a3c1089670269786be1577','USD_Coin','Stables','curve','0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e','USDC','1e6',22 UNION ALL
    SELECT '0x3a43a5851a3e3e0e25a3c1089670269786be1577','USD_Coin','Stables','curve','0xa7d7079b0fead91f3e65f86e8915cb59c1a4c664','USDC.e','1e6',23 UNION ALL
    SELECT '0x2b80f8fe0064112e7d53880025e7731e246303bc','USDC-USDC.e 1bp_Kyberswap','Stables','kyberswap','0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e','USDC','1e6',23 UNION ALL
    SELECT '0x2b80f8fe0064112e7d53880025e7731e246303bc','USDC-USDC.e 1bp_Kyberswap','Stables','kyberswap','0xa7d7079b0fead91f3e65f86e8915cb59c1a4c664','USDC.e','1e6',24 UNION ALL
    SELECT '0xa83e7eebcf91097d116feacfc0d53ea5e4d03fa7','USDT-USDC 1bp_Kyberswap','Stables','kyberswap','0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7','USDT','1e6',25 UNION ALL
    SELECT '0xa83e7eebcf91097d116feacfc0d53ea5e4d03fa7','USDT-USDC 1bp_Kyberswap','Stables','kyberswap','0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e','USDC','1e6',26 UNION ALL
    SELECT '0x0c3b6ee14cf0eddab91276e7ee71280f6ff61128','USDT-USDT.e 1bp_Kyberswap','Stables','kyberswap','0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7','USDT','1e6',27 UNION ALL
    SELECT '0x0c3b6ee14cf0eddab91276e7ee71280f6ff61128','USDT-USDT.e 1bp_Kyberswap','Stables','kyberswap','0xc7198437980c041c805a1edcba50c1ce5db95118','USDT.e','1e6',28 UNION ALL
    SELECT '0xaef735b1e7ecfaf8209ea46610585817dc0a2e16','PTP_main_vault_USDC','Stables','platypus','0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e','USDC','1e6',29 UNION ALL
    SELECT '0x909b0ce4fac1a0dca78f8ca7430bbafeeca12871','PTP_main_vault-USDC.e','Stables','platypus','0xa7d7079b0fead91f3e65f86e8915cb59c1a4c664','USDC.e','1e6',30 UNION ALL
    SELECT '0x776628a5c37335608dd2a9538807b9bba3869e14','PTP_main_vault_USDT','Stables','platypus','0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7','USDT','1e6',31 UNION ALL
    SELECT '0x0d26d103c91f63052fbca88aaf01d5304ae40015','PTP_main_vault_USDT.e','Stables','platypus','0xc7198437980c041c805a1edcba50c1ce5db95118','USDT.e','1e6',32
    ),