PREVIEW / stock_30min / 2024-01-02
file: by_date/stock_30min/2024/2024-01-02.parquet size: 2.1 MB rows: 102,650 symbols: 1,187
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-01-02 04:00:00 | AAPL | Stock | 191.52 | 191.52 | 189.8 | 190.05 | 34842.0 |
| 2024-01-02 04:30:00 | AAPL | Stock | 190.07 | 190.09 | 189.88 | 189.95 | 11255.0 |
| 2024-01-02 05:00:00 | AAPL | Stock | 190.0 | 190.24 | 190.0 | 190.05 | 7610.0 |
| 2024-01-02 05:30:00 | AAPL | Stock | 190.01 | 190.15 | 189.7 | 189.76 | 10651.0 |
| 2024-01-02 06:00:00 | AAPL | Stock | 189.68 | 189.68 | 188.95 | 188.95 | 62692.0 |
| 2024-01-02 06:30:00 | AAPL | Stock | 188.87 | 189.22 | 188.8 | 188.94 | 18803.0 |
| 2024-01-02 07:00:00 | AAPL | Stock | 189.02 | 189.65 | 189.0 | 189.15 | 51586.0 |
| 2024-01-02 07:30:00 | AAPL | Stock | 189.1 | 189.15 | 188.4 | 188.4 | 55031.0 |
| 2024-01-02 08:00:00 | AAPL | Stock | 189.03 | 192.1 | 187.78 | 187.95 | 277745.0 |
| 2024-01-02 08:30:00 | AAPL | Stock | 187.95 | 192.53 | 187.91 | 188.1 | 117137.0 |
| 2024-01-02 09:00:00 | AAPL | Stock | 188.1 | 188.54 | 187.0 | 187.14 | 412393.0 |
| 2024-01-02 09:30:00 | AAPL | Stock | 187.17 | 188.44 | 186.01 | 186.52 | 11979508.0 |
| 2024-01-02 10:00:00 | AAPL | Stock | 186.52 | 186.97 | 186.07 | 186.1899 | 3899623.0 |
| 2024-01-02 10:30:00 | AAPL | Stock | 186.18 | 186.18 | 185.1843 | 185.89 | 4233756.0 |
| 2024-01-02 11:00:00 | AAPL | Stock | 185.88 | 186.905 | 185.87 | 186.805 | 3167886.0 |
| 2024-01-02 11:30:00 | AAPL | Stock | 186.8 | 187.35 | 186.65 | 186.7443 | 2676219.0 |
| 2024-01-02 12:00:00 | AAPL | Stock | 186.75 | 186.96 | 186.57 | 186.615 | 2434358.0 |
| 2024-01-02 12:30:00 | AAPL | Stock | 186.615 | 187.04 | 185.8401 | 185.878 | 2445566.0 |
| 2024-01-02 13:00:00 | AAPL | Stock | 185.885 | 185.9576 | 185.26 | 185.295 | 2061491.0 |
| 2024-01-02 13:30:00 | AAPL | Stock | 185.29 | 185.54 | 184.745 | 184.9083 | 3168440.0 |
| 2024-01-02 14:00:00 | AAPL | Stock | 184.9025 | 184.98 | 184.23 | 184.495 | 2935409.0 |
| 2024-01-02 14:30:00 | AAPL | Stock | 184.49 | 184.68 | 184.01 | 184.05 | 2752706.0 |
| 2024-01-02 15:00:00 | AAPL | Stock | 184.045 | 184.46 | 183.885 | 184.42 | 3860082.0 |
| 2024-01-02 15:30:00 | AAPL | Stock | 184.42 | 185.64 | 184.415 | 185.525 | 8242977.0 |
| 2024-01-02 16:00:00 | AAPL | Stock | 185.51 | 185.93 | 185.4351 | 185.47 | 10670712.0 |
| 2024-01-02 16:30:00 | AAPL | Stock | 185.47 | 185.64 | 185.42 | 185.43 | 324006.0 |
| 2024-01-02 17:00:00 | AAPL | Stock | 185.43 | 185.51 | 185.3 | 185.36 | 31373.0 |
| 2024-01-02 17:30:00 | AAPL | Stock | 185.35 | 185.64 | 185.35 | 185.57 | 45596.0 |
| 2024-01-02 18:00:00 | AAPL | Stock | 185.58 | 185.6 | 185.34 | 185.36 | 32686.0 |
| 2024-01-02 18:30:00 | AAPL | Stock | 185.37 | 185.37 | 185.22 | 185.3081 | 19415.0 |
| 2024-01-02 19:00:00 | AAPL | Stock | 185.31 | 185.31 | 185.15 | 185.21 | 22128.0 |
| 2024-01-02 19:30:00 | AAPL | Stock | 185.2 | 185.28 | 185.18 | 185.2 | 14042.0 |
| 2024-01-02 04:00:00 | MSFT | Stock | 376.73 | 376.81 | 376.7 | 376.7 | 630.0 |
| 2024-01-02 04:30:00 | MSFT | Stock | 376.29 | 376.29 | 376.29 | 376.29 | 291.0 |
| 2024-01-02 05:00:00 | MSFT | Stock | 376.04 | 376.04 | 375.7 | 375.7 | 300.0 |
| 2024-01-02 05:30:00 | MSFT | Stock | 375.7 | 375.7 | 375.0 | 375.0 | 600.0 |
| 2024-01-02 06:00:00 | MSFT | Stock | 375.08 | 375.11 | 373.6 | 373.6 | 20130.0 |
| 2024-01-02 06:30:00 | MSFT | Stock | 373.6 | 373.65 | 373.0 | 373.25 | 4255.0 |
| 2024-01-02 07:00:00 | MSFT | Stock | 373.31 | 373.83 | 373.3 | 373.79 | 7219.0 |
| 2024-01-02 07:30:00 | MSFT | Stock | 373.79 | 373.79 | 372.7 | 372.71 | 10145.0 |
| 2024-01-02 08:00:00 | MSFT | Stock | 373.53 | 376.66 | 372.71 | 373.25 | 37479.0 |
| 2024-01-02 08:30:00 | MSFT | Stock | 373.27 | 373.982 | 373.24 | 373.3007 | 10610.0 |
| 2024-01-02 09:00:00 | MSFT | Stock | 373.56 | 376.04 | 373.18 | 373.43 | 20327.0 |
| 2024-01-02 09:30:00 | MSFT | Stock | 373.69 | 375.9 | 366.771 | 367.6927 | 2989795.0 |
| 2024-01-02 10:00:00 | MSFT | Stock | 367.695 | 369.05 | 367.57 | 368.3 | 1276911.0 |
| 2024-01-02 10:30:00 | MSFT | Stock | 368.25 | 368.79 | 367.0 | 368.3 | 914075.0 |
| 2024-01-02 11:00:00 | MSFT | Stock | 368.27 | 369.98 | 368.2449 | 369.97 | 715782.0 |
| 2024-01-02 11:30:00 | MSFT | Stock | 369.96 | 371.12 | 369.9 | 370.8826 | 674402.0 |
| 2024-01-02 12:00:00 | MSFT | Stock | 370.92 | 371.36 | 370.2945 | 370.477 | 603792.0 |
| 2024-01-02 12:30:00 | MSFT | Stock | 370.4746 | 371.02 | 369.26 | 369.3528 | 458393.0 |
> showing 50 of 102,650 rows — these rows as CSV