PREVIEW / stock_1min / 2012-01-30
file: by_date/stock_1min/2012/2012-01-30.parquet size: 12.6 MB rows: 937,570 symbols: 2,854
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-01-30 04:01:00 | AAPL | Stock | 15.9218 | 15.9218 | 15.9204 | 15.9204 | 11200.0 |
| 2012-01-30 04:29:00 | AAPL | Stock | 15.925 | 15.925 | 15.925 | 15.925 | 2800.0 |
| 2012-01-30 04:33:00 | AAPL | Stock | 15.9068 | 15.9068 | 15.9032 | 15.9032 | 5600.0 |
| 2012-01-30 04:35:00 | AAPL | Stock | 15.9021 | 15.9021 | 15.9021 | 15.9021 | 2800.0 |
| 2012-01-30 04:36:00 | AAPL | Stock | 15.9021 | 15.9021 | 15.9021 | 15.9021 | 5600.0 |
| 2012-01-30 04:38:00 | AAPL | Stock | 15.8979 | 15.8979 | 15.8979 | 15.8979 | 4200.0 |
| 2012-01-30 04:41:00 | AAPL | Stock | 15.8932 | 15.8932 | 15.8932 | 15.8932 | 2940.0 |
| 2012-01-30 04:42:00 | AAPL | Stock | 15.8929 | 15.8929 | 15.8929 | 15.8929 | 28000.0 |
| 2012-01-30 04:51:00 | AAPL | Stock | 15.8893 | 15.8893 | 15.8893 | 15.8893 | 14000.0 |
| 2012-01-30 04:53:00 | AAPL | Stock | 15.8854 | 15.8854 | 15.8854 | 15.8854 | 2800.0 |
| 2012-01-30 05:00:00 | AAPL | Stock | 15.8964 | 15.9075 | 15.8964 | 15.9075 | 11200.0 |
| 2012-01-30 05:01:00 | AAPL | Stock | 15.8946 | 15.8946 | 15.8946 | 15.8946 | 5600.0 |
| 2012-01-30 05:07:00 | AAPL | Stock | 15.8929 | 15.8929 | 15.8929 | 15.8929 | 5600.0 |
| 2012-01-30 05:21:00 | AAPL | Stock | 15.8964 | 15.8964 | 15.8964 | 15.8964 | 5600.0 |
| 2012-01-30 05:32:00 | AAPL | Stock | 15.9075 | 15.9075 | 15.9075 | 15.9075 | 8400.0 |
| 2012-01-30 06:35:00 | AAPL | Stock | 15.9211 | 15.9211 | 15.9211 | 15.9211 | 14000.0 |
| 2012-01-30 06:36:00 | AAPL | Stock | 15.9211 | 15.9214 | 15.9211 | 15.9214 | 16800.0 |
| 2012-01-30 06:56:00 | AAPL | Stock | 15.9107 | 15.9107 | 15.9086 | 15.9086 | 28000.0 |
| 2012-01-30 07:00:00 | AAPL | Stock | 15.9214 | 15.9214 | 15.9214 | 15.9214 | 2800.0 |
| 2012-01-30 07:01:00 | AAPL | Stock | 15.9214 | 15.9286 | 15.9143 | 15.9143 | 29904.0 |
| 2012-01-30 07:02:00 | AAPL | Stock | 15.9143 | 15.9143 | 15.9107 | 15.9107 | 16800.0 |
| 2012-01-30 07:04:00 | AAPL | Stock | 15.9179 | 15.9179 | 15.9179 | 15.9179 | 5320.0 |
| 2012-01-30 07:07:00 | AAPL | Stock | 15.9196 | 15.9196 | 15.9196 | 15.9196 | 11200.0 |
| 2012-01-30 07:09:00 | AAPL | Stock | 15.9454 | 15.9454 | 15.9454 | 15.9454 | 2800.0 |
| 2012-01-30 07:11:00 | AAPL | Stock | 15.9457 | 15.9457 | 15.9446 | 15.9446 | 25480.0 |
| 2012-01-30 07:12:00 | AAPL | Stock | 15.9507 | 15.9507 | 15.9507 | 15.9507 | 5600.0 |
| 2012-01-30 07:13:00 | AAPL | Stock | 15.9296 | 15.9296 | 15.9296 | 15.9296 | 22400.0 |
| 2012-01-30 07:14:00 | AAPL | Stock | 15.9375 | 15.9375 | 15.9375 | 15.9375 | 2800.0 |
| 2012-01-30 07:15:00 | AAPL | Stock | 15.9296 | 15.9296 | 15.9286 | 15.9286 | 28000.0 |
| 2012-01-30 07:16:00 | AAPL | Stock | 15.9286 | 15.9286 | 15.9286 | 15.9286 | 3920.0 |
| 2012-01-30 07:17:00 | AAPL | Stock | 15.9286 | 15.9286 | 15.9286 | 15.9286 | 14000.0 |
| 2012-01-30 07:18:00 | AAPL | Stock | 15.9264 | 15.9264 | 15.9239 | 15.9239 | 16800.0 |
| 2012-01-30 07:19:00 | AAPL | Stock | 15.9114 | 15.9114 | 15.9114 | 15.9114 | 5600.0 |
| 2012-01-30 07:21:00 | AAPL | Stock | 15.9239 | 15.9239 | 15.9239 | 15.9239 | 4200.0 |
| 2012-01-30 07:22:00 | AAPL | Stock | 15.9196 | 15.9239 | 15.9196 | 15.9239 | 31920.0 |
| 2012-01-30 07:24:00 | AAPL | Stock | 15.9239 | 15.9239 | 15.9239 | 15.9239 | 2800.0 |
| 2012-01-30 07:26:00 | AAPL | Stock | 15.925 | 15.925 | 15.925 | 15.925 | 2800.0 |
| 2012-01-30 07:27:00 | AAPL | Stock | 15.9179 | 15.9179 | 15.9179 | 15.9179 | 2800.0 |
| 2012-01-30 07:29:00 | AAPL | Stock | 15.9196 | 15.9196 | 15.9196 | 15.9196 | 14000.0 |
| 2012-01-30 07:31:00 | AAPL | Stock | 15.9214 | 15.9214 | 15.9214 | 15.9214 | 5320.0 |
| 2012-01-30 07:33:00 | AAPL | Stock | 15.9179 | 15.9179 | 15.9179 | 15.9179 | 28000.0 |
| 2012-01-30 07:40:00 | AAPL | Stock | 15.915 | 15.9161 | 15.915 | 15.915 | 30268.0 |
| 2012-01-30 07:43:00 | AAPL | Stock | 15.9114 | 15.9114 | 15.9075 | 15.9075 | 52640.0 |
| 2012-01-30 07:44:00 | AAPL | Stock | 15.9082 | 15.9082 | 15.9082 | 15.9082 | 10920.0 |
| 2012-01-30 07:45:00 | AAPL | Stock | 15.9029 | 15.9029 | 15.9029 | 15.9029 | 5600.0 |
| 2012-01-30 07:46:00 | AAPL | Stock | 15.9032 | 15.9032 | 15.9032 | 15.9032 | 3724.0 |
| 2012-01-30 07:52:00 | AAPL | Stock | 15.9139 | 15.9139 | 15.9139 | 15.9139 | 5124.0 |
| 2012-01-30 07:55:00 | AAPL | Stock | 15.915 | 15.915 | 15.915 | 15.915 | 2800.0 |
| 2012-01-30 07:56:00 | AAPL | Stock | 15.9157 | 15.9157 | 15.9157 | 15.9157 | 2800.0 |
| 2012-01-30 08:00:00 | AAPL | Stock | 15.9154 | 15.9218 | 15.9143 | 15.9143 | 50932.0 |
> showing 50 of 937,570 rows — these rows as CSV