PREVIEW / stock_30min / 2024-01-22
file: by_date/stock_30min/2024/2024-01-22.parquet size: 2.1 MB rows: 100,053 symbols: 1,196
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-22 04:00:00 | AAPL | Stock | 192.18 | 192.18 | 191.56 | 191.89 | 7517.0 |
| 2024-01-22 04:30:00 | AAPL | Stock | 191.85 | 191.92 | 191.81 | 191.92 | 9481.0 |
| 2024-01-22 05:00:00 | AAPL | Stock | 191.92 | 192.13 | 191.9 | 192.13 | 13380.0 |
| 2024-01-22 05:30:00 | AAPL | Stock | 192.13 | 192.13 | 191.95 | 191.97 | 7637.0 |
| 2024-01-22 06:00:00 | AAPL | Stock | 192.03 | 192.05 | 192.0 | 192.0 | 1607.0 |
| 2024-01-22 06:30:00 | AAPL | Stock | 192.03 | 192.18 | 192.02 | 192.02 | 7001.0 |
| 2024-01-22 07:00:00 | AAPL | Stock | 192.0 | 192.61 | 191.95 | 192.61 | 39165.0 |
| 2024-01-22 07:30:00 | AAPL | Stock | 192.7 | 192.72 | 192.4 | 192.54 | 17601.0 |
| 2024-01-22 08:00:00 | AAPL | Stock | 191.9749 | 192.776 | 191.86 | 192.4 | 123564.0 |
| 2024-01-22 08:30:00 | AAPL | Stock | 192.43 | 192.45 | 192.02 | 192.18 | 49082.0 |
| 2024-01-22 09:00:00 | AAPL | Stock | 192.15 | 192.36 | 191.92 | 192.3 | 99632.0 |
| 2024-01-22 09:30:00 | AAPL | Stock | 192.29 | 194.72 | 192.26 | 194.46 | 7673532.0 |
| 2024-01-22 10:00:00 | AAPL | Stock | 194.46 | 194.95 | 194.3 | 194.75 | 4119847.0 |
| 2024-01-22 10:30:00 | AAPL | Stock | 194.77 | 195.33 | 193.3101 | 193.425 | 6238408.0 |
| 2024-01-22 11:00:00 | AAPL | Stock | 193.4482 | 193.99 | 193.15 | 193.78 | 2542240.0 |
| 2024-01-22 11:30:00 | AAPL | Stock | 193.79 | 193.855 | 193.1742 | 193.69 | 2011063.0 |
| 2024-01-22 12:00:00 | AAPL | Stock | 193.72 | 193.82 | 193.03 | 193.6675 | 1918093.0 |
| 2024-01-22 12:30:00 | AAPL | Stock | 193.6632 | 194.066 | 193.51 | 193.925 | 1693705.0 |
| 2024-01-22 13:00:00 | AAPL | Stock | 193.93 | 194.14 | 193.66 | 193.7573 | 2023585.0 |
| 2024-01-22 13:30:00 | AAPL | Stock | 193.76 | 194.5 | 193.745 | 194.49 | 1969686.0 |
| 2024-01-22 14:00:00 | AAPL | Stock | 194.49 | 194.49 | 193.97 | 194.38 | 1896801.0 |
| 2024-01-22 14:30:00 | AAPL | Stock | 194.39 | 194.57 | 193.9401 | 194.08 | 1858632.0 |
| 2024-01-22 15:00:00 | AAPL | Stock | 194.08 | 194.1081 | 193.705 | 193.9001 | 1824432.0 |
| 2024-01-22 15:30:00 | AAPL | Stock | 193.9 | 193.92 | 193.46 | 193.87 | 3996512.0 |
| 2024-01-22 16:00:00 | AAPL | Stock | 193.89 | 193.89 | 193.64 | 193.7 | 7534308.0 |
| 2024-01-22 16:30:00 | AAPL | Stock | 193.73 | 193.89 | 193.67 | 193.76 | 66169.0 |
| 2024-01-22 17:00:00 | AAPL | Stock | 193.79 | 193.8 | 193.75 | 193.775 | 4032.0 |
| 2024-01-22 17:30:00 | AAPL | Stock | 193.75 | 193.75 | 193.72 | 193.72 | 5810.0 |
| 2024-01-22 18:00:00 | AAPL | Stock | 193.75 | 193.86 | 193.7005 | 193.85 | 4238.0 |
| 2024-01-22 18:30:00 | AAPL | Stock | 193.85 | 193.97 | 193.85 | 193.89 | 9285.0 |
| 2024-01-22 19:00:00 | AAPL | Stock | 193.88 | 193.91 | 193.86 | 193.87 | 3255.0 |
| 2024-01-22 19:30:00 | AAPL | Stock | 193.87 | 193.91 | 193.71 | 193.91 | 6044.0 |
| 2024-01-22 04:00:00 | MSFT | Stock | 400.1 | 400.4 | 399.76 | 400.02 | 7145.0 |
| 2024-01-22 04:30:00 | MSFT | Stock | 400.11 | 400.44 | 400.0 | 400.43 | 5344.0 |
| 2024-01-22 05:00:00 | MSFT | Stock | 400.36 | 400.52 | 400.23 | 400.41 | 1195.0 |
| 2024-01-22 05:30:00 | MSFT | Stock | 400.35 | 400.65 | 400.04 | 400.5 | 3248.0 |
| 2024-01-22 06:00:00 | MSFT | Stock | 400.47 | 400.59 | 400.38 | 400.39 | 2282.0 |
| 2024-01-22 06:30:00 | MSFT | Stock | 400.5 | 400.66 | 400.3 | 400.31 | 6087.0 |
| 2024-01-22 07:00:00 | MSFT | Stock | 400.2 | 400.87 | 399.9 | 400.75 | 33343.0 |
| 2024-01-22 07:30:00 | MSFT | Stock | 400.85 | 400.85 | 399.9 | 400.25 | 29554.0 |
| 2024-01-22 08:00:00 | MSFT | Stock | 400.0 | 401.79 | 399.86 | 399.95 | 100053.0 |
| 2024-01-22 08:30:00 | MSFT | Stock | 400.0 | 400.0 | 398.78 | 399.33 | 33162.0 |
| 2024-01-22 09:00:00 | MSFT | Stock | 399.39 | 400.95 | 399.2228 | 399.91 | 82896.0 |
| 2024-01-22 09:30:00 | MSFT | Stock | 399.91 | 400.62 | 395.47 | 398.005 | 3519923.0 |
| 2024-01-22 10:00:00 | MSFT | Stock | 398.02 | 398.29 | 393.89 | 393.96 | 1895133.0 |
| 2024-01-22 10:30:00 | MSFT | Stock | 393.98 | 395.88 | 393.59 | 395.205 | 1297809.0 |
| 2024-01-22 11:00:00 | MSFT | Stock | 395.195 | 397.925 | 394.86 | 397.05 | 969197.0 |
| 2024-01-22 11:30:00 | MSFT | Stock | 397.02 | 398.09 | 397.02 | 397.61 | 549965.0 |
| 2024-01-22 12:00:00 | MSFT | Stock | 397.595 | 397.595 | 396.4 | 396.74 | 558850.0 |
| 2024-01-22 12:30:00 | MSFT | Stock | 396.77 | 397.0 | 396.0806 | 396.6973 | 317291.0 |
> showing 50 of 100,053 rows — these rows as CSV