PREVIEW / stock_30min / 2025-01-21
file: by_date/stock_30min/2025/2025-01-21.parquet size: 2.3 MB rows: 112,874 symbols: 593
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-01-21 04:00:00 | AAPL | Stock | 227.33 | 228.27 | 226.5 | 227.23 | 54538.0 |
| 2025-01-21 04:30:00 | AAPL | Stock | 227.25 | 227.34 | 226.65 | 227.03 | 26909.0 |
| 2025-01-21 05:00:00 | AAPL | Stock | 227.14 | 227.51 | 227.14 | 227.51 | 7501.0 |
| 2025-01-21 05:30:00 | AAPL | Stock | 227.46 | 227.51 | 226.8 | 226.8 | 16230.0 |
| 2025-01-21 06:00:00 | AAPL | Stock | 226.96 | 227.14 | 226.25 | 226.3 | 24919.0 |
| 2025-01-21 06:30:00 | AAPL | Stock | 226.4 | 226.56 | 225.34 | 225.45 | 86067.0 |
| 2025-01-21 07:00:00 | AAPL | Stock | 225.49 | 225.91 | 224.82 | 225.39 | 168073.0 |
| 2025-01-21 07:30:00 | AAPL | Stock | 225.39 | 226.1 | 225.33 | 225.87 | 96554.0 |
| 2025-01-21 08:00:00 | AAPL | Stock | 225.25 | 227.75 | 224.7 | 225.0039 | 352896.0 |
| 2025-01-21 08:30:00 | AAPL | Stock | 225.1 | 226.0999 | 225.0 | 226.0517 | 238015.0 |
| 2025-01-21 09:00:00 | AAPL | Stock | 226.06 | 226.09 | 223.37 | 224.05 | 580206.0 |
| 2025-01-21 09:30:00 | AAPL | Stock | 224.0 | 224.42 | 220.8 | 221.86 | 13897314.0 |
| 2025-01-21 10:00:00 | AAPL | Stock | 221.867 | 222.3 | 221.19 | 221.7703 | 4680635.0 |
| 2025-01-21 10:30:00 | AAPL | Stock | 221.775 | 222.1 | 220.6 | 221.31 | 4812968.0 |
| 2025-01-21 11:00:00 | AAPL | Stock | 221.3 | 221.44 | 219.7 | 220.1078 | 5567175.0 |
| 2025-01-21 11:30:00 | AAPL | Stock | 220.1 | 220.38 | 219.38 | 220.17 | 4232029.0 |
| 2025-01-21 12:00:00 | AAPL | Stock | 220.1757 | 220.77 | 219.82 | 220.36 | 3320196.0 |
| 2025-01-21 12:30:00 | AAPL | Stock | 220.36 | 221.07 | 220.22 | 220.235 | 2804628.0 |
| 2025-01-21 13:00:00 | AAPL | Stock | 220.23 | 220.5 | 220.0 | 220.405 | 2237096.0 |
| 2025-01-21 13:30:00 | AAPL | Stock | 220.4047 | 221.28 | 220.37 | 221.21 | 2586068.0 |
| 2025-01-21 14:00:00 | AAPL | Stock | 221.21 | 221.69 | 220.95 | 221.61 | 2356002.0 |
| 2025-01-21 14:30:00 | AAPL | Stock | 221.605 | 221.61 | 220.38 | 221.1203 | 2467886.0 |
| 2025-01-21 15:00:00 | AAPL | Stock | 221.125 | 221.67 | 220.31 | 221.65 | 3030209.0 |
| 2025-01-21 15:30:00 | AAPL | Stock | 221.64 | 222.79 | 221.34 | 222.66 | 5622035.0 |
| 2025-01-21 16:00:00 | AAPL | Stock | 222.63 | 222.76 | 221.98 | 222.14 | 12907182.0 |
| 2025-01-21 16:30:00 | AAPL | Stock | 222.11 | 222.64 | 221.68 | 221.8988 | 115181.0 |
| 2025-01-21 17:00:00 | AAPL | Stock | 221.8995 | 222.1 | 221.7001 | 221.75 | 55482.0 |
| 2025-01-21 17:30:00 | AAPL | Stock | 221.76 | 222.64 | 221.7 | 222.64 | 71617.0 |
| 2025-01-21 18:00:00 | AAPL | Stock | 221.89 | 222.64 | 221.28 | 221.89 | 99257.0 |
| 2025-01-21 18:30:00 | AAPL | Stock | 221.8801 | 222.15 | 221.854 | 221.921 | 44911.0 |
| 2025-01-21 19:00:00 | AAPL | Stock | 221.92 | 221.97 | 221.8 | 221.91 | 24461.0 |
| 2025-01-21 19:30:00 | AAPL | Stock | 221.87 | 222.17 | 221.86 | 222.0501 | 47889.0 |
| 2025-01-21 04:00:00 | MSFT | Stock | 430.26 | 430.8 | 430.18 | 430.8 | 5592.0 |
| 2025-01-21 04:30:00 | MSFT | Stock | 430.64 | 431.27 | 430.64 | 431.27 | 3379.0 |
| 2025-01-21 05:00:00 | MSFT | Stock | 431.37 | 431.43 | 431.35 | 431.41 | 900.0 |
| 2025-01-21 05:30:00 | MSFT | Stock | 431.41 | 431.65 | 431.35 | 431.35 | 1584.0 |
| 2025-01-21 06:00:00 | MSFT | Stock | 431.2 | 431.47 | 431.0 | 431.0 | 2669.0 |
| 2025-01-21 06:30:00 | MSFT | Stock | 431.17 | 431.19 | 431.02 | 431.02 | 500.0 |
| 2025-01-21 07:00:00 | MSFT | Stock | 431.2 | 431.33 | 430.88 | 431.24 | 6268.0 |
| 2025-01-21 07:30:00 | MSFT | Stock | 431.25 | 431.78 | 431.19 | 431.69 | 5704.0 |
| 2025-01-21 08:00:00 | MSFT | Stock | 431.0 | 431.7 | 429.94 | 431.005 | 17737.0 |
| 2025-01-21 08:30:00 | MSFT | Stock | 431.0 | 431.65 | 431.0 | 431.54 | 5229.0 |
| 2025-01-21 09:00:00 | MSFT | Stock | 431.58 | 431.71 | 429.01 | 430.26 | 21485.0 |
| 2025-01-21 09:30:00 | MSFT | Stock | 430.2 | 430.79 | 425.595 | 426.48 | 1791343.0 |
| 2025-01-21 10:00:00 | MSFT | Stock | 426.48 | 428.71 | 425.76 | 428.5 | 620812.0 |
| 2025-01-21 10:30:00 | MSFT | Stock | 428.46 | 428.52 | 427.03 | 427.59 | 435554.0 |
| 2025-01-21 11:00:00 | MSFT | Stock | 427.56 | 428.9399 | 427.01 | 428.01 | 410502.0 |
| 2025-01-21 11:30:00 | MSFT | Stock | 428.0 | 428.942 | 427.71 | 428.91 | 430694.0 |
| 2025-01-21 12:00:00 | MSFT | Stock | 428.902 | 428.95 | 427.91 | 428.57 | 413338.0 |
| 2025-01-21 12:30:00 | MSFT | Stock | 428.56 | 429.99 | 428.55 | 429.87 | 454913.0 |
> showing 50 of 112,874 rows — these rows as CSV