PREVIEW / stock_5min / 2019-05-31
file: by_date/stock_5min/2019/2019-05-31.parquet size: 5.7 MB rows: 369,352 symbols: 2,610
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 |
|---|---|---|---|---|---|---|---|
| 2019-05-31 04:00:00 | AAPL | Stock | 43.8 | 43.8375 | 43.8 | 43.825 | 7012.0 |
| 2019-05-31 04:05:00 | AAPL | Stock | 43.9075 | 43.9075 | 43.9075 | 43.9075 | 2284.0 |
| 2019-05-31 04:10:00 | AAPL | Stock | 43.8225 | 43.8475 | 43.8225 | 43.8475 | 3476.0 |
| 2019-05-31 04:15:00 | AAPL | Stock | 43.8675 | 43.8675 | 43.8675 | 43.8675 | 400.0 |
| 2019-05-31 04:20:00 | AAPL | Stock | 43.835 | 43.8425 | 43.8125 | 43.8425 | 6440.0 |
| 2019-05-31 04:25:00 | AAPL | Stock | 43.8525 | 43.8525 | 43.8075 | 43.8075 | 3556.0 |
| 2019-05-31 04:30:00 | AAPL | Stock | 43.8125 | 43.85 | 43.8125 | 43.85 | 1308.0 |
| 2019-05-31 04:35:00 | AAPL | Stock | 43.8475 | 43.8575 | 43.8475 | 43.8575 | 856.0 |
| 2019-05-31 04:45:00 | AAPL | Stock | 43.8475 | 43.8475 | 43.8475 | 43.8475 | 400.0 |
| 2019-05-31 05:05:00 | AAPL | Stock | 43.8675 | 43.875 | 43.8275 | 43.8275 | 1600.0 |
| 2019-05-31 05:10:00 | AAPL | Stock | 43.8275 | 43.8275 | 43.8275 | 43.8275 | 1240.0 |
| 2019-05-31 05:15:00 | AAPL | Stock | 43.8275 | 43.8275 | 43.8 | 43.8 | 6420.0 |
| 2019-05-31 05:20:00 | AAPL | Stock | 43.8 | 43.8 | 43.8 | 43.8 | 400.0 |
| 2019-05-31 05:25:00 | AAPL | Stock | 43.8125 | 43.8125 | 43.765 | 43.765 | 4800.0 |
| 2019-05-31 05:30:00 | AAPL | Stock | 43.75 | 43.75 | 43.75 | 43.75 | 800.0 |
| 2019-05-31 05:35:00 | AAPL | Stock | 43.75 | 43.75 | 43.7 | 43.7 | 11856.0 |
| 2019-05-31 05:40:00 | AAPL | Stock | 43.7175 | 43.72 | 43.62 | 43.6525 | 18928.0 |
| 2019-05-31 05:45:00 | AAPL | Stock | 43.6525 | 43.6675 | 43.6275 | 43.6275 | 5744.0 |
| 2019-05-31 05:50:00 | AAPL | Stock | 43.65 | 43.67 | 43.6275 | 43.67 | 6440.0 |
| 2019-05-31 05:55:00 | AAPL | Stock | 43.6675 | 43.6675 | 43.6675 | 43.6675 | 800.0 |
| 2019-05-31 06:10:00 | AAPL | Stock | 43.6875 | 43.6925 | 43.6875 | 43.6925 | 2800.0 |
| 2019-05-31 06:15:00 | AAPL | Stock | 43.69 | 43.69 | 43.6 | 43.6 | 3040.0 |
| 2019-05-31 06:20:00 | AAPL | Stock | 43.6425 | 43.67 | 43.6425 | 43.67 | 2380.0 |
| 2019-05-31 06:25:00 | AAPL | Stock | 43.7125 | 43.7225 | 43.7125 | 43.72 | 3200.0 |
| 2019-05-31 06:30:00 | AAPL | Stock | 43.7175 | 43.7175 | 43.7175 | 43.7175 | 400.0 |
| 2019-05-31 06:35:00 | AAPL | Stock | 43.65 | 43.65 | 43.625 | 43.625 | 2036.0 |
| 2019-05-31 06:40:00 | AAPL | Stock | 43.6625 | 43.6625 | 43.6625 | 43.6625 | 800.0 |
| 2019-05-31 06:45:00 | AAPL | Stock | 43.7175 | 43.7175 | 43.7 | 43.7 | 2400.0 |
| 2019-05-31 06:50:00 | AAPL | Stock | 43.7225 | 43.75 | 43.68 | 43.75 | 4472.0 |
| 2019-05-31 06:55:00 | AAPL | Stock | 43.75 | 43.75 | 43.75 | 43.75 | 4988.0 |
| 2019-05-31 07:00:00 | AAPL | Stock | 43.725 | 43.875 | 43.7025 | 43.8375 | 64008.0 |
| 2019-05-31 07:05:00 | AAPL | Stock | 43.825 | 43.8375 | 43.8125 | 43.835 | 24220.0 |
| 2019-05-31 07:10:00 | AAPL | Stock | 43.835 | 43.835 | 43.8125 | 43.825 | 5224.0 |
| 2019-05-31 07:15:00 | AAPL | Stock | 43.825 | 43.8475 | 43.7575 | 43.7575 | 22588.0 |
| 2019-05-31 07:20:00 | AAPL | Stock | 43.7925 | 43.8125 | 43.775 | 43.8075 | 8072.0 |
| 2019-05-31 07:25:00 | AAPL | Stock | 43.8075 | 43.9 | 43.8075 | 43.9 | 24080.0 |
| 2019-05-31 07:30:00 | AAPL | Stock | 43.9475 | 43.95 | 43.8925 | 43.8925 | 6448.0 |
| 2019-05-31 07:35:00 | AAPL | Stock | 43.935 | 43.95 | 43.8875 | 43.92 | 11628.0 |
| 2019-05-31 07:40:00 | AAPL | Stock | 43.9125 | 43.965 | 43.875 | 43.8775 | 12932.0 |
| 2019-05-31 07:45:00 | AAPL | Stock | 43.89 | 43.89 | 43.87 | 43.8875 | 9328.0 |
| 2019-05-31 07:50:00 | AAPL | Stock | 43.9 | 43.9 | 43.8625 | 43.8775 | 14064.0 |
| 2019-05-31 07:55:00 | AAPL | Stock | 43.875 | 43.89 | 43.8425 | 43.875 | 17984.0 |
| 2019-05-31 08:00:00 | AAPL | Stock | 43.805 | 43.95 | 43.7625 | 43.7675 | 95308.0 |
| 2019-05-31 08:05:00 | AAPL | Stock | 43.765 | 43.8225 | 43.7625 | 43.8225 | 12832.0 |
| 2019-05-31 08:10:00 | AAPL | Stock | 43.78 | 43.85 | 43.78 | 43.85 | 7964.0 |
| 2019-05-31 08:15:00 | AAPL | Stock | 43.87 | 43.875 | 43.7725 | 43.775 | 38164.0 |
| 2019-05-31 08:20:00 | AAPL | Stock | 43.7925 | 43.825 | 43.775 | 43.7875 | 34720.0 |
| 2019-05-31 08:25:00 | AAPL | Stock | 43.8025 | 43.8875 | 43.8025 | 43.875 | 7208.0 |
| 2019-05-31 08:30:00 | AAPL | Stock | 43.8675 | 43.9725 | 43.8675 | 43.9675 | 41096.0 |
| 2019-05-31 08:35:00 | AAPL | Stock | 43.9375 | 43.9975 | 43.875 | 43.9 | 18904.0 |
> showing 50 of 369,352 rows — these rows as CSV