PREVIEW / stock_5min / 2014-09-29
file: by_date/stock_5min/2014/2014-09-29.parquet size: 5.3 MB rows: 356,085 symbols: 3,586
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-09-29 04:00:00 | AAPL | Stock | 25.135 | 25.135 | 24.7475 | 24.8 | 40180.0 |
| 2014-09-29 04:05:00 | AAPL | Stock | 24.8175 | 24.825 | 24.8175 | 24.825 | 5800.0 |
| 2014-09-29 04:10:00 | AAPL | Stock | 24.865 | 24.88 | 24.865 | 24.88 | 11744.0 |
| 2014-09-29 04:15:00 | AAPL | Stock | 24.89 | 24.8925 | 24.825 | 24.825 | 23200.0 |
| 2014-09-29 04:20:00 | AAPL | Stock | 24.815 | 24.815 | 24.7775 | 24.7775 | 22020.0 |
| 2014-09-29 04:25:00 | AAPL | Stock | 24.82 | 24.82 | 24.82 | 24.82 | 11200.0 |
| 2014-09-29 04:30:00 | AAPL | Stock | 24.8175 | 24.8175 | 24.805 | 24.805 | 3400.0 |
| 2014-09-29 04:35:00 | AAPL | Stock | 24.8175 | 24.8175 | 24.8 | 24.8125 | 13748.0 |
| 2014-09-29 04:40:00 | AAPL | Stock | 24.8 | 24.8 | 24.7975 | 24.7975 | 3348.0 |
| 2014-09-29 04:45:00 | AAPL | Stock | 24.7775 | 24.7775 | 24.775 | 24.775 | 5200.0 |
| 2014-09-29 04:50:00 | AAPL | Stock | 24.775 | 24.775 | 24.7 | 24.725 | 41876.0 |
| 2014-09-29 04:55:00 | AAPL | Stock | 24.725 | 24.775 | 24.725 | 24.775 | 50644.0 |
| 2014-09-29 05:00:00 | AAPL | Stock | 24.775 | 24.775 | 24.7575 | 24.7575 | 19600.0 |
| 2014-09-29 05:05:00 | AAPL | Stock | 24.7575 | 24.8175 | 24.7575 | 24.8 | 23000.0 |
| 2014-09-29 05:10:00 | AAPL | Stock | 24.8175 | 24.855 | 24.8175 | 24.855 | 1204.0 |
| 2014-09-29 05:20:00 | AAPL | Stock | 24.8275 | 24.8325 | 24.8275 | 24.8325 | 19200.0 |
| 2014-09-29 05:30:00 | AAPL | Stock | 24.855 | 24.855 | 24.855 | 24.855 | 400.0 |
| 2014-09-29 05:35:00 | AAPL | Stock | 24.85 | 24.85 | 24.8375 | 24.8375 | 4400.0 |
| 2014-09-29 05:40:00 | AAPL | Stock | 24.85 | 24.85 | 24.85 | 24.85 | 3200.0 |
| 2014-09-29 05:45:00 | AAPL | Stock | 24.85 | 24.85 | 24.85 | 24.85 | 4136.0 |
| 2014-09-29 05:55:00 | AAPL | Stock | 24.84 | 24.84 | 24.84 | 24.84 | 800.0 |
| 2014-09-29 06:00:00 | AAPL | Stock | 24.845 | 24.87 | 24.845 | 24.87 | 6524.0 |
| 2014-09-29 06:05:00 | AAPL | Stock | 24.875 | 24.875 | 24.865 | 24.865 | 2000.0 |
| 2014-09-29 06:10:00 | AAPL | Stock | 24.87 | 24.87 | 24.865 | 24.865 | 4260.0 |
| 2014-09-29 06:15:00 | AAPL | Stock | 24.875 | 24.875 | 24.875 | 24.875 | 2000.0 |
| 2014-09-29 06:20:00 | AAPL | Stock | 24.875 | 24.8875 | 24.8675 | 24.8875 | 2620.0 |
| 2014-09-29 06:25:00 | AAPL | Stock | 24.8875 | 24.95 | 24.8825 | 24.9275 | 17184.0 |
| 2014-09-29 06:30:00 | AAPL | Stock | 24.9275 | 24.9375 | 24.925 | 24.925 | 49208.0 |
| 2014-09-29 06:35:00 | AAPL | Stock | 24.925 | 24.925 | 24.925 | 24.925 | 2000.0 |
| 2014-09-29 06:45:00 | AAPL | Stock | 24.925 | 24.925 | 24.9125 | 24.925 | 11500.0 |
| 2014-09-29 06:50:00 | AAPL | Stock | 24.925 | 24.925 | 24.875 | 24.875 | 25000.0 |
| 2014-09-29 06:55:00 | AAPL | Stock | 24.875 | 24.89 | 24.875 | 24.875 | 5800.0 |
| 2014-09-29 07:00:00 | AAPL | Stock | 24.895 | 24.935 | 24.8925 | 24.935 | 30104.0 |
| 2014-09-29 07:05:00 | AAPL | Stock | 24.935 | 24.9875 | 24.925 | 24.975 | 110528.0 |
| 2014-09-29 07:10:00 | AAPL | Stock | 24.975 | 24.9975 | 24.9375 | 24.945 | 212072.0 |
| 2014-09-29 07:15:00 | AAPL | Stock | 24.945 | 24.945 | 24.9125 | 24.925 | 45068.0 |
| 2014-09-29 07:20:00 | AAPL | Stock | 24.9125 | 24.9175 | 24.8875 | 24.8962 | 20808.0 |
| 2014-09-29 07:25:00 | AAPL | Stock | 24.8962 | 24.9 | 24.88 | 24.88 | 55552.0 |
| 2014-09-29 07:30:00 | AAPL | Stock | 24.8875 | 24.895 | 24.88 | 24.895 | 26444.0 |
| 2014-09-29 07:35:00 | AAPL | Stock | 24.895 | 24.895 | 24.8775 | 24.8775 | 38480.0 |
| 2014-09-29 07:40:00 | AAPL | Stock | 24.8775 | 24.8825 | 24.865 | 24.875 | 71260.0 |
| 2014-09-29 07:45:00 | AAPL | Stock | 24.8875 | 24.9025 | 24.8725 | 24.8725 | 74612.0 |
| 2014-09-29 07:50:00 | AAPL | Stock | 24.8875 | 24.8925 | 24.875 | 24.885 | 72916.0 |
| 2014-09-29 07:55:00 | AAPL | Stock | 24.8925 | 24.9 | 24.8875 | 24.9 | 30800.0 |
| 2014-09-29 08:00:00 | AAPL | Stock | 24.9025 | 24.9825 | 24.8725 | 24.88 | 283852.0 |
| 2014-09-29 08:05:00 | AAPL | Stock | 24.88 | 24.9 | 24.88 | 24.8925 | 135700.0 |
| 2014-09-29 08:10:00 | AAPL | Stock | 24.8925 | 24.905 | 24.8875 | 24.9 | 73076.0 |
| 2014-09-29 08:15:00 | AAPL | Stock | 24.9 | 24.905 | 24.89 | 24.9025 | 104040.0 |
| 2014-09-29 08:20:00 | AAPL | Stock | 24.91 | 24.9125 | 24.895 | 24.895 | 55680.0 |
| 2014-09-29 08:25:00 | AAPL | Stock | 24.895 | 24.895 | 24.875 | 24.875 | 156516.0 |
> showing 50 of 356,085 rows — these rows as CSV