PREVIEW / stock_30min / 2024-11-11
file: by_date/stock_30min/2024/2024-11-11.parquet size: 2.3 MB rows: 108,595 symbols: 726
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-11-11 04:00:00 | AAPL | Stock | 227.21 | 227.26 | 226.0 | 226.58 | 16849.0 |
| 2024-11-11 04:30:00 | AAPL | Stock | 226.7 | 226.85 | 226.45 | 226.45 | 7306.0 |
| 2024-11-11 05:00:00 | AAPL | Stock | 226.43 | 226.44 | 226.34 | 226.34 | 3531.0 |
| 2024-11-11 05:30:00 | AAPL | Stock | 226.33 | 226.43 | 226.21 | 226.21 | 4125.0 |
| 2024-11-11 06:00:00 | AAPL | Stock | 226.18 | 226.2 | 226.1 | 226.1 | 2692.0 |
| 2024-11-11 06:30:00 | AAPL | Stock | 226.2 | 226.22 | 226.2 | 226.22 | 1201.0 |
| 2024-11-11 07:00:00 | AAPL | Stock | 226.3 | 226.4 | 226.2 | 226.23 | 22835.0 |
| 2024-11-11 07:30:00 | AAPL | Stock | 226.22 | 226.3 | 226.02 | 226.22 | 27039.0 |
| 2024-11-11 08:00:00 | AAPL | Stock | 226.3104 | 227.69 | 226.0304 | 226.1 | 109041.0 |
| 2024-11-11 08:30:00 | AAPL | Stock | 226.17 | 226.1757 | 225.75 | 225.9 | 77741.0 |
| 2024-11-11 09:00:00 | AAPL | Stock | 225.9 | 226.06 | 224.98 | 225.02 | 124474.0 |
| 2024-11-11 09:30:00 | AAPL | Stock | 224.99 | 225.7 | 222.77 | 222.9 | 5434345.0 |
| 2024-11-11 10:00:00 | AAPL | Stock | 222.9 | 223.49 | 222.79 | 222.805 | 2377433.0 |
| 2024-11-11 10:30:00 | AAPL | Stock | 222.81 | 223.72 | 222.74 | 222.75 | 2334228.0 |
| 2024-11-11 11:00:00 | AAPL | Stock | 222.755 | 223.35 | 222.67 | 222.77 | 1513498.0 |
| 2024-11-11 11:30:00 | AAPL | Stock | 222.78 | 223.1388 | 222.66 | 222.78 | 1514026.0 |
| 2024-11-11 12:00:00 | AAPL | Stock | 222.78 | 222.88 | 222.01 | 222.195 | 1525913.0 |
| 2024-11-11 12:30:00 | AAPL | Stock | 222.19 | 222.24 | 221.7 | 221.86 | 1552333.0 |
| 2024-11-11 13:00:00 | AAPL | Stock | 221.86 | 222.46 | 221.5 | 222.46 | 1215368.0 |
| 2024-11-11 13:30:00 | AAPL | Stock | 222.45 | 222.99 | 222.36 | 222.9 | 979559.0 |
| 2024-11-11 14:00:00 | AAPL | Stock | 222.9085 | 223.1 | 222.84 | 223.06 | 852627.0 |
| 2024-11-11 14:30:00 | AAPL | Stock | 223.06 | 223.18 | 222.97 | 223.045 | 706796.0 |
| 2024-11-11 15:00:00 | AAPL | Stock | 223.05 | 223.74 | 223.015 | 223.635 | 1113571.0 |
| 2024-11-11 15:30:00 | AAPL | Stock | 223.64 | 224.35 | 223.46 | 224.25 | 2943040.0 |
| 2024-11-11 16:00:00 | AAPL | Stock | 224.23 | 224.5 | 224.12 | 224.2601 | 5008083.0 |
| 2024-11-11 16:30:00 | AAPL | Stock | 224.2801 | 224.3 | 224.23 | 224.25 | 56345.0 |
| 2024-11-11 17:00:00 | AAPL | Stock | 224.25 | 224.3 | 224.21 | 224.21 | 24077.0 |
| 2024-11-11 17:30:00 | AAPL | Stock | 224.1 | 224.1 | 224.0127 | 224.03 | 8523.0 |
| 2024-11-11 18:00:00 | AAPL | Stock | 224.05 | 224.12 | 223.9101 | 223.9101 | 7995.0 |
| 2024-11-11 18:30:00 | AAPL | Stock | 223.95 | 224.1475 | 223.9 | 224.11 | 8069.0 |
| 2024-11-11 19:00:00 | AAPL | Stock | 224.0001 | 224.04 | 223.81 | 223.95 | 6166.0 |
| 2024-11-11 19:30:00 | AAPL | Stock | 223.81 | 223.9 | 223.45 | 223.77 | 19560.0 |
| 2024-11-11 04:00:00 | MSFT | Stock | 423.04 | 423.04 | 422.0 | 422.23 | 5469.0 |
| 2024-11-11 04:30:00 | MSFT | Stock | 422.26 | 422.56 | 422.2 | 422.4 | 4015.0 |
| 2024-11-11 05:00:00 | MSFT | Stock | 422.34 | 422.34 | 421.95 | 422.0 | 6906.0 |
| 2024-11-11 05:30:00 | MSFT | Stock | 421.98 | 422.0 | 421.9 | 421.99 | 619.0 |
| 2024-11-11 06:00:00 | MSFT | Stock | 421.95 | 422.0 | 421.8 | 421.8 | 633.0 |
| 2024-11-11 06:30:00 | MSFT | Stock | 421.89 | 422.02 | 421.83 | 421.99 | 2264.0 |
| 2024-11-11 07:00:00 | MSFT | Stock | 422.13 | 423.08 | 422.02 | 423.08 | 6801.0 |
| 2024-11-11 07:30:00 | MSFT | Stock | 423.15 | 423.34 | 422.9 | 423.25 | 6700.0 |
| 2024-11-11 08:00:00 | MSFT | Stock | 422.1 | 423.8 | 421.8683 | 423.27 | 31126.0 |
| 2024-11-11 08:30:00 | MSFT | Stock | 423.3 | 423.4 | 422.92 | 422.9619 | 10901.0 |
| 2024-11-11 09:00:00 | MSFT | Stock | 423.01 | 423.85 | 422.5 | 422.51 | 22858.0 |
| 2024-11-11 09:30:00 | MSFT | Stock | 422.44 | 424.81 | 421.88 | 422.94 | 1454655.0 |
| 2024-11-11 10:00:00 | MSFT | Stock | 422.99 | 423.155 | 420.22 | 420.34 | 942877.0 |
| 2024-11-11 10:30:00 | MSFT | Stock | 420.35 | 421.189 | 419.3 | 419.31 | 955583.0 |
| 2024-11-11 11:00:00 | MSFT | Stock | 419.34 | 419.41 | 416.0 | 417.14 | 1310107.0 |
| 2024-11-11 11:30:00 | MSFT | Stock | 417.14 | 418.89 | 416.96 | 418.7 | 669816.0 |
| 2024-11-11 12:00:00 | MSFT | Stock | 418.7279 | 419.16 | 418.36 | 418.83 | 353494.0 |
| 2024-11-11 12:30:00 | MSFT | Stock | 418.8 | 418.82 | 417.25 | 417.37 | 384565.0 |
> showing 50 of 108,595 rows — these rows as CSV