PREVIEW / stock_5min / 2022-08-26
file: by_date/stock_5min/2022/2022-08-26.parquet size: 6.9 MB rows: 423,049 symbols: 2,236
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-26 04:00:00 | AAPL | Stock | 170.0 | 170.0 | 169.4 | 169.4 | 6814.0 |
| 2022-08-26 04:05:00 | AAPL | Stock | 169.49 | 169.5 | 169.43 | 169.5 | 853.0 |
| 2022-08-26 04:10:00 | AAPL | Stock | 169.52 | 169.53 | 169.52 | 169.53 | 2117.0 |
| 2022-08-26 04:15:00 | AAPL | Stock | 169.58 | 169.58 | 169.57 | 169.57 | 200.0 |
| 2022-08-26 04:20:00 | AAPL | Stock | 169.57 | 169.6 | 169.57 | 169.6 | 270.0 |
| 2022-08-26 04:25:00 | AAPL | Stock | 169.56 | 169.56 | 169.54 | 169.54 | 400.0 |
| 2022-08-26 04:30:00 | AAPL | Stock | 169.51 | 169.6 | 169.42 | 169.6 | 2713.0 |
| 2022-08-26 04:35:00 | AAPL | Stock | 169.59 | 169.69 | 169.59 | 169.69 | 1342.0 |
| 2022-08-26 04:40:00 | AAPL | Stock | 169.69 | 169.7 | 169.65 | 169.67 | 2563.0 |
| 2022-08-26 04:45:00 | AAPL | Stock | 169.68 | 169.68 | 169.68 | 169.68 | 100.0 |
| 2022-08-26 04:50:00 | AAPL | Stock | 169.73 | 169.73 | 169.57 | 169.57 | 293.0 |
| 2022-08-26 05:00:00 | AAPL | Stock | 169.51 | 169.51 | 169.44 | 169.44 | 1467.0 |
| 2022-08-26 05:05:00 | AAPL | Stock | 169.44 | 169.51 | 169.44 | 169.51 | 466.0 |
| 2022-08-26 05:10:00 | AAPL | Stock | 169.51 | 169.51 | 169.51 | 169.51 | 3769.0 |
| 2022-08-26 05:15:00 | AAPL | Stock | 169.51 | 169.51 | 169.45 | 169.45 | 531.0 |
| 2022-08-26 05:20:00 | AAPL | Stock | 169.42 | 169.42 | 169.41 | 169.42 | 1440.0 |
| 2022-08-26 05:30:00 | AAPL | Stock | 169.42 | 169.42 | 169.31 | 169.31 | 2965.0 |
| 2022-08-26 05:40:00 | AAPL | Stock | 169.4 | 169.4 | 169.4 | 169.4 | 340.0 |
| 2022-08-26 05:45:00 | AAPL | Stock | 169.43 | 169.44 | 169.31 | 169.31 | 648.0 |
| 2022-08-26 05:50:00 | AAPL | Stock | 169.24 | 169.24 | 169.24 | 169.24 | 134.0 |
| 2022-08-26 06:00:00 | AAPL | Stock | 169.36 | 169.44 | 169.36 | 169.44 | 800.0 |
| 2022-08-26 06:10:00 | AAPL | Stock | 169.41 | 169.41 | 169.39 | 169.39 | 1312.0 |
| 2022-08-26 06:20:00 | AAPL | Stock | 169.52 | 169.52 | 169.52 | 169.52 | 700.0 |
| 2022-08-26 06:25:00 | AAPL | Stock | 169.52 | 169.53 | 169.52 | 169.53 | 300.0 |
| 2022-08-26 06:30:00 | AAPL | Stock | 169.53 | 169.53 | 169.5 | 169.5 | 956.0 |
| 2022-08-26 06:35:00 | AAPL | Stock | 169.45 | 169.49 | 169.45 | 169.49 | 382.0 |
| 2022-08-26 06:50:00 | AAPL | Stock | 169.47 | 169.47 | 169.47 | 169.47 | 620.0 |
| 2022-08-26 06:55:00 | AAPL | Stock | 169.47 | 169.47 | 169.47 | 169.47 | 350.0 |
| 2022-08-26 07:00:00 | AAPL | Stock | 169.54 | 169.61 | 169.45 | 169.45 | 10628.0 |
| 2022-08-26 07:05:00 | AAPL | Stock | 169.45 | 169.45 | 169.33 | 169.37 | 8098.0 |
| 2022-08-26 07:10:00 | AAPL | Stock | 169.39 | 169.46 | 169.39 | 169.45 | 5134.0 |
| 2022-08-26 07:15:00 | AAPL | Stock | 169.55 | 169.59 | 169.48 | 169.54 | 3559.0 |
| 2022-08-26 07:20:00 | AAPL | Stock | 169.54 | 169.6 | 169.51 | 169.6 | 4242.0 |
| 2022-08-26 07:25:00 | AAPL | Stock | 169.6 | 169.77 | 169.58 | 169.75 | 4415.0 |
| 2022-08-26 07:30:00 | AAPL | Stock | 169.71 | 169.99 | 169.71 | 169.81 | 9153.0 |
| 2022-08-26 07:35:00 | AAPL | Stock | 169.81 | 169.91 | 169.78 | 169.9 | 2322.0 |
| 2022-08-26 07:40:00 | AAPL | Stock | 169.9 | 169.9 | 169.82 | 169.89 | 2400.0 |
| 2022-08-26 07:45:00 | AAPL | Stock | 169.9 | 169.93 | 169.84 | 169.93 | 3753.0 |
| 2022-08-26 07:50:00 | AAPL | Stock | 169.87 | 169.95 | 169.85 | 169.95 | 3451.0 |
| 2022-08-26 07:55:00 | AAPL | Stock | 169.96 | 169.96 | 169.86 | 169.86 | 2142.0 |
| 2022-08-26 08:00:00 | AAPL | Stock | 169.51 | 169.94 | 169.35 | 169.83 | 62108.0 |
| 2022-08-26 08:05:00 | AAPL | Stock | 169.8 | 169.86 | 169.79 | 169.7956 | 4556.0 |
| 2022-08-26 08:10:00 | AAPL | Stock | 169.7903 | 169.81 | 169.76 | 169.8 | 5414.0 |
| 2022-08-26 08:15:00 | AAPL | Stock | 169.85 | 169.94 | 169.81 | 169.85 | 9511.0 |
| 2022-08-26 08:20:00 | AAPL | Stock | 169.84 | 169.84 | 169.76 | 169.84 | 3726.0 |
| 2022-08-26 08:25:00 | AAPL | Stock | 169.8 | 169.82 | 169.74 | 169.77 | 5610.0 |
| 2022-08-26 08:30:00 | AAPL | Stock | 169.74 | 170.47 | 169.66 | 170.21 | 70745.0 |
| 2022-08-26 08:35:00 | AAPL | Stock | 170.22 | 170.3391 | 170.05 | 170.23 | 35677.0 |
| 2022-08-26 08:40:00 | AAPL | Stock | 170.24 | 170.29 | 169.92 | 170.03 | 31539.0 |
| 2022-08-26 08:45:00 | AAPL | Stock | 170.05 | 170.27 | 170.05 | 170.27 | 27298.0 |
> showing 50 of 423,049 rows — these rows as CSV