PREVIEW / stock_1min / 2011-03-21
file: by_date/stock_1min/2011/2011-03-21.parquet size: 13.4 MB rows: 1,004,851 symbols: 2,858
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-21 04:00:00 | AAPL | Stock | 11.8929 | 11.8929 | 11.8929 | 11.8929 | 9800.0 |
| 2011-03-21 04:02:00 | AAPL | Stock | 11.9446 | 11.9446 | 11.9446 | 11.9446 | 5600.0 |
| 2011-03-21 04:03:00 | AAPL | Stock | 11.9432 | 11.9432 | 11.9432 | 11.9432 | 2800.0 |
| 2011-03-21 04:04:00 | AAPL | Stock | 11.9432 | 11.9432 | 11.9432 | 11.9432 | 5600.0 |
| 2011-03-21 04:06:00 | AAPL | Stock | 11.9718 | 11.9718 | 11.9718 | 11.9718 | 25200.0 |
| 2011-03-21 04:08:00 | AAPL | Stock | 11.9732 | 11.9732 | 11.9732 | 11.9732 | 2800.0 |
| 2011-03-21 04:11:00 | AAPL | Stock | 11.9714 | 11.9714 | 11.9714 | 11.9714 | 2800.0 |
| 2011-03-21 04:12:00 | AAPL | Stock | 11.9696 | 11.9696 | 11.9696 | 11.9696 | 2800.0 |
| 2011-03-21 04:13:00 | AAPL | Stock | 11.9714 | 11.9886 | 11.9714 | 11.9886 | 11200.0 |
| 2011-03-21 04:16:00 | AAPL | Stock | 11.9911 | 11.9911 | 11.9911 | 11.9911 | 5600.0 |
| 2011-03-21 04:23:00 | AAPL | Stock | 11.9879 | 11.9911 | 11.9879 | 11.9911 | 8400.0 |
| 2011-03-21 04:29:00 | AAPL | Stock | 11.9821 | 11.9821 | 11.9821 | 11.9821 | 5600.0 |
| 2011-03-21 04:35:00 | AAPL | Stock | 11.99 | 11.99 | 11.99 | 11.99 | 2800.0 |
| 2011-03-21 04:38:00 | AAPL | Stock | 11.99 | 11.99 | 11.99 | 11.99 | 2800.0 |
| 2011-03-21 04:41:00 | AAPL | Stock | 11.9911 | 11.9911 | 11.9911 | 11.9911 | 2800.0 |
| 2011-03-21 04:47:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 2800.0 |
| 2011-03-21 04:48:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 2800.0 |
| 2011-03-21 04:51:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 5600.0 |
| 2011-03-21 04:52:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 2800.0 |
| 2011-03-21 04:53:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 5600.0 |
| 2011-03-21 04:57:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 2800.0 |
| 2011-03-21 04:58:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 2800.0 |
| 2011-03-21 05:00:00 | AAPL | Stock | 11.9821 | 11.9821 | 11.9821 | 11.9821 | 2800.0 |
| 2011-03-21 05:02:00 | AAPL | Stock | 11.9811 | 11.9811 | 11.9811 | 11.9811 | 2800.0 |
| 2011-03-21 05:03:00 | AAPL | Stock | 11.9879 | 11.9879 | 11.9879 | 11.9879 | 2800.0 |
| 2011-03-21 05:04:00 | AAPL | Stock | 11.97 | 11.97 | 11.97 | 11.97 | 5600.0 |
| 2011-03-21 05:06:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 2800.0 |
| 2011-03-21 05:07:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 2800.0 |
| 2011-03-21 05:08:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 2800.0 |
| 2011-03-21 05:16:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 5600.0 |
| 2011-03-21 05:17:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 2800.0 |
| 2011-03-21 05:19:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 2800.0 |
| 2011-03-21 05:25:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 2800.0 |
| 2011-03-21 05:26:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 8400.0 |
| 2011-03-21 05:29:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 2800.0 |
| 2011-03-21 05:31:00 | AAPL | Stock | 11.9929 | 11.9929 | 11.9929 | 11.9929 | 2800.0 |
| 2011-03-21 05:36:00 | AAPL | Stock | 11.9821 | 11.9821 | 11.9821 | 11.9821 | 5600.0 |
| 2011-03-21 06:05:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 5600.0 |
| 2011-03-21 06:08:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 2800.0 |
| 2011-03-21 06:13:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 2800.0 |
| 2011-03-21 06:14:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 2800.0 |
| 2011-03-21 06:16:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 8400.0 |
| 2011-03-21 06:20:00 | AAPL | Stock | 11.9857 | 11.9857 | 11.9857 | 11.9857 | 2800.0 |
| 2011-03-21 06:21:00 | AAPL | Stock | 12.0 | 12.0 | 11.9857 | 11.9857 | 8400.0 |
| 2011-03-21 06:24:00 | AAPL | Stock | 11.9882 | 11.9882 | 11.9882 | 11.9882 | 2800.0 |
| 2011-03-21 06:29:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 5600.0 |
| 2011-03-21 06:35:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 2800.0 |
| 2011-03-21 06:46:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 2800.0 |
| 2011-03-21 06:48:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 5600.0 |
| 2011-03-21 06:49:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 5600.0 |
> showing 50 of 1,004,851 rows — these rows as CSV