PREVIEW / stock_1min / 2012-12-17
file: by_date/stock_1min/2012/2012-12-17.parquet size: 13.1 MB rows: 970,465 symbols: 2,850
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-12-17 04:00:00 | AAPL | Stock | 18.3929 | 18.3929 | 18.0357 | 18.0357 | 58800.0 |
| 2012-12-17 04:02:00 | AAPL | Stock | 18.0761 | 18.0761 | 18.0393 | 18.0393 | 19600.0 |
| 2012-12-17 04:03:00 | AAPL | Stock | 18.0607 | 18.0607 | 18.0607 | 18.0607 | 5600.0 |
| 2012-12-17 04:04:00 | AAPL | Stock | 18.0782 | 18.0793 | 18.0782 | 18.0793 | 9100.0 |
| 2012-12-17 04:05:00 | AAPL | Stock | 18.0393 | 18.0393 | 18.0386 | 18.0386 | 8400.0 |
| 2012-12-17 04:11:00 | AAPL | Stock | 18.0179 | 18.0318 | 18.0179 | 18.0318 | 8400.0 |
| 2012-12-17 04:12:00 | AAPL | Stock | 18.0321 | 18.0321 | 18.0321 | 18.0321 | 2800.0 |
| 2012-12-17 04:16:00 | AAPL | Stock | 18.0532 | 18.0536 | 18.0532 | 18.0536 | 5600.0 |
| 2012-12-17 04:17:00 | AAPL | Stock | 18.0536 | 18.0611 | 18.0536 | 18.0611 | 12600.0 |
| 2012-12-17 04:19:00 | AAPL | Stock | 18.0536 | 18.0536 | 18.0375 | 18.0375 | 21000.0 |
| 2012-12-17 04:20:00 | AAPL | Stock | 18.0375 | 18.0375 | 18.0375 | 18.0375 | 2800.0 |
| 2012-12-17 04:21:00 | AAPL | Stock | 18.0536 | 18.0536 | 18.0536 | 18.0536 | 4900.0 |
| 2012-12-17 04:25:00 | AAPL | Stock | 18.0375 | 18.0375 | 18.0375 | 18.0375 | 10920.0 |
| 2012-12-17 04:31:00 | AAPL | Stock | 18.0179 | 18.0179 | 18.0179 | 18.0179 | 2800.0 |
| 2012-12-17 04:32:00 | AAPL | Stock | 18.0179 | 18.0179 | 18.0179 | 18.0179 | 5600.0 |
| 2012-12-17 04:33:00 | AAPL | Stock | 18.0071 | 18.0071 | 18.0071 | 18.0071 | 44800.0 |
| 2012-12-17 04:34:00 | AAPL | Stock | 18.0429 | 18.0429 | 18.0429 | 18.0429 | 2800.0 |
| 2012-12-17 04:36:00 | AAPL | Stock | 18.0 | 18.0 | 18.0 | 18.0 | 2800.0 |
| 2012-12-17 04:37:00 | AAPL | Stock | 17.9946 | 17.9946 | 17.9946 | 17.9946 | 2800.0 |
| 2012-12-17 04:39:00 | AAPL | Stock | 17.9946 | 17.9946 | 17.9946 | 17.9946 | 2800.0 |
| 2012-12-17 04:40:00 | AAPL | Stock | 17.965 | 17.965 | 17.965 | 17.965 | 2800.0 |
| 2012-12-17 04:42:00 | AAPL | Stock | 17.9468 | 17.9468 | 17.9464 | 17.9464 | 13832.0 |
| 2012-12-17 04:44:00 | AAPL | Stock | 17.9464 | 17.9464 | 17.9379 | 17.9379 | 8400.0 |
| 2012-12-17 04:49:00 | AAPL | Stock | 17.9179 | 17.9179 | 17.9179 | 17.9179 | 2800.0 |
| 2012-12-17 04:52:00 | AAPL | Stock | 17.9175 | 17.9175 | 17.9029 | 17.9036 | 14000.0 |
| 2012-12-17 04:53:00 | AAPL | Stock | 17.9196 | 17.9196 | 17.9196 | 17.9196 | 2800.0 |
| 2012-12-17 04:54:00 | AAPL | Stock | 17.9036 | 17.9175 | 17.9036 | 17.9089 | 8400.0 |
| 2012-12-17 04:55:00 | AAPL | Stock | 17.9036 | 17.9036 | 17.9036 | 17.9036 | 2800.0 |
| 2012-12-17 04:56:00 | AAPL | Stock | 17.9036 | 17.9036 | 17.9036 | 17.9036 | 17360.0 |
| 2012-12-17 04:57:00 | AAPL | Stock | 17.9036 | 17.9036 | 17.9036 | 17.9036 | 7196.0 |
| 2012-12-17 04:58:00 | AAPL | Stock | 17.9 | 17.9 | 17.9 | 17.9 | 5600.0 |
| 2012-12-17 05:00:00 | AAPL | Stock | 17.885 | 17.885 | 17.8611 | 17.8611 | 9996.0 |
| 2012-12-17 05:02:00 | AAPL | Stock | 17.825 | 17.8307 | 17.825 | 17.8307 | 16464.0 |
| 2012-12-17 05:03:00 | AAPL | Stock | 17.8404 | 17.85 | 17.8304 | 17.8304 | 36680.0 |
| 2012-12-17 05:04:00 | AAPL | Stock | 17.85 | 17.85 | 17.85 | 17.85 | 2800.0 |
| 2012-12-17 05:05:00 | AAPL | Stock | 17.8304 | 17.8304 | 17.8304 | 17.8304 | 5600.0 |
| 2012-12-17 05:06:00 | AAPL | Stock | 17.8304 | 17.8304 | 17.8304 | 17.8304 | 15540.0 |
| 2012-12-17 05:08:00 | AAPL | Stock | 17.8304 | 17.8304 | 17.8304 | 17.8304 | 8680.0 |
| 2012-12-17 05:09:00 | AAPL | Stock | 17.8304 | 17.8304 | 17.8304 | 17.8304 | 28140.0 |
| 2012-12-17 05:10:00 | AAPL | Stock | 17.8193 | 17.8196 | 17.8107 | 17.8107 | 8400.0 |
| 2012-12-17 05:12:00 | AAPL | Stock | 17.7875 | 17.7875 | 17.7875 | 17.7875 | 2800.0 |
| 2012-12-17 05:13:00 | AAPL | Stock | 17.7893 | 17.7893 | 17.7893 | 17.7893 | 2800.0 |
| 2012-12-17 05:14:00 | AAPL | Stock | 17.7893 | 17.7893 | 17.7893 | 17.7893 | 5600.0 |
| 2012-12-17 05:15:00 | AAPL | Stock | 17.8068 | 17.8068 | 17.8068 | 17.8068 | 2800.0 |
| 2012-12-17 05:16:00 | AAPL | Stock | 17.8054 | 17.8057 | 17.8054 | 17.8057 | 5600.0 |
| 2012-12-17 05:17:00 | AAPL | Stock | 17.7929 | 17.7929 | 17.7929 | 17.7929 | 2800.0 |
| 2012-12-17 05:18:00 | AAPL | Stock | 17.8071 | 17.8104 | 17.8071 | 17.8104 | 14000.0 |
| 2012-12-17 05:20:00 | AAPL | Stock | 17.8214 | 17.8214 | 17.8214 | 17.8214 | 7280.0 |
| 2012-12-17 05:21:00 | AAPL | Stock | 17.8214 | 17.8214 | 17.8214 | 17.8214 | 2800.0 |
| 2012-12-17 05:22:00 | AAPL | Stock | 17.8393 | 17.8393 | 17.8393 | 17.8393 | 2800.0 |
> showing 50 of 970,465 rows — these rows as CSV