PREVIEW / stock_5min / 2016-06-07
file: by_date/stock_5min/2016/2016-06-07.parquet size: 5.4 MB rows: 362,103 symbols: 3,315
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-06-07 04:00:00 | AAPL | Stock | 24.6925 | 24.745 | 24.6925 | 24.745 | 8000.0 |
| 2016-06-07 04:55:00 | AAPL | Stock | 24.7675 | 24.7675 | 24.7675 | 24.7675 | 400.0 |
| 2016-06-07 05:10:00 | AAPL | Stock | 24.7875 | 24.7875 | 24.7875 | 24.7875 | 400.0 |
| 2016-06-07 05:20:00 | AAPL | Stock | 24.79 | 24.79 | 24.79 | 24.79 | 3400.0 |
| 2016-06-07 05:45:00 | AAPL | Stock | 24.7975 | 24.8025 | 24.7975 | 24.8025 | 3724.0 |
| 2016-06-07 05:50:00 | AAPL | Stock | 24.8175 | 24.8175 | 24.8175 | 24.8175 | 400.0 |
| 2016-06-07 06:05:00 | AAPL | Stock | 24.84 | 24.84 | 24.84 | 24.84 | 1200.0 |
| 2016-06-07 06:15:00 | AAPL | Stock | 24.8375 | 24.8375 | 24.8375 | 24.8375 | 3200.0 |
| 2016-06-07 06:30:00 | AAPL | Stock | 24.8025 | 24.8025 | 24.79 | 24.7925 | 4528.0 |
| 2016-06-07 06:50:00 | AAPL | Stock | 24.7875 | 24.7875 | 24.7875 | 24.7875 | 7908.0 |
| 2016-06-07 06:55:00 | AAPL | Stock | 24.775 | 24.775 | 24.775 | 24.775 | 400.0 |
| 2016-06-07 07:00:00 | AAPL | Stock | 24.7825 | 24.7825 | 24.7675 | 24.7675 | 7608.0 |
| 2016-06-07 07:05:00 | AAPL | Stock | 24.775 | 24.775 | 24.77 | 24.77 | 8400.0 |
| 2016-06-07 07:15:00 | AAPL | Stock | 24.775 | 24.775 | 24.775 | 24.775 | 752.0 |
| 2016-06-07 07:20:00 | AAPL | Stock | 24.775 | 24.78 | 24.775 | 24.78 | 1220.0 |
| 2016-06-07 07:25:00 | AAPL | Stock | 24.765 | 24.7875 | 24.765 | 24.7875 | 11180.0 |
| 2016-06-07 07:30:00 | AAPL | Stock | 24.785 | 24.7875 | 24.785 | 24.785 | 4000.0 |
| 2016-06-07 07:35:00 | AAPL | Stock | 24.775 | 24.775 | 24.7675 | 24.7675 | 3032.0 |
| 2016-06-07 07:40:00 | AAPL | Stock | 24.7675 | 24.7675 | 24.76 | 24.76 | 23328.0 |
| 2016-06-07 07:45:00 | AAPL | Stock | 24.7725 | 24.775 | 24.7725 | 24.775 | 4800.0 |
| 2016-06-07 07:55:00 | AAPL | Stock | 24.775 | 24.775 | 24.775 | 24.775 | 10468.0 |
| 2016-06-07 08:00:00 | AAPL | Stock | 24.7875 | 24.795 | 24.7575 | 24.7875 | 78740.0 |
| 2016-06-07 08:05:00 | AAPL | Stock | 24.775 | 24.7825 | 24.775 | 24.78 | 21200.0 |
| 2016-06-07 08:10:00 | AAPL | Stock | 24.7825 | 24.7825 | 24.7575 | 24.7575 | 3760.0 |
| 2016-06-07 08:15:00 | AAPL | Stock | 24.7725 | 24.785 | 24.7725 | 24.785 | 8800.0 |
| 2016-06-07 08:20:00 | AAPL | Stock | 24.765 | 24.78 | 24.7625 | 24.7775 | 7720.0 |
| 2016-06-07 08:25:00 | AAPL | Stock | 24.765 | 24.775 | 24.7625 | 24.775 | 14920.0 |
| 2016-06-07 08:30:00 | AAPL | Stock | 24.775 | 24.775 | 24.775 | 24.775 | 4240.0 |
| 2016-06-07 08:35:00 | AAPL | Stock | 24.7625 | 24.7675 | 24.745 | 24.7525 | 52768.0 |
| 2016-06-07 08:40:00 | AAPL | Stock | 24.7625 | 24.7675 | 24.755 | 24.7675 | 13640.0 |
| 2016-06-07 08:45:00 | AAPL | Stock | 24.7625 | 24.7775 | 24.7625 | 24.7775 | 14400.0 |
| 2016-06-07 08:50:00 | AAPL | Stock | 24.775 | 24.775 | 24.7725 | 24.775 | 5600.0 |
| 2016-06-07 08:55:00 | AAPL | Stock | 24.7675 | 24.775 | 24.7625 | 24.7625 | 9712.0 |
| 2016-06-07 09:00:00 | AAPL | Stock | 24.7625 | 24.7625 | 24.76 | 24.7625 | 1200.0 |
| 2016-06-07 09:05:00 | AAPL | Stock | 24.755 | 24.765 | 24.7525 | 24.765 | 8336.0 |
| 2016-06-07 09:10:00 | AAPL | Stock | 24.755 | 24.755 | 24.7325 | 24.7325 | 30144.0 |
| 2016-06-07 09:15:00 | AAPL | Stock | 24.7425 | 24.745 | 24.7375 | 24.7375 | 6344.0 |
| 2016-06-07 09:20:00 | AAPL | Stock | 24.725 | 24.74 | 24.725 | 24.7375 | 13428.0 |
| 2016-06-07 09:25:00 | AAPL | Stock | 24.7375 | 24.825 | 24.7375 | 24.8125 | 88580.0 |
| 2016-06-07 09:30:00 | AAPL | Stock | 24.8125 | 24.885 | 24.8 | 24.8725 | 4380840.0 |
| 2016-06-07 09:35:00 | AAPL | Stock | 24.8725 | 24.91 | 24.86 | 24.905 | 2893316.0 |
| 2016-06-07 09:40:00 | AAPL | Stock | 24.905 | 24.9375 | 24.8825 | 24.8875 | 2092852.0 |
| 2016-06-07 09:45:00 | AAPL | Stock | 24.89 | 24.935 | 24.8585 | 24.9212 | 2279772.0 |
| 2016-06-07 09:50:00 | AAPL | Stock | 24.9225 | 24.95 | 24.9125 | 24.94 | 2112496.0 |
| 2016-06-07 09:55:00 | AAPL | Stock | 24.94 | 24.94 | 24.895 | 24.9375 | 1383840.0 |
| 2016-06-07 10:00:00 | AAPL | Stock | 24.94 | 24.9675 | 24.9175 | 24.9625 | 1833576.0 |
| 2016-06-07 10:05:00 | AAPL | Stock | 24.96 | 24.96 | 24.9275 | 24.9345 | 999476.0 |
| 2016-06-07 10:10:00 | AAPL | Stock | 24.9338 | 24.94 | 24.885 | 24.888 | 1215144.0 |
| 2016-06-07 10:15:00 | AAPL | Stock | 24.8878 | 24.9325 | 24.8878 | 24.9125 | 1485652.0 |
| 2016-06-07 10:20:00 | AAPL | Stock | 24.915 | 24.9275 | 24.9 | 24.9275 | 833960.0 |
> showing 50 of 362,103 rows — these rows as CSV