PREVIEW / stock_30min / 2025-04-21
file: by_date/stock_30min/2025/2025-04-21.parquet size: 2.1 MB rows: 102,396 symbols: 429
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-21 04:00:00 | AAPL | Stock | 195.93 | 195.93 | 194.36 | 194.56 | 8781.0 |
| 2025-04-21 04:30:00 | AAPL | Stock | 194.49 | 194.74 | 193.8 | 194.0 | 22384.0 |
| 2025-04-21 05:00:00 | AAPL | Stock | 193.94 | 194.23 | 193.4 | 193.96 | 11782.0 |
| 2025-04-21 05:30:00 | AAPL | Stock | 193.94 | 194.45 | 193.94 | 194.45 | 4904.0 |
| 2025-04-21 06:00:00 | AAPL | Stock | 194.45 | 194.5 | 194.1 | 194.1 | 7130.0 |
| 2025-04-21 06:30:00 | AAPL | Stock | 194.08 | 194.5 | 193.99 | 194.0 | 8311.0 |
| 2025-04-21 07:00:00 | AAPL | Stock | 194.29 | 194.45 | 192.3 | 192.8 | 39057.0 |
| 2025-04-21 07:30:00 | AAPL | Stock | 192.8 | 192.92 | 191.75 | 191.94 | 44464.0 |
| 2025-04-21 08:00:00 | AAPL | Stock | 193.42 | 195.78 | 191.7 | 191.9999 | 89772.0 |
| 2025-04-21 08:30:00 | AAPL | Stock | 191.95 | 192.3453 | 191.7 | 191.96 | 41980.0 |
| 2025-04-21 09:00:00 | AAPL | Stock | 191.9 | 193.3853 | 191.52 | 193.35 | 158685.0 |
| 2025-04-21 09:30:00 | AAPL | Stock | 193.305 | 193.8 | 192.38 | 192.4995 | 3586007.0 |
| 2025-04-21 10:00:00 | AAPL | Stock | 192.45 | 192.65 | 191.36 | 192.12 | 2538116.0 |
| 2025-04-21 10:30:00 | AAPL | Stock | 192.11 | 192.49 | 191.27 | 191.495 | 1709193.0 |
| 2025-04-21 11:00:00 | AAPL | Stock | 191.5 | 191.99 | 190.605 | 190.735 | 1639833.0 |
| 2025-04-21 11:30:00 | AAPL | Stock | 190.72 | 190.83 | 189.8112 | 190.25 | 2152557.0 |
| 2025-04-21 12:00:00 | AAPL | Stock | 190.24 | 191.32 | 190.23 | 191.13 | 1139786.0 |
| 2025-04-21 12:30:00 | AAPL | Stock | 191.12 | 191.75 | 190.68 | 190.765 | 1093258.0 |
| 2025-04-21 13:00:00 | AAPL | Stock | 190.765 | 190.9899 | 190.13 | 190.614 | 1265377.0 |
| 2025-04-21 13:30:00 | AAPL | Stock | 190.59 | 191.02 | 190.28 | 190.51 | 1115455.0 |
| 2025-04-21 14:00:00 | AAPL | Stock | 190.51 | 190.93 | 190.24 | 190.82 | 927181.0 |
| 2025-04-21 14:30:00 | AAPL | Stock | 190.815 | 191.14 | 190.18 | 190.27 | 1132048.0 |
| 2025-04-21 15:00:00 | AAPL | Stock | 190.27 | 191.38 | 190.24 | 191.105 | 1342990.0 |
| 2025-04-21 15:30:00 | AAPL | Stock | 191.09 | 193.43 | 191.05 | 193.09 | 3829626.0 |
| 2025-04-21 16:00:00 | AAPL | Stock | 193.03 | 193.38 | 191.5 | 192.7499 | 8156792.0 |
| 2025-04-21 16:30:00 | AAPL | Stock | 192.75 | 193.16 | 192.6 | 193.1 | 82079.0 |
| 2025-04-21 17:00:00 | AAPL | Stock | 193.09 | 193.16 | 192.61 | 192.7253 | 17781.0 |
| 2025-04-21 17:30:00 | AAPL | Stock | 192.7188 | 192.9886 | 192.7188 | 192.85 | 2945.0 |
| 2025-04-21 18:00:00 | AAPL | Stock | 192.97 | 192.99 | 192.52 | 192.5257 | 9997.0 |
| 2025-04-21 18:30:00 | AAPL | Stock | 192.52 | 192.99 | 192.52 | 192.94 | 6167.0 |
| 2025-04-21 19:00:00 | AAPL | Stock | 192.644 | 192.787 | 192.56 | 192.56 | 5625.0 |
| 2025-04-21 19:30:00 | AAPL | Stock | 192.61 | 194.0 | 192.61 | 194.0 | 37123.0 |
| 2025-04-21 04:00:00 | MSFT | Stock | 363.9 | 365.72 | 363.9 | 364.44 | 670.0 |
| 2025-04-21 04:30:00 | MSFT | Stock | 364.38 | 364.6 | 364.1 | 364.1 | 1328.0 |
| 2025-04-21 06:00:00 | MSFT | Stock | 364.1 | 364.53 | 364.1 | 364.44 | 1685.0 |
| 2025-04-21 06:30:00 | MSFT | Stock | 364.54 | 365.5 | 364.54 | 365.5 | 339.0 |
| 2025-04-21 07:00:00 | MSFT | Stock | 365.73 | 366.5 | 364.0 | 364.58 | 2731.0 |
| 2025-04-21 07:30:00 | MSFT | Stock | 364.75 | 364.75 | 363.4 | 363.94 | 3782.0 |
| 2025-04-21 08:00:00 | MSFT | Stock | 366.0 | 369.067 | 363.5 | 364.49 | 13346.0 |
| 2025-04-21 08:30:00 | MSFT | Stock | 364.0122 | 364.9803 | 364.0087 | 364.13 | 3728.0 |
| 2025-04-21 09:00:00 | MSFT | Stock | 364.49 | 364.49 | 362.7 | 362.7 | 18485.0 |
| 2025-04-21 09:30:00 | MSFT | Stock | 362.93 | 364.48 | 361.02 | 361.03 | 1173894.0 |
| 2025-04-21 10:00:00 | MSFT | Stock | 361.01 | 361.05 | 359.56 | 360.24 | 980129.0 |
| 2025-04-21 10:30:00 | MSFT | Stock | 360.22 | 361.53 | 359.8 | 360.085 | 634822.0 |
| 2025-04-21 11:00:00 | MSFT | Stock | 360.0925 | 361.33 | 359.44 | 359.55 | 684843.0 |
| 2025-04-21 11:30:00 | MSFT | Stock | 359.5 | 359.76 | 357.75 | 358.23 | 1001495.0 |
| 2025-04-21 12:00:00 | MSFT | Stock | 358.235 | 358.62 | 357.9501 | 358.2569 | 437423.0 |
| 2025-04-21 12:30:00 | MSFT | Stock | 358.21 | 359.69 | 358.18 | 358.8 | 453299.0 |
| 2025-04-21 13:00:00 | MSFT | Stock | 358.82 | 359.33 | 358.19 | 358.54 | 537785.0 |
| 2025-04-21 13:30:00 | MSFT | Stock | 358.49 | 358.95 | 357.27 | 357.3872 | 473356.0 |
> showing 50 of 102,396 rows — these rows as CSV