PREVIEW / stock_30min / 2025-03-20
file: by_date/stock_30min/2025/2025-03-20.parquet size: 2.1 MB rows: 101,556 symbols: 482
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-20 04:00:00 | AAPL | Stock | 216.24 | 216.36 | 215.8 | 216.2 | 15922.0 |
| 2025-03-20 04:30:00 | AAPL | Stock | 216.16 | 216.26 | 216.0 | 216.05 | 3673.0 |
| 2025-03-20 05:00:00 | AAPL | Stock | 215.93 | 216.24 | 215.86 | 216.12 | 1518.0 |
| 2025-03-20 05:30:00 | AAPL | Stock | 215.96 | 215.96 | 215.28 | 215.41 | 2935.0 |
| 2025-03-20 06:00:00 | AAPL | Stock | 215.5 | 215.5 | 213.87 | 214.24 | 15567.0 |
| 2025-03-20 06:30:00 | AAPL | Stock | 214.16 | 214.41 | 213.86 | 214.41 | 15293.0 |
| 2025-03-20 07:00:00 | AAPL | Stock | 214.44 | 214.78 | 214.18 | 214.31 | 13152.0 |
| 2025-03-20 07:30:00 | AAPL | Stock | 214.38 | 214.88 | 214.22 | 214.86 | 8909.0 |
| 2025-03-20 08:00:00 | AAPL | Stock | 214.34 | 216.45 | 214.1908 | 214.3187 | 53896.0 |
| 2025-03-20 08:30:00 | AAPL | Stock | 214.3 | 214.84 | 214.22 | 214.74 | 62798.0 |
| 2025-03-20 09:00:00 | AAPL | Stock | 214.67 | 214.67 | 213.41 | 213.81 | 110531.0 |
| 2025-03-20 09:30:00 | AAPL | Stock | 213.915 | 215.49 | 212.9 | 215.49 | 3064777.0 |
| 2025-03-20 10:00:00 | AAPL | Stock | 215.485 | 217.4899 | 215.39 | 216.9904 | 2481130.0 |
| 2025-03-20 10:30:00 | AAPL | Stock | 216.98 | 217.295 | 216.14 | 216.145 | 2012955.0 |
| 2025-03-20 11:00:00 | AAPL | Stock | 216.17 | 216.53 | 215.7876 | 215.919 | 1654190.0 |
| 2025-03-20 11:30:00 | AAPL | Stock | 215.9 | 216.47 | 215.425 | 215.5963 | 1050638.0 |
| 2025-03-20 12:00:00 | AAPL | Stock | 215.589 | 216.44 | 214.02 | 214.14 | 2236678.0 |
| 2025-03-20 12:30:00 | AAPL | Stock | 214.14 | 214.51 | 213.0 | 213.54 | 2278690.0 |
| 2025-03-20 13:00:00 | AAPL | Stock | 213.53 | 214.02 | 213.1 | 213.2252 | 1428606.0 |
| 2025-03-20 13:30:00 | AAPL | Stock | 213.24 | 213.89 | 213.18 | 213.4 | 1074840.0 |
| 2025-03-20 14:00:00 | AAPL | Stock | 213.43 | 213.83 | 212.73 | 212.76 | 1378418.0 |
| 2025-03-20 14:30:00 | AAPL | Stock | 212.77 | 213.09 | 212.22 | 212.3694 | 1874471.0 |
| 2025-03-20 15:00:00 | AAPL | Stock | 212.35 | 213.4 | 212.34 | 212.6835 | 1480600.0 |
| 2025-03-20 15:30:00 | AAPL | Stock | 212.69 | 214.76 | 212.68 | 214.15 | 4173184.0 |
| 2025-03-20 16:00:00 | AAPL | Stock | 214.1 | 214.35 | 213.67 | 214.15 | 12218487.0 |
| 2025-03-20 16:30:00 | AAPL | Stock | 214.14 | 214.27 | 213.88 | 214.0603 | 32683.0 |
| 2025-03-20 17:00:00 | AAPL | Stock | 214.06 | 214.1 | 213.9 | 213.9022 | 8076.0 |
| 2025-03-20 17:30:00 | AAPL | Stock | 213.912 | 213.99 | 213.9 | 213.91 | 2216.0 |
| 2025-03-20 18:00:00 | AAPL | Stock | 213.8523 | 213.99 | 213.7067 | 213.8267 | 10225.0 |
| 2025-03-20 18:30:00 | AAPL | Stock | 213.95 | 213.97 | 213.8799 | 213.8799 | 5682.0 |
| 2025-03-20 19:00:00 | AAPL | Stock | 213.85 | 213.85 | 213.65 | 213.8 | 3165.0 |
| 2025-03-20 19:30:00 | AAPL | Stock | 213.8 | 213.88 | 213.7 | 213.7 | 10879.0 |
| 2025-03-20 04:00:00 | MSFT | Stock | 389.45 | 389.9 | 388.68 | 389.69 | 3912.0 |
| 2025-03-20 04:30:00 | MSFT | Stock | 389.9 | 389.9 | 389.48 | 389.78 | 1050.0 |
| 2025-03-20 05:00:00 | MSFT | Stock | 389.76 | 389.77 | 388.57 | 388.89 | 3011.0 |
| 2025-03-20 05:30:00 | MSFT | Stock | 388.81 | 388.83 | 388.02 | 388.02 | 3715.0 |
| 2025-03-20 06:00:00 | MSFT | Stock | 388.0 | 388.0 | 384.68 | 385.21 | 5241.0 |
| 2025-03-20 06:30:00 | MSFT | Stock | 385.18 | 385.8 | 384.11 | 385.8 | 6091.0 |
| 2025-03-20 07:00:00 | MSFT | Stock | 385.62 | 387.0 | 385.29 | 385.89 | 12419.0 |
| 2025-03-20 07:30:00 | MSFT | Stock | 385.73 | 386.68 | 385.7 | 386.55 | 2945.0 |
| 2025-03-20 08:00:00 | MSFT | Stock | 386.16 | 390.0 | 384.14 | 386.45 | 10881.0 |
| 2025-03-20 08:30:00 | MSFT | Stock | 386.4 | 387.22 | 386.4 | 386.8 | 15469.0 |
| 2025-03-20 09:00:00 | MSFT | Stock | 386.65 | 386.78 | 384.94 | 385.62 | 23933.0 |
| 2025-03-20 09:30:00 | MSFT | Stock | 385.735 | 386.87 | 383.28 | 386.73 | 1003249.0 |
| 2025-03-20 10:00:00 | MSFT | Stock | 386.71 | 391.589 | 386.62 | 390.8353 | 726854.0 |
| 2025-03-20 10:30:00 | MSFT | Stock | 390.855 | 391.785 | 389.32 | 389.49 | 527476.0 |
| 2025-03-20 11:00:00 | MSFT | Stock | 389.5 | 389.67 | 388.42 | 388.6 | 447175.0 |
| 2025-03-20 11:30:00 | MSFT | Stock | 388.58 | 388.94 | 387.5543 | 387.655 | 438521.0 |
| 2025-03-20 12:00:00 | MSFT | Stock | 387.62 | 388.85 | 386.69 | 386.825 | 483081.0 |
| 2025-03-20 12:30:00 | MSFT | Stock | 386.83 | 387.61 | 386.3825 | 386.535 | 369172.0 |
> showing 50 of 101,556 rows — these rows as CSV