PREVIEW / stock_5min / 2022-01-24
file: by_date/stock_5min/2022/2022-01-24.parquet size: 8.4 MB rows: 516,395 symbols: 2,718
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 |
|---|---|---|---|---|---|---|---|
| 2022-01-24 04:00:00 | AAPL | Stock | 162.27 | 163.16 | 162.27 | 162.81 | 5635.0 |
| 2022-01-24 04:05:00 | AAPL | Stock | 162.95 | 163.17 | 162.83 | 163.17 | 4379.0 |
| 2022-01-24 04:10:00 | AAPL | Stock | 163.0 | 163.0 | 162.8 | 162.97 | 4820.0 |
| 2022-01-24 04:15:00 | AAPL | Stock | 162.9 | 162.93 | 162.6 | 162.67 | 5216.0 |
| 2022-01-24 04:20:00 | AAPL | Stock | 162.52 | 162.69 | 162.48 | 162.64 | 2634.0 |
| 2022-01-24 04:25:00 | AAPL | Stock | 162.64 | 162.77 | 162.63 | 162.7 | 3528.0 |
| 2022-01-24 04:30:00 | AAPL | Stock | 162.79 | 162.98 | 162.76 | 162.76 | 1801.0 |
| 2022-01-24 04:35:00 | AAPL | Stock | 162.74 | 162.99 | 162.74 | 162.92 | 3406.0 |
| 2022-01-24 04:40:00 | AAPL | Stock | 162.71 | 162.95 | 162.71 | 162.94 | 2064.0 |
| 2022-01-24 04:45:00 | AAPL | Stock | 162.76 | 162.78 | 162.38 | 162.78 | 5102.0 |
| 2022-01-24 04:50:00 | AAPL | Stock | 162.74 | 162.88 | 162.55 | 162.64 | 3963.0 |
| 2022-01-24 04:55:00 | AAPL | Stock | 162.66 | 162.68 | 162.35 | 162.52 | 10196.0 |
| 2022-01-24 05:00:00 | AAPL | Stock | 162.33 | 162.33 | 161.7 | 162.2 | 5111.0 |
| 2022-01-24 05:05:00 | AAPL | Stock | 162.17 | 162.18 | 161.8 | 162.01 | 7715.0 |
| 2022-01-24 05:10:00 | AAPL | Stock | 162.0 | 162.05 | 161.2 | 161.5 | 12856.0 |
| 2022-01-24 05:15:00 | AAPL | Stock | 161.41 | 161.59 | 161.06 | 161.29 | 9202.0 |
| 2022-01-24 05:20:00 | AAPL | Stock | 161.14 | 161.4 | 161.14 | 161.35 | 10093.0 |
| 2022-01-24 05:25:00 | AAPL | Stock | 161.3 | 161.42 | 160.5 | 160.72 | 9476.0 |
| 2022-01-24 05:30:00 | AAPL | Stock | 160.8 | 160.97 | 160.3 | 160.81 | 23150.0 |
| 2022-01-24 05:35:00 | AAPL | Stock | 160.95 | 161.49 | 160.85 | 161.29 | 30124.0 |
| 2022-01-24 05:40:00 | AAPL | Stock | 161.15 | 161.15 | 160.12 | 160.4 | 13367.0 |
| 2022-01-24 05:45:00 | AAPL | Stock | 160.4 | 160.86 | 160.37 | 160.86 | 14970.0 |
| 2022-01-24 05:50:00 | AAPL | Stock | 160.78 | 160.9 | 160.64 | 160.87 | 10037.0 |
| 2022-01-24 05:55:00 | AAPL | Stock | 160.94 | 161.4 | 160.94 | 161.4 | 14114.0 |
| 2022-01-24 06:00:00 | AAPL | Stock | 161.36 | 161.47 | 161.21 | 161.28 | 15589.0 |
| 2022-01-24 06:05:00 | AAPL | Stock | 161.28 | 161.92 | 161.28 | 161.68 | 11722.0 |
| 2022-01-24 06:10:00 | AAPL | Stock | 161.6 | 161.74 | 161.6 | 161.74 | 2729.0 |
| 2022-01-24 06:15:00 | AAPL | Stock | 161.76 | 162.25 | 161.34 | 161.34 | 9286.0 |
| 2022-01-24 06:20:00 | AAPL | Stock | 161.35 | 161.46 | 161.33 | 161.33 | 2814.0 |
| 2022-01-24 06:25:00 | AAPL | Stock | 161.52 | 161.52 | 161.02 | 161.02 | 2258.0 |
| 2022-01-24 06:30:00 | AAPL | Stock | 160.96 | 160.96 | 160.89 | 160.89 | 688.0 |
| 2022-01-24 06:35:00 | AAPL | Stock | 160.73 | 161.28 | 160.7 | 161.19 | 5722.0 |
| 2022-01-24 06:40:00 | AAPL | Stock | 161.44 | 161.59 | 161.27 | 161.5 | 5616.0 |
| 2022-01-24 06:45:00 | AAPL | Stock | 161.56 | 161.85 | 161.56 | 161.76 | 13788.0 |
| 2022-01-24 06:50:00 | AAPL | Stock | 161.76 | 161.81 | 161.29 | 161.29 | 1561.0 |
| 2022-01-24 06:55:00 | AAPL | Stock | 161.35 | 161.79 | 161.32 | 161.71 | 1345.0 |
| 2022-01-24 07:00:00 | AAPL | Stock | 161.62 | 162.11 | 160.8 | 160.8 | 41769.0 |
| 2022-01-24 07:05:00 | AAPL | Stock | 160.87 | 161.24 | 160.65 | 160.66 | 21812.0 |
| 2022-01-24 07:10:00 | AAPL | Stock | 160.65 | 160.88 | 160.51 | 160.73 | 13396.0 |
| 2022-01-24 07:15:00 | AAPL | Stock | 160.72 | 161.0 | 160.68 | 160.7 | 23063.0 |
| 2022-01-24 07:20:00 | AAPL | Stock | 160.7 | 160.77 | 160.43 | 160.64 | 33157.0 |
| 2022-01-24 07:25:00 | AAPL | Stock | 160.77 | 160.96 | 160.52 | 160.7 | 35979.0 |
| 2022-01-24 07:30:00 | AAPL | Stock | 160.6 | 160.84 | 160.4 | 160.4 | 23716.0 |
| 2022-01-24 07:35:00 | AAPL | Stock | 160.47 | 160.7 | 160.44 | 160.47 | 23695.0 |
| 2022-01-24 07:40:00 | AAPL | Stock | 160.49 | 160.52 | 160.15 | 160.15 | 26249.0 |
| 2022-01-24 07:45:00 | AAPL | Stock | 160.25 | 160.5 | 160.25 | 160.25 | 38896.0 |
| 2022-01-24 07:50:00 | AAPL | Stock | 160.25 | 160.4 | 160.01 | 160.4 | 27820.0 |
| 2022-01-24 07:55:00 | AAPL | Stock | 160.3 | 160.49 | 160.21 | 160.27 | 26661.0 |
| 2022-01-24 08:00:00 | AAPL | Stock | 160.5201 | 161.7 | 159.87 | 159.96 | 389085.0 |
| 2022-01-24 08:05:00 | AAPL | Stock | 159.97 | 160.18 | 159.92 | 160.16 | 75668.0 |
> showing 50 of 516,395 rows — these rows as CSV