PREVIEW / stock_5min / 2014-03-10
file: by_date/stock_5min/2014/2014-03-10.parquet size: 5.4 MB rows: 360,744 symbols: 3,527
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-03-10 04:10:00 | AAPL | Stock | 18.9089 | 18.9089 | 18.9089 | 18.9089 | 2800.0 |
| 2014-03-10 04:15:00 | AAPL | Stock | 18.9107 | 18.9107 | 18.9107 | 18.9107 | 2800.0 |
| 2014-03-10 05:30:00 | AAPL | Stock | 18.9421 | 18.9421 | 18.9421 | 18.9421 | 2800.0 |
| 2014-03-10 06:50:00 | AAPL | Stock | 18.9304 | 18.9304 | 18.9304 | 18.9304 | 2800.0 |
| 2014-03-10 07:30:00 | AAPL | Stock | 18.9286 | 18.9286 | 18.9286 | 18.9286 | 2800.0 |
| 2014-03-10 07:50:00 | AAPL | Stock | 18.9307 | 18.9429 | 18.9307 | 18.9429 | 12180.0 |
| 2014-03-10 07:55:00 | AAPL | Stock | 18.9321 | 18.9321 | 18.9321 | 18.9321 | 2800.0 |
| 2014-03-10 08:00:00 | AAPL | Stock | 18.9196 | 18.9286 | 18.9196 | 18.9239 | 47040.0 |
| 2014-03-10 08:05:00 | AAPL | Stock | 18.9425 | 18.9425 | 18.9232 | 18.9232 | 28420.0 |
| 2014-03-10 08:10:00 | AAPL | Stock | 18.9243 | 18.9243 | 18.9071 | 18.9171 | 50120.0 |
| 2014-03-10 08:15:00 | AAPL | Stock | 18.9089 | 18.9093 | 18.9089 | 18.9093 | 5600.0 |
| 2014-03-10 08:25:00 | AAPL | Stock | 18.9064 | 18.9064 | 18.895 | 18.895 | 53676.0 |
| 2014-03-10 08:35:00 | AAPL | Stock | 18.9007 | 18.9007 | 18.8982 | 18.8982 | 8820.0 |
| 2014-03-10 08:40:00 | AAPL | Stock | 18.8964 | 18.8964 | 18.8929 | 18.8929 | 45108.0 |
| 2014-03-10 08:45:00 | AAPL | Stock | 18.8911 | 18.9 | 18.875 | 18.875 | 159320.0 |
| 2014-03-10 08:50:00 | AAPL | Stock | 18.8707 | 18.8875 | 18.8707 | 18.8732 | 95200.0 |
| 2014-03-10 08:55:00 | AAPL | Stock | 18.8825 | 18.8929 | 18.8732 | 18.8732 | 98840.0 |
| 2014-03-10 09:00:00 | AAPL | Stock | 18.8764 | 18.8821 | 18.8757 | 18.8789 | 39200.0 |
| 2014-03-10 09:05:00 | AAPL | Stock | 18.8921 | 18.8946 | 18.88 | 18.8946 | 47040.0 |
| 2014-03-10 09:10:00 | AAPL | Stock | 18.8861 | 18.8929 | 18.8732 | 18.8732 | 197792.0 |
| 2014-03-10 09:15:00 | AAPL | Stock | 18.8789 | 18.8789 | 18.8789 | 18.8789 | 2800.0 |
| 2014-03-10 09:20:00 | AAPL | Stock | 18.8682 | 18.875 | 18.8682 | 18.875 | 5600.0 |
| 2014-03-10 09:25:00 | AAPL | Stock | 18.8771 | 18.8789 | 18.86 | 18.8789 | 121128.0 |
| 2014-03-10 09:30:00 | AAPL | Stock | 18.87 | 18.9732 | 18.8692 | 18.9654 | 8612352.0 |
| 2014-03-10 09:35:00 | AAPL | Stock | 18.9696 | 19.0054 | 18.9446 | 19.0041 | 5754084.0 |
| 2014-03-10 09:40:00 | AAPL | Stock | 19.0021 | 19.0071 | 18.9464 | 18.9732 | 4299204.0 |
| 2014-03-10 09:45:00 | AAPL | Stock | 18.9793 | 19.0325 | 18.9748 | 19.0111 | 5027764.0 |
| 2014-03-10 09:50:00 | AAPL | Stock | 19.0104 | 19.0261 | 18.9857 | 18.9929 | 3516492.0 |
| 2014-03-10 09:55:00 | AAPL | Stock | 18.9979 | 19.0153 | 18.9693 | 19.0095 | 3052532.0 |
| 2014-03-10 10:00:00 | AAPL | Stock | 19.0129 | 19.0132 | 18.9868 | 18.9898 | 1692656.0 |
| 2014-03-10 10:05:00 | AAPL | Stock | 18.9889 | 18.9889 | 18.9479 | 18.9634 | 2968784.0 |
| 2014-03-10 10:10:00 | AAPL | Stock | 18.9621 | 18.9693 | 18.9257 | 18.9311 | 2899204.0 |
| 2014-03-10 10:15:00 | AAPL | Stock | 18.9307 | 18.9654 | 18.9286 | 18.9529 | 1663872.0 |
| 2014-03-10 10:20:00 | AAPL | Stock | 18.9607 | 19.0046 | 18.9532 | 18.9832 | 3311728.0 |
| 2014-03-10 10:25:00 | AAPL | Stock | 18.9835 | 18.9961 | 18.9596 | 18.9596 | 1997604.0 |
| 2014-03-10 10:30:00 | AAPL | Stock | 18.9689 | 18.9689 | 18.95 | 18.955 | 1565704.0 |
| 2014-03-10 10:35:00 | AAPL | Stock | 18.9546 | 18.9818 | 18.9343 | 18.9721 | 2175488.0 |
| 2014-03-10 10:40:00 | AAPL | Stock | 18.9736 | 18.9782 | 18.9486 | 18.9571 | 2171708.0 |
| 2014-03-10 10:45:00 | AAPL | Stock | 18.9579 | 18.9661 | 18.9396 | 18.9639 | 1637748.0 |
| 2014-03-10 10:50:00 | AAPL | Stock | 18.9614 | 18.9732 | 18.945 | 18.9625 | 1513428.0 |
| 2014-03-10 10:55:00 | AAPL | Stock | 18.9619 | 18.97 | 18.9286 | 18.9351 | 1910692.0 |
| 2014-03-10 11:00:00 | AAPL | Stock | 18.9379 | 18.9407 | 18.9071 | 18.9407 | 2941820.0 |
| 2014-03-10 11:05:00 | AAPL | Stock | 18.9393 | 18.9682 | 18.9229 | 18.9682 | 2082780.0 |
| 2014-03-10 11:10:00 | AAPL | Stock | 18.9725 | 18.9864 | 18.9636 | 18.9785 | 1729504.0 |
| 2014-03-10 11:15:00 | AAPL | Stock | 18.9821 | 18.9871 | 18.9743 | 18.9821 | 1142512.0 |
| 2014-03-10 11:20:00 | AAPL | Stock | 18.9798 | 19.0232 | 18.9798 | 19.01 | 3087588.0 |
| 2014-03-10 11:25:00 | AAPL | Stock | 19.01 | 19.0214 | 18.9896 | 19.0046 | 2080008.0 |
| 2014-03-10 11:30:00 | AAPL | Stock | 19.0039 | 19.0335 | 19.0004 | 19.0318 | 3300080.0 |
| 2014-03-10 11:35:00 | AAPL | Stock | 19.0318 | 19.0475 | 19.0279 | 19.0307 | 3040940.0 |
| 2014-03-10 11:40:00 | AAPL | Stock | 19.0339 | 19.0346 | 18.9954 | 19.0146 | 1930040.0 |
> showing 50 of 360,744 rows — these rows as CSV