PREVIEW / stock_30min / 2024-01-08
file: by_date/stock_30min/2024/2024-01-08.parquet size: 2.1 MB rows: 100,590 symbols: 1,181
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-01-08 04:00:00 | AAPL | Stock | 180.81 | 180.81 | 180.26 | 180.26 | 9456.0 |
| 2024-01-08 04:30:00 | AAPL | Stock | 180.28 | 180.7 | 179.96 | 180.55 | 26929.0 |
| 2024-01-08 05:00:00 | AAPL | Stock | 180.59 | 180.73 | 180.46 | 180.67 | 9019.0 |
| 2024-01-08 05:30:00 | AAPL | Stock | 180.61 | 180.63 | 180.22 | 180.43 | 11647.0 |
| 2024-01-08 06:00:00 | AAPL | Stock | 180.4 | 181.17 | 180.34 | 181.17 | 20907.0 |
| 2024-01-08 06:30:00 | AAPL | Stock | 181.13 | 181.64 | 181.13 | 181.64 | 15115.0 |
| 2024-01-08 07:00:00 | AAPL | Stock | 181.62 | 181.89 | 180.85 | 181.7 | 60442.0 |
| 2024-01-08 07:30:00 | AAPL | Stock | 181.68 | 181.91 | 181.4 | 181.91 | 18686.0 |
| 2024-01-08 08:00:00 | AAPL | Stock | 181.15 | 181.9 | 179.68 | 181.7 | 107165.0 |
| 2024-01-08 08:30:00 | AAPL | Stock | 181.64 | 181.75 | 181.308 | 181.37 | 60059.0 |
| 2024-01-08 09:00:00 | AAPL | Stock | 181.3996 | 182.6 | 181.3996 | 182.14 | 388747.0 |
| 2024-01-08 09:30:00 | AAPL | Stock | 182.15 | 183.505 | 181.5 | 183.4141 | 6948437.0 |
| 2024-01-08 10:00:00 | AAPL | Stock | 183.41 | 183.885 | 183.3 | 183.81 | 3410585.0 |
| 2024-01-08 10:30:00 | AAPL | Stock | 183.82 | 183.88 | 183.39 | 183.585 | 2106723.0 |
| 2024-01-08 11:00:00 | AAPL | Stock | 183.59 | 183.64 | 183.21 | 183.245 | 1762542.0 |
| 2024-01-08 11:30:00 | AAPL | Stock | 183.245 | 183.85 | 183.235 | 183.835 | 2072753.0 |
| 2024-01-08 12:00:00 | AAPL | Stock | 183.84 | 184.57 | 183.83 | 183.9901 | 2813952.0 |
| 2024-01-08 12:30:00 | AAPL | Stock | 184.0 | 184.47 | 183.96 | 184.2546 | 1496740.0 |
| 2024-01-08 13:00:00 | AAPL | Stock | 184.251 | 184.27 | 184.01 | 184.115 | 1184267.0 |
| 2024-01-08 13:30:00 | AAPL | Stock | 184.12 | 184.72 | 184.05 | 184.7101 | 1387637.0 |
| 2024-01-08 14:00:00 | AAPL | Stock | 184.72 | 184.875 | 184.55 | 184.8325 | 1707978.0 |
| 2024-01-08 14:30:00 | AAPL | Stock | 184.84 | 185.321 | 184.7 | 185.1714 | 2229697.0 |
| 2024-01-08 15:00:00 | AAPL | Stock | 185.1777 | 185.42 | 184.99 | 185.22 | 2266033.0 |
| 2024-01-08 15:30:00 | AAPL | Stock | 185.215 | 185.6 | 184.91 | 185.55 | 5847054.0 |
| 2024-01-08 16:00:00 | AAPL | Stock | 185.56 | 185.59 | 185.31 | 185.38 | 12176861.0 |
| 2024-01-08 16:30:00 | AAPL | Stock | 185.42 | 185.56 | 185.31 | 185.46 | 226667.0 |
| 2024-01-08 17:00:00 | AAPL | Stock | 185.44 | 185.56 | 185.21 | 185.21 | 38033.0 |
| 2024-01-08 17:30:00 | AAPL | Stock | 185.26 | 185.32 | 185.2 | 185.25 | 22095.0 |
| 2024-01-08 18:00:00 | AAPL | Stock | 185.25 | 185.28 | 185.15 | 185.2798 | 11280.0 |
| 2024-01-08 18:30:00 | AAPL | Stock | 185.33 | 185.35 | 185.24 | 185.34 | 6083.0 |
| 2024-01-08 19:00:00 | AAPL | Stock | 185.31 | 185.39 | 185.2 | 185.22 | 9299.0 |
| 2024-01-08 19:30:00 | AAPL | Stock | 185.22 | 185.22 | 185.08 | 185.22 | 13881.0 |
| 2024-01-08 04:00:00 | MSFT | Stock | 367.99 | 367.99 | 367.55 | 367.85 | 2034.0 |
| 2024-01-08 04:30:00 | MSFT | Stock | 367.4 | 367.5 | 366.75 | 367.5 | 1980.0 |
| 2024-01-08 05:00:00 | MSFT | Stock | 367.74 | 367.74 | 367.74 | 367.74 | 243.0 |
| 2024-01-08 05:30:00 | MSFT | Stock | 368.44 | 368.52 | 368.4 | 368.52 | 650.0 |
| 2024-01-08 06:00:00 | MSFT | Stock | 368.47 | 369.21 | 368.47 | 368.88 | 1079.0 |
| 2024-01-08 06:30:00 | MSFT | Stock | 368.84 | 369.22 | 368.84 | 369.0 | 1292.0 |
| 2024-01-08 07:00:00 | MSFT | Stock | 369.01 | 369.16 | 368.8 | 368.8 | 4329.0 |
| 2024-01-08 07:30:00 | MSFT | Stock | 368.54 | 368.96 | 368.4 | 368.96 | 4805.0 |
| 2024-01-08 08:00:00 | MSFT | Stock | 369.0 | 369.5 | 367.66 | 369.2159 | 32420.0 |
| 2024-01-08 08:30:00 | MSFT | Stock | 369.35 | 369.5 | 367.75 | 368.5315 | 100241.0 |
| 2024-01-08 09:00:00 | MSFT | Stock | 368.75 | 369.88 | 368.73 | 369.54 | 17504.0 |
| 2024-01-08 09:30:00 | MSFT | Stock | 369.3 | 370.96 | 369.01 | 370.56 | 1646579.0 |
| 2024-01-08 10:00:00 | MSFT | Stock | 370.56 | 370.97 | 369.89 | 370.1056 | 924659.0 |
| 2024-01-08 10:30:00 | MSFT | Stock | 370.13 | 370.82 | 369.77 | 370.28 | 639327.0 |
| 2024-01-08 11:00:00 | MSFT | Stock | 370.305 | 370.8242 | 369.95 | 370.14 | 662630.0 |
| 2024-01-08 11:30:00 | MSFT | Stock | 370.17 | 371.3961 | 370.11 | 371.22 | 724933.0 |
| 2024-01-08 12:00:00 | MSFT | Stock | 371.24 | 371.63 | 370.76 | 371.11 | 456568.0 |
| 2024-01-08 12:30:00 | MSFT | Stock | 371.13 | 372.035 | 370.97 | 371.83 | 517118.0 |
> showing 50 of 100,590 rows — these rows as CSV