PREVIEW / stock_5min / 2023-10-11
file: by_date/stock_5min/2023/2023-10-11.parquet size: 6.4 MB rows: 388,710 symbols: 1,380
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-10-11 04:00:00 | AAPL | Stock | 178.62 | 178.62 | 178.51 | 178.55 | 1708.0 |
| 2023-10-11 04:05:00 | AAPL | Stock | 178.6 | 178.6 | 178.6 | 178.6 | 279.0 |
| 2023-10-11 04:10:00 | AAPL | Stock | 178.6 | 178.6 | 178.51 | 178.51 | 1413.0 |
| 2023-10-11 04:15:00 | AAPL | Stock | 178.5 | 178.5 | 178.41 | 178.47 | 498.0 |
| 2023-10-11 04:20:00 | AAPL | Stock | 178.51 | 178.51 | 178.5 | 178.5 | 498.0 |
| 2023-10-11 04:25:00 | AAPL | Stock | 178.41 | 178.41 | 178.36 | 178.36 | 994.0 |
| 2023-10-11 04:35:00 | AAPL | Stock | 178.5 | 178.5 | 178.5 | 178.5 | 874.0 |
| 2023-10-11 04:40:00 | AAPL | Stock | 178.6 | 178.61 | 178.6 | 178.61 | 1419.0 |
| 2023-10-11 04:50:00 | AAPL | Stock | 178.5 | 178.5 | 178.42 | 178.42 | 1352.0 |
| 2023-10-11 04:55:00 | AAPL | Stock | 178.41 | 178.41 | 178.4 | 178.4 | 360.0 |
| 2023-10-11 05:00:00 | AAPL | Stock | 178.4 | 178.47 | 178.4 | 178.47 | 1131.0 |
| 2023-10-11 05:10:00 | AAPL | Stock | 178.37 | 178.37 | 178.37 | 178.37 | 132.0 |
| 2023-10-11 05:25:00 | AAPL | Stock | 178.35 | 178.35 | 178.35 | 178.35 | 100.0 |
| 2023-10-11 05:40:00 | AAPL | Stock | 178.44 | 178.45 | 178.44 | 178.45 | 234.0 |
| 2023-10-11 05:55:00 | AAPL | Stock | 178.5 | 178.61 | 178.5 | 178.6 | 651.0 |
| 2023-10-11 06:00:00 | AAPL | Stock | 178.6 | 178.64 | 178.6 | 178.64 | 879.0 |
| 2023-10-11 06:05:00 | AAPL | Stock | 178.57 | 178.61 | 178.57 | 178.61 | 212.0 |
| 2023-10-11 06:20:00 | AAPL | Stock | 178.47 | 178.47 | 178.47 | 178.47 | 198.0 |
| 2023-10-11 06:25:00 | AAPL | Stock | 178.51 | 178.54 | 178.49 | 178.49 | 817.0 |
| 2023-10-11 06:35:00 | AAPL | Stock | 178.55 | 178.56 | 178.55 | 178.56 | 483.0 |
| 2023-10-11 06:40:00 | AAPL | Stock | 178.57 | 178.57 | 178.56 | 178.56 | 485.0 |
| 2023-10-11 06:45:00 | AAPL | Stock | 178.6 | 178.6 | 178.6 | 178.6 | 484.0 |
| 2023-10-11 06:50:00 | AAPL | Stock | 178.55 | 178.57 | 178.52 | 178.57 | 884.0 |
| 2023-10-11 06:55:00 | AAPL | Stock | 178.55 | 178.58 | 178.55 | 178.58 | 500.0 |
| 2023-10-11 07:00:00 | AAPL | Stock | 178.56 | 178.62 | 178.56 | 178.61 | 1031.0 |
| 2023-10-11 07:05:00 | AAPL | Stock | 178.63 | 178.8 | 178.63 | 178.8 | 2563.0 |
| 2023-10-11 07:10:00 | AAPL | Stock | 178.85 | 178.87 | 178.82 | 178.82 | 1771.0 |
| 2023-10-11 07:20:00 | AAPL | Stock | 178.85 | 178.85 | 178.85 | 178.85 | 116.0 |
| 2023-10-11 07:25:00 | AAPL | Stock | 178.8 | 178.8 | 178.74 | 178.74 | 1605.0 |
| 2023-10-11 07:30:00 | AAPL | Stock | 178.75 | 178.9 | 178.75 | 178.9 | 3737.0 |
| 2023-10-11 07:35:00 | AAPL | Stock | 178.9 | 178.9 | 178.73 | 178.73 | 3001.0 |
| 2023-10-11 07:40:00 | AAPL | Stock | 178.76 | 178.76 | 178.54 | 178.54 | 5657.0 |
| 2023-10-11 07:45:00 | AAPL | Stock | 178.54 | 178.56 | 178.4 | 178.55 | 7140.0 |
| 2023-10-11 07:50:00 | AAPL | Stock | 178.56 | 178.56 | 178.52 | 178.52 | 1048.0 |
| 2023-10-11 07:55:00 | AAPL | Stock | 178.5 | 178.5 | 178.44 | 178.44 | 2332.0 |
| 2023-10-11 08:00:00 | AAPL | Stock | 178.58 | 178.92 | 178.3 | 178.36 | 32600.0 |
| 2023-10-11 08:05:00 | AAPL | Stock | 178.4167 | 178.5 | 178.4 | 178.49 | 5679.0 |
| 2023-10-11 08:10:00 | AAPL | Stock | 178.47 | 178.5 | 178.37 | 178.37 | 2288.0 |
| 2023-10-11 08:15:00 | AAPL | Stock | 178.35 | 178.45 | 178.35 | 178.35 | 9228.0 |
| 2023-10-11 08:20:00 | AAPL | Stock | 178.38 | 178.49 | 178.38 | 178.38 | 28700.0 |
| 2023-10-11 08:25:00 | AAPL | Stock | 178.4739 | 178.4739 | 178.18 | 178.18 | 10026.0 |
| 2023-10-11 08:30:00 | AAPL | Stock | 178.2 | 178.43 | 177.63 | 178.22 | 34527.0 |
| 2023-10-11 08:35:00 | AAPL | Stock | 178.25 | 178.4174 | 178.07 | 178.0708 | 12502.0 |
| 2023-10-11 08:40:00 | AAPL | Stock | 178.17 | 178.24 | 178.0816 | 178.16 | 7995.0 |
| 2023-10-11 08:45:00 | AAPL | Stock | 178.24 | 178.4 | 178.12 | 178.36 | 58704.0 |
| 2023-10-11 08:50:00 | AAPL | Stock | 178.4 | 178.41 | 178.29 | 178.36 | 7678.0 |
| 2023-10-11 08:55:00 | AAPL | Stock | 178.34 | 178.44 | 178.29 | 178.44 | 12768.0 |
| 2023-10-11 09:00:00 | AAPL | Stock | 178.43 | 178.49 | 178.29 | 178.34 | 15158.0 |
| 2023-10-11 09:05:00 | AAPL | Stock | 178.4 | 178.44 | 178.31 | 178.31 | 15487.0 |
| 2023-10-11 09:10:00 | AAPL | Stock | 178.3 | 178.35 | 178.1 | 178.1 | 11336.0 |
> showing 50 of 388,710 rows — these rows as CSV