PREVIEW / stock_30min / 2024-01-10
file: by_date/stock_30min/2024/2024-01-10.parquet size: 2.0 MB rows: 98,688 symbols: 1,173
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-10 04:00:00 | AAPL | Stock | 184.88 | 185.27 | 184.8 | 185.27 | 15969.0 |
| 2024-01-10 04:30:00 | AAPL | Stock | 185.32 | 185.35 | 185.24 | 185.3 | 5320.0 |
| 2024-01-10 05:00:00 | AAPL | Stock | 185.28 | 185.33 | 185.2 | 185.33 | 9791.0 |
| 2024-01-10 05:30:00 | AAPL | Stock | 185.32 | 185.35 | 185.29 | 185.35 | 4335.0 |
| 2024-01-10 06:00:00 | AAPL | Stock | 185.41 | 185.41 | 185.1 | 185.16 | 8521.0 |
| 2024-01-10 06:30:00 | AAPL | Stock | 185.16 | 185.21 | 184.71 | 184.88 | 11297.0 |
| 2024-01-10 07:00:00 | AAPL | Stock | 184.88 | 185.14 | 184.88 | 185.0 | 16610.0 |
| 2024-01-10 07:30:00 | AAPL | Stock | 185.0 | 185.0 | 184.69 | 184.7 | 29003.0 |
| 2024-01-10 08:00:00 | AAPL | Stock | 184.949 | 185.55 | 184.5409 | 184.5465 | 111250.0 |
| 2024-01-10 08:30:00 | AAPL | Stock | 184.54 | 184.54 | 184.26 | 184.37 | 52092.0 |
| 2024-01-10 09:00:00 | AAPL | Stock | 184.4 | 184.6 | 184.0 | 184.31 | 127562.0 |
| 2024-01-10 09:30:00 | AAPL | Stock | 184.31 | 184.96 | 183.97 | 184.265 | 4256957.0 |
| 2024-01-10 10:00:00 | AAPL | Stock | 184.26 | 184.64 | 183.92 | 184.55 | 2317792.0 |
| 2024-01-10 10:30:00 | AAPL | Stock | 184.545 | 184.8 | 184.2225 | 184.773 | 2008058.0 |
| 2024-01-10 11:00:00 | AAPL | Stock | 184.7784 | 185.01 | 184.48 | 184.51 | 2189278.0 |
| 2024-01-10 11:30:00 | AAPL | Stock | 184.515 | 184.55 | 184.05 | 184.27 | 1861292.0 |
| 2024-01-10 12:00:00 | AAPL | Stock | 184.2913 | 184.395 | 184.13 | 184.27 | 1006684.0 |
| 2024-01-10 12:30:00 | AAPL | Stock | 184.27 | 184.39 | 184.08 | 184.32 | 1197954.0 |
| 2024-01-10 13:00:00 | AAPL | Stock | 184.325 | 184.575 | 184.13 | 184.375 | 1456489.0 |
| 2024-01-10 13:30:00 | AAPL | Stock | 184.38 | 184.85 | 184.355 | 184.78 | 1167016.0 |
| 2024-01-10 14:00:00 | AAPL | Stock | 184.7894 | 185.68 | 184.77 | 185.625 | 2213485.0 |
| 2024-01-10 14:30:00 | AAPL | Stock | 185.63 | 186.13 | 185.62 | 186.1176 | 2284376.0 |
| 2024-01-10 15:00:00 | AAPL | Stock | 186.12 | 186.4 | 185.645 | 185.825 | 2806774.0 |
| 2024-01-10 15:30:00 | AAPL | Stock | 185.83 | 186.27 | 185.27 | 186.15 | 5028745.0 |
| 2024-01-10 16:00:00 | AAPL | Stock | 186.14 | 186.73 | 186.13 | 186.62 | 7044840.0 |
| 2024-01-10 16:30:00 | AAPL | Stock | 186.64 | 186.68 | 186.19 | 186.68 | 66622.0 |
| 2024-01-10 17:00:00 | AAPL | Stock | 186.68 | 186.77 | 186.19 | 186.76 | 42672.0 |
| 2024-01-10 17:30:00 | AAPL | Stock | 186.76 | 186.78 | 186.19 | 186.61 | 50161.0 |
| 2024-01-10 18:00:00 | AAPL | Stock | 186.6 | 186.6299 | 186.5 | 186.59 | 19598.0 |
| 2024-01-10 18:30:00 | AAPL | Stock | 186.59 | 186.65 | 186.55 | 186.6 | 7735.0 |
| 2024-01-10 19:00:00 | AAPL | Stock | 186.59 | 186.59 | 186.4 | 186.4 | 7464.0 |
| 2024-01-10 19:30:00 | AAPL | Stock | 186.43 | 186.7 | 186.4 | 186.7 | 18963.0 |
| 2024-01-10 04:00:00 | MSFT | Stock | 376.5 | 377.2 | 376.5 | 377.2 | 3105.0 |
| 2024-01-10 04:30:00 | MSFT | Stock | 377.27 | 377.5 | 377.05 | 377.25 | 1390.0 |
| 2024-01-10 05:00:00 | MSFT | Stock | 377.2 | 377.51 | 377.13 | 377.37 | 2326.0 |
| 2024-01-10 05:30:00 | MSFT | Stock | 377.4 | 377.8 | 377.32 | 377.69 | 4264.0 |
| 2024-01-10 06:00:00 | MSFT | Stock | 377.85 | 378.2 | 377.71 | 377.85 | 3905.0 |
| 2024-01-10 06:30:00 | MSFT | Stock | 377.75 | 377.83 | 377.2 | 377.22 | 2569.0 |
| 2024-01-10 07:00:00 | MSFT | Stock | 377.37 | 377.49 | 377.1 | 377.35 | 11517.0 |
| 2024-01-10 07:30:00 | MSFT | Stock | 377.21 | 377.45 | 377.0 | 377.0 | 14749.0 |
| 2024-01-10 08:00:00 | MSFT | Stock | 377.4 | 377.5 | 376.05 | 377.0 | 41330.0 |
| 2024-01-10 08:30:00 | MSFT | Stock | 376.8 | 376.8 | 376.213 | 376.54 | 12016.0 |
| 2024-01-10 09:00:00 | MSFT | Stock | 376.39 | 376.7097 | 376.08 | 376.35 | 12302.0 |
| 2024-01-10 09:30:00 | MSFT | Stock | 376.49 | 380.45 | 376.32 | 379.92 | 2918338.0 |
| 2024-01-10 10:00:00 | MSFT | Stock | 379.92 | 381.06 | 379.13 | 380.96 | 1390284.0 |
| 2024-01-10 10:30:00 | MSFT | Stock | 380.93 | 382.29 | 380.85 | 381.4699 | 1471945.0 |
| 2024-01-10 11:00:00 | MSFT | Stock | 381.47 | 381.88 | 380.8 | 381.5 | 782770.0 |
| 2024-01-10 11:30:00 | MSFT | Stock | 381.4898 | 381.53 | 380.47 | 381.09 | 698096.0 |
| 2024-01-10 12:00:00 | MSFT | Stock | 381.08 | 381.95 | 380.7969 | 381.934 | 765439.0 |
| 2024-01-10 12:30:00 | MSFT | Stock | 381.94 | 382.45 | 381.79 | 382.38 | 567737.0 |
> showing 50 of 98,688 rows — these rows as CSV