PREVIEW / stock_1min / 2012-11-29
file: by_date/stock_1min/2012/2012-11-29.parquet size: 12.8 MB rows: 955,305 symbols: 2,823
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-11-29 04:18:00 | AAPL | Stock | 20.9321 | 20.9321 | 20.9314 | 20.9314 | 8400.0 |
| 2012-11-29 04:37:00 | AAPL | Stock | 20.9464 | 20.9464 | 20.9464 | 20.9464 | 8400.0 |
| 2012-11-29 04:52:00 | AAPL | Stock | 20.9429 | 20.9429 | 20.9375 | 20.9375 | 25200.0 |
| 2012-11-29 05:10:00 | AAPL | Stock | 20.9464 | 20.9464 | 20.9464 | 20.9464 | 2800.0 |
| 2012-11-29 05:11:00 | AAPL | Stock | 20.9464 | 20.9464 | 20.9464 | 20.9464 | 5600.0 |
| 2012-11-29 05:12:00 | AAPL | Stock | 20.9464 | 20.9464 | 20.9464 | 20.9464 | 5600.0 |
| 2012-11-29 05:13:00 | AAPL | Stock | 20.9464 | 20.9464 | 20.9464 | 20.9464 | 9800.0 |
| 2012-11-29 05:14:00 | AAPL | Stock | 20.95 | 20.95 | 20.95 | 20.95 | 2800.0 |
| 2012-11-29 05:18:00 | AAPL | Stock | 20.9396 | 20.9396 | 20.9396 | 20.9396 | 2800.0 |
| 2012-11-29 05:43:00 | AAPL | Stock | 20.9314 | 20.9314 | 20.9314 | 20.9314 | 2800.0 |
| 2012-11-29 05:52:00 | AAPL | Stock | 20.9607 | 20.9607 | 20.9607 | 20.9607 | 16800.0 |
| 2012-11-29 06:15:00 | AAPL | Stock | 20.9582 | 20.9582 | 20.9582 | 20.9582 | 2800.0 |
| 2012-11-29 06:21:00 | AAPL | Stock | 20.9307 | 20.9307 | 20.9307 | 20.9307 | 5600.0 |
| 2012-11-29 06:34:00 | AAPL | Stock | 20.9464 | 20.9464 | 20.9464 | 20.9464 | 2800.0 |
| 2012-11-29 06:39:00 | AAPL | Stock | 20.9464 | 20.9464 | 20.9464 | 20.9464 | 2800.0 |
| 2012-11-29 06:48:00 | AAPL | Stock | 20.9464 | 20.9536 | 20.9464 | 20.9536 | 14000.0 |
| 2012-11-29 06:54:00 | AAPL | Stock | 20.9339 | 20.9339 | 20.9339 | 20.9339 | 2800.0 |
| 2012-11-29 06:59:00 | AAPL | Stock | 20.9607 | 20.9607 | 20.9607 | 20.9607 | 2800.0 |
| 2012-11-29 07:03:00 | AAPL | Stock | 20.96 | 20.96 | 20.9464 | 20.96 | 20440.0 |
| 2012-11-29 07:04:00 | AAPL | Stock | 20.9607 | 20.9607 | 20.9571 | 20.9596 | 47124.0 |
| 2012-11-29 07:06:00 | AAPL | Stock | 20.9536 | 20.9536 | 20.9536 | 20.9536 | 2800.0 |
| 2012-11-29 07:07:00 | AAPL | Stock | 20.9536 | 20.9543 | 20.9536 | 20.9543 | 8400.0 |
| 2012-11-29 07:09:00 | AAPL | Stock | 20.9536 | 20.9536 | 20.9375 | 20.9375 | 19600.0 |
| 2012-11-29 07:10:00 | AAPL | Stock | 20.9375 | 20.9375 | 20.9321 | 20.9321 | 5600.0 |
| 2012-11-29 07:11:00 | AAPL | Stock | 20.9296 | 20.9296 | 20.9243 | 20.9246 | 19600.0 |
| 2012-11-29 07:12:00 | AAPL | Stock | 20.9375 | 20.9554 | 20.9375 | 20.9554 | 64400.0 |
| 2012-11-29 07:13:00 | AAPL | Stock | 20.9589 | 20.9714 | 20.9589 | 20.9714 | 61796.0 |
| 2012-11-29 07:14:00 | AAPL | Stock | 20.9664 | 20.9679 | 20.9643 | 20.9679 | 49420.0 |
| 2012-11-29 07:16:00 | AAPL | Stock | 20.9654 | 20.9657 | 20.9643 | 20.9643 | 30380.0 |
| 2012-11-29 07:17:00 | AAPL | Stock | 20.9725 | 20.975 | 20.9693 | 20.9693 | 36344.0 |
| 2012-11-29 07:18:00 | AAPL | Stock | 20.9721 | 20.9818 | 20.9721 | 20.9818 | 5600.0 |
| 2012-11-29 07:19:00 | AAPL | Stock | 20.9821 | 20.9821 | 20.9818 | 20.9818 | 8400.0 |
| 2012-11-29 07:20:00 | AAPL | Stock | 20.9696 | 20.9696 | 20.9696 | 20.9696 | 25200.0 |
| 2012-11-29 07:21:00 | AAPL | Stock | 20.9814 | 20.9814 | 20.9814 | 20.9814 | 2800.0 |
| 2012-11-29 07:22:00 | AAPL | Stock | 20.9732 | 20.9786 | 20.9732 | 20.9786 | 8400.0 |
| 2012-11-29 07:23:00 | AAPL | Stock | 20.9704 | 20.9704 | 20.9679 | 20.9679 | 32200.0 |
| 2012-11-29 07:24:00 | AAPL | Stock | 20.9643 | 20.9654 | 20.9643 | 20.9643 | 35840.0 |
| 2012-11-29 07:25:00 | AAPL | Stock | 20.97 | 20.97 | 20.9643 | 20.9643 | 32480.0 |
| 2012-11-29 07:26:00 | AAPL | Stock | 20.9643 | 20.9643 | 20.9643 | 20.9643 | 19964.0 |
| 2012-11-29 07:27:00 | AAPL | Stock | 20.9654 | 20.9654 | 20.9654 | 20.9654 | 11200.0 |
| 2012-11-29 07:28:00 | AAPL | Stock | 20.97 | 20.9732 | 20.97 | 20.9732 | 8400.0 |
| 2012-11-29 07:29:00 | AAPL | Stock | 20.9732 | 20.9732 | 20.9732 | 20.9732 | 6160.0 |
| 2012-11-29 07:30:00 | AAPL | Stock | 20.9818 | 20.9818 | 20.9818 | 20.9818 | 2800.0 |
| 2012-11-29 07:31:00 | AAPL | Stock | 20.9832 | 20.9832 | 20.9832 | 20.9832 | 8400.0 |
| 2012-11-29 07:32:00 | AAPL | Stock | 20.9832 | 20.9832 | 20.9821 | 20.9821 | 14112.0 |
| 2012-11-29 07:33:00 | AAPL | Stock | 20.9818 | 20.9821 | 20.9811 | 20.9821 | 28000.0 |
| 2012-11-29 07:34:00 | AAPL | Stock | 20.9736 | 20.9832 | 20.9736 | 20.9832 | 6720.0 |
| 2012-11-29 07:37:00 | AAPL | Stock | 20.9821 | 20.9821 | 20.9818 | 20.9821 | 23940.0 |
| 2012-11-29 07:40:00 | AAPL | Stock | 20.9861 | 21.0125 | 20.9836 | 21.0125 | 84000.0 |
| 2012-11-29 07:41:00 | AAPL | Stock | 21.0121 | 21.0179 | 21.0121 | 21.0175 | 25200.0 |
> showing 50 of 955,305 rows — these rows as CSV