PREVIEW / stock_30min / 2025-05-23
file: by_date/stock_30min/2025/2025-05-23.parquet size: 2.1 MB rows: 102,532 symbols: 406
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-23 04:00:00 | AAPL | Stock | 201.74 | 202.0 | 201.61 | 201.92 | 9901.0 |
| 2025-05-23 04:30:00 | AAPL | Stock | 201.86 | 201.88 | 201.66 | 201.7 | 4333.0 |
| 2025-05-23 05:00:00 | AAPL | Stock | 201.67 | 201.7 | 201.02 | 201.02 | 9096.0 |
| 2025-05-23 05:30:00 | AAPL | Stock | 201.02 | 201.65 | 201.0 | 201.48 | 2866.0 |
| 2025-05-23 06:00:00 | AAPL | Stock | 201.5 | 201.57 | 201.27 | 201.29 | 5671.0 |
| 2025-05-23 06:30:00 | AAPL | Stock | 201.33 | 201.54 | 201.2 | 201.4 | 7924.0 |
| 2025-05-23 07:00:00 | AAPL | Stock | 201.42 | 201.58 | 193.23 | 195.18 | 663668.0 |
| 2025-05-23 07:30:00 | AAPL | Stock | 195.17 | 196.78 | 194.3 | 194.8 | 679385.0 |
| 2025-05-23 08:00:00 | AAPL | Stock | 193.68 | 201.7 | 193.13 | 194.9995 | 1181203.0 |
| 2025-05-23 08:30:00 | AAPL | Stock | 194.9994 | 196.02 | 194.15 | 194.87 | 554042.0 |
| 2025-05-23 09:00:00 | AAPL | Stock | 194.9 | 194.9 | 193.2 | 193.6299 | 772972.0 |
| 2025-05-23 09:30:00 | AAPL | Stock | 193.67 | 197.0999 | 193.46 | 196.37 | 12209426.0 |
| 2025-05-23 10:00:00 | AAPL | Stock | 196.34 | 197.7 | 195.985 | 197.17 | 5166689.0 |
| 2025-05-23 10:30:00 | AAPL | Stock | 197.16 | 197.37 | 195.69 | 195.9301 | 3434153.0 |
| 2025-05-23 11:00:00 | AAPL | Stock | 195.94 | 196.6088 | 195.8 | 196.59 | 2391781.0 |
| 2025-05-23 11:30:00 | AAPL | Stock | 196.59 | 197.125 | 195.9801 | 196.2001 | 2342124.0 |
| 2025-05-23 12:00:00 | AAPL | Stock | 196.2 | 196.67 | 195.715 | 196.0502 | 2532824.0 |
| 2025-05-23 12:30:00 | AAPL | Stock | 196.06 | 196.4299 | 195.635 | 196.1 | 2251465.0 |
| 2025-05-23 13:00:00 | AAPL | Stock | 196.1 | 196.6724 | 195.77 | 196.62 | 2478014.0 |
| 2025-05-23 13:30:00 | AAPL | Stock | 196.6 | 196.6 | 195.58 | 195.98 | 2343735.0 |
| 2025-05-23 14:00:00 | AAPL | Stock | 195.97 | 196.53 | 195.0 | 195.74 | 3202511.0 |
| 2025-05-23 14:30:00 | AAPL | Stock | 195.72 | 195.9 | 195.2906 | 195.525 | 1740751.0 |
| 2025-05-23 15:00:00 | AAPL | Stock | 195.52 | 195.9 | 195.03 | 195.4624 | 2520678.0 |
| 2025-05-23 15:30:00 | AAPL | Stock | 195.46 | 195.97 | 195.01 | 195.34 | 6468753.0 |
| 2025-05-23 16:00:00 | AAPL | Stock | 195.27 | 195.7 | 195.18 | 195.5006 | 6321824.0 |
| 2025-05-23 16:30:00 | AAPL | Stock | 195.5 | 195.75 | 195.16 | 195.29 | 90402.0 |
| 2025-05-23 17:00:00 | AAPL | Stock | 195.25 | 195.4 | 195.1 | 195.35 | 33965.0 |
| 2025-05-23 17:30:00 | AAPL | Stock | 195.37 | 195.6 | 195.31 | 195.5 | 23551.0 |
| 2025-05-23 18:00:00 | AAPL | Stock | 195.45 | 195.52 | 195.33 | 195.45 | 14790.0 |
| 2025-05-23 18:30:00 | AAPL | Stock | 195.4399 | 195.5 | 195.36 | 195.4893 | 21468.0 |
| 2025-05-23 19:00:00 | AAPL | Stock | 195.47 | 195.48 | 195.4 | 195.43 | 16341.0 |
| 2025-05-23 19:30:00 | AAPL | Stock | 195.41 | 195.98 | 195.4 | 195.85 | 33155.0 |
| 2025-05-23 04:00:00 | MSFT | Stock | 454.64 | 454.84 | 454.0 | 454.14 | 3021.0 |
| 2025-05-23 04:30:00 | MSFT | Stock | 454.02 | 454.02 | 453.65 | 453.9 | 1100.0 |
| 2025-05-23 05:00:00 | MSFT | Stock | 453.4 | 453.44 | 452.0 | 452.0 | 415.0 |
| 2025-05-23 05:30:00 | MSFT | Stock | 452.28 | 453.04 | 452.28 | 452.86 | 869.0 |
| 2025-05-23 06:00:00 | MSFT | Stock | 453.35 | 453.35 | 453.35 | 453.35 | 122.0 |
| 2025-05-23 06:30:00 | MSFT | Stock | 453.2 | 453.3 | 453.18 | 453.24 | 852.0 |
| 2025-05-23 07:00:00 | MSFT | Stock | 453.56 | 454.0 | 452.5 | 453.7 | 7371.0 |
| 2025-05-23 07:30:00 | MSFT | Stock | 453.74 | 454.1 | 449.02 | 449.5 | 19683.0 |
| 2025-05-23 08:00:00 | MSFT | Stock | 453.95 | 454.23 | 448.5002 | 451.0 | 68393.0 |
| 2025-05-23 08:30:00 | MSFT | Stock | 451.01 | 454.86 | 449.38 | 449.48 | 17829.0 |
| 2025-05-23 09:00:00 | MSFT | Stock | 449.22 | 451.12 | 448.94 | 450.04 | 32371.0 |
| 2025-05-23 09:30:00 | MSFT | Stock | 449.98 | 451.79 | 448.91 | 449.785 | 1474137.0 |
| 2025-05-23 10:00:00 | MSFT | Stock | 449.73 | 452.36 | 449.5001 | 451.41 | 747141.0 |
| 2025-05-23 10:30:00 | MSFT | Stock | 451.42 | 452.03 | 449.935 | 450.315 | 409817.0 |
| 2025-05-23 11:00:00 | MSFT | Stock | 450.37 | 451.0 | 449.9605 | 450.755 | 384959.0 |
| 2025-05-23 11:30:00 | MSFT | Stock | 450.75 | 451.82 | 450.2969 | 450.36 | 361090.0 |
| 2025-05-23 12:00:00 | MSFT | Stock | 450.39 | 451.59 | 450.03 | 451.175 | 384630.0 |
| 2025-05-23 12:30:00 | MSFT | Stock | 451.13 | 452.05 | 450.5458 | 451.37 | 359161.0 |
> showing 50 of 102,532 rows — these rows as CSV