PREVIEW / stock_5min / 2016-12-14
file: by_date/stock_5min/2016/2016-12-14.parquet size: 5.6 MB rows: 366,673 symbols: 3,147
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-12-14 05:10:00 | AAPL | Stock | 28.8125 | 28.8125 | 28.8125 | 28.8125 | 1864.0 |
| 2016-12-14 05:20:00 | AAPL | Stock | 28.8 | 28.8 | 28.8 | 28.8 | 1000.0 |
| 2016-12-14 05:55:00 | AAPL | Stock | 28.815 | 28.815 | 28.815 | 28.815 | 2752.0 |
| 2016-12-14 06:30:00 | AAPL | Stock | 28.8 | 28.8 | 28.8 | 28.8 | 420.0 |
| 2016-12-14 06:35:00 | AAPL | Stock | 28.8 | 28.8 | 28.8 | 28.8 | 400.0 |
| 2016-12-14 07:00:00 | AAPL | Stock | 28.8475 | 28.8475 | 28.8475 | 28.8475 | 400.0 |
| 2016-12-14 07:05:00 | AAPL | Stock | 28.85 | 28.85 | 28.85 | 28.85 | 400.0 |
| 2016-12-14 07:10:00 | AAPL | Stock | 28.8525 | 28.86 | 28.8525 | 28.8575 | 3200.0 |
| 2016-12-14 07:15:00 | AAPL | Stock | 28.8625 | 28.8975 | 28.8625 | 28.8975 | 7944.0 |
| 2016-12-14 07:20:00 | AAPL | Stock | 28.855 | 28.855 | 28.8525 | 28.8525 | 2020.0 |
| 2016-12-14 07:25:00 | AAPL | Stock | 28.84 | 28.875 | 28.84 | 28.875 | 3808.0 |
| 2016-12-14 07:30:00 | AAPL | Stock | 28.8875 | 28.8875 | 28.8375 | 28.8725 | 7016.0 |
| 2016-12-14 07:35:00 | AAPL | Stock | 28.875 | 28.875 | 28.87 | 28.87 | 2228.0 |
| 2016-12-14 07:45:00 | AAPL | Stock | 28.8575 | 28.8725 | 28.8325 | 28.85 | 3160.0 |
| 2016-12-14 07:50:00 | AAPL | Stock | 28.8325 | 28.8325 | 28.8325 | 28.8325 | 2596.0 |
| 2016-12-14 07:55:00 | AAPL | Stock | 28.805 | 28.805 | 28.7575 | 28.8 | 10456.0 |
| 2016-12-14 08:00:00 | AAPL | Stock | 28.8125 | 28.8575 | 28.8125 | 28.85 | 59360.0 |
| 2016-12-14 08:05:00 | AAPL | Stock | 28.8375 | 28.8475 | 28.8225 | 28.8475 | 17176.0 |
| 2016-12-14 08:10:00 | AAPL | Stock | 28.8375 | 28.8375 | 28.8 | 28.8175 | 32488.0 |
| 2016-12-14 08:15:00 | AAPL | Stock | 28.81 | 28.8175 | 28.8 | 28.8 | 16400.0 |
| 2016-12-14 08:20:00 | AAPL | Stock | 28.8 | 28.8 | 28.7175 | 28.7175 | 76220.0 |
| 2016-12-14 08:25:00 | AAPL | Stock | 28.7075 | 28.7375 | 28.7075 | 28.7325 | 21952.0 |
| 2016-12-14 08:30:00 | AAPL | Stock | 28.725 | 28.74 | 28.72 | 28.7375 | 35004.0 |
| 2016-12-14 08:35:00 | AAPL | Stock | 28.75 | 28.7625 | 28.75 | 28.75 | 13700.0 |
| 2016-12-14 08:40:00 | AAPL | Stock | 28.75 | 28.75 | 28.7375 | 28.7375 | 13960.0 |
| 2016-12-14 08:45:00 | AAPL | Stock | 28.7375 | 28.745 | 28.73 | 28.745 | 6544.0 |
| 2016-12-14 08:50:00 | AAPL | Stock | 28.75 | 28.75 | 28.7375 | 28.74 | 15460.0 |
| 2016-12-14 08:55:00 | AAPL | Stock | 28.7475 | 28.75 | 28.745 | 28.75 | 22996.0 |
| 2016-12-14 09:00:00 | AAPL | Stock | 28.765 | 28.77 | 28.765 | 28.7675 | 11936.0 |
| 2016-12-14 09:05:00 | AAPL | Stock | 28.7675 | 28.77 | 28.7525 | 28.7525 | 7200.0 |
| 2016-12-14 09:10:00 | AAPL | Stock | 28.7525 | 28.7725 | 28.7525 | 28.7725 | 8740.0 |
| 2016-12-14 09:15:00 | AAPL | Stock | 28.7725 | 28.79 | 28.7725 | 28.79 | 14320.0 |
| 2016-12-14 09:20:00 | AAPL | Stock | 28.79 | 28.79 | 28.7825 | 28.7825 | 23696.0 |
| 2016-12-14 09:25:00 | AAPL | Stock | 28.7675 | 28.77 | 28.735 | 28.76 | 127392.0 |
| 2016-12-14 09:30:00 | AAPL | Stock | 28.76 | 28.9725 | 28.745 | 28.9525 | 5497940.0 |
| 2016-12-14 09:35:00 | AAPL | Stock | 28.9525 | 28.9938 | 28.8975 | 28.9275 | 3326292.0 |
| 2016-12-14 09:40:00 | AAPL | Stock | 28.93 | 29.025 | 28.9275 | 29.0212 | 3764816.0 |
| 2016-12-14 09:45:00 | AAPL | Stock | 29.0175 | 29.0225 | 28.855 | 28.96 | 2798596.0 |
| 2016-12-14 09:50:00 | AAPL | Stock | 28.9625 | 29.0225 | 28.9625 | 29.0 | 2156164.0 |
| 2016-12-14 09:55:00 | AAPL | Stock | 29.0012 | 29.05 | 28.9775 | 28.9925 | 2263216.0 |
| 2016-12-14 10:00:00 | AAPL | Stock | 28.995 | 29.0068 | 28.9525 | 28.975 | 1364324.0 |
| 2016-12-14 10:05:00 | AAPL | Stock | 28.9775 | 28.99 | 28.9675 | 28.9675 | 1171740.0 |
| 2016-12-14 10:10:00 | AAPL | Stock | 28.9688 | 29.0125 | 28.9675 | 28.9725 | 1327192.0 |
| 2016-12-14 10:15:00 | AAPL | Stock | 28.9725 | 29.0 | 28.96 | 28.9925 | 1130120.0 |
| 2016-12-14 10:20:00 | AAPL | Stock | 28.9925 | 29.0125 | 28.965 | 29.01 | 1836628.0 |
| 2016-12-14 10:25:00 | AAPL | Stock | 29.01 | 29.025 | 28.975 | 28.9875 | 1677240.0 |
| 2016-12-14 10:30:00 | AAPL | Stock | 28.99 | 29.015 | 28.965 | 28.9725 | 1444272.0 |
| 2016-12-14 10:35:00 | AAPL | Stock | 28.9725 | 28.98 | 28.92 | 28.9495 | 1515608.0 |
| 2016-12-14 10:40:00 | AAPL | Stock | 28.95 | 28.9675 | 28.915 | 28.9178 | 1017176.0 |
| 2016-12-14 10:45:00 | AAPL | Stock | 28.92 | 28.925 | 28.8925 | 28.9248 | 1089364.0 |
> showing 50 of 366,673 rows — these rows as CSV