PREVIEW / stock_5min / 2018-01-08
file: by_date/stock_5min/2018/2018-01-08.parquet size: 5.8 MB rows: 371,621 symbols: 2,910
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 |
|---|---|---|---|---|---|---|---|
| 2018-01-08 04:50:00 | AAPL | Stock | 43.775 | 43.775 | 43.775 | 43.775 | 764.0 |
| 2018-01-08 04:55:00 | AAPL | Stock | 43.775 | 43.775 | 43.775 | 43.775 | 1124.0 |
| 2018-01-08 06:40:00 | AAPL | Stock | 43.825 | 43.825 | 43.825 | 43.825 | 400.0 |
| 2018-01-08 06:50:00 | AAPL | Stock | 43.7725 | 43.7725 | 43.7725 | 43.7725 | 400.0 |
| 2018-01-08 06:55:00 | AAPL | Stock | 43.725 | 43.725 | 43.725 | 43.725 | 2084.0 |
| 2018-01-08 07:00:00 | AAPL | Stock | 43.7725 | 43.7725 | 43.74 | 43.7675 | 15248.0 |
| 2018-01-08 07:05:00 | AAPL | Stock | 43.755 | 43.755 | 43.75 | 43.75 | 14344.0 |
| 2018-01-08 07:10:00 | AAPL | Stock | 43.75 | 43.75 | 43.75 | 43.75 | 1708.0 |
| 2018-01-08 07:15:00 | AAPL | Stock | 43.74 | 43.75 | 43.74 | 43.75 | 3600.0 |
| 2018-01-08 07:20:00 | AAPL | Stock | 43.74 | 43.75 | 43.74 | 43.75 | 3300.0 |
| 2018-01-08 07:25:00 | AAPL | Stock | 43.7375 | 43.7375 | 43.7075 | 43.7075 | 13128.0 |
| 2018-01-08 07:30:00 | AAPL | Stock | 43.72 | 43.7225 | 43.72 | 43.7225 | 1620.0 |
| 2018-01-08 07:35:00 | AAPL | Stock | 43.705 | 43.705 | 43.705 | 43.705 | 800.0 |
| 2018-01-08 07:40:00 | AAPL | Stock | 43.705 | 43.705 | 43.705 | 43.705 | 3000.0 |
| 2018-01-08 07:45:00 | AAPL | Stock | 43.7075 | 43.7075 | 43.6875 | 43.6875 | 18460.0 |
| 2018-01-08 07:50:00 | AAPL | Stock | 43.7025 | 43.7025 | 43.7 | 43.7 | 2400.0 |
| 2018-01-08 07:55:00 | AAPL | Stock | 43.7025 | 43.7125 | 43.7025 | 43.7125 | 7192.0 |
| 2018-01-08 08:00:00 | AAPL | Stock | 43.755 | 43.77 | 43.69 | 43.7 | 43320.0 |
| 2018-01-08 08:05:00 | AAPL | Stock | 43.7 | 43.72 | 43.6875 | 43.72 | 14044.0 |
| 2018-01-08 08:10:00 | AAPL | Stock | 43.72 | 43.72 | 43.685 | 43.705 | 9308.0 |
| 2018-01-08 08:15:00 | AAPL | Stock | 43.7025 | 43.7025 | 43.69 | 43.69 | 2528.0 |
| 2018-01-08 08:20:00 | AAPL | Stock | 43.69 | 43.7025 | 43.6875 | 43.6875 | 4072.0 |
| 2018-01-08 08:25:00 | AAPL | Stock | 43.6875 | 43.6875 | 43.6325 | 43.65 | 31332.0 |
| 2018-01-08 08:30:00 | AAPL | Stock | 43.65 | 43.65 | 43.6275 | 43.6325 | 12884.0 |
| 2018-01-08 08:35:00 | AAPL | Stock | 43.63 | 43.6625 | 43.6275 | 43.6625 | 3644.0 |
| 2018-01-08 08:40:00 | AAPL | Stock | 43.6825 | 43.6825 | 43.665 | 43.68 | 17472.0 |
| 2018-01-08 08:45:00 | AAPL | Stock | 43.665 | 43.68 | 43.665 | 43.665 | 9772.0 |
| 2018-01-08 08:50:00 | AAPL | Stock | 43.665 | 43.6875 | 43.665 | 43.6875 | 20284.0 |
| 2018-01-08 08:55:00 | AAPL | Stock | 43.675 | 43.6875 | 43.675 | 43.6875 | 26284.0 |
| 2018-01-08 09:00:00 | AAPL | Stock | 43.6875 | 43.6875 | 43.665 | 43.675 | 19616.0 |
| 2018-01-08 09:05:00 | AAPL | Stock | 43.6825 | 43.6825 | 43.6575 | 43.6825 | 39004.0 |
| 2018-01-08 09:10:00 | AAPL | Stock | 43.6775 | 43.6825 | 43.6625 | 43.6625 | 7364.0 |
| 2018-01-08 09:15:00 | AAPL | Stock | 43.665 | 43.665 | 43.645 | 43.65 | 38436.0 |
| 2018-01-08 09:20:00 | AAPL | Stock | 43.655 | 43.655 | 43.6 | 43.6 | 29672.0 |
| 2018-01-08 09:25:00 | AAPL | Stock | 43.6125 | 43.64 | 43.5775 | 43.59 | 43364.0 |
| 2018-01-08 09:30:00 | AAPL | Stock | 43.5775 | 43.8975 | 43.5675 | 43.8362 | 4340408.0 |
| 2018-01-08 09:35:00 | AAPL | Stock | 43.8325 | 43.9025 | 43.7275 | 43.75 | 2060308.0 |
| 2018-01-08 09:40:00 | AAPL | Stock | 43.7463 | 43.77 | 43.7325 | 43.745 | 1504392.0 |
| 2018-01-08 09:45:00 | AAPL | Stock | 43.7475 | 43.755 | 43.6575 | 43.7125 | 1793880.0 |
| 2018-01-08 09:50:00 | AAPL | Stock | 43.7125 | 43.748 | 43.675 | 43.7375 | 1205764.0 |
| 2018-01-08 09:55:00 | AAPL | Stock | 43.735 | 43.7675 | 43.725 | 43.75 | 1178892.0 |
| 2018-01-08 10:00:00 | AAPL | Stock | 43.75 | 43.75 | 43.6875 | 43.7125 | 1192392.0 |
| 2018-01-08 10:05:00 | AAPL | Stock | 43.715 | 43.7425 | 43.6625 | 43.6725 | 1079932.0 |
| 2018-01-08 10:10:00 | AAPL | Stock | 43.6725 | 43.6725 | 43.6175 | 43.6692 | 1435288.0 |
| 2018-01-08 10:15:00 | AAPL | Stock | 43.668 | 43.7175 | 43.6625 | 43.6825 | 973460.0 |
| 2018-01-08 10:20:00 | AAPL | Stock | 43.6825 | 43.6875 | 43.6675 | 43.6795 | 625668.0 |
| 2018-01-08 10:25:00 | AAPL | Stock | 43.6825 | 43.7 | 43.6725 | 43.6962 | 985648.0 |
| 2018-01-08 10:30:00 | AAPL | Stock | 43.695 | 43.7738 | 43.6888 | 43.77 | 1188924.0 |
| 2018-01-08 10:35:00 | AAPL | Stock | 43.7675 | 43.773 | 43.73 | 43.73 | 756852.0 |
| 2018-01-08 10:40:00 | AAPL | Stock | 43.7335 | 43.7425 | 43.685 | 43.695 | 1184116.0 |
> showing 50 of 371,621 rows — these rows as CSV