PREVIEW / stock_30min / 2024-10-31
file: by_date/stock_30min/2024/2024-10-31.parquet size: 2.1 MB rows: 101,527 symbols: 735
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-31 04:00:00 | AAPL | Stock | 230.13 | 230.78 | 229.18 | 229.6 | 13015.0 |
| 2024-10-31 04:30:00 | AAPL | Stock | 229.36 | 229.7 | 229.36 | 229.67 | 4537.0 |
| 2024-10-31 05:00:00 | AAPL | Stock | 229.6 | 229.6 | 229.32 | 229.41 | 4733.0 |
| 2024-10-31 05:30:00 | AAPL | Stock | 229.31 | 229.37 | 229.23 | 229.23 | 2883.0 |
| 2024-10-31 06:00:00 | AAPL | Stock | 229.26 | 229.3 | 229.24 | 229.29 | 1593.0 |
| 2024-10-31 06:30:00 | AAPL | Stock | 229.32 | 229.57 | 229.3 | 229.55 | 5661.0 |
| 2024-10-31 07:00:00 | AAPL | Stock | 229.56 | 229.8 | 229.5 | 229.5 | 18499.0 |
| 2024-10-31 07:30:00 | AAPL | Stock | 229.44 | 229.73 | 229.25 | 229.73 | 19817.0 |
| 2024-10-31 08:00:00 | AAPL | Stock | 229.57 | 230.92 | 229.2 | 230.0401 | 125659.0 |
| 2024-10-31 08:30:00 | AAPL | Stock | 230.01 | 230.4 | 229.81 | 229.92 | 35348.0 |
| 2024-10-31 09:00:00 | AAPL | Stock | 229.88 | 229.92 | 228.82 | 229.5 | 99227.0 |
| 2024-10-31 09:30:00 | AAPL | Stock | 229.51 | 229.83 | 228.1994 | 229.2082 | 3706888.0 |
| 2024-10-31 10:00:00 | AAPL | Stock | 229.2 | 229.26 | 227.81 | 228.445 | 2155476.0 |
| 2024-10-31 10:30:00 | AAPL | Stock | 228.45 | 228.73 | 227.41 | 227.71 | 1722650.0 |
| 2024-10-31 11:00:00 | AAPL | Stock | 227.68 | 227.76 | 226.88 | 227.315 | 2344916.0 |
| 2024-10-31 11:30:00 | AAPL | Stock | 227.31 | 227.395 | 226.4 | 227.055 | 1411044.0 |
| 2024-10-31 12:00:00 | AAPL | Stock | 227.03 | 227.485 | 226.89 | 227.29 | 1261071.0 |
| 2024-10-31 12:30:00 | AAPL | Stock | 227.28 | 227.99 | 227.2 | 227.73 | 1321232.0 |
| 2024-10-31 13:00:00 | AAPL | Stock | 227.735 | 228.18 | 227.4501 | 227.8601 | 1345238.0 |
| 2024-10-31 13:30:00 | AAPL | Stock | 227.86 | 227.9663 | 226.88 | 226.9 | 1615379.0 |
| 2024-10-31 14:00:00 | AAPL | Stock | 226.9 | 227.25 | 226.825 | 227.09 | 1325178.0 |
| 2024-10-31 14:30:00 | AAPL | Stock | 227.095 | 227.22 | 226.695 | 227.07 | 1521597.0 |
| 2024-10-31 15:00:00 | AAPL | Stock | 227.08 | 227.78 | 226.975 | 227.33 | 2260698.0 |
| 2024-10-31 15:30:00 | AAPL | Stock | 227.33 | 227.78 | 225.37 | 225.39 | 5477824.0 |
| 2024-10-31 16:00:00 | AAPL | Stock | 225.39 | 227.88 | 223.86 | 227.5 | 14391363.0 |
| 2024-10-31 16:30:00 | AAPL | Stock | 227.4 | 229.88 | 220.5 | 223.5 | 2507429.0 |
| 2024-10-31 17:00:00 | AAPL | Stock | 223.49 | 225.91 | 220.0 | 221.4 | 1411475.0 |
| 2024-10-31 17:30:00 | AAPL | Stock | 221.4 | 222.0 | 221.0 | 221.26 | 576713.0 |
| 2024-10-31 18:00:00 | AAPL | Stock | 221.395 | 222.49 | 220.8 | 222.4699 | 165717.0 |
| 2024-10-31 18:30:00 | AAPL | Stock | 222.4215 | 222.9 | 222.02 | 222.4 | 124973.0 |
| 2024-10-31 19:00:00 | AAPL | Stock | 222.4 | 222.56 | 222.05 | 222.52 | 36323.0 |
| 2024-10-31 19:30:00 | AAPL | Stock | 222.53 | 222.61 | 221.61 | 221.71 | 80977.0 |
| 2024-10-31 04:00:00 | MSFT | Stock | 414.6 | 418.25 | 413.42 | 417.8 | 42738.0 |
| 2024-10-31 04:30:00 | MSFT | Stock | 417.2 | 417.2 | 414.1 | 416.5 | 41268.0 |
| 2024-10-31 05:00:00 | MSFT | Stock | 416.5 | 417.89 | 416.0 | 417.88 | 6651.0 |
| 2024-10-31 05:30:00 | MSFT | Stock | 417.89 | 417.9 | 415.35 | 415.35 | 19054.0 |
| 2024-10-31 06:00:00 | MSFT | Stock | 415.5 | 415.65 | 415.02 | 415.64 | 16434.0 |
| 2024-10-31 06:30:00 | MSFT | Stock | 415.45 | 417.44 | 415.24 | 416.09 | 33483.0 |
| 2024-10-31 07:00:00 | MSFT | Stock | 416.35 | 417.35 | 415.23 | 416.01 | 79361.0 |
| 2024-10-31 07:30:00 | MSFT | Stock | 416.25 | 418.68 | 416.0 | 418.68 | 67548.0 |
| 2024-10-31 08:00:00 | MSFT | Stock | 416.74 | 419.7 | 413.0 | 418.25 | 256017.0 |
| 2024-10-31 08:30:00 | MSFT | Stock | 418.26 | 418.3843 | 415.85 | 415.99 | 180522.0 |
| 2024-10-31 09:00:00 | MSFT | Stock | 416.0 | 418.0 | 415.0 | 415.02 | 266395.0 |
| 2024-10-31 09:30:00 | MSFT | Stock | 415.01 | 416.16 | 408.24 | 410.83 | 7489078.0 |
| 2024-10-31 10:00:00 | MSFT | Stock | 410.82 | 412.28 | 407.38 | 407.74 | 3104634.0 |
| 2024-10-31 10:30:00 | MSFT | Stock | 407.69 | 407.99 | 406.3 | 407.67 | 2297308.0 |
| 2024-10-31 11:00:00 | MSFT | Stock | 407.71 | 409.15 | 406.55 | 407.93 | 1719576.0 |
| 2024-10-31 11:30:00 | MSFT | Stock | 407.93 | 408.5499 | 406.89 | 408.468 | 1271650.0 |
| 2024-10-31 12:00:00 | MSFT | Stock | 408.44 | 409.38 | 408.0 | 408.9 | 1552868.0 |
| 2024-10-31 12:30:00 | MSFT | Stock | 408.875 | 410.9 | 408.27 | 409.62 | 1470962.0 |
> showing 50 of 101,527 rows — these rows as CSV