PREVIEW / stock_5min / 2014-09-02
file: by_date/stock_5min/2014/2014-09-02.parquet size: 5.5 MB rows: 364,367 symbols: 3,579
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-02 04:00:00 | AAPL | Stock | 25.66 | 25.955 | 25.66 | 25.8625 | 66848.0 |
| 2014-09-02 04:05:00 | AAPL | Stock | 25.875 | 25.9 | 25.875 | 25.9 | 15360.0 |
| 2014-09-02 04:10:00 | AAPL | Stock | 25.905 | 25.92 | 25.905 | 25.92 | 35232.0 |
| 2014-09-02 04:15:00 | AAPL | Stock | 25.92 | 25.9225 | 25.9125 | 25.9125 | 15368.0 |
| 2014-09-02 04:20:00 | AAPL | Stock | 25.9 | 25.9125 | 25.9 | 25.9125 | 26460.0 |
| 2014-09-02 04:25:00 | AAPL | Stock | 25.92 | 25.92 | 25.9125 | 25.9125 | 4340.0 |
| 2014-09-02 04:30:00 | AAPL | Stock | 25.9125 | 25.9325 | 25.9125 | 25.9325 | 6400.0 |
| 2014-09-02 04:35:00 | AAPL | Stock | 25.93 | 25.93 | 25.9175 | 25.9175 | 9692.0 |
| 2014-09-02 04:40:00 | AAPL | Stock | 25.9125 | 25.9225 | 25.9125 | 25.9225 | 4400.0 |
| 2014-09-02 04:45:00 | AAPL | Stock | 25.92 | 25.92 | 25.92 | 25.92 | 400.0 |
| 2014-09-02 04:50:00 | AAPL | Stock | 25.92 | 25.92 | 25.92 | 25.92 | 4000.0 |
| 2014-09-02 04:55:00 | AAPL | Stock | 25.92 | 25.9225 | 25.92 | 25.9225 | 1400.0 |
| 2014-09-02 05:00:00 | AAPL | Stock | 25.9225 | 25.9225 | 25.9225 | 25.9225 | 4000.0 |
| 2014-09-02 05:05:00 | AAPL | Stock | 25.9225 | 25.9225 | 25.9225 | 25.9225 | 400.0 |
| 2014-09-02 05:10:00 | AAPL | Stock | 25.92 | 25.92 | 25.92 | 25.92 | 3600.0 |
| 2014-09-02 05:15:00 | AAPL | Stock | 25.92 | 25.92 | 25.9175 | 25.9175 | 1792.0 |
| 2014-09-02 05:20:00 | AAPL | Stock | 25.9175 | 25.9175 | 25.9175 | 25.9175 | 4400.0 |
| 2014-09-02 05:25:00 | AAPL | Stock | 25.9175 | 25.9175 | 25.9175 | 25.9175 | 5132.0 |
| 2014-09-02 05:30:00 | AAPL | Stock | 25.92 | 25.9225 | 25.92 | 25.9225 | 1600.0 |
| 2014-09-02 05:35:00 | AAPL | Stock | 25.915 | 25.9175 | 25.9025 | 25.9075 | 25400.0 |
| 2014-09-02 05:40:00 | AAPL | Stock | 25.9025 | 25.9025 | 25.8875 | 25.8875 | 7600.0 |
| 2014-09-02 05:45:00 | AAPL | Stock | 25.8975 | 25.9 | 25.8975 | 25.9 | 6844.0 |
| 2014-09-02 05:50:00 | AAPL | Stock | 25.8775 | 25.8775 | 25.8775 | 25.8775 | 4000.0 |
| 2014-09-02 05:55:00 | AAPL | Stock | 25.8925 | 25.8925 | 25.8625 | 25.88 | 38856.0 |
| 2014-09-02 06:00:00 | AAPL | Stock | 25.88 | 25.88 | 25.8625 | 25.8625 | 3024.0 |
| 2014-09-02 06:05:00 | AAPL | Stock | 25.875 | 25.875 | 25.8625 | 25.8625 | 3600.0 |
| 2014-09-02 06:10:00 | AAPL | Stock | 25.8725 | 25.875 | 25.8725 | 25.8725 | 9900.0 |
| 2014-09-02 06:15:00 | AAPL | Stock | 25.875 | 25.8875 | 25.875 | 25.8875 | 13744.0 |
| 2014-09-02 06:20:00 | AAPL | Stock | 25.9 | 25.9 | 25.9 | 25.9 | 2400.0 |
| 2014-09-02 06:25:00 | AAPL | Stock | 25.895 | 25.8975 | 25.895 | 25.8975 | 2032.0 |
| 2014-09-02 06:30:00 | AAPL | Stock | 25.8975 | 25.905 | 25.8875 | 25.9 | 47680.0 |
| 2014-09-02 06:35:00 | AAPL | Stock | 25.9 | 25.9 | 25.895 | 25.9 | 12200.0 |
| 2014-09-02 06:40:00 | AAPL | Stock | 25.9 | 25.9 | 25.875 | 25.875 | 22700.0 |
| 2014-09-02 06:45:00 | AAPL | Stock | 25.885 | 25.8875 | 25.885 | 25.8875 | 2600.0 |
| 2014-09-02 06:50:00 | AAPL | Stock | 25.89 | 25.89 | 25.8325 | 25.8725 | 30852.0 |
| 2014-09-02 06:55:00 | AAPL | Stock | 25.8725 | 25.8725 | 25.8 | 25.8 | 59384.0 |
| 2014-09-02 07:00:00 | AAPL | Stock | 25.8 | 25.8425 | 25.8 | 25.8275 | 33960.0 |
| 2014-09-02 07:05:00 | AAPL | Stock | 25.825 | 25.825 | 25.7975 | 25.8125 | 30852.0 |
| 2014-09-02 07:10:00 | AAPL | Stock | 25.8125 | 25.825 | 25.805 | 25.82 | 51596.0 |
| 2014-09-02 07:15:00 | AAPL | Stock | 25.825 | 25.825 | 25.795 | 25.805 | 41748.0 |
| 2014-09-02 07:20:00 | AAPL | Stock | 25.8 | 25.8075 | 25.7975 | 25.8025 | 25908.0 |
| 2014-09-02 07:25:00 | AAPL | Stock | 25.8 | 25.8025 | 25.7925 | 25.7925 | 13092.0 |
| 2014-09-02 07:30:00 | AAPL | Stock | 25.8 | 25.8075 | 25.7975 | 25.8075 | 14092.0 |
| 2014-09-02 07:35:00 | AAPL | Stock | 25.81 | 25.81 | 25.7925 | 25.795 | 50000.0 |
| 2014-09-02 07:40:00 | AAPL | Stock | 25.795 | 25.8 | 25.7875 | 25.7875 | 25900.0 |
| 2014-09-02 07:45:00 | AAPL | Stock | 25.795 | 25.81 | 25.79 | 25.81 | 92664.0 |
| 2014-09-02 07:50:00 | AAPL | Stock | 25.8 | 25.81 | 25.7925 | 25.8 | 18816.0 |
| 2014-09-02 07:55:00 | AAPL | Stock | 25.7975 | 25.7975 | 25.785 | 25.785 | 39196.0 |
| 2014-09-02 08:00:00 | AAPL | Stock | 25.8 | 25.9 | 25.625 | 25.9 | 420092.0 |
| 2014-09-02 08:05:00 | AAPL | Stock | 25.7775 | 25.8 | 25.7675 | 25.7875 | 129740.0 |
> showing 50 of 364,367 rows — these rows as CSV