PREVIEW / stock_5min / 2024-10-07
file: by_date/stock_5min/2024/2024-10-07.parquet size: 6.7 MB rows: 400,655 symbols: 760
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-07 04:00:00 | AAPL | Stock | 224.88 | 224.88 | 223.7 | 224.4 | 20259.0 |
| 2024-10-07 04:05:00 | AAPL | Stock | 224.3 | 224.5 | 224.2 | 224.2 | 3690.0 |
| 2024-10-07 04:10:00 | AAPL | Stock | 224.41 | 224.45 | 224.32 | 224.45 | 2415.0 |
| 2024-10-07 04:15:00 | AAPL | Stock | 224.44 | 224.6 | 224.28 | 224.56 | 9153.0 |
| 2024-10-07 04:20:00 | AAPL | Stock | 224.53 | 224.53 | 224.45 | 224.5 | 498.0 |
| 2024-10-07 04:25:00 | AAPL | Stock | 224.42 | 224.52 | 224.42 | 224.52 | 2738.0 |
| 2024-10-07 04:30:00 | AAPL | Stock | 224.53 | 224.9 | 224.52 | 224.75 | 4317.0 |
| 2024-10-07 04:35:00 | AAPL | Stock | 224.85 | 224.92 | 224.85 | 224.85 | 1350.0 |
| 2024-10-07 04:40:00 | AAPL | Stock | 224.76 | 224.76 | 224.29 | 224.29 | 4770.0 |
| 2024-10-07 04:45:00 | AAPL | Stock | 224.39 | 224.39 | 224.1 | 224.1 | 2073.0 |
| 2024-10-07 04:50:00 | AAPL | Stock | 224.1 | 224.1 | 224.1 | 224.1 | 660.0 |
| 2024-10-07 04:55:00 | AAPL | Stock | 224.1 | 224.1 | 224.0 | 224.0 | 3313.0 |
| 2024-10-07 05:00:00 | AAPL | Stock | 224.0 | 224.0 | 223.7 | 223.7 | 8211.0 |
| 2024-10-07 05:05:00 | AAPL | Stock | 223.62 | 223.62 | 223.58 | 223.59 | 2969.0 |
| 2024-10-07 05:10:00 | AAPL | Stock | 223.58 | 223.59 | 223.0 | 223.51 | 5515.0 |
| 2024-10-07 05:15:00 | AAPL | Stock | 223.56 | 223.7 | 223.5 | 223.7 | 2904.0 |
| 2024-10-07 05:20:00 | AAPL | Stock | 223.65 | 223.65 | 223.5 | 223.5 | 2896.0 |
| 2024-10-07 05:25:00 | AAPL | Stock | 223.4 | 223.46 | 223.3 | 223.37 | 3053.0 |
| 2024-10-07 05:30:00 | AAPL | Stock | 223.31 | 223.41 | 223.31 | 223.41 | 852.0 |
| 2024-10-07 05:35:00 | AAPL | Stock | 223.5 | 223.5 | 223.45 | 223.5 | 2068.0 |
| 2024-10-07 05:40:00 | AAPL | Stock | 223.49 | 223.52 | 223.45 | 223.45 | 4773.0 |
| 2024-10-07 05:45:00 | AAPL | Stock | 223.42 | 223.42 | 223.41 | 223.41 | 1043.0 |
| 2024-10-07 05:50:00 | AAPL | Stock | 223.49 | 223.5 | 223.49 | 223.5 | 1668.0 |
| 2024-10-07 05:55:00 | AAPL | Stock | 223.65 | 223.7 | 223.65 | 223.7 | 2801.0 |
| 2024-10-07 06:00:00 | AAPL | Stock | 223.6 | 223.6 | 223.41 | 223.55 | 1805.0 |
| 2024-10-07 06:05:00 | AAPL | Stock | 223.55 | 223.65 | 223.55 | 223.65 | 1664.0 |
| 2024-10-07 06:10:00 | AAPL | Stock | 223.6 | 223.6 | 223.47 | 223.47 | 1266.0 |
| 2024-10-07 06:15:00 | AAPL | Stock | 223.52 | 223.52 | 223.5 | 223.5 | 1070.0 |
| 2024-10-07 06:20:00 | AAPL | Stock | 223.53 | 223.57 | 223.46 | 223.47 | 2102.0 |
| 2024-10-07 06:25:00 | AAPL | Stock | 223.41 | 223.5 | 223.41 | 223.49 | 1875.0 |
| 2024-10-07 06:30:00 | AAPL | Stock | 223.49 | 223.6 | 223.49 | 223.51 | 747.0 |
| 2024-10-07 06:35:00 | AAPL | Stock | 223.56 | 223.56 | 223.5 | 223.51 | 4716.0 |
| 2024-10-07 06:40:00 | AAPL | Stock | 223.51 | 223.6 | 223.51 | 223.55 | 944.0 |
| 2024-10-07 06:45:00 | AAPL | Stock | 223.55 | 223.55 | 223.48 | 223.49 | 6326.0 |
| 2024-10-07 06:50:00 | AAPL | Stock | 223.55 | 223.68 | 223.55 | 223.68 | 1269.0 |
| 2024-10-07 06:55:00 | AAPL | Stock | 223.68 | 223.68 | 223.62 | 223.62 | 2633.0 |
| 2024-10-07 07:00:00 | AAPL | Stock | 223.65 | 224.1 | 223.49 | 223.95 | 17269.0 |
| 2024-10-07 07:05:00 | AAPL | Stock | 223.94 | 223.94 | 223.75 | 223.8 | 8299.0 |
| 2024-10-07 07:10:00 | AAPL | Stock | 223.8 | 223.86 | 223.66 | 223.7 | 25468.0 |
| 2024-10-07 07:15:00 | AAPL | Stock | 223.7 | 223.88 | 223.7 | 223.82 | 3742.0 |
| 2024-10-07 07:20:00 | AAPL | Stock | 223.89 | 223.94 | 223.89 | 223.94 | 3726.0 |
| 2024-10-07 07:25:00 | AAPL | Stock | 223.89 | 224.0 | 223.84 | 223.95 | 5208.0 |
| 2024-10-07 07:30:00 | AAPL | Stock | 223.84 | 223.95 | 223.84 | 223.95 | 2137.0 |
| 2024-10-07 07:35:00 | AAPL | Stock | 223.93 | 224.06 | 223.93 | 223.98 | 2165.0 |
| 2024-10-07 07:40:00 | AAPL | Stock | 224.04 | 224.24 | 224.04 | 224.24 | 2287.0 |
| 2024-10-07 07:45:00 | AAPL | Stock | 224.14 | 224.29 | 224.14 | 224.29 | 2797.0 |
| 2024-10-07 07:50:00 | AAPL | Stock | 224.24 | 224.26 | 224.19 | 224.26 | 14334.0 |
| 2024-10-07 07:55:00 | AAPL | Stock | 224.19 | 224.19 | 224.17 | 224.17 | 1121.0 |
| 2024-10-07 08:00:00 | AAPL | Stock | 223.85 | 226.0 | 223.58 | 224.22 | 59298.0 |
| 2024-10-07 08:05:00 | AAPL | Stock | 224.22 | 226.233 | 224.16 | 224.3515 | 5376.0 |
> showing 50 of 400,655 rows — these rows as CSV