PREVIEW / stock_30min / 2024-12-17
file: by_date/stock_30min/2024/2024-12-17.parquet size: 2.2 MB rows: 108,230 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-17 04:00:00 | AAPL | Stock | 250.29 | 250.33 | 250.06 | 250.25 | 4335.0 |
| 2024-12-17 04:30:00 | AAPL | Stock | 250.44 | 250.53 | 250.4 | 250.47 | 2554.0 |
| 2024-12-17 05:00:00 | AAPL | Stock | 250.46 | 250.58 | 250.42 | 250.58 | 3739.0 |
| 2024-12-17 05:30:00 | AAPL | Stock | 250.55 | 250.55 | 250.44 | 250.46 | 3734.0 |
| 2024-12-17 06:00:00 | AAPL | Stock | 250.42 | 250.52 | 250.36 | 250.52 | 1967.0 |
| 2024-12-17 06:30:00 | AAPL | Stock | 250.39 | 250.47 | 250.14 | 250.14 | 1933.0 |
| 2024-12-17 07:00:00 | AAPL | Stock | 250.16 | 250.35 | 250.14 | 250.15 | 2684.0 |
| 2024-12-17 07:30:00 | AAPL | Stock | 250.14 | 250.24 | 250.1 | 250.16 | 5127.0 |
| 2024-12-17 08:00:00 | AAPL | Stock | 250.28 | 251.13 | 250.04 | 250.1379 | 45182.0 |
| 2024-12-17 08:30:00 | AAPL | Stock | 250.1 | 250.4999 | 250.06 | 250.4999 | 29751.0 |
| 2024-12-17 09:00:00 | AAPL | Stock | 250.5 | 250.65 | 249.65 | 250.18 | 92715.0 |
| 2024-12-17 09:30:00 | AAPL | Stock | 250.08 | 252.98 | 249.78 | 252.04 | 4153571.0 |
| 2024-12-17 10:00:00 | AAPL | Stock | 252.04 | 252.59 | 251.81 | 252.26 | 1959130.0 |
| 2024-12-17 10:30:00 | AAPL | Stock | 252.25 | 252.68 | 251.77 | 252.36 | 1308839.0 |
| 2024-12-17 11:00:00 | AAPL | Stock | 252.365 | 253.35 | 252.24 | 252.55 | 1980252.0 |
| 2024-12-17 11:30:00 | AAPL | Stock | 252.53 | 253.1 | 252.48 | 253.075 | 1160042.0 |
| 2024-12-17 12:00:00 | AAPL | Stock | 253.08 | 253.3 | 252.585 | 253.24 | 1369251.0 |
| 2024-12-17 12:30:00 | AAPL | Stock | 253.24 | 253.29 | 252.795 | 252.915 | 1013315.0 |
| 2024-12-17 13:00:00 | AAPL | Stock | 252.9 | 253.19 | 252.6901 | 253.13 | 972560.0 |
| 2024-12-17 13:30:00 | AAPL | Stock | 253.14 | 253.635 | 253.09 | 253.335 | 1256337.0 |
| 2024-12-17 14:00:00 | AAPL | Stock | 253.3301 | 253.4 | 252.93 | 253.205 | 809115.0 |
| 2024-12-17 14:30:00 | AAPL | Stock | 253.2 | 253.39 | 252.92 | 253.24 | 1022580.0 |
| 2024-12-17 15:00:00 | AAPL | Stock | 253.24 | 253.29 | 252.75 | 252.88 | 1185289.0 |
| 2024-12-17 15:30:00 | AAPL | Stock | 252.88 | 253.83 | 252.65 | 253.48 | 5073585.0 |
| 2024-12-17 16:00:00 | AAPL | Stock | 253.45 | 253.62 | 253.22 | 253.51 | 16067140.0 |
| 2024-12-17 16:30:00 | AAPL | Stock | 253.52 | 253.5602 | 253.3 | 253.36 | 64852.0 |
| 2024-12-17 17:00:00 | AAPL | Stock | 253.36 | 253.36 | 253.31 | 253.36 | 4431.0 |
| 2024-12-17 17:30:00 | AAPL | Stock | 253.36 | 253.36 | 253.2997 | 253.36 | 2449.0 |
| 2024-12-17 18:00:00 | AAPL | Stock | 253.3 | 253.3 | 252.15 | 253.1 | 22350.0 |
| 2024-12-17 18:30:00 | AAPL | Stock | 253.11 | 253.2355 | 253.08 | 253.1 | 1771.0 |
| 2024-12-17 19:00:00 | AAPL | Stock | 253.22 | 253.3699 | 253.06 | 253.3 | 5185.0 |
| 2024-12-17 19:30:00 | AAPL | Stock | 253.27 | 253.39 | 253.12 | 253.39 | 6591.0 |
| 2024-12-17 04:00:00 | MSFT | Stock | 450.32 | 450.33 | 450.32 | 450.33 | 323.0 |
| 2024-12-17 04:30:00 | MSFT | Stock | 450.03 | 450.05 | 449.85 | 450.0 | 2097.0 |
| 2024-12-17 05:00:00 | MSFT | Stock | 450.16 | 450.19 | 450.0 | 450.0 | 650.0 |
| 2024-12-17 05:30:00 | MSFT | Stock | 450.04 | 450.26 | 450.04 | 450.22 | 565.0 |
| 2024-12-17 06:00:00 | MSFT | Stock | 450.04 | 450.09 | 450.0 | 450.09 | 4799.0 |
| 2024-12-17 06:30:00 | MSFT | Stock | 450.4 | 450.54 | 450.0 | 450.01 | 636.0 |
| 2024-12-17 07:00:00 | MSFT | Stock | 449.69 | 450.15 | 449.5 | 450.15 | 4643.0 |
| 2024-12-17 07:30:00 | MSFT | Stock | 450.39 | 450.39 | 450.0 | 450.0 | 1084.0 |
| 2024-12-17 08:00:00 | MSFT | Stock | 449.99 | 451.29 | 449.6 | 450.2325 | 20723.0 |
| 2024-12-17 08:30:00 | MSFT | Stock | 450.48 | 450.64 | 450.1852 | 450.36 | 5339.0 |
| 2024-12-17 09:00:00 | MSFT | Stock | 450.3 | 451.0 | 449.7 | 450.65 | 14237.0 |
| 2024-12-17 09:30:00 | MSFT | Stock | 451.02 | 452.8 | 449.8 | 450.57 | 1248095.0 |
| 2024-12-17 10:00:00 | MSFT | Stock | 450.57 | 452.1 | 449.57 | 451.79 | 737580.0 |
| 2024-12-17 10:30:00 | MSFT | Stock | 451.82 | 453.16 | 451.2808 | 453.0 | 647813.0 |
| 2024-12-17 11:00:00 | MSFT | Stock | 453.04 | 454.7264 | 452.58 | 453.615 | 725048.0 |
| 2024-12-17 11:30:00 | MSFT | Stock | 453.56 | 455.28 | 453.51 | 455.01 | 546521.0 |
| 2024-12-17 12:00:00 | MSFT | Stock | 455.015 | 455.015 | 453.75 | 454.355 | 289424.0 |
| 2024-12-17 12:30:00 | MSFT | Stock | 454.46 | 454.89 | 453.4201 | 453.66 | 286745.0 |
> showing 50 of 108,230 rows — these rows as CSV