PREVIEW / stock_1min / 2010-08-17
file: by_date/stock_1min/2010/2010-08-17.parquet size: 12.3 MB rows: 939,671 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 |
|---|---|---|---|---|---|---|---|
| 2010-08-17 05:11:00 | AAPL | Stock | 8.9261 | 8.9261 | 8.9261 | 8.9261 | 2884.0 |
| 2010-08-17 05:45:00 | AAPL | Stock | 8.9261 | 8.9261 | 8.9261 | 8.9261 | 2800.0 |
| 2010-08-17 07:10:00 | AAPL | Stock | 8.8964 | 8.8964 | 8.8964 | 8.8964 | 2968.0 |
| 2010-08-17 07:21:00 | AAPL | Stock | 8.8929 | 8.9111 | 8.8929 | 8.9111 | 5600.0 |
| 2010-08-17 07:45:00 | AAPL | Stock | 8.9025 | 8.9025 | 8.9025 | 8.9025 | 2800.0 |
| 2010-08-17 07:47:00 | AAPL | Stock | 8.9025 | 8.9025 | 8.9025 | 8.9025 | 2800.0 |
| 2010-08-17 07:48:00 | AAPL | Stock | 8.9007 | 8.9007 | 8.9007 | 8.9007 | 7000.0 |
| 2010-08-17 07:49:00 | AAPL | Stock | 8.9025 | 8.9025 | 8.9025 | 8.9025 | 2800.0 |
| 2010-08-17 07:50:00 | AAPL | Stock | 8.9025 | 8.9025 | 8.9025 | 8.9025 | 9800.0 |
| 2010-08-17 07:52:00 | AAPL | Stock | 8.9086 | 8.9086 | 8.9086 | 8.9086 | 11200.0 |
| 2010-08-17 07:59:00 | AAPL | Stock | 8.9132 | 8.9132 | 8.9132 | 8.9132 | 2800.0 |
| 2010-08-17 08:00:00 | AAPL | Stock | 8.9039 | 8.9039 | 8.8911 | 8.8911 | 42476.0 |
| 2010-08-17 08:01:00 | AAPL | Stock | 8.8929 | 8.8982 | 8.8929 | 8.8982 | 19600.0 |
| 2010-08-17 08:02:00 | AAPL | Stock | 8.8982 | 8.8982 | 8.8982 | 8.8982 | 5600.0 |
| 2010-08-17 08:03:00 | AAPL | Stock | 8.8982 | 8.8982 | 8.8982 | 8.8982 | 5600.0 |
| 2010-08-17 08:04:00 | AAPL | Stock | 8.8939 | 8.8939 | 8.8929 | 8.8929 | 22960.0 |
| 2010-08-17 08:05:00 | AAPL | Stock | 8.9018 | 8.9018 | 8.9018 | 8.9018 | 13300.0 |
| 2010-08-17 08:06:00 | AAPL | Stock | 8.9018 | 8.9018 | 8.8946 | 8.8946 | 19320.0 |
| 2010-08-17 08:07:00 | AAPL | Stock | 8.8964 | 8.8964 | 8.8964 | 8.8964 | 44800.0 |
| 2010-08-17 08:08:00 | AAPL | Stock | 8.9018 | 8.9018 | 8.9018 | 8.9018 | 11200.0 |
| 2010-08-17 08:09:00 | AAPL | Stock | 8.9018 | 8.9018 | 8.9014 | 8.9018 | 28280.0 |
| 2010-08-17 08:10:00 | AAPL | Stock | 8.9018 | 8.9018 | 8.9018 | 8.9018 | 57484.0 |
| 2010-08-17 08:11:00 | AAPL | Stock | 8.9018 | 8.9018 | 8.9018 | 8.9018 | 2800.0 |
| 2010-08-17 08:12:00 | AAPL | Stock | 8.9018 | 8.9061 | 8.9018 | 8.9061 | 18200.0 |
| 2010-08-17 08:14:00 | AAPL | Stock | 8.9061 | 8.9061 | 8.9018 | 8.9018 | 36400.0 |
| 2010-08-17 08:15:00 | AAPL | Stock | 8.9036 | 8.9036 | 8.9036 | 8.9036 | 2800.0 |
| 2010-08-17 08:17:00 | AAPL | Stock | 8.9036 | 8.9064 | 8.9 | 8.9 | 60508.0 |
| 2010-08-17 08:18:00 | AAPL | Stock | 8.8993 | 8.8993 | 8.8993 | 8.8993 | 2800.0 |
| 2010-08-17 08:19:00 | AAPL | Stock | 8.8996 | 8.9 | 8.8996 | 8.9 | 7000.0 |
| 2010-08-17 08:20:00 | AAPL | Stock | 8.9018 | 8.9107 | 8.9018 | 8.9036 | 120260.0 |
| 2010-08-17 08:23:00 | AAPL | Stock | 8.9025 | 8.9025 | 8.9025 | 8.9025 | 2800.0 |
| 2010-08-17 08:24:00 | AAPL | Stock | 8.9043 | 8.9043 | 8.9043 | 8.9043 | 2800.0 |
| 2010-08-17 08:25:00 | AAPL | Stock | 8.9079 | 8.9082 | 8.9079 | 8.9082 | 16800.0 |
| 2010-08-17 08:26:00 | AAPL | Stock | 8.9082 | 8.9107 | 8.9082 | 8.9107 | 29960.0 |
| 2010-08-17 08:27:00 | AAPL | Stock | 8.9125 | 8.9125 | 8.9107 | 8.9107 | 40600.0 |
| 2010-08-17 08:28:00 | AAPL | Stock | 8.9107 | 8.9107 | 8.9107 | 8.9107 | 28000.0 |
| 2010-08-17 08:29:00 | AAPL | Stock | 8.9107 | 8.9132 | 8.9107 | 8.9107 | 32200.0 |
| 2010-08-17 08:30:00 | AAPL | Stock | 8.9107 | 8.9121 | 8.9036 | 8.9107 | 253036.0 |
| 2010-08-17 08:31:00 | AAPL | Stock | 8.9096 | 8.9207 | 8.9096 | 8.9207 | 75600.0 |
| 2010-08-17 08:32:00 | AAPL | Stock | 8.9196 | 8.9214 | 8.9193 | 8.9214 | 90664.0 |
| 2010-08-17 08:33:00 | AAPL | Stock | 8.9243 | 8.9286 | 8.9229 | 8.9286 | 93968.0 |
| 2010-08-17 08:34:00 | AAPL | Stock | 8.9289 | 8.9346 | 8.9286 | 8.9318 | 38780.0 |
| 2010-08-17 08:35:00 | AAPL | Stock | 8.9339 | 8.9339 | 8.9304 | 8.9304 | 103600.0 |
| 2010-08-17 08:36:00 | AAPL | Stock | 8.9336 | 8.9336 | 8.9296 | 8.9296 | 5600.0 |
| 2010-08-17 08:37:00 | AAPL | Stock | 8.9307 | 8.9339 | 8.9296 | 8.9339 | 30240.0 |
| 2010-08-17 08:38:00 | AAPL | Stock | 8.9325 | 8.9357 | 8.9325 | 8.9325 | 50400.0 |
| 2010-08-17 08:39:00 | AAPL | Stock | 8.9339 | 8.9339 | 8.9339 | 8.9339 | 28000.0 |
| 2010-08-17 08:40:00 | AAPL | Stock | 8.9329 | 8.9357 | 8.9329 | 8.9354 | 21756.0 |
| 2010-08-17 08:41:00 | AAPL | Stock | 8.9332 | 8.9357 | 8.9329 | 8.9339 | 47600.0 |
| 2010-08-17 08:42:00 | AAPL | Stock | 8.9357 | 8.9361 | 8.9357 | 8.9361 | 6440.0 |
> showing 50 of 939,671 rows — these rows as CSV