PREVIEW / stock_30min / 2025-04-04
file: by_date/stock_30min/2025/2025-04-04.parquet size: 2.4 MB rows: 114,393 symbols: 452
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 |
|---|---|---|---|---|---|---|---|
| 2025-04-04 04:00:00 | AAPL | Stock | 203.11 | 203.46 | 201.81 | 202.5 | 31035.0 |
| 2025-04-04 04:30:00 | AAPL | Stock | 202.27 | 202.27 | 201.79 | 201.9 | 28770.0 |
| 2025-04-04 05:00:00 | AAPL | Stock | 201.86 | 201.96 | 200.83 | 200.83 | 53130.0 |
| 2025-04-04 05:30:00 | AAPL | Stock | 200.88 | 201.54 | 200.88 | 201.23 | 28162.0 |
| 2025-04-04 06:00:00 | AAPL | Stock | 201.23 | 201.4 | 193.89 | 193.94 | 307566.0 |
| 2025-04-04 06:30:00 | AAPL | Stock | 194.0 | 196.94 | 192.82 | 192.82 | 393818.0 |
| 2025-04-04 07:00:00 | AAPL | Stock | 192.92 | 195.06 | 190.33 | 191.0 | 501021.0 |
| 2025-04-04 07:30:00 | AAPL | Stock | 191.02 | 194.5 | 190.38 | 194.15 | 306916.0 |
| 2025-04-04 08:00:00 | AAPL | Stock | 193.57 | 203.15 | 190.3502 | 193.6 | 766303.0 |
| 2025-04-04 08:30:00 | AAPL | Stock | 193.8438 | 194.78 | 192.31 | 194.78 | 490625.0 |
| 2025-04-04 09:00:00 | AAPL | Stock | 194.7235 | 195.8 | 193.2 | 193.91 | 474622.0 |
| 2025-04-04 09:30:00 | AAPL | Stock | 193.92 | 199.88 | 192.77 | 199.235 | 14525339.0 |
| 2025-04-04 10:00:00 | AAPL | Stock | 199.27 | 199.31 | 194.82 | 195.295 | 6024482.0 |
| 2025-04-04 10:30:00 | AAPL | Stock | 195.295 | 196.09 | 191.06 | 193.48 | 8435112.0 |
| 2025-04-04 11:00:00 | AAPL | Stock | 193.45 | 197.2117 | 193.35 | 194.48 | 5876848.0 |
| 2025-04-04 11:30:00 | AAPL | Stock | 194.465 | 196.0 | 193.75 | 194.165 | 3502232.0 |
| 2025-04-04 12:00:00 | AAPL | Stock | 194.163 | 195.07 | 192.25 | 192.81 | 3270116.0 |
| 2025-04-04 12:30:00 | AAPL | Stock | 192.78 | 193.9762 | 192.18 | 192.96 | 2590921.0 |
| 2025-04-04 13:00:00 | AAPL | Stock | 192.93 | 193.54 | 190.9 | 190.99 | 3327468.0 |
| 2025-04-04 13:30:00 | AAPL | Stock | 190.98 | 192.57 | 190.66 | 191.68 | 4395535.0 |
| 2025-04-04 14:00:00 | AAPL | Stock | 191.66 | 192.54 | 188.831 | 188.88 | 3858715.0 |
| 2025-04-04 14:30:00 | AAPL | Stock | 188.9 | 189.73 | 187.34 | 188.88 | 4206897.0 |
| 2025-04-04 15:00:00 | AAPL | Stock | 188.87 | 190.8688 | 188.014 | 190.22 | 5485126.0 |
| 2025-04-04 15:30:00 | AAPL | Stock | 190.21 | 191.73 | 188.06 | 188.38 | 10149277.0 |
| 2025-04-04 16:00:00 | AAPL | Stock | 188.38 | 188.639 | 187.2565 | 187.33 | 14258521.0 |
| 2025-04-04 16:30:00 | AAPL | Stock | 187.39 | 188.38 | 187.24 | 187.9 | 315628.0 |
| 2025-04-04 17:00:00 | AAPL | Stock | 187.9 | 188.2 | 187.5 | 187.72 | 51466.0 |
| 2025-04-04 17:30:00 | AAPL | Stock | 187.72 | 188.15 | 187.598 | 187.77 | 22745.0 |
| 2025-04-04 18:00:00 | AAPL | Stock | 187.8 | 187.87 | 187.6 | 187.64 | 38974.0 |
| 2025-04-04 18:30:00 | AAPL | Stock | 187.65 | 187.65 | 187.2501 | 187.2501 | 30415.0 |
| 2025-04-04 19:00:00 | AAPL | Stock | 187.28 | 187.3334 | 187.02 | 187.03 | 49938.0 |
| 2025-04-04 19:30:00 | AAPL | Stock | 187.04 | 187.04 | 186.44 | 186.6 | 82225.0 |
| 2025-04-04 04:00:00 | MSFT | Stock | 370.0 | 370.85 | 369.49 | 370.85 | 4794.0 |
| 2025-04-04 04:30:00 | MSFT | Stock | 370.5 | 370.6 | 369.7 | 369.75 | 3262.0 |
| 2025-04-04 05:00:00 | MSFT | Stock | 369.49 | 370.25 | 369.27 | 369.27 | 3646.0 |
| 2025-04-04 05:30:00 | MSFT | Stock | 369.33 | 369.78 | 369.1 | 369.32 | 2060.0 |
| 2025-04-04 06:00:00 | MSFT | Stock | 369.59 | 369.59 | 361.44 | 361.44 | 20146.0 |
| 2025-04-04 06:30:00 | MSFT | Stock | 361.64 | 362.77 | 355.18 | 355.4 | 56572.0 |
| 2025-04-04 07:00:00 | MSFT | Stock | 356.18 | 358.9 | 355.0 | 355.25 | 60862.0 |
| 2025-04-04 07:30:00 | MSFT | Stock | 355.51 | 359.84 | 355.0 | 359.46 | 61990.0 |
| 2025-04-04 08:00:00 | MSFT | Stock | 357.7 | 371.62 | 355.0 | 362.496 | 150636.0 |
| 2025-04-04 08:30:00 | MSFT | Stock | 362.5 | 367.69 | 362.0 | 365.29 | 117973.0 |
| 2025-04-04 09:00:00 | MSFT | Stock | 366.0 | 373.11 | 362.86 | 364.12 | 68162.0 |
| 2025-04-04 09:30:00 | MSFT | Stock | 364.125 | 372.8 | 363.99 | 372.47 | 4312798.0 |
| 2025-04-04 10:00:00 | MSFT | Stock | 372.52 | 374.59 | 370.37 | 370.5479 | 2757438.0 |
| 2025-04-04 10:30:00 | MSFT | Stock | 370.5075 | 371.0997 | 365.511 | 367.9397 | 2294718.0 |
| 2025-04-04 11:00:00 | MSFT | Stock | 367.92 | 372.85 | 366.29 | 366.775 | 2112665.0 |
| 2025-04-04 11:30:00 | MSFT | Stock | 366.78 | 370.35 | 366.68 | 367.145 | 1125371.0 |
| 2025-04-04 12:00:00 | MSFT | Stock | 367.15 | 369.29 | 364.16 | 364.605 | 910451.0 |
| 2025-04-04 12:30:00 | MSFT | Stock | 364.5 | 366.0 | 363.02 | 364.56 | 1010953.0 |
> showing 50 of 114,393 rows — these rows as CSV