PREVIEW / stock_30min / 2024-10-11
file: by_date/stock_30min/2024/2024-10-11.parquet size: 2.0 MB rows: 97,299 symbols: 769
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-10-11 04:00:00 | AAPL | Stock | 228.5 | 228.8 | 228.32 | 228.61 | 2639.0 |
| 2024-10-11 04:30:00 | AAPL | Stock | 228.8 | 229.09 | 228.8 | 229.09 | 2307.0 |
| 2024-10-11 05:00:00 | AAPL | Stock | 228.65 | 228.84 | 228.63 | 228.84 | 1186.0 |
| 2024-10-11 05:30:00 | AAPL | Stock | 228.71 | 228.71 | 228.71 | 228.71 | 300.0 |
| 2024-10-11 06:30:00 | AAPL | Stock | 228.73 | 228.75 | 228.73 | 228.75 | 436.0 |
| 2024-10-11 07:00:00 | AAPL | Stock | 228.8 | 229.06 | 228.8 | 229.0 | 6060.0 |
| 2024-10-11 07:30:00 | AAPL | Stock | 229.01 | 229.15 | 229.01 | 229.12 | 8847.0 |
| 2024-10-11 08:00:00 | AAPL | Stock | 228.85 | 229.36 | 228.85 | 229.2 | 45641.0 |
| 2024-10-11 08:30:00 | AAPL | Stock | 229.23 | 229.5 | 228.8 | 228.96 | 22770.0 |
| 2024-10-11 09:00:00 | AAPL | Stock | 228.97 | 229.55 | 228.73 | 229.49 | 40069.0 |
| 2024-10-11 09:30:00 | AAPL | Stock | 229.49 | 229.5 | 227.34 | 227.96 | 2952416.0 |
| 2024-10-11 10:00:00 | AAPL | Stock | 227.965 | 228.9 | 227.62 | 228.76 | 1721720.0 |
| 2024-10-11 10:30:00 | AAPL | Stock | 228.74 | 229.19 | 227.87 | 228.09 | 1478032.0 |
| 2024-10-11 11:00:00 | AAPL | Stock | 228.08 | 228.4 | 227.79 | 227.975 | 1072094.0 |
| 2024-10-11 11:30:00 | AAPL | Stock | 227.9701 | 228.11 | 227.685 | 228.0699 | 912003.0 |
| 2024-10-11 12:00:00 | AAPL | Stock | 228.065 | 228.09 | 227.66 | 227.8301 | 760537.0 |
| 2024-10-11 12:30:00 | AAPL | Stock | 227.83 | 227.985 | 227.41 | 227.87 | 904844.0 |
| 2024-10-11 13:00:00 | AAPL | Stock | 227.87 | 227.95 | 227.495 | 227.84 | 728115.0 |
| 2024-10-11 13:30:00 | AAPL | Stock | 227.825 | 228.075 | 227.58 | 227.8342 | 808371.0 |
| 2024-10-11 14:00:00 | AAPL | Stock | 227.83 | 228.45 | 227.82 | 228.195 | 962765.0 |
| 2024-10-11 14:30:00 | AAPL | Stock | 228.195 | 228.63 | 228.06 | 228.585 | 859010.0 |
| 2024-10-11 15:00:00 | AAPL | Stock | 228.57 | 228.97 | 228.4 | 228.69 | 1229080.0 |
| 2024-10-11 15:30:00 | AAPL | Stock | 228.6887 | 228.76 | 227.5 | 227.51 | 2962242.0 |
| 2024-10-11 16:00:00 | AAPL | Stock | 227.55 | 228.65 | 227.43 | 227.54 | 5920309.0 |
| 2024-10-11 16:30:00 | AAPL | Stock | 227.5 | 227.56 | 227.42 | 227.45 | 51972.0 |
| 2024-10-11 17:00:00 | AAPL | Stock | 227.461 | 227.55 | 227.461 | 227.52 | 8388.0 |
| 2024-10-11 17:30:00 | AAPL | Stock | 227.52 | 227.52 | 227.45 | 227.49 | 2075.0 |
| 2024-10-11 18:00:00 | AAPL | Stock | 227.45 | 227.49 | 227.2 | 227.35 | 12478.0 |
| 2024-10-11 18:30:00 | AAPL | Stock | 227.3565 | 227.36 | 227.35 | 227.3533 | 933.0 |
| 2024-10-11 19:00:00 | AAPL | Stock | 227.35 | 227.35 | 227.34 | 227.34 | 1283.0 |
| 2024-10-11 19:30:00 | AAPL | Stock | 227.34 | 227.41 | 227.34 | 227.4 | 6325.0 |
| 2024-10-11 04:00:00 | MSFT | Stock | 416.07 | 416.35 | 415.85 | 415.85 | 527.0 |
| 2024-10-11 04:30:00 | MSFT | Stock | 416.0 | 416.0 | 415.9 | 415.95 | 545.0 |
| 2024-10-11 05:30:00 | MSFT | Stock | 416.12 | 416.12 | 416.12 | 416.12 | 117.0 |
| 2024-10-11 06:00:00 | MSFT | Stock | 416.2 | 416.2 | 416.2 | 416.2 | 276.0 |
| 2024-10-11 06:30:00 | MSFT | Stock | 416.33 | 416.33 | 416.2 | 416.2 | 407.0 |
| 2024-10-11 07:00:00 | MSFT | Stock | 415.99 | 415.99 | 415.66 | 415.66 | 2256.0 |
| 2024-10-11 07:30:00 | MSFT | Stock | 415.65 | 415.82 | 415.65 | 415.82 | 1032.0 |
| 2024-10-11 08:00:00 | MSFT | Stock | 416.2 | 416.2067 | 415.652 | 415.9684 | 6532.0 |
| 2024-10-11 08:30:00 | MSFT | Stock | 416.1 | 416.45 | 415.55 | 415.67 | 9351.0 |
| 2024-10-11 09:00:00 | MSFT | Stock | 415.7 | 416.16 | 415.2 | 416.0 | 9379.0 |
| 2024-10-11 09:30:00 | MSFT | Stock | 416.135 | 416.135 | 413.25 | 414.965 | 1098221.0 |
| 2024-10-11 10:00:00 | MSFT | Stock | 414.965 | 417.1086 | 414.5 | 416.88 | 721408.0 |
| 2024-10-11 10:30:00 | MSFT | Stock | 416.84 | 417.13 | 414.8001 | 415.385 | 551605.0 |
| 2024-10-11 11:00:00 | MSFT | Stock | 415.39 | 415.99 | 414.93 | 415.31 | 357700.0 |
| 2024-10-11 11:30:00 | MSFT | Stock | 415.36 | 415.99 | 415.08 | 415.48 | 333695.0 |
| 2024-10-11 12:00:00 | MSFT | Stock | 415.48 | 415.505 | 413.32 | 413.835 | 583807.0 |
| 2024-10-11 12:30:00 | MSFT | Stock | 413.825 | 414.3558 | 413.35 | 414.335 | 382963.0 |
| 2024-10-11 13:00:00 | MSFT | Stock | 414.36 | 414.69 | 414.17 | 414.68 | 239535.0 |
| 2024-10-11 13:30:00 | MSFT | Stock | 414.69 | 414.98 | 414.4101 | 414.445 | 202577.0 |
> showing 50 of 97,299 rows — these rows as CSV