PREVIEW / stock_5min / 2016-08-26
file: by_date/stock_5min/2016/2016-08-26.parquet size: 5.3 MB rows: 346,099 symbols: 3,246
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 |
|---|---|---|---|---|---|---|---|
| 2016-08-26 04:00:00 | AAPL | Stock | 26.9525 | 26.9525 | 26.9525 | 26.9525 | 1600.0 |
| 2016-08-26 04:45:00 | AAPL | Stock | 26.905 | 26.905 | 26.905 | 26.905 | 400.0 |
| 2016-08-26 05:50:00 | AAPL | Stock | 26.9025 | 26.9025 | 26.9 | 26.9 | 1600.0 |
| 2016-08-26 06:00:00 | AAPL | Stock | 26.8975 | 26.8975 | 26.8975 | 26.8975 | 400.0 |
| 2016-08-26 07:00:00 | AAPL | Stock | 26.8575 | 26.8575 | 26.8575 | 26.8575 | 800.0 |
| 2016-08-26 07:05:00 | AAPL | Stock | 26.875 | 26.875 | 26.875 | 26.875 | 800.0 |
| 2016-08-26 07:10:00 | AAPL | Stock | 26.875 | 26.875 | 26.875 | 26.875 | 1800.0 |
| 2016-08-26 07:25:00 | AAPL | Stock | 26.87 | 26.87 | 26.87 | 26.87 | 800.0 |
| 2016-08-26 07:30:00 | AAPL | Stock | 26.8675 | 26.8675 | 26.8675 | 26.8675 | 2000.0 |
| 2016-08-26 07:40:00 | AAPL | Stock | 26.8525 | 26.8525 | 26.85 | 26.85 | 4488.0 |
| 2016-08-26 07:45:00 | AAPL | Stock | 26.85 | 26.85 | 26.85 | 26.85 | 552.0 |
| 2016-08-26 07:55:00 | AAPL | Stock | 26.8375 | 26.8375 | 26.8375 | 26.8375 | 680.0 |
| 2016-08-26 08:00:00 | AAPL | Stock | 26.8375 | 26.8375 | 26.8375 | 26.8375 | 1600.0 |
| 2016-08-26 08:05:00 | AAPL | Stock | 26.8375 | 26.8375 | 26.8375 | 26.8375 | 600.0 |
| 2016-08-26 08:20:00 | AAPL | Stock | 26.845 | 26.845 | 26.8375 | 26.8375 | 1200.0 |
| 2016-08-26 08:25:00 | AAPL | Stock | 26.8375 | 26.8375 | 26.825 | 26.825 | 2856.0 |
| 2016-08-26 08:30:00 | AAPL | Stock | 26.8275 | 26.8275 | 26.825 | 26.825 | 1680.0 |
| 2016-08-26 08:35:00 | AAPL | Stock | 26.8325 | 26.8325 | 26.8325 | 26.8325 | 400.0 |
| 2016-08-26 08:40:00 | AAPL | Stock | 26.8425 | 26.845 | 26.84 | 26.84 | 4400.0 |
| 2016-08-26 08:45:00 | AAPL | Stock | 26.8475 | 26.86 | 26.8475 | 26.85 | 22800.0 |
| 2016-08-26 08:50:00 | AAPL | Stock | 26.8575 | 26.86 | 26.84 | 26.84 | 14024.0 |
| 2016-08-26 08:55:00 | AAPL | Stock | 26.8625 | 26.8625 | 26.84 | 26.85 | 4960.0 |
| 2016-08-26 09:00:00 | AAPL | Stock | 26.86 | 26.8625 | 26.8475 | 26.8475 | 21440.0 |
| 2016-08-26 09:05:00 | AAPL | Stock | 26.84 | 26.8425 | 26.84 | 26.84 | 4800.0 |
| 2016-08-26 09:10:00 | AAPL | Stock | 26.85 | 26.85 | 26.84 | 26.84 | 4400.0 |
| 2016-08-26 09:15:00 | AAPL | Stock | 26.8375 | 26.8425 | 26.8375 | 26.8375 | 6000.0 |
| 2016-08-26 09:20:00 | AAPL | Stock | 26.83 | 26.83 | 26.815 | 26.815 | 40040.0 |
| 2016-08-26 09:25:00 | AAPL | Stock | 26.8125 | 26.875 | 26.8125 | 26.8575 | 44816.0 |
| 2016-08-26 09:30:00 | AAPL | Stock | 26.86 | 26.8925 | 26.8075 | 26.8622 | 3073324.0 |
| 2016-08-26 09:35:00 | AAPL | Stock | 26.865 | 26.9725 | 26.8625 | 26.9325 | 2344744.0 |
| 2016-08-26 09:40:00 | AAPL | Stock | 26.935 | 26.96 | 26.915 | 26.9215 | 1694984.0 |
| 2016-08-26 09:45:00 | AAPL | Stock | 26.9225 | 26.945 | 26.87 | 26.8725 | 1699304.0 |
| 2016-08-26 09:50:00 | AAPL | Stock | 26.8725 | 26.8875 | 26.8475 | 26.865 | 1534100.0 |
| 2016-08-26 09:55:00 | AAPL | Stock | 26.865 | 26.87 | 26.8025 | 26.805 | 1310192.0 |
| 2016-08-26 10:00:00 | AAPL | Stock | 26.8025 | 26.8775 | 26.7575 | 26.845 | 3410268.0 |
| 2016-08-26 10:05:00 | AAPL | Stock | 26.8445 | 26.875 | 26.8225 | 26.8475 | 1820816.0 |
| 2016-08-26 10:10:00 | AAPL | Stock | 26.8475 | 26.8575 | 26.785 | 26.815 | 1842872.0 |
| 2016-08-26 10:15:00 | AAPL | Stock | 26.815 | 26.9325 | 26.81 | 26.8992 | 2587576.0 |
| 2016-08-26 10:20:00 | AAPL | Stock | 26.9 | 26.9475 | 26.9 | 26.94 | 1655780.0 |
| 2016-08-26 10:25:00 | AAPL | Stock | 26.94 | 26.9875 | 26.94 | 26.96 | 1896948.0 |
| 2016-08-26 10:30:00 | AAPL | Stock | 26.9622 | 26.9725 | 26.93 | 26.9325 | 1054048.0 |
| 2016-08-26 10:35:00 | AAPL | Stock | 26.935 | 26.96 | 26.93 | 26.9438 | 709572.0 |
| 2016-08-26 10:40:00 | AAPL | Stock | 26.944 | 26.95 | 26.92 | 26.945 | 915608.0 |
| 2016-08-26 10:45:00 | AAPL | Stock | 26.945 | 26.95 | 26.9275 | 26.9338 | 754280.0 |
| 2016-08-26 10:50:00 | AAPL | Stock | 26.9312 | 26.935 | 26.8925 | 26.9018 | 1107652.0 |
| 2016-08-26 10:55:00 | AAPL | Stock | 26.9 | 26.915 | 26.885 | 26.8912 | 1741020.0 |
| 2016-08-26 11:00:00 | AAPL | Stock | 26.8925 | 26.895 | 26.835 | 26.8475 | 1322868.0 |
| 2016-08-26 11:05:00 | AAPL | Stock | 26.8475 | 26.8912 | 26.8475 | 26.88 | 969288.0 |
| 2016-08-26 11:10:00 | AAPL | Stock | 26.88 | 26.8975 | 26.8675 | 26.8965 | 676752.0 |
| 2016-08-26 11:15:00 | AAPL | Stock | 26.8975 | 26.9175 | 26.8912 | 26.895 | 988548.0 |
> showing 50 of 346,099 rows — these rows as CSV