Query editor
WITH my_jettons AS (SELECT *FROM (VALUES('0:B113A994B5024A16719F69139328EB759596C38A25F59028B146FECDC3621DFE', 'USDT'),('0:AFC49CB8786F21C87045B19EDE78FC6B46C51048513F8E9A6D44060199C1BF0C', 'DOGS'),('0:EFFB2AF8D7F099DAEAE0DA07DE8157DAE383C33E320AF45F8C8A510328350886', 'ANON'),('0:59FDC69F3F20EBE4A513B3468DC61D194C3864A4464E3662C903648D1A52E6E0', 'REDO'),('0:FE72F474373E97032441BDB873F9A6D3AD10BAB08E6DBC7BEFA5E42B695F5400', 'CATI'),('0:2F956143C461769579BAEF2E32CC2D7BC18283F40D20BB03E432CD603AC33FFC', 'NOT'),('0:09F2E59DEC406AB26A5259A45D7FF23EF11F3E5C7C21DE0B0D2A1CBE52B76B3D', 'HMSTR'),('0:AE3E6D351E576276E439E7168117FD64696FD6014CB90C77B2F2CBAACD4FCC00', 'MAJOR'),('0:78DB4C90B19A1B19CCB45580DF48A1E91B6410970FA3D5FFED3EED49E3CF08FF', 'PX'),('0:808F9A22451AD7A2462C83F07E7B4286F71330879BA9AF923C1D0CC4AE6D3F04', 'BLUM'),('0:086FA2A675F74347B08DD4606A549B8FDB98829CB282BC1949D3B12FBAED9DCC', 'USDE'),('0:D0E545323C7ACB7102653C073377F7E3C67F122EB94D430A250739F109D4A57D', 'TSUSD')) AS t(jetton_master, symbol)),latest_prices AS (SELECTUPPER(token_address) AS jetton_master,max_by(price_usd, timestamp) AS price_usd_rawFROM ton.prices_dailyWHERE UPPER(token_address) IN (SELECT jetton_master FROM my_jettons)GROUP BY 1),decimals AS (SELECTUPPER(address) AS jetton_master,max_by(TRY_CAST(decimals AS INTEGER), update_time_metadata) AS decimalsFROM ton.jetton_metadataWHERE UPPER(address) IN (SELECT jetton_master FROM my_jettons)GROUP BY 1)SELECTj.symbol,j.jetton_master,ROUND(p.price_usd_raw * POWER(10, COALESCE(d.decimals, 9)), 6) AS price_usd_per_tokenFROM my_jettons jLEFT JOIN latest_prices p ON p.jetton_master = j.jetton_masterLEFT JOIN decimals d ON d.jetton_master = j.jetton_masterORDER BY j.symbol;