PREVIEW / stock_5min / 2024-10-29
file: by_date/stock_5min/2024/2024-10-29.parquet size: 6.9 MB rows: 409,494 symbols: 746
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-29 04:00:00 | AAPL | Stock | 232.7 | 232.96 | 232.41 | 232.72 | 6336.0 |
| 2024-10-29 04:05:00 | AAPL | Stock | 232.67 | 232.84 | 232.65 | 232.84 | 682.0 |
| 2024-10-29 04:10:00 | AAPL | Stock | 232.84 | 232.84 | 232.29 | 232.29 | 3494.0 |
| 2024-10-29 04:15:00 | AAPL | Stock | 232.74 | 232.76 | 232.74 | 232.76 | 355.0 |
| 2024-10-29 04:20:00 | AAPL | Stock | 232.71 | 232.73 | 232.71 | 232.73 | 704.0 |
| 2024-10-29 04:25:00 | AAPL | Stock | 232.88 | 232.98 | 232.88 | 232.98 | 448.0 |
| 2024-10-29 04:30:00 | AAPL | Stock | 232.89 | 232.89 | 232.89 | 232.89 | 614.0 |
| 2024-10-29 04:35:00 | AAPL | Stock | 232.99 | 233.1 | 232.99 | 233.1 | 204.0 |
| 2024-10-29 04:50:00 | AAPL | Stock | 233.2 | 233.2 | 233.17 | 233.17 | 1812.0 |
| 2024-10-29 04:55:00 | AAPL | Stock | 233.05 | 233.11 | 232.98 | 232.98 | 1674.0 |
| 2024-10-29 05:00:00 | AAPL | Stock | 233.11 | 233.11 | 233.11 | 233.11 | 100.0 |
| 2024-10-29 05:05:00 | AAPL | Stock | 232.99 | 233.0 | 232.95 | 233.0 | 1134.0 |
| 2024-10-29 05:10:00 | AAPL | Stock | 232.95 | 232.95 | 232.73 | 232.73 | 1191.0 |
| 2024-10-29 05:15:00 | AAPL | Stock | 232.77 | 232.79 | 232.69 | 232.69 | 2716.0 |
| 2024-10-29 05:20:00 | AAPL | Stock | 232.6 | 232.8 | 232.6 | 232.8 | 1342.0 |
| 2024-10-29 05:30:00 | AAPL | Stock | 232.7 | 232.7 | 232.5 | 232.68 | 1823.0 |
| 2024-10-29 05:35:00 | AAPL | Stock | 232.54 | 232.54 | 232.54 | 232.54 | 100.0 |
| 2024-10-29 05:45:00 | AAPL | Stock | 232.73 | 232.75 | 232.69 | 232.69 | 1104.0 |
| 2024-10-29 05:50:00 | AAPL | Stock | 232.6 | 232.6 | 232.6 | 232.6 | 123.0 |
| 2024-10-29 05:55:00 | AAPL | Stock | 232.68 | 232.68 | 232.68 | 232.68 | 290.0 |
| 2024-10-29 06:00:00 | AAPL | Stock | 232.69 | 232.69 | 232.65 | 232.65 | 720.0 |
| 2024-10-29 06:05:00 | AAPL | Stock | 232.61 | 232.61 | 232.61 | 232.61 | 1871.0 |
| 2024-10-29 06:10:00 | AAPL | Stock | 232.62 | 232.62 | 232.6 | 232.6 | 952.0 |
| 2024-10-29 06:20:00 | AAPL | Stock | 232.52 | 232.52 | 232.52 | 232.52 | 134.0 |
| 2024-10-29 06:25:00 | AAPL | Stock | 232.51 | 232.53 | 232.5 | 232.5 | 2504.0 |
| 2024-10-29 06:35:00 | AAPL | Stock | 232.58 | 232.66 | 232.5 | 232.66 | 2114.0 |
| 2024-10-29 06:40:00 | AAPL | Stock | 232.54 | 232.54 | 232.54 | 232.54 | 100.0 |
| 2024-10-29 06:45:00 | AAPL | Stock | 232.43 | 232.43 | 232.42 | 232.42 | 350.0 |
| 2024-10-29 06:50:00 | AAPL | Stock | 232.6 | 232.6 | 232.6 | 232.6 | 150.0 |
| 2024-10-29 07:00:00 | AAPL | Stock | 232.58 | 232.69 | 232.45 | 232.63 | 4467.0 |
| 2024-10-29 07:05:00 | AAPL | Stock | 232.53 | 232.53 | 232.01 | 232.01 | 3961.0 |
| 2024-10-29 07:10:00 | AAPL | Stock | 232.08 | 232.33 | 232.05 | 232.33 | 2894.0 |
| 2024-10-29 07:15:00 | AAPL | Stock | 232.21 | 232.37 | 231.76 | 231.81 | 13736.0 |
| 2024-10-29 07:20:00 | AAPL | Stock | 232.14 | 232.2 | 232.06 | 232.12 | 2127.0 |
| 2024-10-29 07:25:00 | AAPL | Stock | 232.24 | 232.36 | 232.13 | 232.13 | 1918.0 |
| 2024-10-29 07:30:00 | AAPL | Stock | 232.21 | 232.21 | 232.1 | 232.17 | 1292.0 |
| 2024-10-29 07:35:00 | AAPL | Stock | 232.32 | 232.37 | 232.32 | 232.37 | 867.0 |
| 2024-10-29 07:40:00 | AAPL | Stock | 232.25 | 232.68 | 232.25 | 232.58 | 3226.0 |
| 2024-10-29 07:45:00 | AAPL | Stock | 232.55 | 232.66 | 232.28 | 232.28 | 3935.0 |
| 2024-10-29 07:50:00 | AAPL | Stock | 232.38 | 232.38 | 232.17 | 232.18 | 3396.0 |
| 2024-10-29 07:55:00 | AAPL | Stock | 232.18 | 232.27 | 232.17 | 232.27 | 908.0 |
| 2024-10-29 08:00:00 | AAPL | Stock | 232.35 | 233.17 | 231.8 | 231.87 | 49310.0 |
| 2024-10-29 08:05:00 | AAPL | Stock | 231.85 | 231.93 | 231.61 | 231.61 | 7526.0 |
| 2024-10-29 08:10:00 | AAPL | Stock | 231.61 | 232.817 | 231.6 | 231.94 | 5948.0 |
| 2024-10-29 08:15:00 | AAPL | Stock | 231.99 | 232.39 | 231.99 | 232.3 | 4171.0 |
| 2024-10-29 08:20:00 | AAPL | Stock | 232.3 | 232.3299 | 232.15 | 232.2 | 8122.0 |
| 2024-10-29 08:25:00 | AAPL | Stock | 232.25 | 232.35 | 232.1511 | 232.2619 | 1970.0 |
| 2024-10-29 08:30:00 | AAPL | Stock | 232.31 | 232.35 | 232.26 | 232.26 | 2233.0 |
| 2024-10-29 08:35:00 | AAPL | Stock | 232.2597 | 232.4 | 232.16 | 232.4 | 2865.0 |
| 2024-10-29 08:40:00 | AAPL | Stock | 232.4 | 232.59 | 232.4 | 232.46 | 3126.0 |
> showing 50 of 409,494 rows — these rows as CSV