PREVIEW / stock_30min / 2024-09-23
file: by_date/stock_30min/2024/2024-09-23.parquet size: 2.1 MB rows: 99,913 symbols: 782
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-23 04:00:00 | AAPL | Stock | 228.4 | 228.48 | 227.37 | 227.75 | 38761.0 |
| 2024-09-23 04:30:00 | AAPL | Stock | 227.69 | 227.7 | 227.35 | 227.7 | 5055.0 |
| 2024-09-23 05:00:00 | AAPL | Stock | 227.71 | 227.87 | 227.55 | 227.59 | 8124.0 |
| 2024-09-23 05:30:00 | AAPL | Stock | 227.6 | 227.98 | 227.55 | 227.98 | 11465.0 |
| 2024-09-23 06:00:00 | AAPL | Stock | 227.87 | 228.37 | 227.8 | 228.3 | 17724.0 |
| 2024-09-23 06:30:00 | AAPL | Stock | 228.32 | 228.34 | 228.2 | 228.2 | 6159.0 |
| 2024-09-23 07:00:00 | AAPL | Stock | 228.05 | 228.2 | 227.81 | 227.89 | 31670.0 |
| 2024-09-23 07:30:00 | AAPL | Stock | 227.98 | 228.44 | 227.93 | 228.27 | 27440.0 |
| 2024-09-23 08:00:00 | AAPL | Stock | 228.125 | 228.66 | 227.27 | 227.9 | 117713.0 |
| 2024-09-23 08:30:00 | AAPL | Stock | 227.89 | 227.9599 | 226.6 | 227.1995 | 155857.0 |
| 2024-09-23 09:00:00 | AAPL | Stock | 227.18 | 227.58 | 226.5 | 227.45 | 280143.0 |
| 2024-09-23 09:30:00 | AAPL | Stock | 227.34 | 227.84 | 225.85 | 226.935 | 6001180.0 |
| 2024-09-23 10:00:00 | AAPL | Stock | 226.935 | 228.07 | 226.29 | 228.01 | 3196883.0 |
| 2024-09-23 10:30:00 | AAPL | Stock | 228.01 | 229.45 | 227.63 | 228.705 | 2742682.0 |
| 2024-09-23 11:00:00 | AAPL | Stock | 228.7001 | 228.88 | 228.26 | 228.6534 | 1495673.0 |
| 2024-09-23 11:30:00 | AAPL | Stock | 228.66 | 228.9 | 228.1 | 228.34 | 1088503.0 |
| 2024-09-23 12:00:00 | AAPL | Stock | 228.3389 | 228.3389 | 226.93 | 226.94 | 1441086.0 |
| 2024-09-23 12:30:00 | AAPL | Stock | 226.94 | 227.41 | 226.66 | 226.7605 | 1144583.0 |
| 2024-09-23 13:00:00 | AAPL | Stock | 226.77 | 227.1399 | 226.6201 | 226.74 | 1267316.0 |
| 2024-09-23 13:30:00 | AAPL | Stock | 226.749 | 227.14 | 226.51 | 227.1 | 1107865.0 |
| 2024-09-23 14:00:00 | AAPL | Stock | 227.08 | 227.18 | 226.61 | 226.68 | 878797.0 |
| 2024-09-23 14:30:00 | AAPL | Stock | 226.69 | 226.77 | 226.485 | 226.68 | 824972.0 |
| 2024-09-23 15:00:00 | AAPL | Stock | 226.68 | 226.705 | 225.9 | 226.29 | 1765984.0 |
| 2024-09-23 15:30:00 | AAPL | Stock | 226.28 | 226.7 | 225.81 | 226.45 | 3281562.0 |
| 2024-09-23 16:00:00 | AAPL | Stock | 226.47 | 226.6 | 226.27 | 226.27 | 8845452.0 |
| 2024-09-23 16:30:00 | AAPL | Stock | 226.31 | 226.47 | 226.29 | 226.29 | 329171.0 |
| 2024-09-23 17:00:00 | AAPL | Stock | 226.3 | 226.47 | 226.2211 | 226.26 | 1480342.0 |
| 2024-09-23 17:30:00 | AAPL | Stock | 226.25 | 226.26 | 226.22 | 226.24 | 2095.0 |
| 2024-09-23 18:00:00 | AAPL | Stock | 226.26 | 226.276 | 226.2 | 226.2 | 7393.0 |
| 2024-09-23 18:30:00 | AAPL | Stock | 226.18 | 226.22 | 226.12 | 226.22 | 6599.0 |
| 2024-09-23 19:00:00 | AAPL | Stock | 226.18 | 226.18 | 226.0 | 226.1 | 8873.0 |
| 2024-09-23 19:30:00 | AAPL | Stock | 226.08 | 226.393 | 226.05 | 226.23 | 7475.0 |
| 2024-09-23 04:00:00 | MSFT | Stock | 436.56 | 436.79 | 436.25 | 436.79 | 1721.0 |
| 2024-09-23 04:30:00 | MSFT | Stock | 436.01 | 436.01 | 435.38 | 436.0 | 2230.0 |
| 2024-09-23 05:00:00 | MSFT | Stock | 436.35 | 436.55 | 435.99 | 436.4 | 3435.0 |
| 2024-09-23 05:30:00 | MSFT | Stock | 436.05 | 436.4 | 435.9 | 436.4 | 1377.0 |
| 2024-09-23 06:00:00 | MSFT | Stock | 436.59 | 436.59 | 431.5 | 432.38 | 34446.0 |
| 2024-09-23 06:30:00 | MSFT | Stock | 432.39 | 433.4 | 432.16 | 432.29 | 4011.0 |
| 2024-09-23 07:00:00 | MSFT | Stock | 432.68 | 433.6 | 432.31 | 432.93 | 29037.0 |
| 2024-09-23 07:30:00 | MSFT | Stock | 433.33 | 434.0 | 433.25 | 433.9 | 7324.0 |
| 2024-09-23 08:00:00 | MSFT | Stock | 434.09 | 437.46 | 432.4 | 434.319 | 33095.0 |
| 2024-09-23 08:30:00 | MSFT | Stock | 433.56 | 434.28 | 433.09 | 433.65 | 30268.0 |
| 2024-09-23 09:00:00 | MSFT | Stock | 433.58 | 434.5365 | 433.05 | 434.5365 | 39554.0 |
| 2024-09-23 09:30:00 | MSFT | Stock | 434.28 | 434.68 | 430.3889 | 432.74 | 1440344.0 |
| 2024-09-23 10:00:00 | MSFT | Stock | 432.72 | 435.0 | 432.21 | 434.52 | 447808.0 |
| 2024-09-23 10:30:00 | MSFT | Stock | 434.555 | 435.9 | 433.8 | 435.27 | 342203.0 |
| 2024-09-23 11:00:00 | MSFT | Stock | 435.27 | 435.595 | 434.2501 | 435.595 | 232325.0 |
| 2024-09-23 11:30:00 | MSFT | Stock | 435.59 | 436.46 | 435.23 | 435.352 | 272805.0 |
| 2024-09-23 12:00:00 | MSFT | Stock | 435.38 | 435.4649 | 434.05 | 434.5401 | 249969.0 |
| 2024-09-23 12:30:00 | MSFT | Stock | 434.62 | 434.73 | 433.05 | 433.24 | 258333.0 |
> showing 50 of 99,913 rows — these rows as CSV