PREVIEW / stock_5min / 2023-07-19
file: by_date/stock_5min/2023/2023-07-19.parquet size: 6.8 MB rows: 414,020 symbols: 1,553
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 |
|---|---|---|---|---|---|---|---|
| 2023-07-19 04:00:00 | AAPL | Stock | 193.64 | 193.64 | 193.58 | 193.58 | 2461.0 |
| 2023-07-19 04:05:00 | AAPL | Stock | 193.58 | 193.58 | 193.58 | 193.58 | 500.0 |
| 2023-07-19 04:15:00 | AAPL | Stock | 193.5 | 193.56 | 193.5 | 193.51 | 956.0 |
| 2023-07-19 04:20:00 | AAPL | Stock | 193.51 | 193.54 | 193.51 | 193.54 | 200.0 |
| 2023-07-19 04:25:00 | AAPL | Stock | 193.63 | 193.63 | 193.63 | 193.63 | 100.0 |
| 2023-07-19 04:30:00 | AAPL | Stock | 193.63 | 193.63 | 193.63 | 193.63 | 379.0 |
| 2023-07-19 04:35:00 | AAPL | Stock | 193.65 | 193.65 | 193.65 | 193.65 | 948.0 |
| 2023-07-19 04:40:00 | AAPL | Stock | 193.65 | 193.65 | 193.65 | 193.65 | 199.0 |
| 2023-07-19 04:45:00 | AAPL | Stock | 193.66 | 193.66 | 193.65 | 193.65 | 311.0 |
| 2023-07-19 04:50:00 | AAPL | Stock | 193.65 | 193.65 | 193.45 | 193.45 | 751.0 |
| 2023-07-19 04:55:00 | AAPL | Stock | 193.6 | 193.6 | 193.6 | 193.6 | 284.0 |
| 2023-07-19 05:00:00 | AAPL | Stock | 193.55 | 193.55 | 193.55 | 193.55 | 100.0 |
| 2023-07-19 05:15:00 | AAPL | Stock | 193.5 | 193.5 | 193.5 | 193.5 | 209.0 |
| 2023-07-19 05:25:00 | AAPL | Stock | 193.48 | 193.48 | 193.39 | 193.41 | 1270.0 |
| 2023-07-19 05:35:00 | AAPL | Stock | 193.57 | 193.57 | 193.57 | 193.57 | 169.0 |
| 2023-07-19 05:40:00 | AAPL | Stock | 193.57 | 193.64 | 193.57 | 193.64 | 1103.0 |
| 2023-07-19 05:45:00 | AAPL | Stock | 193.65 | 193.66 | 193.65 | 193.66 | 389.0 |
| 2023-07-19 05:55:00 | AAPL | Stock | 193.64 | 193.64 | 193.59 | 193.59 | 325.0 |
| 2023-07-19 06:00:00 | AAPL | Stock | 193.53 | 193.54 | 193.47 | 193.54 | 2419.0 |
| 2023-07-19 06:05:00 | AAPL | Stock | 193.45 | 193.45 | 193.31 | 193.33 | 4183.0 |
| 2023-07-19 06:10:00 | AAPL | Stock | 193.44 | 193.44 | 193.44 | 193.44 | 252.0 |
| 2023-07-19 06:15:00 | AAPL | Stock | 193.4 | 193.4 | 193.4 | 193.4 | 212.0 |
| 2023-07-19 06:20:00 | AAPL | Stock | 193.34 | 193.34 | 193.3 | 193.3 | 600.0 |
| 2023-07-19 06:25:00 | AAPL | Stock | 193.37 | 193.37 | 193.29 | 193.29 | 1394.0 |
| 2023-07-19 06:30:00 | AAPL | Stock | 193.27 | 193.28 | 193.27 | 193.28 | 389.0 |
| 2023-07-19 06:35:00 | AAPL | Stock | 193.27 | 193.27 | 193.11 | 193.11 | 2658.0 |
| 2023-07-19 06:40:00 | AAPL | Stock | 193.12 | 193.12 | 193.12 | 193.12 | 209.0 |
| 2023-07-19 07:00:00 | AAPL | Stock | 193.38 | 193.66 | 193.38 | 193.6 | 16736.0 |
| 2023-07-19 07:05:00 | AAPL | Stock | 193.55 | 193.56 | 193.5 | 193.55 | 1197.0 |
| 2023-07-19 07:10:00 | AAPL | Stock | 193.65 | 193.66 | 193.55 | 193.55 | 1454.0 |
| 2023-07-19 07:20:00 | AAPL | Stock | 193.52 | 193.55 | 193.49 | 193.49 | 3099.0 |
| 2023-07-19 07:25:00 | AAPL | Stock | 193.45 | 193.49 | 193.39 | 193.47 | 4039.0 |
| 2023-07-19 07:30:00 | AAPL | Stock | 193.49 | 193.49 | 193.42 | 193.42 | 1213.0 |
| 2023-07-19 07:35:00 | AAPL | Stock | 193.45 | 193.49 | 193.41 | 193.41 | 3614.0 |
| 2023-07-19 07:40:00 | AAPL | Stock | 193.4 | 193.4 | 193.25 | 193.3 | 10081.0 |
| 2023-07-19 07:45:00 | AAPL | Stock | 193.29 | 193.33 | 193.25 | 193.33 | 2884.0 |
| 2023-07-19 07:50:00 | AAPL | Stock | 193.32 | 193.32 | 193.29 | 193.3 | 998.0 |
| 2023-07-19 07:55:00 | AAPL | Stock | 193.34 | 193.42 | 193.34 | 193.4 | 745.0 |
| 2023-07-19 08:00:00 | AAPL | Stock | 193.41 | 193.96 | 193.2607 | 193.36 | 33033.0 |
| 2023-07-19 08:05:00 | AAPL | Stock | 193.42 | 193.53 | 193.41 | 193.46 | 8509.0 |
| 2023-07-19 08:10:00 | AAPL | Stock | 193.5 | 193.51 | 193.45 | 193.51 | 6626.0 |
| 2023-07-19 08:15:00 | AAPL | Stock | 193.5009 | 193.54 | 193.5 | 193.54 | 9311.0 |
| 2023-07-19 08:20:00 | AAPL | Stock | 193.5 | 193.5349 | 193.42 | 193.44 | 7261.0 |
| 2023-07-19 08:25:00 | AAPL | Stock | 193.42 | 193.5 | 193.4 | 193.5 | 5522.0 |
| 2023-07-19 08:30:00 | AAPL | Stock | 193.4009 | 193.48 | 193.4 | 193.48 | 4333.0 |
| 2023-07-19 08:35:00 | AAPL | Stock | 193.48 | 193.56 | 193.4 | 193.56 | 8389.0 |
| 2023-07-19 08:40:00 | AAPL | Stock | 193.57 | 193.69 | 193.57 | 193.65 | 14813.0 |
| 2023-07-19 08:45:00 | AAPL | Stock | 193.6 | 193.68 | 193.5801 | 193.65 | 9152.0 |
| 2023-07-19 08:50:00 | AAPL | Stock | 193.67 | 193.73 | 193.66 | 193.7 | 8087.0 |
| 2023-07-19 08:55:00 | AAPL | Stock | 193.71 | 193.79 | 193.57 | 193.67 | 12150.0 |
> showing 50 of 414,020 rows — these rows as CSV