PREVIEW / stock_5min / 2014-02-25
file: by_date/stock_5min/2014/2014-02-25.parquet size: 5.4 MB rows: 355,923 symbols: 3,528
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 |
|---|---|---|---|---|---|---|---|
| 2014-02-25 04:00:00 | AAPL | Stock | 18.8429 | 18.8429 | 18.6361 | 18.8232 | 8400.0 |
| 2014-02-25 04:05:00 | AAPL | Stock | 18.8321 | 18.8321 | 18.8321 | 18.8321 | 2800.0 |
| 2014-02-25 04:35:00 | AAPL | Stock | 18.8214 | 18.8214 | 18.8036 | 18.8036 | 8400.0 |
| 2014-02-25 05:40:00 | AAPL | Stock | 18.8204 | 18.8204 | 18.8204 | 18.8204 | 11200.0 |
| 2014-02-25 06:50:00 | AAPL | Stock | 18.8643 | 18.8661 | 18.8643 | 18.8661 | 14000.0 |
| 2014-02-25 07:05:00 | AAPL | Stock | 18.8661 | 18.8925 | 18.8571 | 18.8571 | 30800.0 |
| 2014-02-25 07:20:00 | AAPL | Stock | 18.8696 | 18.8696 | 18.8411 | 18.8411 | 28000.0 |
| 2014-02-25 07:30:00 | AAPL | Stock | 18.8429 | 18.8429 | 18.8429 | 18.8429 | 6776.0 |
| 2014-02-25 07:50:00 | AAPL | Stock | 18.8571 | 18.8621 | 18.8571 | 18.8621 | 8400.0 |
| 2014-02-25 08:00:00 | AAPL | Stock | 18.8411 | 18.8889 | 18.8411 | 18.8889 | 36820.0 |
| 2014-02-25 08:05:00 | AAPL | Stock | 18.8868 | 18.8868 | 18.8868 | 18.8868 | 3500.0 |
| 2014-02-25 08:10:00 | AAPL | Stock | 18.8875 | 18.8875 | 18.8875 | 18.8875 | 2800.0 |
| 2014-02-25 08:15:00 | AAPL | Stock | 18.8743 | 18.8871 | 18.8743 | 18.8846 | 19600.0 |
| 2014-02-25 08:20:00 | AAPL | Stock | 18.8771 | 18.8839 | 18.8771 | 18.8839 | 58800.0 |
| 2014-02-25 08:25:00 | AAPL | Stock | 18.875 | 18.8886 | 18.8607 | 18.8786 | 84000.0 |
| 2014-02-25 08:30:00 | AAPL | Stock | 18.8825 | 18.8857 | 18.8821 | 18.8857 | 14476.0 |
| 2014-02-25 08:35:00 | AAPL | Stock | 18.8875 | 18.8875 | 18.8746 | 18.8818 | 20104.0 |
| 2014-02-25 08:40:00 | AAPL | Stock | 18.8675 | 18.8875 | 18.8621 | 18.8843 | 58800.0 |
| 2014-02-25 08:45:00 | AAPL | Stock | 18.8843 | 18.8882 | 18.8843 | 18.8882 | 61152.0 |
| 2014-02-25 08:50:00 | AAPL | Stock | 18.8846 | 18.8854 | 18.875 | 18.875 | 33600.0 |
| 2014-02-25 08:55:00 | AAPL | Stock | 18.8807 | 18.8839 | 18.8807 | 18.8839 | 8400.0 |
| 2014-02-25 09:00:00 | AAPL | Stock | 18.8836 | 18.8839 | 18.8836 | 18.8839 | 17920.0 |
| 2014-02-25 09:05:00 | AAPL | Stock | 18.8889 | 18.8993 | 18.8889 | 18.8993 | 103740.0 |
| 2014-02-25 09:10:00 | AAPL | Stock | 18.91 | 18.9107 | 18.8946 | 18.8946 | 316820.0 |
| 2014-02-25 09:15:00 | AAPL | Stock | 18.8993 | 18.91 | 18.8929 | 18.8929 | 127204.0 |
| 2014-02-25 09:20:00 | AAPL | Stock | 18.9068 | 18.9154 | 18.9068 | 18.9154 | 140168.0 |
| 2014-02-25 09:25:00 | AAPL | Stock | 18.9143 | 18.9286 | 18.8932 | 18.8961 | 654528.0 |
| 2014-02-25 09:30:00 | AAPL | Stock | 18.9064 | 18.913 | 18.8493 | 18.8607 | 9916956.0 |
| 2014-02-25 09:35:00 | AAPL | Stock | 18.8607 | 18.8607 | 18.8079 | 18.8218 | 6194412.0 |
| 2014-02-25 09:40:00 | AAPL | Stock | 18.8304 | 18.8907 | 18.8218 | 18.8874 | 5411364.0 |
| 2014-02-25 09:45:00 | AAPL | Stock | 18.8839 | 18.8846 | 18.8214 | 18.8311 | 2868964.0 |
| 2014-02-25 09:50:00 | AAPL | Stock | 18.8304 | 18.8304 | 18.7857 | 18.7928 | 4089288.0 |
| 2014-02-25 09:55:00 | AAPL | Stock | 18.7918 | 18.7936 | 18.7646 | 18.7752 | 3495044.0 |
| 2014-02-25 10:00:00 | AAPL | Stock | 18.7771 | 18.7829 | 18.7321 | 18.7396 | 4521720.0 |
| 2014-02-25 10:05:00 | AAPL | Stock | 18.7357 | 18.7771 | 18.7239 | 18.7636 | 3939684.0 |
| 2014-02-25 10:10:00 | AAPL | Stock | 18.7643 | 18.7893 | 18.7389 | 18.7482 | 3201912.0 |
| 2014-02-25 10:15:00 | AAPL | Stock | 18.7482 | 18.7504 | 18.7154 | 18.7232 | 4422012.0 |
| 2014-02-25 10:20:00 | AAPL | Stock | 18.725 | 18.7604 | 18.7168 | 18.7593 | 3830596.0 |
| 2014-02-25 10:25:00 | AAPL | Stock | 18.7604 | 18.7867 | 18.75 | 18.775 | 2964164.0 |
| 2014-02-25 10:30:00 | AAPL | Stock | 18.7781 | 18.7998 | 18.7504 | 18.7696 | 2257724.0 |
| 2014-02-25 10:35:00 | AAPL | Stock | 18.7685 | 18.7811 | 18.7443 | 18.7679 | 1420244.0 |
| 2014-02-25 10:40:00 | AAPL | Stock | 18.7659 | 18.7679 | 18.7461 | 18.7582 | 1555960.0 |
| 2014-02-25 10:45:00 | AAPL | Stock | 18.763 | 18.7661 | 18.7268 | 18.7532 | 2536548.0 |
| 2014-02-25 10:50:00 | AAPL | Stock | 18.7532 | 18.7579 | 18.7268 | 18.7268 | 1351028.0 |
| 2014-02-25 10:55:00 | AAPL | Stock | 18.7289 | 18.7321 | 18.6964 | 18.7107 | 3689476.0 |
| 2014-02-25 11:00:00 | AAPL | Stock | 18.7136 | 18.7289 | 18.6982 | 18.7275 | 4539864.0 |
| 2014-02-25 11:05:00 | AAPL | Stock | 18.7296 | 18.7554 | 18.7225 | 18.7529 | 2300900.0 |
| 2014-02-25 11:10:00 | AAPL | Stock | 18.7514 | 18.7839 | 18.7514 | 18.7768 | 2845892.0 |
| 2014-02-25 11:15:00 | AAPL | Stock | 18.7729 | 18.7921 | 18.7618 | 18.7822 | 1488564.0 |
| 2014-02-25 11:20:00 | AAPL | Stock | 18.7821 | 18.7857 | 18.7682 | 18.7754 | 1601544.0 |
> showing 50 of 355,923 rows — these rows as CSV