PREVIEW / stock_5min / 2012-10-01
file: by_date/stock_5min/2012/2012-10-01.parquet size: 4.9 MB rows: 330,784 symbols: 3,476
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-10-01 04:00:00 | AAPL | Stock | 23.8093 | 23.925 | 23.8093 | 23.925 | 68740.0 |
| 2012-10-01 04:05:00 | AAPL | Stock | 23.8929 | 23.8929 | 23.8929 | 23.8929 | 28000.0 |
| 2012-10-01 04:10:00 | AAPL | Stock | 23.8964 | 23.8964 | 23.8964 | 23.8964 | 2800.0 |
| 2012-10-01 04:20:00 | AAPL | Stock | 23.9143 | 23.9143 | 23.9143 | 23.9143 | 2800.0 |
| 2012-10-01 04:25:00 | AAPL | Stock | 23.9286 | 23.9289 | 23.9286 | 23.9289 | 50960.0 |
| 2012-10-01 04:35:00 | AAPL | Stock | 23.9286 | 23.9286 | 23.9286 | 23.9286 | 7000.0 |
| 2012-10-01 05:00:00 | AAPL | Stock | 23.9446 | 23.9446 | 23.9446 | 23.9446 | 27160.0 |
| 2012-10-01 05:10:00 | AAPL | Stock | 23.9407 | 23.9407 | 23.9407 | 23.9407 | 2800.0 |
| 2012-10-01 05:20:00 | AAPL | Stock | 23.9446 | 23.9464 | 23.9446 | 23.9464 | 37800.0 |
| 2012-10-01 05:50:00 | AAPL | Stock | 23.9571 | 23.9571 | 23.9571 | 23.9571 | 9800.0 |
| 2012-10-01 05:55:00 | AAPL | Stock | 23.9679 | 23.9679 | 23.9679 | 23.9679 | 10220.0 |
| 2012-10-01 06:05:00 | AAPL | Stock | 23.95 | 23.95 | 23.95 | 23.95 | 5600.0 |
| 2012-10-01 06:10:00 | AAPL | Stock | 23.95 | 23.95 | 23.95 | 23.95 | 2800.0 |
| 2012-10-01 06:15:00 | AAPL | Stock | 23.95 | 23.95 | 23.95 | 23.95 | 4200.0 |
| 2012-10-01 06:40:00 | AAPL | Stock | 23.9429 | 23.9429 | 23.9429 | 23.9429 | 2800.0 |
| 2012-10-01 06:50:00 | AAPL | Stock | 23.9429 | 23.9429 | 23.9429 | 23.9429 | 2800.0 |
| 2012-10-01 07:00:00 | AAPL | Stock | 23.9571 | 23.9571 | 23.9286 | 23.9286 | 75992.0 |
| 2012-10-01 07:05:00 | AAPL | Stock | 23.9286 | 23.9286 | 23.9107 | 23.9107 | 40740.0 |
| 2012-10-01 07:10:00 | AAPL | Stock | 23.9107 | 23.9107 | 23.8654 | 23.8654 | 28168.0 |
| 2012-10-01 07:15:00 | AAPL | Stock | 23.8836 | 23.9086 | 23.8836 | 23.9071 | 30716.0 |
| 2012-10-01 07:20:00 | AAPL | Stock | 23.895 | 23.895 | 23.8857 | 23.8929 | 168000.0 |
| 2012-10-01 07:25:00 | AAPL | Stock | 23.8932 | 23.9036 | 23.875 | 23.875 | 32396.0 |
| 2012-10-01 07:30:00 | AAPL | Stock | 23.8929 | 23.9143 | 23.8929 | 23.9143 | 11256.0 |
| 2012-10-01 07:35:00 | AAPL | Stock | 23.9286 | 23.9357 | 23.9286 | 23.9286 | 91000.0 |
| 2012-10-01 07:40:00 | AAPL | Stock | 23.9282 | 23.9286 | 23.9239 | 23.9239 | 19600.0 |
| 2012-10-01 07:45:00 | AAPL | Stock | 23.9289 | 23.9461 | 23.9286 | 23.9375 | 37072.0 |
| 2012-10-01 07:50:00 | AAPL | Stock | 23.9325 | 23.9375 | 23.9304 | 23.9339 | 33404.0 |
| 2012-10-01 07:55:00 | AAPL | Stock | 23.9375 | 24.0 | 23.9375 | 23.9879 | 353696.0 |
| 2012-10-01 08:00:00 | AAPL | Stock | 23.9604 | 23.9964 | 23.9286 | 23.9489 | 278656.0 |
| 2012-10-01 08:05:00 | AAPL | Stock | 23.9518 | 23.9632 | 23.8307 | 23.9604 | 94920.0 |
| 2012-10-01 08:10:00 | AAPL | Stock | 23.9604 | 23.9604 | 23.9311 | 23.9311 | 153776.0 |
| 2012-10-01 08:15:00 | AAPL | Stock | 23.9304 | 23.9518 | 23.92 | 23.9518 | 274960.0 |
| 2012-10-01 08:20:00 | AAPL | Stock | 23.9507 | 23.9589 | 23.9411 | 23.95 | 92960.0 |
| 2012-10-01 08:25:00 | AAPL | Stock | 23.9464 | 23.9532 | 23.9464 | 23.9532 | 34944.0 |
| 2012-10-01 08:30:00 | AAPL | Stock | 23.9518 | 23.9857 | 23.9518 | 23.9821 | 365260.0 |
| 2012-10-01 08:35:00 | AAPL | Stock | 23.9857 | 23.9929 | 23.9818 | 23.9818 | 200452.0 |
| 2012-10-01 08:40:00 | AAPL | Stock | 23.9771 | 23.985 | 23.9718 | 23.9786 | 118944.0 |
| 2012-10-01 08:45:00 | AAPL | Stock | 23.9736 | 23.9893 | 23.9736 | 23.9893 | 68516.0 |
| 2012-10-01 08:50:00 | AAPL | Stock | 23.9893 | 24.0 | 23.9893 | 23.9929 | 167160.0 |
| 2012-10-01 08:55:00 | AAPL | Stock | 23.9929 | 24.0071 | 23.9821 | 23.9896 | 327740.0 |
| 2012-10-01 09:00:00 | AAPL | Stock | 23.9918 | 24.0 | 23.9843 | 24.0 | 116228.0 |
| 2012-10-01 09:05:00 | AAPL | Stock | 24.0 | 24.0 | 23.9839 | 23.9893 | 254212.0 |
| 2012-10-01 09:10:00 | AAPL | Stock | 23.9732 | 23.98 | 23.9686 | 23.9686 | 82180.0 |
| 2012-10-01 09:15:00 | AAPL | Stock | 23.975 | 23.9761 | 23.9607 | 23.9607 | 237832.0 |
| 2012-10-01 09:20:00 | AAPL | Stock | 23.9589 | 23.9589 | 23.935 | 23.9482 | 204092.0 |
| 2012-10-01 09:25:00 | AAPL | Stock | 23.9482 | 23.9821 | 23.9482 | 23.975 | 301168.0 |
| 2012-10-01 09:30:00 | AAPL | Stock | 23.9714 | 23.9821 | 23.8693 | 23.8934 | 17187268.0 |
| 2012-10-01 09:35:00 | AAPL | Stock | 23.8996 | 23.9093 | 23.8268 | 23.8664 | 11456452.0 |
| 2012-10-01 09:40:00 | AAPL | Stock | 23.8629 | 23.9239 | 23.8126 | 23.91 | 9973096.0 |
| 2012-10-01 09:45:00 | AAPL | Stock | 23.9143 | 24.0232 | 23.8981 | 23.9836 | 14264236.0 |
> showing 50 of 330,784 rows — these rows as CSV