PREVIEW / stock_30min / 2025-05-19
file: by_date/stock_30min/2025/2025-05-19.parquet size: 2.2 MB rows: 104,734 symbols: 414
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-05-19 04:00:00 | AAPL | Stock | 207.9 | 208.23 | 206.0 | 207.44 | 30823.0 |
| 2025-05-19 04:30:00 | AAPL | Stock | 207.33 | 208.04 | 207.21 | 207.98 | 13816.0 |
| 2025-05-19 05:00:00 | AAPL | Stock | 207.9 | 208.37 | 207.71 | 208.37 | 5072.0 |
| 2025-05-19 05:30:00 | AAPL | Stock | 208.5 | 208.51 | 208.05 | 208.14 | 10692.0 |
| 2025-05-19 06:00:00 | AAPL | Stock | 208.1 | 208.14 | 207.82 | 208.0 | 6567.0 |
| 2025-05-19 06:30:00 | AAPL | Stock | 207.97 | 208.33 | 207.97 | 208.22 | 6200.0 |
| 2025-05-19 07:00:00 | AAPL | Stock | 208.2 | 208.4 | 207.99 | 208.0 | 19380.0 |
| 2025-05-19 07:30:00 | AAPL | Stock | 207.97 | 208.16 | 207.82 | 208.13 | 21045.0 |
| 2025-05-19 08:00:00 | AAPL | Stock | 208.16 | 208.36 | 207.35 | 207.85 | 85939.0 |
| 2025-05-19 08:30:00 | AAPL | Stock | 207.8 | 208.17 | 207.73 | 208.0578 | 28654.0 |
| 2025-05-19 09:00:00 | AAPL | Stock | 208.05 | 208.4876 | 207.5 | 208.02 | 120683.0 |
| 2025-05-19 09:30:00 | AAPL | Stock | 207.78 | 208.27 | 204.26 | 205.73 | 7272469.0 |
| 2025-05-19 10:00:00 | AAPL | Stock | 205.72 | 207.48 | 205.67 | 206.6199 | 3379756.0 |
| 2025-05-19 10:30:00 | AAPL | Stock | 206.61 | 207.59 | 206.23 | 207.54 | 2311805.0 |
| 2025-05-19 11:00:00 | AAPL | Stock | 207.55 | 208.04 | 206.965 | 207.33 | 1723300.0 |
| 2025-05-19 11:30:00 | AAPL | Stock | 207.32 | 207.96 | 207.28 | 207.63 | 1010091.0 |
| 2025-05-19 12:00:00 | AAPL | Stock | 207.64 | 208.58 | 207.5801 | 208.4826 | 1266960.0 |
| 2025-05-19 12:30:00 | AAPL | Stock | 208.49 | 208.72 | 208.07 | 208.57 | 1192575.0 |
| 2025-05-19 13:00:00 | AAPL | Stock | 208.57 | 209.48 | 208.56 | 208.93 | 1406012.0 |
| 2025-05-19 13:30:00 | AAPL | Stock | 208.93 | 209.2 | 208.35 | 208.4146 | 1012826.0 |
| 2025-05-19 14:00:00 | AAPL | Stock | 208.415 | 208.47 | 207.78 | 208.03 | 1274889.0 |
| 2025-05-19 14:30:00 | AAPL | Stock | 208.04 | 208.735 | 208.03 | 208.66 | 838629.0 |
| 2025-05-19 15:00:00 | AAPL | Stock | 208.67 | 208.8 | 207.96 | 208.1274 | 1126796.0 |
| 2025-05-19 15:30:00 | AAPL | Stock | 208.12 | 208.93 | 208.1 | 208.76 | 2999228.0 |
| 2025-05-19 16:00:00 | AAPL | Stock | 208.78 | 208.82 | 208.1 | 208.21 | 5452474.0 |
| 2025-05-19 16:30:00 | AAPL | Stock | 208.25 | 208.78 | 208.1 | 208.102 | 31515.0 |
| 2025-05-19 17:00:00 | AAPL | Stock | 208.16 | 208.35 | 208.16 | 208.2 | 9097.0 |
| 2025-05-19 17:30:00 | AAPL | Stock | 208.24 | 208.2974 | 208.16 | 208.19 | 7959.0 |
| 2025-05-19 18:00:00 | AAPL | Stock | 208.16 | 208.35 | 208.16 | 208.318 | 10187.0 |
| 2025-05-19 18:30:00 | AAPL | Stock | 208.26 | 208.337 | 208.2 | 208.2505 | 9679.0 |
| 2025-05-19 19:00:00 | AAPL | Stock | 208.34 | 208.6 | 208.24 | 208.6 | 20854.0 |
| 2025-05-19 19:30:00 | AAPL | Stock | 208.66 | 208.9706 | 208.66 | 208.9 | 18287.0 |
| 2025-05-19 04:00:00 | MSFT | Stock | 448.55 | 449.55 | 445.0 | 448.41 | 5563.0 |
| 2025-05-19 04:30:00 | MSFT | Stock | 447.83 | 449.0 | 447.79 | 448.51 | 1755.0 |
| 2025-05-19 05:00:00 | MSFT | Stock | 448.51 | 449.2 | 448.51 | 449.2 | 2590.0 |
| 2025-05-19 05:30:00 | MSFT | Stock | 449.57 | 449.57 | 449.45 | 449.45 | 1309.0 |
| 2025-05-19 06:00:00 | MSFT | Stock | 449.28 | 449.65 | 449.28 | 449.65 | 300.0 |
| 2025-05-19 06:30:00 | MSFT | Stock | 449.6 | 450.0 | 449.6 | 449.82 | 2960.0 |
| 2025-05-19 07:00:00 | MSFT | Stock | 449.56 | 450.38 | 449.53 | 450.2 | 7933.0 |
| 2025-05-19 07:30:00 | MSFT | Stock | 450.08 | 450.92 | 449.78 | 450.9 | 5945.0 |
| 2025-05-19 08:00:00 | MSFT | Stock | 449.62 | 453.135 | 448.0 | 450.45 | 18677.0 |
| 2025-05-19 08:30:00 | MSFT | Stock | 450.68 | 450.97 | 450.1 | 450.75 | 7007.0 |
| 2025-05-19 09:00:00 | MSFT | Stock | 450.67 | 450.8 | 449.55 | 450.7 | 18697.0 |
| 2025-05-19 09:30:00 | MSFT | Stock | 450.99 | 458.66 | 450.8 | 456.14 | 1980570.0 |
| 2025-05-19 10:00:00 | MSFT | Stock | 456.11 | 457.66 | 455.55 | 455.79 | 731126.0 |
| 2025-05-19 10:30:00 | MSFT | Stock | 455.76 | 457.15 | 455.42 | 456.44 | 424083.0 |
| 2025-05-19 11:00:00 | MSFT | Stock | 456.48 | 457.44 | 456.42 | 456.68 | 450217.0 |
| 2025-05-19 11:30:00 | MSFT | Stock | 456.63 | 457.77 | 456.62 | 457.25 | 320894.0 |
| 2025-05-19 12:00:00 | MSFT | Stock | 457.285 | 458.1 | 456.71 | 458.07 | 378433.0 |
| 2025-05-19 12:30:00 | MSFT | Stock | 458.07 | 458.48 | 457.637 | 458.31 | 414231.0 |
> showing 50 of 104,734 rows — these rows as CSV