PREVIEW / stock_5min / 2000-08-14
file: by_date/stock_5min/2000/2000-08-14.parquet size: 1.1 MB rows: 87,191 symbols: 1,211
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-08-14 08:15:00 | AAPL | Stock | 0.8527 | 0.8527 | 0.8527 | 0.8527 | 39200.0 |
| 2000-08-14 08:55:00 | AAPL | Stock | 0.8527 | 0.8527 | 0.8527 | 0.8527 | 5600.0 |
| 2000-08-14 09:20:00 | AAPL | Stock | 0.8516 | 0.8516 | 0.8516 | 0.8516 | 11200.0 |
| 2000-08-14 09:25:00 | AAPL | Stock | 0.8527 | 0.8527 | 0.8516 | 0.8516 | 22400.0 |
| 2000-08-14 09:30:00 | AAPL | Stock | 0.8499 | 0.8516 | 0.8449 | 0.8449 | 1439200.0 |
| 2000-08-14 09:35:00 | AAPL | Stock | 0.8454 | 0.8516 | 0.8304 | 0.8326 | 3102400.0 |
| 2000-08-14 09:40:00 | AAPL | Stock | 0.8326 | 0.8359 | 0.8304 | 0.8315 | 1349600.0 |
| 2000-08-14 09:45:00 | AAPL | Stock | 0.8326 | 0.8337 | 0.8304 | 0.8315 | 935200.0 |
| 2000-08-14 09:50:00 | AAPL | Stock | 0.832 | 0.8326 | 0.8292 | 0.8292 | 2038400.0 |
| 2000-08-14 09:55:00 | AAPL | Stock | 0.8292 | 0.8304 | 0.827 | 0.8292 | 1663200.0 |
| 2000-08-14 10:00:00 | AAPL | Stock | 0.8315 | 0.8348 | 0.8292 | 0.8348 | 8635200.0 |
| 2000-08-14 10:05:00 | AAPL | Stock | 0.8348 | 0.8393 | 0.8292 | 0.8371 | 6904800.0 |
| 2000-08-14 10:10:00 | AAPL | Stock | 0.8404 | 0.8404 | 0.8382 | 0.8382 | 2228800.0 |
| 2000-08-14 10:15:00 | AAPL | Stock | 0.8382 | 0.846 | 0.8382 | 0.846 | 6675200.0 |
| 2000-08-14 10:20:00 | AAPL | Stock | 0.8471 | 0.8482 | 0.8426 | 0.8438 | 1030400.0 |
| 2000-08-14 10:25:00 | AAPL | Stock | 0.8426 | 0.8438 | 0.8382 | 0.8393 | 1988000.0 |
| 2000-08-14 10:30:00 | AAPL | Stock | 0.8393 | 0.8393 | 0.8359 | 0.8371 | 1002400.0 |
| 2000-08-14 10:35:00 | AAPL | Stock | 0.8371 | 0.8404 | 0.8359 | 0.8404 | 728000.0 |
| 2000-08-14 10:40:00 | AAPL | Stock | 0.8393 | 0.846 | 0.8371 | 0.8438 | 1030400.0 |
| 2000-08-14 10:45:00 | AAPL | Stock | 0.8449 | 0.846 | 0.8404 | 0.8415 | 1730400.0 |
| 2000-08-14 10:50:00 | AAPL | Stock | 0.8415 | 0.8438 | 0.8404 | 0.8404 | 1898400.0 |
| 2000-08-14 10:55:00 | AAPL | Stock | 0.8415 | 0.8438 | 0.8404 | 0.8438 | 487200.0 |
| 2000-08-14 11:00:00 | AAPL | Stock | 0.8415 | 0.8426 | 0.8404 | 0.8415 | 1103200.0 |
| 2000-08-14 11:05:00 | AAPL | Stock | 0.8426 | 0.8438 | 0.8393 | 0.8426 | 3830400.0 |
| 2000-08-14 11:10:00 | AAPL | Stock | 0.8426 | 0.8426 | 0.8393 | 0.8404 | 1792000.0 |
| 2000-08-14 11:15:00 | AAPL | Stock | 0.8404 | 0.8415 | 0.8393 | 0.8393 | 5656000.0 |
| 2000-08-14 11:20:00 | AAPL | Stock | 0.8393 | 0.8393 | 0.8371 | 0.8371 | 7364000.0 |
| 2000-08-14 11:25:00 | AAPL | Stock | 0.8371 | 0.8393 | 0.8371 | 0.8371 | 3029600.0 |
| 2000-08-14 11:30:00 | AAPL | Stock | 0.8371 | 0.8404 | 0.8348 | 0.8359 | 3796800.0 |
| 2000-08-14 11:35:00 | AAPL | Stock | 0.8371 | 0.8371 | 0.8348 | 0.8359 | 912800.0 |
| 2000-08-14 11:40:00 | AAPL | Stock | 0.8371 | 0.8371 | 0.8359 | 0.8371 | 520800.0 |
| 2000-08-14 11:45:00 | AAPL | Stock | 0.8382 | 0.8382 | 0.8371 | 0.8382 | 2576000.0 |
| 2000-08-14 11:50:00 | AAPL | Stock | 0.8382 | 0.8382 | 0.8371 | 0.8382 | 1915200.0 |
| 2000-08-14 11:55:00 | AAPL | Stock | 0.8382 | 0.8404 | 0.8382 | 0.8393 | 3231200.0 |
| 2000-08-14 12:00:00 | AAPL | Stock | 0.8393 | 0.8393 | 0.8359 | 0.8371 | 476000.0 |
| 2000-08-14 12:05:00 | AAPL | Stock | 0.8371 | 0.8393 | 0.8359 | 0.8365 | 728000.0 |
| 2000-08-14 12:10:00 | AAPL | Stock | 0.8359 | 0.8382 | 0.8359 | 0.8359 | 1752800.0 |
| 2000-08-14 12:15:00 | AAPL | Stock | 0.8371 | 0.8371 | 0.8337 | 0.8359 | 1036000.0 |
| 2000-08-14 12:20:00 | AAPL | Stock | 0.8359 | 0.8359 | 0.8348 | 0.8359 | 1276800.0 |
| 2000-08-14 12:25:00 | AAPL | Stock | 0.8348 | 0.8359 | 0.8348 | 0.8359 | 397600.0 |
| 2000-08-14 12:30:00 | AAPL | Stock | 0.8348 | 0.8359 | 0.8337 | 0.8359 | 123200.0 |
| 2000-08-14 12:35:00 | AAPL | Stock | 0.8337 | 0.8359 | 0.8337 | 0.8348 | 436800.0 |
| 2000-08-14 12:40:00 | AAPL | Stock | 0.8359 | 0.8371 | 0.8359 | 0.8359 | 912800.0 |
| 2000-08-14 12:45:00 | AAPL | Stock | 0.8359 | 0.8371 | 0.8359 | 0.8359 | 280000.0 |
| 2000-08-14 12:50:00 | AAPL | Stock | 0.8359 | 0.8359 | 0.8348 | 0.8359 | 1075200.0 |
| 2000-08-14 12:55:00 | AAPL | Stock | 0.8348 | 0.8359 | 0.8337 | 0.8343 | 1769600.0 |
| 2000-08-14 13:00:00 | AAPL | Stock | 0.8348 | 0.8348 | 0.8337 | 0.8348 | 84000.0 |
| 2000-08-14 13:05:00 | AAPL | Stock | 0.8337 | 0.8348 | 0.8337 | 0.8337 | 235200.0 |
| 2000-08-14 13:10:00 | AAPL | Stock | 0.8343 | 0.8359 | 0.8337 | 0.8348 | 666400.0 |
| 2000-08-14 13:15:00 | AAPL | Stock | 0.8348 | 0.8348 | 0.8337 | 0.8348 | 431200.0 |
> showing 50 of 87,191 rows — these rows as CSV