PREVIEW / stock_5min / 2021-12-22
file: by_date/stock_5min/2021/2021-12-22.parquet size: 7.4 MB rows: 451,119 symbols: 2,654
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-12-22 04:00:00 | AAPL | Stock | 172.29 | 172.48 | 172.0 | 172.39 | 3180.0 |
| 2021-12-22 04:05:00 | AAPL | Stock | 172.41 | 172.43 | 172.35 | 172.4 | 1107.0 |
| 2021-12-22 04:10:00 | AAPL | Stock | 172.39 | 172.4 | 172.38 | 172.4 | 2666.0 |
| 2021-12-22 04:15:00 | AAPL | Stock | 172.39 | 172.4 | 172.3 | 172.3 | 509.0 |
| 2021-12-22 04:20:00 | AAPL | Stock | 172.38 | 172.38 | 172.38 | 172.38 | 400.0 |
| 2021-12-22 04:25:00 | AAPL | Stock | 172.23 | 172.38 | 172.22 | 172.22 | 3785.0 |
| 2021-12-22 04:30:00 | AAPL | Stock | 172.18 | 172.3 | 172.18 | 172.3 | 777.0 |
| 2021-12-22 04:35:00 | AAPL | Stock | 172.2 | 172.2 | 172.17 | 172.17 | 328.0 |
| 2021-12-22 04:40:00 | AAPL | Stock | 172.06 | 172.06 | 172.05 | 172.05 | 574.0 |
| 2021-12-22 04:45:00 | AAPL | Stock | 172.03 | 172.03 | 171.91 | 171.94 | 315.0 |
| 2021-12-22 04:50:00 | AAPL | Stock | 172.0 | 172.2 | 172.0 | 172.2 | 413.0 |
| 2021-12-22 04:55:00 | AAPL | Stock | 172.1 | 172.1 | 172.09 | 172.09 | 338.0 |
| 2021-12-22 05:00:00 | AAPL | Stock | 172.09 | 172.09 | 172.0 | 172.0 | 4411.0 |
| 2021-12-22 05:05:00 | AAPL | Stock | 172.16 | 172.25 | 172.16 | 172.25 | 686.0 |
| 2021-12-22 05:10:00 | AAPL | Stock | 172.28 | 172.42 | 172.26 | 172.26 | 2276.0 |
| 2021-12-22 05:15:00 | AAPL | Stock | 172.41 | 172.44 | 172.41 | 172.44 | 373.0 |
| 2021-12-22 05:20:00 | AAPL | Stock | 172.2 | 172.34 | 172.2 | 172.34 | 686.0 |
| 2021-12-22 05:25:00 | AAPL | Stock | 172.3 | 172.3 | 172.21 | 172.21 | 243.0 |
| 2021-12-22 05:30:00 | AAPL | Stock | 172.35 | 172.35 | 172.3 | 172.32 | 642.0 |
| 2021-12-22 05:35:00 | AAPL | Stock | 172.32 | 172.36 | 172.32 | 172.36 | 1408.0 |
| 2021-12-22 05:40:00 | AAPL | Stock | 172.48 | 172.48 | 172.48 | 172.48 | 123.0 |
| 2021-12-22 05:45:00 | AAPL | Stock | 172.43 | 172.43 | 172.43 | 172.43 | 125.0 |
| 2021-12-22 05:50:00 | AAPL | Stock | 172.58 | 172.72 | 172.58 | 172.72 | 1503.0 |
| 2021-12-22 05:55:00 | AAPL | Stock | 172.79 | 172.79 | 172.79 | 172.79 | 100.0 |
| 2021-12-22 06:00:00 | AAPL | Stock | 172.79 | 172.83 | 172.79 | 172.83 | 345.0 |
| 2021-12-22 06:05:00 | AAPL | Stock | 172.84 | 172.84 | 172.82 | 172.82 | 525.0 |
| 2021-12-22 06:10:00 | AAPL | Stock | 172.87 | 172.87 | 172.79 | 172.79 | 1098.0 |
| 2021-12-22 06:15:00 | AAPL | Stock | 172.72 | 172.91 | 172.72 | 172.81 | 2705.0 |
| 2021-12-22 06:20:00 | AAPL | Stock | 172.8 | 172.89 | 172.8 | 172.8 | 1883.0 |
| 2021-12-22 06:25:00 | AAPL | Stock | 172.76 | 172.8 | 172.76 | 172.8 | 1069.0 |
| 2021-12-22 06:30:00 | AAPL | Stock | 172.64 | 172.71 | 172.63 | 172.64 | 605.0 |
| 2021-12-22 06:35:00 | AAPL | Stock | 172.61 | 172.61 | 172.53 | 172.53 | 544.0 |
| 2021-12-22 06:40:00 | AAPL | Stock | 172.53 | 172.65 | 172.52 | 172.6 | 1877.0 |
| 2021-12-22 06:45:00 | AAPL | Stock | 172.68 | 172.88 | 172.68 | 172.88 | 4192.0 |
| 2021-12-22 06:50:00 | AAPL | Stock | 172.8 | 172.87 | 172.8 | 172.87 | 213.0 |
| 2021-12-22 06:55:00 | AAPL | Stock | 172.89 | 173.1 | 172.89 | 172.94 | 4772.0 |
| 2021-12-22 07:00:00 | AAPL | Stock | 172.9 | 173.07 | 172.86 | 172.98 | 23766.0 |
| 2021-12-22 07:05:00 | AAPL | Stock | 172.97 | 173.04 | 172.86 | 172.98 | 10259.0 |
| 2021-12-22 07:10:00 | AAPL | Stock | 172.94 | 173.06 | 172.9 | 173.06 | 19250.0 |
| 2021-12-22 07:15:00 | AAPL | Stock | 173.0 | 173.0 | 172.9 | 172.9 | 3248.0 |
| 2021-12-22 07:20:00 | AAPL | Stock | 172.95 | 172.95 | 172.87 | 172.93 | 3147.0 |
| 2021-12-22 07:25:00 | AAPL | Stock | 172.91 | 172.94 | 172.76 | 172.8 | 10024.0 |
| 2021-12-22 07:30:00 | AAPL | Stock | 172.8 | 172.9 | 172.75 | 172.9 | 11007.0 |
| 2021-12-22 07:35:00 | AAPL | Stock | 172.85 | 172.85 | 172.75 | 172.83 | 8046.0 |
| 2021-12-22 07:40:00 | AAPL | Stock | 172.81 | 172.81 | 172.72 | 172.8 | 3255.0 |
| 2021-12-22 07:45:00 | AAPL | Stock | 172.81 | 172.87 | 172.8 | 172.81 | 4593.0 |
| 2021-12-22 07:50:00 | AAPL | Stock | 172.82 | 172.85 | 172.6 | 172.6 | 6701.0 |
| 2021-12-22 07:55:00 | AAPL | Stock | 172.6 | 172.71 | 172.5 | 172.56 | 7362.0 |
| 2021-12-22 08:00:00 | AAPL | Stock | 172.56 | 173.0 | 172.5 | 172.52 | 64322.0 |
| 2021-12-22 08:05:00 | AAPL | Stock | 172.57 | 172.79 | 172.49 | 172.64 | 14244.0 |
> showing 50 of 451,119 rows — these rows as CSV