PREVIEW / stock_1min / 2010-01-27
file: by_date/stock_1min/2010/2010-01-27.parquet size: 12.7 MB rows: 958,177 symbols: 2,791
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-01-27 04:19:00 | AAPL | Stock | 7.3961 | 7.3961 | 7.3961 | 7.3961 | 14000.0 |
| 2010-01-27 04:20:00 | AAPL | Stock | 7.3964 | 7.3964 | 7.3954 | 7.3954 | 16800.0 |
| 2010-01-27 04:23:00 | AAPL | Stock | 7.3964 | 7.3964 | 7.3964 | 7.3964 | 2800.0 |
| 2010-01-27 04:25:00 | AAPL | Stock | 7.3964 | 7.3964 | 7.3964 | 7.3964 | 2800.0 |
| 2010-01-27 04:26:00 | AAPL | Stock | 7.4054 | 7.4054 | 7.4054 | 7.4054 | 2800.0 |
| 2010-01-27 05:26:00 | AAPL | Stock | 7.4132 | 7.4132 | 7.4132 | 7.4132 | 6160.0 |
| 2010-01-27 05:32:00 | AAPL | Stock | 7.4246 | 7.4246 | 7.4246 | 7.4246 | 14000.0 |
| 2010-01-27 05:33:00 | AAPL | Stock | 7.425 | 7.425 | 7.425 | 7.425 | 14000.0 |
| 2010-01-27 05:36:00 | AAPL | Stock | 7.425 | 7.425 | 7.425 | 7.425 | 2800.0 |
| 2010-01-27 05:39:00 | AAPL | Stock | 7.4204 | 7.4204 | 7.4204 | 7.4204 | 10192.0 |
| 2010-01-27 05:40:00 | AAPL | Stock | 7.4193 | 7.4193 | 7.4193 | 7.4193 | 8400.0 |
| 2010-01-27 05:56:00 | AAPL | Stock | 7.4157 | 7.4157 | 7.4157 | 7.4157 | 2800.0 |
| 2010-01-27 05:57:00 | AAPL | Stock | 7.4246 | 7.4264 | 7.4246 | 7.4264 | 5600.0 |
| 2010-01-27 06:02:00 | AAPL | Stock | 7.4246 | 7.4246 | 7.4246 | 7.4246 | 5600.0 |
| 2010-01-27 06:03:00 | AAPL | Stock | 7.425 | 7.425 | 7.425 | 7.425 | 2800.0 |
| 2010-01-27 06:05:00 | AAPL | Stock | 7.4189 | 7.4189 | 7.4189 | 7.4189 | 2800.0 |
| 2010-01-27 06:11:00 | AAPL | Stock | 7.425 | 7.425 | 7.425 | 7.425 | 2800.0 |
| 2010-01-27 06:14:00 | AAPL | Stock | 7.425 | 7.425 | 7.425 | 7.425 | 9408.0 |
| 2010-01-27 06:15:00 | AAPL | Stock | 7.4268 | 7.4275 | 7.4268 | 7.4275 | 14000.0 |
| 2010-01-27 06:19:00 | AAPL | Stock | 7.4375 | 7.4375 | 7.4375 | 7.4375 | 4200.0 |
| 2010-01-27 06:43:00 | AAPL | Stock | 7.4289 | 7.4418 | 7.4286 | 7.4418 | 54152.0 |
| 2010-01-27 06:44:00 | AAPL | Stock | 7.4421 | 7.4421 | 7.4421 | 7.4421 | 2800.0 |
| 2010-01-27 06:46:00 | AAPL | Stock | 7.4421 | 7.4464 | 7.4421 | 7.4464 | 25984.0 |
| 2010-01-27 06:53:00 | AAPL | Stock | 7.4404 | 7.4404 | 7.4321 | 7.4321 | 19600.0 |
| 2010-01-27 07:00:00 | AAPL | Stock | 7.42 | 7.4254 | 7.4179 | 7.4254 | 28000.0 |
| 2010-01-27 07:03:00 | AAPL | Stock | 7.4146 | 7.4146 | 7.4146 | 7.4146 | 2800.0 |
| 2010-01-27 07:04:00 | AAPL | Stock | 7.4321 | 7.4321 | 7.4286 | 7.4286 | 8400.0 |
| 2010-01-27 07:05:00 | AAPL | Stock | 7.4286 | 7.4286 | 7.4286 | 7.4286 | 19600.0 |
| 2010-01-27 07:07:00 | AAPL | Stock | 7.4286 | 7.4321 | 7.4286 | 7.4321 | 40068.0 |
| 2010-01-27 07:08:00 | AAPL | Stock | 7.4318 | 7.4339 | 7.4314 | 7.4339 | 63840.0 |
| 2010-01-27 07:10:00 | AAPL | Stock | 7.4339 | 7.4339 | 7.4321 | 7.4321 | 8400.0 |
| 2010-01-27 07:11:00 | AAPL | Stock | 7.4346 | 7.4346 | 7.4346 | 7.4346 | 2800.0 |
| 2010-01-27 07:12:00 | AAPL | Stock | 7.4386 | 7.4386 | 7.4386 | 7.4386 | 5600.0 |
| 2010-01-27 07:13:00 | AAPL | Stock | 7.435 | 7.4382 | 7.4346 | 7.4346 | 18144.0 |
| 2010-01-27 07:14:00 | AAPL | Stock | 7.4354 | 7.4354 | 7.4321 | 7.4321 | 67620.0 |
| 2010-01-27 07:15:00 | AAPL | Stock | 7.4293 | 7.4321 | 7.4286 | 7.4321 | 66584.0 |
| 2010-01-27 07:16:00 | AAPL | Stock | 7.4286 | 7.4321 | 7.4286 | 7.4321 | 44800.0 |
| 2010-01-27 07:18:00 | AAPL | Stock | 7.4293 | 7.4293 | 7.4293 | 7.4293 | 14000.0 |
| 2010-01-27 07:19:00 | AAPL | Stock | 7.4296 | 7.4296 | 7.425 | 7.4286 | 39340.0 |
| 2010-01-27 07:20:00 | AAPL | Stock | 7.4268 | 7.4286 | 7.4243 | 7.4243 | 34580.0 |
| 2010-01-27 07:21:00 | AAPL | Stock | 7.4204 | 7.4204 | 7.4204 | 7.4204 | 2800.0 |
| 2010-01-27 07:22:00 | AAPL | Stock | 7.4282 | 7.4354 | 7.4282 | 7.4286 | 55160.0 |
| 2010-01-27 07:23:00 | AAPL | Stock | 7.4286 | 7.4286 | 7.4286 | 7.4286 | 18200.0 |
| 2010-01-27 07:24:00 | AAPL | Stock | 7.4321 | 7.4321 | 7.4318 | 7.4318 | 9800.0 |
| 2010-01-27 07:25:00 | AAPL | Stock | 7.4289 | 7.4289 | 7.4286 | 7.4286 | 37800.0 |
| 2010-01-27 07:26:00 | AAPL | Stock | 7.4232 | 7.4232 | 7.4232 | 7.4232 | 14000.0 |
| 2010-01-27 07:27:00 | AAPL | Stock | 7.4286 | 7.4286 | 7.4282 | 7.4282 | 14000.0 |
| 2010-01-27 07:28:00 | AAPL | Stock | 7.4282 | 7.4286 | 7.4282 | 7.4286 | 28000.0 |
| 2010-01-27 07:29:00 | AAPL | Stock | 7.4236 | 7.4236 | 7.4107 | 7.4107 | 115388.0 |
| 2010-01-27 07:30:00 | AAPL | Stock | 7.4089 | 7.4089 | 7.3936 | 7.4014 | 199500.0 |
> showing 50 of 958,177 rows — these rows as CSV