PREVIEW / stock_5min / 2013-01-22
file: by_date/stock_5min/2013/2013-01-22.parquet size: 5.0 MB rows: 333,163 symbols: 3,501
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-01-22 04:00:00 | AAPL | Stock | 17.8714 | 17.8714 | 17.8714 | 17.8714 | 6916.0 |
| 2013-01-22 04:05:00 | AAPL | Stock | 17.8393 | 17.8393 | 17.825 | 17.8393 | 14000.0 |
| 2013-01-22 04:15:00 | AAPL | Stock | 17.8107 | 17.8107 | 17.8 | 17.8 | 44800.0 |
| 2013-01-22 04:20:00 | AAPL | Stock | 17.8393 | 17.8393 | 17.8393 | 17.8393 | 4200.0 |
| 2013-01-22 04:25:00 | AAPL | Stock | 17.8679 | 17.8679 | 17.8679 | 17.8679 | 2800.0 |
| 2013-01-22 04:30:00 | AAPL | Stock | 17.8696 | 17.8696 | 17.8696 | 17.8696 | 2800.0 |
| 2013-01-22 04:35:00 | AAPL | Stock | 17.89 | 17.915 | 17.8886 | 17.915 | 19600.0 |
| 2013-01-22 04:40:00 | AAPL | Stock | 17.9032 | 17.9032 | 17.9032 | 17.9032 | 11200.0 |
| 2013-01-22 04:45:00 | AAPL | Stock | 17.9046 | 17.9046 | 17.9046 | 17.9046 | 2800.0 |
| 2013-01-22 04:50:00 | AAPL | Stock | 17.9036 | 17.9036 | 17.9011 | 17.9011 | 8400.0 |
| 2013-01-22 04:55:00 | AAPL | Stock | 17.9118 | 17.9118 | 17.9118 | 17.9118 | 2800.0 |
| 2013-01-22 05:00:00 | AAPL | Stock | 17.9118 | 17.9118 | 17.9118 | 17.9118 | 2800.0 |
| 2013-01-22 05:05:00 | AAPL | Stock | 17.9189 | 17.9189 | 17.9189 | 17.9189 | 11200.0 |
| 2013-01-22 05:10:00 | AAPL | Stock | 17.9243 | 17.9243 | 17.9243 | 17.9243 | 2800.0 |
| 2013-01-22 05:15:00 | AAPL | Stock | 17.9321 | 17.9464 | 17.9321 | 17.9464 | 8400.0 |
| 2013-01-22 05:20:00 | AAPL | Stock | 17.955 | 17.9857 | 17.955 | 17.9857 | 16800.0 |
| 2013-01-22 05:25:00 | AAPL | Stock | 17.9839 | 17.9875 | 17.9839 | 17.9875 | 12600.0 |
| 2013-01-22 05:30:00 | AAPL | Stock | 17.9871 | 17.9871 | 17.9732 | 17.9732 | 11200.0 |
| 2013-01-22 05:40:00 | AAPL | Stock | 17.9732 | 17.9732 | 17.9732 | 17.9732 | 6972.0 |
| 2013-01-22 05:45:00 | AAPL | Stock | 17.9732 | 17.9732 | 17.9732 | 17.9732 | 2800.0 |
| 2013-01-22 05:50:00 | AAPL | Stock | 17.9732 | 17.9732 | 17.9643 | 17.9643 | 19600.0 |
| 2013-01-22 06:00:00 | AAPL | Stock | 17.9814 | 17.9825 | 17.9807 | 17.9825 | 33600.0 |
| 2013-01-22 06:05:00 | AAPL | Stock | 17.9861 | 17.9861 | 17.9854 | 17.9854 | 11200.0 |
| 2013-01-22 06:10:00 | AAPL | Stock | 17.9718 | 17.9718 | 17.9679 | 17.9679 | 61600.0 |
| 2013-01-22 06:20:00 | AAPL | Stock | 17.9875 | 17.9875 | 17.9875 | 17.9875 | 2800.0 |
| 2013-01-22 06:40:00 | AAPL | Stock | 17.975 | 17.975 | 17.9443 | 17.9443 | 13160.0 |
| 2013-01-22 06:45:00 | AAPL | Stock | 17.9379 | 17.9379 | 17.9379 | 17.9379 | 11200.0 |
| 2013-01-22 06:50:00 | AAPL | Stock | 17.9464 | 17.9536 | 17.9464 | 17.9464 | 11200.0 |
| 2013-01-22 07:00:00 | AAPL | Stock | 17.9464 | 17.9464 | 17.9054 | 17.9054 | 134624.0 |
| 2013-01-22 07:05:00 | AAPL | Stock | 17.9011 | 17.9304 | 17.8929 | 17.9132 | 189000.0 |
| 2013-01-22 07:10:00 | AAPL | Stock | 17.9157 | 17.9286 | 17.9143 | 17.9286 | 66108.0 |
| 2013-01-22 07:15:00 | AAPL | Stock | 17.9375 | 17.9554 | 17.9375 | 17.9464 | 38472.0 |
| 2013-01-22 07:20:00 | AAPL | Stock | 17.9375 | 17.9571 | 17.9325 | 17.9554 | 63560.0 |
| 2013-01-22 07:25:00 | AAPL | Stock | 17.9536 | 17.9571 | 17.9286 | 17.9482 | 133476.0 |
| 2013-01-22 07:30:00 | AAPL | Stock | 17.9393 | 17.9425 | 17.9311 | 17.9425 | 33600.0 |
| 2013-01-22 07:35:00 | AAPL | Stock | 17.9432 | 17.9518 | 17.9371 | 17.9464 | 34244.0 |
| 2013-01-22 07:40:00 | AAPL | Stock | 17.955 | 17.9657 | 17.95 | 17.9657 | 283668.0 |
| 2013-01-22 07:45:00 | AAPL | Stock | 17.9664 | 17.9664 | 17.9464 | 17.9464 | 53760.0 |
| 2013-01-22 07:50:00 | AAPL | Stock | 17.945 | 17.945 | 17.9232 | 17.9243 | 239400.0 |
| 2013-01-22 07:55:00 | AAPL | Stock | 17.9255 | 17.9354 | 17.9179 | 17.9214 | 106344.0 |
| 2013-01-22 08:00:00 | AAPL | Stock | 17.9268 | 17.9607 | 17.875 | 17.8764 | 691124.0 |
| 2013-01-22 08:05:00 | AAPL | Stock | 17.875 | 17.8925 | 17.8214 | 17.8293 | 779716.0 |
| 2013-01-22 08:10:00 | AAPL | Stock | 17.8214 | 17.8564 | 17.8057 | 17.8214 | 549948.0 |
| 2013-01-22 08:15:00 | AAPL | Stock | 17.8214 | 17.875 | 17.8214 | 17.8643 | 311612.0 |
| 2013-01-22 08:20:00 | AAPL | Stock | 17.8643 | 17.865 | 17.8393 | 17.8411 | 292012.0 |
| 2013-01-22 08:25:00 | AAPL | Stock | 17.8407 | 17.8568 | 17.8407 | 17.8568 | 86100.0 |
| 2013-01-22 08:30:00 | AAPL | Stock | 17.855 | 17.8696 | 17.8518 | 17.8536 | 290640.0 |
| 2013-01-22 08:35:00 | AAPL | Stock | 17.8571 | 17.8757 | 17.8568 | 17.8607 | 183120.0 |
| 2013-01-22 08:40:00 | AAPL | Stock | 17.8611 | 17.985 | 17.8571 | 17.985 | 1181292.0 |
| 2013-01-22 08:45:00 | AAPL | Stock | 17.985 | 18.0136 | 17.9407 | 17.9489 | 1563212.0 |
> showing 50 of 333,163 rows — these rows as CSV