PREVIEW / stock_5min / 2018-02-20
file: by_date/stock_5min/2018/2018-02-20.parquet size: 5.6 MB rows: 360,903 symbols: 2,891
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-02-20 04:00:00 | AAPL | Stock | 42.775 | 42.875 | 42.775 | 42.85 | 10404.0 |
| 2018-02-20 04:05:00 | AAPL | Stock | 42.84 | 42.84 | 42.825 | 42.825 | 2800.0 |
| 2018-02-20 04:10:00 | AAPL | Stock | 42.9 | 42.9 | 42.875 | 42.875 | 2000.0 |
| 2018-02-20 04:15:00 | AAPL | Stock | 42.85 | 42.85 | 42.7525 | 42.8 | 7620.0 |
| 2018-02-20 04:20:00 | AAPL | Stock | 42.8 | 42.8 | 42.7675 | 42.7675 | 2400.0 |
| 2018-02-20 04:25:00 | AAPL | Stock | 42.775 | 42.775 | 42.775 | 42.775 | 1600.0 |
| 2018-02-20 04:30:00 | AAPL | Stock | 42.775 | 42.775 | 42.775 | 42.775 | 400.0 |
| 2018-02-20 04:35:00 | AAPL | Stock | 42.765 | 42.765 | 42.71 | 42.71 | 8400.0 |
| 2018-02-20 04:40:00 | AAPL | Stock | 42.7025 | 42.75 | 42.7025 | 42.75 | 2760.0 |
| 2018-02-20 04:45:00 | AAPL | Stock | 42.7475 | 42.75 | 42.7025 | 42.7025 | 2784.0 |
| 2018-02-20 04:50:00 | AAPL | Stock | 42.7025 | 42.7025 | 42.7025 | 42.7025 | 800.0 |
| 2018-02-20 04:55:00 | AAPL | Stock | 42.7 | 42.7 | 42.7 | 42.7 | 400.0 |
| 2018-02-20 05:00:00 | AAPL | Stock | 42.7 | 42.7 | 42.555 | 42.555 | 10000.0 |
| 2018-02-20 05:05:00 | AAPL | Stock | 42.56 | 42.595 | 42.545 | 42.5925 | 13920.0 |
| 2018-02-20 05:10:00 | AAPL | Stock | 42.575 | 42.5825 | 42.575 | 42.5825 | 11300.0 |
| 2018-02-20 05:15:00 | AAPL | Stock | 42.58 | 42.58 | 42.58 | 42.58 | 4000.0 |
| 2018-02-20 05:20:00 | AAPL | Stock | 42.5825 | 42.595 | 42.5825 | 42.595 | 7308.0 |
| 2018-02-20 05:25:00 | AAPL | Stock | 42.675 | 42.6775 | 42.67 | 42.675 | 28656.0 |
| 2018-02-20 05:30:00 | AAPL | Stock | 42.68 | 42.68 | 42.625 | 42.65 | 1380.0 |
| 2018-02-20 05:35:00 | AAPL | Stock | 42.6525 | 42.6575 | 42.6525 | 42.6575 | 2800.0 |
| 2018-02-20 05:40:00 | AAPL | Stock | 42.6025 | 42.6275 | 42.6025 | 42.6275 | 10940.0 |
| 2018-02-20 05:45:00 | AAPL | Stock | 42.6925 | 42.6925 | 42.6925 | 42.6925 | 400.0 |
| 2018-02-20 05:50:00 | AAPL | Stock | 42.695 | 42.695 | 42.675 | 42.675 | 8108.0 |
| 2018-02-20 05:55:00 | AAPL | Stock | 42.65 | 42.675 | 42.65 | 42.675 | 24652.0 |
| 2018-02-20 06:00:00 | AAPL | Stock | 42.725 | 42.7375 | 42.675 | 42.7125 | 17840.0 |
| 2018-02-20 06:05:00 | AAPL | Stock | 42.7 | 42.7 | 42.65 | 42.6875 | 13228.0 |
| 2018-02-20 06:10:00 | AAPL | Stock | 42.7 | 42.7175 | 42.7 | 42.7125 | 12592.0 |
| 2018-02-20 06:15:00 | AAPL | Stock | 42.7075 | 42.7075 | 42.7075 | 42.7075 | 3140.0 |
| 2018-02-20 06:20:00 | AAPL | Stock | 42.7 | 42.7 | 42.65 | 42.65 | 15600.0 |
| 2018-02-20 06:25:00 | AAPL | Stock | 42.6875 | 42.6875 | 42.6475 | 42.665 | 11200.0 |
| 2018-02-20 06:30:00 | AAPL | Stock | 42.675 | 42.6875 | 42.675 | 42.6875 | 6400.0 |
| 2018-02-20 06:35:00 | AAPL | Stock | 42.685 | 42.6875 | 42.655 | 42.655 | 2104.0 |
| 2018-02-20 06:40:00 | AAPL | Stock | 42.71 | 42.735 | 42.71 | 42.725 | 8872.0 |
| 2018-02-20 06:45:00 | AAPL | Stock | 42.7275 | 42.7275 | 42.7275 | 42.7275 | 1200.0 |
| 2018-02-20 06:50:00 | AAPL | Stock | 42.7 | 42.7475 | 42.7 | 42.7475 | 7828.0 |
| 2018-02-20 07:00:00 | AAPL | Stock | 42.7475 | 42.825 | 42.725 | 42.825 | 33016.0 |
| 2018-02-20 07:05:00 | AAPL | Stock | 42.8475 | 42.92 | 42.8375 | 42.865 | 97728.0 |
| 2018-02-20 07:10:00 | AAPL | Stock | 42.865 | 42.9 | 42.865 | 42.865 | 14624.0 |
| 2018-02-20 07:15:00 | AAPL | Stock | 42.8625 | 42.8625 | 42.825 | 42.83 | 17800.0 |
| 2018-02-20 07:20:00 | AAPL | Stock | 42.8375 | 42.84 | 42.805 | 42.805 | 14776.0 |
| 2018-02-20 07:25:00 | AAPL | Stock | 42.805 | 42.825 | 42.775 | 42.8125 | 23168.0 |
| 2018-02-20 07:30:00 | AAPL | Stock | 42.8275 | 42.8275 | 42.8125 | 42.82 | 13132.0 |
| 2018-02-20 07:35:00 | AAPL | Stock | 42.8275 | 42.86 | 42.825 | 42.86 | 24712.0 |
| 2018-02-20 07:40:00 | AAPL | Stock | 42.865 | 42.87 | 42.8375 | 42.87 | 16644.0 |
| 2018-02-20 07:45:00 | AAPL | Stock | 42.8725 | 42.9 | 42.87 | 42.8975 | 36904.0 |
| 2018-02-20 07:50:00 | AAPL | Stock | 42.9 | 42.92 | 42.9 | 42.9025 | 43616.0 |
| 2018-02-20 07:55:00 | AAPL | Stock | 42.9125 | 42.935 | 42.9125 | 42.9225 | 13700.0 |
| 2018-02-20 08:00:00 | AAPL | Stock | 42.915 | 42.9375 | 42.735 | 42.88 | 151704.0 |
| 2018-02-20 08:05:00 | AAPL | Stock | 42.88 | 42.8875 | 42.8525 | 42.875 | 62976.0 |
| 2018-02-20 08:10:00 | AAPL | Stock | 42.875 | 42.91 | 42.8625 | 42.875 | 50252.0 |
> showing 50 of 360,903 rows — these rows as CSV