PREVIEW / stock_5min / 2018-11-26
file: by_date/stock_5min/2018/2018-11-26.parquet size: 5.6 MB rows: 354,707 symbols: 2,745
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-11-26 04:00:00 | AAPL | Stock | 43.6375 | 43.8325 | 43.6375 | 43.79 | 37588.0 |
| 2018-11-26 04:05:00 | AAPL | Stock | 43.7625 | 43.8075 | 43.7625 | 43.8075 | 4676.0 |
| 2018-11-26 04:10:00 | AAPL | Stock | 43.81 | 43.87 | 43.805 | 43.8625 | 8232.0 |
| 2018-11-26 04:15:00 | AAPL | Stock | 43.85 | 43.875 | 43.85 | 43.875 | 1200.0 |
| 2018-11-26 04:20:00 | AAPL | Stock | 43.875 | 43.875 | 43.85 | 43.85 | 1600.0 |
| 2018-11-26 04:25:00 | AAPL | Stock | 43.875 | 43.875 | 43.85 | 43.8725 | 4000.0 |
| 2018-11-26 04:30:00 | AAPL | Stock | 43.8975 | 43.8975 | 43.845 | 43.85 | 13240.0 |
| 2018-11-26 04:35:00 | AAPL | Stock | 43.8625 | 43.8625 | 43.85 | 43.85 | 2624.0 |
| 2018-11-26 04:40:00 | AAPL | Stock | 43.8375 | 43.85 | 43.835 | 43.8375 | 8932.0 |
| 2018-11-26 04:45:00 | AAPL | Stock | 43.8625 | 43.8625 | 43.8625 | 43.8625 | 400.0 |
| 2018-11-26 04:50:00 | AAPL | Stock | 43.85 | 43.85 | 43.85 | 43.85 | 400.0 |
| 2018-11-26 04:55:00 | AAPL | Stock | 43.85 | 43.875 | 43.85 | 43.875 | 2000.0 |
| 2018-11-26 05:00:00 | AAPL | Stock | 43.9 | 43.9 | 43.9 | 43.9 | 1096.0 |
| 2018-11-26 05:05:00 | AAPL | Stock | 43.895 | 43.8975 | 43.895 | 43.8975 | 5340.0 |
| 2018-11-26 05:10:00 | AAPL | Stock | 43.8425 | 43.9 | 43.8425 | 43.875 | 2000.0 |
| 2018-11-26 05:20:00 | AAPL | Stock | 43.86 | 43.86 | 43.86 | 43.86 | 400.0 |
| 2018-11-26 05:25:00 | AAPL | Stock | 43.855 | 43.855 | 43.845 | 43.85 | 2400.0 |
| 2018-11-26 05:30:00 | AAPL | Stock | 43.8375 | 43.9975 | 43.7525 | 43.95 | 25528.0 |
| 2018-11-26 05:35:00 | AAPL | Stock | 43.9825 | 43.9825 | 43.875 | 43.875 | 7760.0 |
| 2018-11-26 05:40:00 | AAPL | Stock | 43.875 | 43.875 | 43.875 | 43.875 | 1840.0 |
| 2018-11-26 05:45:00 | AAPL | Stock | 43.855 | 43.855 | 43.855 | 43.855 | 400.0 |
| 2018-11-26 05:50:00 | AAPL | Stock | 43.875 | 43.8875 | 43.875 | 43.875 | 6260.0 |
| 2018-11-26 05:55:00 | AAPL | Stock | 43.855 | 43.855 | 43.85 | 43.85 | 7780.0 |
| 2018-11-26 06:00:00 | AAPL | Stock | 43.9 | 43.9 | 43.9 | 43.9 | 412.0 |
| 2018-11-26 06:05:00 | AAPL | Stock | 43.9 | 43.9175 | 43.8625 | 43.875 | 6472.0 |
| 2018-11-26 06:10:00 | AAPL | Stock | 43.8425 | 43.875 | 43.8375 | 43.85 | 7976.0 |
| 2018-11-26 06:15:00 | AAPL | Stock | 43.8625 | 43.9 | 43.8625 | 43.9 | 3400.0 |
| 2018-11-26 06:20:00 | AAPL | Stock | 43.88 | 43.905 | 43.875 | 43.875 | 2400.0 |
| 2018-11-26 06:25:00 | AAPL | Stock | 43.9 | 43.9 | 43.9 | 43.9 | 1200.0 |
| 2018-11-26 06:30:00 | AAPL | Stock | 43.91 | 43.95 | 43.91 | 43.925 | 5980.0 |
| 2018-11-26 06:35:00 | AAPL | Stock | 43.92 | 43.92 | 43.92 | 43.92 | 400.0 |
| 2018-11-26 06:40:00 | AAPL | Stock | 43.85 | 43.8925 | 43.85 | 43.8925 | 1200.0 |
| 2018-11-26 06:50:00 | AAPL | Stock | 43.8925 | 43.91 | 43.8925 | 43.91 | 1520.0 |
| 2018-11-26 06:55:00 | AAPL | Stock | 43.8775 | 43.915 | 43.8775 | 43.9125 | 4268.0 |
| 2018-11-26 07:00:00 | AAPL | Stock | 43.88 | 43.9 | 43.68 | 43.6875 | 83836.0 |
| 2018-11-26 07:05:00 | AAPL | Stock | 43.68 | 43.68 | 43.575 | 43.6025 | 109872.0 |
| 2018-11-26 07:10:00 | AAPL | Stock | 43.605 | 43.6625 | 43.605 | 43.64 | 60156.0 |
| 2018-11-26 07:15:00 | AAPL | Stock | 43.6675 | 43.6725 | 43.5725 | 43.595 | 10800.0 |
| 2018-11-26 07:20:00 | AAPL | Stock | 43.565 | 43.7125 | 43.565 | 43.705 | 89840.0 |
| 2018-11-26 07:25:00 | AAPL | Stock | 43.695 | 43.695 | 43.6025 | 43.6025 | 18760.0 |
| 2018-11-26 07:30:00 | AAPL | Stock | 43.6025 | 43.6025 | 43.525 | 43.55 | 65372.0 |
| 2018-11-26 07:35:00 | AAPL | Stock | 43.575 | 43.625 | 43.575 | 43.62 | 40316.0 |
| 2018-11-26 07:40:00 | AAPL | Stock | 43.6025 | 43.65 | 43.6 | 43.6375 | 38040.0 |
| 2018-11-26 07:45:00 | AAPL | Stock | 43.665 | 43.665 | 43.6125 | 43.65 | 35396.0 |
| 2018-11-26 07:50:00 | AAPL | Stock | 43.65 | 43.65 | 43.6225 | 43.625 | 14888.0 |
| 2018-11-26 07:55:00 | AAPL | Stock | 43.6275 | 43.6575 | 43.6025 | 43.625 | 70576.0 |
| 2018-11-26 08:00:00 | AAPL | Stock | 43.64 | 43.875 | 43.5125 | 43.7 | 306672.0 |
| 2018-11-26 08:05:00 | AAPL | Stock | 43.69 | 43.7025 | 43.6475 | 43.6475 | 26660.0 |
| 2018-11-26 08:10:00 | AAPL | Stock | 43.675 | 43.6825 | 43.625 | 43.6375 | 41144.0 |
| 2018-11-26 08:15:00 | AAPL | Stock | 43.6375 | 43.675 | 43.615 | 43.6575 | 48760.0 |
> showing 50 of 354,707 rows — these rows as CSV