PREVIEW / stock_5min / 2024-08-01
file: by_date/stock_5min/2024/2024-08-01.parquet size: 6.8 MB rows: 409,964 symbols: 875
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-08-01 04:00:00 | AAPL | Stock | 223.8 | 223.8 | 223.34 | 223.42 | 4687.0 |
| 2024-08-01 04:05:00 | AAPL | Stock | 223.5 | 223.52 | 223.0 | 223.0 | 1684.0 |
| 2024-08-01 04:10:00 | AAPL | Stock | 223.2 | 223.28 | 223.0 | 223.0 | 1699.0 |
| 2024-08-01 04:15:00 | AAPL | Stock | 222.97 | 223.11 | 222.97 | 223.11 | 3779.0 |
| 2024-08-01 04:20:00 | AAPL | Stock | 223.1 | 223.1 | 222.7 | 222.7 | 1367.0 |
| 2024-08-01 04:25:00 | AAPL | Stock | 222.79 | 223.0 | 222.78 | 222.78 | 2337.0 |
| 2024-08-01 04:30:00 | AAPL | Stock | 223.0 | 223.17 | 223.0 | 223.17 | 2021.0 |
| 2024-08-01 04:35:00 | AAPL | Stock | 223.0 | 223.0 | 222.83 | 222.83 | 646.0 |
| 2024-08-01 04:40:00 | AAPL | Stock | 222.8 | 222.8 | 222.8 | 222.8 | 1249.0 |
| 2024-08-01 04:45:00 | AAPL | Stock | 223.0 | 223.0 | 222.99 | 222.99 | 551.0 |
| 2024-08-01 04:50:00 | AAPL | Stock | 223.11 | 223.12 | 223.05 | 223.05 | 896.0 |
| 2024-08-01 05:00:00 | AAPL | Stock | 223.26 | 223.26 | 223.26 | 223.26 | 181.0 |
| 2024-08-01 05:05:00 | AAPL | Stock | 223.48 | 223.5 | 223.42 | 223.42 | 1983.0 |
| 2024-08-01 05:10:00 | AAPL | Stock | 223.54 | 223.55 | 223.35 | 223.35 | 3097.0 |
| 2024-08-01 05:20:00 | AAPL | Stock | 223.4 | 223.4 | 223.39 | 223.39 | 365.0 |
| 2024-08-01 05:25:00 | AAPL | Stock | 223.35 | 223.35 | 223.35 | 223.35 | 329.0 |
| 2024-08-01 05:35:00 | AAPL | Stock | 223.35 | 223.4 | 223.35 | 223.4 | 1018.0 |
| 2024-08-01 05:40:00 | AAPL | Stock | 223.41 | 223.6 | 223.41 | 223.6 | 940.0 |
| 2024-08-01 05:45:00 | AAPL | Stock | 223.6 | 223.65 | 223.55 | 223.55 | 578.0 |
| 2024-08-01 05:50:00 | AAPL | Stock | 223.6 | 223.6 | 223.6 | 223.6 | 600.0 |
| 2024-08-01 05:55:00 | AAPL | Stock | 223.62 | 223.62 | 223.62 | 223.62 | 206.0 |
| 2024-08-01 06:00:00 | AAPL | Stock | 223.6 | 223.81 | 223.6 | 223.81 | 1242.0 |
| 2024-08-01 06:05:00 | AAPL | Stock | 223.81 | 223.81 | 223.81 | 223.81 | 200.0 |
| 2024-08-01 06:15:00 | AAPL | Stock | 223.75 | 223.75 | 223.75 | 223.75 | 100.0 |
| 2024-08-01 06:20:00 | AAPL | Stock | 223.78 | 223.8 | 223.78 | 223.8 | 2600.0 |
| 2024-08-01 06:25:00 | AAPL | Stock | 223.81 | 223.81 | 223.8 | 223.8 | 305.0 |
| 2024-08-01 06:30:00 | AAPL | Stock | 223.89 | 223.89 | 223.76 | 223.85 | 1023.0 |
| 2024-08-01 06:35:00 | AAPL | Stock | 223.8 | 223.9 | 223.74 | 223.9 | 2419.0 |
| 2024-08-01 06:40:00 | AAPL | Stock | 223.8 | 223.8 | 223.8 | 223.8 | 500.0 |
| 2024-08-01 06:45:00 | AAPL | Stock | 223.86 | 223.96 | 223.81 | 223.96 | 1244.0 |
| 2024-08-01 06:50:00 | AAPL | Stock | 223.99 | 224.0 | 223.99 | 224.0 | 441.0 |
| 2024-08-01 06:55:00 | AAPL | Stock | 224.08 | 224.08 | 224.0 | 224.0 | 756.0 |
| 2024-08-01 07:00:00 | AAPL | Stock | 224.0 | 224.15 | 223.97 | 224.15 | 11128.0 |
| 2024-08-01 07:05:00 | AAPL | Stock | 224.12 | 224.26 | 224.1 | 224.21 | 5374.0 |
| 2024-08-01 07:10:00 | AAPL | Stock | 224.15 | 224.3 | 224.1 | 224.3 | 9886.0 |
| 2024-08-01 07:15:00 | AAPL | Stock | 224.3 | 224.5 | 224.22 | 224.5 | 8378.0 |
| 2024-08-01 07:20:00 | AAPL | Stock | 224.31 | 224.5 | 224.3 | 224.41 | 4834.0 |
| 2024-08-01 07:25:00 | AAPL | Stock | 224.45 | 224.73 | 224.45 | 224.62 | 6620.0 |
| 2024-08-01 07:30:00 | AAPL | Stock | 224.5 | 224.73 | 224.49 | 224.73 | 7199.0 |
| 2024-08-01 07:35:00 | AAPL | Stock | 224.7 | 224.8 | 224.55 | 224.6 | 2427.0 |
| 2024-08-01 07:40:00 | AAPL | Stock | 224.6 | 224.84 | 224.6 | 224.7 | 6640.0 |
| 2024-08-01 07:45:00 | AAPL | Stock | 224.71 | 224.72 | 224.49 | 224.49 | 3825.0 |
| 2024-08-01 07:50:00 | AAPL | Stock | 224.28 | 224.28 | 224.1 | 224.26 | 3599.0 |
| 2024-08-01 07:55:00 | AAPL | Stock | 224.2 | 224.25 | 224.13 | 224.25 | 3299.0 |
| 2024-08-01 08:00:00 | AAPL | Stock | 223.98 | 224.84 | 223.5 | 223.8 | 92998.0 |
| 2024-08-01 08:05:00 | AAPL | Stock | 224.13 | 224.3081 | 224.1151 | 224.3081 | 2602.0 |
| 2024-08-01 08:10:00 | AAPL | Stock | 224.33 | 224.34 | 224.15 | 224.3 | 5069.0 |
| 2024-08-01 08:15:00 | AAPL | Stock | 224.2 | 224.48 | 224.2 | 224.48 | 7032.0 |
| 2024-08-01 08:20:00 | AAPL | Stock | 224.4015 | 224.55 | 224.4 | 224.5 | 7873.0 |
| 2024-08-01 08:25:00 | AAPL | Stock | 224.42 | 224.54 | 224.42 | 224.49 | 5136.0 |
> showing 50 of 409,964 rows — these rows as CSV