PREVIEW / stock_30min / 2025-03-27
file: by_date/stock_30min/2025/2025-03-27.parquet size: 2.1 MB rows: 99,966 symbols: 479
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-27 04:00:00 | AAPL | Stock | 221.0 | 221.09 | 220.5 | 221.0 | 18057.0 |
| 2025-03-27 04:30:00 | AAPL | Stock | 221.0 | 221.3 | 220.93 | 221.2 | 4265.0 |
| 2025-03-27 05:00:00 | AAPL | Stock | 221.3 | 221.45 | 220.9 | 221.26 | 3757.0 |
| 2025-03-27 05:30:00 | AAPL | Stock | 221.14 | 221.16 | 221.13 | 221.14 | 581.0 |
| 2025-03-27 06:00:00 | AAPL | Stock | 221.27 | 221.28 | 221.06 | 221.06 | 1260.0 |
| 2025-03-27 06:30:00 | AAPL | Stock | 221.08 | 221.08 | 220.55 | 220.6 | 1608.0 |
| 2025-03-27 07:00:00 | AAPL | Stock | 220.64 | 221.1 | 220.64 | 220.65 | 6048.0 |
| 2025-03-27 07:30:00 | AAPL | Stock | 220.75 | 221.47 | 220.7 | 221.47 | 7192.0 |
| 2025-03-27 08:00:00 | AAPL | Stock | 220.66 | 222.35 | 220.64 | 221.1 | 28570.0 |
| 2025-03-27 08:30:00 | AAPL | Stock | 221.0109 | 221.74 | 221.0 | 221.66 | 12247.0 |
| 2025-03-27 09:00:00 | AAPL | Stock | 221.64 | 221.85 | 220.82 | 221.37 | 36445.0 |
| 2025-03-27 09:30:00 | AAPL | Stock | 221.39 | 222.1 | 220.5601 | 221.555 | 2709906.0 |
| 2025-03-27 10:00:00 | AAPL | Stock | 221.58 | 221.71 | 220.81 | 221.65 | 1294182.0 |
| 2025-03-27 10:30:00 | AAPL | Stock | 221.65 | 222.56 | 221.4 | 222.485 | 1250821.0 |
| 2025-03-27 11:00:00 | AAPL | Stock | 222.485 | 223.24 | 222.35 | 222.8001 | 1217036.0 |
| 2025-03-27 11:30:00 | AAPL | Stock | 222.8 | 223.5771 | 222.565 | 223.0 | 1199161.0 |
| 2025-03-27 12:00:00 | AAPL | Stock | 223.005 | 223.76 | 222.91 | 223.195 | 969643.0 |
| 2025-03-27 12:30:00 | AAPL | Stock | 223.18 | 223.98 | 222.72 | 222.89 | 986381.0 |
| 2025-03-27 13:00:00 | AAPL | Stock | 222.905 | 223.645 | 222.72 | 223.09 | 898464.0 |
| 2025-03-27 13:30:00 | AAPL | Stock | 223.08 | 223.7 | 223.05 | 223.32 | 822870.0 |
| 2025-03-27 14:00:00 | AAPL | Stock | 223.32 | 224.57 | 223.295 | 224.37 | 2023865.0 |
| 2025-03-27 14:30:00 | AAPL | Stock | 224.35 | 224.95 | 224.035 | 224.106 | 1311804.0 |
| 2025-03-27 15:00:00 | AAPL | Stock | 224.095 | 224.99 | 223.945 | 224.79 | 1284453.0 |
| 2025-03-27 15:30:00 | AAPL | Stock | 224.8 | 224.99 | 223.59 | 223.93 | 3570507.0 |
| 2025-03-27 16:00:00 | AAPL | Stock | 223.93 | 223.95 | 223.39 | 223.49 | 5812058.0 |
| 2025-03-27 16:30:00 | AAPL | Stock | 223.49 | 223.85 | 223.45 | 223.6 | 39288.0 |
| 2025-03-27 17:00:00 | AAPL | Stock | 223.6 | 223.85 | 223.4 | 223.4 | 2773.0 |
| 2025-03-27 17:30:00 | AAPL | Stock | 223.45 | 223.52 | 223.41 | 223.52 | 2075.0 |
| 2025-03-27 18:00:00 | AAPL | Stock | 223.47 | 223.6 | 223.42 | 223.59 | 4562.0 |
| 2025-03-27 18:30:00 | AAPL | Stock | 223.4469 | 223.5 | 223.41 | 223.5 | 3429.0 |
| 2025-03-27 19:00:00 | AAPL | Stock | 223.37 | 223.4 | 223.2909 | 223.39 | 8202.0 |
| 2025-03-27 19:30:00 | AAPL | Stock | 223.31 | 223.46 | 223.25 | 223.46 | 5443.0 |
| 2025-03-27 04:00:00 | MSFT | Stock | 390.14 | 390.14 | 389.41 | 389.53 | 1065.0 |
| 2025-03-27 04:30:00 | MSFT | Stock | 390.49 | 391.33 | 390.39 | 391.33 | 2897.0 |
| 2025-03-27 05:00:00 | MSFT | Stock | 390.72 | 391.21 | 390.63 | 390.63 | 8401.0 |
| 2025-03-27 05:30:00 | MSFT | Stock | 390.86 | 391.36 | 390.86 | 391.36 | 880.0 |
| 2025-03-27 06:30:00 | MSFT | Stock | 391.03 | 391.03 | 390.24 | 390.27 | 2457.0 |
| 2025-03-27 07:00:00 | MSFT | Stock | 390.0 | 390.47 | 389.62 | 389.64 | 1831.0 |
| 2025-03-27 07:30:00 | MSFT | Stock | 389.4 | 390.68 | 389.23 | 390.67 | 4333.0 |
| 2025-03-27 08:00:00 | MSFT | Stock | 390.24 | 391.2 | 389.2379 | 390.0 | 9086.0 |
| 2025-03-27 08:30:00 | MSFT | Stock | 390.5 | 390.81 | 389.82 | 390.34 | 7028.0 |
| 2025-03-27 09:00:00 | MSFT | Stock | 389.94 | 390.65 | 389.4 | 390.13 | 19714.0 |
| 2025-03-27 09:30:00 | MSFT | Stock | 390.24 | 390.42 | 387.395 | 389.72 | 1131130.0 |
| 2025-03-27 10:00:00 | MSFT | Stock | 389.68 | 391.2 | 389.46 | 390.7 | 627129.0 |
| 2025-03-27 10:30:00 | MSFT | Stock | 390.73 | 390.97 | 389.67 | 390.54 | 401865.0 |
| 2025-03-27 11:00:00 | MSFT | Stock | 390.625 | 391.19 | 390.0101 | 390.63 | 310443.0 |
| 2025-03-27 11:30:00 | MSFT | Stock | 390.63 | 390.63 | 389.71 | 390.28 | 281177.0 |
| 2025-03-27 12:00:00 | MSFT | Stock | 390.275 | 391.79 | 390.21 | 390.6833 | 243565.0 |
| 2025-03-27 12:30:00 | MSFT | Stock | 390.71 | 391.435 | 389.64 | 389.67 | 320879.0 |
| 2025-03-27 13:00:00 | MSFT | Stock | 389.7 | 390.395 | 389.41 | 389.82 | 332620.0 |
> showing 50 of 99,966 rows — these rows as CSV