PREVIEW / stock_1min / 2010-07-15
file: by_date/stock_1min/2010/2010-07-15.parquet size: 12.0 MB rows: 920,255 symbols: 2,793
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 |
|---|---|---|---|---|---|---|---|
| 2010-07-15 06:13:00 | AAPL | Stock | 8.9736 | 8.9736 | 8.9721 | 8.9721 | 11200.0 |
| 2010-07-15 06:14:00 | AAPL | Stock | 8.9721 | 8.9721 | 8.9721 | 8.9721 | 2800.0 |
| 2010-07-15 06:25:00 | AAPL | Stock | 9.0 | 9.0 | 9.0 | 9.0 | 5600.0 |
| 2010-07-15 06:46:00 | AAPL | Stock | 9.0075 | 9.0075 | 9.0075 | 9.0075 | 2800.0 |
| 2010-07-15 06:47:00 | AAPL | Stock | 9.0075 | 9.0093 | 9.0075 | 9.0093 | 5600.0 |
| 2010-07-15 06:52:00 | AAPL | Stock | 9.0179 | 9.0179 | 9.0179 | 9.0179 | 2800.0 |
| 2010-07-15 07:03:00 | AAPL | Stock | 9.0 | 9.0193 | 9.0 | 9.0193 | 14812.0 |
| 2010-07-15 07:06:00 | AAPL | Stock | 9.0246 | 9.0254 | 9.0246 | 9.0254 | 11200.0 |
| 2010-07-15 07:08:00 | AAPL | Stock | 9.0179 | 9.0179 | 9.0179 | 9.0179 | 2800.0 |
| 2010-07-15 07:10:00 | AAPL | Stock | 9.0221 | 9.0268 | 9.0221 | 9.0264 | 20832.0 |
| 2010-07-15 07:18:00 | AAPL | Stock | 9.0143 | 9.0143 | 9.0143 | 9.0143 | 5600.0 |
| 2010-07-15 07:19:00 | AAPL | Stock | 9.0004 | 9.0004 | 9.0004 | 9.0004 | 2800.0 |
| 2010-07-15 07:20:00 | AAPL | Stock | 9.0 | 9.0 | 9.0 | 9.0 | 11200.0 |
| 2010-07-15 07:21:00 | AAPL | Stock | 9.0 | 9.0 | 9.0 | 9.0 | 2800.0 |
| 2010-07-15 07:23:00 | AAPL | Stock | 8.9807 | 8.9857 | 8.9768 | 8.9768 | 24640.0 |
| 2010-07-15 07:24:00 | AAPL | Stock | 8.975 | 8.975 | 8.9629 | 8.9629 | 22400.0 |
| 2010-07-15 07:26:00 | AAPL | Stock | 8.9604 | 8.9607 | 8.9604 | 8.9607 | 8400.0 |
| 2010-07-15 07:27:00 | AAPL | Stock | 8.9604 | 8.9607 | 8.9604 | 8.9607 | 8400.0 |
| 2010-07-15 07:28:00 | AAPL | Stock | 8.9604 | 8.9604 | 8.9521 | 8.9604 | 14000.0 |
| 2010-07-15 07:31:00 | AAPL | Stock | 8.9607 | 8.9607 | 8.9607 | 8.9607 | 2800.0 |
| 2010-07-15 07:33:00 | AAPL | Stock | 8.9543 | 8.9543 | 8.9543 | 8.9543 | 11200.0 |
| 2010-07-15 07:34:00 | AAPL | Stock | 8.9539 | 8.9543 | 8.9321 | 8.9321 | 113932.0 |
| 2010-07-15 07:35:00 | AAPL | Stock | 8.9325 | 8.9325 | 8.9304 | 8.9304 | 22400.0 |
| 2010-07-15 07:36:00 | AAPL | Stock | 8.9479 | 8.9529 | 8.9461 | 8.9461 | 11200.0 |
| 2010-07-15 07:37:00 | AAPL | Stock | 8.9521 | 8.9525 | 8.9464 | 8.9525 | 16800.0 |
| 2010-07-15 07:38:00 | AAPL | Stock | 8.9536 | 8.9554 | 8.9536 | 8.9536 | 28140.0 |
| 2010-07-15 07:39:00 | AAPL | Stock | 8.9532 | 8.9543 | 8.9532 | 8.9539 | 36400.0 |
| 2010-07-15 07:40:00 | AAPL | Stock | 8.9543 | 8.9721 | 8.9543 | 8.9721 | 71932.0 |
| 2010-07-15 07:41:00 | AAPL | Stock | 8.9643 | 8.9643 | 8.9539 | 8.9539 | 68600.0 |
| 2010-07-15 07:42:00 | AAPL | Stock | 8.9593 | 8.9593 | 8.9593 | 8.9593 | 8400.0 |
| 2010-07-15 07:44:00 | AAPL | Stock | 8.9539 | 8.9539 | 8.9464 | 8.9464 | 75600.0 |
| 2010-07-15 07:45:00 | AAPL | Stock | 8.9461 | 8.9464 | 8.9461 | 8.9464 | 49840.0 |
| 2010-07-15 07:47:00 | AAPL | Stock | 8.9475 | 8.9475 | 8.9464 | 8.9471 | 19600.0 |
| 2010-07-15 07:48:00 | AAPL | Stock | 8.95 | 8.95 | 8.9471 | 8.9471 | 36400.0 |
| 2010-07-15 07:49:00 | AAPL | Stock | 8.9486 | 8.9486 | 8.9464 | 8.9464 | 58800.0 |
| 2010-07-15 07:52:00 | AAPL | Stock | 8.9468 | 8.9468 | 8.9468 | 8.9468 | 5600.0 |
| 2010-07-15 07:53:00 | AAPL | Stock | 8.9471 | 8.9471 | 8.9468 | 8.9468 | 30800.0 |
| 2010-07-15 07:54:00 | AAPL | Stock | 8.9468 | 8.95 | 8.9468 | 8.95 | 29400.0 |
| 2010-07-15 07:55:00 | AAPL | Stock | 8.9468 | 8.9561 | 8.9468 | 8.9561 | 67200.0 |
| 2010-07-15 07:56:00 | AAPL | Stock | 8.9561 | 8.9561 | 8.9464 | 8.9464 | 30800.0 |
| 2010-07-15 07:57:00 | AAPL | Stock | 8.9568 | 8.9611 | 8.9568 | 8.9611 | 26320.0 |
| 2010-07-15 07:58:00 | AAPL | Stock | 8.9611 | 8.9643 | 8.9611 | 8.9643 | 79800.0 |
| 2010-07-15 07:59:00 | AAPL | Stock | 8.9696 | 8.9696 | 8.9575 | 8.9643 | 133840.0 |
| 2010-07-15 08:00:00 | AAPL | Stock | 8.9679 | 8.9775 | 8.9571 | 8.9775 | 156156.0 |
| 2010-07-15 08:01:00 | AAPL | Stock | 8.9679 | 8.9821 | 8.9679 | 8.975 | 130200.0 |
| 2010-07-15 08:02:00 | AAPL | Stock | 8.975 | 8.9821 | 8.975 | 8.9821 | 121940.0 |
| 2010-07-15 08:03:00 | AAPL | Stock | 8.9818 | 8.9882 | 8.9786 | 8.9882 | 39760.0 |
| 2010-07-15 08:04:00 | AAPL | Stock | 8.9825 | 8.9839 | 8.9818 | 8.9821 | 47040.0 |
| 2010-07-15 08:05:00 | AAPL | Stock | 8.9829 | 8.9871 | 8.9825 | 8.9871 | 13160.0 |
| 2010-07-15 08:06:00 | AAPL | Stock | 8.9893 | 8.9911 | 8.9861 | 8.9907 | 16800.0 |
> showing 50 of 920,255 rows — these rows as CSV