PREVIEW / stock_5min / 2013-12-17
file: by_date/stock_5min/2013/2013-12-17.parquet size: 5.4 MB rows: 358,640 symbols: 3,560
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-17 04:20:00 | AAPL | Stock | 19.9011 | 19.9011 | 19.9011 | 19.9011 | 2800.0 |
| 2013-12-17 05:00:00 | AAPL | Stock | 19.9089 | 19.9089 | 19.9089 | 19.9089 | 2800.0 |
| 2013-12-17 06:30:00 | AAPL | Stock | 19.9089 | 19.9089 | 19.9089 | 19.9089 | 2800.0 |
| 2013-12-17 07:00:00 | AAPL | Stock | 19.9125 | 19.925 | 19.9107 | 19.925 | 32452.0 |
| 2013-12-17 07:10:00 | AAPL | Stock | 19.9304 | 19.9304 | 19.9304 | 19.9304 | 2800.0 |
| 2013-12-17 07:20:00 | AAPL | Stock | 19.9475 | 19.9475 | 19.9379 | 19.9379 | 9800.0 |
| 2013-12-17 07:30:00 | AAPL | Stock | 19.9493 | 19.9493 | 19.9382 | 19.9382 | 22400.0 |
| 2013-12-17 07:35:00 | AAPL | Stock | 19.9296 | 19.9296 | 19.9296 | 19.9296 | 5600.0 |
| 2013-12-17 07:45:00 | AAPL | Stock | 19.9321 | 19.9375 | 19.9321 | 19.9357 | 13720.0 |
| 2013-12-17 07:50:00 | AAPL | Stock | 19.9461 | 19.9461 | 19.9461 | 19.9461 | 2800.0 |
| 2013-12-17 07:55:00 | AAPL | Stock | 19.9439 | 19.9439 | 19.9375 | 19.9375 | 33600.0 |
| 2013-12-17 08:00:00 | AAPL | Stock | 19.9393 | 19.9564 | 19.9036 | 19.9393 | 269136.0 |
| 2013-12-17 08:05:00 | AAPL | Stock | 19.9546 | 19.9639 | 19.9532 | 19.9536 | 43344.0 |
| 2013-12-17 08:10:00 | AAPL | Stock | 19.9579 | 19.9682 | 19.9579 | 19.9607 | 157192.0 |
| 2013-12-17 08:15:00 | AAPL | Stock | 19.9554 | 19.96 | 19.9554 | 19.96 | 14000.0 |
| 2013-12-17 08:20:00 | AAPL | Stock | 19.9468 | 19.9468 | 19.9439 | 19.9464 | 75880.0 |
| 2013-12-17 08:25:00 | AAPL | Stock | 19.9454 | 19.9464 | 19.9436 | 19.9464 | 33600.0 |
| 2013-12-17 08:30:00 | AAPL | Stock | 19.9464 | 19.95 | 19.9464 | 19.9496 | 30800.0 |
| 2013-12-17 08:35:00 | AAPL | Stock | 19.9464 | 19.9489 | 19.9393 | 19.9489 | 73024.0 |
| 2013-12-17 08:40:00 | AAPL | Stock | 19.9429 | 19.9429 | 19.935 | 19.935 | 67200.0 |
| 2013-12-17 08:45:00 | AAPL | Stock | 19.9446 | 19.9461 | 19.8929 | 19.9229 | 198212.0 |
| 2013-12-17 08:50:00 | AAPL | Stock | 19.9121 | 19.925 | 19.9121 | 19.9196 | 72800.0 |
| 2013-12-17 08:55:00 | AAPL | Stock | 19.9175 | 19.9175 | 19.9 | 19.9107 | 174580.0 |
| 2013-12-17 09:00:00 | AAPL | Stock | 19.9021 | 19.9071 | 19.9021 | 19.9036 | 21700.0 |
| 2013-12-17 09:05:00 | AAPL | Stock | 19.9071 | 19.9161 | 19.9057 | 19.9146 | 67620.0 |
| 2013-12-17 09:10:00 | AAPL | Stock | 19.9161 | 19.9218 | 19.9107 | 19.9211 | 19600.0 |
| 2013-12-17 09:15:00 | AAPL | Stock | 19.9107 | 19.9107 | 19.8982 | 19.8982 | 74900.0 |
| 2013-12-17 09:20:00 | AAPL | Stock | 19.8943 | 19.8943 | 19.8729 | 19.8879 | 112560.0 |
| 2013-12-17 09:25:00 | AAPL | Stock | 19.9 | 19.9046 | 19.85 | 19.85 | 467348.0 |
| 2013-12-17 09:30:00 | AAPL | Stock | 19.8518 | 19.9543 | 19.85 | 19.945 | 9504796.0 |
| 2013-12-17 09:35:00 | AAPL | Stock | 19.945 | 19.98 | 19.9139 | 19.9464 | 8190784.0 |
| 2013-12-17 09:40:00 | AAPL | Stock | 19.9429 | 19.9439 | 19.8979 | 19.9064 | 5946360.0 |
| 2013-12-17 09:45:00 | AAPL | Stock | 19.9027 | 19.915 | 19.8798 | 19.9025 | 3744048.0 |
| 2013-12-17 09:50:00 | AAPL | Stock | 19.9057 | 19.9061 | 19.8571 | 19.8639 | 3664388.0 |
| 2013-12-17 09:55:00 | AAPL | Stock | 19.8593 | 19.8907 | 19.85 | 19.8562 | 3173184.0 |
| 2013-12-17 10:00:00 | AAPL | Stock | 19.8539 | 19.8564 | 19.8168 | 19.85 | 6140736.0 |
| 2013-12-17 10:05:00 | AAPL | Stock | 19.85 | 19.8896 | 19.8375 | 19.888 | 3220756.0 |
| 2013-12-17 10:10:00 | AAPL | Stock | 19.8825 | 19.9118 | 19.8721 | 19.9082 | 3159044.0 |
| 2013-12-17 10:15:00 | AAPL | Stock | 19.9071 | 19.9106 | 19.88 | 19.8804 | 2304596.0 |
| 2013-12-17 10:20:00 | AAPL | Stock | 19.8804 | 19.8929 | 19.8646 | 19.875 | 1748516.0 |
| 2013-12-17 10:25:00 | AAPL | Stock | 19.8725 | 19.8907 | 19.8693 | 19.8861 | 971292.0 |
| 2013-12-17 10:30:00 | AAPL | Stock | 19.8871 | 19.8871 | 19.8432 | 19.8432 | 2702980.0 |
| 2013-12-17 10:35:00 | AAPL | Stock | 19.8468 | 19.8807 | 19.8429 | 19.8689 | 1664768.0 |
| 2013-12-17 10:40:00 | AAPL | Stock | 19.8704 | 19.8767 | 19.8675 | 19.8686 | 825048.0 |
| 2013-12-17 10:45:00 | AAPL | Stock | 19.8721 | 19.8746 | 19.8214 | 19.8214 | 4937828.0 |
| 2013-12-17 10:50:00 | AAPL | Stock | 19.8214 | 19.8396 | 19.8089 | 19.8329 | 2667784.0 |
| 2013-12-17 10:55:00 | AAPL | Stock | 19.8361 | 19.8364 | 19.7982 | 19.8191 | 2762228.0 |
| 2013-12-17 11:00:00 | AAPL | Stock | 19.8164 | 19.8236 | 19.7634 | 19.7796 | 4773468.0 |
| 2013-12-17 11:05:00 | AAPL | Stock | 19.7771 | 19.8082 | 19.7715 | 19.7937 | 3332084.0 |
| 2013-12-17 11:10:00 | AAPL | Stock | 19.795 | 19.8036 | 19.7768 | 19.8018 | 1557584.0 |
> showing 50 of 358,640 rows — these rows as CSV