PREVIEW / stock_1min / 2012-06-19
file: by_date/stock_1min/2012/2012-06-19.parquet size: 13.5 MB rows: 1,009,065 symbols: 2,855
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-06-19 04:11:00 | AAPL | Stock | 20.8575 | 20.8575 | 20.8571 | 20.8571 | 19600.0 |
| 2012-06-19 04:17:00 | AAPL | Stock | 20.8571 | 20.8571 | 20.8571 | 20.8571 | 11200.0 |
| 2012-06-19 04:55:00 | AAPL | Stock | 20.875 | 20.875 | 20.875 | 20.875 | 4900.0 |
| 2012-06-19 04:57:00 | AAPL | Stock | 20.875 | 20.875 | 20.875 | 20.875 | 2800.0 |
| 2012-06-19 05:01:00 | AAPL | Stock | 20.85 | 20.85 | 20.85 | 20.85 | 8400.0 |
| 2012-06-19 05:12:00 | AAPL | Stock | 20.875 | 20.875 | 20.875 | 20.875 | 2800.0 |
| 2012-06-19 05:41:00 | AAPL | Stock | 20.8839 | 20.8839 | 20.8839 | 20.8839 | 14000.0 |
| 2012-06-19 05:47:00 | AAPL | Stock | 20.9043 | 20.9043 | 20.9043 | 20.9043 | 2800.0 |
| 2012-06-19 05:48:00 | AAPL | Stock | 20.9043 | 20.9043 | 20.9043 | 20.9043 | 5600.0 |
| 2012-06-19 05:49:00 | AAPL | Stock | 20.9043 | 20.9043 | 20.9043 | 20.9043 | 5600.0 |
| 2012-06-19 05:55:00 | AAPL | Stock | 20.9286 | 20.9286 | 20.9286 | 20.9286 | 12600.0 |
| 2012-06-19 06:12:00 | AAPL | Stock | 20.9286 | 20.9286 | 20.9286 | 20.9286 | 2800.0 |
| 2012-06-19 06:20:00 | AAPL | Stock | 20.9107 | 20.9107 | 20.9107 | 20.9107 | 4900.0 |
| 2012-06-19 07:00:00 | AAPL | Stock | 20.9193 | 20.9193 | 20.9193 | 20.9193 | 2800.0 |
| 2012-06-19 07:01:00 | AAPL | Stock | 20.9196 | 20.9286 | 20.9196 | 20.9282 | 41160.0 |
| 2012-06-19 07:02:00 | AAPL | Stock | 20.9286 | 20.9286 | 20.9286 | 20.9286 | 8400.0 |
| 2012-06-19 07:03:00 | AAPL | Stock | 20.9107 | 20.9107 | 20.9107 | 20.9107 | 8400.0 |
| 2012-06-19 07:04:00 | AAPL | Stock | 20.9104 | 20.9107 | 20.8864 | 20.8929 | 40600.0 |
| 2012-06-19 07:05:00 | AAPL | Stock | 20.8929 | 20.8986 | 20.8929 | 20.8986 | 14000.0 |
| 2012-06-19 07:06:00 | AAPL | Stock | 20.8989 | 20.8989 | 20.8989 | 20.8989 | 5600.0 |
| 2012-06-19 07:08:00 | AAPL | Stock | 20.9193 | 20.9286 | 20.9193 | 20.9286 | 25760.0 |
| 2012-06-19 07:09:00 | AAPL | Stock | 20.9218 | 20.9286 | 20.9218 | 20.9286 | 14980.0 |
| 2012-06-19 07:10:00 | AAPL | Stock | 20.9286 | 20.9286 | 20.9286 | 20.9286 | 22400.0 |
| 2012-06-19 07:11:00 | AAPL | Stock | 20.9425 | 20.9429 | 20.9425 | 20.9429 | 11200.0 |
| 2012-06-19 07:12:00 | AAPL | Stock | 20.9454 | 20.9464 | 20.9454 | 20.9464 | 30800.0 |
| 2012-06-19 07:13:00 | AAPL | Stock | 20.9464 | 20.9464 | 20.9368 | 20.9368 | 5600.0 |
| 2012-06-19 07:14:00 | AAPL | Stock | 20.9464 | 20.9464 | 20.9464 | 20.9464 | 5600.0 |
| 2012-06-19 07:18:00 | AAPL | Stock | 20.9554 | 20.9554 | 20.9464 | 20.9464 | 100576.0 |
| 2012-06-19 07:22:00 | AAPL | Stock | 20.9482 | 20.9482 | 20.9482 | 20.9482 | 11172.0 |
| 2012-06-19 07:23:00 | AAPL | Stock | 20.9589 | 20.9646 | 20.9589 | 20.9646 | 124320.0 |
| 2012-06-19 07:25:00 | AAPL | Stock | 20.9761 | 20.98 | 20.9732 | 20.9732 | 16772.0 |
| 2012-06-19 07:26:00 | AAPL | Stock | 20.9571 | 20.9571 | 20.9339 | 20.9339 | 37800.0 |
| 2012-06-19 07:27:00 | AAPL | Stock | 20.9464 | 20.9536 | 20.9464 | 20.9536 | 8400.0 |
| 2012-06-19 07:28:00 | AAPL | Stock | 20.9532 | 20.9536 | 20.9532 | 20.9536 | 70000.0 |
| 2012-06-19 07:29:00 | AAPL | Stock | 20.95 | 20.95 | 20.9482 | 20.9482 | 16800.0 |
| 2012-06-19 07:30:00 | AAPL | Stock | 20.9532 | 20.9536 | 20.9532 | 20.9536 | 16520.0 |
| 2012-06-19 07:33:00 | AAPL | Stock | 20.955 | 20.9571 | 20.9546 | 20.9546 | 35840.0 |
| 2012-06-19 07:34:00 | AAPL | Stock | 20.9464 | 20.9471 | 20.9411 | 20.9429 | 39200.0 |
| 2012-06-19 07:35:00 | AAPL | Stock | 20.9518 | 20.9518 | 20.9518 | 20.9518 | 2800.0 |
| 2012-06-19 07:36:00 | AAPL | Stock | 20.9407 | 20.9407 | 20.9375 | 20.9375 | 8400.0 |
| 2012-06-19 07:37:00 | AAPL | Stock | 20.94 | 20.9536 | 20.94 | 20.9536 | 18200.0 |
| 2012-06-19 07:38:00 | AAPL | Stock | 20.9536 | 20.9643 | 20.9536 | 20.9639 | 84840.0 |
| 2012-06-19 07:39:00 | AAPL | Stock | 20.9589 | 20.9589 | 20.9489 | 20.9496 | 61600.0 |
| 2012-06-19 07:40:00 | AAPL | Stock | 20.9571 | 20.9571 | 20.9571 | 20.9571 | 5600.0 |
| 2012-06-19 07:41:00 | AAPL | Stock | 20.9571 | 20.9571 | 20.9532 | 20.9571 | 36400.0 |
| 2012-06-19 07:42:00 | AAPL | Stock | 20.9554 | 20.9554 | 20.9543 | 20.9554 | 11200.0 |
| 2012-06-19 07:43:00 | AAPL | Stock | 20.9554 | 20.9611 | 20.9536 | 20.9611 | 24640.0 |
| 2012-06-19 07:44:00 | AAPL | Stock | 20.9554 | 20.9554 | 20.9464 | 20.9464 | 25200.0 |
| 2012-06-19 07:45:00 | AAPL | Stock | 20.945 | 20.945 | 20.9382 | 20.9429 | 56700.0 |
| 2012-06-19 07:47:00 | AAPL | Stock | 20.94 | 20.94 | 20.9304 | 20.9304 | 21840.0 |
> showing 50 of 1,009,065 rows — these rows as CSV