PREVIEW / stock_5min / 2017-06-14
file: by_date/stock_5min/2017/2017-06-14.parquet size: 5.4 MB rows: 356,629 symbols: 3,029
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 |
|---|---|---|---|---|---|---|---|
| 2017-06-14 05:00:00 | AAPL | Stock | 36.745 | 36.745 | 36.745 | 36.745 | 400.0 |
| 2017-06-14 05:05:00 | AAPL | Stock | 36.7425 | 36.7425 | 36.7425 | 36.7425 | 800.0 |
| 2017-06-14 05:20:00 | AAPL | Stock | 36.75 | 36.75 | 36.75 | 36.75 | 800.0 |
| 2017-06-14 05:25:00 | AAPL | Stock | 36.8 | 36.8 | 36.8 | 36.8 | 2784.0 |
| 2017-06-14 05:30:00 | AAPL | Stock | 36.8 | 36.8 | 36.8 | 36.8 | 768.0 |
| 2017-06-14 05:40:00 | AAPL | Stock | 36.8175 | 36.8175 | 36.8175 | 36.8175 | 1304.0 |
| 2017-06-14 05:45:00 | AAPL | Stock | 36.8 | 36.8 | 36.7975 | 36.8 | 10168.0 |
| 2017-06-14 06:00:00 | AAPL | Stock | 36.755 | 36.755 | 36.755 | 36.755 | 800.0 |
| 2017-06-14 06:05:00 | AAPL | Stock | 36.7525 | 36.76 | 36.7525 | 36.76 | 3600.0 |
| 2017-06-14 06:10:00 | AAPL | Stock | 36.7775 | 36.7775 | 36.7775 | 36.7775 | 3304.0 |
| 2017-06-14 06:25:00 | AAPL | Stock | 36.8 | 36.8425 | 36.8 | 36.8425 | 3820.0 |
| 2017-06-14 06:35:00 | AAPL | Stock | 36.8025 | 36.8025 | 36.8025 | 36.8025 | 400.0 |
| 2017-06-14 06:40:00 | AAPL | Stock | 36.8025 | 36.81 | 36.8025 | 36.81 | 1552.0 |
| 2017-06-14 06:50:00 | AAPL | Stock | 36.805 | 36.805 | 36.805 | 36.805 | 2000.0 |
| 2017-06-14 06:55:00 | AAPL | Stock | 36.8125 | 36.8125 | 36.8125 | 36.8125 | 400.0 |
| 2017-06-14 07:00:00 | AAPL | Stock | 36.8125 | 36.8325 | 36.805 | 36.805 | 15336.0 |
| 2017-06-14 07:05:00 | AAPL | Stock | 36.825 | 36.8675 | 36.825 | 36.8375 | 16788.0 |
| 2017-06-14 07:10:00 | AAPL | Stock | 36.8375 | 36.8675 | 36.8375 | 36.86 | 5292.0 |
| 2017-06-14 07:15:00 | AAPL | Stock | 36.8675 | 36.8675 | 36.8675 | 36.8675 | 1200.0 |
| 2017-06-14 07:20:00 | AAPL | Stock | 36.8625 | 36.865 | 36.825 | 36.825 | 4328.0 |
| 2017-06-14 07:25:00 | AAPL | Stock | 36.84 | 36.84 | 36.84 | 36.84 | 2000.0 |
| 2017-06-14 07:30:00 | AAPL | Stock | 36.84 | 36.84 | 36.8175 | 36.8175 | 2568.0 |
| 2017-06-14 07:35:00 | AAPL | Stock | 36.8375 | 36.8375 | 36.815 | 36.815 | 8400.0 |
| 2017-06-14 07:40:00 | AAPL | Stock | 36.8225 | 36.825 | 36.8125 | 36.825 | 8920.0 |
| 2017-06-14 07:45:00 | AAPL | Stock | 36.825 | 36.8375 | 36.825 | 36.8375 | 3524.0 |
| 2017-06-14 07:50:00 | AAPL | Stock | 36.825 | 36.825 | 36.8225 | 36.8225 | 3512.0 |
| 2017-06-14 07:55:00 | AAPL | Stock | 36.82 | 36.82 | 36.8175 | 36.8175 | 9300.0 |
| 2017-06-14 08:00:00 | AAPL | Stock | 36.835 | 36.8675 | 36.775 | 36.7875 | 29900.0 |
| 2017-06-14 08:05:00 | AAPL | Stock | 36.795 | 36.795 | 36.76 | 36.785 | 13896.0 |
| 2017-06-14 08:10:00 | AAPL | Stock | 36.775 | 36.795 | 36.76 | 36.795 | 7820.0 |
| 2017-06-14 08:15:00 | AAPL | Stock | 36.7775 | 36.7775 | 36.7575 | 36.7575 | 5600.0 |
| 2017-06-14 08:20:00 | AAPL | Stock | 36.76 | 36.765 | 36.7375 | 36.75 | 32144.0 |
| 2017-06-14 08:25:00 | AAPL | Stock | 36.75 | 36.76 | 36.7375 | 36.7375 | 22260.0 |
| 2017-06-14 08:30:00 | AAPL | Stock | 36.745 | 36.7475 | 36.725 | 36.7375 | 11404.0 |
| 2017-06-14 08:35:00 | AAPL | Stock | 36.7175 | 36.775 | 36.7125 | 36.75 | 39444.0 |
| 2017-06-14 08:40:00 | AAPL | Stock | 36.775 | 36.8175 | 36.775 | 36.8025 | 30488.0 |
| 2017-06-14 08:45:00 | AAPL | Stock | 36.8175 | 36.8225 | 36.8175 | 36.8175 | 43368.0 |
| 2017-06-14 08:50:00 | AAPL | Stock | 36.82 | 36.82 | 36.7975 | 36.7975 | 17108.0 |
| 2017-06-14 08:55:00 | AAPL | Stock | 36.7975 | 36.7975 | 36.7525 | 36.7725 | 8680.0 |
| 2017-06-14 09:00:00 | AAPL | Stock | 36.7725 | 36.8125 | 36.75 | 36.8125 | 51376.0 |
| 2017-06-14 09:05:00 | AAPL | Stock | 36.8125 | 36.8125 | 36.79 | 36.79 | 12340.0 |
| 2017-06-14 09:10:00 | AAPL | Stock | 36.79 | 36.8 | 36.785 | 36.8 | 13716.0 |
| 2017-06-14 09:15:00 | AAPL | Stock | 36.7975 | 36.8 | 36.795 | 36.8 | 5572.0 |
| 2017-06-14 09:20:00 | AAPL | Stock | 36.8 | 36.81 | 36.795 | 36.8 | 27776.0 |
| 2017-06-14 09:25:00 | AAPL | Stock | 36.8 | 36.875 | 36.7675 | 36.8725 | 111028.0 |
| 2017-06-14 09:30:00 | AAPL | Stock | 36.87 | 36.875 | 36.6775 | 36.725 | 3616412.0 |
| 2017-06-14 09:35:00 | AAPL | Stock | 36.725 | 36.725 | 36.5675 | 36.57 | 2038296.0 |
| 2017-06-14 09:40:00 | AAPL | Stock | 36.5737 | 36.6525 | 36.5275 | 36.5672 | 2204132.0 |
| 2017-06-14 09:45:00 | AAPL | Stock | 36.57 | 36.6775 | 36.5675 | 36.604 | 1548872.0 |
| 2017-06-14 09:50:00 | AAPL | Stock | 36.6038 | 36.6475 | 36.5425 | 36.625 | 1057052.0 |
> showing 50 of 356,629 rows — these rows as CSV