PREVIEW / stock_5min / 2012-03-06
file: by_date/stock_5min/2012/2012-03-06.parquet size: 5.0 MB rows: 336,256 symbols: 3,513
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-03-06 04:20:00 | AAPL | Stock | 18.9543 | 18.9543 | 18.9543 | 18.9543 | 2800.0 |
| 2012-03-06 04:25:00 | AAPL | Stock | 18.9554 | 18.9611 | 18.9521 | 18.9611 | 14000.0 |
| 2012-03-06 04:30:00 | AAPL | Stock | 18.9643 | 18.9643 | 18.9643 | 18.9643 | 19600.0 |
| 2012-03-06 04:35:00 | AAPL | Stock | 18.9429 | 18.9464 | 18.9286 | 18.9464 | 27300.0 |
| 2012-03-06 05:10:00 | AAPL | Stock | 18.9286 | 18.9286 | 18.9286 | 18.9286 | 8120.0 |
| 2012-03-06 05:15:00 | AAPL | Stock | 18.9286 | 18.9286 | 18.9286 | 18.9286 | 33600.0 |
| 2012-03-06 05:20:00 | AAPL | Stock | 18.9196 | 18.9268 | 18.9196 | 18.9196 | 10360.0 |
| 2012-03-06 05:30:00 | AAPL | Stock | 18.9214 | 18.9214 | 18.9021 | 18.9071 | 66500.0 |
| 2012-03-06 05:45:00 | AAPL | Stock | 18.8946 | 18.8946 | 18.8796 | 18.8929 | 27160.0 |
| 2012-03-06 05:50:00 | AAPL | Stock | 18.8857 | 18.8857 | 18.8857 | 18.8857 | 2800.0 |
| 2012-03-06 06:00:00 | AAPL | Stock | 18.8754 | 18.8754 | 18.8679 | 18.8679 | 15400.0 |
| 2012-03-06 06:05:00 | AAPL | Stock | 18.8571 | 18.8575 | 18.8571 | 18.8575 | 15400.0 |
| 2012-03-06 06:10:00 | AAPL | Stock | 18.8529 | 18.8529 | 18.8214 | 18.8214 | 22400.0 |
| 2012-03-06 06:15:00 | AAPL | Stock | 18.8214 | 18.8214 | 18.8214 | 18.8214 | 2800.0 |
| 2012-03-06 06:20:00 | AAPL | Stock | 18.8482 | 18.8482 | 18.8482 | 18.8482 | 2800.0 |
| 2012-03-06 06:25:00 | AAPL | Stock | 18.8393 | 18.8521 | 18.8143 | 18.8143 | 35000.0 |
| 2012-03-06 06:30:00 | AAPL | Stock | 18.8036 | 18.8036 | 18.8021 | 18.8036 | 17136.0 |
| 2012-03-06 06:35:00 | AAPL | Stock | 18.8286 | 18.8286 | 18.8218 | 18.8218 | 16800.0 |
| 2012-03-06 06:40:00 | AAPL | Stock | 18.8107 | 18.8107 | 18.8107 | 18.8107 | 9912.0 |
| 2012-03-06 06:45:00 | AAPL | Stock | 18.8107 | 18.8214 | 18.8036 | 18.8211 | 83720.0 |
| 2012-03-06 06:50:00 | AAPL | Stock | 18.8107 | 18.8107 | 18.7518 | 18.7639 | 172340.0 |
| 2012-03-06 06:55:00 | AAPL | Stock | 18.7679 | 18.7768 | 18.7679 | 18.7714 | 18200.0 |
| 2012-03-06 07:00:00 | AAPL | Stock | 18.7786 | 18.8393 | 18.7786 | 18.8343 | 183932.0 |
| 2012-03-06 07:05:00 | AAPL | Stock | 18.8289 | 18.8571 | 18.8214 | 18.8571 | 147672.0 |
| 2012-03-06 07:10:00 | AAPL | Stock | 18.8739 | 18.8929 | 18.8643 | 18.875 | 66864.0 |
| 2012-03-06 07:15:00 | AAPL | Stock | 18.8686 | 18.8854 | 18.8571 | 18.8571 | 133588.0 |
| 2012-03-06 07:20:00 | AAPL | Stock | 18.8432 | 18.8571 | 18.8218 | 18.8571 | 134960.0 |
| 2012-03-06 07:25:00 | AAPL | Stock | 18.8571 | 18.8571 | 18.8518 | 18.8571 | 117292.0 |
| 2012-03-06 07:30:00 | AAPL | Stock | 18.8561 | 18.8571 | 18.8393 | 18.8571 | 145824.0 |
| 2012-03-06 07:35:00 | AAPL | Stock | 18.8518 | 18.8661 | 18.8518 | 18.8643 | 267624.0 |
| 2012-03-06 07:40:00 | AAPL | Stock | 18.8643 | 18.8857 | 18.8643 | 18.8857 | 109312.0 |
| 2012-03-06 07:45:00 | AAPL | Stock | 18.8893 | 18.8893 | 18.875 | 18.8879 | 71120.0 |
| 2012-03-06 07:50:00 | AAPL | Stock | 18.8807 | 18.8807 | 18.875 | 18.875 | 85792.0 |
| 2012-03-06 07:55:00 | AAPL | Stock | 18.8757 | 18.8818 | 18.8757 | 18.8768 | 47600.0 |
| 2012-03-06 08:00:00 | AAPL | Stock | 18.8786 | 18.9021 | 18.8518 | 18.8825 | 844312.0 |
| 2012-03-06 08:05:00 | AAPL | Stock | 18.8825 | 18.9089 | 18.8821 | 18.9064 | 450128.0 |
| 2012-03-06 08:10:00 | AAPL | Stock | 18.9021 | 18.9064 | 18.8793 | 18.8793 | 405104.0 |
| 2012-03-06 08:15:00 | AAPL | Stock | 18.8764 | 18.8907 | 18.875 | 18.875 | 355236.0 |
| 2012-03-06 08:20:00 | AAPL | Stock | 18.875 | 18.8911 | 18.875 | 18.8868 | 538300.0 |
| 2012-03-06 08:25:00 | AAPL | Stock | 18.8868 | 18.9018 | 18.8868 | 18.8982 | 477960.0 |
| 2012-03-06 08:30:00 | AAPL | Stock | 18.8986 | 18.8986 | 18.8757 | 18.8804 | 505232.0 |
| 2012-03-06 08:35:00 | AAPL | Stock | 18.8775 | 18.8839 | 18.875 | 18.8821 | 277760.0 |
| 2012-03-06 08:40:00 | AAPL | Stock | 18.8818 | 18.8964 | 18.8732 | 18.8814 | 793100.0 |
| 2012-03-06 08:45:00 | AAPL | Stock | 18.8857 | 18.8857 | 18.875 | 18.875 | 182196.0 |
| 2012-03-06 08:50:00 | AAPL | Stock | 18.875 | 18.8782 | 18.8579 | 18.8643 | 541016.0 |
| 2012-03-06 08:55:00 | AAPL | Stock | 18.8671 | 18.8725 | 18.8643 | 18.8654 | 320908.0 |
| 2012-03-06 09:00:00 | AAPL | Stock | 18.8664 | 18.8696 | 18.8571 | 18.8579 | 1012788.0 |
| 2012-03-06 09:05:00 | AAPL | Stock | 18.8604 | 18.8679 | 18.8546 | 18.8604 | 789600.0 |
| 2012-03-06 09:10:00 | AAPL | Stock | 18.8589 | 18.8661 | 18.8304 | 18.8432 | 965860.0 |
| 2012-03-06 09:15:00 | AAPL | Stock | 18.8325 | 18.8432 | 18.8007 | 18.8036 | 651616.0 |
> showing 50 of 336,256 rows — these rows as CSV