PREVIEW / stock_30min / 2024-11-06
file: by_date/stock_30min/2024/2024-11-06.parquet size: 2.3 MB rows: 111,965 symbols: 717
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-06 04:00:00 | AAPL | Stock | 226.9 | 226.9 | 224.04 | 224.83 | 35765.0 |
| 2024-11-06 04:30:00 | AAPL | Stock | 224.9 | 225.08 | 223.66 | 224.49 | 31881.0 |
| 2024-11-06 05:00:00 | AAPL | Stock | 224.31 | 224.31 | 223.71 | 223.9 | 22531.0 |
| 2024-11-06 05:30:00 | AAPL | Stock | 223.9 | 224.1 | 223.31 | 223.31 | 47173.0 |
| 2024-11-06 06:00:00 | AAPL | Stock | 223.49 | 223.5 | 223.0 | 223.42 | 23937.0 |
| 2024-11-06 06:30:00 | AAPL | Stock | 223.42 | 223.6 | 222.41 | 223.0 | 51902.0 |
| 2024-11-06 07:00:00 | AAPL | Stock | 223.0 | 224.22 | 223.0 | 224.18 | 111255.0 |
| 2024-11-06 07:30:00 | AAPL | Stock | 224.18 | 224.6 | 224.0 | 224.0 | 65122.0 |
| 2024-11-06 08:00:00 | AAPL | Stock | 224.05 | 228.78 | 222.892 | 224.75 | 253932.0 |
| 2024-11-06 08:30:00 | AAPL | Stock | 224.7482 | 224.75 | 223.8 | 223.95 | 95473.0 |
| 2024-11-06 09:00:00 | AAPL | Stock | 223.81 | 224.05 | 222.3 | 222.5 | 255749.0 |
| 2024-11-06 09:30:00 | AAPL | Stock | 222.58 | 225.64 | 221.19 | 224.45 | 7496016.0 |
| 2024-11-06 10:00:00 | AAPL | Stock | 224.48 | 225.89 | 224.46 | 225.6513 | 3017004.0 |
| 2024-11-06 10:30:00 | AAPL | Stock | 225.66 | 226.065 | 223.94 | 224.21 | 2204980.0 |
| 2024-11-06 11:00:00 | AAPL | Stock | 224.205 | 224.92 | 223.69 | 224.8 | 1915919.0 |
| 2024-11-06 11:30:00 | AAPL | Stock | 224.8024 | 225.185 | 224.66 | 224.67 | 1406287.0 |
| 2024-11-06 12:00:00 | AAPL | Stock | 224.665 | 224.68 | 223.965 | 224.26 | 1759115.0 |
| 2024-11-06 12:30:00 | AAPL | Stock | 224.27 | 224.6 | 224.155 | 224.35 | 1053737.0 |
| 2024-11-06 13:00:00 | AAPL | Stock | 224.35 | 224.56 | 223.99 | 224.1877 | 1120923.0 |
| 2024-11-06 13:30:00 | AAPL | Stock | 224.185 | 224.33 | 223.845 | 223.915 | 896437.0 |
| 2024-11-06 14:00:00 | AAPL | Stock | 223.92 | 224.09 | 223.745 | 223.85 | 1066824.0 |
| 2024-11-06 14:30:00 | AAPL | Stock | 223.86 | 223.97 | 223.26 | 223.4101 | 1417160.0 |
| 2024-11-06 15:00:00 | AAPL | Stock | 223.42 | 224.225 | 223.36 | 223.6255 | 1790629.0 |
| 2024-11-06 15:30:00 | AAPL | Stock | 223.66 | 223.88 | 222.5 | 222.7 | 3780295.0 |
| 2024-11-06 16:00:00 | AAPL | Stock | 222.71 | 223.41 | 222.36 | 223.12 | 9172873.0 |
| 2024-11-06 16:30:00 | AAPL | Stock | 223.12 | 223.3 | 222.72 | 223.17 | 51236.0 |
| 2024-11-06 17:00:00 | AAPL | Stock | 223.08 | 223.5 | 223.05 | 223.4366 | 37357.0 |
| 2024-11-06 17:30:00 | AAPL | Stock | 223.35 | 223.44 | 222.72 | 222.76 | 21976.0 |
| 2024-11-06 18:00:00 | AAPL | Stock | 222.81 | 222.87 | 222.5 | 222.65 | 24440.0 |
| 2024-11-06 18:30:00 | AAPL | Stock | 222.68 | 222.88 | 222.6203 | 222.65 | 9610.0 |
| 2024-11-06 19:00:00 | AAPL | Stock | 222.65 | 222.8125 | 222.65 | 222.68 | 7900.0 |
| 2024-11-06 19:30:00 | AAPL | Stock | 222.65 | 222.6998 | 222.4 | 222.4699 | 15519.0 |
| 2024-11-06 04:00:00 | MSFT | Stock | 415.58 | 416.5 | 415.0 | 415.6 | 15795.0 |
| 2024-11-06 04:30:00 | MSFT | Stock | 415.9 | 417.28 | 415.9 | 417.28 | 10457.0 |
| 2024-11-06 05:00:00 | MSFT | Stock | 417.5 | 417.69 | 416.45 | 416.8 | 7549.0 |
| 2024-11-06 05:30:00 | MSFT | Stock | 417.11 | 417.63 | 416.53 | 416.96 | 11604.0 |
| 2024-11-06 06:00:00 | MSFT | Stock | 416.96 | 417.15 | 416.7 | 416.81 | 5115.0 |
| 2024-11-06 06:30:00 | MSFT | Stock | 417.08 | 417.08 | 415.0 | 415.0 | 12253.0 |
| 2024-11-06 07:00:00 | MSFT | Stock | 415.11 | 416.57 | 415.0 | 416.3 | 25338.0 |
| 2024-11-06 07:30:00 | MSFT | Stock | 416.3 | 418.4 | 416.3 | 417.52 | 27405.0 |
| 2024-11-06 08:00:00 | MSFT | Stock | 415.3 | 418.79 | 411.8 | 418.0 | 90112.0 |
| 2024-11-06 08:30:00 | MSFT | Stock | 417.9972 | 417.9972 | 416.05 | 416.46 | 38156.0 |
| 2024-11-06 09:00:00 | MSFT | Stock | 416.39 | 416.4 | 411.46 | 412.0 | 109302.0 |
| 2024-11-06 09:30:00 | MSFT | Stock | 412.42 | 417.98 | 410.52 | 417.5 | 3465138.0 |
| 2024-11-06 10:00:00 | MSFT | Stock | 417.54 | 419.99 | 417.09 | 419.94 | 1490619.0 |
| 2024-11-06 10:30:00 | MSFT | Stock | 419.91 | 420.39 | 416.15 | 416.2899 | 1021648.0 |
| 2024-11-06 11:00:00 | MSFT | Stock | 416.25 | 417.49 | 415.26 | 415.79 | 895430.0 |
| 2024-11-06 11:30:00 | MSFT | Stock | 415.81 | 416.68 | 415.47 | 416.09 | 553399.0 |
| 2024-11-06 12:00:00 | MSFT | Stock | 416.08 | 416.14 | 414.78 | 415.74 | 529509.0 |
| 2024-11-06 12:30:00 | MSFT | Stock | 415.75 | 416.88 | 415.55 | 416.09 | 446186.0 |
> showing 50 of 111,965 rows — these rows as CSV