PREVIEW / stock_1min / 2009-10-02
file: by_date/stock_1min/2009/2009-10-02.parquet size: 12.8 MB rows: 974,480 symbols: 2,745
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 |
|---|---|---|---|---|---|---|---|
| 2009-10-02 04:15:00 | AAPL | Stock | 6.535 | 6.535 | 6.535 | 6.535 | 2800.0 |
| 2009-10-02 05:25:00 | AAPL | Stock | 6.5107 | 6.5107 | 6.5107 | 6.5107 | 2800.0 |
| 2009-10-02 05:26:00 | AAPL | Stock | 6.5107 | 6.5107 | 6.5107 | 6.5107 | 11200.0 |
| 2009-10-02 05:27:00 | AAPL | Stock | 6.5107 | 6.5107 | 6.5107 | 6.5107 | 14000.0 |
| 2009-10-02 05:46:00 | AAPL | Stock | 6.5146 | 6.5146 | 6.5143 | 6.5143 | 55860.0 |
| 2009-10-02 05:47:00 | AAPL | Stock | 6.5143 | 6.5143 | 6.5125 | 6.5125 | 83860.0 |
| 2009-10-02 06:06:00 | AAPL | Stock | 6.5114 | 6.5114 | 6.5114 | 6.5114 | 28000.0 |
| 2009-10-02 06:07:00 | AAPL | Stock | 6.5114 | 6.5114 | 6.5114 | 6.5114 | 14000.0 |
| 2009-10-02 06:13:00 | AAPL | Stock | 6.5136 | 6.5136 | 6.5136 | 6.5136 | 8400.0 |
| 2009-10-02 06:15:00 | AAPL | Stock | 6.5268 | 6.5268 | 6.5268 | 6.5268 | 22400.0 |
| 2009-10-02 06:16:00 | AAPL | Stock | 6.5179 | 6.5179 | 6.5179 | 6.5179 | 28000.0 |
| 2009-10-02 06:20:00 | AAPL | Stock | 6.5179 | 6.5179 | 6.5179 | 6.5179 | 28000.0 |
| 2009-10-02 06:40:00 | AAPL | Stock | 6.5229 | 6.5232 | 6.5229 | 6.5232 | 11200.0 |
| 2009-10-02 06:42:00 | AAPL | Stock | 6.5179 | 6.5179 | 6.5179 | 6.5179 | 2800.0 |
| 2009-10-02 06:43:00 | AAPL | Stock | 6.5179 | 6.5179 | 6.5179 | 6.5179 | 2800.0 |
| 2009-10-02 07:00:00 | AAPL | Stock | 6.5304 | 6.5304 | 6.5214 | 6.5214 | 25200.0 |
| 2009-10-02 07:04:00 | AAPL | Stock | 6.5214 | 6.5214 | 6.5214 | 6.5214 | 2800.0 |
| 2009-10-02 07:05:00 | AAPL | Stock | 6.5214 | 6.5214 | 6.5211 | 6.5211 | 32200.0 |
| 2009-10-02 07:06:00 | AAPL | Stock | 6.5304 | 6.5325 | 6.5304 | 6.5325 | 5600.0 |
| 2009-10-02 07:11:00 | AAPL | Stock | 6.5214 | 6.5214 | 6.5214 | 6.5214 | 8400.0 |
| 2009-10-02 07:16:00 | AAPL | Stock | 6.5179 | 6.5179 | 6.5179 | 6.5179 | 2800.0 |
| 2009-10-02 07:17:00 | AAPL | Stock | 6.5096 | 6.5096 | 6.5089 | 6.5093 | 39704.0 |
| 2009-10-02 07:18:00 | AAPL | Stock | 6.5125 | 6.5125 | 6.5125 | 6.5125 | 2800.0 |
| 2009-10-02 07:19:00 | AAPL | Stock | 6.5129 | 6.5143 | 6.5129 | 6.5143 | 64316.0 |
| 2009-10-02 07:26:00 | AAPL | Stock | 6.5125 | 6.5125 | 6.5125 | 6.5125 | 5600.0 |
| 2009-10-02 07:27:00 | AAPL | Stock | 6.5125 | 6.5125 | 6.5125 | 6.5125 | 2800.0 |
| 2009-10-02 07:29:00 | AAPL | Stock | 6.5179 | 6.5179 | 6.5179 | 6.5179 | 2800.0 |
| 2009-10-02 07:30:00 | AAPL | Stock | 6.5104 | 6.5104 | 6.51 | 6.51 | 30800.0 |
| 2009-10-02 07:31:00 | AAPL | Stock | 6.5089 | 6.5089 | 6.5089 | 6.5089 | 13496.0 |
| 2009-10-02 07:32:00 | AAPL | Stock | 6.5093 | 6.5093 | 6.5 | 6.5036 | 151200.0 |
| 2009-10-02 07:33:00 | AAPL | Stock | 6.5089 | 6.5089 | 6.5089 | 6.5089 | 8428.0 |
| 2009-10-02 07:37:00 | AAPL | Stock | 6.5179 | 6.5179 | 6.5179 | 6.5179 | 7028.0 |
| 2009-10-02 07:38:00 | AAPL | Stock | 6.5179 | 6.5179 | 6.5179 | 6.5179 | 2800.0 |
| 2009-10-02 07:41:00 | AAPL | Stock | 6.5125 | 6.5211 | 6.5125 | 6.5211 | 47516.0 |
| 2009-10-02 07:43:00 | AAPL | Stock | 6.5179 | 6.5179 | 6.5179 | 6.5179 | 33656.0 |
| 2009-10-02 07:44:00 | AAPL | Stock | 6.5179 | 6.5179 | 6.5179 | 6.5179 | 2800.0 |
| 2009-10-02 07:47:00 | AAPL | Stock | 6.5196 | 6.525 | 6.5196 | 6.525 | 42980.0 |
| 2009-10-02 07:48:00 | AAPL | Stock | 6.5182 | 6.5182 | 6.5182 | 6.5182 | 2800.0 |
| 2009-10-02 07:52:00 | AAPL | Stock | 6.5264 | 6.5264 | 6.5264 | 6.5264 | 8400.0 |
| 2009-10-02 07:53:00 | AAPL | Stock | 6.5261 | 6.5261 | 6.5143 | 6.5143 | 151760.0 |
| 2009-10-02 07:54:00 | AAPL | Stock | 6.5182 | 6.525 | 6.5182 | 6.525 | 120400.0 |
| 2009-10-02 07:55:00 | AAPL | Stock | 6.5246 | 6.5246 | 6.5246 | 6.5246 | 2800.0 |
| 2009-10-02 07:56:00 | AAPL | Stock | 6.5246 | 6.5321 | 6.5196 | 6.5196 | 258160.0 |
| 2009-10-02 07:57:00 | AAPL | Stock | 6.5261 | 6.5275 | 6.5261 | 6.5275 | 11200.0 |
| 2009-10-02 07:58:00 | AAPL | Stock | 6.5279 | 6.5279 | 6.5279 | 6.5279 | 2800.0 |
| 2009-10-02 07:59:00 | AAPL | Stock | 6.5268 | 6.5268 | 6.5268 | 6.5268 | 8400.0 |
| 2009-10-02 08:00:00 | AAPL | Stock | 6.5232 | 6.5261 | 6.5179 | 6.5179 | 369376.0 |
| 2009-10-02 08:01:00 | AAPL | Stock | 6.5161 | 6.5175 | 6.5143 | 6.5143 | 70560.0 |
| 2009-10-02 08:02:00 | AAPL | Stock | 6.5161 | 6.5161 | 6.5125 | 6.5125 | 11900.0 |
| 2009-10-02 08:03:00 | AAPL | Stock | 6.5143 | 6.5168 | 6.5118 | 6.5118 | 182308.0 |
> showing 50 of 974,480 rows — these rows as CSV