PREVIEW / stock_1min / 2008-11-06
file: by_date/stock_1min/2008/2008-11-06.parquet size: 12.7 MB rows: 1,006,062 symbols: 2,692
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 |
|---|---|---|---|---|---|---|---|
| 2008-11-06 05:54:00 | AAPL | Stock | 3.5836 | 3.5836 | 3.5836 | 3.5836 | 54320.0 |
| 2008-11-06 07:01:00 | AAPL | Stock | 3.6129 | 3.6129 | 3.6046 | 3.6046 | 23800.0 |
| 2008-11-06 07:02:00 | AAPL | Stock | 3.6175 | 3.6246 | 3.6175 | 3.6246 | 7616.0 |
| 2008-11-06 07:03:00 | AAPL | Stock | 3.6214 | 3.6214 | 3.6214 | 3.6214 | 19600.0 |
| 2008-11-06 07:05:00 | AAPL | Stock | 3.6143 | 3.6143 | 3.6143 | 3.6143 | 3500.0 |
| 2008-11-06 07:06:00 | AAPL | Stock | 3.6214 | 3.625 | 3.6214 | 3.625 | 14000.0 |
| 2008-11-06 07:08:00 | AAPL | Stock | 3.6143 | 3.6143 | 3.6143 | 3.6143 | 18200.0 |
| 2008-11-06 07:09:00 | AAPL | Stock | 3.6143 | 3.6143 | 3.6143 | 3.6143 | 13720.0 |
| 2008-11-06 07:17:00 | AAPL | Stock | 3.6143 | 3.6143 | 3.6143 | 3.6143 | 19320.0 |
| 2008-11-06 07:18:00 | AAPL | Stock | 3.6143 | 3.6143 | 3.6143 | 3.6143 | 2800.0 |
| 2008-11-06 07:22:00 | AAPL | Stock | 3.6143 | 3.6143 | 3.6143 | 3.6143 | 2800.0 |
| 2008-11-06 07:23:00 | AAPL | Stock | 3.6143 | 3.6143 | 3.6143 | 3.6143 | 5600.0 |
| 2008-11-06 07:24:00 | AAPL | Stock | 3.6143 | 3.6143 | 3.6143 | 3.6143 | 2800.0 |
| 2008-11-06 07:25:00 | AAPL | Stock | 3.6196 | 3.6196 | 3.6196 | 3.6196 | 2800.0 |
| 2008-11-06 07:26:00 | AAPL | Stock | 3.6196 | 3.6196 | 3.6196 | 3.6196 | 65996.0 |
| 2008-11-06 07:27:00 | AAPL | Stock | 3.6243 | 3.6321 | 3.6243 | 3.6321 | 23800.0 |
| 2008-11-06 07:32:00 | AAPL | Stock | 3.635 | 3.635 | 3.635 | 3.635 | 11200.0 |
| 2008-11-06 07:35:00 | AAPL | Stock | 3.635 | 3.6357 | 3.635 | 3.6357 | 17976.0 |
| 2008-11-06 07:36:00 | AAPL | Stock | 3.6411 | 3.6429 | 3.6411 | 3.6429 | 168000.0 |
| 2008-11-06 07:38:00 | AAPL | Stock | 3.6443 | 3.6443 | 3.6396 | 3.6396 | 16800.0 |
| 2008-11-06 07:42:00 | AAPL | Stock | 3.6321 | 3.6321 | 3.6304 | 3.6304 | 28000.0 |
| 2008-11-06 07:45:00 | AAPL | Stock | 3.6304 | 3.6368 | 3.6304 | 3.6368 | 30800.0 |
| 2008-11-06 07:47:00 | AAPL | Stock | 3.6143 | 3.6214 | 3.6143 | 3.6143 | 40600.0 |
| 2008-11-06 07:48:00 | AAPL | Stock | 3.6143 | 3.6143 | 3.6143 | 3.6143 | 8876.0 |
| 2008-11-06 07:50:00 | AAPL | Stock | 3.6143 | 3.6143 | 3.6143 | 3.6143 | 2800.0 |
| 2008-11-06 07:51:00 | AAPL | Stock | 3.6143 | 3.625 | 3.6143 | 3.625 | 15400.0 |
| 2008-11-06 07:52:00 | AAPL | Stock | 3.615 | 3.6161 | 3.615 | 3.6161 | 19124.0 |
| 2008-11-06 07:56:00 | AAPL | Stock | 3.6143 | 3.6161 | 3.6143 | 3.6161 | 35504.0 |
| 2008-11-06 07:57:00 | AAPL | Stock | 3.6161 | 3.6161 | 3.6161 | 3.6161 | 2800.0 |
| 2008-11-06 08:00:00 | AAPL | Stock | 3.6186 | 3.6186 | 3.5896 | 3.5911 | 92960.0 |
| 2008-11-06 08:01:00 | AAPL | Stock | 3.5982 | 3.6071 | 3.5982 | 3.6071 | 5600.0 |
| 2008-11-06 08:02:00 | AAPL | Stock | 3.6071 | 3.6071 | 3.6071 | 3.6071 | 82320.0 |
| 2008-11-06 08:03:00 | AAPL | Stock | 3.6021 | 3.6021 | 3.5929 | 3.6004 | 65380.0 |
| 2008-11-06 08:04:00 | AAPL | Stock | 3.5929 | 3.5964 | 3.5857 | 3.5893 | 224952.0 |
| 2008-11-06 08:05:00 | AAPL | Stock | 3.5846 | 3.5893 | 3.5846 | 3.5893 | 27440.0 |
| 2008-11-06 08:06:00 | AAPL | Stock | 3.5811 | 3.5854 | 3.5804 | 3.5821 | 178976.0 |
| 2008-11-06 08:07:00 | AAPL | Stock | 3.5804 | 3.5857 | 3.5804 | 3.5857 | 92316.0 |
| 2008-11-06 08:08:00 | AAPL | Stock | 3.5821 | 3.5821 | 3.5821 | 3.5821 | 2800.0 |
| 2008-11-06 08:09:00 | AAPL | Stock | 3.5889 | 3.5929 | 3.5889 | 3.5929 | 110572.0 |
| 2008-11-06 08:10:00 | AAPL | Stock | 3.6032 | 3.6032 | 3.6032 | 3.6032 | 5600.0 |
| 2008-11-06 08:11:00 | AAPL | Stock | 3.5982 | 3.5989 | 3.5911 | 3.5911 | 51548.0 |
| 2008-11-06 08:12:00 | AAPL | Stock | 3.5893 | 3.5946 | 3.5893 | 3.5946 | 35840.0 |
| 2008-11-06 08:13:00 | AAPL | Stock | 3.6 | 3.6 | 3.5932 | 3.5982 | 28000.0 |
| 2008-11-06 08:14:00 | AAPL | Stock | 3.5929 | 3.5929 | 3.5929 | 3.5929 | 5600.0 |
| 2008-11-06 08:15:00 | AAPL | Stock | 3.5936 | 3.5936 | 3.5911 | 3.5911 | 26964.0 |
| 2008-11-06 08:16:00 | AAPL | Stock | 3.5911 | 3.5911 | 3.5911 | 3.5911 | 2800.0 |
| 2008-11-06 08:17:00 | AAPL | Stock | 3.5918 | 3.5929 | 3.5896 | 3.5929 | 20888.0 |
| 2008-11-06 08:18:00 | AAPL | Stock | 3.5932 | 3.5982 | 3.5932 | 3.5982 | 19348.0 |
| 2008-11-06 08:19:00 | AAPL | Stock | 3.6 | 3.6036 | 3.5968 | 3.5968 | 31136.0 |
| 2008-11-06 08:20:00 | AAPL | Stock | 3.5982 | 3.6068 | 3.5982 | 3.6068 | 14504.0 |
> showing 50 of 1,006,062 rows — these rows as CSV