PREVIEW / stock_30min / 2024-09-13
file: by_date/stock_30min/2024/2024-09-13.parquet size: 2.0 MB rows: 99,233 symbols: 860
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-09-13 04:00:00 | AAPL | Stock | 222.7 | 223.0 | 222.68 | 222.9 | 4328.0 |
| 2024-09-13 04:30:00 | AAPL | Stock | 222.9 | 223.08 | 222.9 | 222.95 | 2536.0 |
| 2024-09-13 05:00:00 | AAPL | Stock | 223.0 | 223.1 | 223.0 | 223.1 | 3754.0 |
| 2024-09-13 05:30:00 | AAPL | Stock | 223.24 | 223.31 | 223.22 | 223.22 | 813.0 |
| 2024-09-13 06:00:00 | AAPL | Stock | 223.17 | 223.46 | 223.13 | 223.45 | 5410.0 |
| 2024-09-13 06:30:00 | AAPL | Stock | 223.34 | 223.45 | 223.34 | 223.41 | 8039.0 |
| 2024-09-13 07:00:00 | AAPL | Stock | 223.46 | 223.49 | 223.14 | 223.4 | 6759.0 |
| 2024-09-13 07:30:00 | AAPL | Stock | 223.5 | 224.05 | 223.31 | 224.05 | 25728.0 |
| 2024-09-13 08:00:00 | AAPL | Stock | 223.49 | 224.1455 | 222.97 | 224.05 | 55715.0 |
| 2024-09-13 08:30:00 | AAPL | Stock | 224.05 | 224.59 | 224.0 | 224.48 | 84401.0 |
| 2024-09-13 09:00:00 | AAPL | Stock | 224.45 | 224.47 | 223.55 | 223.71 | 136112.0 |
| 2024-09-13 09:30:00 | AAPL | Stock | 223.61 | 223.85 | 222.2412 | 222.52 | 3934465.0 |
| 2024-09-13 10:00:00 | AAPL | Stock | 222.5 | 223.5 | 222.19 | 222.36 | 2696845.0 |
| 2024-09-13 10:30:00 | AAPL | Stock | 222.36 | 223.2 | 221.91 | 223.16 | 1785924.0 |
| 2024-09-13 11:00:00 | AAPL | Stock | 223.18 | 223.75 | 223.1401 | 223.545 | 1657908.0 |
| 2024-09-13 11:30:00 | AAPL | Stock | 223.545 | 223.849 | 223.33 | 223.81 | 1091315.0 |
| 2024-09-13 12:00:00 | AAPL | Stock | 223.8 | 223.99 | 223.055 | 223.3101 | 1001797.0 |
| 2024-09-13 12:30:00 | AAPL | Stock | 223.32 | 223.945 | 223.22 | 223.88 | 836622.0 |
| 2024-09-13 13:00:00 | AAPL | Stock | 223.88 | 224.04 | 223.42 | 223.5838 | 855811.0 |
| 2024-09-13 13:30:00 | AAPL | Stock | 223.58 | 223.806 | 223.32 | 223.69 | 776871.0 |
| 2024-09-13 14:00:00 | AAPL | Stock | 223.7 | 224.02 | 222.85 | 223.0 | 1461889.0 |
| 2024-09-13 14:30:00 | AAPL | Stock | 222.995 | 223.05 | 222.41 | 222.4701 | 1149824.0 |
| 2024-09-13 15:00:00 | AAPL | Stock | 222.47 | 222.75 | 222.3312 | 222.534 | 1123067.0 |
| 2024-09-13 15:30:00 | AAPL | Stock | 222.54 | 222.85 | 222.31 | 222.46 | 3147441.0 |
| 2024-09-13 16:00:00 | AAPL | Stock | 222.5 | 222.5 | 222.2 | 222.37 | 5224268.0 |
| 2024-09-13 16:30:00 | AAPL | Stock | 222.424 | 222.5 | 222.33 | 222.42 | 651559.0 |
| 2024-09-13 17:00:00 | AAPL | Stock | 222.42 | 222.49 | 222.42 | 222.48 | 13583.0 |
| 2024-09-13 17:30:00 | AAPL | Stock | 222.5 | 222.5 | 222.35 | 222.35 | 30741.0 |
| 2024-09-13 18:00:00 | AAPL | Stock | 222.37 | 222.37 | 222.2201 | 222.26 | 10458.0 |
| 2024-09-13 18:30:00 | AAPL | Stock | 222.26 | 222.31 | 222.2565 | 222.31 | 2777.0 |
| 2024-09-13 19:00:00 | AAPL | Stock | 222.27 | 222.28 | 222.18 | 222.23 | 9298.0 |
| 2024-09-13 19:30:00 | AAPL | Stock | 222.1919 | 222.2799 | 222.16 | 222.23 | 14851.0 |
| 2024-09-13 04:00:00 | MSFT | Stock | 426.31 | 427.14 | 426.31 | 426.56 | 3603.0 |
| 2024-09-13 04:30:00 | MSFT | Stock | 426.23 | 426.89 | 426.0 | 426.12 | 1650.0 |
| 2024-09-13 05:00:00 | MSFT | Stock | 426.38 | 426.38 | 426.24 | 426.28 | 1248.0 |
| 2024-09-13 06:30:00 | MSFT | Stock | 426.45 | 426.45 | 426.23 | 426.25 | 622.0 |
| 2024-09-13 07:00:00 | MSFT | Stock | 426.64 | 426.64 | 426.0 | 426.4 | 3271.0 |
| 2024-09-13 07:30:00 | MSFT | Stock | 426.3 | 426.3 | 426.09 | 426.21 | 4264.0 |
| 2024-09-13 08:00:00 | MSFT | Stock | 426.3988 | 427.82 | 426.0043 | 426.49 | 8893.0 |
| 2024-09-13 08:30:00 | MSFT | Stock | 426.36 | 426.8 | 425.6478 | 426.8 | 16299.0 |
| 2024-09-13 09:00:00 | MSFT | Stock | 426.58 | 426.58 | 426.06 | 426.13 | 6010.0 |
| 2024-09-13 09:30:00 | MSFT | Stock | 425.79 | 428.76 | 425.46 | 426.9 | 986874.0 |
| 2024-09-13 10:00:00 | MSFT | Stock | 426.92 | 428.5 | 426.35 | 427.29 | 471483.0 |
| 2024-09-13 10:30:00 | MSFT | Stock | 427.3 | 429.0 | 426.5414 | 428.57 | 598003.0 |
| 2024-09-13 11:00:00 | MSFT | Stock | 428.6 | 429.0 | 428.375 | 428.53 | 339344.0 |
| 2024-09-13 11:30:00 | MSFT | Stock | 428.5308 | 429.18 | 428.1146 | 429.05 | 395714.0 |
| 2024-09-13 12:00:00 | MSFT | Stock | 428.98 | 429.49 | 428.08 | 428.55 | 387383.0 |
| 2024-09-13 12:30:00 | MSFT | Stock | 428.555 | 430.3 | 428.545 | 430.28 | 386466.0 |
| 2024-09-13 13:00:00 | MSFT | Stock | 430.28 | 431.5098 | 430.1675 | 431.29 | 537245.0 |
| 2024-09-13 13:30:00 | MSFT | Stock | 431.29 | 431.83 | 430.54 | 431.21 | 312508.0 |
> showing 50 of 99,233 rows — these rows as CSV