PREVIEW / stock_1min / 2012-10-15
file: by_date/stock_1min/2012/2012-10-15.parquet size: 11.9 MB rows: 875,466 symbols: 2,818
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-10-15 04:00:00 | AAPL | Stock | 22.5357 | 22.6071 | 22.5357 | 22.6071 | 44800.0 |
| 2012-10-15 04:29:00 | AAPL | Stock | 22.6071 | 22.6071 | 22.6071 | 22.6071 | 5600.0 |
| 2012-10-15 04:30:00 | AAPL | Stock | 22.5968 | 22.5968 | 22.5968 | 22.5968 | 2800.0 |
| 2012-10-15 04:56:00 | AAPL | Stock | 22.6071 | 22.6071 | 22.6071 | 22.6071 | 8400.0 |
| 2012-10-15 04:58:00 | AAPL | Stock | 22.6071 | 22.6071 | 22.6071 | 22.6071 | 5600.0 |
| 2012-10-15 05:00:00 | AAPL | Stock | 22.6071 | 22.6071 | 22.6071 | 22.6071 | 6888.0 |
| 2012-10-15 05:06:00 | AAPL | Stock | 22.6214 | 22.6214 | 22.6214 | 22.6214 | 2800.0 |
| 2012-10-15 05:36:00 | AAPL | Stock | 22.6393 | 22.6393 | 22.6393 | 22.6393 | 2800.0 |
| 2012-10-15 06:05:00 | AAPL | Stock | 22.6268 | 22.6268 | 22.6268 | 22.6268 | 3780.0 |
| 2012-10-15 06:07:00 | AAPL | Stock | 22.6346 | 22.6346 | 22.6346 | 22.6346 | 9800.0 |
| 2012-10-15 06:44:00 | AAPL | Stock | 22.6346 | 22.6346 | 22.6346 | 22.6346 | 4200.0 |
| 2012-10-15 06:46:00 | AAPL | Stock | 22.6346 | 22.6346 | 22.6346 | 22.6346 | 2800.0 |
| 2012-10-15 07:01:00 | AAPL | Stock | 22.625 | 22.625 | 22.6214 | 22.6214 | 5600.0 |
| 2012-10-15 07:03:00 | AAPL | Stock | 22.6214 | 22.6218 | 22.6214 | 22.6214 | 29512.0 |
| 2012-10-15 07:04:00 | AAPL | Stock | 22.6093 | 22.6093 | 22.6093 | 22.6093 | 4312.0 |
| 2012-10-15 07:05:00 | AAPL | Stock | 22.6214 | 22.6271 | 22.6004 | 22.6096 | 12600.0 |
| 2012-10-15 07:06:00 | AAPL | Stock | 22.6171 | 22.6171 | 22.6071 | 22.6071 | 36400.0 |
| 2012-10-15 07:07:00 | AAPL | Stock | 22.6214 | 22.6214 | 22.6211 | 22.6211 | 5600.0 |
| 2012-10-15 07:08:00 | AAPL | Stock | 22.6093 | 22.6214 | 22.6093 | 22.6214 | 5600.0 |
| 2012-10-15 07:09:00 | AAPL | Stock | 22.6211 | 22.6232 | 22.6211 | 22.6232 | 5600.0 |
| 2012-10-15 07:10:00 | AAPL | Stock | 22.6157 | 22.6157 | 22.6157 | 22.6157 | 5600.0 |
| 2012-10-15 07:11:00 | AAPL | Stock | 22.6196 | 22.6196 | 22.6179 | 22.6179 | 17500.0 |
| 2012-10-15 07:12:00 | AAPL | Stock | 22.63 | 22.63 | 22.63 | 22.63 | 10192.0 |
| 2012-10-15 07:25:00 | AAPL | Stock | 22.625 | 22.625 | 22.625 | 22.625 | 11200.0 |
| 2012-10-15 07:28:00 | AAPL | Stock | 22.6311 | 22.6425 | 22.6311 | 22.6425 | 37800.0 |
| 2012-10-15 07:29:00 | AAPL | Stock | 22.6429 | 22.6429 | 22.6429 | 22.6429 | 2800.0 |
| 2012-10-15 07:30:00 | AAPL | Stock | 22.6436 | 22.6436 | 22.6357 | 22.6357 | 19600.0 |
| 2012-10-15 07:35:00 | AAPL | Stock | 22.6311 | 22.6418 | 22.6311 | 22.6418 | 5600.0 |
| 2012-10-15 07:38:00 | AAPL | Stock | 22.6321 | 22.6321 | 22.6268 | 22.6268 | 50400.0 |
| 2012-10-15 07:39:00 | AAPL | Stock | 22.62 | 22.62 | 22.6089 | 22.6089 | 39172.0 |
| 2012-10-15 07:40:00 | AAPL | Stock | 22.6143 | 22.6143 | 22.6143 | 22.6143 | 2800.0 |
| 2012-10-15 07:41:00 | AAPL | Stock | 22.6143 | 22.6218 | 22.6143 | 22.6189 | 16800.0 |
| 2012-10-15 07:42:00 | AAPL | Stock | 22.6196 | 22.6196 | 22.6196 | 22.6196 | 5600.0 |
| 2012-10-15 07:44:00 | AAPL | Stock | 22.6261 | 22.6261 | 22.6261 | 22.6261 | 2800.0 |
| 2012-10-15 07:45:00 | AAPL | Stock | 22.6232 | 22.6268 | 22.6232 | 22.625 | 39340.0 |
| 2012-10-15 07:47:00 | AAPL | Stock | 22.615 | 22.615 | 22.615 | 22.615 | 5600.0 |
| 2012-10-15 07:51:00 | AAPL | Stock | 22.6232 | 22.6232 | 22.6232 | 22.6232 | 2800.0 |
| 2012-10-15 07:52:00 | AAPL | Stock | 22.6243 | 22.625 | 22.6243 | 22.625 | 19600.0 |
| 2012-10-15 07:58:00 | AAPL | Stock | 22.6243 | 22.6243 | 22.6196 | 22.6196 | 11900.0 |
| 2012-10-15 07:59:00 | AAPL | Stock | 22.6196 | 22.6196 | 22.6146 | 22.6146 | 22120.0 |
| 2012-10-15 08:00:00 | AAPL | Stock | 22.6129 | 22.6289 | 22.5939 | 22.6071 | 58016.0 |
| 2012-10-15 08:01:00 | AAPL | Stock | 22.6068 | 22.6136 | 22.6043 | 22.6043 | 41692.0 |
| 2012-10-15 08:02:00 | AAPL | Stock | 22.6064 | 22.6064 | 22.5893 | 22.5893 | 33600.0 |
| 2012-10-15 08:03:00 | AAPL | Stock | 22.59 | 22.6018 | 22.59 | 22.6018 | 25200.0 |
| 2012-10-15 08:04:00 | AAPL | Stock | 22.5932 | 22.6021 | 22.5932 | 22.6021 | 22260.0 |
| 2012-10-15 08:05:00 | AAPL | Stock | 22.6036 | 22.61 | 22.5911 | 22.5929 | 162932.0 |
| 2012-10-15 08:06:00 | AAPL | Stock | 22.5911 | 22.6325 | 22.5896 | 22.6004 | 141428.0 |
| 2012-10-15 08:08:00 | AAPL | Stock | 22.6046 | 22.6071 | 22.6014 | 22.6071 | 44016.0 |
| 2012-10-15 08:09:00 | AAPL | Stock | 22.6107 | 22.6107 | 22.6004 | 22.6004 | 11760.0 |
| 2012-10-15 08:10:00 | AAPL | Stock | 22.6 | 22.6 | 22.5989 | 22.5989 | 9240.0 |
> showing 50 of 875,466 rows — these rows as CSV