PREVIEW / stock_5min / 2023-11-07
file: by_date/stock_5min/2023/2023-11-07.parquet size: 6.4 MB rows: 390,790 symbols: 1,341
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-11-07 04:00:00 | AAPL | Stock | 178.88 | 178.88 | 178.73 | 178.79 | 1206.0 |
| 2023-11-07 04:05:00 | AAPL | Stock | 178.8 | 178.8 | 178.79 | 178.79 | 200.0 |
| 2023-11-07 04:10:00 | AAPL | Stock | 178.8 | 178.8 | 178.77 | 178.77 | 1046.0 |
| 2023-11-07 04:15:00 | AAPL | Stock | 178.74 | 178.74 | 178.7 | 178.7 | 717.0 |
| 2023-11-07 04:20:00 | AAPL | Stock | 178.6 | 178.6 | 178.6 | 178.6 | 662.0 |
| 2023-11-07 04:30:00 | AAPL | Stock | 178.52 | 178.52 | 178.47 | 178.47 | 500.0 |
| 2023-11-07 04:40:00 | AAPL | Stock | 178.5 | 178.51 | 178.5 | 178.5 | 575.0 |
| 2023-11-07 04:45:00 | AAPL | Stock | 178.5 | 178.5 | 178.5 | 178.5 | 352.0 |
| 2023-11-07 05:00:00 | AAPL | Stock | 178.4 | 178.4 | 178.4 | 178.4 | 125.0 |
| 2023-11-07 05:10:00 | AAPL | Stock | 178.4 | 178.4 | 178.4 | 178.4 | 299.0 |
| 2023-11-07 05:15:00 | AAPL | Stock | 178.45 | 178.45 | 178.43 | 178.43 | 1235.0 |
| 2023-11-07 05:20:00 | AAPL | Stock | 178.52 | 178.52 | 178.52 | 178.52 | 100.0 |
| 2023-11-07 05:25:00 | AAPL | Stock | 178.55 | 178.68 | 178.54 | 178.68 | 508.0 |
| 2023-11-07 05:40:00 | AAPL | Stock | 178.55 | 178.55 | 178.55 | 178.55 | 500.0 |
| 2023-11-07 05:45:00 | AAPL | Stock | 178.45 | 178.45 | 178.45 | 178.45 | 500.0 |
| 2023-11-07 05:50:00 | AAPL | Stock | 178.46 | 178.49 | 178.46 | 178.49 | 391.0 |
| 2023-11-07 06:10:00 | AAPL | Stock | 178.5 | 178.5 | 178.47 | 178.47 | 738.0 |
| 2023-11-07 06:15:00 | AAPL | Stock | 178.44 | 178.44 | 178.41 | 178.41 | 427.0 |
| 2023-11-07 06:20:00 | AAPL | Stock | 178.39 | 178.39 | 178.39 | 178.39 | 500.0 |
| 2023-11-07 06:25:00 | AAPL | Stock | 178.41 | 178.41 | 178.38 | 178.38 | 1028.0 |
| 2023-11-07 06:30:00 | AAPL | Stock | 178.35 | 178.35 | 178.22 | 178.22 | 16201.0 |
| 2023-11-07 06:35:00 | AAPL | Stock | 178.25 | 178.33 | 178.22 | 178.22 | 8139.0 |
| 2023-11-07 06:40:00 | AAPL | Stock | 178.29 | 178.33 | 178.29 | 178.33 | 500.0 |
| 2023-11-07 06:45:00 | AAPL | Stock | 178.3 | 178.3 | 178.3 | 178.3 | 332.0 |
| 2023-11-07 06:50:00 | AAPL | Stock | 178.3 | 178.3 | 178.3 | 178.3 | 100.0 |
| 2023-11-07 06:55:00 | AAPL | Stock | 178.34 | 178.41 | 178.34 | 178.41 | 1065.0 |
| 2023-11-07 07:00:00 | AAPL | Stock | 178.5 | 178.5 | 178.45 | 178.45 | 2625.0 |
| 2023-11-07 07:05:00 | AAPL | Stock | 178.49 | 178.49 | 178.33 | 178.33 | 5287.0 |
| 2023-11-07 07:10:00 | AAPL | Stock | 178.45 | 178.53 | 178.45 | 178.48 | 2770.0 |
| 2023-11-07 07:15:00 | AAPL | Stock | 178.51 | 178.64 | 178.51 | 178.64 | 3362.0 |
| 2023-11-07 07:20:00 | AAPL | Stock | 178.65 | 178.66 | 178.56 | 178.56 | 1580.0 |
| 2023-11-07 07:25:00 | AAPL | Stock | 178.56 | 178.6 | 178.56 | 178.59 | 1195.0 |
| 2023-11-07 07:30:00 | AAPL | Stock | 178.6 | 178.6 | 178.6 | 178.6 | 128.0 |
| 2023-11-07 07:35:00 | AAPL | Stock | 178.56 | 178.56 | 178.53 | 178.53 | 879.0 |
| 2023-11-07 07:40:00 | AAPL | Stock | 178.51 | 178.51 | 178.5 | 178.5 | 1441.0 |
| 2023-11-07 07:45:00 | AAPL | Stock | 178.5 | 178.51 | 178.47 | 178.47 | 901.0 |
| 2023-11-07 07:50:00 | AAPL | Stock | 178.56 | 178.56 | 178.52 | 178.52 | 600.0 |
| 2023-11-07 07:55:00 | AAPL | Stock | 178.57 | 178.69 | 178.56 | 178.66 | 2186.0 |
| 2023-11-07 08:00:00 | AAPL | Stock | 178.48 | 178.83 | 178.36 | 178.83 | 39082.0 |
| 2023-11-07 08:05:00 | AAPL | Stock | 178.87 | 178.9 | 178.84 | 178.89 | 4317.0 |
| 2023-11-07 08:10:00 | AAPL | Stock | 178.9 | 178.94 | 178.83 | 178.83 | 7762.0 |
| 2023-11-07 08:15:00 | AAPL | Stock | 178.82 | 178.88 | 178.82 | 178.85 | 2158.0 |
| 2023-11-07 08:20:00 | AAPL | Stock | 178.89 | 178.89 | 178.71 | 178.71 | 5105.0 |
| 2023-11-07 08:25:00 | AAPL | Stock | 178.75 | 178.75 | 178.6801 | 178.72 | 3968.0 |
| 2023-11-07 08:30:00 | AAPL | Stock | 178.76 | 178.87 | 178.76 | 178.84 | 3175.0 |
| 2023-11-07 08:35:00 | AAPL | Stock | 178.86 | 178.97 | 178.77 | 178.9 | 12365.0 |
| 2023-11-07 08:40:00 | AAPL | Stock | 178.85 | 178.86 | 178.7856 | 178.8361 | 6050.0 |
| 2023-11-07 08:45:00 | AAPL | Stock | 178.84 | 178.9 | 178.79 | 178.9 | 4117.0 |
| 2023-11-07 08:50:00 | AAPL | Stock | 178.8 | 178.81 | 178.74 | 178.74 | 2010.0 |
| 2023-11-07 08:55:00 | AAPL | Stock | 178.83 | 178.87 | 178.8097 | 178.85 | 7150.0 |
> showing 50 of 390,790 rows — these rows as CSV