PREVIEW / stock_30min / 2025-02-18
file: by_date/stock_30min/2025/2025-02-18.parquet size: 2.3 MB rows: 110,772 symbols: 525
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-02-18 04:00:00 | AAPL | Stock | 245.05 | 245.4 | 244.72 | 244.92 | 12369.0 |
| 2025-02-18 04:30:00 | AAPL | Stock | 244.93 | 244.96 | 244.85 | 244.96 | 4835.0 |
| 2025-02-18 05:00:00 | AAPL | Stock | 244.94 | 244.96 | 244.8 | 244.94 | 4994.0 |
| 2025-02-18 05:30:00 | AAPL | Stock | 244.95 | 244.95 | 244.83 | 244.9 | 885.0 |
| 2025-02-18 06:00:00 | AAPL | Stock | 244.96 | 245.16 | 244.96 | 245.0 | 5739.0 |
| 2025-02-18 06:30:00 | AAPL | Stock | 245.0 | 245.0 | 244.68 | 244.68 | 8297.0 |
| 2025-02-18 07:00:00 | AAPL | Stock | 244.66 | 244.93 | 244.66 | 244.81 | 13320.0 |
| 2025-02-18 07:30:00 | AAPL | Stock | 244.75 | 244.99 | 244.75 | 244.98 | 18965.0 |
| 2025-02-18 08:00:00 | AAPL | Stock | 244.8 | 245.51 | 244.6 | 244.62 | 54423.0 |
| 2025-02-18 08:30:00 | AAPL | Stock | 244.62 | 244.84 | 244.21 | 244.7 | 49141.0 |
| 2025-02-18 09:00:00 | AAPL | Stock | 244.7 | 244.83 | 243.0 | 244.05 | 134390.0 |
| 2025-02-18 09:30:00 | AAPL | Stock | 244.15 | 245.18 | 242.8601 | 244.93 | 5408391.0 |
| 2025-02-18 10:00:00 | AAPL | Stock | 244.984 | 245.0972 | 243.86 | 244.0905 | 1630518.0 |
| 2025-02-18 10:30:00 | AAPL | Stock | 244.095 | 244.69 | 243.94 | 244.33 | 1324274.0 |
| 2025-02-18 11:00:00 | AAPL | Stock | 244.33 | 244.9699 | 244.22 | 244.725 | 1041235.0 |
| 2025-02-18 11:30:00 | AAPL | Stock | 244.72 | 245.05 | 244.35 | 244.89 | 1255598.0 |
| 2025-02-18 12:00:00 | AAPL | Stock | 244.895 | 244.95 | 244.173 | 244.43 | 816617.0 |
| 2025-02-18 12:30:00 | AAPL | Stock | 244.45 | 244.5 | 243.93 | 243.975 | 870253.0 |
| 2025-02-18 13:00:00 | AAPL | Stock | 243.97 | 244.1155 | 243.25 | 243.435 | 906855.0 |
| 2025-02-18 13:30:00 | AAPL | Stock | 243.43 | 243.4833 | 242.3101 | 242.62 | 1333285.0 |
| 2025-02-18 14:00:00 | AAPL | Stock | 242.61 | 243.09 | 241.84 | 243.05 | 1239350.0 |
| 2025-02-18 14:30:00 | AAPL | Stock | 243.055 | 243.835 | 242.975 | 243.695 | 932010.0 |
| 2025-02-18 15:00:00 | AAPL | Stock | 243.6989 | 243.835 | 243.45 | 243.52 | 914222.0 |
| 2025-02-18 15:30:00 | AAPL | Stock | 243.53 | 244.6 | 243.15 | 244.46 | 3861567.0 |
| 2025-02-18 16:00:00 | AAPL | Stock | 244.47 | 244.66 | 244.11 | 244.66 | 8398281.0 |
| 2025-02-18 16:30:00 | AAPL | Stock | 244.57 | 244.74 | 244.43 | 244.53 | 29175.0 |
| 2025-02-18 17:00:00 | AAPL | Stock | 244.56 | 244.79 | 244.53 | 244.65 | 6294.0 |
| 2025-02-18 17:30:00 | AAPL | Stock | 244.69 | 244.7 | 244.56 | 244.58 | 3857.0 |
| 2025-02-18 18:00:00 | AAPL | Stock | 244.65 | 244.99 | 244.65 | 244.76 | 12189.0 |
| 2025-02-18 18:30:00 | AAPL | Stock | 244.75 | 244.95 | 244.7 | 244.9486 | 6432.0 |
| 2025-02-18 19:00:00 | AAPL | Stock | 244.9 | 245.0 | 244.82 | 244.96 | 6372.0 |
| 2025-02-18 19:30:00 | AAPL | Stock | 244.98 | 245.4091 | 244.94 | 245.37 | 22534.0 |
| 2025-02-18 04:00:00 | MSFT | Stock | 410.33 | 410.33 | 409.3 | 409.8 | 3483.0 |
| 2025-02-18 04:30:00 | MSFT | Stock | 409.59 | 409.79 | 409.52 | 409.7 | 1125.0 |
| 2025-02-18 05:00:00 | MSFT | Stock | 409.65 | 409.7 | 409.5 | 409.66 | 2067.0 |
| 2025-02-18 05:30:00 | MSFT | Stock | 409.64 | 409.92 | 409.64 | 409.74 | 1465.0 |
| 2025-02-18 06:00:00 | MSFT | Stock | 409.71 | 409.8 | 409.65 | 409.75 | 2763.0 |
| 2025-02-18 06:30:00 | MSFT | Stock | 409.8 | 410.0 | 409.8 | 409.94 | 2100.0 |
| 2025-02-18 07:00:00 | MSFT | Stock | 409.68 | 410.0 | 409.47 | 409.65 | 11467.0 |
| 2025-02-18 07:30:00 | MSFT | Stock | 409.7 | 409.72 | 409.5 | 409.55 | 6381.0 |
| 2025-02-18 08:00:00 | MSFT | Stock | 409.5 | 410.25 | 407.409 | 409.59 | 34169.0 |
| 2025-02-18 08:30:00 | MSFT | Stock | 409.56 | 409.97 | 409.56 | 409.88 | 7020.0 |
| 2025-02-18 09:00:00 | MSFT | Stock | 409.88 | 409.91 | 407.15 | 408.06 | 89399.0 |
| 2025-02-18 09:30:00 | MSFT | Stock | 408.0 | 410.597 | 407.73 | 409.815 | 1936569.0 |
| 2025-02-18 10:00:00 | MSFT | Stock | 409.86 | 410.3699 | 408.0 | 408.0503 | 900453.0 |
| 2025-02-18 10:30:00 | MSFT | Stock | 408.05 | 409.2829 | 407.79 | 409.0934 | 542153.0 |
| 2025-02-18 11:00:00 | MSFT | Stock | 409.05 | 409.26 | 408.21 | 408.97 | 464626.0 |
| 2025-02-18 11:30:00 | MSFT | Stock | 408.97 | 409.45 | 408.27 | 408.8994 | 370143.0 |
| 2025-02-18 12:00:00 | MSFT | Stock | 408.87 | 409.09 | 408.18 | 408.335 | 387319.0 |
| 2025-02-18 12:30:00 | MSFT | Stock | 408.34 | 408.96 | 408.31 | 408.565 | 248162.0 |
> showing 50 of 110,772 rows — these rows as CSV