PREVIEW / stock_30min / 2024-01-29
file: by_date/stock_30min/2024/2024-01-29.parquet size: 2.1 MB rows: 99,167 symbols: 1,179
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-29 04:00:00 | AAPL | Stock | 192.2 | 192.99 | 192.13 | 192.28 | 17533.0 |
| 2024-01-29 04:30:00 | AAPL | Stock | 192.28 | 192.28 | 192.02 | 192.02 | 3150.0 |
| 2024-01-29 05:00:00 | AAPL | Stock | 192.02 | 192.19 | 191.98 | 192.19 | 5904.0 |
| 2024-01-29 05:30:00 | AAPL | Stock | 192.2 | 192.28 | 192.2 | 192.2 | 3387.0 |
| 2024-01-29 06:00:00 | AAPL | Stock | 192.2 | 192.28 | 192.05 | 192.28 | 1841.0 |
| 2024-01-29 06:30:00 | AAPL | Stock | 192.2 | 192.2 | 192.17 | 192.19 | 313.0 |
| 2024-01-29 07:00:00 | AAPL | Stock | 192.3 | 192.6 | 192.21 | 192.45 | 25056.0 |
| 2024-01-29 07:30:00 | AAPL | Stock | 192.45 | 192.45 | 192.3 | 192.35 | 6842.0 |
| 2024-01-29 08:00:00 | AAPL | Stock | 192.3 | 192.66 | 192.16 | 192.21 | 60521.0 |
| 2024-01-29 08:30:00 | AAPL | Stock | 192.2 | 192.21 | 191.95 | 191.95 | 31846.0 |
| 2024-01-29 09:00:00 | AAPL | Stock | 191.9467 | 192.2 | 191.85 | 191.99 | 89794.0 |
| 2024-01-29 09:30:00 | AAPL | Stock | 192.01 | 192.178 | 189.58 | 190.7744 | 6416451.0 |
| 2024-01-29 10:00:00 | AAPL | Stock | 190.78 | 191.255 | 190.49 | 190.87 | 2917869.0 |
| 2024-01-29 10:30:00 | AAPL | Stock | 190.87 | 191.15 | 190.5811 | 190.5901 | 1936793.0 |
| 2024-01-29 11:00:00 | AAPL | Stock | 190.59 | 191.0284 | 190.405 | 190.69 | 1768404.0 |
| 2024-01-29 11:30:00 | AAPL | Stock | 190.685 | 190.825 | 190.4 | 190.775 | 1323892.0 |
| 2024-01-29 12:00:00 | AAPL | Stock | 190.78 | 191.1389 | 190.72 | 191.03 | 1201988.0 |
| 2024-01-29 12:30:00 | AAPL | Stock | 191.035 | 191.16 | 190.78 | 191.05 | 1194838.0 |
| 2024-01-29 13:00:00 | AAPL | Stock | 191.07 | 191.29 | 190.9333 | 191.25 | 1054179.0 |
| 2024-01-29 13:30:00 | AAPL | Stock | 191.26 | 191.39 | 191.21 | 191.27 | 1155775.0 |
| 2024-01-29 14:00:00 | AAPL | Stock | 191.27 | 191.62 | 191.24 | 191.535 | 1183290.0 |
| 2024-01-29 14:30:00 | AAPL | Stock | 191.5356 | 191.67 | 191.28 | 191.375 | 1652153.0 |
| 2024-01-29 15:00:00 | AAPL | Stock | 191.38 | 192.2 | 191.37 | 191.935 | 2796963.0 |
| 2024-01-29 15:30:00 | AAPL | Stock | 191.935 | 192.105 | 191.39 | 191.78 | 3785814.0 |
| 2024-01-29 16:00:00 | AAPL | Stock | 191.6 | 191.74 | 191.52 | 191.58 | 7084614.0 |
| 2024-01-29 16:30:00 | AAPL | Stock | 191.58 | 191.61 | 191.3 | 191.39 | 37697.0 |
| 2024-01-29 17:00:00 | AAPL | Stock | 191.39 | 191.73 | 191.37 | 191.48 | 38973.0 |
| 2024-01-29 17:30:00 | AAPL | Stock | 191.49 | 191.73 | 191.41 | 191.54 | 36914.0 |
| 2024-01-29 18:00:00 | AAPL | Stock | 191.51 | 191.51 | 191.24 | 191.27 | 40738.0 |
| 2024-01-29 18:30:00 | AAPL | Stock | 191.27 | 191.31 | 191.04 | 191.11 | 14950.0 |
| 2024-01-29 19:00:00 | AAPL | Stock | 191.15 | 191.15 | 190.88 | 191.08 | 13602.0 |
| 2024-01-29 19:30:00 | AAPL | Stock | 191.02 | 191.1094 | 190.88 | 190.88 | 17819.0 |
| 2024-01-29 04:00:00 | MSFT | Stock | 403.0 | 406.76 | 403.0 | 405.5 | 6694.0 |
| 2024-01-29 04:30:00 | MSFT | Stock | 406.19 | 406.3 | 406.0 | 406.0 | 1989.0 |
| 2024-01-29 05:00:00 | MSFT | Stock | 406.24 | 406.55 | 406.24 | 406.36 | 3476.0 |
| 2024-01-29 05:30:00 | MSFT | Stock | 406.2 | 406.3 | 406.2 | 406.3 | 346.0 |
| 2024-01-29 06:00:00 | MSFT | Stock | 406.29 | 407.27 | 406.29 | 407.27 | 7331.0 |
| 2024-01-29 06:30:00 | MSFT | Stock | 407.49 | 407.49 | 406.93 | 406.93 | 3098.0 |
| 2024-01-29 07:00:00 | MSFT | Stock | 406.85 | 407.1 | 406.54 | 407.03 | 20870.0 |
| 2024-01-29 07:30:00 | MSFT | Stock | 407.02 | 407.03 | 406.3 | 406.45 | 6867.0 |
| 2024-01-29 08:00:00 | MSFT | Stock | 406.95 | 407.15 | 405.4 | 406.3 | 56210.0 |
| 2024-01-29 08:30:00 | MSFT | Stock | 406.3 | 406.9 | 406.2201 | 406.6 | 23414.0 |
| 2024-01-29 09:00:00 | MSFT | Stock | 406.6 | 407.05 | 405.81 | 405.84 | 31374.0 |
| 2024-01-29 09:30:00 | MSFT | Stock | 406.02 | 409.12 | 404.33 | 407.63 | 2731313.0 |
| 2024-01-29 10:00:00 | MSFT | Stock | 407.605 | 407.732 | 405.8278 | 406.02 | 1368253.0 |
| 2024-01-29 10:30:00 | MSFT | Stock | 406.04 | 406.59 | 405.55 | 406.0391 | 737396.0 |
| 2024-01-29 11:00:00 | MSFT | Stock | 406.0551 | 406.93 | 405.81 | 406.93 | 648962.0 |
| 2024-01-29 11:30:00 | MSFT | Stock | 406.95 | 407.49 | 406.81 | 407.06 | 669540.0 |
| 2024-01-29 12:00:00 | MSFT | Stock | 407.09 | 407.45 | 406.76 | 407.1 | 491114.0 |
| 2024-01-29 12:30:00 | MSFT | Stock | 407.11 | 407.34 | 406.71 | 407.05 | 561729.0 |
> showing 50 of 99,167 rows — these rows as CSV