( values ('0xaf54be5b6eec24d6bfacf1cce4eaf680a8239398','stargate','bridge','Stargate Bridge'),

('0x19ceead7105607cd444f5ad10dd51356436095a1','odos','dex','odos V2 Router'),

('0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc','layerzero','bridge','Layer Zero Bridge'),

('0x0be808376ecb75a5cf9bb6d237d16cd37893d904','sushiswap','dex','Sushiswap router'),

('0x0d380362762b0cf375227037f2217f59a4ec4b9e','rabbithole','',''),

('0x72544e3cce122dffe2a3ebaf50d96333ee04c34d','synthswap','',''),

('0x9d845e853fd41565a77c2713244b1ecb7759489c','synthswap','',''),

('0xdb6f1920a889355780af7570773609bd8cb1f498','0x exchange','',''),

('0x22ca6d83ab887a535ae1c6011cc36ea9d1255c31','sushiswap','',''),

('0x5f0a153a64fd734c111b770da11de2c385ca8042','sushiswap','',''),

('0x06eb48763f117c7be887296cdcdfad2e4092739c','stargate','',''),

('0x20f0b18bdde8e3dd0e42c173062ebdd05c421151','swapbased','',''),

('0x52eaecac2402633d98b95213d0b473e069d86590','alienbase','',''),

('0x0ce6c85cf43553de10fc56ceca0aef6ff0dd444d','hop protocol','',''),

('0x3666f603cc164936c1b87e207f36beba4ac5f18a','hop protocol','',''),

('0x349bedc6c779efd4021db98d19ac3b5a725cb6b7','swapbased','','')

) as a (contract_address,contract_name , label_types , address_name))

,

base_contract as ( select * from (

SELECT

livequery.live.udf_api (

'https://api.dune.com/api/v1/query/3149503/results?api_key=JjaTXHvlAUGAsb0MVz3ztKMphH6pX2xO') as resp)

,

table(FLATTEN(parse_json(resp:data:"result":"rows")))),

token_json_data as

SELECT

chainbase_utils.post('/v1/dw/query', {

'query': 'select contract_address,