PREVIEW / stock_30min / 2024-09-19
file: by_date/stock_30min/2024/2024-09-19.parquet size: 2.1 MB rows: 102,630 symbols: 802
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-19 04:00:00 | AAPL | Stock | 222.79 | 224.3 | 222.79 | 223.65 | 23534.0 |
| 2024-09-19 04:30:00 | AAPL | Stock | 223.75 | 224.76 | 223.75 | 224.5 | 30662.0 |
| 2024-09-19 05:00:00 | AAPL | Stock | 224.34 | 224.49 | 223.87 | 224.35 | 24261.0 |
| 2024-09-19 05:30:00 | AAPL | Stock | 224.36 | 224.42 | 224.24 | 224.38 | 3474.0 |
| 2024-09-19 06:00:00 | AAPL | Stock | 224.23 | 224.38 | 224.13 | 224.38 | 9443.0 |
| 2024-09-19 06:30:00 | AAPL | Stock | 224.38 | 224.85 | 224.38 | 224.84 | 14780.0 |
| 2024-09-19 07:00:00 | AAPL | Stock | 224.5 | 224.55 | 224.01 | 224.25 | 31468.0 |
| 2024-09-19 07:30:00 | AAPL | Stock | 224.29 | 224.89 | 224.27 | 224.7 | 31479.0 |
| 2024-09-19 08:00:00 | AAPL | Stock | 224.14 | 225.0 | 223.0 | 224.74 | 227204.0 |
| 2024-09-19 08:30:00 | AAPL | Stock | 224.74 | 225.29 | 224.7 | 225.105 | 128052.0 |
| 2024-09-19 09:00:00 | AAPL | Stock | 225.1 | 225.6 | 224.9 | 225.0 | 164259.0 |
| 2024-09-19 09:30:00 | AAPL | Stock | 225.0 | 227.42 | 224.63 | 227.3 | 8300529.0 |
| 2024-09-19 10:00:00 | AAPL | Stock | 227.29 | 229.6 | 227.23 | 229.495 | 5831904.0 |
| 2024-09-19 10:30:00 | AAPL | Stock | 229.49 | 229.82 | 227.7601 | 227.94 | 3770907.0 |
| 2024-09-19 11:00:00 | AAPL | Stock | 227.96 | 228.75 | 227.66 | 228.49 | 2722086.0 |
| 2024-09-19 11:30:00 | AAPL | Stock | 228.4846 | 228.8699 | 228.0 | 228.37 | 1685918.0 |
| 2024-09-19 12:00:00 | AAPL | Stock | 228.37 | 229.18 | 228.28 | 228.995 | 1709394.0 |
| 2024-09-19 12:30:00 | AAPL | Stock | 228.99 | 229.33 | 228.79 | 229.18 | 1509398.0 |
| 2024-09-19 13:00:00 | AAPL | Stock | 229.18 | 229.25 | 228.715 | 229.1701 | 1228982.0 |
| 2024-09-19 13:30:00 | AAPL | Stock | 229.18 | 229.46 | 228.97 | 229.38 | 1573726.0 |
| 2024-09-19 14:00:00 | AAPL | Stock | 229.38 | 229.44 | 228.4 | 228.87 | 1800039.0 |
| 2024-09-19 14:30:00 | AAPL | Stock | 228.87 | 229.3299 | 228.76 | 229.32 | 1480098.0 |
| 2024-09-19 15:00:00 | AAPL | Stock | 229.32 | 229.49 | 228.84 | 229.48 | 2177647.0 |
| 2024-09-19 15:30:00 | AAPL | Stock | 229.46 | 229.59 | 228.28 | 228.81 | 5704992.0 |
| 2024-09-19 16:00:00 | AAPL | Stock | 228.87 | 228.9 | 228.5291 | 228.77 | 10915768.0 |
| 2024-09-19 16:30:00 | AAPL | Stock | 228.78 | 228.87 | 228.58 | 228.58 | 246166.0 |
| 2024-09-19 17:00:00 | AAPL | Stock | 228.6275 | 228.6908 | 228.55 | 228.68 | 10785.0 |
| 2024-09-19 17:30:00 | AAPL | Stock | 228.68 | 228.71 | 228.5374 | 228.6293 | 5811.0 |
| 2024-09-19 18:00:00 | AAPL | Stock | 228.63 | 228.8 | 228.6 | 228.8 | 11470.0 |
| 2024-09-19 18:30:00 | AAPL | Stock | 228.71 | 228.78 | 228.4 | 228.5 | 10303.0 |
| 2024-09-19 19:00:00 | AAPL | Stock | 228.59 | 228.5944 | 228.4218 | 228.45 | 7465.0 |
| 2024-09-19 19:30:00 | AAPL | Stock | 228.5425 | 228.589 | 228.258 | 228.546 | 14420.0 |
| 2024-09-19 04:00:00 | MSFT | Stock | 437.0 | 437.67 | 436.5 | 437.08 | 4810.0 |
| 2024-09-19 04:30:00 | MSFT | Stock | 437.0 | 437.39 | 436.8 | 437.39 | 2847.0 |
| 2024-09-19 05:00:00 | MSFT | Stock | 438.0 | 439.2 | 437.9 | 438.84 | 4756.0 |
| 2024-09-19 05:30:00 | MSFT | Stock | 438.74 | 439.09 | 438.59 | 439.06 | 2294.0 |
| 2024-09-19 06:00:00 | MSFT | Stock | 439.25 | 439.25 | 438.82 | 439.24 | 2186.0 |
| 2024-09-19 06:30:00 | MSFT | Stock | 439.35 | 440.0 | 439.13 | 439.13 | 8186.0 |
| 2024-09-19 07:00:00 | MSFT | Stock | 439.02 | 439.25 | 437.81 | 437.99 | 12948.0 |
| 2024-09-19 07:30:00 | MSFT | Stock | 437.83 | 438.85 | 437.83 | 438.0 | 8947.0 |
| 2024-09-19 08:00:00 | MSFT | Stock | 438.32 | 439.3667 | 430.81 | 437.6932 | 28828.0 |
| 2024-09-19 08:30:00 | MSFT | Stock | 438.0 | 438.26 | 437.6 | 437.6 | 8364.0 |
| 2024-09-19 09:00:00 | MSFT | Stock | 437.6075 | 442.47 | 437.2191 | 441.3603 | 170682.0 |
| 2024-09-19 09:30:00 | MSFT | Stock | 441.27 | 441.5 | 436.9 | 436.97 | 2330229.0 |
| 2024-09-19 10:00:00 | MSFT | Stock | 437.135 | 439.83 | 437.0 | 439.58 | 810959.0 |
| 2024-09-19 10:30:00 | MSFT | Stock | 439.56 | 440.059 | 438.15 | 438.16 | 573369.0 |
| 2024-09-19 11:00:00 | MSFT | Stock | 438.17 | 439.74 | 437.29 | 439.35 | 475171.0 |
| 2024-09-19 11:30:00 | MSFT | Stock | 439.35 | 439.7 | 438.61 | 438.91 | 417329.0 |
| 2024-09-19 12:00:00 | MSFT | Stock | 438.96 | 439.84 | 438.76 | 439.4 | 381669.0 |
| 2024-09-19 12:30:00 | MSFT | Stock | 439.39 | 439.77 | 438.45 | 438.475 | 376418.0 |
> showing 50 of 102,630 rows — these rows as CSV