Query editor
with baset AS (SELECTblock_time,block_number,tx_hash, index,contract_address AS vault_contract,CONCAT('0x', SUBSTRING(TO_HEX(topic1), 25, 40)) AS creator,CONCAT('0x', SUBSTRING(TO_HEX(topic2), 25, 40)) AS underlying_token,CONCAT('0x', SUBSTRING(TO_HEX(data), 25, 40)) AS debt_tokenFROM sonic.logsWHERE topic0 = 0x0cd345140b9008a43f99a999a328ece572a0193e8c8bf5f5755585e6f293b85eAND block_time >= TIMESTAMP '2024-01-01'),pricet AS (SELECT *FROM prices.latestWHERE blockchain = 'sonic'),tokens as (select *from(SELECT'0x930441AA7AB17654DF5663781CA0C02CC17E6643' AS underlying_token,'0x930441AA7AB17654DF5663781CA0C02CC17E6643' AS contract_address,'PT-aSonUSDC-14AUG2025' AS symbol,price,6 as decimalsFROM pricetWHERE contract_address = 0x29219DD400F2BF60E5A23D13BE72B486D4038894UNION ALLSELECT'0x46EB02B9F47634C4FAB3110CC7ADC1C6311DFAC1' AS underlying_token,'0x46EB02B9F47634C4FAB3110CC7ADC1C6311DFAC1' AS contract_address,'PT-wOS-29MAY2025' AS symbol,price,18 as decimalsFROM pricetWHERE contract_address = 0x9F0DF7799F6FDAD409300080CFF680F5A23DF4B1UNION ALLSELECT'0x420DF605D062F8611EFB3F203BF258159B8FFFDE' AS underlying_token,'0x420DF605D062F8611EFB3F203BF258159B8FFFDE' AS contract_address,'PT-stS-29MAY2025' AS symbol,price,18 as decimalsFROM pricetWHERE contract_address = 0xE5DA20F15420AD15DE0FA650600AFC998BBE3955UNION ALLSELECT'0xBE27993204EC64238F71A527B4C4D5F4949034C3' AS underlying_token,'0xBE27993204EC64238F71A527B4C4D5F4949034C3' AS contract_address,'PT-wstkscUSD-29MAY2025' AS symbol,