PREVIEW / stock_30min / 2024-10-09
file: by_date/stock_30min/2024/2024-10-09.parquet size: 2.1 MB rows: 97,807 symbols: 762
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-10-09 04:00:00 | AAPL | Stock | 225.12 | 225.12 | 224.5 | 224.56 | 3076.0 |
| 2024-10-09 04:30:00 | AAPL | Stock | 224.45 | 224.72 | 224.45 | 224.72 | 920.0 |
| 2024-10-09 05:00:00 | AAPL | Stock | 224.83 | 224.89 | 224.82 | 224.89 | 853.0 |
| 2024-10-09 05:30:00 | AAPL | Stock | 225.0 | 225.26 | 225.0 | 225.13 | 2741.0 |
| 2024-10-09 06:00:00 | AAPL | Stock | 224.99 | 225.15 | 224.93 | 225.15 | 2075.0 |
| 2024-10-09 06:30:00 | AAPL | Stock | 225.15 | 225.17 | 225.0 | 225.0 | 2497.0 |
| 2024-10-09 07:00:00 | AAPL | Stock | 225.14 | 225.37 | 225.1 | 225.27 | 8455.0 |
| 2024-10-09 07:30:00 | AAPL | Stock | 225.29 | 225.69 | 225.25 | 225.5 | 18004.0 |
| 2024-10-09 08:00:00 | AAPL | Stock | 225.3 | 225.73 | 224.7726 | 225.3 | 35467.0 |
| 2024-10-09 08:30:00 | AAPL | Stock | 225.2754 | 225.72 | 225.25 | 225.65 | 22532.0 |
| 2024-10-09 09:00:00 | AAPL | Stock | 225.59 | 225.9 | 225.1091 | 225.28 | 33063.0 |
| 2024-10-09 09:30:00 | AAPL | Stock | 225.31 | 226.485 | 224.83 | 226.15 | 2807192.0 |
| 2024-10-09 10:00:00 | AAPL | Stock | 226.15 | 227.17 | 225.82 | 227.1 | 2476443.0 |
| 2024-10-09 10:30:00 | AAPL | Stock | 227.1 | 227.8 | 226.97 | 227.65 | 1714222.0 |
| 2024-10-09 11:00:00 | AAPL | Stock | 227.66 | 228.29 | 227.64 | 228.19 | 1577447.0 |
| 2024-10-09 11:30:00 | AAPL | Stock | 228.21 | 228.63 | 228.1 | 228.4245 | 1330670.0 |
| 2024-10-09 12:00:00 | AAPL | Stock | 228.425 | 228.71 | 228.082 | 228.71 | 955483.0 |
| 2024-10-09 12:30:00 | AAPL | Stock | 228.72 | 229.0399 | 228.52 | 228.65 | 1156941.0 |
| 2024-10-09 13:00:00 | AAPL | Stock | 228.64 | 228.99 | 228.56 | 228.86 | 565623.0 |
| 2024-10-09 13:30:00 | AAPL | Stock | 228.84 | 229.0 | 228.02 | 228.5032 | 841531.0 |
| 2024-10-09 14:00:00 | AAPL | Stock | 228.51 | 229.67 | 228.41 | 229.635 | 1200040.0 |
| 2024-10-09 14:30:00 | AAPL | Stock | 229.63 | 229.63 | 229.01 | 229.3 | 1251587.0 |
| 2024-10-09 15:00:00 | AAPL | Stock | 229.31 | 229.32 | 228.8 | 229.0742 | 1268095.0 |
| 2024-10-09 15:30:00 | AAPL | Stock | 229.07 | 229.75 | 229.06 | 229.49 | 2355601.0 |
| 2024-10-09 16:00:00 | AAPL | Stock | 229.51 | 229.55 | 229.05 | 229.1285 | 5260579.0 |
| 2024-10-09 16:30:00 | AAPL | Stock | 229.1 | 229.54 | 229.08 | 229.18 | 28832.0 |
| 2024-10-09 17:00:00 | AAPL | Stock | 229.22 | 229.54 | 229.1523 | 229.17 | 71256.0 |
| 2024-10-09 17:30:00 | AAPL | Stock | 229.1775 | 229.2 | 229.12 | 229.14 | 2546.0 |
| 2024-10-09 18:00:00 | AAPL | Stock | 229.19 | 229.23 | 229.13 | 229.228 | 11484.0 |
| 2024-10-09 18:30:00 | AAPL | Stock | 229.19 | 229.2063 | 229.12 | 229.1503 | 4580.0 |
| 2024-10-09 19:00:00 | AAPL | Stock | 229.14 | 229.4 | 229.135 | 229.39 | 9928.0 |
| 2024-10-09 19:30:00 | AAPL | Stock | 229.36 | 229.4 | 229.2523 | 229.3961 | 9277.0 |
| 2024-10-09 04:00:00 | MSFT | Stock | 414.74 | 414.86 | 414.74 | 414.74 | 807.0 |
| 2024-10-09 04:30:00 | MSFT | Stock | 414.89 | 415.5 | 414.89 | 415.4 | 1012.0 |
| 2024-10-09 05:00:00 | MSFT | Stock | 415.48 | 415.59 | 415.42 | 415.5 | 1172.0 |
| 2024-10-09 05:30:00 | MSFT | Stock | 415.59 | 415.59 | 415.45 | 415.5 | 2414.0 |
| 2024-10-09 06:00:00 | MSFT | Stock | 415.8 | 416.02 | 415.8 | 415.85 | 1974.0 |
| 2024-10-09 06:30:00 | MSFT | Stock | 416.08 | 417.48 | 416.08 | 416.7 | 4314.0 |
| 2024-10-09 07:00:00 | MSFT | Stock | 416.7 | 416.7 | 415.54 | 415.84 | 5702.0 |
| 2024-10-09 07:30:00 | MSFT | Stock | 415.841 | 415.841 | 415.51 | 415.52 | 2417.0 |
| 2024-10-09 08:00:00 | MSFT | Stock | 416.71 | 416.71 | 414.21 | 415.81 | 26468.0 |
| 2024-10-09 08:30:00 | MSFT | Stock | 415.75 | 415.79 | 414.71 | 415.456 | 14666.0 |
| 2024-10-09 09:00:00 | MSFT | Stock | 415.333 | 416.6 | 415.333 | 416.08 | 14586.0 |
| 2024-10-09 09:30:00 | MSFT | Stock | 416.0 | 416.7899 | 414.3 | 415.45 | 1092793.0 |
| 2024-10-09 10:00:00 | MSFT | Stock | 415.465 | 417.5 | 415.45 | 416.7899 | 976138.0 |
| 2024-10-09 10:30:00 | MSFT | Stock | 416.7301 | 418.17 | 416.53 | 418.17 | 637786.0 |
| 2024-10-09 11:00:00 | MSFT | Stock | 418.13 | 419.65 | 418.07 | 419.14 | 609899.0 |
| 2024-10-09 11:30:00 | MSFT | Stock | 419.21 | 420.38 | 418.94 | 419.81 | 671951.0 |
| 2024-10-09 12:00:00 | MSFT | Stock | 419.85 | 419.85 | 417.87 | 418.5901 | 566328.0 |
| 2024-10-09 12:30:00 | MSFT | Stock | 418.65 | 418.8499 | 417.76 | 417.92 | 481506.0 |
> showing 50 of 97,807 rows — these rows as CSV