PREVIEW / stock_30min / 2024-12-16
file: by_date/stock_30min/2024/2024-12-16.parquet size: 2.3 MB rows: 108,857 symbols: 673
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 |
|---|---|---|---|---|---|---|---|
| 2024-12-16 04:00:00 | AAPL | Stock | 248.23 | 248.9 | 248.23 | 248.34 | 3122.0 |
| 2024-12-16 04:30:00 | AAPL | Stock | 248.42 | 248.5 | 248.42 | 248.5 | 550.0 |
| 2024-12-16 05:00:00 | AAPL | Stock | 248.57 | 248.97 | 248.57 | 248.7 | 3963.0 |
| 2024-12-16 05:30:00 | AAPL | Stock | 248.6 | 248.74 | 248.59 | 248.72 | 3631.0 |
| 2024-12-16 06:00:00 | AAPL | Stock | 248.69 | 248.69 | 248.6 | 248.6 | 619.0 |
| 2024-12-16 06:30:00 | AAPL | Stock | 248.66 | 248.74 | 248.61 | 248.74 | 3698.0 |
| 2024-12-16 07:00:00 | AAPL | Stock | 248.7 | 248.97 | 248.48 | 248.94 | 11760.0 |
| 2024-12-16 07:30:00 | AAPL | Stock | 248.96 | 248.96 | 248.61 | 248.73 | 4869.0 |
| 2024-12-16 08:00:00 | AAPL | Stock | 248.7 | 248.99 | 247.51 | 248.26 | 56755.0 |
| 2024-12-16 08:30:00 | AAPL | Stock | 248.34 | 248.44 | 247.94 | 248.19 | 19970.0 |
| 2024-12-16 09:00:00 | AAPL | Stock | 248.21 | 248.5 | 247.23 | 247.9 | 70537.0 |
| 2024-12-16 09:30:00 | AAPL | Stock | 247.99 | 250.0 | 247.65 | 248.605 | 3677595.0 |
| 2024-12-16 10:00:00 | AAPL | Stock | 248.615 | 249.24 | 248.49 | 249.04 | 1417383.0 |
| 2024-12-16 10:30:00 | AAPL | Stock | 249.03 | 249.49 | 248.82 | 249.31 | 1041091.0 |
| 2024-12-16 11:00:00 | AAPL | Stock | 249.3 | 249.96 | 249.13 | 249.67 | 1298084.0 |
| 2024-12-16 11:30:00 | AAPL | Stock | 249.7 | 250.29 | 249.535 | 250.275 | 2115903.0 |
| 2024-12-16 12:00:00 | AAPL | Stock | 250.275 | 250.3 | 249.7705 | 250.06 | 1008117.0 |
| 2024-12-16 12:30:00 | AAPL | Stock | 250.06 | 251.38 | 250.0526 | 251.2859 | 1686286.0 |
| 2024-12-16 13:00:00 | AAPL | Stock | 251.2863 | 251.2863 | 250.76 | 251.1 | 1042410.0 |
| 2024-12-16 13:30:00 | AAPL | Stock | 251.1 | 251.2472 | 250.58 | 250.86 | 889446.0 |
| 2024-12-16 14:00:00 | AAPL | Stock | 250.86 | 251.21 | 250.73 | 250.8001 | 871382.0 |
| 2024-12-16 14:30:00 | AAPL | Stock | 250.81 | 251.0002 | 250.68 | 250.81 | 1212755.0 |
| 2024-12-16 15:00:00 | AAPL | Stock | 250.81 | 250.82 | 250.21 | 250.695 | 1093967.0 |
| 2024-12-16 15:30:00 | AAPL | Stock | 250.7 | 251.1 | 249.95 | 251.04 | 2809880.0 |
| 2024-12-16 16:00:00 | AAPL | Stock | 251.05 | 251.15 | 250.7065 | 251.07 | 17221557.0 |
| 2024-12-16 16:30:00 | AAPL | Stock | 251.05 | 251.2 | 251.04 | 251.2 | 10097.0 |
| 2024-12-16 17:00:00 | AAPL | Stock | 251.17 | 251.2 | 251.04 | 251.0599 | 39498.0 |
| 2024-12-16 17:30:00 | AAPL | Stock | 251.05 | 251.13 | 251.0432 | 251.07 | 2424.0 |
| 2024-12-16 18:00:00 | AAPL | Stock | 251.08 | 251.08 | 250.62 | 250.75 | 23752.0 |
| 2024-12-16 18:30:00 | AAPL | Stock | 250.8 | 251.0 | 250.75 | 250.87 | 2730.0 |
| 2024-12-16 19:00:00 | AAPL | Stock | 250.81 | 250.9 | 250.8 | 250.9 | 1335.0 |
| 2024-12-16 19:30:00 | AAPL | Stock | 250.87 | 251.04 | 250.84 | 251.0 | 7870.0 |
| 2024-12-16 04:00:00 | MSFT | Stock | 447.27 | 447.85 | 447.27 | 447.4 | 1878.0 |
| 2024-12-16 04:30:00 | MSFT | Stock | 447.49 | 447.49 | 447.49 | 447.49 | 100.0 |
| 2024-12-16 05:00:00 | MSFT | Stock | 447.66 | 447.7 | 447.59 | 447.7 | 1516.0 |
| 2024-12-16 05:30:00 | MSFT | Stock | 447.78 | 448.57 | 447.78 | 448.39 | 1785.0 |
| 2024-12-16 06:00:00 | MSFT | Stock | 448.12 | 448.13 | 448.12 | 448.13 | 200.0 |
| 2024-12-16 06:30:00 | MSFT | Stock | 448.12 | 448.16 | 448.0 | 448.16 | 600.0 |
| 2024-12-16 07:00:00 | MSFT | Stock | 448.08 | 448.15 | 447.61 | 448.15 | 8977.0 |
| 2024-12-16 07:30:00 | MSFT | Stock | 448.19 | 448.57 | 447.9 | 447.91 | 5519.0 |
| 2024-12-16 08:00:00 | MSFT | Stock | 448.0 | 448.5678 | 446.152 | 448.0 | 19021.0 |
| 2024-12-16 08:30:00 | MSFT | Stock | 448.0 | 448.16 | 447.51 | 447.51 | 15673.0 |
| 2024-12-16 09:00:00 | MSFT | Stock | 447.6 | 447.75 | 445.7 | 447.0 | 38912.0 |
| 2024-12-16 09:30:00 | MSFT | Stock | 447.0 | 449.15 | 445.76 | 447.05 | 1820072.0 |
| 2024-12-16 10:00:00 | MSFT | Stock | 447.02 | 447.1 | 445.28 | 446.395 | 707942.0 |
| 2024-12-16 10:30:00 | MSFT | Stock | 446.39 | 447.28 | 445.85 | 447.05 | 479344.0 |
| 2024-12-16 11:00:00 | MSFT | Stock | 447.04 | 448.64 | 446.84 | 448.075 | 580589.0 |
| 2024-12-16 11:30:00 | MSFT | Stock | 448.04 | 448.58 | 447.42 | 448.2597 | 505154.0 |
| 2024-12-16 12:00:00 | MSFT | Stock | 448.3399 | 448.41 | 446.55 | 447.95 | 501643.0 |
| 2024-12-16 12:30:00 | MSFT | Stock | 447.98 | 448.54 | 447.61 | 448.1699 | 393946.0 |
> showing 50 of 108,857 rows — these rows as CSV