PREVIEW / stock_30min / 2001-01-03
file: by_date/stock_30min/2001/2001-01-03.parquet size: 487 KB rows: 27,919 symbols: 1,267
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2001-01-03 08:00:00 | AAPL | Stock | 0.2656 | 0.2662 | 0.25 | 0.2567 | 3808000.0 |
| 2001-01-03 08:30:00 | AAPL | Stock | 0.2578 | 0.2589 | 0.2578 | 0.2578 | 683200.0 |
| 2001-01-03 09:00:00 | AAPL | Stock | 0.2578 | 0.2656 | 0.2545 | 0.2578 | 2609600.0 |
| 2001-01-03 09:30:00 | AAPL | Stock | 0.2589 | 0.2723 | 0.2578 | 0.269 | 81099200.0 |
| 2001-01-03 10:00:00 | AAPL | Stock | 0.269 | 0.2801 | 0.2667 | 0.2757 | 118406400.0 |
| 2001-01-03 10:30:00 | AAPL | Stock | 0.2757 | 0.279 | 0.2679 | 0.2706 | 47924800.0 |
| 2001-01-03 11:00:00 | AAPL | Stock | 0.2701 | 0.2718 | 0.2667 | 0.2701 | 34596800.0 |
| 2001-01-03 11:30:00 | AAPL | Stock | 0.2701 | 0.2734 | 0.2679 | 0.2701 | 17567200.0 |
| 2001-01-03 12:00:00 | AAPL | Stock | 0.269 | 0.2712 | 0.2679 | 0.269 | 17085600.0 |
| 2001-01-03 12:30:00 | AAPL | Stock | 0.269 | 0.2712 | 0.2667 | 0.2701 | 40275200.0 |
| 2001-01-03 13:00:00 | AAPL | Stock | 0.2701 | 0.2801 | 0.2679 | 0.2779 | 33538400.0 |
| 2001-01-03 13:30:00 | AAPL | Stock | 0.2779 | 0.2835 | 0.2746 | 0.2768 | 76955200.0 |
| 2001-01-03 14:00:00 | AAPL | Stock | 0.2779 | 0.2902 | 0.2757 | 0.2891 | 88698400.0 |
| 2001-01-03 14:30:00 | AAPL | Stock | 0.2891 | 0.2958 | 0.2846 | 0.2946 | 76176800.0 |
| 2001-01-03 15:00:00 | AAPL | Stock | 0.2935 | 0.2946 | 0.2846 | 0.2857 | 59684800.0 |
| 2001-01-03 15:30:00 | AAPL | Stock | 0.2857 | 0.298 | 0.2846 | 0.2924 | 44682400.0 |
| 2001-01-03 16:00:00 | AAPL | Stock | 0.2913 | 0.2935 | 0.2807 | 0.2924 | 15976800.0 |
| 2001-01-03 16:30:00 | AAPL | Stock | 0.2879 | 0.2924 | 0.2879 | 0.2913 | 5908000.0 |
| 2001-01-03 17:30:00 | AAPL | Stock | 0.2919 | 0.2935 | 0.2919 | 0.2924 | 117600.0 |
| 2001-01-03 18:00:00 | AAPL | Stock | 0.2935 | 0.2935 | 0.2924 | 0.2924 | 44800.0 |
| 2001-01-03 08:00:00 | MSFT | Stock | 21.5 | 21.625 | 21.1562 | 21.25 | 29400.0 |
| 2001-01-03 08:30:00 | MSFT | Stock | 21.25 | 21.75 | 21.125 | 21.375 | 103400.0 |
| 2001-01-03 09:00:00 | MSFT | Stock | 21.375 | 21.75 | 21.25 | 21.5938 | 532800.0 |
| 2001-01-03 09:30:00 | MSFT | Stock | 21.5938 | 22.375 | 21.5625 | 22.2188 | 13483000.0 |
| 2001-01-03 10:00:00 | MSFT | Stock | 22.2188 | 22.7188 | 22.125 | 22.5938 | 11982200.0 |
| 2001-01-03 10:30:00 | MSFT | Stock | 22.5938 | 22.6875 | 22.3125 | 22.5312 | 6012200.0 |
| 2001-01-03 11:00:00 | MSFT | Stock | 22.5312 | 22.5625 | 22.25 | 22.5 | 4739800.0 |
| 2001-01-03 11:30:00 | MSFT | Stock | 22.5 | 22.8125 | 22.3438 | 22.4688 | 5816200.0 |
| 2001-01-03 12:00:00 | MSFT | Stock | 22.4688 | 22.5156 | 22.2812 | 22.4688 | 3884400.0 |
| 2001-01-03 12:30:00 | MSFT | Stock | 22.4688 | 22.625 | 22.375 | 22.5625 | 4198000.0 |
| 2001-01-03 13:00:00 | MSFT | Stock | 22.5938 | 24.0 | 22.4062 | 23.6875 | 8989800.0 |
| 2001-01-03 13:30:00 | MSFT | Stock | 23.7188 | 24.25 | 22.9375 | 23.375 | 18047800.0 |
| 2001-01-03 14:00:00 | MSFT | Stock | 23.4062 | 24.2188 | 23.3125 | 24.1562 | 12902600.0 |
| 2001-01-03 14:30:00 | MSFT | Stock | 24.1562 | 24.4375 | 23.8438 | 24.375 | 10951400.0 |
| 2001-01-03 15:00:00 | MSFT | Stock | 24.4062 | 24.4375 | 24.0 | 24.1562 | 10213400.0 |
| 2001-01-03 15:30:00 | MSFT | Stock | 24.1406 | 24.2656 | 23.9062 | 23.9375 | 12851400.0 |
| 2001-01-03 16:00:00 | MSFT | Stock | 23.9844 | 24.1875 | 23.2344 | 23.875 | 3701000.0 |
| 2001-01-03 16:30:00 | MSFT | Stock | 23.8438 | 24.0 | 23.75 | 23.9688 | 803400.0 |
| 2001-01-03 17:00:00 | MSFT | Stock | 23.9688 | 23.9688 | 23.75 | 23.9375 | 17000.0 |
| 2001-01-03 17:30:00 | MSFT | Stock | 23.9375 | 24.0 | 23.8125 | 23.9062 | 25400.0 |
| 2001-01-03 18:00:00 | MSFT | Stock | 23.9688 | 24.0 | 23.9375 | 24.0 | 5400.0 |
| 2001-01-03 09:00:00 | NVDA | Stock | 0.125 | 0.125 | 0.1211 | 0.1211 | 6408000.0 |
| 2001-01-03 09:30:00 | NVDA | Stock | 0.1208 | 0.1292 | 0.1177 | 0.1245 | 52944000.0 |
| 2001-01-03 10:00:00 | NVDA | Stock | 0.1245 | 0.1339 | 0.1232 | 0.1318 | 38328000.0 |
| 2001-01-03 10:30:00 | NVDA | Stock | 0.1318 | 0.1398 | 0.1297 | 0.1331 | 57912000.0 |
| 2001-01-03 11:00:00 | NVDA | Stock | 0.1331 | 0.1354 | 0.1313 | 0.1333 | 33624000.0 |
| 2001-01-03 11:30:00 | NVDA | Stock | 0.1333 | 0.1333 | 0.1289 | 0.1299 | 30240000.0 |
| 2001-01-03 12:00:00 | NVDA | Stock | 0.1302 | 0.1313 | 0.1277 | 0.1286 | 38952000.0 |
| 2001-01-03 12:30:00 | NVDA | Stock | 0.1289 | 0.1326 | 0.1271 | 0.1315 | 15384000.0 |
| 2001-01-03 13:00:00 | NVDA | Stock | 0.1318 | 0.15 | 0.1299 | 0.15 | 72600000.0 |
> showing 50 of 27,919 rows — these rows as CSV