PREVIEW / stock_5min / 2024-10-04
file: by_date/stock_5min/2024/2024-10-04.parquet size: 6.7 MB rows: 397,075 symbols: 750
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-04 04:00:00 | AAPL | Stock | 226.08 | 226.5 | 225.99 | 226.05 | 10266.0 |
| 2024-10-04 04:05:00 | AAPL | Stock | 226.09 | 226.1 | 225.79 | 225.85 | 2177.0 |
| 2024-10-04 04:15:00 | AAPL | Stock | 225.86 | 225.9 | 225.85 | 225.88 | 1794.0 |
| 2024-10-04 04:20:00 | AAPL | Stock | 225.82 | 225.85 | 225.82 | 225.85 | 1494.0 |
| 2024-10-04 04:25:00 | AAPL | Stock | 225.9 | 225.93 | 225.9 | 225.93 | 1087.0 |
| 2024-10-04 04:30:00 | AAPL | Stock | 225.9 | 225.9 | 225.9 | 225.9 | 400.0 |
| 2024-10-04 04:40:00 | AAPL | Stock | 225.95 | 225.99 | 225.95 | 225.99 | 250.0 |
| 2024-10-04 04:45:00 | AAPL | Stock | 225.91 | 225.91 | 225.85 | 225.85 | 1158.0 |
| 2024-10-04 04:50:00 | AAPL | Stock | 225.86 | 225.86 | 225.86 | 225.86 | 100.0 |
| 2024-10-04 04:55:00 | AAPL | Stock | 225.86 | 225.86 | 225.86 | 225.86 | 115.0 |
| 2024-10-04 05:15:00 | AAPL | Stock | 225.83 | 225.83 | 225.83 | 225.83 | 105.0 |
| 2024-10-04 05:20:00 | AAPL | Stock | 225.74 | 225.74 | 225.67 | 225.67 | 332.0 |
| 2024-10-04 05:30:00 | AAPL | Stock | 225.65 | 225.72 | 225.65 | 225.72 | 700.0 |
| 2024-10-04 05:45:00 | AAPL | Stock | 225.66 | 225.67 | 225.66 | 225.66 | 382.0 |
| 2024-10-04 05:55:00 | AAPL | Stock | 225.76 | 225.87 | 225.76 | 225.87 | 2183.0 |
| 2024-10-04 06:00:00 | AAPL | Stock | 225.95 | 226.04 | 225.95 | 226.04 | 3756.0 |
| 2024-10-04 06:10:00 | AAPL | Stock | 226.08 | 226.11 | 226.0 | 226.11 | 702.0 |
| 2024-10-04 06:15:00 | AAPL | Stock | 226.13 | 226.24 | 226.13 | 226.24 | 223.0 |
| 2024-10-04 06:20:00 | AAPL | Stock | 226.14 | 226.14 | 226.14 | 226.14 | 187.0 |
| 2024-10-04 06:25:00 | AAPL | Stock | 226.13 | 226.13 | 226.13 | 226.13 | 140.0 |
| 2024-10-04 06:35:00 | AAPL | Stock | 226.22 | 226.22 | 226.22 | 226.22 | 480.0 |
| 2024-10-04 06:40:00 | AAPL | Stock | 226.19 | 226.19 | 226.19 | 226.19 | 240.0 |
| 2024-10-04 06:45:00 | AAPL | Stock | 226.05 | 226.2 | 225.96 | 225.96 | 2045.0 |
| 2024-10-04 06:50:00 | AAPL | Stock | 226.01 | 226.01 | 226.01 | 226.01 | 100.0 |
| 2024-10-04 06:55:00 | AAPL | Stock | 226.18 | 226.18 | 226.18 | 226.18 | 300.0 |
| 2024-10-04 07:00:00 | AAPL | Stock | 226.01 | 226.2 | 225.99 | 226.2 | 5034.0 |
| 2024-10-04 07:05:00 | AAPL | Stock | 226.17 | 226.17 | 226.17 | 226.17 | 169.0 |
| 2024-10-04 07:10:00 | AAPL | Stock | 226.19 | 226.19 | 226.16 | 226.16 | 200.0 |
| 2024-10-04 07:15:00 | AAPL | Stock | 226.2 | 226.35 | 226.2 | 226.35 | 1869.0 |
| 2024-10-04 07:20:00 | AAPL | Stock | 226.34 | 226.45 | 226.34 | 226.45 | 589.0 |
| 2024-10-04 07:25:00 | AAPL | Stock | 226.4 | 226.44 | 226.39 | 226.43 | 1954.0 |
| 2024-10-04 07:30:00 | AAPL | Stock | 226.43 | 226.6 | 226.43 | 226.6 | 2616.0 |
| 2024-10-04 07:35:00 | AAPL | Stock | 226.52 | 226.52 | 226.5 | 226.51 | 2388.0 |
| 2024-10-04 07:40:00 | AAPL | Stock | 226.46 | 226.46 | 226.46 | 226.46 | 350.0 |
| 2024-10-04 07:45:00 | AAPL | Stock | 226.5 | 226.5 | 226.49 | 226.5 | 2173.0 |
| 2024-10-04 07:50:00 | AAPL | Stock | 226.52 | 226.52 | 226.47 | 226.47 | 1891.0 |
| 2024-10-04 07:55:00 | AAPL | Stock | 226.46 | 226.5 | 226.46 | 226.5 | 300.0 |
| 2024-10-04 08:00:00 | AAPL | Stock | 226.0 | 226.6 | 225.106 | 226.41 | 33325.0 |
| 2024-10-04 08:05:00 | AAPL | Stock | 226.42 | 226.42 | 226.3 | 226.42 | 5725.0 |
| 2024-10-04 08:10:00 | AAPL | Stock | 226.308 | 226.6198 | 226.308 | 226.56 | 3648.0 |
| 2024-10-04 08:15:00 | AAPL | Stock | 226.56 | 226.57 | 226.477 | 226.477 | 965.0 |
| 2024-10-04 08:20:00 | AAPL | Stock | 226.45 | 226.6286 | 226.45 | 226.6286 | 2590.0 |
| 2024-10-04 08:25:00 | AAPL | Stock | 226.58 | 226.64 | 226.5345 | 226.63 | 11875.0 |
| 2024-10-04 08:30:00 | AAPL | Stock | 226.63 | 227.25 | 226.63 | 227.06 | 27532.0 |
| 2024-10-04 08:35:00 | AAPL | Stock | 227.0748 | 227.4 | 227.0748 | 227.22 | 12796.0 |
| 2024-10-04 08:40:00 | AAPL | Stock | 227.2 | 227.4 | 227.2 | 227.4 | 13742.0 |
| 2024-10-04 08:45:00 | AAPL | Stock | 227.35 | 227.47 | 227.305 | 227.47 | 9408.0 |
| 2024-10-04 08:50:00 | AAPL | Stock | 227.44 | 227.82 | 227.3827 | 227.62 | 27009.0 |
| 2024-10-04 08:55:00 | AAPL | Stock | 227.6982 | 227.9 | 227.6 | 227.85 | 15118.0 |
| 2024-10-04 09:00:00 | AAPL | Stock | 227.9 | 227.92 | 227.64 | 227.83 | 17862.0 |
> showing 50 of 397,075 rows — these rows as CSV