PREVIEW / stock_30min / 2025-03-17
file: by_date/stock_30min/2025/2025-03-17.parquet size: 2.2 MB rows: 104,393 symbols: 489
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-17 04:00:00 | AAPL | Stock | 212.86 | 213.35 | 212.0 | 212.74 | 9832.0 |
| 2025-03-17 04:30:00 | AAPL | Stock | 212.53 | 212.59 | 212.29 | 212.55 | 10176.0 |
| 2025-03-17 05:00:00 | AAPL | Stock | 212.49 | 212.68 | 212.1 | 212.16 | 5245.0 |
| 2025-03-17 05:30:00 | AAPL | Stock | 212.19 | 212.41 | 212.18 | 212.37 | 4693.0 |
| 2025-03-17 06:00:00 | AAPL | Stock | 212.37 | 212.6 | 212.34 | 212.56 | 6926.0 |
| 2025-03-17 06:30:00 | AAPL | Stock | 212.63 | 212.96 | 212.5 | 212.73 | 8259.0 |
| 2025-03-17 07:00:00 | AAPL | Stock | 212.77 | 213.18 | 212.69 | 212.96 | 14114.0 |
| 2025-03-17 07:30:00 | AAPL | Stock | 212.96 | 213.02 | 212.77 | 212.79 | 13384.0 |
| 2025-03-17 08:00:00 | AAPL | Stock | 212.94 | 213.19 | 212.2 | 213.1 | 81241.0 |
| 2025-03-17 08:30:00 | AAPL | Stock | 213.1 | 214.0 | 213.05 | 213.82 | 59394.0 |
| 2025-03-17 09:00:00 | AAPL | Stock | 213.75 | 213.82 | 213.03 | 213.29 | 98660.0 |
| 2025-03-17 09:30:00 | AAPL | Stock | 213.31 | 214.97 | 212.17 | 213.72 | 4413406.0 |
| 2025-03-17 10:00:00 | AAPL | Stock | 213.73 | 214.0 | 212.71 | 213.2247 | 2232264.0 |
| 2025-03-17 10:30:00 | AAPL | Stock | 213.24 | 213.26 | 211.3075 | 211.39 | 2183313.0 |
| 2025-03-17 11:00:00 | AAPL | Stock | 211.39 | 211.67 | 210.4697 | 210.7547 | 2429258.0 |
| 2025-03-17 11:30:00 | AAPL | Stock | 210.755 | 211.05 | 209.97 | 210.915 | 1770133.0 |
| 2025-03-17 12:00:00 | AAPL | Stock | 210.9157 | 211.89 | 210.57 | 211.2 | 1549692.0 |
| 2025-03-17 12:30:00 | AAPL | Stock | 211.21 | 211.7906 | 211.14 | 211.5662 | 1009915.0 |
| 2025-03-17 13:00:00 | AAPL | Stock | 211.55 | 212.37 | 211.09 | 212.3303 | 1408227.0 |
| 2025-03-17 13:30:00 | AAPL | Stock | 212.36 | 213.7478 | 212.28 | 213.665 | 1605469.0 |
| 2025-03-17 14:00:00 | AAPL | Stock | 213.66 | 214.7302 | 213.51 | 214.455 | 1659878.0 |
| 2025-03-17 14:30:00 | AAPL | Stock | 214.45 | 214.7968 | 214.315 | 214.55 | 1261883.0 |
| 2025-03-17 15:00:00 | AAPL | Stock | 214.541 | 214.71 | 214.07 | 214.685 | 1332977.0 |
| 2025-03-17 15:30:00 | AAPL | Stock | 214.68 | 215.22 | 213.67 | 214.15 | 5033519.0 |
| 2025-03-17 16:00:00 | AAPL | Stock | 214.0 | 214.26 | 213.6 | 214.0 | 6986608.0 |
| 2025-03-17 16:30:00 | AAPL | Stock | 213.98 | 214.1 | 213.8396 | 213.99 | 60957.0 |
| 2025-03-17 17:00:00 | AAPL | Stock | 213.95 | 213.95 | 213.75 | 213.7501 | 14743.0 |
| 2025-03-17 17:30:00 | AAPL | Stock | 213.8097 | 213.81 | 213.75 | 213.78 | 4853.0 |
| 2025-03-17 18:00:00 | AAPL | Stock | 213.8096 | 213.9482 | 213.78 | 213.87 | 7250.0 |
| 2025-03-17 18:30:00 | AAPL | Stock | 213.8 | 214.0 | 213.8 | 214.0 | 6299.0 |
| 2025-03-17 19:00:00 | AAPL | Stock | 214.02 | 214.05 | 213.73 | 213.76 | 4553.0 |
| 2025-03-17 19:30:00 | AAPL | Stock | 213.763 | 213.9766 | 213.763 | 213.93 | 5512.0 |
| 2025-03-17 04:00:00 | MSFT | Stock | 386.1 | 386.4 | 385.5 | 386.32 | 2959.0 |
| 2025-03-17 04:30:00 | MSFT | Stock | 386.15 | 386.37 | 386.14 | 386.29 | 2532.0 |
| 2025-03-17 05:00:00 | MSFT | Stock | 386.01 | 386.02 | 385.79 | 385.79 | 400.0 |
| 2025-03-17 05:30:00 | MSFT | Stock | 385.84 | 386.03 | 385.81 | 385.81 | 2650.0 |
| 2025-03-17 06:00:00 | MSFT | Stock | 385.82 | 387.0 | 385.82 | 386.99 | 3702.0 |
| 2025-03-17 06:30:00 | MSFT | Stock | 386.91 | 387.2 | 386.53 | 386.99 | 1768.0 |
| 2025-03-17 07:00:00 | MSFT | Stock | 387.05 | 387.3 | 386.3 | 386.3 | 7944.0 |
| 2025-03-17 07:30:00 | MSFT | Stock | 386.31 | 386.44 | 385.86 | 386.15 | 11688.0 |
| 2025-03-17 08:00:00 | MSFT | Stock | 386.14 | 387.589 | 385.35 | 385.48 | 24722.0 |
| 2025-03-17 08:30:00 | MSFT | Stock | 385.3 | 387.38 | 385.3 | 386.69 | 17556.0 |
| 2025-03-17 09:00:00 | MSFT | Stock | 386.56 | 386.85 | 386.1 | 386.74 | 17103.0 |
| 2025-03-17 09:30:00 | MSFT | Stock | 386.7 | 389.93 | 385.93 | 388.79 | 1259488.0 |
| 2025-03-17 10:00:00 | MSFT | Stock | 388.84 | 390.3107 | 387.37 | 389.145 | 766048.0 |
| 2025-03-17 10:30:00 | MSFT | Stock | 389.09 | 389.44 | 387.53 | 388.025 | 604599.0 |
| 2025-03-17 11:00:00 | MSFT | Stock | 388.07 | 388.27 | 386.74 | 386.865 | 580599.0 |
| 2025-03-17 11:30:00 | MSFT | Stock | 386.77 | 387.01 | 385.57 | 386.64 | 361255.0 |
| 2025-03-17 12:00:00 | MSFT | Stock | 386.66 | 387.4541 | 386.14 | 386.96 | 323965.0 |
| 2025-03-17 12:30:00 | MSFT | Stock | 386.99 | 387.97 | 386.918 | 387.64 | 367535.0 |
> showing 50 of 104,393 rows — these rows as CSV