PREVIEW / stock_1min / 2011-03-30
file: by_date/stock_1min/2011/2011-03-30.parquet size: 13.2 MB rows: 979,266 symbols: 2,856
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-03-30 04:06:00 | AAPL | Stock | 12.6518 | 12.6518 | 12.6518 | 12.6518 | 2800.0 |
| 2011-03-30 04:08:00 | AAPL | Stock | 12.655 | 12.655 | 12.655 | 12.655 | 5600.0 |
| 2011-03-30 04:11:00 | AAPL | Stock | 12.655 | 12.655 | 12.655 | 12.655 | 2800.0 |
| 2011-03-30 04:16:00 | AAPL | Stock | 12.6468 | 12.6468 | 12.6468 | 12.6468 | 5600.0 |
| 2011-03-30 04:30:00 | AAPL | Stock | 12.6429 | 12.6429 | 12.64 | 12.64 | 5600.0 |
| 2011-03-30 04:31:00 | AAPL | Stock | 12.6429 | 12.6429 | 12.6429 | 12.6429 | 8400.0 |
| 2011-03-30 04:32:00 | AAPL | Stock | 12.6429 | 12.6429 | 12.6429 | 12.6429 | 5600.0 |
| 2011-03-30 04:45:00 | AAPL | Stock | 12.6304 | 12.6304 | 12.6304 | 12.6304 | 2800.0 |
| 2011-03-30 04:49:00 | AAPL | Stock | 12.6389 | 12.6389 | 12.6389 | 12.6389 | 2800.0 |
| 2011-03-30 04:59:00 | AAPL | Stock | 12.6214 | 12.6214 | 12.6214 | 12.6214 | 2800.0 |
| 2011-03-30 05:13:00 | AAPL | Stock | 12.625 | 12.625 | 12.625 | 12.625 | 2800.0 |
| 2011-03-30 05:30:00 | AAPL | Stock | 12.6107 | 12.6107 | 12.6107 | 12.6107 | 2800.0 |
| 2011-03-30 05:38:00 | AAPL | Stock | 12.6143 | 12.6143 | 12.6143 | 12.6143 | 2800.0 |
| 2011-03-30 05:47:00 | AAPL | Stock | 12.6096 | 12.6096 | 12.6096 | 12.6096 | 2800.0 |
| 2011-03-30 06:21:00 | AAPL | Stock | 12.6096 | 12.6096 | 12.6096 | 12.6096 | 2800.0 |
| 2011-03-30 06:37:00 | AAPL | Stock | 12.6196 | 12.6221 | 12.6196 | 12.6221 | 11200.0 |
| 2011-03-30 06:38:00 | AAPL | Stock | 12.6196 | 12.6196 | 12.6196 | 12.6196 | 2800.0 |
| 2011-03-30 06:40:00 | AAPL | Stock | 12.6125 | 12.6125 | 12.6125 | 12.6125 | 2800.0 |
| 2011-03-30 06:41:00 | AAPL | Stock | 12.6107 | 12.6107 | 12.6107 | 12.6107 | 35336.0 |
| 2011-03-30 06:51:00 | AAPL | Stock | 12.6089 | 12.6089 | 12.6089 | 12.6089 | 2800.0 |
| 2011-03-30 07:02:00 | AAPL | Stock | 12.6204 | 12.6204 | 12.6204 | 12.6204 | 5600.0 |
| 2011-03-30 07:03:00 | AAPL | Stock | 12.6 | 12.6 | 12.6 | 12.6 | 5600.0 |
| 2011-03-30 07:04:00 | AAPL | Stock | 12.6054 | 12.6054 | 12.6054 | 12.6054 | 2800.0 |
| 2011-03-30 07:05:00 | AAPL | Stock | 12.6071 | 12.6071 | 12.6071 | 12.6071 | 2800.0 |
| 2011-03-30 07:06:00 | AAPL | Stock | 12.6054 | 12.6054 | 12.6036 | 12.6036 | 61600.0 |
| 2011-03-30 07:07:00 | AAPL | Stock | 12.6021 | 12.6021 | 12.6021 | 12.6021 | 2800.0 |
| 2011-03-30 07:08:00 | AAPL | Stock | 12.5982 | 12.5982 | 12.5982 | 12.5982 | 8400.0 |
| 2011-03-30 07:09:00 | AAPL | Stock | 12.595 | 12.595 | 12.5946 | 12.5946 | 5600.0 |
| 2011-03-30 07:10:00 | AAPL | Stock | 12.5946 | 12.5946 | 12.5929 | 12.5946 | 44800.0 |
| 2011-03-30 07:11:00 | AAPL | Stock | 12.6 | 12.6004 | 12.6 | 12.6004 | 5600.0 |
| 2011-03-30 07:12:00 | AAPL | Stock | 12.6018 | 12.6071 | 12.6018 | 12.6071 | 62552.0 |
| 2011-03-30 07:13:00 | AAPL | Stock | 12.6029 | 12.6029 | 12.6029 | 12.6029 | 2800.0 |
| 2011-03-30 07:15:00 | AAPL | Stock | 12.6029 | 12.6054 | 12.6029 | 12.6054 | 86800.0 |
| 2011-03-30 07:16:00 | AAPL | Stock | 12.6004 | 12.6004 | 12.6004 | 12.6004 | 5600.0 |
| 2011-03-30 07:17:00 | AAPL | Stock | 12.6054 | 12.6054 | 12.6054 | 12.6054 | 5600.0 |
| 2011-03-30 07:18:00 | AAPL | Stock | 12.6004 | 12.6004 | 12.6004 | 12.6004 | 7000.0 |
| 2011-03-30 07:19:00 | AAPL | Stock | 12.6004 | 12.6004 | 12.6004 | 12.6004 | 5600.0 |
| 2011-03-30 07:20:00 | AAPL | Stock | 12.5971 | 12.6036 | 12.5971 | 12.6036 | 5600.0 |
| 2011-03-30 07:21:00 | AAPL | Stock | 12.5971 | 12.5971 | 12.5971 | 12.5971 | 2800.0 |
| 2011-03-30 07:23:00 | AAPL | Stock | 12.5971 | 12.5971 | 12.5968 | 12.5968 | 8400.0 |
| 2011-03-30 07:24:00 | AAPL | Stock | 12.5982 | 12.5982 | 12.5968 | 12.5968 | 15092.0 |
| 2011-03-30 07:25:00 | AAPL | Stock | 12.5968 | 12.5968 | 12.5968 | 12.5968 | 29400.0 |
| 2011-03-30 07:26:00 | AAPL | Stock | 12.6018 | 12.6061 | 12.6018 | 12.6061 | 48720.0 |
| 2011-03-30 07:27:00 | AAPL | Stock | 12.6029 | 12.6029 | 12.5971 | 12.5975 | 11200.0 |
| 2011-03-30 07:29:00 | AAPL | Stock | 12.5996 | 12.6 | 12.5996 | 12.6 | 12516.0 |
| 2011-03-30 07:30:00 | AAPL | Stock | 12.6 | 12.6 | 12.5968 | 12.5968 | 49252.0 |
| 2011-03-30 07:31:00 | AAPL | Stock | 12.5996 | 12.6036 | 12.5971 | 12.5971 | 34384.0 |
| 2011-03-30 07:32:00 | AAPL | Stock | 12.6032 | 12.6032 | 12.6032 | 12.6032 | 5600.0 |
| 2011-03-30 07:35:00 | AAPL | Stock | 12.6036 | 12.6036 | 12.6036 | 12.6036 | 14000.0 |
| 2011-03-30 07:36:00 | AAPL | Stock | 12.5975 | 12.5975 | 12.5975 | 12.5975 | 14000.0 |
> showing 50 of 979,266 rows — these rows as CSV