PREVIEW / stock_30min / 2024-12-26
file: by_date/stock_30min/2024/2024-12-26.parquet size: 2.2 MB rows: 106,879 symbols: 613
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-12-26 04:00:00 | AAPL | Stock | 258.06 | 258.38 | 257.75 | 258.05 | 4699.0 |
| 2024-12-26 04:30:00 | AAPL | Stock | 258.09 | 258.09 | 257.85 | 257.85 | 749.0 |
| 2024-12-26 05:00:00 | AAPL | Stock | 257.75 | 257.75 | 257.13 | 257.37 | 2731.0 |
| 2024-12-26 05:30:00 | AAPL | Stock | 257.46 | 257.71 | 257.46 | 257.7 | 3314.0 |
| 2024-12-26 06:00:00 | AAPL | Stock | 257.61 | 257.73 | 257.6 | 257.73 | 2215.0 |
| 2024-12-26 06:30:00 | AAPL | Stock | 257.64 | 257.73 | 257.64 | 257.73 | 915.0 |
| 2024-12-26 07:00:00 | AAPL | Stock | 257.8 | 257.96 | 257.7 | 257.7 | 5658.0 |
| 2024-12-26 07:30:00 | AAPL | Stock | 257.79 | 257.85 | 257.6 | 257.63 | 3992.0 |
| 2024-12-26 08:00:00 | AAPL | Stock | 257.95 | 259.19 | 257.5534 | 258.19 | 45161.0 |
| 2024-12-26 08:30:00 | AAPL | Stock | 258.2 | 258.2 | 257.59 | 257.93 | 25827.0 |
| 2024-12-26 09:00:00 | AAPL | Stock | 257.88 | 258.22 | 257.71 | 258.2 | 44524.0 |
| 2024-12-26 09:30:00 | AAPL | Stock | 258.19 | 260.1 | 258.02 | 258.7899 | 4584254.0 |
| 2024-12-26 10:00:00 | AAPL | Stock | 258.76 | 258.84 | 257.63 | 258.3612 | 1900130.0 |
| 2024-12-26 10:30:00 | AAPL | Stock | 258.365 | 258.7852 | 258.12 | 258.355 | 1069646.0 |
| 2024-12-26 11:00:00 | AAPL | Stock | 258.37 | 259.19 | 258.31 | 258.88 | 1134930.0 |
| 2024-12-26 11:30:00 | AAPL | Stock | 258.89 | 259.23 | 258.82 | 258.89 | 808464.0 |
| 2024-12-26 12:00:00 | AAPL | Stock | 258.8904 | 259.34 | 258.875 | 258.985 | 720844.0 |
| 2024-12-26 12:30:00 | AAPL | Stock | 258.98 | 259.325 | 258.57 | 258.85 | 739460.0 |
| 2024-12-26 13:00:00 | AAPL | Stock | 258.844 | 259.06 | 258.65 | 258.8189 | 610962.0 |
| 2024-12-26 13:30:00 | AAPL | Stock | 258.81 | 258.95 | 258.46 | 258.65 | 578276.0 |
| 2024-12-26 14:00:00 | AAPL | Stock | 258.62 | 258.7 | 258.41 | 258.6 | 577989.0 |
| 2024-12-26 14:30:00 | AAPL | Stock | 258.61 | 259.1 | 258.59 | 259.09 | 717570.0 |
| 2024-12-26 15:00:00 | AAPL | Stock | 259.1 | 259.47 | 259.07 | 259.11 | 1043118.0 |
| 2024-12-26 15:30:00 | AAPL | Stock | 259.11 | 259.51 | 259.01 | 259.1 | 2056333.0 |
| 2024-12-26 16:00:00 | AAPL | Stock | 259.08 | 259.36 | 258.9 | 259.14 | 4192030.0 |
| 2024-12-26 16:30:00 | AAPL | Stock | 259.14 | 259.16 | 258.94 | 258.97 | 26580.0 |
| 2024-12-26 17:00:00 | AAPL | Stock | 259.01 | 259.02 | 258.9 | 259.02 | 11339.0 |
| 2024-12-26 17:30:00 | AAPL | Stock | 259.02 | 259.04 | 259.0 | 259.02 | 2968.0 |
| 2024-12-26 18:00:00 | AAPL | Stock | 259.02 | 259.12 | 258.9 | 259.1177 | 4361.0 |
| 2024-12-26 18:30:00 | AAPL | Stock | 259.05 | 259.12 | 259.05 | 259.12 | 3177.0 |
| 2024-12-26 19:00:00 | AAPL | Stock | 259.12 | 259.12 | 258.81 | 258.9489 | 5223.0 |
| 2024-12-26 19:30:00 | AAPL | Stock | 259.06 | 259.06 | 258.9116 | 259.06 | 4895.0 |
| 2024-12-26 04:00:00 | MSFT | Stock | 439.91 | 439.95 | 439.32 | 439.32 | 368.0 |
| 2024-12-26 04:30:00 | MSFT | Stock | 438.44 | 438.44 | 438.24 | 438.24 | 300.0 |
| 2024-12-26 05:00:00 | MSFT | Stock | 437.9 | 437.9 | 437.15 | 437.44 | 944.0 |
| 2024-12-26 05:30:00 | MSFT | Stock | 437.9 | 437.9 | 437.9 | 437.9 | 300.0 |
| 2024-12-26 06:00:00 | MSFT | Stock | 437.51 | 437.51 | 437.51 | 437.51 | 173.0 |
| 2024-12-26 06:30:00 | MSFT | Stock | 437.92 | 438.19 | 437.92 | 438.19 | 2957.0 |
| 2024-12-26 07:00:00 | MSFT | Stock | 438.42 | 438.5 | 438.0 | 438.25 | 2932.0 |
| 2024-12-26 07:30:00 | MSFT | Stock | 438.05 | 438.1 | 438.0 | 438.0 | 370.0 |
| 2024-12-26 08:00:00 | MSFT | Stock | 438.4985 | 440.9 | 437.8702 | 438.15 | 9327.0 |
| 2024-12-26 08:30:00 | MSFT | Stock | 438.0 | 438.25 | 437.25 | 438.25 | 9170.0 |
| 2024-12-26 09:00:00 | MSFT | Stock | 438.163 | 439.29 | 438.163 | 438.6 | 7653.0 |
| 2024-12-26 09:30:00 | MSFT | Stock | 439.08 | 440.94 | 436.63 | 438.2487 | 722245.0 |
| 2024-12-26 10:00:00 | MSFT | Stock | 438.38 | 438.65 | 437.14 | 438.235 | 383129.0 |
| 2024-12-26 10:30:00 | MSFT | Stock | 438.24 | 438.43 | 437.3401 | 438.03 | 273926.0 |
| 2024-12-26 11:00:00 | MSFT | Stock | 438.09 | 439.14 | 437.79 | 438.79 | 235530.0 |
| 2024-12-26 11:30:00 | MSFT | Stock | 438.68 | 439.56 | 438.68 | 439.31 | 232837.0 |
| 2024-12-26 12:00:00 | MSFT | Stock | 439.29 | 439.9094 | 438.94 | 438.9938 | 231791.0 |
| 2024-12-26 12:30:00 | MSFT | Stock | 439.02 | 439.57 | 438.03 | 438.53 | 235206.0 |
> showing 50 of 106,879 rows — these rows as CSV