PREVIEW / stock_5min / 2011-10-27
file: by_date/stock_5min/2011/2011-10-27.parquet size: 5.4 MB rows: 359,882 symbols: 3,557
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-10-27 04:00:00 | AAPL | Stock | 14.3714 | 14.4857 | 14.3714 | 14.4857 | 9800.0 |
| 2011-10-27 04:05:00 | AAPL | Stock | 14.5 | 14.5 | 14.5 | 14.5 | 5600.0 |
| 2011-10-27 04:15:00 | AAPL | Stock | 14.4639 | 14.4639 | 14.4639 | 14.4639 | 4788.0 |
| 2011-10-27 04:20:00 | AAPL | Stock | 14.4754 | 14.4754 | 14.4754 | 14.4754 | 5600.0 |
| 2011-10-27 04:25:00 | AAPL | Stock | 14.4779 | 14.4779 | 14.4779 | 14.4779 | 5600.0 |
| 2011-10-27 04:30:00 | AAPL | Stock | 14.4961 | 14.4961 | 14.4961 | 14.4961 | 2800.0 |
| 2011-10-27 04:40:00 | AAPL | Stock | 14.4821 | 14.4821 | 14.4821 | 14.4821 | 8400.0 |
| 2011-10-27 04:45:00 | AAPL | Stock | 14.4961 | 14.4961 | 14.4961 | 14.4961 | 9800.0 |
| 2011-10-27 04:50:00 | AAPL | Stock | 14.5161 | 14.5161 | 14.5161 | 14.5161 | 14000.0 |
| 2011-10-27 05:05:00 | AAPL | Stock | 14.5179 | 14.5179 | 14.5179 | 14.5179 | 2800.0 |
| 2011-10-27 05:15:00 | AAPL | Stock | 14.5179 | 14.5179 | 14.5179 | 14.5179 | 11116.0 |
| 2011-10-27 05:20:00 | AAPL | Stock | 14.5179 | 14.5179 | 14.5179 | 14.5179 | 2800.0 |
| 2011-10-27 05:25:00 | AAPL | Stock | 14.5179 | 14.5179 | 14.5179 | 14.5179 | 2800.0 |
| 2011-10-27 05:30:00 | AAPL | Stock | 14.5179 | 14.5179 | 14.5179 | 14.5179 | 2800.0 |
| 2011-10-27 05:40:00 | AAPL | Stock | 14.5179 | 14.5179 | 14.5179 | 14.5179 | 3724.0 |
| 2011-10-27 05:45:00 | AAPL | Stock | 14.5096 | 14.5096 | 14.5 | 14.5 | 5600.0 |
| 2011-10-27 05:50:00 | AAPL | Stock | 14.5089 | 14.5089 | 14.5089 | 14.5089 | 2800.0 |
| 2011-10-27 06:00:00 | AAPL | Stock | 14.5357 | 14.5357 | 14.5357 | 14.5357 | 2800.0 |
| 2011-10-27 06:05:00 | AAPL | Stock | 14.5357 | 14.5357 | 14.5179 | 14.5354 | 25200.0 |
| 2011-10-27 06:10:00 | AAPL | Stock | 14.5179 | 14.5179 | 14.5179 | 14.5179 | 2800.0 |
| 2011-10-27 06:15:00 | AAPL | Stock | 14.5357 | 14.5357 | 14.5357 | 14.5357 | 2800.0 |
| 2011-10-27 06:50:00 | AAPL | Stock | 14.5357 | 14.5536 | 14.5357 | 14.5536 | 27720.0 |
| 2011-10-27 06:55:00 | AAPL | Stock | 14.5536 | 14.5607 | 14.5536 | 14.5607 | 5600.0 |
| 2011-10-27 07:00:00 | AAPL | Stock | 14.5625 | 14.6032 | 14.5625 | 14.5979 | 345184.0 |
| 2011-10-27 07:05:00 | AAPL | Stock | 14.5979 | 14.5982 | 14.5714 | 14.5714 | 204344.0 |
| 2011-10-27 07:10:00 | AAPL | Stock | 14.5571 | 14.5571 | 14.5361 | 14.5536 | 134120.0 |
| 2011-10-27 07:15:00 | AAPL | Stock | 14.5393 | 14.545 | 14.5286 | 14.545 | 70000.0 |
| 2011-10-27 07:20:00 | AAPL | Stock | 14.5454 | 14.5604 | 14.5443 | 14.56 | 26936.0 |
| 2011-10-27 07:25:00 | AAPL | Stock | 14.56 | 14.5811 | 14.5596 | 14.5811 | 144200.0 |
| 2011-10-27 07:30:00 | AAPL | Stock | 14.5875 | 14.5893 | 14.5643 | 14.5643 | 158396.0 |
| 2011-10-27 07:35:00 | AAPL | Stock | 14.5711 | 14.5714 | 14.5554 | 14.5554 | 19600.0 |
| 2011-10-27 07:40:00 | AAPL | Stock | 14.5643 | 14.5696 | 14.5429 | 14.5586 | 63700.0 |
| 2011-10-27 07:45:00 | AAPL | Stock | 14.5586 | 14.5607 | 14.5504 | 14.5546 | 28000.0 |
| 2011-10-27 07:50:00 | AAPL | Stock | 14.5629 | 14.5675 | 14.5532 | 14.5532 | 179676.0 |
| 2011-10-27 07:55:00 | AAPL | Stock | 14.56 | 14.5829 | 14.56 | 14.5739 | 114520.0 |
| 2011-10-27 08:00:00 | AAPL | Stock | 14.5721 | 14.5829 | 14.5393 | 14.5711 | 1319472.0 |
| 2011-10-27 08:05:00 | AAPL | Stock | 14.5714 | 14.5732 | 14.5357 | 14.5357 | 416864.0 |
| 2011-10-27 08:10:00 | AAPL | Stock | 14.5361 | 14.5536 | 14.5357 | 14.5464 | 451752.0 |
| 2011-10-27 08:15:00 | AAPL | Stock | 14.5429 | 14.5532 | 14.5393 | 14.5489 | 332752.0 |
| 2011-10-27 08:20:00 | AAPL | Stock | 14.5496 | 14.5568 | 14.5414 | 14.5464 | 208628.0 |
| 2011-10-27 08:25:00 | AAPL | Stock | 14.5464 | 14.5536 | 14.5429 | 14.5464 | 217364.0 |
| 2011-10-27 08:30:00 | AAPL | Stock | 14.5536 | 14.5761 | 14.5432 | 14.5571 | 586740.0 |
| 2011-10-27 08:35:00 | AAPL | Stock | 14.5589 | 14.5604 | 14.5464 | 14.5536 | 214732.0 |
| 2011-10-27 08:40:00 | AAPL | Stock | 14.5571 | 14.5646 | 14.5511 | 14.5511 | 269584.0 |
| 2011-10-27 08:45:00 | AAPL | Stock | 14.5536 | 14.5536 | 14.5496 | 14.5529 | 181496.0 |
| 2011-10-27 08:50:00 | AAPL | Stock | 14.5518 | 14.5589 | 14.5518 | 14.5536 | 148344.0 |
| 2011-10-27 08:55:00 | AAPL | Stock | 14.5539 | 14.5661 | 14.5504 | 14.5575 | 227472.0 |
| 2011-10-27 09:00:00 | AAPL | Stock | 14.5571 | 14.5639 | 14.5546 | 14.5625 | 117096.0 |
| 2011-10-27 09:05:00 | AAPL | Stock | 14.5639 | 14.57 | 14.5611 | 14.57 | 338912.0 |
| 2011-10-27 09:10:00 | AAPL | Stock | 14.5711 | 14.5886 | 14.5707 | 14.5836 | 642964.0 |
> showing 50 of 359,882 rows — these rows as CSV