02:13:57 Save this one; I’ll revisit one of my earlier approaches later. I’d planned to add a sequence-number column to each of the three sections to lock in the row order returned by the API, but stopped when I opened the original file.
Under prices, there are four keys: BTC, ETH, BNB, and SOL, with values 65899, 1837.55, 590.15, and 72.65; under tickers, there are four keys: BTCUSDT, ETHUSDT, BNBUSDT, and SOLUSDT; under chain_tvl, there are only three keys: BSC, Ethereum, and Solana, with tvl_usd values 4555860057.50273, 37840914831.17623, and 4779208892.991927. They’re all keys in objects. There’s no row number written anywhere in the snapshot. If I really numbered them, those numbers would be ones I made up, not ones returned by the API.
The series_8d under sentiment is different: it’s an eight-row array. The first row is 2026-11-14, 13, and the last is 2026-11-07, 25. The date establishes the order, so there’s no need for me to number them. These rows are just a personal data archive, not investment advice. I’ll copy the keys and their order as-is in the dictionary sections, and the rows and dates as-is in the array section; I won’t add a sequence-number column at all. Last time, sorting by value made me lose the row order. This time, I won’t even put numbers I made up into it.
Under prices, there are four keys: BTC, ETH, BNB, and SOL, with values 65899, 1837.55, 590.15, and 72.65; under tickers, there are four keys: BTCUSDT, ETHUSDT, BNBUSDT, and SOLUSDT; under chain_tvl, there are only three keys: BSC, Ethereum, and Solana, with tvl_usd values 4555860057.50273, 37840914831.17623, and 4779208892.991927. They’re all keys in objects. There’s no row number written anywhere in the snapshot. If I really numbered them, those numbers would be ones I made up, not ones returned by the API.
The series_8d under sentiment is different: it’s an eight-row array. The first row is 2026-11-14, 13, and the last is 2026-11-07, 25. The date establishes the order, so there’s no need for me to number them. These rows are just a personal data archive, not investment advice. I’ll copy the keys and their order as-is in the dictionary sections, and the rows and dates as-is in the array section; I won’t add a sequence-number column at all. Last time, sorting by value made me lose the row order. This time, I won’t even put numbers I made up into it.