PREVIEW / stock_1min / 2011-06-01
file: by_date/stock_1min/2011/2011-06-01.parquet size: 14.5 MB rows: 1,081,270 symbols: 2,888
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 |
|---|---|---|---|---|---|---|---|
| 2011-06-01 04:26:00 | AAPL | Stock | 12.4607 | 12.4607 | 12.4607 | 12.4607 | 2800.0 |
| 2011-06-01 04:40:00 | AAPL | Stock | 12.4339 | 12.4339 | 12.4339 | 12.4339 | 2800.0 |
| 2011-06-01 05:12:00 | AAPL | Stock | 12.4286 | 12.4286 | 12.4286 | 12.4286 | 2800.0 |
| 2011-06-01 05:13:00 | AAPL | Stock | 12.4286 | 12.4286 | 12.4286 | 12.4286 | 2800.0 |
| 2011-06-01 05:32:00 | AAPL | Stock | 12.4286 | 12.4286 | 12.4286 | 12.4286 | 2800.0 |
| 2011-06-01 05:54:00 | AAPL | Stock | 12.4286 | 12.4286 | 12.4286 | 12.4286 | 4480.0 |
| 2011-06-01 05:56:00 | AAPL | Stock | 12.4107 | 12.4107 | 12.4054 | 12.4107 | 53200.0 |
| 2011-06-01 06:31:00 | AAPL | Stock | 12.4 | 12.4 | 12.4 | 12.4 | 28000.0 |
| 2011-06-01 06:33:00 | AAPL | Stock | 12.3971 | 12.3971 | 12.3929 | 12.3929 | 8288.0 |
| 2011-06-01 06:39:00 | AAPL | Stock | 12.3957 | 12.3957 | 12.3957 | 12.3957 | 2800.0 |
| 2011-06-01 06:52:00 | AAPL | Stock | 12.4071 | 12.4071 | 12.4036 | 12.4036 | 16800.0 |
| 2011-06-01 07:01:00 | AAPL | Stock | 12.4161 | 12.4168 | 12.4161 | 12.4168 | 35196.0 |
| 2011-06-01 07:02:00 | AAPL | Stock | 12.4168 | 12.4168 | 12.4168 | 12.4168 | 33600.0 |
| 2011-06-01 07:03:00 | AAPL | Stock | 12.4168 | 12.4168 | 12.4168 | 12.4168 | 12152.0 |
| 2011-06-01 07:04:00 | AAPL | Stock | 12.4246 | 12.4246 | 12.4246 | 12.4246 | 2800.0 |
| 2011-06-01 07:05:00 | AAPL | Stock | 12.4357 | 12.4393 | 12.4357 | 12.4393 | 27860.0 |
| 2011-06-01 07:06:00 | AAPL | Stock | 12.4446 | 12.4446 | 12.4446 | 12.4446 | 2800.0 |
| 2011-06-01 07:10:00 | AAPL | Stock | 12.4393 | 12.4393 | 12.4393 | 12.4393 | 5600.0 |
| 2011-06-01 07:11:00 | AAPL | Stock | 12.4454 | 12.4461 | 12.4454 | 12.4461 | 5600.0 |
| 2011-06-01 07:15:00 | AAPL | Stock | 12.4304 | 12.4304 | 12.4246 | 12.4286 | 67200.0 |
| 2011-06-01 07:18:00 | AAPL | Stock | 12.4286 | 12.4286 | 12.4246 | 12.4246 | 11200.0 |
| 2011-06-01 07:19:00 | AAPL | Stock | 12.4111 | 12.4111 | 12.4107 | 12.4107 | 16800.0 |
| 2011-06-01 07:20:00 | AAPL | Stock | 12.4211 | 12.4211 | 12.4211 | 12.4211 | 5600.0 |
| 2011-06-01 07:21:00 | AAPL | Stock | 12.4211 | 12.4214 | 12.4211 | 12.4214 | 33600.0 |
| 2011-06-01 07:28:00 | AAPL | Stock | 12.4268 | 12.4268 | 12.4268 | 12.4268 | 25200.0 |
| 2011-06-01 07:31:00 | AAPL | Stock | 12.4318 | 12.4318 | 12.4318 | 12.4318 | 42000.0 |
| 2011-06-01 07:36:00 | AAPL | Stock | 12.425 | 12.425 | 12.425 | 12.425 | 5600.0 |
| 2011-06-01 07:46:00 | AAPL | Stock | 12.4286 | 12.4286 | 12.425 | 12.425 | 29680.0 |
| 2011-06-01 07:48:00 | AAPL | Stock | 12.4214 | 12.4257 | 12.4214 | 12.4257 | 8400.0 |
| 2011-06-01 07:52:00 | AAPL | Stock | 12.4196 | 12.4243 | 12.4196 | 12.4243 | 8400.0 |
| 2011-06-01 07:53:00 | AAPL | Stock | 12.4246 | 12.4286 | 12.4246 | 12.4286 | 30800.0 |
| 2011-06-01 07:58:00 | AAPL | Stock | 12.4254 | 12.4254 | 12.425 | 12.425 | 8400.0 |
| 2011-06-01 08:00:00 | AAPL | Stock | 12.4225 | 12.4379 | 12.4225 | 12.4379 | 422240.0 |
| 2011-06-01 08:01:00 | AAPL | Stock | 12.4439 | 12.4536 | 12.4439 | 12.4536 | 149240.0 |
| 2011-06-01 08:02:00 | AAPL | Stock | 12.4518 | 12.4518 | 12.4446 | 12.4464 | 279272.0 |
| 2011-06-01 08:03:00 | AAPL | Stock | 12.4518 | 12.4518 | 12.4518 | 12.4518 | 5600.0 |
| 2011-06-01 08:04:00 | AAPL | Stock | 12.4518 | 12.4571 | 12.4489 | 12.4564 | 56560.0 |
| 2011-06-01 08:05:00 | AAPL | Stock | 12.4571 | 12.4621 | 12.4554 | 12.46 | 80640.0 |
| 2011-06-01 08:06:00 | AAPL | Stock | 12.4525 | 12.4525 | 12.4464 | 12.4518 | 83692.0 |
| 2011-06-01 08:07:00 | AAPL | Stock | 12.4536 | 12.4536 | 12.4536 | 12.4536 | 13860.0 |
| 2011-06-01 08:08:00 | AAPL | Stock | 12.4579 | 12.4589 | 12.4325 | 12.4325 | 86632.0 |
| 2011-06-01 08:09:00 | AAPL | Stock | 12.4457 | 12.4457 | 12.4375 | 12.4375 | 17920.0 |
| 2011-06-01 08:10:00 | AAPL | Stock | 12.4393 | 12.4532 | 12.4329 | 12.45 | 99120.0 |
| 2011-06-01 08:11:00 | AAPL | Stock | 12.4532 | 12.4532 | 12.4357 | 12.4411 | 17360.0 |
| 2011-06-01 08:12:00 | AAPL | Stock | 12.4464 | 12.4464 | 12.4464 | 12.4464 | 4480.0 |
| 2011-06-01 08:13:00 | AAPL | Stock | 12.4429 | 12.4464 | 12.4429 | 12.4429 | 19600.0 |
| 2011-06-01 08:14:00 | AAPL | Stock | 12.4346 | 12.4393 | 12.4346 | 12.4393 | 16800.0 |
| 2011-06-01 08:15:00 | AAPL | Stock | 12.4393 | 12.4393 | 12.4236 | 12.43 | 233884.0 |
| 2011-06-01 08:16:00 | AAPL | Stock | 12.4304 | 12.4354 | 12.4286 | 12.4286 | 176400.0 |
| 2011-06-01 08:17:00 | AAPL | Stock | 12.4293 | 12.4296 | 12.4286 | 12.4286 | 29260.0 |
> showing 50 of 1,081,270 rows — these rows as CSV