PREVIEW / stock_30min / 2025-04-08
file: by_date/stock_30min/2025/2025-04-08.parquet size: 2.3 MB rows: 109,018 symbols: 453
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-08 04:00:00 | AAPL | Stock | 183.88 | 184.85 | 182.71 | 183.22 | 47960.0 |
| 2025-04-08 04:30:00 | AAPL | Stock | 183.25 | 184.39 | 183.24 | 184.26 | 29574.0 |
| 2025-04-08 05:00:00 | AAPL | Stock | 184.22 | 184.99 | 184.09 | 184.24 | 43628.0 |
| 2025-04-08 05:30:00 | AAPL | Stock | 184.16 | 184.61 | 183.83 | 183.85 | 45917.0 |
| 2025-04-08 06:00:00 | AAPL | Stock | 183.9 | 184.03 | 183.26 | 183.51 | 25093.0 |
| 2025-04-08 06:30:00 | AAPL | Stock | 183.77 | 184.32 | 183.72 | 183.73 | 17182.0 |
| 2025-04-08 07:00:00 | AAPL | Stock | 183.75 | 184.18 | 182.67 | 183.6 | 84046.0 |
| 2025-04-08 07:30:00 | AAPL | Stock | 183.6 | 185.75 | 183.37 | 185.52 | 118173.0 |
| 2025-04-08 08:00:00 | AAPL | Stock | 183.5 | 186.34 | 181.6 | 185.9 | 384142.0 |
| 2025-04-08 08:30:00 | AAPL | Stock | 185.9 | 186.1 | 184.27 | 185.45 | 189087.0 |
| 2025-04-08 09:00:00 | AAPL | Stock | 185.32 | 187.7 | 185.2 | 186.53 | 485289.0 |
| 2025-04-08 09:30:00 | AAPL | Stock | 186.54 | 188.56 | 185.09 | 188.0 | 11313875.0 |
| 2025-04-08 10:00:00 | AAPL | Stock | 188.0 | 190.335 | 187.78 | 189.33 | 6074488.0 |
| 2025-04-08 10:30:00 | AAPL | Stock | 189.32 | 189.93 | 186.18 | 186.2 | 4263556.0 |
| 2025-04-08 11:00:00 | AAPL | Stock | 186.215 | 186.94 | 184.06 | 184.09 | 4453544.0 |
| 2025-04-08 11:30:00 | AAPL | Stock | 184.07 | 185.54 | 183.03 | 184.47 | 2783031.0 |
| 2025-04-08 12:00:00 | AAPL | Stock | 184.48 | 184.8682 | 182.29 | 183.33 | 2690627.0 |
| 2025-04-08 12:30:00 | AAPL | Stock | 183.32 | 183.52 | 178.9409 | 179.1685 | 5781274.0 |
| 2025-04-08 13:00:00 | AAPL | Stock | 179.15 | 179.6 | 175.0 | 175.03 | 5638305.0 |
| 2025-04-08 13:30:00 | AAPL | Stock | 175.02 | 178.6099 | 174.82 | 178.15 | 5219162.0 |
| 2025-04-08 14:00:00 | AAPL | Stock | 178.16 | 178.21 | 175.2 | 175.32 | 3134766.0 |
| 2025-04-08 14:30:00 | AAPL | Stock | 175.3122 | 177.245 | 174.52 | 174.59 | 4592556.0 |
| 2025-04-08 15:00:00 | AAPL | Stock | 174.58 | 174.888 | 171.63 | 172.89 | 6402317.0 |
| 2025-04-08 15:30:00 | AAPL | Stock | 172.87 | 173.44 | 169.2101 | 172.77 | 12125583.0 |
| 2025-04-08 16:00:00 | AAPL | Stock | 172.868 | 173.5436 | 171.6032 | 172.2 | 11048690.0 |
| 2025-04-08 16:30:00 | AAPL | Stock | 172.14 | 175.0 | 172.0 | 175.0 | 342208.0 |
| 2025-04-08 17:00:00 | AAPL | Stock | 175.0 | 175.49 | 173.0103 | 173.5699 | 135039.0 |
| 2025-04-08 17:30:00 | AAPL | Stock | 173.56 | 173.8 | 172.51 | 172.9 | 70270.0 |
| 2025-04-08 18:00:00 | AAPL | Stock | 172.88 | 172.9 | 170.0 | 170.7 | 153400.0 |
| 2025-04-08 18:30:00 | AAPL | Stock | 170.66 | 170.96 | 170.0 | 170.85 | 79348.0 |
| 2025-04-08 19:00:00 | AAPL | Stock | 170.95 | 171.01 | 169.1216 | 169.2 | 89482.0 |
| 2025-04-08 19:30:00 | AAPL | Stock | 169.2 | 169.96 | 169.1 | 169.45 | 118001.0 |
| 2025-04-08 04:00:00 | MSFT | Stock | 364.37 | 364.88 | 360.91 | 361.09 | 15622.0 |
| 2025-04-08 04:30:00 | MSFT | Stock | 361.29 | 361.5 | 360.67 | 361.24 | 21950.0 |
| 2025-04-08 05:00:00 | MSFT | Stock | 361.29 | 361.3 | 358.68 | 358.71 | 16057.0 |
| 2025-04-08 05:30:00 | MSFT | Stock | 359.0 | 359.97 | 357.73 | 357.73 | 6734.0 |
| 2025-04-08 06:00:00 | MSFT | Stock | 357.5 | 358.43 | 356.6 | 358.0 | 24953.0 |
| 2025-04-08 06:30:00 | MSFT | Stock | 358.0 | 359.48 | 358.0 | 359.1 | 4423.0 |
| 2025-04-08 07:00:00 | MSFT | Stock | 359.35 | 360.73 | 358.76 | 359.72 | 17465.0 |
| 2025-04-08 07:30:00 | MSFT | Stock | 359.73 | 363.01 | 359.7 | 363.0 | 29607.0 |
| 2025-04-08 08:00:00 | MSFT | Stock | 359.0 | 364.72 | 350.88 | 363.5 | 105746.0 |
| 2025-04-08 08:30:00 | MSFT | Stock | 363.8056 | 364.9 | 363.0 | 364.89 | 47213.0 |
| 2025-04-08 09:00:00 | MSFT | Stock | 364.38 | 372.39 | 364.0034 | 368.0 | 228808.0 |
| 2025-04-08 09:30:00 | MSFT | Stock | 368.255 | 371.966 | 366.9 | 371.73 | 3458718.0 |
| 2025-04-08 10:00:00 | MSFT | Stock | 371.76 | 373.65 | 370.9 | 372.12 | 1442381.0 |
| 2025-04-08 10:30:00 | MSFT | Stock | 372.12 | 372.52 | 368.92 | 369.41 | 1442031.0 |
| 2025-04-08 11:00:00 | MSFT | Stock | 369.405 | 370.1319 | 366.87 | 367.03 | 959607.0 |
| 2025-04-08 11:30:00 | MSFT | Stock | 367.08 | 369.24 | 365.71 | 366.96 | 654128.0 |
| 2025-04-08 12:00:00 | MSFT | Stock | 366.87 | 366.87 | 363.0 | 364.75 | 696446.0 |
| 2025-04-08 12:30:00 | MSFT | Stock | 364.69 | 365.0 | 360.115 | 360.82 | 1032357.0 |
> showing 50 of 109,018 rows — these rows as CSV