WITH hardcoded_tokens AS (

SELECT * FROM (VALUES

('DAI', '0x44fa8e6f47987339850636f88629646662444217', 18),

('SAFE', '0x5aFE3855358E112B5647B952709E6165e1c1eEEe', 18),

('SOL', 'So11111111111111111111111111111111111111112', 9),

('LINK', '0x350a791bfc2c21f9ed5d10980dad2e2638ffa7f6', 18),

('SWEAT', '0xb4b9dc1c77bdbb135ea907fd5a08094d98883a35', 18),

('DOGE', '0xba2ae424d960c26247dd6c32edc70b295c744c43', 8),

('TURBO', '0xa35923162c49cf95e6bf26623385eb431ad920d3', 6),

('BOME', 'ukHH6c7mMyiWCf1b9pnWe25TSpkDDt3H5pQZgZ74J82', 6),

('REF', 'token.v2.ref-finance.near', 18),

('MPDAO', 'mpdao-token.near', 6),

('MELANIA', 'FUAfBo2jgks6gB4Z4LfZkqSZgzNucisEHqnNebaRxM1P', 18),

('WIF', 'EKpQGSJtjMFqKZ9KQanSqYXRcF8fBopzLHYxdM65zcjm', 6),

('COW', '0x177127622c4a00f3d409b75571e12cb3c8973d3c', 18),

('MOG', '0x2da56acb9ea78330f947bd57c54119debda7af71', 18),

('USDT', '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::usdt', 6),

('BRETT', '0x532f27101965dd16442e59d40670faf5ebb142e4', 18),

('BRRR', 'token.burrow.near', 18),

('GMX', '0x62edc0692bd897d2295872a9ffcac5425011c661', 18),

('AURORA', 'aaaaaa20d9e0e2461697782ef11675f668207961.factory.bridge.near', 18),

('USDC', '0x640952e7984f2ecedead8fd97aa618ab1210a21c', 6),

('UNI', '0xb33eaad8d922b1083446dc23f610c2567fb5180f', 18),

('SHIB', 'factory/osmo1f588gk9dazpsueevdl2w6wfkmfmhg5gdvg2uerdlzl0atkasqhsq59qc6a/alloyed/allshib', 18),

('WXDAI', '0xe91d153e0b41518a2ce8dd3d7944fa863463a97d', 18),

('WETH', '0x695921034f0387eac4e11620ee91b1b15a6a09fe', 18),

('GNO', '0xa0b862f60edef4452f25b4160f177db44deb6cf1', 18),

('NEAR', '0x1fa4a73a3f0133f0025378af00236f3abdee5d63', 18),

('WBTC', '3NZ9JMVBmGAqocybic2c7LQCJScmgsAZ6vQqTDzcqmJh', 8),

('AAVE', '0xfb6115445bff7b52feb98650c87f44907e58f802', 18),

('XRP', '0x1d2f0da169ceb9fc7b3144628db156f3f6c60dbe', 6),

('SHITZU', 'AFbJW5rdaGidnF6o8ZqTtkDBpq3fotSBdJN8fGRN3VRS', 9),

('BERA', '0x6969696969696969696969696969696969696969', 18)

) AS t(symbol, token_address, decimals)

),