PREVIEW / stock_5min / 2023-01-23
file: by_date/stock_5min/2023/2023-01-23.parquet size: 7.1 MB rows: 429,317 symbols: 1,961
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 |
|---|---|---|---|---|---|---|---|
| 2023-01-23 04:00:00 | AAPL | Stock | 138.5 | 138.5 | 137.7 | 137.81 | 4355.0 |
| 2023-01-23 04:05:00 | AAPL | Stock | 137.81 | 137.81 | 137.63 | 137.63 | 1692.0 |
| 2023-01-23 04:10:00 | AAPL | Stock | 137.67 | 137.7 | 137.6 | 137.7 | 4325.0 |
| 2023-01-23 04:15:00 | AAPL | Stock | 137.71 | 137.74 | 137.66 | 137.72 | 1350.0 |
| 2023-01-23 04:20:00 | AAPL | Stock | 137.68 | 137.68 | 137.65 | 137.65 | 751.0 |
| 2023-01-23 04:25:00 | AAPL | Stock | 137.64 | 137.64 | 137.56 | 137.56 | 1928.0 |
| 2023-01-23 04:30:00 | AAPL | Stock | 137.65 | 137.75 | 137.65 | 137.7 | 1649.0 |
| 2023-01-23 04:35:00 | AAPL | Stock | 137.7 | 137.7 | 137.57 | 137.57 | 868.0 |
| 2023-01-23 04:40:00 | AAPL | Stock | 137.72 | 137.72 | 137.64 | 137.64 | 1166.0 |
| 2023-01-23 04:45:00 | AAPL | Stock | 137.64 | 137.7 | 137.61 | 137.7 | 2240.0 |
| 2023-01-23 04:50:00 | AAPL | Stock | 137.7 | 137.75 | 137.66 | 137.69 | 3061.0 |
| 2023-01-23 04:55:00 | AAPL | Stock | 137.74 | 137.76 | 137.71 | 137.73 | 1542.0 |
| 2023-01-23 05:00:00 | AAPL | Stock | 137.74 | 137.83 | 137.74 | 137.8 | 2119.0 |
| 2023-01-23 05:05:00 | AAPL | Stock | 137.8 | 137.8 | 137.6 | 137.66 | 1959.0 |
| 2023-01-23 05:10:00 | AAPL | Stock | 137.67 | 137.67 | 137.6 | 137.61 | 733.0 |
| 2023-01-23 05:15:00 | AAPL | Stock | 137.58 | 137.58 | 137.34 | 137.4 | 5141.0 |
| 2023-01-23 05:20:00 | AAPL | Stock | 137.36 | 137.43 | 137.3 | 137.3 | 5109.0 |
| 2023-01-23 05:25:00 | AAPL | Stock | 137.32 | 137.32 | 137.32 | 137.32 | 100.0 |
| 2023-01-23 05:30:00 | AAPL | Stock | 137.32 | 137.35 | 137.22 | 137.25 | 6748.0 |
| 2023-01-23 05:35:00 | AAPL | Stock | 137.3 | 137.38 | 137.3 | 137.38 | 1287.0 |
| 2023-01-23 05:40:00 | AAPL | Stock | 137.32 | 137.32 | 137.24 | 137.31 | 836.0 |
| 2023-01-23 05:45:00 | AAPL | Stock | 137.41 | 137.41 | 137.33 | 137.39 | 1281.0 |
| 2023-01-23 05:50:00 | AAPL | Stock | 137.43 | 137.43 | 137.41 | 137.41 | 448.0 |
| 2023-01-23 05:55:00 | AAPL | Stock | 137.42 | 137.42 | 137.41 | 137.41 | 272.0 |
| 2023-01-23 06:00:00 | AAPL | Stock | 137.39 | 137.39 | 137.39 | 137.39 | 140.0 |
| 2023-01-23 06:05:00 | AAPL | Stock | 137.3 | 137.4 | 137.3 | 137.4 | 1284.0 |
| 2023-01-23 06:10:00 | AAPL | Stock | 137.4 | 137.4 | 137.37 | 137.37 | 1902.0 |
| 2023-01-23 06:15:00 | AAPL | Stock | 137.44 | 137.58 | 137.44 | 137.54 | 2214.0 |
| 2023-01-23 06:20:00 | AAPL | Stock | 137.51 | 137.6 | 137.48 | 137.48 | 830.0 |
| 2023-01-23 06:25:00 | AAPL | Stock | 137.5 | 137.5 | 137.45 | 137.45 | 432.0 |
| 2023-01-23 06:30:00 | AAPL | Stock | 137.55 | 137.55 | 137.53 | 137.53 | 720.0 |
| 2023-01-23 06:35:00 | AAPL | Stock | 137.59 | 137.59 | 137.5 | 137.54 | 2041.0 |
| 2023-01-23 06:40:00 | AAPL | Stock | 137.54 | 137.54 | 137.5 | 137.5 | 410.0 |
| 2023-01-23 06:45:00 | AAPL | Stock | 137.47 | 137.47 | 137.41 | 137.42 | 1043.0 |
| 2023-01-23 06:50:00 | AAPL | Stock | 137.55 | 137.56 | 137.43 | 137.43 | 1350.0 |
| 2023-01-23 06:55:00 | AAPL | Stock | 137.43 | 137.43 | 137.41 | 137.42 | 1097.0 |
| 2023-01-23 07:00:00 | AAPL | Stock | 137.54 | 137.6 | 137.48 | 137.55 | 6974.0 |
| 2023-01-23 07:05:00 | AAPL | Stock | 137.52 | 137.58 | 137.52 | 137.52 | 2277.0 |
| 2023-01-23 07:10:00 | AAPL | Stock | 137.57 | 137.58 | 137.41 | 137.42 | 6274.0 |
| 2023-01-23 07:15:00 | AAPL | Stock | 137.55 | 137.8 | 137.55 | 137.8 | 15026.0 |
| 2023-01-23 07:20:00 | AAPL | Stock | 137.71 | 137.8 | 137.67 | 137.75 | 2758.0 |
| 2023-01-23 07:25:00 | AAPL | Stock | 137.7 | 137.7 | 137.67 | 137.67 | 446.0 |
| 2023-01-23 07:30:00 | AAPL | Stock | 137.69 | 137.72 | 137.59 | 137.63 | 3541.0 |
| 2023-01-23 07:35:00 | AAPL | Stock | 137.7 | 137.85 | 137.7 | 137.84 | 5142.0 |
| 2023-01-23 07:40:00 | AAPL | Stock | 137.82 | 138.01 | 137.8 | 138.01 | 10122.0 |
| 2023-01-23 07:45:00 | AAPL | Stock | 138.06 | 138.13 | 138.01 | 138.03 | 7442.0 |
| 2023-01-23 07:50:00 | AAPL | Stock | 138.03 | 138.03 | 137.95 | 137.97 | 10726.0 |
| 2023-01-23 07:55:00 | AAPL | Stock | 137.92 | 137.96 | 137.8 | 137.87 | 4015.0 |
| 2023-01-23 08:00:00 | AAPL | Stock | 137.5135 | 138.11 | 137.4285 | 138.106 | 51974.0 |
| 2023-01-23 08:05:00 | AAPL | Stock | 138.12 | 138.28 | 138.12 | 138.19 | 12098.0 |
> showing 50 of 429,317 rows — these rows as CSV