12:43:06 I saved this copy and first took a quick look at the request string for price in sources. After ids came bitcoin, ethereum, binancecoin, and solana—the four full names. In the prices block, though, the keys were BTC, ETH, BNB, and SOL, with usd values of 64785, 1814.91, 593.89, and 71.03, respectively. The request string for ticker had a {symbol} placeholder; in tickers, it was replaced with BTCUSDT, last 64795.95.
There’s nothing in this snapshot that spells out how the full names correspond to the abbreviations. The mapping is in the data-fetching script, not in the data; if you create an asset column based literally on ids, the table will end up with several names that don’t appear in the snapshot. These are just my personal readings archived as a complete bundle at the time they were saved, not investment advice. Copy the asset column from the keys in the block, leave the original URL string in the sources cell, and don’t fill in the correspondence in between yourself.
The keys and request parameters each have their own place, so copy them into two separate places.
There’s nothing in this snapshot that spells out how the full names correspond to the abbreviations. The mapping is in the data-fetching script, not in the data; if you create an asset column based literally on ids, the table will end up with several names that don’t appear in the snapshot. These are just my personal readings archived as a complete bundle at the time they were saved, not investment advice. Copy the asset column from the keys in the block, leave the original URL string in the sources cell, and don’t fill in the correspondence in between yourself.
The keys and request parameters each have their own place, so copy them into two separate places.