PREVIEW / stock_5min / 2022-08-31
file: by_date/stock_5min/2022/2022-08-31.parquet size: 6.8 MB rows: 424,530 symbols: 2,206
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-08-31 04:00:00 | AAPL | Stock | 159.91 | 159.91 | 159.44 | 159.75 | 4428.0 |
| 2022-08-31 04:05:00 | AAPL | Stock | 159.7 | 159.78 | 159.7 | 159.78 | 490.0 |
| 2022-08-31 04:10:00 | AAPL | Stock | 159.69 | 159.7 | 159.69 | 159.7 | 318.0 |
| 2022-08-31 04:15:00 | AAPL | Stock | 159.79 | 159.79 | 159.75 | 159.75 | 512.0 |
| 2022-08-31 04:20:00 | AAPL | Stock | 159.72 | 159.72 | 159.6 | 159.6 | 715.0 |
| 2022-08-31 04:25:00 | AAPL | Stock | 159.52 | 159.52 | 159.3 | 159.3 | 1798.0 |
| 2022-08-31 04:30:00 | AAPL | Stock | 159.6 | 159.6 | 159.55 | 159.55 | 11235.0 |
| 2022-08-31 04:35:00 | AAPL | Stock | 159.4 | 159.6 | 159.4 | 159.6 | 1614.0 |
| 2022-08-31 04:40:00 | AAPL | Stock | 159.6 | 159.79 | 159.59 | 159.79 | 4921.0 |
| 2022-08-31 04:45:00 | AAPL | Stock | 159.78 | 160.0 | 159.78 | 159.99 | 3435.0 |
| 2022-08-31 04:55:00 | AAPL | Stock | 159.79 | 159.79 | 159.7 | 159.72 | 1822.0 |
| 2022-08-31 05:00:00 | AAPL | Stock | 159.65 | 159.66 | 159.49 | 159.6 | 7440.0 |
| 2022-08-31 05:05:00 | AAPL | Stock | 159.6 | 159.65 | 159.52 | 159.52 | 2243.0 |
| 2022-08-31 05:10:00 | AAPL | Stock | 159.6 | 159.6 | 159.4 | 159.4 | 24812.0 |
| 2022-08-31 05:15:00 | AAPL | Stock | 159.4 | 159.56 | 159.4 | 159.56 | 1586.0 |
| 2022-08-31 05:20:00 | AAPL | Stock | 159.55 | 159.55 | 159.55 | 159.55 | 243.0 |
| 2022-08-31 05:25:00 | AAPL | Stock | 159.41 | 159.41 | 159.4 | 159.4 | 321.0 |
| 2022-08-31 05:30:00 | AAPL | Stock | 159.37 | 159.37 | 159.3 | 159.3 | 586.0 |
| 2022-08-31 05:35:00 | AAPL | Stock | 159.32 | 159.32 | 159.32 | 159.32 | 100.0 |
| 2022-08-31 05:40:00 | AAPL | Stock | 159.4 | 159.56 | 159.4 | 159.56 | 223.0 |
| 2022-08-31 05:45:00 | AAPL | Stock | 159.54 | 159.54 | 159.54 | 159.54 | 196.0 |
| 2022-08-31 05:50:00 | AAPL | Stock | 159.47 | 159.59 | 159.47 | 159.59 | 1109.0 |
| 2022-08-31 06:05:00 | AAPL | Stock | 159.45 | 159.46 | 159.45 | 159.46 | 593.0 |
| 2022-08-31 06:10:00 | AAPL | Stock | 159.6 | 159.69 | 159.6 | 159.69 | 687.0 |
| 2022-08-31 06:15:00 | AAPL | Stock | 159.63 | 159.92 | 159.63 | 159.92 | 4522.0 |
| 2022-08-31 06:20:00 | AAPL | Stock | 159.81 | 159.96 | 159.81 | 159.95 | 1521.0 |
| 2022-08-31 06:25:00 | AAPL | Stock | 159.97 | 159.97 | 159.92 | 159.95 | 1411.0 |
| 2022-08-31 06:30:00 | AAPL | Stock | 159.82 | 159.82 | 159.64 | 159.64 | 1087.0 |
| 2022-08-31 06:35:00 | AAPL | Stock | 159.63 | 159.98 | 159.61 | 159.98 | 3290.0 |
| 2022-08-31 06:40:00 | AAPL | Stock | 159.97 | 160.04 | 159.97 | 160.04 | 2611.0 |
| 2022-08-31 06:45:00 | AAPL | Stock | 159.97 | 160.03 | 159.95 | 159.99 | 1808.0 |
| 2022-08-31 06:50:00 | AAPL | Stock | 160.04 | 160.35 | 160.04 | 160.35 | 10760.0 |
| 2022-08-31 06:55:00 | AAPL | Stock | 160.27 | 160.27 | 160.09 | 160.11 | 1693.0 |
| 2022-08-31 07:00:00 | AAPL | Stock | 159.99 | 160.1 | 159.83 | 160.03 | 25786.0 |
| 2022-08-31 07:05:00 | AAPL | Stock | 160.09 | 160.09 | 159.83 | 159.88 | 4216.0 |
| 2022-08-31 07:10:00 | AAPL | Stock | 159.85 | 159.85 | 159.73 | 159.8 | 5315.0 |
| 2022-08-31 07:15:00 | AAPL | Stock | 159.8 | 159.84 | 159.51 | 159.84 | 21770.0 |
| 2022-08-31 07:20:00 | AAPL | Stock | 159.87 | 159.88 | 159.74 | 159.79 | 4627.0 |
| 2022-08-31 07:25:00 | AAPL | Stock | 159.77 | 159.77 | 159.65 | 159.72 | 3480.0 |
| 2022-08-31 07:30:00 | AAPL | Stock | 159.68 | 159.71 | 159.55 | 159.59 | 3588.0 |
| 2022-08-31 07:35:00 | AAPL | Stock | 159.57 | 159.59 | 159.53 | 159.59 | 1075.0 |
| 2022-08-31 07:40:00 | AAPL | Stock | 159.56 | 159.56 | 159.56 | 159.56 | 300.0 |
| 2022-08-31 07:45:00 | AAPL | Stock | 159.54 | 159.55 | 159.5 | 159.55 | 5574.0 |
| 2022-08-31 07:50:00 | AAPL | Stock | 159.47 | 159.62 | 159.43 | 159.61 | 3491.0 |
| 2022-08-31 07:55:00 | AAPL | Stock | 159.57 | 159.72 | 159.57 | 159.72 | 4996.0 |
| 2022-08-31 08:00:00 | AAPL | Stock | 159.7 | 160.76 | 158.513 | 159.8 | 114085.0 |
| 2022-08-31 08:05:00 | AAPL | Stock | 159.8 | 159.82 | 159.7 | 159.7 | 15633.0 |
| 2022-08-31 08:10:00 | AAPL | Stock | 159.7101 | 159.7848 | 159.671 | 159.73 | 11305.0 |
| 2022-08-31 08:15:00 | AAPL | Stock | 159.8 | 160.19 | 159.8 | 160.05 | 32378.0 |
| 2022-08-31 08:20:00 | AAPL | Stock | 160.06 | 160.1 | 159.79 | 159.8 | 19004.0 |
> showing 50 of 424,530 rows — these rows as CSV