PREVIEW / stock_5min / 2000-01-03
file: by_date/stock_5min/2000/2000-01-03.parquet size: 1.1 MB rows: 86,565 symbols: 1,125
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 |
|---|---|---|---|---|---|---|---|
| 2000-01-03 09:30:00 | AAPL | Stock | 0.9364 | 0.9408 | 0.9336 | 0.9336 | 22075200.0 |
| 2000-01-03 09:35:00 | AAPL | Stock | 0.9375 | 0.9386 | 0.9241 | 0.9247 | 9396800.0 |
| 2000-01-03 09:40:00 | AAPL | Stock | 0.9241 | 0.9302 | 0.9208 | 0.9263 | 7515200.0 |
| 2000-01-03 09:45:00 | AAPL | Stock | 0.928 | 0.9375 | 0.928 | 0.9342 | 12331200.0 |
| 2000-01-03 09:50:00 | AAPL | Stock | 0.9342 | 0.9369 | 0.9286 | 0.9311 | 17931200.0 |
| 2000-01-03 09:55:00 | AAPL | Stock | 0.9314 | 0.9314 | 0.9208 | 0.9238 | 4995200.0 |
| 2000-01-03 10:00:00 | AAPL | Stock | 0.9235 | 0.9319 | 0.923 | 0.928 | 5812800.0 |
| 2000-01-03 10:05:00 | AAPL | Stock | 0.928 | 0.9308 | 0.9252 | 0.928 | 6272000.0 |
| 2000-01-03 10:10:00 | AAPL | Stock | 0.9286 | 0.9381 | 0.928 | 0.9353 | 7347200.0 |
| 2000-01-03 10:15:00 | AAPL | Stock | 0.9336 | 0.9375 | 0.9319 | 0.935 | 3662400.0 |
| 2000-01-03 10:20:00 | AAPL | Stock | 0.9353 | 0.9353 | 0.9319 | 0.9319 | 2352000.0 |
| 2000-01-03 10:25:00 | AAPL | Stock | 0.9322 | 0.9464 | 0.9319 | 0.942 | 13104000.0 |
| 2000-01-03 10:30:00 | AAPL | Stock | 0.9464 | 0.9464 | 0.9342 | 0.9358 | 6328000.0 |
| 2000-01-03 10:35:00 | AAPL | Stock | 0.9347 | 0.9381 | 0.9263 | 0.9263 | 7896000.0 |
| 2000-01-03 10:40:00 | AAPL | Stock | 0.9263 | 0.9308 | 0.9241 | 0.9241 | 3718400.0 |
| 2000-01-03 10:45:00 | AAPL | Stock | 0.9241 | 0.9308 | 0.923 | 0.9241 | 3248000.0 |
| 2000-01-03 10:50:00 | AAPL | Stock | 0.9241 | 0.9252 | 0.9174 | 0.9196 | 7683200.0 |
| 2000-01-03 10:55:00 | AAPL | Stock | 0.9185 | 0.9196 | 0.9079 | 0.9096 | 11076800.0 |
| 2000-01-03 11:00:00 | AAPL | Stock | 0.9118 | 0.9185 | 0.9107 | 0.9174 | 8187200.0 |
| 2000-01-03 11:05:00 | AAPL | Stock | 0.9152 | 0.9185 | 0.9113 | 0.918 | 1601600.0 |
| 2000-01-03 11:10:00 | AAPL | Stock | 0.918 | 0.9185 | 0.9141 | 0.9146 | 3808000.0 |
| 2000-01-03 11:15:00 | AAPL | Stock | 0.9146 | 0.9146 | 0.9107 | 0.9135 | 4289600.0 |
| 2000-01-03 11:20:00 | AAPL | Stock | 0.9135 | 0.9174 | 0.9124 | 0.9163 | 1444800.0 |
| 2000-01-03 11:25:00 | AAPL | Stock | 0.9163 | 0.9308 | 0.9163 | 0.9275 | 3606400.0 |
| 2000-01-03 11:30:00 | AAPL | Stock | 0.928 | 0.928 | 0.9263 | 0.9263 | 3472000.0 |
| 2000-01-03 11:35:00 | AAPL | Stock | 0.9263 | 0.9294 | 0.9196 | 0.9275 | 2900800.0 |
| 2000-01-03 11:40:00 | AAPL | Stock | 0.9275 | 0.9297 | 0.9263 | 0.9263 | 2688000.0 |
| 2000-01-03 11:45:00 | AAPL | Stock | 0.9275 | 0.9286 | 0.9263 | 0.9286 | 1568000.0 |
| 2000-01-03 11:50:00 | AAPL | Stock | 0.9286 | 0.9308 | 0.928 | 0.9291 | 4592000.0 |
| 2000-01-03 11:55:00 | AAPL | Stock | 0.9297 | 0.9297 | 0.9224 | 0.928 | 2968000.0 |
| 2000-01-03 12:00:00 | AAPL | Stock | 0.9286 | 0.9302 | 0.928 | 0.9302 | 2822400.0 |
| 2000-01-03 12:05:00 | AAPL | Stock | 0.9302 | 0.9302 | 0.9252 | 0.9258 | 3315200.0 |
| 2000-01-03 12:10:00 | AAPL | Stock | 0.9252 | 0.9286 | 0.9252 | 0.928 | 1254400.0 |
| 2000-01-03 12:15:00 | AAPL | Stock | 0.928 | 0.9297 | 0.9275 | 0.9297 | 3516800.0 |
| 2000-01-03 12:20:00 | AAPL | Stock | 0.9286 | 0.9297 | 0.9263 | 0.9275 | 3046400.0 |
| 2000-01-03 12:25:00 | AAPL | Stock | 0.9286 | 0.9286 | 0.9263 | 0.928 | 1164800.0 |
| 2000-01-03 12:30:00 | AAPL | Stock | 0.9286 | 0.9325 | 0.9275 | 0.9319 | 4188800.0 |
| 2000-01-03 12:35:00 | AAPL | Stock | 0.9319 | 0.9325 | 0.9308 | 0.9308 | 1276800.0 |
| 2000-01-03 12:40:00 | AAPL | Stock | 0.9308 | 0.9325 | 0.9302 | 0.9319 | 2934400.0 |
| 2000-01-03 12:45:00 | AAPL | Stock | 0.9319 | 0.9364 | 0.9308 | 0.9347 | 6944000.0 |
| 2000-01-03 12:50:00 | AAPL | Stock | 0.9347 | 0.9358 | 0.9308 | 0.9358 | 5432000.0 |
| 2000-01-03 12:55:00 | AAPL | Stock | 0.9367 | 0.9414 | 0.9342 | 0.9397 | 6608000.0 |
| 2000-01-03 13:00:00 | AAPL | Stock | 0.9403 | 0.9475 | 0.9397 | 0.9475 | 6630400.0 |
| 2000-01-03 13:05:00 | AAPL | Stock | 0.9464 | 0.9503 | 0.9453 | 0.9475 | 7604800.0 |
| 2000-01-03 13:10:00 | AAPL | Stock | 0.947 | 0.9576 | 0.9464 | 0.9537 | 6294400.0 |
| 2000-01-03 13:15:00 | AAPL | Stock | 0.9542 | 0.9637 | 0.9537 | 0.9632 | 8276800.0 |
| 2000-01-03 13:20:00 | AAPL | Stock | 0.9621 | 0.9676 | 0.9621 | 0.9668 | 9419200.0 |
| 2000-01-03 13:25:00 | AAPL | Stock | 0.9665 | 0.976 | 0.9654 | 0.9754 | 7952000.0 |
| 2000-01-03 13:30:00 | AAPL | Stock | 0.976 | 0.981 | 0.9732 | 0.9805 | 9800000.0 |
| 2000-01-03 13:35:00 | AAPL | Stock | 0.9799 | 0.9866 | 0.9777 | 0.9816 | 14504000.0 |
> showing 50 of 86,565 rows — these rows as CSV