PREVIEW / stock_5min / 2013-02-26
file: by_date/stock_5min/2013/2013-02-26.parquet size: 4.9 MB rows: 329,356 symbols: 3,475
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 |
|---|---|---|---|---|---|---|---|
| 2013-02-26 04:00:00 | AAPL | Stock | 15.8571 | 15.8571 | 15.8571 | 15.8571 | 2800.0 |
| 2013-02-26 04:55:00 | AAPL | Stock | 15.8714 | 15.8714 | 15.8714 | 15.8714 | 25060.0 |
| 2013-02-26 05:35:00 | AAPL | Stock | 15.8393 | 15.8393 | 15.8393 | 15.8393 | 2800.0 |
| 2013-02-26 05:40:00 | AAPL | Stock | 15.8304 | 15.8304 | 15.8304 | 15.8304 | 2800.0 |
| 2013-02-26 05:55:00 | AAPL | Stock | 15.8321 | 15.8321 | 15.8321 | 15.8321 | 2800.0 |
| 2013-02-26 06:40:00 | AAPL | Stock | 15.8446 | 15.8446 | 15.8446 | 15.8446 | 2800.0 |
| 2013-02-26 06:45:00 | AAPL | Stock | 15.8568 | 15.8568 | 15.8568 | 15.8568 | 2800.0 |
| 2013-02-26 07:00:00 | AAPL | Stock | 15.875 | 15.875 | 15.875 | 15.875 | 2800.0 |
| 2013-02-26 07:05:00 | AAPL | Stock | 15.8814 | 15.8929 | 15.8661 | 15.8929 | 42000.0 |
| 2013-02-26 07:10:00 | AAPL | Stock | 15.8929 | 15.8932 | 15.8821 | 15.8821 | 49280.0 |
| 2013-02-26 07:15:00 | AAPL | Stock | 15.8661 | 15.8661 | 15.8661 | 15.8661 | 10360.0 |
| 2013-02-26 07:20:00 | AAPL | Stock | 15.8661 | 15.8661 | 15.8614 | 15.8614 | 10920.0 |
| 2013-02-26 07:25:00 | AAPL | Stock | 15.8746 | 15.875 | 15.8746 | 15.875 | 28000.0 |
| 2013-02-26 07:30:00 | AAPL | Stock | 15.8714 | 15.8929 | 15.8714 | 15.8911 | 76048.0 |
| 2013-02-26 07:35:00 | AAPL | Stock | 15.875 | 15.875 | 15.875 | 15.875 | 2800.0 |
| 2013-02-26 07:40:00 | AAPL | Stock | 15.875 | 15.8907 | 15.875 | 15.8907 | 30464.0 |
| 2013-02-26 07:45:00 | AAPL | Stock | 15.8839 | 15.8839 | 15.875 | 15.8839 | 41916.0 |
| 2013-02-26 07:50:00 | AAPL | Stock | 15.8768 | 15.8768 | 15.8696 | 15.8696 | 11200.0 |
| 2013-02-26 07:55:00 | AAPL | Stock | 15.8732 | 15.8746 | 15.8636 | 15.8661 | 22568.0 |
| 2013-02-26 08:00:00 | AAPL | Stock | 15.8679 | 15.8907 | 15.8071 | 15.8732 | 199052.0 |
| 2013-02-26 08:05:00 | AAPL | Stock | 15.8811 | 15.8829 | 15.8625 | 15.8675 | 147840.0 |
| 2013-02-26 08:10:00 | AAPL | Stock | 15.8636 | 15.8668 | 15.8532 | 15.8557 | 166796.0 |
| 2013-02-26 08:15:00 | AAPL | Stock | 15.8571 | 15.8639 | 15.8554 | 15.8571 | 46760.0 |
| 2013-02-26 08:20:00 | AAPL | Stock | 15.8625 | 15.8646 | 15.8543 | 15.8543 | 104160.0 |
| 2013-02-26 08:25:00 | AAPL | Stock | 15.8539 | 15.8604 | 15.85 | 15.8571 | 60620.0 |
| 2013-02-26 08:30:00 | AAPL | Stock | 15.855 | 15.8586 | 15.85 | 15.8586 | 72576.0 |
| 2013-02-26 08:35:00 | AAPL | Stock | 15.8575 | 15.8668 | 15.8575 | 15.8668 | 64400.0 |
| 2013-02-26 08:40:00 | AAPL | Stock | 15.8657 | 15.8671 | 15.8632 | 15.8671 | 14000.0 |
| 2013-02-26 08:45:00 | AAPL | Stock | 15.8643 | 15.8657 | 15.8539 | 15.8543 | 174328.0 |
| 2013-02-26 08:50:00 | AAPL | Stock | 15.8571 | 15.8571 | 15.8411 | 15.85 | 194292.0 |
| 2013-02-26 08:55:00 | AAPL | Stock | 15.8564 | 15.8629 | 15.8482 | 15.8629 | 158480.0 |
| 2013-02-26 09:00:00 | AAPL | Stock | 15.8671 | 15.8671 | 15.85 | 15.8568 | 207592.0 |
| 2013-02-26 09:05:00 | AAPL | Stock | 15.8643 | 15.88 | 15.8643 | 15.88 | 111076.0 |
| 2013-02-26 09:10:00 | AAPL | Stock | 15.8807 | 15.8821 | 15.8718 | 15.8729 | 147000.0 |
| 2013-02-26 09:15:00 | AAPL | Stock | 15.8732 | 15.8829 | 15.8661 | 15.8661 | 317632.0 |
| 2013-02-26 09:20:00 | AAPL | Stock | 15.8696 | 15.8768 | 15.8679 | 15.8686 | 95200.0 |
| 2013-02-26 09:25:00 | AAPL | Stock | 15.8729 | 15.88 | 15.8411 | 15.8411 | 223664.0 |
| 2013-02-26 09:30:00 | AAPL | Stock | 15.8414 | 15.8684 | 15.7957 | 15.8393 | 14636692.0 |
| 2013-02-26 09:35:00 | AAPL | Stock | 15.8379 | 15.8821 | 15.8218 | 15.8301 | 6650504.0 |
| 2013-02-26 09:40:00 | AAPL | Stock | 15.8236 | 15.8354 | 15.7536 | 15.7536 | 10228652.0 |
| 2013-02-26 09:45:00 | AAPL | Stock | 15.7557 | 15.76 | 15.7271 | 15.7414 | 10407712.0 |
| 2013-02-26 09:50:00 | AAPL | Stock | 15.7396 | 15.7821 | 15.7054 | 15.7605 | 13171816.0 |
| 2013-02-26 09:55:00 | AAPL | Stock | 15.7636 | 15.8271 | 15.7625 | 15.8268 | 10074232.0 |
| 2013-02-26 10:00:00 | AAPL | Stock | 15.8225 | 15.8604 | 15.8071 | 15.8289 | 9573340.0 |
| 2013-02-26 10:05:00 | AAPL | Stock | 15.83 | 15.8321 | 15.7296 | 15.7339 | 8705984.0 |
| 2013-02-26 10:10:00 | AAPL | Stock | 15.7343 | 15.7724 | 15.7232 | 15.7545 | 6288772.0 |
| 2013-02-26 10:15:00 | AAPL | Stock | 15.7558 | 15.7729 | 15.7429 | 15.7541 | 5568024.0 |
| 2013-02-26 10:20:00 | AAPL | Stock | 15.7521 | 15.7554 | 15.6929 | 15.7164 | 11822748.0 |
| 2013-02-26 10:25:00 | AAPL | Stock | 15.7125 | 15.7368 | 15.6896 | 15.6896 | 6182204.0 |
| 2013-02-26 10:30:00 | AAPL | Stock | 15.6896 | 15.7281 | 15.6732 | 15.6861 | 7216076.0 |
> showing 50 of 329,356 rows — these rows as CSV