PREVIEW / stock_30min / 2025-08-21
file: by_date/stock_30min/2025/2025-08-21.parquet size: 2.1 MB rows: 102,048 symbols: 333
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-08-21 04:00:00 | AAPL | Stock | 225.99 | 226.11 | 225.55 | 225.67 | 3050.0 |
| 2025-08-21 04:30:00 | AAPL | Stock | 225.72 | 225.72 | 225.4 | 225.44 | 3098.0 |
| 2025-08-21 05:00:00 | AAPL | Stock | 225.23 | 225.3 | 225.06 | 225.27 | 7058.0 |
| 2025-08-21 05:30:00 | AAPL | Stock | 225.2 | 225.2 | 224.9 | 224.9 | 3764.0 |
| 2025-08-21 06:00:00 | AAPL | Stock | 224.82 | 224.98 | 224.62 | 224.76 | 5333.0 |
| 2025-08-21 06:30:00 | AAPL | Stock | 224.93 | 225.0 | 224.8 | 225.0 | 5741.0 |
| 2025-08-21 07:00:00 | AAPL | Stock | 225.13 | 225.4 | 225.13 | 225.13 | 8156.0 |
| 2025-08-21 07:30:00 | AAPL | Stock | 225.1 | 225.4 | 225.0 | 225.34 | 10056.0 |
| 2025-08-21 08:00:00 | AAPL | Stock | 225.2 | 226.2 | 224.8504 | 225.4 | 56498.0 |
| 2025-08-21 08:30:00 | AAPL | Stock | 225.32 | 225.84 | 225.32 | 225.56 | 25606.0 |
| 2025-08-21 09:00:00 | AAPL | Stock | 225.38 | 226.41 | 225.33 | 226.38 | 79743.0 |
| 2025-08-21 09:30:00 | AAPL | Stock | 226.27 | 226.52 | 224.68 | 225.2 | 2921146.0 |
| 2025-08-21 10:00:00 | AAPL | Stock | 225.2 | 226.02 | 225.01 | 225.5799 | 1685099.0 |
| 2025-08-21 10:30:00 | AAPL | Stock | 225.56 | 225.585 | 225.1 | 225.29 | 1130697.0 |
| 2025-08-21 11:00:00 | AAPL | Stock | 225.29 | 225.4801 | 224.51 | 225.13 | 1640065.0 |
| 2025-08-21 11:30:00 | AAPL | Stock | 225.135 | 225.8499 | 225.11 | 225.26 | 1219633.0 |
| 2025-08-21 12:00:00 | AAPL | Stock | 225.26 | 225.275 | 224.8 | 224.83 | 933772.0 |
| 2025-08-21 12:30:00 | AAPL | Stock | 224.83 | 225.01 | 224.54 | 224.61 | 910594.0 |
| 2025-08-21 13:00:00 | AAPL | Stock | 224.62 | 224.82 | 223.7804 | 224.175 | 1654704.0 |
| 2025-08-21 13:30:00 | AAPL | Stock | 224.1708 | 224.78 | 224.15 | 224.56 | 997293.0 |
| 2025-08-21 14:00:00 | AAPL | Stock | 224.55 | 224.59 | 224.19 | 224.24 | 854746.0 |
| 2025-08-21 14:30:00 | AAPL | Stock | 224.23 | 224.5899 | 224.0942 | 224.51 | 886638.0 |
| 2025-08-21 15:00:00 | AAPL | Stock | 224.5 | 225.06 | 224.48 | 224.88 | 1073404.0 |
| 2025-08-21 15:30:00 | AAPL | Stock | 224.89 | 225.25 | 224.3884 | 224.91 | 3142659.0 |
| 2025-08-21 16:00:00 | AAPL | Stock | 224.9 | 225.2 | 224.68 | 224.75 | 3300782.0 |
| 2025-08-21 16:30:00 | AAPL | Stock | 224.6741 | 225.15 | 224.6741 | 225.09 | 20196.0 |
| 2025-08-21 17:00:00 | AAPL | Stock | 225.01 | 225.01 | 224.84 | 224.9 | 9946.0 |
| 2025-08-21 17:30:00 | AAPL | Stock | 224.87 | 224.95 | 224.86 | 224.9208 | 3239.0 |
| 2025-08-21 18:00:00 | AAPL | Stock | 224.93 | 225.48 | 224.93 | 225.25 | 7796.0 |
| 2025-08-21 18:30:00 | AAPL | Stock | 225.25 | 225.41 | 225.0255 | 225.3 | 4762.0 |
| 2025-08-21 19:00:00 | AAPL | Stock | 225.2117 | 225.3 | 225.05 | 225.2801 | 3268.0 |
| 2025-08-21 19:30:00 | AAPL | Stock | 225.3 | 225.39 | 225.0608 | 225.38 | 6343.0 |
| 2025-08-21 04:00:00 | MSFT | Stock | 505.88 | 506.21 | 505.88 | 506.2 | 1639.0 |
| 2025-08-21 04:30:00 | MSFT | Stock | 505.8 | 506.03 | 505.6 | 505.6 | 1647.0 |
| 2025-08-21 05:00:00 | MSFT | Stock | 505.13 | 505.44 | 505.01 | 505.44 | 806.0 |
| 2025-08-21 05:30:00 | MSFT | Stock | 505.44 | 505.86 | 505.44 | 505.86 | 2454.0 |
| 2025-08-21 06:00:00 | MSFT | Stock | 505.25 | 505.59 | 504.8 | 504.8 | 1671.0 |
| 2025-08-21 06:30:00 | MSFT | Stock | 505.15 | 505.3 | 505.15 | 505.27 | 403.0 |
| 2025-08-21 07:00:00 | MSFT | Stock | 505.2 | 505.41 | 504.5 | 504.75 | 6566.0 |
| 2025-08-21 07:30:00 | MSFT | Stock | 504.99 | 504.99 | 504.25 | 504.4 | 3647.0 |
| 2025-08-21 08:00:00 | MSFT | Stock | 504.75 | 506.2 | 503.45 | 503.9869 | 15918.0 |
| 2025-08-21 08:30:00 | MSFT | Stock | 503.33 | 504.89 | 503.33 | 504.25 | 8637.0 |
| 2025-08-21 09:00:00 | MSFT | Stock | 503.82 | 504.0 | 502.57 | 503.2 | 12409.0 |
| 2025-08-21 09:30:00 | MSFT | Stock | 503.69 | 505.43 | 502.7201 | 503.2 | 953605.0 |
| 2025-08-21 10:00:00 | MSFT | Stock | 503.175 | 507.63 | 502.9197 | 507.5186 | 716073.0 |
| 2025-08-21 10:30:00 | MSFT | Stock | 507.52 | 507.52 | 506.08 | 506.8288 | 356996.0 |
| 2025-08-21 11:00:00 | MSFT | Stock | 506.755 | 507.41 | 505.45 | 506.78 | 328444.0 |
| 2025-08-21 11:30:00 | MSFT | Stock | 506.65 | 507.1399 | 505.9 | 506.525 | 256787.0 |
| 2025-08-21 12:00:00 | MSFT | Stock | 506.55 | 506.95 | 505.11 | 505.41 | 376613.0 |
| 2025-08-21 12:30:00 | MSFT | Stock | 505.43 | 505.75 | 504.43 | 504.635 | 824727.0 |
> showing 50 of 102,048 rows — these rows as CSV