PREVIEW / stock_5min / 2011-12-01
file: by_date/stock_5min/2011/2011-12-01.parquet size: 4.8 MB rows: 326,970 symbols: 3,533
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-12-01 04:10:00 | AAPL | Stock | 13.5957 | 13.5957 | 13.5957 | 13.5957 | 5600.0 |
| 2011-12-01 04:25:00 | AAPL | Stock | 13.5954 | 13.5954 | 13.5954 | 13.5954 | 8400.0 |
| 2011-12-01 04:30:00 | AAPL | Stock | 13.6 | 13.6 | 13.6 | 13.6 | 2800.0 |
| 2011-12-01 04:35:00 | AAPL | Stock | 13.6 | 13.6 | 13.6 | 13.6 | 2800.0 |
| 2011-12-01 04:40:00 | AAPL | Stock | 13.6 | 13.6 | 13.6 | 13.6 | 2800.0 |
| 2011-12-01 04:45:00 | AAPL | Stock | 13.6 | 13.6 | 13.6 | 13.6 | 2800.0 |
| 2011-12-01 05:15:00 | AAPL | Stock | 13.625 | 13.625 | 13.625 | 13.625 | 5600.0 |
| 2011-12-01 05:25:00 | AAPL | Stock | 13.6321 | 13.6321 | 13.6321 | 13.6321 | 5600.0 |
| 2011-12-01 05:35:00 | AAPL | Stock | 13.6429 | 13.6429 | 13.6429 | 13.6429 | 10640.0 |
| 2011-12-01 06:55:00 | AAPL | Stock | 13.6379 | 13.6429 | 13.6379 | 13.6429 | 33740.0 |
| 2011-12-01 07:00:00 | AAPL | Stock | 13.65 | 13.6889 | 13.65 | 13.6786 | 42000.0 |
| 2011-12-01 07:05:00 | AAPL | Stock | 13.6882 | 13.6996 | 13.6882 | 13.6996 | 28000.0 |
| 2011-12-01 07:10:00 | AAPL | Stock | 13.6954 | 13.6954 | 13.6893 | 13.6893 | 22400.0 |
| 2011-12-01 07:15:00 | AAPL | Stock | 13.6875 | 13.6879 | 13.6875 | 13.6875 | 58800.0 |
| 2011-12-01 07:20:00 | AAPL | Stock | 13.6875 | 13.6875 | 13.6875 | 13.6875 | 2800.0 |
| 2011-12-01 07:25:00 | AAPL | Stock | 13.6957 | 13.6957 | 13.6846 | 13.6846 | 30800.0 |
| 2011-12-01 07:30:00 | AAPL | Stock | 13.6957 | 13.7 | 13.6957 | 13.7 | 96320.0 |
| 2011-12-01 07:35:00 | AAPL | Stock | 13.7071 | 13.7107 | 13.7071 | 13.7107 | 32480.0 |
| 2011-12-01 07:40:00 | AAPL | Stock | 13.7104 | 13.7104 | 13.7 | 13.7 | 14000.0 |
| 2011-12-01 07:45:00 | AAPL | Stock | 13.7054 | 13.7107 | 13.7054 | 13.7107 | 25200.0 |
| 2011-12-01 07:50:00 | AAPL | Stock | 13.7107 | 13.7107 | 13.6964 | 13.6964 | 100100.0 |
| 2011-12-01 07:55:00 | AAPL | Stock | 13.6964 | 13.7075 | 13.6964 | 13.7054 | 106792.0 |
| 2011-12-01 08:00:00 | AAPL | Stock | 13.71 | 13.71 | 13.65 | 13.7032 | 76020.0 |
| 2011-12-01 08:05:00 | AAPL | Stock | 13.7021 | 13.7021 | 13.6786 | 13.6786 | 191408.0 |
| 2011-12-01 08:10:00 | AAPL | Stock | 13.675 | 13.6768 | 13.6607 | 13.6607 | 136920.0 |
| 2011-12-01 08:15:00 | AAPL | Stock | 13.6625 | 13.6925 | 13.6521 | 13.6925 | 140672.0 |
| 2011-12-01 08:20:00 | AAPL | Stock | 13.6782 | 13.6857 | 13.6782 | 13.6786 | 50260.0 |
| 2011-12-01 08:25:00 | AAPL | Stock | 13.675 | 13.68 | 13.6693 | 13.6786 | 102956.0 |
| 2011-12-01 08:30:00 | AAPL | Stock | 13.6714 | 13.6804 | 13.6607 | 13.6725 | 195300.0 |
| 2011-12-01 08:35:00 | AAPL | Stock | 13.6661 | 13.6732 | 13.6546 | 13.655 | 65520.0 |
| 2011-12-01 08:40:00 | AAPL | Stock | 13.6554 | 13.6571 | 13.65 | 13.65 | 105560.0 |
| 2011-12-01 08:45:00 | AAPL | Stock | 13.6518 | 13.6518 | 13.6304 | 13.6357 | 330736.0 |
| 2011-12-01 08:50:00 | AAPL | Stock | 13.6325 | 13.6393 | 13.6286 | 13.6321 | 147000.0 |
| 2011-12-01 08:55:00 | AAPL | Stock | 13.6339 | 13.6411 | 13.6293 | 13.6389 | 99260.0 |
| 2011-12-01 09:00:00 | AAPL | Stock | 13.6361 | 13.6411 | 13.6343 | 13.6407 | 53200.0 |
| 2011-12-01 09:05:00 | AAPL | Stock | 13.6429 | 13.65 | 13.6429 | 13.65 | 14000.0 |
| 2011-12-01 09:10:00 | AAPL | Stock | 13.65 | 13.6571 | 13.65 | 13.6571 | 8400.0 |
| 2011-12-01 09:15:00 | AAPL | Stock | 13.65 | 13.6504 | 13.6429 | 13.6504 | 173292.0 |
| 2011-12-01 09:20:00 | AAPL | Stock | 13.6536 | 13.6604 | 13.6443 | 13.6443 | 122444.0 |
| 2011-12-01 09:25:00 | AAPL | Stock | 13.645 | 13.6682 | 13.6446 | 13.6664 | 338464.0 |
| 2011-12-01 09:30:00 | AAPL | Stock | 13.6579 | 13.6743 | 13.5989 | 13.6118 | 11006660.0 |
| 2011-12-01 09:35:00 | AAPL | Stock | 13.6107 | 13.6589 | 13.5982 | 13.6525 | 7110516.0 |
| 2011-12-01 09:40:00 | AAPL | Stock | 13.6521 | 13.6675 | 13.6211 | 13.6443 | 8419964.0 |
| 2011-12-01 09:45:00 | AAPL | Stock | 13.645 | 13.6675 | 13.6275 | 13.6607 | 6885172.0 |
| 2011-12-01 09:50:00 | AAPL | Stock | 13.6571 | 13.7107 | 13.6554 | 13.7068 | 8177232.0 |
| 2011-12-01 09:55:00 | AAPL | Stock | 13.7062 | 13.7479 | 13.7043 | 13.7454 | 9493904.0 |
| 2011-12-01 10:00:00 | AAPL | Stock | 13.7425 | 13.7961 | 13.7364 | 13.7739 | 18986128.0 |
| 2011-12-01 10:05:00 | AAPL | Stock | 13.7743 | 13.7796 | 13.7582 | 13.7654 | 6387976.0 |
| 2011-12-01 10:10:00 | AAPL | Stock | 13.7661 | 13.7729 | 13.7554 | 13.7614 | 3912776.0 |
| 2011-12-01 10:15:00 | AAPL | Stock | 13.7611 | 13.7804 | 13.7482 | 13.7511 | 6166776.0 |
> showing 50 of 326,970 rows — these rows as CSV