PREVIEW / stock_5min / 2012-02-28
file: by_date/stock_5min/2012/2012-02-28.parquet size: 4.9 MB rows: 326,673 symbols: 3,538
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-02-28 04:00:00 | AAPL | Stock | 18.875 | 18.875 | 18.875 | 18.875 | 2800.0 |
| 2012-02-28 04:05:00 | AAPL | Stock | 18.8593 | 18.8593 | 18.8593 | 18.8593 | 2800.0 |
| 2012-02-28 04:20:00 | AAPL | Stock | 18.8571 | 18.8571 | 18.8571 | 18.8571 | 2800.0 |
| 2012-02-28 04:25:00 | AAPL | Stock | 18.8757 | 18.8757 | 18.8757 | 18.8757 | 11620.0 |
| 2012-02-28 04:40:00 | AAPL | Stock | 18.8679 | 18.8679 | 18.8679 | 18.8679 | 19600.0 |
| 2012-02-28 05:10:00 | AAPL | Stock | 18.8732 | 18.8732 | 18.8732 | 18.8732 | 2800.0 |
| 2012-02-28 05:25:00 | AAPL | Stock | 18.875 | 18.875 | 18.875 | 18.875 | 8792.0 |
| 2012-02-28 05:40:00 | AAPL | Stock | 18.8596 | 18.8596 | 18.8579 | 18.8579 | 13720.0 |
| 2012-02-28 05:45:00 | AAPL | Stock | 18.8661 | 18.8661 | 18.8661 | 18.8661 | 28000.0 |
| 2012-02-28 05:50:00 | AAPL | Stock | 18.8661 | 18.8661 | 18.8607 | 18.8607 | 8400.0 |
| 2012-02-28 06:05:00 | AAPL | Stock | 18.875 | 18.875 | 18.875 | 18.875 | 2800.0 |
| 2012-02-28 06:20:00 | AAPL | Stock | 18.88 | 18.88 | 18.8789 | 18.8789 | 5600.0 |
| 2012-02-28 06:50:00 | AAPL | Stock | 18.8632 | 18.8632 | 18.8611 | 18.8611 | 19600.0 |
| 2012-02-28 07:00:00 | AAPL | Stock | 18.8607 | 18.8607 | 18.8393 | 18.8539 | 45276.0 |
| 2012-02-28 07:05:00 | AAPL | Stock | 18.8607 | 18.8607 | 18.8571 | 18.8571 | 11200.0 |
| 2012-02-28 07:10:00 | AAPL | Stock | 18.8696 | 18.8696 | 18.8625 | 18.8625 | 43288.0 |
| 2012-02-28 07:15:00 | AAPL | Stock | 18.8657 | 18.8696 | 18.8564 | 18.8625 | 76440.0 |
| 2012-02-28 07:20:00 | AAPL | Stock | 18.8639 | 18.8729 | 18.8639 | 18.8639 | 75600.0 |
| 2012-02-28 07:25:00 | AAPL | Stock | 18.8639 | 18.8679 | 18.8607 | 18.8679 | 70000.0 |
| 2012-02-28 07:30:00 | AAPL | Stock | 18.8639 | 18.8696 | 18.8639 | 18.8696 | 14000.0 |
| 2012-02-28 07:35:00 | AAPL | Stock | 18.8714 | 18.8714 | 18.8664 | 18.8707 | 21476.0 |
| 2012-02-28 07:40:00 | AAPL | Stock | 18.8711 | 18.8711 | 18.8643 | 18.87 | 16800.0 |
| 2012-02-28 07:45:00 | AAPL | Stock | 18.8621 | 18.8636 | 18.8596 | 18.8636 | 59920.0 |
| 2012-02-28 07:50:00 | AAPL | Stock | 18.8689 | 18.8711 | 18.8643 | 18.8704 | 27720.0 |
| 2012-02-28 07:55:00 | AAPL | Stock | 18.8654 | 18.8718 | 18.8646 | 18.8646 | 23184.0 |
| 2012-02-28 08:00:00 | AAPL | Stock | 18.865 | 18.8718 | 18.85 | 18.8614 | 282408.0 |
| 2012-02-28 08:05:00 | AAPL | Stock | 18.8657 | 18.8714 | 18.8639 | 18.8679 | 256508.0 |
| 2012-02-28 08:10:00 | AAPL | Stock | 18.8693 | 18.8732 | 18.8629 | 18.8679 | 327628.0 |
| 2012-02-28 08:15:00 | AAPL | Stock | 18.8696 | 18.8729 | 18.8532 | 18.8532 | 695156.0 |
| 2012-02-28 08:20:00 | AAPL | Stock | 18.8536 | 18.8668 | 18.8536 | 18.8596 | 297752.0 |
| 2012-02-28 08:25:00 | AAPL | Stock | 18.8636 | 18.8679 | 18.8607 | 18.8679 | 235032.0 |
| 2012-02-28 08:30:00 | AAPL | Stock | 18.8646 | 18.8654 | 18.8039 | 18.8329 | 1202516.0 |
| 2012-02-28 08:35:00 | AAPL | Stock | 18.8393 | 18.8393 | 18.7768 | 18.7768 | 1123416.0 |
| 2012-02-28 08:40:00 | AAPL | Stock | 18.7811 | 18.8057 | 18.7754 | 18.7961 | 750036.0 |
| 2012-02-28 08:45:00 | AAPL | Stock | 18.7932 | 18.8211 | 18.7893 | 18.8054 | 216328.0 |
| 2012-02-28 08:50:00 | AAPL | Stock | 18.8064 | 18.8261 | 18.8064 | 18.8257 | 226380.0 |
| 2012-02-28 08:55:00 | AAPL | Stock | 18.8254 | 18.8325 | 18.8168 | 18.8171 | 376712.0 |
| 2012-02-28 09:00:00 | AAPL | Stock | 18.8125 | 18.8125 | 18.8036 | 18.8054 | 188160.0 |
| 2012-02-28 09:05:00 | AAPL | Stock | 18.805 | 18.8225 | 18.805 | 18.8161 | 208180.0 |
| 2012-02-28 09:10:00 | AAPL | Stock | 18.8214 | 18.8286 | 18.8186 | 18.8246 | 205184.0 |
| 2012-02-28 09:15:00 | AAPL | Stock | 18.8218 | 18.8218 | 18.8143 | 18.8193 | 158312.0 |
| 2012-02-28 09:20:00 | AAPL | Stock | 18.8214 | 18.8232 | 18.8125 | 18.8211 | 166740.0 |
| 2012-02-28 09:25:00 | AAPL | Stock | 18.8171 | 18.8571 | 18.8143 | 18.8564 | 610176.0 |
| 2012-02-28 09:30:00 | AAPL | Stock | 18.8557 | 18.8571 | 18.7804 | 18.7968 | 17861256.0 |
| 2012-02-28 09:35:00 | AAPL | Stock | 18.7986 | 18.8914 | 18.7896 | 18.8779 | 14361256.0 |
| 2012-02-28 09:40:00 | AAPL | Stock | 18.8804 | 18.8971 | 18.8275 | 18.8379 | 13578964.0 |
| 2012-02-28 09:45:00 | AAPL | Stock | 18.8371 | 18.8864 | 18.8314 | 18.8836 | 7998480.0 |
| 2012-02-28 09:50:00 | AAPL | Stock | 18.8811 | 18.9007 | 18.8661 | 18.8856 | 9847796.0 |
| 2012-02-28 09:55:00 | AAPL | Stock | 18.8863 | 18.9275 | 18.8775 | 18.9275 | 12474476.0 |
| 2012-02-28 10:00:00 | AAPL | Stock | 18.9279 | 18.9643 | 18.9089 | 18.9443 | 15164492.0 |
> showing 50 of 326,673 rows — these rows as CSV