Query editor
WITH view_tokens AS (SELECT * FROM (VALUES('qiAVAX', 0x5C0401e81Bc07Ca70fAD469b451682c0d747Ef1c, 8, 'WAVAX', 0xB31f66AA3C1e785363F0875A1B74E27b85FD66c7, 18, 'core'),('qisAVAX', 0xF362feA9659cf036792c9cb02f8ff8198E21B4cB, 8, 'sAVAX', 0x2b2C81e08f1Af8835a78Bb2A90AE924ACE0eA4bE, 18, 'core'),('qiUSDTn', 0xd8fcDa6ec4Bdc547C0827B8804e89aCd817d56EF, 8, 'USDT', 0x9702230A8Ea53601f5cD2dc00fDBc13d4dF4A8c7, 6, 'core'),('qiUSDT', 0xc9e5999b8e75C3fEB117F6f73E664b9f3C8ca65C, 8, 'USDT.e', 0xc7198437980c041c805A1EDcbA50c1Ce5db95118, 6, 'core'),('qiUSDCn', 0xB715808a78F6041E46d61Cb123C9B4A27056AE9C, 8, 'USDC', 0xB97EF9Ef8734C71904D8002F8b6Bc66Dd9c48a6E, 6, 'core'),('qiUSDC', 0xBEb5d47A3f720Ec0a390d04b4d41ED7d9688bC7F, 8, 'USDC', 0xB97EF9Ef8734C71904D8002F8b6Bc66Dd9c48a6E, 6, 'core'),('qiDAI', 0x835866d37AFB8CB8F8334dCCdaf66cf01832Ff5D, 8, 'DAI.e', 0xd586E7F844cEa2F87f50152665BCbc2C279D8d70, 18, 'core'),('qiBTC', 0xe194c4c5aC32a3C9ffDb358d9Bfd523a0B6d1568, 8, 'BTC.b', 0x152b9d0FdC40C096757F570A51E494bd4b943E50, 8, 'core'),('qiETH', 0x334AD834Cd4481BB02d09615E7c11a00579A7909, 8, 'WETH.e', 0x49D5c2BdFfac6CE2BFdB6640F4F80f226bc10bAB, 18, 'core'),('qiLink', 0x4e9f683A27a6BdAD3FC2764003759277e93696e6, 8, 'LINK.e', 0x5947BB275c521040051D82396192181b413227A3, 18, 'old'),('qiAvalancheEcosystemMarketsQI', 0x545356e396350D40cDEa888ad73534517399BF96, 8, 'QI', 0x8729438EB15e2C8B576fCc6AeCdA6A148776C0F5, 18, 'AvalancheEcosystemMarkets'),('qiAvalancheEcosystemMarketsCOQ', 0x0eBfebD41e1eA83Be5e911cDCd2730a0CCEE344d, 8, 'COQ', 0x420FcA0121DC28039145009570975747295f2329, 18, 'AvalancheEcosystemMarkets'),('qiAvalancheEcosystemMarketsUSDC', 0x6B35Eb18BCA06bD7d66a428eeb45aC7d200C1e4E, 8, 'USDC', 0xB97EF9Ef8734C71904D8002F8b6Bc66Dd9c48a6E, 6, 'AvalancheEcosystemMarkets'),('qiAvalancheEcosystemMarketsJOE', 0x4036cb0D6BF6b5F17Aa4e05191F86D4b1655b0d9, 8, 'JOE', 0x6e84a6216eA6dACC71eE8E6b0a5B7322EEbC0fDd, 18, 'AvalancheEcosystemMarkets'),('qiAvalancheEcosystemMarketsAUSD', 0xb7CfB8Ae67E20059021A0D20fc30311a6c67C734, 8, 'AUSD', 0xb7CfB8Ae67E20059021A0D20fc30311a6c67C734, 6, 'AvalancheEcosystemMarkets')) x (vtoken, vtoken_contract_address, vtoken_decimals, symbol, underlying_token_address, decimals, pool)),token_prices AS (SELECT minute AS dt,a.vtoken_contract_address AS vtoken_contract,a.underlying_token_address AS contract_address,a.symbol,a.vtoken,a.decimals AS decimals,vtoken_decimals AS vtoken_decimals,b.price AS priceFROM view_tokens aLEFT JOIN prices.usd_latest b ON a.underlying_token_address = b.contract_address),exchange_rates_1 AS (SELECT dt, vtoken, vtoken_contract_address, vtoken_decimals, underlying_token_address, symbol, decimals, exchange_rateFROM (SELECTcall_block_time AS dt,contract_address,CAST(output_0 AS double) / POWER(10, 28) AS exchange_rateFROM benqi_finance_avalanche_c.QiErc20Delegate_call_exchangeRateStored aWHERE call_successUNION ALLSELECT call_block_time AS dt, contract_address, CAST(output_0 AS double) / POWER(10, 28) AS exchange_rateFROM benqi_finance_avalanche_c.QiAvax_call_exchangeRateStored bWHERE call_success) cLEFT JOIN view_tokens d ON c.contract_address = d.vtoken_contract_address),exchange_rates_max AS (SELECT MAX(dt) AS dt, vtoken_contract_addressFROM exchange_rates_1GROUP BY vtoken_contract_address),exchange_rates AS (