PREVIEW / stock_5min / 2012-04-27
file: by_date/stock_5min/2012/2012-04-27.parquet size: 4.8 MB rows: 327,320 symbols: 3,531
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-04-27 04:15:00 | AAPL | Stock | 21.6136 | 21.6136 | 21.6136 | 21.6136 | 2800.0 |
| 2012-04-27 04:25:00 | AAPL | Stock | 21.6518 | 21.6518 | 21.6429 | 21.6429 | 17360.0 |
| 2012-04-27 04:30:00 | AAPL | Stock | 21.6536 | 21.6536 | 21.6536 | 21.6536 | 5208.0 |
| 2012-04-27 04:35:00 | AAPL | Stock | 21.6536 | 21.6536 | 21.6536 | 21.6536 | 2800.0 |
| 2012-04-27 04:50:00 | AAPL | Stock | 21.6746 | 21.675 | 21.6746 | 21.675 | 8400.0 |
| 2012-04-27 04:55:00 | AAPL | Stock | 21.675 | 21.675 | 21.675 | 21.675 | 2800.0 |
| 2012-04-27 05:10:00 | AAPL | Stock | 21.6768 | 21.6786 | 21.6768 | 21.6786 | 16100.0 |
| 2012-04-27 05:30:00 | AAPL | Stock | 21.6436 | 21.6436 | 21.6436 | 21.6436 | 2800.0 |
| 2012-04-27 05:40:00 | AAPL | Stock | 21.6614 | 21.6614 | 21.6614 | 21.6614 | 2800.0 |
| 2012-04-27 05:50:00 | AAPL | Stock | 21.6607 | 21.6607 | 21.6607 | 21.6607 | 5600.0 |
| 2012-04-27 06:05:00 | AAPL | Stock | 21.6782 | 21.6782 | 21.6782 | 21.6782 | 2800.0 |
| 2012-04-27 06:10:00 | AAPL | Stock | 21.6671 | 21.6671 | 21.6671 | 21.6671 | 3500.0 |
| 2012-04-27 06:15:00 | AAPL | Stock | 21.6786 | 21.6786 | 21.6786 | 21.6786 | 8988.0 |
| 2012-04-27 06:30:00 | AAPL | Stock | 21.6821 | 21.6821 | 21.6821 | 21.6821 | 3108.0 |
| 2012-04-27 06:45:00 | AAPL | Stock | 21.7036 | 21.7036 | 21.7036 | 21.7036 | 2800.0 |
| 2012-04-27 07:00:00 | AAPL | Stock | 21.6964 | 21.7168 | 21.6964 | 21.7143 | 72072.0 |
| 2012-04-27 07:05:00 | AAPL | Stock | 21.7143 | 21.7143 | 21.7143 | 21.7143 | 5600.0 |
| 2012-04-27 07:10:00 | AAPL | Stock | 21.7179 | 21.7321 | 21.7179 | 21.7321 | 8400.0 |
| 2012-04-27 07:15:00 | AAPL | Stock | 21.7143 | 21.7143 | 21.7143 | 21.7143 | 31052.0 |
| 2012-04-27 07:25:00 | AAPL | Stock | 21.7143 | 21.7143 | 21.7143 | 21.7143 | 6244.0 |
| 2012-04-27 07:30:00 | AAPL | Stock | 21.7143 | 21.7232 | 21.7143 | 21.7232 | 21840.0 |
| 2012-04-27 07:35:00 | AAPL | Stock | 21.7143 | 21.7143 | 21.7089 | 21.7089 | 60032.0 |
| 2012-04-27 07:40:00 | AAPL | Stock | 21.7036 | 21.7036 | 21.7036 | 21.7036 | 7000.0 |
| 2012-04-27 07:45:00 | AAPL | Stock | 21.7036 | 21.7036 | 21.6679 | 21.6679 | 16464.0 |
| 2012-04-27 07:50:00 | AAPL | Stock | 21.6964 | 21.7046 | 21.6793 | 21.6875 | 21448.0 |
| 2012-04-27 07:55:00 | AAPL | Stock | 21.6964 | 21.7054 | 21.6875 | 21.7043 | 56000.0 |
| 2012-04-27 08:00:00 | AAPL | Stock | 21.6911 | 21.7357 | 21.6639 | 21.6639 | 237720.0 |
| 2012-04-27 08:05:00 | AAPL | Stock | 21.6725 | 21.6786 | 21.6725 | 21.6775 | 50008.0 |
| 2012-04-27 08:10:00 | AAPL | Stock | 21.6786 | 21.6786 | 21.6454 | 21.6596 | 208572.0 |
| 2012-04-27 08:15:00 | AAPL | Stock | 21.6589 | 21.6857 | 21.6536 | 21.6854 | 74200.0 |
| 2012-04-27 08:20:00 | AAPL | Stock | 21.6854 | 21.6889 | 21.67 | 21.6786 | 64960.0 |
| 2012-04-27 08:25:00 | AAPL | Stock | 21.6786 | 21.6957 | 21.6754 | 21.6957 | 79044.0 |
| 2012-04-27 08:30:00 | AAPL | Stock | 21.685 | 21.685 | 21.6186 | 21.6661 | 443996.0 |
| 2012-04-27 08:35:00 | AAPL | Stock | 21.6661 | 21.6679 | 21.6364 | 21.6371 | 213892.0 |
| 2012-04-27 08:40:00 | AAPL | Stock | 21.6371 | 21.6371 | 21.5696 | 21.5761 | 577388.0 |
| 2012-04-27 08:45:00 | AAPL | Stock | 21.585 | 21.6296 | 21.5789 | 21.625 | 228172.0 |
| 2012-04-27 08:50:00 | AAPL | Stock | 21.6214 | 21.6321 | 21.6039 | 21.6321 | 182056.0 |
| 2012-04-27 08:55:00 | AAPL | Stock | 21.625 | 21.6275 | 21.6114 | 21.6246 | 188832.0 |
| 2012-04-27 09:00:00 | AAPL | Stock | 21.6257 | 21.6429 | 21.6257 | 21.6421 | 167580.0 |
| 2012-04-27 09:05:00 | AAPL | Stock | 21.6429 | 21.6493 | 21.6339 | 21.6379 | 136360.0 |
| 2012-04-27 09:10:00 | AAPL | Stock | 21.635 | 21.6354 | 21.6161 | 21.6314 | 239596.0 |
| 2012-04-27 09:15:00 | AAPL | Stock | 21.6289 | 21.6346 | 21.6232 | 21.6321 | 44856.0 |
| 2012-04-27 09:20:00 | AAPL | Stock | 21.6343 | 21.6343 | 21.6125 | 21.62 | 133980.0 |
| 2012-04-27 09:25:00 | AAPL | Stock | 21.6143 | 21.6318 | 21.6 | 21.6132 | 393876.0 |
| 2012-04-27 09:30:00 | AAPL | Stock | 21.6096 | 21.6296 | 21.5668 | 21.5943 | 15477196.0 |
| 2012-04-27 09:35:00 | AAPL | Stock | 21.595 | 21.595 | 21.4464 | 21.5366 | 30121420.0 |
| 2012-04-27 09:40:00 | AAPL | Stock | 21.5329 | 21.5489 | 21.4554 | 21.4604 | 14461188.0 |
| 2012-04-27 09:45:00 | AAPL | Stock | 21.4604 | 21.5336 | 21.455 | 21.5146 | 10839108.0 |
| 2012-04-27 09:50:00 | AAPL | Stock | 21.5164 | 21.5429 | 21.4675 | 21.4739 | 9323636.0 |
| 2012-04-27 09:55:00 | AAPL | Stock | 21.475 | 21.5249 | 21.4739 | 21.5079 | 8688540.0 |
> showing 50 of 327,320 rows — these rows as CSV