PREVIEW / stock_5min / 2012-12-04
file: by_date/stock_5min/2012/2012-12-04.parquet size: 4.7 MB rows: 320,219 symbols: 3,463
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 |
|---|---|---|---|---|---|---|---|
| 2012-12-04 04:50:00 | AAPL | Stock | 20.8975 | 20.8975 | 20.8975 | 20.8975 | 2800.0 |
| 2012-12-04 05:25:00 | AAPL | Stock | 20.8929 | 20.9107 | 20.8929 | 20.9107 | 5600.0 |
| 2012-12-04 05:35:00 | AAPL | Stock | 20.9282 | 20.9282 | 20.9282 | 20.9282 | 6244.0 |
| 2012-12-04 06:10:00 | AAPL | Stock | 20.9282 | 20.9282 | 20.9282 | 20.9282 | 7532.0 |
| 2012-12-04 06:15:00 | AAPL | Stock | 20.9282 | 20.9282 | 20.9282 | 20.9282 | 5600.0 |
| 2012-12-04 06:20:00 | AAPL | Stock | 20.9286 | 20.9336 | 20.9286 | 20.9336 | 11200.0 |
| 2012-12-04 06:45:00 | AAPL | Stock | 20.9296 | 20.9296 | 20.9286 | 20.9286 | 8400.0 |
| 2012-12-04 07:00:00 | AAPL | Stock | 20.9214 | 20.9214 | 20.9018 | 20.9018 | 43400.0 |
| 2012-12-04 07:05:00 | AAPL | Stock | 20.905 | 20.9243 | 20.905 | 20.9243 | 11200.0 |
| 2012-12-04 07:10:00 | AAPL | Stock | 20.9243 | 20.925 | 20.9107 | 20.9107 | 28000.0 |
| 2012-12-04 07:15:00 | AAPL | Stock | 20.9075 | 20.9075 | 20.8929 | 20.8929 | 57400.0 |
| 2012-12-04 07:20:00 | AAPL | Stock | 20.8939 | 20.8939 | 20.8925 | 20.8932 | 32424.0 |
| 2012-12-04 07:25:00 | AAPL | Stock | 20.8911 | 20.8911 | 20.8857 | 20.8857 | 11200.0 |
| 2012-12-04 07:30:00 | AAPL | Stock | 20.8857 | 20.8857 | 20.8857 | 20.8857 | 8400.0 |
| 2012-12-04 07:35:00 | AAPL | Stock | 20.8925 | 20.9143 | 20.8925 | 20.9143 | 39200.0 |
| 2012-12-04 07:40:00 | AAPL | Stock | 20.9007 | 20.9007 | 20.9 | 20.9 | 6160.0 |
| 2012-12-04 07:45:00 | AAPL | Stock | 20.9104 | 20.9171 | 20.9104 | 20.9171 | 19320.0 |
| 2012-12-04 07:50:00 | AAPL | Stock | 20.9214 | 20.9236 | 20.9107 | 20.9107 | 62720.0 |
| 2012-12-04 07:55:00 | AAPL | Stock | 20.9107 | 20.9107 | 20.9 | 20.9 | 10640.0 |
| 2012-12-04 08:00:00 | AAPL | Stock | 20.9079 | 20.9125 | 20.8929 | 20.9071 | 148344.0 |
| 2012-12-04 08:05:00 | AAPL | Stock | 20.9036 | 20.9071 | 20.8929 | 20.8929 | 66864.0 |
| 2012-12-04 08:10:00 | AAPL | Stock | 20.9014 | 20.9036 | 20.8929 | 20.8929 | 80164.0 |
| 2012-12-04 08:15:00 | AAPL | Stock | 20.8961 | 20.9314 | 20.8871 | 20.9107 | 246652.0 |
| 2012-12-04 08:20:00 | AAPL | Stock | 20.9146 | 20.9146 | 20.8939 | 20.9036 | 151956.0 |
| 2012-12-04 08:25:00 | AAPL | Stock | 20.9021 | 20.9068 | 20.8911 | 20.8911 | 130424.0 |
| 2012-12-04 08:30:00 | AAPL | Stock | 20.8861 | 20.8929 | 20.8768 | 20.8829 | 184772.0 |
| 2012-12-04 08:35:00 | AAPL | Stock | 20.8829 | 20.8829 | 20.8436 | 20.85 | 362208.0 |
| 2012-12-04 08:40:00 | AAPL | Stock | 20.8454 | 20.8486 | 20.7661 | 20.7857 | 812308.0 |
| 2012-12-04 08:45:00 | AAPL | Stock | 20.7846 | 20.8036 | 20.7775 | 20.7775 | 484036.0 |
| 2012-12-04 08:50:00 | AAPL | Stock | 20.7854 | 20.8025 | 20.7714 | 20.7971 | 284284.0 |
| 2012-12-04 08:55:00 | AAPL | Stock | 20.8025 | 20.8204 | 20.7982 | 20.7982 | 214956.0 |
| 2012-12-04 09:00:00 | AAPL | Stock | 20.8007 | 20.8079 | 20.7696 | 20.7696 | 196084.0 |
| 2012-12-04 09:05:00 | AAPL | Stock | 20.7768 | 20.7768 | 20.7361 | 20.7714 | 586852.0 |
| 2012-12-04 09:10:00 | AAPL | Stock | 20.775 | 20.7821 | 20.7357 | 20.7357 | 489580.0 |
| 2012-12-04 09:15:00 | AAPL | Stock | 20.7443 | 20.7607 | 20.7382 | 20.7586 | 181664.0 |
| 2012-12-04 09:20:00 | AAPL | Stock | 20.7589 | 20.7714 | 20.7518 | 20.7629 | 239960.0 |
| 2012-12-04 09:25:00 | AAPL | Stock | 20.7675 | 20.7861 | 20.7661 | 20.7696 | 576520.0 |
| 2012-12-04 09:30:00 | AAPL | Stock | 20.7682 | 20.78 | 20.6539 | 20.7104 | 19003320.0 |
| 2012-12-04 09:35:00 | AAPL | Stock | 20.7171 | 20.743 | 20.6986 | 20.7007 | 11120984.0 |
| 2012-12-04 09:40:00 | AAPL | Stock | 20.6968 | 20.7264 | 20.6429 | 20.6746 | 11632656.0 |
| 2012-12-04 09:45:00 | AAPL | Stock | 20.6693 | 20.6971 | 20.6286 | 20.6625 | 9198140.0 |
| 2012-12-04 09:50:00 | AAPL | Stock | 20.6618 | 20.7125 | 20.6364 | 20.6441 | 7265440.0 |
| 2012-12-04 09:55:00 | AAPL | Stock | 20.6446 | 20.6725 | 20.625 | 20.6321 | 6722660.0 |
| 2012-12-04 10:00:00 | AAPL | Stock | 20.6314 | 20.64 | 20.5893 | 20.5975 | 9383276.0 |
| 2012-12-04 10:05:00 | AAPL | Stock | 20.5993 | 20.6725 | 20.5857 | 20.6557 | 9624524.0 |
| 2012-12-04 10:10:00 | AAPL | Stock | 20.655 | 20.7315 | 20.6357 | 20.7011 | 11501000.0 |
| 2012-12-04 10:15:00 | AAPL | Stock | 20.6989 | 20.7175 | 20.6525 | 20.6589 | 6028036.0 |
| 2012-12-04 10:20:00 | AAPL | Stock | 20.6639 | 20.6804 | 20.6175 | 20.6193 | 5492788.0 |
| 2012-12-04 10:25:00 | AAPL | Stock | 20.6229 | 20.6332 | 20.5682 | 20.5793 | 9164148.0 |
| 2012-12-04 10:30:00 | AAPL | Stock | 20.5761 | 20.5875 | 20.5464 | 20.5496 | 10520804.0 |
> showing 50 of 320,219 rows — these rows as CSV