PREVIEW / stock_5min / 2012-12-07
file: by_date/stock_5min/2012/2012-12-07.parquet size: 4.7 MB rows: 315,971 symbols: 3,481
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 |
|---|---|---|---|---|---|---|---|
| 2012-12-07 04:00:00 | AAPL | Stock | 19.5736 | 19.5736 | 19.5736 | 19.5736 | 2800.0 |
| 2012-12-07 04:05:00 | AAPL | Stock | 19.5739 | 19.5739 | 19.5739 | 19.5739 | 2800.0 |
| 2012-12-07 04:10:00 | AAPL | Stock | 19.5739 | 19.5739 | 19.5739 | 19.5739 | 2800.0 |
| 2012-12-07 04:15:00 | AAPL | Stock | 19.5739 | 19.5739 | 19.5739 | 19.5739 | 2800.0 |
| 2012-12-07 04:30:00 | AAPL | Stock | 19.5829 | 19.5829 | 19.5829 | 19.5829 | 2800.0 |
| 2012-12-07 04:45:00 | AAPL | Stock | 19.6 | 19.6 | 19.6 | 19.6 | 2800.0 |
| 2012-12-07 04:55:00 | AAPL | Stock | 19.6 | 19.6 | 19.6 | 19.6 | 2800.0 |
| 2012-12-07 05:25:00 | AAPL | Stock | 19.5743 | 19.5743 | 19.5743 | 19.5743 | 2800.0 |
| 2012-12-07 05:30:00 | AAPL | Stock | 19.5557 | 19.5557 | 19.5507 | 19.5507 | 8400.0 |
| 2012-12-07 05:35:00 | AAPL | Stock | 19.54 | 19.54 | 19.54 | 19.54 | 2800.0 |
| 2012-12-07 05:40:00 | AAPL | Stock | 19.5361 | 19.5361 | 19.5361 | 19.5361 | 8400.0 |
| 2012-12-07 05:55:00 | AAPL | Stock | 19.5536 | 19.5536 | 19.5396 | 19.5396 | 9632.0 |
| 2012-12-07 06:05:00 | AAPL | Stock | 19.5393 | 19.5393 | 19.5393 | 19.5393 | 5600.0 |
| 2012-12-07 06:10:00 | AAPL | Stock | 19.5625 | 19.5625 | 19.5429 | 19.5429 | 5600.0 |
| 2012-12-07 06:20:00 | AAPL | Stock | 19.5407 | 19.5407 | 19.5407 | 19.5407 | 2800.0 |
| 2012-12-07 06:30:00 | AAPL | Stock | 19.5357 | 19.5357 | 19.5357 | 19.5357 | 6188.0 |
| 2012-12-07 06:50:00 | AAPL | Stock | 19.5496 | 19.5496 | 19.5496 | 19.5496 | 2800.0 |
| 2012-12-07 06:55:00 | AAPL | Stock | 19.5396 | 19.5396 | 19.5357 | 19.5357 | 14000.0 |
| 2012-12-07 07:00:00 | AAPL | Stock | 19.5568 | 19.5568 | 19.5568 | 19.5568 | 2800.0 |
| 2012-12-07 07:10:00 | AAPL | Stock | 19.5536 | 19.6214 | 19.5536 | 19.6071 | 61600.0 |
| 2012-12-07 07:15:00 | AAPL | Stock | 19.5736 | 19.5886 | 19.5736 | 19.5886 | 11200.0 |
| 2012-12-07 07:20:00 | AAPL | Stock | 19.6054 | 19.625 | 19.6054 | 19.6071 | 57680.0 |
| 2012-12-07 07:25:00 | AAPL | Stock | 19.6086 | 19.6304 | 19.6086 | 19.6304 | 120092.0 |
| 2012-12-07 07:30:00 | AAPL | Stock | 19.6286 | 19.6429 | 19.6161 | 19.6429 | 97524.0 |
| 2012-12-07 07:35:00 | AAPL | Stock | 19.6536 | 19.6782 | 19.6429 | 19.6782 | 63140.0 |
| 2012-12-07 07:40:00 | AAPL | Stock | 19.6871 | 19.6871 | 19.6504 | 19.6504 | 61628.0 |
| 2012-12-07 07:45:00 | AAPL | Stock | 19.6446 | 19.6504 | 19.6089 | 19.6146 | 123760.0 |
| 2012-12-07 07:50:00 | AAPL | Stock | 19.6246 | 19.6318 | 19.5982 | 19.5982 | 272972.0 |
| 2012-12-07 07:55:00 | AAPL | Stock | 19.6036 | 19.6036 | 19.5943 | 19.5943 | 5600.0 |
| 2012-12-07 08:00:00 | AAPL | Stock | 19.6068 | 19.6254 | 19.5186 | 19.5186 | 477344.0 |
| 2012-12-07 08:05:00 | AAPL | Stock | 19.5182 | 19.5343 | 19.3929 | 19.3929 | 576268.0 |
| 2012-12-07 08:10:00 | AAPL | Stock | 19.4107 | 19.4821 | 19.4075 | 19.4821 | 325948.0 |
| 2012-12-07 08:15:00 | AAPL | Stock | 19.4721 | 19.5011 | 19.4643 | 19.5011 | 502544.0 |
| 2012-12-07 08:20:00 | AAPL | Stock | 19.5071 | 19.5464 | 19.4929 | 19.5168 | 657244.0 |
| 2012-12-07 08:25:00 | AAPL | Stock | 19.5179 | 19.5536 | 19.51 | 19.5357 | 358484.0 |
| 2012-12-07 08:30:00 | AAPL | Stock | 19.5339 | 19.6375 | 19.5321 | 19.6093 | 1958796.0 |
| 2012-12-07 08:35:00 | AAPL | Stock | 19.6071 | 19.6743 | 19.6071 | 19.6671 | 774340.0 |
| 2012-12-07 08:40:00 | AAPL | Stock | 19.6682 | 19.7411 | 19.6618 | 19.7179 | 2101848.0 |
| 2012-12-07 08:45:00 | AAPL | Stock | 19.7186 | 19.7404 | 19.6875 | 19.7218 | 1299676.0 |
| 2012-12-07 08:50:00 | AAPL | Stock | 19.7321 | 19.7321 | 19.6482 | 19.6625 | 1302112.0 |
| 2012-12-07 08:55:00 | AAPL | Stock | 19.6675 | 19.6907 | 19.6507 | 19.6907 | 810516.0 |
| 2012-12-07 09:00:00 | AAPL | Stock | 19.6857 | 19.73 | 19.6857 | 19.7046 | 612724.0 |
| 2012-12-07 09:05:00 | AAPL | Stock | 19.705 | 19.7136 | 19.6836 | 19.6836 | 461944.0 |
| 2012-12-07 09:10:00 | AAPL | Stock | 19.6932 | 19.6996 | 19.6714 | 19.6989 | 138040.0 |
| 2012-12-07 09:15:00 | AAPL | Stock | 19.6929 | 19.7157 | 19.675 | 19.7082 | 371560.0 |
| 2012-12-07 09:20:00 | AAPL | Stock | 19.7075 | 19.7418 | 19.7014 | 19.7418 | 564872.0 |
| 2012-12-07 09:25:00 | AAPL | Stock | 19.7418 | 19.7818 | 19.7418 | 19.7679 | 1789228.0 |
| 2012-12-07 09:30:00 | AAPL | Stock | 19.7654 | 19.8286 | 19.6717 | 19.6868 | 34280652.0 |
| 2012-12-07 09:35:00 | AAPL | Stock | 19.6907 | 19.7639 | 19.6582 | 19.7304 | 15327536.0 |
| 2012-12-07 09:40:00 | AAPL | Stock | 19.7271 | 19.7477 | 19.6043 | 19.6864 | 15516648.0 |
> showing 50 of 315,971 rows — these rows as CSV