PREVIEW / stock_30min / 2025-03-12
file: by_date/stock_30min/2025/2025-03-12.parquet size: 2.2 MB rows: 103,578 symbols: 491
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-12 04:00:00 | AAPL | Stock | 219.8 | 220.31 | 219.55 | 219.55 | 11472.0 |
| 2025-03-12 04:30:00 | AAPL | Stock | 219.65 | 220.72 | 219.65 | 220.59 | 12051.0 |
| 2025-03-12 05:00:00 | AAPL | Stock | 220.66 | 220.98 | 220.21 | 220.25 | 11030.0 |
| 2025-03-12 05:30:00 | AAPL | Stock | 220.23 | 220.45 | 220.23 | 220.3 | 2698.0 |
| 2025-03-12 06:00:00 | AAPL | Stock | 220.16 | 220.25 | 220.09 | 220.09 | 11591.0 |
| 2025-03-12 06:30:00 | AAPL | Stock | 220.09 | 220.35 | 219.88 | 220.18 | 19033.0 |
| 2025-03-12 07:00:00 | AAPL | Stock | 220.27 | 220.84 | 220.24 | 220.68 | 14533.0 |
| 2025-03-12 07:30:00 | AAPL | Stock | 220.68 | 220.88 | 220.36 | 220.45 | 12564.0 |
| 2025-03-12 08:00:00 | AAPL | Stock | 220.24 | 221.36 | 219.6 | 221.0 | 143835.0 |
| 2025-03-12 08:30:00 | AAPL | Stock | 221.06 | 222.29 | 220.85 | 221.75 | 195794.0 |
| 2025-03-12 09:00:00 | AAPL | Stock | 221.76 | 222.3899 | 220.05 | 220.12 | 285877.0 |
| 2025-03-12 09:30:00 | AAPL | Stock | 220.14 | 221.75 | 219.27 | 221.41 | 6506599.0 |
| 2025-03-12 10:00:00 | AAPL | Stock | 221.39 | 221.75 | 218.83 | 218.95 | 3475300.0 |
| 2025-03-12 10:30:00 | AAPL | Stock | 218.95 | 219.4 | 216.0 | 216.1 | 4364707.0 |
| 2025-03-12 11:00:00 | AAPL | Stock | 216.125 | 216.8 | 214.91 | 216.445 | 3653914.0 |
| 2025-03-12 11:30:00 | AAPL | Stock | 216.47 | 217.893 | 216.33 | 217.78 | 2142580.0 |
| 2025-03-12 12:00:00 | AAPL | Stock | 217.78 | 218.61 | 217.5 | 218.3604 | 1825980.0 |
| 2025-03-12 12:30:00 | AAPL | Stock | 218.45 | 218.61 | 216.88 | 217.245 | 2014507.0 |
| 2025-03-12 13:00:00 | AAPL | Stock | 217.27 | 218.23 | 217.02 | 218.1898 | 1296551.0 |
| 2025-03-12 13:30:00 | AAPL | Stock | 218.17 | 218.22 | 216.06 | 216.11 | 1726380.0 |
| 2025-03-12 14:00:00 | AAPL | Stock | 216.095 | 216.96 | 215.91 | 216.11 | 1601304.0 |
| 2025-03-12 14:30:00 | AAPL | Stock | 216.11 | 217.0899 | 215.84 | 216.43 | 1850234.0 |
| 2025-03-12 15:00:00 | AAPL | Stock | 216.42 | 216.45 | 215.05 | 215.6399 | 2817684.0 |
| 2025-03-12 15:30:00 | AAPL | Stock | 215.64 | 217.28 | 215.28 | 216.94 | 5676458.0 |
| 2025-03-12 16:00:00 | AAPL | Stock | 216.98 | 217.45 | 216.5 | 217.0 | 7476172.0 |
| 2025-03-12 16:30:00 | AAPL | Stock | 216.98 | 217.43 | 216.98 | 217.12 | 38813.0 |
| 2025-03-12 17:00:00 | AAPL | Stock | 217.01 | 217.17 | 216.98 | 217.17 | 66349.0 |
| 2025-03-12 17:30:00 | AAPL | Stock | 217.17 | 217.17 | 217.01 | 217.15 | 15531.0 |
| 2025-03-12 18:00:00 | AAPL | Stock | 217.12 | 217.4 | 216.98 | 217.22 | 13436.0 |
| 2025-03-12 18:30:00 | AAPL | Stock | 217.16 | 217.3 | 217.0 | 217.0095 | 15560.0 |
| 2025-03-12 19:00:00 | AAPL | Stock | 217.1993 | 217.48 | 217.0927 | 217.36 | 19687.0 |
| 2025-03-12 19:30:00 | AAPL | Stock | 217.36 | 217.49 | 217.2 | 217.41 | 15420.0 |
| 2025-03-12 04:00:00 | MSFT | Stock | 381.0 | 381.35 | 380.8 | 381.2 | 1641.0 |
| 2025-03-12 04:30:00 | MSFT | Stock | 381.34 | 383.0 | 381.34 | 382.9 | 523.0 |
| 2025-03-12 05:00:00 | MSFT | Stock | 383.14 | 383.14 | 382.5 | 382.61 | 1087.0 |
| 2025-03-12 05:30:00 | MSFT | Stock | 382.74 | 383.19 | 382.74 | 382.94 | 1434.0 |
| 2025-03-12 06:00:00 | MSFT | Stock | 383.25 | 383.43 | 382.51 | 382.74 | 4206.0 |
| 2025-03-12 06:30:00 | MSFT | Stock | 382.51 | 382.51 | 382.4 | 382.4 | 1881.0 |
| 2025-03-12 07:00:00 | MSFT | Stock | 382.5 | 383.16 | 382.4 | 383.16 | 5557.0 |
| 2025-03-12 07:30:00 | MSFT | Stock | 382.59 | 383.16 | 382.55 | 382.75 | 5115.0 |
| 2025-03-12 08:00:00 | MSFT | Stock | 382.87 | 383.32 | 380.45 | 382.62 | 23370.0 |
| 2025-03-12 08:30:00 | MSFT | Stock | 382.7 | 385.4 | 382.51 | 383.78 | 67830.0 |
| 2025-03-12 09:00:00 | MSFT | Stock | 383.75 | 383.75 | 382.48 | 382.99 | 44920.0 |
| 2025-03-12 09:30:00 | MSFT | Stock | 382.95 | 384.84 | 379.41 | 381.05 | 2067857.0 |
| 2025-03-12 10:00:00 | MSFT | Stock | 381.0 | 381.7 | 379.41 | 380.49 | 958289.0 |
| 2025-03-12 10:30:00 | MSFT | Stock | 380.4825 | 381.35 | 379.61 | 379.745 | 741351.0 |
| 2025-03-12 11:00:00 | MSFT | Stock | 379.76 | 382.12 | 378.9507 | 381.5701 | 727060.0 |
| 2025-03-12 11:30:00 | MSFT | Stock | 381.65 | 383.25 | 381.29 | 383.13 | 577145.0 |
| 2025-03-12 12:00:00 | MSFT | Stock | 383.13 | 384.7537 | 382.695 | 384.065 | 690919.0 |
| 2025-03-12 12:30:00 | MSFT | Stock | 384.15 | 385.2165 | 382.88 | 383.43 | 573612.0 |
> showing 50 of 103,578 rows — these rows as CSV