PREVIEW / stock_5min / 2021-11-11
file: by_date/stock_5min/2021/2021-11-11.parquet size: 7.4 MB rows: 459,074 symbols: 2,675
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 |
|---|---|---|---|---|---|---|---|
| 2021-11-11 04:00:00 | AAPL | Stock | 148.21 | 148.21 | 148.1 | 148.15 | 1696.0 |
| 2021-11-11 04:05:00 | AAPL | Stock | 148.18 | 148.25 | 148.14 | 148.2 | 2071.0 |
| 2021-11-11 04:10:00 | AAPL | Stock | 148.29 | 148.32 | 148.2 | 148.32 | 7151.0 |
| 2021-11-11 04:15:00 | AAPL | Stock | 148.3 | 148.6 | 148.3 | 148.6 | 11952.0 |
| 2021-11-11 04:20:00 | AAPL | Stock | 148.52 | 148.52 | 148.36 | 148.36 | 300.0 |
| 2021-11-11 04:25:00 | AAPL | Stock | 148.52 | 148.52 | 148.52 | 148.52 | 103.0 |
| 2021-11-11 04:30:00 | AAPL | Stock | 148.58 | 148.58 | 148.58 | 148.58 | 450.0 |
| 2021-11-11 04:35:00 | AAPL | Stock | 148.58 | 148.75 | 148.55 | 148.75 | 5236.0 |
| 2021-11-11 04:40:00 | AAPL | Stock | 148.7 | 148.7 | 148.58 | 148.58 | 2661.0 |
| 2021-11-11 04:45:00 | AAPL | Stock | 148.6 | 148.61 | 148.6 | 148.61 | 806.0 |
| 2021-11-11 04:50:00 | AAPL | Stock | 148.65 | 148.65 | 148.65 | 148.65 | 173.0 |
| 2021-11-11 04:55:00 | AAPL | Stock | 148.69 | 148.7 | 148.66 | 148.67 | 2918.0 |
| 2021-11-11 05:00:00 | AAPL | Stock | 148.7 | 148.7 | 148.62 | 148.62 | 1393.0 |
| 2021-11-11 05:05:00 | AAPL | Stock | 148.67 | 148.67 | 148.67 | 148.67 | 1262.0 |
| 2021-11-11 05:10:00 | AAPL | Stock | 148.67 | 148.67 | 148.67 | 148.67 | 200.0 |
| 2021-11-11 05:15:00 | AAPL | Stock | 148.67 | 148.68 | 148.6 | 148.6 | 1621.0 |
| 2021-11-11 05:20:00 | AAPL | Stock | 148.6 | 148.6 | 148.6 | 148.6 | 373.0 |
| 2021-11-11 05:25:00 | AAPL | Stock | 148.6 | 148.6 | 148.6 | 148.6 | 841.0 |
| 2021-11-11 05:30:00 | AAPL | Stock | 148.6 | 148.65 | 148.59 | 148.65 | 10513.0 |
| 2021-11-11 05:35:00 | AAPL | Stock | 148.6 | 148.6 | 148.38 | 148.38 | 1215.0 |
| 2021-11-11 05:40:00 | AAPL | Stock | 148.59 | 148.59 | 148.51 | 148.51 | 602.0 |
| 2021-11-11 05:50:00 | AAPL | Stock | 148.57 | 148.57 | 148.57 | 148.57 | 364.0 |
| 2021-11-11 05:55:00 | AAPL | Stock | 148.57 | 148.57 | 148.57 | 148.57 | 300.0 |
| 2021-11-11 06:00:00 | AAPL | Stock | 148.63 | 148.63 | 148.57 | 148.57 | 944.0 |
| 2021-11-11 06:15:00 | AAPL | Stock | 148.59 | 148.63 | 148.59 | 148.63 | 1235.0 |
| 2021-11-11 06:20:00 | AAPL | Stock | 148.55 | 148.55 | 148.55 | 148.55 | 417.0 |
| 2021-11-11 06:25:00 | AAPL | Stock | 148.51 | 148.55 | 148.51 | 148.55 | 599.0 |
| 2021-11-11 06:30:00 | AAPL | Stock | 148.59 | 148.66 | 148.59 | 148.66 | 499.0 |
| 2021-11-11 06:35:00 | AAPL | Stock | 148.6 | 148.67 | 148.59 | 148.67 | 632.0 |
| 2021-11-11 06:40:00 | AAPL | Stock | 148.66 | 148.66 | 148.66 | 148.66 | 442.0 |
| 2021-11-11 06:50:00 | AAPL | Stock | 148.64 | 148.74 | 148.64 | 148.74 | 1204.0 |
| 2021-11-11 06:55:00 | AAPL | Stock | 148.69 | 148.69 | 148.68 | 148.68 | 814.0 |
| 2021-11-11 07:00:00 | AAPL | Stock | 148.69 | 148.73 | 148.68 | 148.71 | 7374.0 |
| 2021-11-11 07:05:00 | AAPL | Stock | 148.75 | 148.78 | 148.7 | 148.75 | 4134.0 |
| 2021-11-11 07:10:00 | AAPL | Stock | 148.74 | 148.78 | 148.68 | 148.73 | 4586.0 |
| 2021-11-11 07:15:00 | AAPL | Stock | 148.67 | 148.71 | 148.61 | 148.61 | 2273.0 |
| 2021-11-11 07:20:00 | AAPL | Stock | 148.66 | 148.69 | 148.64 | 148.65 | 900.0 |
| 2021-11-11 07:25:00 | AAPL | Stock | 148.67 | 148.68 | 148.64 | 148.65 | 3189.0 |
| 2021-11-11 07:30:00 | AAPL | Stock | 148.65 | 148.68 | 148.51 | 148.53 | 17662.0 |
| 2021-11-11 07:35:00 | AAPL | Stock | 148.55 | 148.57 | 148.41 | 148.52 | 11932.0 |
| 2021-11-11 07:40:00 | AAPL | Stock | 148.5 | 148.56 | 148.46 | 148.56 | 6934.0 |
| 2021-11-11 07:45:00 | AAPL | Stock | 148.58 | 148.63 | 148.56 | 148.62 | 5611.0 |
| 2021-11-11 07:50:00 | AAPL | Stock | 148.62 | 148.73 | 148.62 | 148.63 | 5832.0 |
| 2021-11-11 07:55:00 | AAPL | Stock | 148.63 | 148.68 | 148.6 | 148.65 | 10705.0 |
| 2021-11-11 08:00:00 | AAPL | Stock | 148.65 | 148.77 | 147.551 | 148.58 | 79236.0 |
| 2021-11-11 08:05:00 | AAPL | Stock | 148.6 | 148.63 | 148.58 | 148.6 | 7617.0 |
| 2021-11-11 08:10:00 | AAPL | Stock | 148.6 | 148.61 | 148.57 | 148.58 | 6587.0 |
| 2021-11-11 08:15:00 | AAPL | Stock | 148.58 | 148.62 | 148.56 | 148.62 | 2769.0 |
| 2021-11-11 08:20:00 | AAPL | Stock | 148.6 | 148.67 | 148.6 | 148.61 | 9756.0 |
| 2021-11-11 08:25:00 | AAPL | Stock | 148.61 | 148.65 | 148.57 | 148.63 | 11885.0 |
> showing 50 of 459,074 rows — these rows as CSV