PREVIEW / stock_5min / 2012-04-10
file: by_date/stock_5min/2012/2012-04-10.parquet size: 5.1 MB rows: 344,349 symbols: 3,511
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-04-10 04:00:00 | AAPL | Stock | 22.7779 | 22.8221 | 22.7779 | 22.8221 | 33460.0 |
| 2012-04-10 04:05:00 | AAPL | Stock | 22.8368 | 22.8368 | 22.8368 | 22.8368 | 11200.0 |
| 2012-04-10 04:10:00 | AAPL | Stock | 22.8214 | 22.8214 | 22.8036 | 22.8036 | 47600.0 |
| 2012-04-10 04:15:00 | AAPL | Stock | 22.7932 | 22.7932 | 22.7857 | 22.7857 | 44800.0 |
| 2012-04-10 04:20:00 | AAPL | Stock | 22.7857 | 22.7857 | 22.7857 | 22.7857 | 61600.0 |
| 2012-04-10 04:25:00 | AAPL | Stock | 22.7861 | 22.7861 | 22.7821 | 22.7857 | 34048.0 |
| 2012-04-10 04:30:00 | AAPL | Stock | 22.7989 | 22.7989 | 22.7857 | 22.7857 | 19880.0 |
| 2012-04-10 04:35:00 | AAPL | Stock | 22.7993 | 22.7993 | 22.7993 | 22.7993 | 16800.0 |
| 2012-04-10 04:40:00 | AAPL | Stock | 22.7864 | 22.8007 | 22.7857 | 22.7857 | 46536.0 |
| 2012-04-10 04:45:00 | AAPL | Stock | 22.7857 | 22.7857 | 22.7804 | 22.7804 | 9688.0 |
| 2012-04-10 04:50:00 | AAPL | Stock | 22.7821 | 22.7857 | 22.7821 | 22.7857 | 16800.0 |
| 2012-04-10 05:00:00 | AAPL | Stock | 22.7768 | 22.7768 | 22.7768 | 22.7768 | 8400.0 |
| 2012-04-10 05:05:00 | AAPL | Stock | 22.7768 | 22.7768 | 22.7768 | 22.7768 | 4900.0 |
| 2012-04-10 05:15:00 | AAPL | Stock | 22.7682 | 22.7682 | 22.7679 | 22.7679 | 7980.0 |
| 2012-04-10 05:20:00 | AAPL | Stock | 22.7718 | 22.7718 | 22.7718 | 22.7718 | 8400.0 |
| 2012-04-10 05:25:00 | AAPL | Stock | 22.7857 | 22.7857 | 22.7857 | 22.7857 | 4200.0 |
| 2012-04-10 05:40:00 | AAPL | Stock | 22.7857 | 22.7857 | 22.7857 | 22.7857 | 13160.0 |
| 2012-04-10 05:45:00 | AAPL | Stock | 22.8032 | 22.8036 | 22.8032 | 22.8036 | 33600.0 |
| 2012-04-10 05:50:00 | AAPL | Stock | 22.8211 | 22.8214 | 22.8211 | 22.8214 | 64400.0 |
| 2012-04-10 06:05:00 | AAPL | Stock | 22.8125 | 22.8143 | 22.8125 | 22.8143 | 9240.0 |
| 2012-04-10 06:20:00 | AAPL | Stock | 22.8093 | 22.8093 | 22.8093 | 22.8093 | 2800.0 |
| 2012-04-10 06:25:00 | AAPL | Stock | 22.8143 | 22.8214 | 22.8143 | 22.8214 | 11200.0 |
| 2012-04-10 06:35:00 | AAPL | Stock | 22.8214 | 22.8521 | 22.8214 | 22.8521 | 70000.0 |
| 2012-04-10 06:40:00 | AAPL | Stock | 22.8518 | 22.8564 | 22.8518 | 22.8518 | 19600.0 |
| 2012-04-10 06:45:00 | AAPL | Stock | 22.8543 | 22.8543 | 22.8543 | 22.8543 | 16800.0 |
| 2012-04-10 06:50:00 | AAPL | Stock | 22.8518 | 22.8571 | 22.8518 | 22.8518 | 28308.0 |
| 2012-04-10 06:55:00 | AAPL | Stock | 22.8518 | 22.8518 | 22.8518 | 22.8518 | 5600.0 |
| 2012-04-10 07:00:00 | AAPL | Stock | 22.85 | 22.8607 | 22.8411 | 22.8607 | 173656.0 |
| 2012-04-10 07:05:00 | AAPL | Stock | 22.8743 | 22.8743 | 22.8439 | 22.8571 | 131208.0 |
| 2012-04-10 07:10:00 | AAPL | Stock | 22.8604 | 22.8643 | 22.8507 | 22.8625 | 97720.0 |
| 2012-04-10 07:15:00 | AAPL | Stock | 22.8571 | 22.8571 | 22.8518 | 22.8525 | 21700.0 |
| 2012-04-10 07:20:00 | AAPL | Stock | 22.8489 | 22.8489 | 22.8143 | 22.8143 | 133000.0 |
| 2012-04-10 07:25:00 | AAPL | Stock | 22.8179 | 22.8229 | 22.8125 | 22.8125 | 39732.0 |
| 2012-04-10 07:30:00 | AAPL | Stock | 22.8214 | 22.8214 | 22.7857 | 22.7857 | 129724.0 |
| 2012-04-10 07:35:00 | AAPL | Stock | 22.7857 | 22.8071 | 22.775 | 22.8071 | 80388.0 |
| 2012-04-10 07:40:00 | AAPL | Stock | 22.8068 | 22.8107 | 22.7946 | 22.8107 | 63476.0 |
| 2012-04-10 07:45:00 | AAPL | Stock | 22.8136 | 22.8143 | 22.8036 | 22.8139 | 78540.0 |
| 2012-04-10 07:50:00 | AAPL | Stock | 22.8161 | 22.8175 | 22.8161 | 22.8175 | 5600.0 |
| 2012-04-10 07:55:00 | AAPL | Stock | 22.8168 | 22.8236 | 22.8075 | 22.8214 | 112420.0 |
| 2012-04-10 08:00:00 | AAPL | Stock | 22.8286 | 22.8571 | 22.8161 | 22.8407 | 1097320.0 |
| 2012-04-10 08:05:00 | AAPL | Stock | 22.8464 | 22.8625 | 22.8396 | 22.8607 | 828100.0 |
| 2012-04-10 08:10:00 | AAPL | Stock | 22.8546 | 22.8679 | 22.8504 | 22.8632 | 299796.0 |
| 2012-04-10 08:15:00 | AAPL | Stock | 22.8679 | 22.8679 | 22.7225 | 22.8564 | 409668.0 |
| 2012-04-10 08:20:00 | AAPL | Stock | 22.8571 | 22.8571 | 22.8321 | 22.8357 | 449036.0 |
| 2012-04-10 08:25:00 | AAPL | Stock | 22.8389 | 22.87 | 22.8371 | 22.8696 | 380520.0 |
| 2012-04-10 08:30:00 | AAPL | Stock | 22.8696 | 22.8893 | 22.8679 | 22.8796 | 573496.0 |
| 2012-04-10 08:35:00 | AAPL | Stock | 22.88 | 22.8814 | 22.8704 | 22.8814 | 333760.0 |
| 2012-04-10 08:40:00 | AAPL | Stock | 22.8814 | 22.8889 | 22.8682 | 22.8732 | 453908.0 |
| 2012-04-10 08:45:00 | AAPL | Stock | 22.8739 | 22.8782 | 22.8646 | 22.8714 | 205940.0 |
| 2012-04-10 08:50:00 | AAPL | Stock | 22.8761 | 22.8868 | 22.8439 | 22.8643 | 570864.0 |
> showing 50 of 344,349 rows — these rows as CSV