PREVIEW / stock_5min / 2024-10-17
file: by_date/stock_5min/2024/2024-10-17.parquet size: 6.8 MB rows: 399,643 symbols: 749
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 |
|---|---|---|---|---|---|---|---|
| 2024-10-17 04:00:00 | AAPL | Stock | 232.0 | 233.43 | 232.0 | 233.12 | 7558.0 |
| 2024-10-17 04:05:00 | AAPL | Stock | 233.0 | 233.0 | 232.77 | 232.77 | 830.0 |
| 2024-10-17 04:10:00 | AAPL | Stock | 232.9 | 233.3 | 232.9 | 233.28 | 1242.0 |
| 2024-10-17 04:15:00 | AAPL | Stock | 233.27 | 233.3 | 233.26 | 233.28 | 4041.0 |
| 2024-10-17 04:20:00 | AAPL | Stock | 233.25 | 233.25 | 233.2 | 233.2 | 537.0 |
| 2024-10-17 04:25:00 | AAPL | Stock | 233.18 | 233.19 | 233.0 | 233.1 | 6687.0 |
| 2024-10-17 04:30:00 | AAPL | Stock | 233.06 | 233.28 | 233.0 | 233.13 | 3202.0 |
| 2024-10-17 04:35:00 | AAPL | Stock | 232.82 | 232.99 | 232.81 | 232.81 | 1498.0 |
| 2024-10-17 04:40:00 | AAPL | Stock | 232.8 | 233.04 | 232.8 | 233.04 | 1169.0 |
| 2024-10-17 04:45:00 | AAPL | Stock | 233.04 | 233.25 | 232.99 | 233.25 | 7098.0 |
| 2024-10-17 04:50:00 | AAPL | Stock | 233.21 | 233.64 | 233.21 | 233.6 | 6633.0 |
| 2024-10-17 04:55:00 | AAPL | Stock | 233.9 | 233.9 | 232.9 | 232.9 | 4571.0 |
| 2024-10-17 05:00:00 | AAPL | Stock | 232.86 | 233.0 | 232.81 | 232.82 | 2175.0 |
| 2024-10-17 05:05:00 | AAPL | Stock | 232.81 | 233.27 | 232.81 | 233.17 | 8666.0 |
| 2024-10-17 05:10:00 | AAPL | Stock | 233.23 | 233.34 | 232.99 | 233.12 | 25817.0 |
| 2024-10-17 05:15:00 | AAPL | Stock | 233.28 | 233.44 | 233.0 | 233.0 | 3724.0 |
| 2024-10-17 05:20:00 | AAPL | Stock | 233.01 | 233.29 | 232.94 | 233.27 | 4939.0 |
| 2024-10-17 05:25:00 | AAPL | Stock | 233.39 | 233.49 | 233.27 | 233.49 | 5091.0 |
| 2024-10-17 05:30:00 | AAPL | Stock | 233.3 | 233.3 | 232.94 | 233.13 | 12968.0 |
| 2024-10-17 05:35:00 | AAPL | Stock | 233.14 | 233.78 | 233.14 | 233.69 | 15625.0 |
| 2024-10-17 05:40:00 | AAPL | Stock | 233.67 | 233.69 | 233.48 | 233.54 | 1908.0 |
| 2024-10-17 05:45:00 | AAPL | Stock | 233.54 | 233.69 | 233.5 | 233.5 | 2109.0 |
| 2024-10-17 05:50:00 | AAPL | Stock | 233.5 | 233.64 | 233.41 | 233.64 | 4376.0 |
| 2024-10-17 05:55:00 | AAPL | Stock | 233.51 | 233.65 | 233.5 | 233.65 | 1951.0 |
| 2024-10-17 06:00:00 | AAPL | Stock | 233.49 | 233.6 | 233.49 | 233.6 | 2509.0 |
| 2024-10-17 06:05:00 | AAPL | Stock | 233.5 | 233.66 | 233.5 | 233.5 | 1634.0 |
| 2024-10-17 06:10:00 | AAPL | Stock | 233.6 | 233.6 | 233.41 | 233.41 | 937.0 |
| 2024-10-17 06:15:00 | AAPL | Stock | 233.36 | 233.7 | 233.36 | 233.61 | 11226.0 |
| 2024-10-17 06:20:00 | AAPL | Stock | 233.66 | 233.66 | 233.23 | 233.33 | 2820.0 |
| 2024-10-17 06:25:00 | AAPL | Stock | 233.4 | 233.48 | 233.27 | 233.29 | 5713.0 |
| 2024-10-17 06:30:00 | AAPL | Stock | 233.4 | 233.4 | 233.26 | 233.3 | 710.0 |
| 2024-10-17 06:35:00 | AAPL | Stock | 233.25 | 233.69 | 233.18 | 233.69 | 7577.0 |
| 2024-10-17 06:40:00 | AAPL | Stock | 233.67 | 233.71 | 233.56 | 233.65 | 4793.0 |
| 2024-10-17 06:45:00 | AAPL | Stock | 233.67 | 233.68 | 233.45 | 233.45 | 5767.0 |
| 2024-10-17 06:50:00 | AAPL | Stock | 233.54 | 233.54 | 233.53 | 233.53 | 900.0 |
| 2024-10-17 06:55:00 | AAPL | Stock | 233.55 | 233.68 | 233.55 | 233.65 | 5041.0 |
| 2024-10-17 07:00:00 | AAPL | Stock | 233.53 | 233.6 | 233.35 | 233.4 | 13618.0 |
| 2024-10-17 07:05:00 | AAPL | Stock | 233.44 | 233.48 | 233.35 | 233.38 | 2381.0 |
| 2024-10-17 07:10:00 | AAPL | Stock | 233.42 | 233.48 | 233.39 | 233.47 | 5297.0 |
| 2024-10-17 07:15:00 | AAPL | Stock | 233.35 | 233.45 | 233.311 | 233.33 | 1994.0 |
| 2024-10-17 07:20:00 | AAPL | Stock | 233.33 | 233.33 | 233.17 | 233.31 | 4601.0 |
| 2024-10-17 07:25:00 | AAPL | Stock | 233.3 | 233.3 | 233.18 | 233.25 | 1215.0 |
| 2024-10-17 07:30:00 | AAPL | Stock | 233.33 | 233.38 | 233.33 | 233.35 | 1593.0 |
| 2024-10-17 07:35:00 | AAPL | Stock | 233.29 | 233.79 | 233.27 | 233.77 | 16120.0 |
| 2024-10-17 07:40:00 | AAPL | Stock | 233.76 | 233.76 | 233.6 | 233.6 | 3649.0 |
| 2024-10-17 07:45:00 | AAPL | Stock | 233.6 | 233.6 | 233.5 | 233.5 | 1045.0 |
| 2024-10-17 07:50:00 | AAPL | Stock | 233.46 | 233.48 | 233.41 | 233.44 | 2288.0 |
| 2024-10-17 07:55:00 | AAPL | Stock | 233.4 | 233.52 | 233.4 | 233.47 | 4393.0 |
| 2024-10-17 08:00:00 | AAPL | Stock | 233.53 | 233.7995 | 231.201 | 233.62 | 55198.0 |
| 2024-10-17 08:05:00 | AAPL | Stock | 233.64 | 233.81 | 233.56 | 233.81 | 17378.0 |
> showing 50 of 399,643 rows — these rows as CSV