PREVIEW / stock_5min / 2014-06-13
file: by_date/stock_5min/2014/2014-06-13.parquet size: 5.2 MB rows: 350,639 symbols: 3,529
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-06-13 04:00:00 | AAPL | Stock | 23.0625 | 23.0625 | 22.9 | 22.9 | 4660.0 |
| 2014-06-13 04:05:00 | AAPL | Stock | 22.9125 | 22.9125 | 22.9125 | 22.9125 | 4000.0 |
| 2014-06-13 04:10:00 | AAPL | Stock | 22.9125 | 22.9125 | 22.9125 | 22.9125 | 400.0 |
| 2014-06-13 04:15:00 | AAPL | Stock | 22.9475 | 22.95 | 22.925 | 22.95 | 7000.0 |
| 2014-06-13 04:20:00 | AAPL | Stock | 22.9275 | 22.9275 | 22.9275 | 22.9275 | 400.0 |
| 2014-06-13 04:25:00 | AAPL | Stock | 22.9025 | 22.905 | 22.9025 | 22.905 | 1600.0 |
| 2014-06-13 04:30:00 | AAPL | Stock | 22.92 | 22.92 | 22.92 | 22.92 | 600.0 |
| 2014-06-13 04:35:00 | AAPL | Stock | 22.925 | 22.925 | 22.925 | 22.925 | 1920.0 |
| 2014-06-13 04:40:00 | AAPL | Stock | 22.925 | 22.925 | 22.925 | 22.925 | 9840.0 |
| 2014-06-13 04:45:00 | AAPL | Stock | 22.9375 | 22.9375 | 22.925 | 22.925 | 6560.0 |
| 2014-06-13 04:50:00 | AAPL | Stock | 22.9375 | 22.9375 | 22.935 | 22.935 | 3600.0 |
| 2014-06-13 05:00:00 | AAPL | Stock | 22.92 | 22.9375 | 22.92 | 22.9375 | 4800.0 |
| 2014-06-13 05:05:00 | AAPL | Stock | 22.9375 | 22.9375 | 22.9375 | 22.9375 | 1600.0 |
| 2014-06-13 05:10:00 | AAPL | Stock | 22.9375 | 22.9375 | 22.9375 | 22.9375 | 2800.0 |
| 2014-06-13 05:20:00 | AAPL | Stock | 22.9375 | 22.95 | 22.9325 | 22.9325 | 12400.0 |
| 2014-06-13 05:25:00 | AAPL | Stock | 22.93 | 22.93 | 22.9275 | 22.9275 | 4080.0 |
| 2014-06-13 05:30:00 | AAPL | Stock | 22.9025 | 22.915 | 22.885 | 22.885 | 6440.0 |
| 2014-06-13 05:35:00 | AAPL | Stock | 22.885 | 22.8875 | 22.8625 | 22.8625 | 8152.0 |
| 2014-06-13 05:40:00 | AAPL | Stock | 22.8625 | 22.8625 | 22.8475 | 22.8475 | 5228.0 |
| 2014-06-13 05:45:00 | AAPL | Stock | 22.8475 | 22.8475 | 22.8 | 22.825 | 4800.0 |
| 2014-06-13 05:50:00 | AAPL | Stock | 22.8025 | 22.825 | 22.8025 | 22.8125 | 10428.0 |
| 2014-06-13 05:55:00 | AAPL | Stock | 22.815 | 22.83 | 22.81 | 22.81 | 11968.0 |
| 2014-06-13 06:00:00 | AAPL | Stock | 22.81 | 22.8675 | 22.8025 | 22.85 | 28052.0 |
| 2014-06-13 06:05:00 | AAPL | Stock | 22.865 | 22.875 | 22.82 | 22.82 | 8136.0 |
| 2014-06-13 06:10:00 | AAPL | Stock | 22.825 | 22.825 | 22.8225 | 22.825 | 44000.0 |
| 2014-06-13 06:15:00 | AAPL | Stock | 22.8575 | 22.8575 | 22.84 | 22.84 | 2400.0 |
| 2014-06-13 06:20:00 | AAPL | Stock | 22.845 | 22.845 | 22.845 | 22.845 | 5200.0 |
| 2014-06-13 06:25:00 | AAPL | Stock | 22.845 | 22.885 | 22.845 | 22.885 | 12792.0 |
| 2014-06-13 06:30:00 | AAPL | Stock | 22.8875 | 22.8875 | 22.85 | 22.85 | 2368.0 |
| 2014-06-13 06:35:00 | AAPL | Stock | 22.8625 | 22.8625 | 22.8625 | 22.8625 | 800.0 |
| 2014-06-13 06:40:00 | AAPL | Stock | 22.8625 | 22.8625 | 22.85 | 22.85 | 1680.0 |
| 2014-06-13 06:45:00 | AAPL | Stock | 22.87 | 22.87 | 22.85 | 22.85 | 10720.0 |
| 2014-06-13 06:50:00 | AAPL | Stock | 22.85 | 22.8625 | 22.85 | 22.8625 | 18600.0 |
| 2014-06-13 06:55:00 | AAPL | Stock | 22.87 | 22.87 | 22.8675 | 22.87 | 8252.0 |
| 2014-06-13 07:00:00 | AAPL | Stock | 22.87 | 22.905 | 22.87 | 22.8875 | 39596.0 |
| 2014-06-13 07:05:00 | AAPL | Stock | 22.9 | 22.905 | 22.895 | 22.895 | 12000.0 |
| 2014-06-13 07:10:00 | AAPL | Stock | 22.895 | 22.8975 | 22.8675 | 22.875 | 72040.0 |
| 2014-06-13 07:15:00 | AAPL | Stock | 22.865 | 22.8925 | 22.86 | 22.8925 | 32000.0 |
| 2014-06-13 07:20:00 | AAPL | Stock | 22.885 | 22.915 | 22.8825 | 22.9 | 73744.0 |
| 2014-06-13 07:25:00 | AAPL | Stock | 22.9075 | 22.925 | 22.9025 | 22.92 | 11200.0 |
| 2014-06-13 07:30:00 | AAPL | Stock | 22.925 | 22.925 | 22.9 | 22.9 | 54872.0 |
| 2014-06-13 07:35:00 | AAPL | Stock | 22.895 | 22.9 | 22.89 | 22.8925 | 18388.0 |
| 2014-06-13 07:40:00 | AAPL | Stock | 22.89 | 22.9075 | 22.8625 | 22.875 | 208832.0 |
| 2014-06-13 07:45:00 | AAPL | Stock | 22.8925 | 22.9175 | 22.8825 | 22.9125 | 65988.0 |
| 2014-06-13 07:50:00 | AAPL | Stock | 22.91 | 22.91 | 22.905 | 22.905 | 4792.0 |
| 2014-06-13 07:55:00 | AAPL | Stock | 22.905 | 22.925 | 22.905 | 22.9075 | 54356.0 |
| 2014-06-13 08:00:00 | AAPL | Stock | 22.9125 | 22.955 | 22.85 | 22.9525 | 659368.0 |
| 2014-06-13 08:05:00 | AAPL | Stock | 22.9525 | 22.9975 | 22.9475 | 22.99 | 162868.0 |
| 2014-06-13 08:10:00 | AAPL | Stock | 22.985 | 22.9925 | 22.965 | 22.97 | 77132.0 |
| 2014-06-13 08:15:00 | AAPL | Stock | 22.9675 | 23.0375 | 22.9675 | 23.0025 | 84660.0 |
> showing 50 of 350,639 rows — these rows as CSV