PREVIEW / stock_30min / 2025-03-07
file: by_date/stock_30min/2025/2025-03-07.parquet size: 2.1 MB rows: 102,944 symbols: 507
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-03-07 04:00:00 | AAPL | Stock | 234.37 | 234.61 | 234.19 | 234.5 | 8498.0 |
| 2025-03-07 04:30:00 | AAPL | Stock | 234.55 | 234.58 | 234.44 | 234.56 | 4529.0 |
| 2025-03-07 05:00:00 | AAPL | Stock | 234.56 | 234.74 | 234.45 | 234.61 | 3124.0 |
| 2025-03-07 05:30:00 | AAPL | Stock | 234.7 | 234.79 | 234.65 | 234.79 | 1298.0 |
| 2025-03-07 06:00:00 | AAPL | Stock | 234.6 | 234.77 | 234.6 | 234.75 | 4412.0 |
| 2025-03-07 06:30:00 | AAPL | Stock | 234.66 | 234.74 | 234.62 | 234.7 | 5212.0 |
| 2025-03-07 07:00:00 | AAPL | Stock | 234.69 | 234.93 | 234.6 | 234.6 | 6838.0 |
| 2025-03-07 07:30:00 | AAPL | Stock | 234.64 | 234.65 | 234.37 | 234.55 | 8936.0 |
| 2025-03-07 08:00:00 | AAPL | Stock | 234.68 | 235.0 | 234.22 | 234.7 | 48475.0 |
| 2025-03-07 08:30:00 | AAPL | Stock | 234.71 | 236.1 | 234.31 | 234.4 | 45378.0 |
| 2025-03-07 09:00:00 | AAPL | Stock | 234.51 | 235.2 | 233.9455 | 235.08 | 88579.0 |
| 2025-03-07 09:30:00 | AAPL | Stock | 235.17 | 239.439 | 234.76 | 238.335 | 4247440.0 |
| 2025-03-07 10:00:00 | AAPL | Stock | 238.34 | 238.97 | 237.8 | 238.31 | 2109000.0 |
| 2025-03-07 10:30:00 | AAPL | Stock | 238.315 | 240.16 | 237.02 | 238.915 | 2842478.0 |
| 2025-03-07 11:00:00 | AAPL | Stock | 238.91 | 239.53 | 238.32 | 239.02 | 2196651.0 |
| 2025-03-07 11:30:00 | AAPL | Stock | 239.02 | 239.34 | 237.87 | 239.2106 | 2830620.0 |
| 2025-03-07 12:00:00 | AAPL | Stock | 239.225 | 239.7 | 237.86 | 239.29 | 2063130.0 |
| 2025-03-07 12:30:00 | AAPL | Stock | 239.26 | 240.83 | 238.8 | 240.03 | 2869740.0 |
| 2025-03-07 13:00:00 | AAPL | Stock | 240.05 | 241.37 | 239.99 | 240.4285 | 2265426.0 |
| 2025-03-07 13:30:00 | AAPL | Stock | 240.425 | 240.92 | 239.3703 | 239.43 | 1563042.0 |
| 2025-03-07 14:00:00 | AAPL | Stock | 239.445 | 239.91 | 238.57 | 239.65 | 1461668.0 |
| 2025-03-07 14:30:00 | AAPL | Stock | 239.665 | 239.86 | 238.68 | 239.22 | 1175949.0 |
| 2025-03-07 15:00:00 | AAPL | Stock | 239.21 | 239.255 | 238.08 | 238.8114 | 1270782.0 |
| 2025-03-07 15:30:00 | AAPL | Stock | 238.8 | 239.77 | 237.94 | 239.03 | 3221428.0 |
| 2025-03-07 16:00:00 | AAPL | Stock | 239.02 | 239.07 | 238.26 | 238.8385 | 4626267.0 |
| 2025-03-07 16:30:00 | AAPL | Stock | 238.6983 | 239.07 | 238.56 | 238.58 | 45833.0 |
| 2025-03-07 17:00:00 | AAPL | Stock | 238.66 | 239.07 | 238.38 | 238.8 | 21597.0 |
| 2025-03-07 17:30:00 | AAPL | Stock | 238.5 | 238.6 | 238.4 | 238.4347 | 3358.0 |
| 2025-03-07 18:00:00 | AAPL | Stock | 238.5 | 238.7 | 238.43 | 238.7 | 5489.0 |
| 2025-03-07 18:30:00 | AAPL | Stock | 238.55 | 238.99 | 238.52 | 238.53 | 13114.0 |
| 2025-03-07 19:00:00 | AAPL | Stock | 238.56 | 238.56 | 238.51 | 238.51 | 700.0 |
| 2025-03-07 19:30:00 | AAPL | Stock | 238.6 | 238.78 | 238.54 | 238.65 | 3236.0 |
| 2025-03-07 04:00:00 | MSFT | Stock | 396.56 | 396.67 | 396.5 | 396.5 | 900.0 |
| 2025-03-07 04:30:00 | MSFT | Stock | 396.64 | 396.73 | 396.01 | 396.33 | 5763.0 |
| 2025-03-07 05:00:00 | MSFT | Stock | 396.05 | 396.08 | 395.69 | 395.78 | 2201.0 |
| 2025-03-07 05:30:00 | MSFT | Stock | 395.78 | 396.09 | 395.63 | 395.64 | 2402.0 |
| 2025-03-07 06:00:00 | MSFT | Stock | 395.51 | 395.82 | 395.51 | 395.76 | 1748.0 |
| 2025-03-07 06:30:00 | MSFT | Stock | 395.9 | 396.06 | 395.6 | 395.6 | 2094.0 |
| 2025-03-07 07:00:00 | MSFT | Stock | 395.65 | 396.0 | 395.55 | 396.0 | 1545.0 |
| 2025-03-07 07:30:00 | MSFT | Stock | 395.78 | 395.99 | 395.0 | 395.44 | 9932.0 |
| 2025-03-07 08:00:00 | MSFT | Stock | 396.27 | 396.73 | 395.0001 | 395.3 | 15080.0 |
| 2025-03-07 08:30:00 | MSFT | Stock | 395.26 | 397.79 | 394.53 | 394.53 | 37172.0 |
| 2025-03-07 09:00:00 | MSFT | Stock | 394.66 | 395.71 | 391.92 | 392.08 | 41994.0 |
| 2025-03-07 09:30:00 | MSFT | Stock | 392.4 | 394.8 | 390.9 | 392.44 | 1685336.0 |
| 2025-03-07 10:00:00 | MSFT | Stock | 392.485 | 393.9691 | 391.25 | 391.39 | 1026073.0 |
| 2025-03-07 10:30:00 | MSFT | Stock | 391.385 | 391.81 | 388.33 | 390.8 | 1046568.0 |
| 2025-03-07 11:00:00 | MSFT | Stock | 390.75 | 390.75 | 387.375 | 387.9026 | 641390.0 |
| 2025-03-07 11:30:00 | MSFT | Stock | 387.97 | 388.3 | 385.81 | 386.5441 | 885270.0 |
| 2025-03-07 12:00:00 | MSFT | Stock | 386.6 | 388.01 | 385.54 | 387.73 | 658793.0 |
| 2025-03-07 12:30:00 | MSFT | Stock | 387.74 | 390.49 | 387.12 | 388.32 | 636853.0 |
> showing 50 of 102,944 rows — these rows as CSV