PREVIEW / stock_30min / 2024-11-05
file: by_date/stock_30min/2024/2024-11-05.parquet size: 2.1 MB rows: 101,059 symbols: 732
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-05 04:00:00 | AAPL | Stock | 221.9 | 221.9 | 221.3 | 221.66 | 5940.0 |
| 2024-11-05 04:30:00 | AAPL | Stock | 221.6 | 221.66 | 221.55 | 221.6 | 2823.0 |
| 2024-11-05 05:00:00 | AAPL | Stock | 221.6 | 221.66 | 221.13 | 221.5 | 4533.0 |
| 2024-11-05 05:30:00 | AAPL | Stock | 221.59 | 221.6 | 221.5 | 221.55 | 2000.0 |
| 2024-11-05 06:00:00 | AAPL | Stock | 221.72 | 221.84 | 221.72 | 221.75 | 1227.0 |
| 2024-11-05 06:30:00 | AAPL | Stock | 221.82 | 222.3 | 221.81 | 221.97 | 5948.0 |
| 2024-11-05 07:00:00 | AAPL | Stock | 221.98 | 222.15 | 221.38 | 221.38 | 9105.0 |
| 2024-11-05 07:30:00 | AAPL | Stock | 221.52 | 221.53 | 221.35 | 221.52 | 2460.0 |
| 2024-11-05 08:00:00 | AAPL | Stock | 221.93 | 222.1 | 220.4 | 221.8 | 42344.0 |
| 2024-11-05 08:30:00 | AAPL | Stock | 221.8 | 221.95 | 221.75 | 221.8887 | 26366.0 |
| 2024-11-05 09:00:00 | AAPL | Stock | 221.81 | 222.0 | 221.1 | 221.77 | 56490.0 |
| 2024-11-05 09:30:00 | AAPL | Stock | 221.795 | 223.95 | 221.14 | 223.545 | 3204309.0 |
| 2024-11-05 10:00:00 | AAPL | Stock | 223.56 | 223.8452 | 223.18 | 223.3191 | 1377187.0 |
| 2024-11-05 10:30:00 | AAPL | Stock | 223.33 | 223.48 | 222.06 | 222.195 | 1632906.0 |
| 2024-11-05 11:00:00 | AAPL | Stock | 222.19 | 223.06 | 221.93 | 222.67 | 1228413.0 |
| 2024-11-05 11:30:00 | AAPL | Stock | 222.68 | 223.33 | 222.68 | 223.23 | 745145.0 |
| 2024-11-05 12:00:00 | AAPL | Stock | 223.25 | 223.75 | 223.15 | 223.38 | 770462.0 |
| 2024-11-05 12:30:00 | AAPL | Stock | 223.4 | 223.78 | 223.38 | 223.49 | 579618.0 |
| 2024-11-05 13:00:00 | AAPL | Stock | 223.495 | 223.51 | 222.62 | 222.62 | 865732.0 |
| 2024-11-05 13:30:00 | AAPL | Stock | 222.63 | 223.0199 | 222.4002 | 222.85 | 844988.0 |
| 2024-11-05 14:00:00 | AAPL | Stock | 222.86 | 223.45 | 222.8316 | 223.3301 | 765731.0 |
| 2024-11-05 14:30:00 | AAPL | Stock | 223.34 | 223.4471 | 222.81 | 222.9399 | 694960.0 |
| 2024-11-05 15:00:00 | AAPL | Stock | 222.93 | 223.29 | 222.8201 | 223.25 | 701627.0 |
| 2024-11-05 15:30:00 | AAPL | Stock | 223.25 | 223.53 | 222.71 | 223.46 | 2495089.0 |
| 2024-11-05 16:00:00 | AAPL | Stock | 223.44 | 223.59 | 223.2 | 223.3 | 5027972.0 |
| 2024-11-05 16:30:00 | AAPL | Stock | 223.271 | 223.45 | 223.01 | 223.1766 | 28953.0 |
| 2024-11-05 17:00:00 | AAPL | Stock | 223.29 | 223.45 | 223.06 | 223.06 | 30635.0 |
| 2024-11-05 17:30:00 | AAPL | Stock | 223.0766 | 223.1128 | 223.0201 | 223.06 | 11317.0 |
| 2024-11-05 18:00:00 | AAPL | Stock | 223.04 | 223.12 | 222.9105 | 223.0003 | 8946.0 |
| 2024-11-05 18:30:00 | AAPL | Stock | 223.05 | 223.12 | 222.96 | 222.96 | 7754.0 |
| 2024-11-05 19:00:00 | AAPL | Stock | 222.98 | 222.99 | 222.45 | 222.45 | 17666.0 |
| 2024-11-05 19:30:00 | AAPL | Stock | 222.449 | 223.1642 | 222.24 | 223.15 | 19095.0 |
| 2024-11-05 04:00:00 | MSFT | Stock | 409.5 | 410.09 | 409.49 | 410.09 | 897.0 |
| 2024-11-05 04:30:00 | MSFT | Stock | 409.8 | 409.8 | 409.65 | 409.74 | 709.0 |
| 2024-11-05 05:00:00 | MSFT | Stock | 409.5 | 409.5 | 409.5 | 409.5 | 134.0 |
| 2024-11-05 05:30:00 | MSFT | Stock | 409.71 | 409.71 | 409.71 | 409.71 | 122.0 |
| 2024-11-05 06:00:00 | MSFT | Stock | 409.8 | 409.95 | 409.7 | 409.95 | 1809.0 |
| 2024-11-05 06:30:00 | MSFT | Stock | 409.81 | 410.0 | 409.81 | 409.95 | 645.0 |
| 2024-11-05 07:00:00 | MSFT | Stock | 409.92 | 410.0 | 409.2 | 409.25 | 6930.0 |
| 2024-11-05 07:30:00 | MSFT | Stock | 409.25 | 409.44 | 409.25 | 409.44 | 4126.0 |
| 2024-11-05 08:00:00 | MSFT | Stock | 409.93 | 409.9999 | 408.95 | 409.43 | 19417.0 |
| 2024-11-05 08:30:00 | MSFT | Stock | 409.46 | 409.99 | 409.32 | 409.5 | 8200.0 |
| 2024-11-05 09:00:00 | MSFT | Stock | 409.31 | 409.9287 | 408.05 | 408.08 | 19931.0 |
| 2024-11-05 09:30:00 | MSFT | Stock | 408.08 | 412.92 | 408.08 | 412.875 | 1701396.0 |
| 2024-11-05 10:00:00 | MSFT | Stock | 412.82 | 413.53 | 411.91 | 412.495 | 976042.0 |
| 2024-11-05 10:30:00 | MSFT | Stock | 412.48 | 412.83 | 411.52 | 411.74 | 504342.0 |
| 2024-11-05 11:00:00 | MSFT | Stock | 411.74 | 413.97 | 411.3859 | 413.59 | 496085.0 |
| 2024-11-05 11:30:00 | MSFT | Stock | 413.5864 | 414.55 | 412.8001 | 414.435 | 466334.0 |
| 2024-11-05 12:00:00 | MSFT | Stock | 414.4101 | 414.9 | 414.15 | 414.26 | 358140.0 |
| 2024-11-05 12:30:00 | MSFT | Stock | 414.31 | 414.7 | 413.21 | 413.4433 | 301305.0 |
> showing 50 of 101,059 rows — these rows as CSV