PREVIEW / stock_5min / 2009-12-09
file: by_date/stock_5min/2009/2009-12-09.parquet size: 4.6 MB rows: 311,952 symbols: 3,407
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 |
|---|---|---|---|---|---|---|---|
| 2009-12-09 04:35:00 | AAPL | Stock | 6.7707 | 6.7707 | 6.7707 | 6.7707 | 2800.0 |
| 2009-12-09 05:00:00 | AAPL | Stock | 6.7654 | 6.7654 | 6.7632 | 6.7632 | 12600.0 |
| 2009-12-09 05:15:00 | AAPL | Stock | 6.7689 | 6.7689 | 6.7689 | 6.7689 | 2800.0 |
| 2009-12-09 05:30:00 | AAPL | Stock | 6.7807 | 6.7807 | 6.7807 | 6.7807 | 2800.0 |
| 2009-12-09 05:40:00 | AAPL | Stock | 6.7996 | 6.8 | 6.7996 | 6.8 | 5600.0 |
| 2009-12-09 05:50:00 | AAPL | Stock | 6.8036 | 6.8036 | 6.8036 | 6.8036 | 2800.0 |
| 2009-12-09 06:10:00 | AAPL | Stock | 6.7996 | 6.7996 | 6.7996 | 6.7996 | 3920.0 |
| 2009-12-09 06:55:00 | AAPL | Stock | 6.8018 | 6.8018 | 6.8 | 6.8 | 5600.0 |
| 2009-12-09 07:00:00 | AAPL | Stock | 6.8075 | 6.8089 | 6.8036 | 6.8089 | 16800.0 |
| 2009-12-09 07:05:00 | AAPL | Stock | 6.8018 | 6.8036 | 6.8018 | 6.8018 | 16660.0 |
| 2009-12-09 07:10:00 | AAPL | Stock | 6.8018 | 6.8018 | 6.8 | 6.8 | 30800.0 |
| 2009-12-09 07:15:00 | AAPL | Stock | 6.8011 | 6.8011 | 6.8011 | 6.8011 | 14000.0 |
| 2009-12-09 07:20:00 | AAPL | Stock | 6.8011 | 6.8036 | 6.7993 | 6.7993 | 18620.0 |
| 2009-12-09 07:25:00 | AAPL | Stock | 6.8025 | 6.8046 | 6.8025 | 6.8036 | 129500.0 |
| 2009-12-09 07:30:00 | AAPL | Stock | 6.7996 | 6.8143 | 6.7996 | 6.8143 | 134960.0 |
| 2009-12-09 07:35:00 | AAPL | Stock | 6.8143 | 6.8143 | 6.8136 | 6.8143 | 18200.0 |
| 2009-12-09 07:40:00 | AAPL | Stock | 6.8154 | 6.8179 | 6.8154 | 6.8175 | 52864.0 |
| 2009-12-09 07:45:00 | AAPL | Stock | 6.8154 | 6.825 | 6.8154 | 6.825 | 111804.0 |
| 2009-12-09 07:50:00 | AAPL | Stock | 6.825 | 6.8371 | 6.825 | 6.835 | 202972.0 |
| 2009-12-09 07:55:00 | AAPL | Stock | 6.8275 | 6.8318 | 6.8225 | 6.8229 | 44800.0 |
| 2009-12-09 08:00:00 | AAPL | Stock | 6.825 | 6.8382 | 6.8214 | 6.8329 | 592648.0 |
| 2009-12-09 08:05:00 | AAPL | Stock | 6.8332 | 6.8439 | 6.8286 | 6.8404 | 657468.0 |
| 2009-12-09 08:10:00 | AAPL | Stock | 6.8421 | 6.8532 | 6.8393 | 6.8518 | 841792.0 |
| 2009-12-09 08:15:00 | AAPL | Stock | 6.85 | 6.8536 | 6.85 | 6.85 | 482216.0 |
| 2009-12-09 08:20:00 | AAPL | Stock | 6.85 | 6.8507 | 6.8429 | 6.8464 | 322840.0 |
| 2009-12-09 08:25:00 | AAPL | Stock | 6.8454 | 6.8486 | 6.8429 | 6.8436 | 267036.0 |
| 2009-12-09 08:30:00 | AAPL | Stock | 6.8454 | 6.8454 | 6.8411 | 6.8446 | 270648.0 |
| 2009-12-09 08:35:00 | AAPL | Stock | 6.8446 | 6.8464 | 6.8411 | 6.8414 | 305480.0 |
| 2009-12-09 08:40:00 | AAPL | Stock | 6.8411 | 6.8411 | 6.8339 | 6.8386 | 399420.0 |
| 2009-12-09 08:45:00 | AAPL | Stock | 6.8368 | 6.8429 | 6.8304 | 6.8375 | 325612.0 |
| 2009-12-09 08:50:00 | AAPL | Stock | 6.8375 | 6.8375 | 6.8332 | 6.8339 | 81732.0 |
| 2009-12-09 08:55:00 | AAPL | Stock | 6.8361 | 6.8464 | 6.8332 | 6.8393 | 490700.0 |
| 2009-12-09 09:00:00 | AAPL | Stock | 6.84 | 6.845 | 6.8307 | 6.8307 | 355880.0 |
| 2009-12-09 09:05:00 | AAPL | Stock | 6.8307 | 6.8404 | 6.8307 | 6.8354 | 117600.0 |
| 2009-12-09 09:10:00 | AAPL | Stock | 6.8307 | 6.8357 | 6.8279 | 6.8279 | 470960.0 |
| 2009-12-09 09:15:00 | AAPL | Stock | 6.8279 | 6.8296 | 6.825 | 6.8275 | 179060.0 |
| 2009-12-09 09:20:00 | AAPL | Stock | 6.8275 | 6.8339 | 6.8257 | 6.8268 | 376740.0 |
| 2009-12-09 09:25:00 | AAPL | Stock | 6.8268 | 6.8312 | 6.8229 | 6.83 | 315392.0 |
| 2009-12-09 09:30:00 | AAPL | Stock | 6.8296 | 6.8455 | 6.8239 | 6.8357 | 17074092.0 |
| 2009-12-09 09:35:00 | AAPL | Stock | 6.8354 | 6.8411 | 6.7968 | 6.8175 | 20016248.0 |
| 2009-12-09 09:40:00 | AAPL | Stock | 6.8189 | 6.8336 | 6.8021 | 6.8293 | 13871004.0 |
| 2009-12-09 09:45:00 | AAPL | Stock | 6.8304 | 6.8361 | 6.8129 | 6.8275 | 12698588.0 |
| 2009-12-09 09:50:00 | AAPL | Stock | 6.8296 | 6.865 | 6.8225 | 6.8607 | 17937276.0 |
| 2009-12-09 09:55:00 | AAPL | Stock | 6.8589 | 6.8721 | 6.8539 | 6.8693 | 14498708.0 |
| 2009-12-09 10:00:00 | AAPL | Stock | 6.8696 | 6.885 | 6.8671 | 6.8696 | 16057860.0 |
| 2009-12-09 10:05:00 | AAPL | Stock | 6.8693 | 6.8829 | 6.8604 | 6.8779 | 11507216.0 |
| 2009-12-09 10:10:00 | AAPL | Stock | 6.8779 | 6.8804 | 6.8575 | 6.8589 | 7260820.0 |
| 2009-12-09 10:15:00 | AAPL | Stock | 6.8593 | 6.8607 | 6.8407 | 6.8443 | 13045704.0 |
| 2009-12-09 10:20:00 | AAPL | Stock | 6.8439 | 6.8539 | 6.8393 | 6.8504 | 8147580.0 |
| 2009-12-09 10:25:00 | AAPL | Stock | 6.8504 | 6.8625 | 6.85 | 6.8611 | 4195800.0 |
> showing 50 of 311,952 rows — these rows as CSV