PREVIEW / stock_5min / 2013-02-08
file: by_date/stock_5min/2013/2013-02-08.parquet size: 4.7 MB rows: 318,133 symbols: 3,464
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 |
|---|---|---|---|---|---|---|---|
| 2013-02-08 04:00:00 | AAPL | Stock | 16.7221 | 16.7221 | 16.6786 | 16.6786 | 11060.0 |
| 2013-02-08 04:05:00 | AAPL | Stock | 16.6729 | 16.6729 | 16.6729 | 16.6729 | 2800.0 |
| 2013-02-08 04:30:00 | AAPL | Stock | 16.7107 | 16.7107 | 16.7107 | 16.7107 | 5600.0 |
| 2013-02-08 04:35:00 | AAPL | Stock | 16.7046 | 16.7046 | 16.7046 | 16.7046 | 2800.0 |
| 2013-02-08 04:50:00 | AAPL | Stock | 16.7107 | 16.7107 | 16.7107 | 16.7107 | 8400.0 |
| 2013-02-08 05:10:00 | AAPL | Stock | 16.7107 | 16.7143 | 16.7107 | 16.7143 | 15932.0 |
| 2013-02-08 05:40:00 | AAPL | Stock | 16.7143 | 16.7143 | 16.7143 | 16.7143 | 2800.0 |
| 2013-02-08 05:45:00 | AAPL | Stock | 16.7089 | 16.7089 | 16.7089 | 16.7089 | 2800.0 |
| 2013-02-08 05:50:00 | AAPL | Stock | 16.7143 | 16.7214 | 16.7143 | 16.7214 | 22400.0 |
| 2013-02-08 06:05:00 | AAPL | Stock | 16.7214 | 16.7214 | 16.7214 | 16.7214 | 2800.0 |
| 2013-02-08 06:10:00 | AAPL | Stock | 16.7214 | 16.7214 | 16.7214 | 16.7214 | 2800.0 |
| 2013-02-08 06:15:00 | AAPL | Stock | 16.6964 | 16.6964 | 16.6964 | 16.6964 | 4200.0 |
| 2013-02-08 06:20:00 | AAPL | Stock | 16.7107 | 16.7107 | 16.7107 | 16.7107 | 2800.0 |
| 2013-02-08 06:30:00 | AAPL | Stock | 16.6964 | 16.6964 | 16.6789 | 16.6789 | 26040.0 |
| 2013-02-08 06:35:00 | AAPL | Stock | 16.6943 | 16.6964 | 16.6893 | 16.6893 | 16800.0 |
| 2013-02-08 06:40:00 | AAPL | Stock | 16.6893 | 16.6893 | 16.6821 | 16.6821 | 8400.0 |
| 2013-02-08 06:45:00 | AAPL | Stock | 16.6821 | 16.6821 | 16.6821 | 16.6821 | 2800.0 |
| 2013-02-08 06:50:00 | AAPL | Stock | 16.6821 | 16.6821 | 16.6821 | 16.6821 | 31024.0 |
| 2013-02-08 06:55:00 | AAPL | Stock | 16.675 | 16.675 | 16.675 | 16.675 | 14000.0 |
| 2013-02-08 07:00:00 | AAPL | Stock | 16.675 | 16.6786 | 16.6607 | 16.6679 | 85596.0 |
| 2013-02-08 07:05:00 | AAPL | Stock | 16.6786 | 16.6875 | 16.6679 | 16.6875 | 28000.0 |
| 2013-02-08 07:10:00 | AAPL | Stock | 16.6875 | 16.7036 | 16.6875 | 16.7032 | 71848.0 |
| 2013-02-08 07:15:00 | AAPL | Stock | 16.7 | 16.7214 | 16.7 | 16.7214 | 80220.0 |
| 2013-02-08 07:20:00 | AAPL | Stock | 16.7143 | 16.7464 | 16.7143 | 16.7321 | 71400.0 |
| 2013-02-08 07:25:00 | AAPL | Stock | 16.7407 | 16.775 | 16.74 | 16.7718 | 204344.0 |
| 2013-02-08 07:30:00 | AAPL | Stock | 16.7714 | 16.8132 | 16.7707 | 16.7896 | 647640.0 |
| 2013-02-08 07:35:00 | AAPL | Stock | 16.7964 | 16.8268 | 16.7932 | 16.8111 | 398020.0 |
| 2013-02-08 07:40:00 | AAPL | Stock | 16.8175 | 16.8482 | 16.8104 | 16.8375 | 675500.0 |
| 2013-02-08 07:45:00 | AAPL | Stock | 16.8375 | 16.8482 | 16.8243 | 16.8482 | 372540.0 |
| 2013-02-08 07:50:00 | AAPL | Stock | 16.8482 | 16.8482 | 16.8275 | 16.8389 | 584864.0 |
| 2013-02-08 07:55:00 | AAPL | Stock | 16.8407 | 16.8732 | 16.8407 | 16.8729 | 749364.0 |
| 2013-02-08 08:00:00 | AAPL | Stock | 16.8664 | 16.8714 | 16.7857 | 16.8321 | 1889440.0 |
| 2013-02-08 08:05:00 | AAPL | Stock | 16.8271 | 16.8339 | 16.8125 | 16.825 | 701792.0 |
| 2013-02-08 08:10:00 | AAPL | Stock | 16.8236 | 16.85 | 16.8157 | 16.8389 | 889924.0 |
| 2013-02-08 08:15:00 | AAPL | Stock | 16.8371 | 16.8714 | 16.8354 | 16.8414 | 840196.0 |
| 2013-02-08 08:20:00 | AAPL | Stock | 16.8518 | 16.8518 | 16.8143 | 16.8143 | 414624.0 |
| 2013-02-08 08:25:00 | AAPL | Stock | 16.8139 | 16.8179 | 16.795 | 16.8046 | 448756.0 |
| 2013-02-08 08:30:00 | AAPL | Stock | 16.7993 | 16.8179 | 16.7993 | 16.8057 | 457688.0 |
| 2013-02-08 08:35:00 | AAPL | Stock | 16.8068 | 16.8568 | 16.8036 | 16.8564 | 1165164.0 |
| 2013-02-08 08:40:00 | AAPL | Stock | 16.8482 | 16.8657 | 16.8421 | 16.8571 | 914760.0 |
| 2013-02-08 08:45:00 | AAPL | Stock | 16.8546 | 16.8707 | 16.8482 | 16.8679 | 866292.0 |
| 2013-02-08 08:50:00 | AAPL | Stock | 16.8657 | 16.8743 | 16.85 | 16.8586 | 1194816.0 |
| 2013-02-08 08:55:00 | AAPL | Stock | 16.8571 | 16.8571 | 16.82 | 16.8343 | 974232.0 |
| 2013-02-08 09:00:00 | AAPL | Stock | 16.8343 | 16.8554 | 16.8325 | 16.8514 | 521948.0 |
| 2013-02-08 09:05:00 | AAPL | Stock | 16.8518 | 16.8636 | 16.8471 | 16.8629 | 531720.0 |
| 2013-02-08 09:10:00 | AAPL | Stock | 16.8629 | 16.8929 | 16.8571 | 16.8921 | 1060584.0 |
| 2013-02-08 09:15:00 | AAPL | Stock | 16.89 | 16.8929 | 16.8661 | 16.8675 | 642348.0 |
| 2013-02-08 09:20:00 | AAPL | Stock | 16.8643 | 16.9007 | 16.8643 | 16.9007 | 1097348.0 |
| 2013-02-08 09:25:00 | AAPL | Stock | 16.8971 | 16.9321 | 16.8818 | 16.9314 | 2540356.0 |
| 2013-02-08 09:30:00 | AAPL | Stock | 16.9318 | 16.9357 | 16.8057 | 16.8296 | 45319344.0 |
> showing 50 of 318,133 rows — these rows as CSV