PREVIEW / stock_1min / 2011-05-04
file: by_date/stock_1min/2011/2011-05-04.parquet size: 14.0 MB rows: 1,040,526 symbols: 2,881
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-05-04 04:43:00 | AAPL | Stock | 12.4393 | 12.4393 | 12.4393 | 12.4393 | 2800.0 |
| 2011-05-04 05:12:00 | AAPL | Stock | 12.4464 | 12.4464 | 12.4464 | 12.4464 | 2800.0 |
| 2011-05-04 06:02:00 | AAPL | Stock | 12.4579 | 12.4579 | 12.4579 | 12.4579 | 2800.0 |
| 2011-05-04 06:46:00 | AAPL | Stock | 12.4107 | 12.4107 | 12.4107 | 12.4107 | 2800.0 |
| 2011-05-04 07:26:00 | AAPL | Stock | 12.4214 | 12.4214 | 12.4214 | 12.4214 | 2800.0 |
| 2011-05-04 07:49:00 | AAPL | Stock | 12.425 | 12.425 | 12.425 | 12.425 | 2800.0 |
| 2011-05-04 07:59:00 | AAPL | Stock | 12.4279 | 12.4279 | 12.4279 | 12.4279 | 2800.0 |
| 2011-05-04 08:00:00 | AAPL | Stock | 12.4214 | 12.4214 | 12.4214 | 12.4214 | 3080.0 |
| 2011-05-04 08:01:00 | AAPL | Stock | 12.4268 | 12.4268 | 12.4268 | 12.4268 | 7140.0 |
| 2011-05-04 08:02:00 | AAPL | Stock | 12.4268 | 12.4286 | 12.4268 | 12.4286 | 11200.0 |
| 2011-05-04 08:04:00 | AAPL | Stock | 12.4286 | 12.4357 | 12.4286 | 12.4357 | 43960.0 |
| 2011-05-04 08:05:00 | AAPL | Stock | 12.4368 | 12.4382 | 12.4368 | 12.4382 | 5600.0 |
| 2011-05-04 08:06:00 | AAPL | Stock | 12.4457 | 12.4589 | 12.4457 | 12.4589 | 35000.0 |
| 2011-05-04 08:08:00 | AAPL | Stock | 12.4518 | 12.4589 | 12.4514 | 12.4514 | 14980.0 |
| 2011-05-04 08:10:00 | AAPL | Stock | 12.4464 | 12.4554 | 12.4393 | 12.4554 | 53200.0 |
| 2011-05-04 08:11:00 | AAPL | Stock | 12.4507 | 12.4507 | 12.4507 | 12.4507 | 19600.0 |
| 2011-05-04 08:12:00 | AAPL | Stock | 12.4504 | 12.4504 | 12.4429 | 12.4429 | 5600.0 |
| 2011-05-04 08:14:00 | AAPL | Stock | 12.4396 | 12.4396 | 12.4396 | 12.4396 | 5600.0 |
| 2011-05-04 08:15:00 | AAPL | Stock | 12.4396 | 12.4396 | 12.4368 | 12.4368 | 51100.0 |
| 2011-05-04 08:18:00 | AAPL | Stock | 12.4368 | 12.4368 | 12.4368 | 12.4368 | 5600.0 |
| 2011-05-04 08:19:00 | AAPL | Stock | 12.4468 | 12.4468 | 12.4468 | 12.4468 | 2800.0 |
| 2011-05-04 08:20:00 | AAPL | Stock | 12.445 | 12.445 | 12.445 | 12.445 | 4900.0 |
| 2011-05-04 08:22:00 | AAPL | Stock | 12.4421 | 12.4421 | 12.4396 | 12.4396 | 11200.0 |
| 2011-05-04 08:23:00 | AAPL | Stock | 12.4411 | 12.4411 | 12.4411 | 12.4411 | 3920.0 |
| 2011-05-04 08:25:00 | AAPL | Stock | 12.4457 | 12.4457 | 12.4457 | 12.4457 | 5880.0 |
| 2011-05-04 08:26:00 | AAPL | Stock | 12.45 | 12.4554 | 12.4486 | 12.4554 | 20720.0 |
| 2011-05-04 08:27:00 | AAPL | Stock | 12.45 | 12.45 | 12.45 | 12.45 | 14000.0 |
| 2011-05-04 08:28:00 | AAPL | Stock | 12.4529 | 12.4529 | 12.45 | 12.45 | 8400.0 |
| 2011-05-04 08:29:00 | AAPL | Stock | 12.4536 | 12.4554 | 12.4536 | 12.4554 | 9800.0 |
| 2011-05-04 08:30:00 | AAPL | Stock | 12.45 | 12.4514 | 12.45 | 12.4514 | 10668.0 |
| 2011-05-04 08:35:00 | AAPL | Stock | 12.4339 | 12.4396 | 12.4339 | 12.4393 | 14000.0 |
| 2011-05-04 08:36:00 | AAPL | Stock | 12.4396 | 12.4396 | 12.4396 | 12.4396 | 2800.0 |
| 2011-05-04 08:37:00 | AAPL | Stock | 12.4471 | 12.4471 | 12.4339 | 12.4339 | 28532.0 |
| 2011-05-04 08:38:00 | AAPL | Stock | 12.4357 | 12.4382 | 12.4339 | 12.4339 | 25200.0 |
| 2011-05-04 08:39:00 | AAPL | Stock | 12.4382 | 12.4382 | 12.4382 | 12.4382 | 5600.0 |
| 2011-05-04 08:40:00 | AAPL | Stock | 12.4375 | 12.4375 | 12.4375 | 12.4375 | 2800.0 |
| 2011-05-04 08:43:00 | AAPL | Stock | 12.4375 | 12.4375 | 12.4375 | 12.4375 | 7000.0 |
| 2011-05-04 08:46:00 | AAPL | Stock | 12.4457 | 12.4518 | 12.4457 | 12.4518 | 36400.0 |
| 2011-05-04 08:47:00 | AAPL | Stock | 12.4479 | 12.4554 | 12.4479 | 12.4554 | 47600.0 |
| 2011-05-04 08:48:00 | AAPL | Stock | 12.4486 | 12.4589 | 12.4486 | 12.455 | 66360.0 |
| 2011-05-04 08:49:00 | AAPL | Stock | 12.4554 | 12.4554 | 12.4539 | 12.4539 | 6244.0 |
| 2011-05-04 08:50:00 | AAPL | Stock | 12.4579 | 12.4579 | 12.4579 | 12.4579 | 2800.0 |
| 2011-05-04 08:52:00 | AAPL | Stock | 12.4582 | 12.4582 | 12.4582 | 12.4582 | 2800.0 |
| 2011-05-04 08:53:00 | AAPL | Stock | 12.4536 | 12.4575 | 12.4536 | 12.4575 | 26600.0 |
| 2011-05-04 08:54:00 | AAPL | Stock | 12.4582 | 12.4582 | 12.4582 | 12.4582 | 8400.0 |
| 2011-05-04 08:57:00 | AAPL | Stock | 12.4564 | 12.4564 | 12.4511 | 12.4511 | 19600.0 |
| 2011-05-04 08:58:00 | AAPL | Stock | 12.4518 | 12.4518 | 12.4518 | 12.4518 | 5208.0 |
| 2011-05-04 09:02:00 | AAPL | Stock | 12.4554 | 12.4554 | 12.45 | 12.45 | 16800.0 |
| 2011-05-04 09:03:00 | AAPL | Stock | 12.4529 | 12.4546 | 12.45 | 12.4532 | 38976.0 |
| 2011-05-04 09:04:00 | AAPL | Stock | 12.4518 | 12.4518 | 12.4518 | 12.4518 | 2800.0 |
> showing 50 of 1,040,526 rows — these rows as CSV