PREVIEW / stock_30min / 2025-03-19
file: by_date/stock_30min/2025/2025-03-19.parquet size: 2.1 MB rows: 100,955 symbols: 478
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-19 04:00:00 | AAPL | Stock | 213.58 | 213.58 | 212.92 | 212.94 | 4295.0 |
| 2025-03-19 04:30:00 | AAPL | Stock | 213.1 | 213.23 | 213.0 | 213.0 | 4385.0 |
| 2025-03-19 05:00:00 | AAPL | Stock | 213.0 | 213.14 | 212.95 | 213.13 | 2533.0 |
| 2025-03-19 05:30:00 | AAPL | Stock | 213.22 | 213.31 | 213.22 | 213.31 | 603.0 |
| 2025-03-19 06:00:00 | AAPL | Stock | 213.33 | 213.39 | 213.27 | 213.35 | 3117.0 |
| 2025-03-19 06:30:00 | AAPL | Stock | 213.4 | 213.43 | 213.29 | 213.29 | 3174.0 |
| 2025-03-19 07:00:00 | AAPL | Stock | 213.26 | 213.34 | 213.25 | 213.34 | 1861.0 |
| 2025-03-19 07:30:00 | AAPL | Stock | 213.3 | 213.36 | 213.06 | 213.24 | 6906.0 |
| 2025-03-19 08:00:00 | AAPL | Stock | 213.26 | 213.4068 | 212.62 | 213.1578 | 25273.0 |
| 2025-03-19 08:30:00 | AAPL | Stock | 213.19 | 213.498 | 213.19 | 213.29 | 16655.0 |
| 2025-03-19 09:00:00 | AAPL | Stock | 213.29 | 214.56 | 213.0 | 214.25 | 79091.0 |
| 2025-03-19 09:30:00 | AAPL | Stock | 214.09 | 217.72 | 213.9101 | 217.155 | 4887485.0 |
| 2025-03-19 10:00:00 | AAPL | Stock | 217.18 | 218.76 | 217.06 | 217.145 | 3767302.0 |
| 2025-03-19 10:30:00 | AAPL | Stock | 217.21 | 217.2198 | 215.45 | 215.55 | 2328220.0 |
| 2025-03-19 11:00:00 | AAPL | Stock | 215.51 | 215.89 | 214.96 | 215.669 | 1752411.0 |
| 2025-03-19 11:30:00 | AAPL | Stock | 215.68 | 216.75 | 215.635 | 216.269 | 1460076.0 |
| 2025-03-19 12:00:00 | AAPL | Stock | 216.24 | 216.34 | 215.18 | 215.3 | 1020310.0 |
| 2025-03-19 12:30:00 | AAPL | Stock | 215.29 | 215.33 | 214.44 | 214.9573 | 1246102.0 |
| 2025-03-19 13:00:00 | AAPL | Stock | 214.97 | 215.1 | 214.29 | 214.38 | 909911.0 |
| 2025-03-19 13:30:00 | AAPL | Stock | 214.39 | 214.66 | 213.86 | 214.07 | 1303061.0 |
| 2025-03-19 14:00:00 | AAPL | Stock | 213.98 | 215.05 | 213.75 | 214.27 | 1907554.0 |
| 2025-03-19 14:30:00 | AAPL | Stock | 214.27 | 215.605 | 214.25 | 215.5888 | 2113239.0 |
| 2025-03-19 15:00:00 | AAPL | Stock | 215.57 | 217.059 | 215.21 | 215.5099 | 2578484.0 |
| 2025-03-19 15:30:00 | AAPL | Stock | 215.505 | 215.68 | 214.48 | 215.3 | 3497279.0 |
| 2025-03-19 16:00:00 | AAPL | Stock | 215.24 | 215.55 | 215.24 | 215.4578 | 12763676.0 |
| 2025-03-19 16:30:00 | AAPL | Stock | 215.37 | 215.45 | 215.24 | 215.3301 | 48037.0 |
| 2025-03-19 17:00:00 | AAPL | Stock | 215.33 | 215.5997 | 215.33 | 215.5997 | 12996.0 |
| 2025-03-19 17:30:00 | AAPL | Stock | 215.55 | 215.58 | 215.5 | 215.5 | 3116.0 |
| 2025-03-19 18:00:00 | AAPL | Stock | 215.47 | 215.76 | 215.41 | 215.7 | 7659.0 |
| 2025-03-19 18:30:00 | AAPL | Stock | 215.75 | 215.84 | 215.6135 | 215.8 | 8629.0 |
| 2025-03-19 19:00:00 | AAPL | Stock | 215.837 | 215.96 | 215.75 | 215.85 | 4040.0 |
| 2025-03-19 19:30:00 | AAPL | Stock | 215.85 | 216.3 | 215.8 | 216.15 | 17417.0 |
| 2025-03-19 04:00:00 | MSFT | Stock | 384.73 | 384.73 | 383.27 | 383.32 | 500.0 |
| 2025-03-19 04:30:00 | MSFT | Stock | 383.6 | 383.64 | 383.4 | 383.4 | 1040.0 |
| 2025-03-19 05:00:00 | MSFT | Stock | 383.5 | 383.72 | 383.5 | 383.72 | 947.0 |
| 2025-03-19 05:30:00 | MSFT | Stock | 383.97 | 384.46 | 383.97 | 384.46 | 638.0 |
| 2025-03-19 06:00:00 | MSFT | Stock | 384.47 | 384.47 | 384.26 | 384.31 | 727.0 |
| 2025-03-19 06:30:00 | MSFT | Stock | 384.12 | 384.3 | 384.12 | 384.3 | 300.0 |
| 2025-03-19 07:00:00 | MSFT | Stock | 384.33 | 384.33 | 384.33 | 384.33 | 193.0 |
| 2025-03-19 07:30:00 | MSFT | Stock | 384.5 | 384.98 | 384.5 | 384.79 | 3488.0 |
| 2025-03-19 08:00:00 | MSFT | Stock | 384.33 | 384.98 | 384.13 | 384.3297 | 6790.0 |
| 2025-03-19 08:30:00 | MSFT | Stock | 384.2 | 384.4328 | 384.1056 | 384.2 | 1120.0 |
| 2025-03-19 09:00:00 | MSFT | Stock | 384.3 | 386.48 | 383.55 | 385.77 | 16765.0 |
| 2025-03-19 09:30:00 | MSFT | Stock | 385.525 | 387.5799 | 384.0 | 386.92 | 1172562.0 |
| 2025-03-19 10:00:00 | MSFT | Stock | 387.01 | 387.92 | 386.82 | 387.12 | 456280.0 |
| 2025-03-19 10:30:00 | MSFT | Stock | 387.12 | 387.23 | 385.44 | 385.5 | 285353.0 |
| 2025-03-19 11:00:00 | MSFT | Stock | 385.5 | 386.74 | 385.4 | 386.15 | 402960.0 |
| 2025-03-19 11:30:00 | MSFT | Stock | 386.125 | 387.6681 | 385.97 | 387.39 | 324781.0 |
| 2025-03-19 12:00:00 | MSFT | Stock | 387.44 | 387.9694 | 386.9 | 387.18 | 369333.0 |
| 2025-03-19 12:30:00 | MSFT | Stock | 387.19 | 387.255 | 386.07 | 386.6964 | 314684.0 |
> showing 50 of 100,955 rows — these rows as CSV