PREVIEW / stock_30min / 2024-12-13
file: by_date/stock_30min/2024/2024-12-13.parquet size: 2.2 MB rows: 104,506 symbols: 667
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-13 04:00:00 | AAPL | Stock | 247.12 | 247.17 | 246.54 | 246.61 | 15615.0 |
| 2024-12-13 04:30:00 | AAPL | Stock | 246.6 | 246.89 | 246.5 | 246.8 | 15205.0 |
| 2024-12-13 05:00:00 | AAPL | Stock | 246.77 | 246.83 | 246.69 | 246.82 | 2636.0 |
| 2024-12-13 05:30:00 | AAPL | Stock | 247.0 | 247.44 | 246.96 | 247.39 | 5476.0 |
| 2024-12-13 06:00:00 | AAPL | Stock | 247.21 | 247.38 | 247.21 | 247.37 | 5182.0 |
| 2024-12-13 06:30:00 | AAPL | Stock | 247.3 | 248.5 | 247.24 | 248.25 | 45827.0 |
| 2024-12-13 07:00:00 | AAPL | Stock | 248.25 | 248.8 | 248.0 | 248.8 | 35929.0 |
| 2024-12-13 07:30:00 | AAPL | Stock | 248.83 | 249.52 | 248.23 | 249.5 | 41384.0 |
| 2024-12-13 08:00:00 | AAPL | Stock | 248.49 | 249.5681 | 246.7 | 249.0 | 99166.0 |
| 2024-12-13 08:30:00 | AAPL | Stock | 249.0 | 249.2773 | 248.6 | 248.88 | 68520.0 |
| 2024-12-13 09:00:00 | AAPL | Stock | 248.71 | 248.8051 | 247.53 | 247.68 | 108627.0 |
| 2024-12-13 09:30:00 | AAPL | Stock | 247.84 | 249.2902 | 247.7 | 248.37 | 2998839.0 |
| 2024-12-13 10:00:00 | AAPL | Stock | 248.37 | 248.39 | 247.35 | 247.55 | 1771172.0 |
| 2024-12-13 10:30:00 | AAPL | Stock | 247.56 | 247.95 | 246.96 | 247.22 | 1373508.0 |
| 2024-12-13 11:00:00 | AAPL | Stock | 247.24 | 247.32 | 246.5 | 246.63 | 1362560.0 |
| 2024-12-13 11:30:00 | AAPL | Stock | 246.62 | 247.03 | 246.41 | 246.715 | 1335889.0 |
| 2024-12-13 12:00:00 | AAPL | Stock | 246.71 | 246.73 | 246.24 | 246.46 | 768028.0 |
| 2024-12-13 12:30:00 | AAPL | Stock | 246.47 | 246.88 | 246.34 | 246.58 | 651918.0 |
| 2024-12-13 13:00:00 | AAPL | Stock | 246.585 | 247.26 | 246.56 | 247.19 | 630322.0 |
| 2024-12-13 13:30:00 | AAPL | Stock | 247.18 | 247.88 | 247.1601 | 247.85 | 886434.0 |
| 2024-12-13 14:00:00 | AAPL | Stock | 247.845 | 248.015 | 247.58 | 247.91 | 803502.0 |
| 2024-12-13 14:30:00 | AAPL | Stock | 247.91 | 248.03 | 247.64 | 247.87 | 681125.0 |
| 2024-12-13 15:00:00 | AAPL | Stock | 247.87 | 248.1 | 247.78 | 248.02 | 886628.0 |
| 2024-12-13 15:30:00 | AAPL | Stock | 248.02 | 248.2987 | 247.89 | 248.11 | 1822298.0 |
| 2024-12-13 16:00:00 | AAPL | Stock | 248.1 | 248.28 | 247.5 | 247.64 | 7623284.0 |
| 2024-12-13 16:30:00 | AAPL | Stock | 247.7487 | 248.13 | 247.5148 | 247.65 | 19845.0 |
| 2024-12-13 17:00:00 | AAPL | Stock | 247.67 | 247.8 | 247.63 | 247.64 | 4741.0 |
| 2024-12-13 17:30:00 | AAPL | Stock | 247.8 | 248.05 | 247.79 | 247.79 | 8962.0 |
| 2024-12-13 18:00:00 | AAPL | Stock | 247.8 | 247.86 | 247.73 | 247.78 | 1557.0 |
| 2024-12-13 18:30:00 | AAPL | Stock | 247.82 | 247.84 | 247.76 | 247.8 | 2199.0 |
| 2024-12-13 19:00:00 | AAPL | Stock | 247.77 | 247.84 | 247.76 | 247.7985 | 2380.0 |
| 2024-12-13 19:30:00 | AAPL | Stock | 247.77 | 248.13 | 247.77 | 248.0 | 10903.0 |
| 2024-12-13 04:00:00 | MSFT | Stock | 448.78 | 450.48 | 448.78 | 450.48 | 6716.0 |
| 2024-12-13 04:30:00 | MSFT | Stock | 450.45 | 450.45 | 449.56 | 449.79 | 2951.0 |
| 2024-12-13 05:00:00 | MSFT | Stock | 450.24 | 450.51 | 450.12 | 450.23 | 2066.0 |
| 2024-12-13 05:30:00 | MSFT | Stock | 450.33 | 450.33 | 450.23 | 450.23 | 328.0 |
| 2024-12-13 06:00:00 | MSFT | Stock | 450.25 | 450.25 | 449.71 | 449.71 | 1237.0 |
| 2024-12-13 06:30:00 | MSFT | Stock | 449.99 | 451.27 | 449.99 | 451.0 | 7840.0 |
| 2024-12-13 07:00:00 | MSFT | Stock | 450.29 | 450.49 | 449.3 | 449.54 | 4054.0 |
| 2024-12-13 07:30:00 | MSFT | Stock | 449.3 | 450.2 | 448.75 | 450.2 | 13622.0 |
| 2024-12-13 08:00:00 | MSFT | Stock | 449.3 | 450.79 | 448.35 | 450.01 | 21677.0 |
| 2024-12-13 08:30:00 | MSFT | Stock | 450.15 | 450.2394 | 448.68 | 448.68 | 10349.0 |
| 2024-12-13 09:00:00 | MSFT | Stock | 448.77 | 449.0 | 447.81 | 447.93 | 21546.0 |
| 2024-12-13 09:30:00 | MSFT | Stock | 447.81 | 451.43 | 447.81 | 449.8 | 1075905.0 |
| 2024-12-13 10:00:00 | MSFT | Stock | 449.9 | 450.1614 | 448.18 | 448.685 | 616272.0 |
| 2024-12-13 10:30:00 | MSFT | Stock | 448.71 | 449.7331 | 447.31 | 447.8417 | 654413.0 |
| 2024-12-13 11:00:00 | MSFT | Stock | 447.79 | 448.63 | 446.82 | 447.11 | 468863.0 |
| 2024-12-13 11:30:00 | MSFT | Stock | 447.135 | 447.86 | 446.4 | 446.955 | 449999.0 |
| 2024-12-13 12:00:00 | MSFT | Stock | 446.95 | 447.1666 | 446.12 | 446.245 | 415622.0 |
| 2024-12-13 12:30:00 | MSFT | Stock | 446.21 | 446.55 | 445.76 | 445.76 | 360489.0 |
> showing 50 of 104,506 rows — these rows as CSV