PREVIEW / stock_5min / 2013-12-30
file: by_date/stock_5min/2013/2013-12-30.parquet size: 5.4 MB rows: 357,540 symbols: 3,546
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-12-30 04:20:00 | AAPL | Stock | 19.95 | 19.9643 | 19.95 | 19.9643 | 25760.0 |
| 2013-12-30 04:25:00 | AAPL | Stock | 19.9618 | 19.9671 | 19.9618 | 19.9671 | 14000.0 |
| 2013-12-30 04:30:00 | AAPL | Stock | 19.97 | 19.97 | 19.97 | 19.97 | 2800.0 |
| 2013-12-30 04:35:00 | AAPL | Stock | 19.9546 | 19.9643 | 19.9546 | 19.9643 | 14000.0 |
| 2013-12-30 05:00:00 | AAPL | Stock | 19.9643 | 19.9643 | 19.9643 | 19.9643 | 2800.0 |
| 2013-12-30 05:10:00 | AAPL | Stock | 19.9714 | 19.9714 | 19.9714 | 19.9714 | 2800.0 |
| 2013-12-30 05:30:00 | AAPL | Stock | 19.9643 | 19.9643 | 19.9643 | 19.9643 | 20776.0 |
| 2013-12-30 05:55:00 | AAPL | Stock | 19.9643 | 19.9686 | 19.9643 | 19.9686 | 19600.0 |
| 2013-12-30 06:10:00 | AAPL | Stock | 19.9464 | 19.9464 | 19.9464 | 19.9464 | 5600.0 |
| 2013-12-30 06:15:00 | AAPL | Stock | 19.9464 | 19.9464 | 19.9464 | 19.9464 | 19600.0 |
| 2013-12-30 06:25:00 | AAPL | Stock | 19.9286 | 19.9286 | 19.9286 | 19.9286 | 20972.0 |
| 2013-12-30 06:45:00 | AAPL | Stock | 19.9032 | 19.9032 | 19.9032 | 19.9032 | 5600.0 |
| 2013-12-30 06:50:00 | AAPL | Stock | 19.8771 | 19.8771 | 19.8771 | 19.8771 | 2800.0 |
| 2013-12-30 06:55:00 | AAPL | Stock | 19.8936 | 19.8936 | 19.8936 | 19.8936 | 8820.0 |
| 2013-12-30 07:00:00 | AAPL | Stock | 19.8925 | 19.9107 | 19.8925 | 19.9107 | 16800.0 |
| 2013-12-30 07:05:00 | AAPL | Stock | 19.9071 | 19.9182 | 19.9071 | 19.9182 | 8400.0 |
| 2013-12-30 07:10:00 | AAPL | Stock | 19.9114 | 19.9114 | 19.8839 | 19.8839 | 53200.0 |
| 2013-12-30 07:15:00 | AAPL | Stock | 19.8936 | 19.8936 | 19.8807 | 19.8807 | 68824.0 |
| 2013-12-30 07:20:00 | AAPL | Stock | 19.8786 | 19.8929 | 19.875 | 19.8768 | 75992.0 |
| 2013-12-30 07:25:00 | AAPL | Stock | 19.8818 | 19.8929 | 19.8668 | 19.8929 | 93464.0 |
| 2013-12-30 07:30:00 | AAPL | Stock | 19.9029 | 19.9068 | 19.8982 | 19.8982 | 11200.0 |
| 2013-12-30 07:35:00 | AAPL | Stock | 19.8957 | 19.8957 | 19.8857 | 19.8857 | 21672.0 |
| 2013-12-30 07:40:00 | AAPL | Stock | 19.8857 | 19.8954 | 19.8857 | 19.8954 | 5600.0 |
| 2013-12-30 07:50:00 | AAPL | Stock | 19.8929 | 19.9 | 19.8929 | 19.9 | 66080.0 |
| 2013-12-30 07:55:00 | AAPL | Stock | 19.8925 | 19.8925 | 19.8925 | 19.8925 | 2800.0 |
| 2013-12-30 08:00:00 | AAPL | Stock | 19.8929 | 19.9286 | 19.8821 | 19.9107 | 181636.0 |
| 2013-12-30 08:05:00 | AAPL | Stock | 19.9086 | 19.9107 | 19.8929 | 19.8929 | 133056.0 |
| 2013-12-30 08:10:00 | AAPL | Stock | 19.8929 | 19.8993 | 19.8679 | 19.8679 | 63812.0 |
| 2013-12-30 08:15:00 | AAPL | Stock | 19.89 | 19.8929 | 19.8696 | 19.8911 | 41244.0 |
| 2013-12-30 08:20:00 | AAPL | Stock | 19.8936 | 19.9018 | 19.8929 | 19.8929 | 86072.0 |
| 2013-12-30 08:25:00 | AAPL | Stock | 19.8929 | 19.9011 | 19.8893 | 19.9011 | 24052.0 |
| 2013-12-30 08:30:00 | AAPL | Stock | 19.9018 | 19.9164 | 19.8982 | 19.8982 | 167160.0 |
| 2013-12-30 08:35:00 | AAPL | Stock | 19.8936 | 19.91 | 19.8929 | 19.9036 | 82460.0 |
| 2013-12-30 08:40:00 | AAPL | Stock | 19.9011 | 19.9382 | 19.9011 | 19.9272 | 90692.0 |
| 2013-12-30 08:45:00 | AAPL | Stock | 19.9375 | 19.9464 | 19.9271 | 19.9379 | 183960.0 |
| 2013-12-30 08:50:00 | AAPL | Stock | 19.9321 | 19.9464 | 19.9229 | 19.935 | 123564.0 |
| 2013-12-30 08:55:00 | AAPL | Stock | 19.9425 | 19.9464 | 19.9364 | 19.9375 | 52976.0 |
| 2013-12-30 09:00:00 | AAPL | Stock | 19.9371 | 19.9371 | 19.9286 | 19.9286 | 114632.0 |
| 2013-12-30 09:05:00 | AAPL | Stock | 19.9264 | 19.9321 | 19.9264 | 19.9321 | 36400.0 |
| 2013-12-30 09:10:00 | AAPL | Stock | 19.9314 | 19.9332 | 19.9196 | 19.9196 | 89880.0 |
| 2013-12-30 09:15:00 | AAPL | Stock | 19.925 | 19.925 | 19.9175 | 19.9175 | 19852.0 |
| 2013-12-30 09:20:00 | AAPL | Stock | 19.9175 | 19.9175 | 19.9057 | 19.9057 | 75796.0 |
| 2013-12-30 09:25:00 | AAPL | Stock | 19.9025 | 19.9218 | 19.8943 | 19.9207 | 69300.0 |
| 2013-12-30 09:30:00 | AAPL | Stock | 19.9093 | 19.9304 | 19.8271 | 19.8321 | 9678256.0 |
| 2013-12-30 09:35:00 | AAPL | Stock | 19.828 | 19.8689 | 19.828 | 19.8561 | 5417972.0 |
| 2013-12-30 09:40:00 | AAPL | Stock | 19.8571 | 19.863 | 19.8232 | 19.8411 | 4208372.0 |
| 2013-12-30 09:45:00 | AAPL | Stock | 19.8389 | 19.8586 | 19.7986 | 19.8032 | 6338304.0 |
| 2013-12-30 09:50:00 | AAPL | Stock | 19.8 | 19.8393 | 19.7971 | 19.8346 | 6602092.0 |
| 2013-12-30 09:55:00 | AAPL | Stock | 19.8354 | 19.865 | 19.825 | 19.8604 | 9739352.0 |
| 2013-12-30 10:00:00 | AAPL | Stock | 19.8604 | 19.866 | 19.8204 | 19.8276 | 3516184.0 |
> showing 50 of 357,540 rows — these rows as CSV