PREVIEW / stock_5min / 2023-08-16
file: by_date/stock_5min/2023/2023-08-16.parquet size: 6.6 MB rows: 402,523 symbols: 1,479
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-08-16 04:05:00 | AAPL | Stock | 178.03 | 178.05 | 178.0 | 178.04 | 1763.0 |
| 2023-08-16 04:15:00 | AAPL | Stock | 177.99 | 178.05 | 177.99 | 178.05 | 815.0 |
| 2023-08-16 04:20:00 | AAPL | Stock | 178.02 | 178.02 | 178.02 | 178.02 | 700.0 |
| 2023-08-16 04:25:00 | AAPL | Stock | 178.02 | 178.02 | 178.01 | 178.02 | 974.0 |
| 2023-08-16 04:35:00 | AAPL | Stock | 177.97 | 177.97 | 177.96 | 177.96 | 621.0 |
| 2023-08-16 04:40:00 | AAPL | Stock | 177.99 | 177.99 | 177.99 | 177.99 | 141.0 |
| 2023-08-16 04:45:00 | AAPL | Stock | 178.03 | 178.07 | 178.03 | 178.07 | 1146.0 |
| 2023-08-16 04:50:00 | AAPL | Stock | 178.04 | 178.04 | 178.04 | 178.04 | 500.0 |
| 2023-08-16 04:55:00 | AAPL | Stock | 178.04 | 178.04 | 178.01 | 178.01 | 1382.0 |
| 2023-08-16 05:00:00 | AAPL | Stock | 178.06 | 178.07 | 178.06 | 178.07 | 437.0 |
| 2023-08-16 05:05:00 | AAPL | Stock | 178.06 | 178.1 | 178.06 | 178.1 | 9380.0 |
| 2023-08-16 05:10:00 | AAPL | Stock | 178.1 | 178.13 | 178.1 | 178.13 | 400.0 |
| 2023-08-16 05:15:00 | AAPL | Stock | 178.07 | 178.07 | 177.96 | 177.96 | 2732.0 |
| 2023-08-16 05:20:00 | AAPL | Stock | 177.93 | 177.93 | 177.8 | 177.8 | 2741.0 |
| 2023-08-16 05:25:00 | AAPL | Stock | 177.84 | 177.85 | 177.84 | 177.85 | 386.0 |
| 2023-08-16 05:30:00 | AAPL | Stock | 177.9 | 177.99 | 177.9 | 177.99 | 430.0 |
| 2023-08-16 05:40:00 | AAPL | Stock | 177.82 | 177.83 | 177.65 | 177.65 | 2696.0 |
| 2023-08-16 05:45:00 | AAPL | Stock | 177.79 | 177.83 | 177.79 | 177.83 | 700.0 |
| 2023-08-16 05:50:00 | AAPL | Stock | 177.75 | 177.75 | 177.75 | 177.75 | 200.0 |
| 2023-08-16 05:55:00 | AAPL | Stock | 177.86 | 177.86 | 177.86 | 177.86 | 1004.0 |
| 2023-08-16 06:00:00 | AAPL | Stock | 177.89 | 177.98 | 177.45 | 177.8 | 7389.0 |
| 2023-08-16 06:05:00 | AAPL | Stock | 177.86 | 177.91 | 177.86 | 177.91 | 390.0 |
| 2023-08-16 06:20:00 | AAPL | Stock | 177.81 | 177.87 | 177.81 | 177.84 | 749.0 |
| 2023-08-16 06:25:00 | AAPL | Stock | 177.86 | 177.96 | 177.86 | 177.96 | 537.0 |
| 2023-08-16 06:30:00 | AAPL | Stock | 177.98 | 177.98 | 177.98 | 177.98 | 220.0 |
| 2023-08-16 06:35:00 | AAPL | Stock | 177.95 | 177.96 | 177.95 | 177.96 | 707.0 |
| 2023-08-16 06:40:00 | AAPL | Stock | 177.95 | 177.95 | 177.81 | 177.81 | 1870.0 |
| 2023-08-16 06:45:00 | AAPL | Stock | 177.85 | 177.87 | 177.85 | 177.87 | 572.0 |
| 2023-08-16 06:50:00 | AAPL | Stock | 177.84 | 177.85 | 177.81 | 177.85 | 650.0 |
| 2023-08-16 06:55:00 | AAPL | Stock | 177.86 | 177.86 | 177.86 | 177.86 | 242.0 |
| 2023-08-16 07:00:00 | AAPL | Stock | 177.83 | 177.84 | 177.75 | 177.75 | 1600.0 |
| 2023-08-16 07:05:00 | AAPL | Stock | 177.58 | 177.58 | 177.55 | 177.55 | 381.0 |
| 2023-08-16 07:10:00 | AAPL | Stock | 177.55 | 177.55 | 177.38 | 177.4 | 3809.0 |
| 2023-08-16 07:15:00 | AAPL | Stock | 177.49 | 177.49 | 177.49 | 177.49 | 149.0 |
| 2023-08-16 07:20:00 | AAPL | Stock | 177.49 | 177.49 | 177.48 | 177.48 | 957.0 |
| 2023-08-16 07:25:00 | AAPL | Stock | 177.49 | 177.55 | 177.49 | 177.52 | 4413.0 |
| 2023-08-16 07:30:00 | AAPL | Stock | 177.54 | 177.68 | 177.53 | 177.68 | 3339.0 |
| 2023-08-16 07:35:00 | AAPL | Stock | 177.74 | 177.74 | 177.7 | 177.7 | 1949.0 |
| 2023-08-16 07:40:00 | AAPL | Stock | 177.68 | 177.7 | 177.67 | 177.67 | 620.0 |
| 2023-08-16 07:45:00 | AAPL | Stock | 177.7 | 177.7 | 177.67 | 177.69 | 500.0 |
| 2023-08-16 07:50:00 | AAPL | Stock | 177.67 | 177.68 | 177.65 | 177.68 | 1015.0 |
| 2023-08-16 07:55:00 | AAPL | Stock | 177.66 | 177.72 | 177.65 | 177.72 | 1258.0 |
| 2023-08-16 08:00:00 | AAPL | Stock | 177.39 | 178.35 | 177.28 | 177.73 | 33326.0 |
| 2023-08-16 08:05:00 | AAPL | Stock | 177.71 | 177.75 | 177.61 | 177.62 | 7003.0 |
| 2023-08-16 08:10:00 | AAPL | Stock | 177.63 | 177.7 | 177.63 | 177.65 | 4354.0 |
| 2023-08-16 08:15:00 | AAPL | Stock | 177.65 | 177.6989 | 177.64 | 177.65 | 6231.0 |
| 2023-08-16 08:20:00 | AAPL | Stock | 177.63 | 177.65 | 177.4 | 177.48 | 13396.0 |
| 2023-08-16 08:25:00 | AAPL | Stock | 177.4899 | 177.52 | 177.39 | 177.4 | 6811.0 |
| 2023-08-16 08:30:00 | AAPL | Stock | 177.45 | 177.47 | 177.3 | 177.47 | 20738.0 |
| 2023-08-16 08:35:00 | AAPL | Stock | 177.49 | 177.53 | 177.3801 | 177.3801 | 8455.0 |
> showing 50 of 402,523 rows — these rows as CSV