PREVIEW / stock_1min / 2011-04-26
file: by_date/stock_1min/2011/2011-04-26.parquet size: 13.6 MB rows: 1,006,054 symbols: 2,892
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-04-26 04:03:00 | AAPL | Stock | 12.6432 | 12.6432 | 12.6432 | 12.6432 | 2800.0 |
| 2011-04-26 04:16:00 | AAPL | Stock | 12.6514 | 12.6514 | 12.6514 | 12.6514 | 2800.0 |
| 2011-04-26 04:38:00 | AAPL | Stock | 12.6518 | 12.6518 | 12.6518 | 12.6518 | 2800.0 |
| 2011-04-26 04:39:00 | AAPL | Stock | 12.6518 | 12.6518 | 12.6518 | 12.6518 | 2800.0 |
| 2011-04-26 04:48:00 | AAPL | Stock | 12.6375 | 12.6375 | 12.6375 | 12.6375 | 2800.0 |
| 2011-04-26 04:49:00 | AAPL | Stock | 12.6389 | 12.6389 | 12.6389 | 12.6389 | 5600.0 |
| 2011-04-26 04:59:00 | AAPL | Stock | 12.6496 | 12.6496 | 12.6496 | 12.6496 | 2800.0 |
| 2011-04-26 05:37:00 | AAPL | Stock | 12.6607 | 12.6607 | 12.6607 | 12.6607 | 4200.0 |
| 2011-04-26 07:02:00 | AAPL | Stock | 12.6429 | 12.6429 | 12.6429 | 12.6429 | 2800.0 |
| 2011-04-26 07:04:00 | AAPL | Stock | 12.6404 | 12.6404 | 12.6404 | 12.6404 | 2800.0 |
| 2011-04-26 07:13:00 | AAPL | Stock | 12.6389 | 12.6389 | 12.6389 | 12.6389 | 42000.0 |
| 2011-04-26 07:15:00 | AAPL | Stock | 12.6375 | 12.6375 | 12.6375 | 12.6375 | 20832.0 |
| 2011-04-26 07:17:00 | AAPL | Stock | 12.6404 | 12.6404 | 12.6404 | 12.6404 | 2800.0 |
| 2011-04-26 07:18:00 | AAPL | Stock | 12.6375 | 12.6375 | 12.6375 | 12.6375 | 2912.0 |
| 2011-04-26 07:21:00 | AAPL | Stock | 12.6393 | 12.6393 | 12.6393 | 12.6393 | 5600.0 |
| 2011-04-26 07:23:00 | AAPL | Stock | 12.6425 | 12.6425 | 12.6425 | 12.6425 | 2800.0 |
| 2011-04-26 07:26:00 | AAPL | Stock | 12.6464 | 12.6464 | 12.6464 | 12.6464 | 2800.0 |
| 2011-04-26 07:30:00 | AAPL | Stock | 12.6464 | 12.6464 | 12.6464 | 12.6464 | 2800.0 |
| 2011-04-26 07:40:00 | AAPL | Stock | 12.6418 | 12.6418 | 12.6418 | 12.6418 | 2800.0 |
| 2011-04-26 07:48:00 | AAPL | Stock | 12.65 | 12.65 | 12.65 | 12.65 | 2800.0 |
| 2011-04-26 07:49:00 | AAPL | Stock | 12.65 | 12.65 | 12.65 | 12.65 | 2800.0 |
| 2011-04-26 07:50:00 | AAPL | Stock | 12.6436 | 12.6436 | 12.6436 | 12.6436 | 25200.0 |
| 2011-04-26 07:52:00 | AAPL | Stock | 12.6436 | 12.6436 | 12.6436 | 12.6436 | 2800.0 |
| 2011-04-26 07:53:00 | AAPL | Stock | 12.6436 | 12.6436 | 12.6436 | 12.6436 | 2800.0 |
| 2011-04-26 07:54:00 | AAPL | Stock | 12.6429 | 12.6429 | 12.6429 | 12.6429 | 2800.0 |
| 2011-04-26 07:55:00 | AAPL | Stock | 12.6429 | 12.6429 | 12.6429 | 12.6429 | 2800.0 |
| 2011-04-26 07:57:00 | AAPL | Stock | 12.6496 | 12.65 | 12.6496 | 12.65 | 8400.0 |
| 2011-04-26 07:59:00 | AAPL | Stock | 12.6482 | 12.6489 | 12.6482 | 12.6482 | 28000.0 |
| 2011-04-26 08:00:00 | AAPL | Stock | 12.65 | 12.6571 | 12.6425 | 12.6429 | 103908.0 |
| 2011-04-26 08:01:00 | AAPL | Stock | 12.6482 | 12.6482 | 12.6429 | 12.6429 | 17976.0 |
| 2011-04-26 08:02:00 | AAPL | Stock | 12.645 | 12.6464 | 12.645 | 12.6464 | 11480.0 |
| 2011-04-26 08:04:00 | AAPL | Stock | 12.6429 | 12.6429 | 12.6429 | 12.6429 | 38528.0 |
| 2011-04-26 08:06:00 | AAPL | Stock | 12.6429 | 12.6461 | 12.6429 | 12.6461 | 51156.0 |
| 2011-04-26 08:07:00 | AAPL | Stock | 12.6464 | 12.6464 | 12.6464 | 12.6464 | 2800.0 |
| 2011-04-26 08:09:00 | AAPL | Stock | 12.6479 | 12.6479 | 12.6479 | 12.6479 | 5600.0 |
| 2011-04-26 08:10:00 | AAPL | Stock | 12.6479 | 12.65 | 12.6446 | 12.6457 | 43820.0 |
| 2011-04-26 08:12:00 | AAPL | Stock | 12.6496 | 12.6507 | 12.6496 | 12.65 | 16800.0 |
| 2011-04-26 08:13:00 | AAPL | Stock | 12.65 | 12.65 | 12.65 | 12.65 | 17612.0 |
| 2011-04-26 08:14:00 | AAPL | Stock | 12.6464 | 12.6464 | 12.6464 | 12.6464 | 3276.0 |
| 2011-04-26 08:15:00 | AAPL | Stock | 12.6482 | 12.6482 | 12.6482 | 12.6482 | 5600.0 |
| 2011-04-26 08:16:00 | AAPL | Stock | 12.65 | 12.65 | 12.645 | 12.645 | 14700.0 |
| 2011-04-26 08:19:00 | AAPL | Stock | 12.6443 | 12.6443 | 12.6393 | 12.6393 | 47516.0 |
| 2011-04-26 08:20:00 | AAPL | Stock | 12.6429 | 12.6429 | 12.6429 | 12.6429 | 5516.0 |
| 2011-04-26 08:21:00 | AAPL | Stock | 12.6429 | 12.6429 | 12.6429 | 12.6429 | 8400.0 |
| 2011-04-26 08:22:00 | AAPL | Stock | 12.6471 | 12.6471 | 12.6471 | 12.6471 | 2800.0 |
| 2011-04-26 08:23:00 | AAPL | Stock | 12.6471 | 12.6475 | 12.6464 | 12.6464 | 8400.0 |
| 2011-04-26 08:24:00 | AAPL | Stock | 12.6468 | 12.6468 | 12.6468 | 12.6468 | 8400.0 |
| 2011-04-26 08:26:00 | AAPL | Stock | 12.6468 | 12.6468 | 12.6468 | 12.6468 | 2800.0 |
| 2011-04-26 08:29:00 | AAPL | Stock | 12.6482 | 12.6482 | 12.6443 | 12.645 | 19600.0 |
| 2011-04-26 08:30:00 | AAPL | Stock | 12.645 | 12.645 | 12.6429 | 12.6429 | 35000.0 |
> showing 50 of 1,006,054 rows — these rows as CSV