PREVIEW / stock_1min / 2011-04-13
file: by_date/stock_1min/2011/2011-04-13.parquet size: 13.2 MB rows: 992,612 symbols: 2,866
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 |
|---|---|---|---|---|---|---|---|
| 2011-04-13 04:50:00 | AAPL | Stock | 11.9236 | 11.9236 | 11.9236 | 11.9236 | 2800.0 |
| 2011-04-13 05:05:00 | AAPL | Stock | 11.9236 | 11.9479 | 11.9236 | 11.9479 | 11200.0 |
| 2011-04-13 05:06:00 | AAPL | Stock | 11.95 | 11.95 | 11.95 | 11.95 | 2800.0 |
| 2011-04-13 05:10:00 | AAPL | Stock | 11.9418 | 11.9418 | 11.9418 | 11.9418 | 2800.0 |
| 2011-04-13 05:35:00 | AAPL | Stock | 11.9464 | 11.9464 | 11.9464 | 11.9464 | 2800.0 |
| 2011-04-13 06:12:00 | AAPL | Stock | 11.9682 | 11.9682 | 11.9661 | 11.9661 | 5600.0 |
| 2011-04-13 06:15:00 | AAPL | Stock | 11.9714 | 11.9729 | 11.9714 | 11.9729 | 5600.0 |
| 2011-04-13 06:17:00 | AAPL | Stock | 11.9729 | 11.9729 | 11.9729 | 11.9729 | 2800.0 |
| 2011-04-13 06:33:00 | AAPL | Stock | 11.9764 | 11.9764 | 11.9764 | 11.9764 | 2800.0 |
| 2011-04-13 07:00:00 | AAPL | Stock | 11.9696 | 11.9696 | 11.9696 | 11.9696 | 2800.0 |
| 2011-04-13 07:02:00 | AAPL | Stock | 11.9746 | 11.9746 | 11.9707 | 11.9707 | 16800.0 |
| 2011-04-13 07:03:00 | AAPL | Stock | 11.9643 | 11.9714 | 11.9571 | 11.9643 | 19600.0 |
| 2011-04-13 07:04:00 | AAPL | Stock | 11.9571 | 11.9571 | 11.9571 | 11.9571 | 2800.0 |
| 2011-04-13 07:06:00 | AAPL | Stock | 11.9571 | 11.9571 | 11.9479 | 11.9479 | 15372.0 |
| 2011-04-13 07:07:00 | AAPL | Stock | 11.9543 | 11.9571 | 11.9543 | 11.9571 | 17780.0 |
| 2011-04-13 07:14:00 | AAPL | Stock | 11.9643 | 11.9643 | 11.9639 | 11.9639 | 11200.0 |
| 2011-04-13 07:15:00 | AAPL | Stock | 11.9632 | 11.9636 | 11.9632 | 11.9636 | 11200.0 |
| 2011-04-13 07:16:00 | AAPL | Stock | 11.9632 | 11.9636 | 11.9632 | 11.9636 | 8400.0 |
| 2011-04-13 07:19:00 | AAPL | Stock | 11.9582 | 11.9607 | 11.9582 | 11.9589 | 11200.0 |
| 2011-04-13 07:20:00 | AAPL | Stock | 11.9607 | 11.9643 | 11.9607 | 11.9643 | 61880.0 |
| 2011-04-13 07:21:00 | AAPL | Stock | 11.9643 | 11.9643 | 11.9643 | 11.9643 | 52360.0 |
| 2011-04-13 07:22:00 | AAPL | Stock | 11.9686 | 11.9686 | 11.9625 | 11.9643 | 20552.0 |
| 2011-04-13 07:23:00 | AAPL | Stock | 11.9679 | 11.9707 | 11.9679 | 11.9707 | 8400.0 |
| 2011-04-13 07:24:00 | AAPL | Stock | 11.9679 | 11.9714 | 11.9679 | 11.9714 | 28000.0 |
| 2011-04-13 07:25:00 | AAPL | Stock | 11.9714 | 11.9714 | 11.9714 | 11.9714 | 90020.0 |
| 2011-04-13 07:26:00 | AAPL | Stock | 11.9775 | 11.9775 | 11.9775 | 11.9775 | 2800.0 |
| 2011-04-13 07:27:00 | AAPL | Stock | 11.9714 | 11.9714 | 11.97 | 11.9714 | 22400.0 |
| 2011-04-13 07:29:00 | AAPL | Stock | 11.9682 | 11.9696 | 11.9682 | 11.9696 | 5600.0 |
| 2011-04-13 07:30:00 | AAPL | Stock | 11.9711 | 11.9711 | 11.9711 | 11.9711 | 2800.0 |
| 2011-04-13 07:31:00 | AAPL | Stock | 11.9643 | 11.9664 | 11.9614 | 11.9643 | 25732.0 |
| 2011-04-13 07:32:00 | AAPL | Stock | 11.9696 | 11.9714 | 11.9696 | 11.9714 | 35140.0 |
| 2011-04-13 07:33:00 | AAPL | Stock | 11.9775 | 11.9786 | 11.9775 | 11.9775 | 11200.0 |
| 2011-04-13 07:34:00 | AAPL | Stock | 11.9775 | 11.985 | 11.9775 | 11.985 | 64400.0 |
| 2011-04-13 07:35:00 | AAPL | Stock | 11.9832 | 11.9832 | 11.9832 | 11.9832 | 5600.0 |
| 2011-04-13 07:36:00 | AAPL | Stock | 11.9804 | 11.9804 | 11.9775 | 11.9775 | 11200.0 |
| 2011-04-13 07:37:00 | AAPL | Stock | 11.9804 | 11.9839 | 11.9804 | 11.9839 | 11200.0 |
| 2011-04-13 07:38:00 | AAPL | Stock | 11.9807 | 11.9807 | 11.9807 | 11.9807 | 2800.0 |
| 2011-04-13 07:39:00 | AAPL | Stock | 11.9804 | 11.9836 | 11.9775 | 11.9775 | 83860.0 |
| 2011-04-13 07:40:00 | AAPL | Stock | 11.9821 | 11.9821 | 11.9821 | 11.9821 | 30800.0 |
| 2011-04-13 07:42:00 | AAPL | Stock | 11.9786 | 11.9789 | 11.9775 | 11.9775 | 44800.0 |
| 2011-04-13 07:43:00 | AAPL | Stock | 11.9775 | 11.9786 | 11.9775 | 11.9775 | 29680.0 |
| 2011-04-13 07:44:00 | AAPL | Stock | 11.9786 | 11.9786 | 11.9786 | 11.9786 | 2800.0 |
| 2011-04-13 07:45:00 | AAPL | Stock | 11.9786 | 11.9786 | 11.9786 | 11.9786 | 2800.0 |
| 2011-04-13 07:46:00 | AAPL | Stock | 11.9786 | 11.9804 | 11.9786 | 11.9786 | 22400.0 |
| 2011-04-13 07:47:00 | AAPL | Stock | 11.9804 | 11.9804 | 11.9804 | 11.9804 | 2800.0 |
| 2011-04-13 07:49:00 | AAPL | Stock | 11.9786 | 11.9786 | 11.9779 | 11.9779 | 12600.0 |
| 2011-04-13 07:50:00 | AAPL | Stock | 11.9775 | 11.9775 | 11.9775 | 11.9775 | 5012.0 |
| 2011-04-13 07:51:00 | AAPL | Stock | 11.9775 | 11.9775 | 11.9775 | 11.9775 | 13412.0 |
| 2011-04-13 07:52:00 | AAPL | Stock | 11.9775 | 11.9811 | 11.9775 | 11.9811 | 5600.0 |
| 2011-04-13 07:53:00 | AAPL | Stock | 11.9775 | 11.9775 | 11.9775 | 11.9775 | 2800.0 |
> showing 50 of 992,612 rows — these rows as CSV