PREVIEW / stock_1min / 2010-08-18
file: by_date/stock_1min/2010/2010-08-18.parquet size: 12.0 MB rows: 915,118 symbols: 2,822
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 |
|---|---|---|---|---|---|---|---|
| 2010-08-18 04:05:00 | AAPL | Stock | 8.9964 | 8.9964 | 8.9964 | 8.9964 | 11900.0 |
| 2010-08-18 04:39:00 | AAPL | Stock | 9.0214 | 9.0214 | 9.0214 | 9.0214 | 2800.0 |
| 2010-08-18 05:15:00 | AAPL | Stock | 9.0214 | 9.0214 | 9.0214 | 9.0214 | 11200.0 |
| 2010-08-18 05:45:00 | AAPL | Stock | 9.0286 | 9.0286 | 9.0286 | 9.0286 | 2800.0 |
| 2010-08-18 05:47:00 | AAPL | Stock | 9.0286 | 9.0286 | 9.0286 | 9.0286 | 2800.0 |
| 2010-08-18 05:58:00 | AAPL | Stock | 9.0286 | 9.0286 | 9.0286 | 9.0286 | 3724.0 |
| 2010-08-18 06:17:00 | AAPL | Stock | 9.0286 | 9.0286 | 9.0286 | 9.0286 | 2800.0 |
| 2010-08-18 06:52:00 | AAPL | Stock | 9.025 | 9.025 | 9.0246 | 9.0246 | 5600.0 |
| 2010-08-18 07:07:00 | AAPL | Stock | 9.0071 | 9.0071 | 9.0071 | 9.0071 | 5600.0 |
| 2010-08-18 07:38:00 | AAPL | Stock | 9.0175 | 9.0175 | 9.0175 | 9.0175 | 5600.0 |
| 2010-08-18 07:40:00 | AAPL | Stock | 9.0161 | 9.0161 | 9.0161 | 9.0161 | 2800.0 |
| 2010-08-18 07:41:00 | AAPL | Stock | 9.0211 | 9.0211 | 9.0179 | 9.0179 | 11200.0 |
| 2010-08-18 07:43:00 | AAPL | Stock | 9.0214 | 9.0214 | 9.0214 | 9.0214 | 14000.0 |
| 2010-08-18 07:46:00 | AAPL | Stock | 9.0286 | 9.0286 | 9.0286 | 9.0286 | 13160.0 |
| 2010-08-18 07:49:00 | AAPL | Stock | 9.0286 | 9.0304 | 9.0286 | 9.0304 | 13160.0 |
| 2010-08-18 07:56:00 | AAPL | Stock | 9.0304 | 9.0346 | 9.0304 | 9.0307 | 28000.0 |
| 2010-08-18 08:00:00 | AAPL | Stock | 9.0286 | 9.0286 | 9.0214 | 9.0286 | 17080.0 |
| 2010-08-18 08:01:00 | AAPL | Stock | 9.0132 | 9.0132 | 9.0071 | 9.0096 | 33600.0 |
| 2010-08-18 08:02:00 | AAPL | Stock | 9.0096 | 9.0104 | 9.0068 | 9.0093 | 48440.0 |
| 2010-08-18 08:03:00 | AAPL | Stock | 9.0039 | 9.0039 | 8.9996 | 8.9996 | 81060.0 |
| 2010-08-18 08:04:00 | AAPL | Stock | 8.9964 | 8.9982 | 8.9964 | 8.9982 | 5600.0 |
| 2010-08-18 08:05:00 | AAPL | Stock | 8.9993 | 9.0 | 8.9993 | 9.0 | 11760.0 |
| 2010-08-18 08:06:00 | AAPL | Stock | 9.0036 | 9.0036 | 9.0036 | 9.0036 | 2800.0 |
| 2010-08-18 08:07:00 | AAPL | Stock | 9.0036 | 9.0046 | 9.0 | 9.0 | 37520.0 |
| 2010-08-18 08:09:00 | AAPL | Stock | 9.0054 | 9.0054 | 9.0036 | 9.0036 | 14000.0 |
| 2010-08-18 08:10:00 | AAPL | Stock | 9.0018 | 9.0061 | 9.0 | 9.0 | 75600.0 |
| 2010-08-18 08:12:00 | AAPL | Stock | 9.0018 | 9.0018 | 9.0018 | 9.0018 | 24780.0 |
| 2010-08-18 08:13:00 | AAPL | Stock | 9.0036 | 9.0036 | 9.0032 | 9.0036 | 19600.0 |
| 2010-08-18 08:14:00 | AAPL | Stock | 9.0036 | 9.0036 | 8.9968 | 8.9968 | 12376.0 |
| 2010-08-18 08:16:00 | AAPL | Stock | 9.0043 | 9.0082 | 9.0043 | 9.0082 | 25200.0 |
| 2010-08-18 08:17:00 | AAPL | Stock | 9.0096 | 9.0096 | 9.0096 | 9.0096 | 21560.0 |
| 2010-08-18 08:18:00 | AAPL | Stock | 9.0129 | 9.0129 | 9.0107 | 9.0107 | 25200.0 |
| 2010-08-18 08:19:00 | AAPL | Stock | 9.0168 | 9.0168 | 9.0168 | 9.0168 | 25200.0 |
| 2010-08-18 08:20:00 | AAPL | Stock | 9.0182 | 9.0193 | 9.0182 | 9.0193 | 5600.0 |
| 2010-08-18 08:21:00 | AAPL | Stock | 9.02 | 9.0232 | 9.02 | 9.0232 | 61600.0 |
| 2010-08-18 08:22:00 | AAPL | Stock | 9.0214 | 9.0232 | 9.0214 | 9.0232 | 44800.0 |
| 2010-08-18 08:23:00 | AAPL | Stock | 9.0214 | 9.0232 | 9.0214 | 9.0232 | 36400.0 |
| 2010-08-18 08:24:00 | AAPL | Stock | 9.0246 | 9.0246 | 9.0246 | 9.0246 | 12040.0 |
| 2010-08-18 08:25:00 | AAPL | Stock | 9.0239 | 9.0239 | 9.0214 | 9.0214 | 21000.0 |
| 2010-08-18 08:26:00 | AAPL | Stock | 9.0221 | 9.025 | 9.0221 | 9.025 | 43400.0 |
| 2010-08-18 08:27:00 | AAPL | Stock | 9.025 | 9.0261 | 9.0214 | 9.0261 | 67060.0 |
| 2010-08-18 08:30:00 | AAPL | Stock | 9.0264 | 9.0264 | 9.025 | 9.025 | 8400.0 |
| 2010-08-18 08:31:00 | AAPL | Stock | 9.0254 | 9.0254 | 9.0214 | 9.0214 | 94444.0 |
| 2010-08-18 08:32:00 | AAPL | Stock | 9.0218 | 9.0218 | 9.0214 | 9.0214 | 23240.0 |
| 2010-08-18 08:33:00 | AAPL | Stock | 9.0207 | 9.0207 | 9.0207 | 9.0207 | 2800.0 |
| 2010-08-18 08:34:00 | AAPL | Stock | 9.0214 | 9.0214 | 9.0214 | 9.0214 | 2800.0 |
| 2010-08-18 08:35:00 | AAPL | Stock | 9.02 | 9.0214 | 9.02 | 9.0214 | 5600.0 |
| 2010-08-18 08:36:00 | AAPL | Stock | 9.0236 | 9.0243 | 9.0236 | 9.0243 | 8400.0 |
| 2010-08-18 08:39:00 | AAPL | Stock | 9.0214 | 9.0232 | 9.0214 | 9.0232 | 11200.0 |
| 2010-08-18 08:40:00 | AAPL | Stock | 9.0232 | 9.0232 | 9.0204 | 9.0214 | 8400.0 |
> showing 50 of 915,118 rows — these rows as CSV