PREVIEW / stock_30min / 2024-11-01
file: by_date/stock_30min/2024/2024-11-01.parquet size: 2.1 MB rows: 98,602 symbols: 726
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-01 04:00:00 | AAPL | Stock | 222.27 | 223.86 | 222.27 | 223.65 | 36320.0 |
| 2024-11-01 04:30:00 | AAPL | Stock | 223.56 | 223.68 | 223.21 | 223.35 | 19031.0 |
| 2024-11-01 05:00:00 | AAPL | Stock | 223.36 | 223.8 | 223.25 | 223.61 | 10778.0 |
| 2024-11-01 05:30:00 | AAPL | Stock | 223.6 | 223.67 | 223.19 | 223.23 | 7350.0 |
| 2024-11-01 06:00:00 | AAPL | Stock | 223.2 | 223.71 | 223.1 | 223.55 | 12665.0 |
| 2024-11-01 06:30:00 | AAPL | Stock | 223.55 | 223.69 | 223.29 | 223.31 | 19902.0 |
| 2024-11-01 07:00:00 | AAPL | Stock | 223.31 | 223.4 | 222.0 | 222.06 | 100137.0 |
| 2024-11-01 07:30:00 | AAPL | Stock | 222.03 | 222.35 | 221.59 | 222.02 | 89623.0 |
| 2024-11-01 08:00:00 | AAPL | Stock | 222.74 | 223.36 | 221.59 | 221.74 | 255799.0 |
| 2024-11-01 08:30:00 | AAPL | Stock | 221.74 | 225.91 | 220.88 | 221.88 | 350145.0 |
| 2024-11-01 09:00:00 | AAPL | Stock | 221.88 | 222.7 | 220.88 | 220.97 | 335328.0 |
| 2024-11-01 09:30:00 | AAPL | Stock | 221.0 | 223.901 | 220.27 | 223.8499 | 8865760.0 |
| 2024-11-01 10:00:00 | AAPL | Stock | 223.85 | 225.35 | 223.77 | 224.06 | 5677590.0 |
| 2024-11-01 10:30:00 | AAPL | Stock | 224.08 | 224.214 | 221.6 | 222.435 | 4223669.0 |
| 2024-11-01 11:00:00 | AAPL | Stock | 222.4205 | 223.26 | 222.11 | 223.2105 | 2777806.0 |
| 2024-11-01 11:30:00 | AAPL | Stock | 223.22 | 223.25 | 221.88 | 222.08 | 1901020.0 |
| 2024-11-01 12:00:00 | AAPL | Stock | 222.07 | 222.53 | 221.77 | 222.15 | 1575372.0 |
| 2024-11-01 12:30:00 | AAPL | Stock | 222.14 | 222.69 | 222.05 | 222.6 | 1162698.0 |
| 2024-11-01 13:00:00 | AAPL | Stock | 222.5911 | 223.3999 | 222.07 | 223.355 | 1375105.0 |
| 2024-11-01 13:30:00 | AAPL | Stock | 223.3402 | 223.36 | 222.15 | 222.2 | 1226581.0 |
| 2024-11-01 14:00:00 | AAPL | Stock | 222.19 | 222.5 | 222.07 | 222.245 | 1211201.0 |
| 2024-11-01 14:30:00 | AAPL | Stock | 222.24 | 222.68 | 222.14 | 222.6 | 1365190.0 |
| 2024-11-01 15:00:00 | AAPL | Stock | 222.59 | 223.1 | 222.25 | 222.34 | 1614515.0 |
| 2024-11-01 15:30:00 | AAPL | Stock | 222.33 | 223.25 | 222.27 | 222.85 | 3891040.0 |
| 2024-11-01 16:00:00 | AAPL | Stock | 222.91 | 223.29 | 222.76 | 222.86 | 7229206.0 |
| 2024-11-01 16:30:00 | AAPL | Stock | 222.9 | 222.96 | 222.83 | 222.87 | 59884.0 |
| 2024-11-01 17:00:00 | AAPL | Stock | 222.87 | 222.95 | 222.85 | 222.94 | 19426.0 |
| 2024-11-01 17:30:00 | AAPL | Stock | 222.9 | 223.0 | 222.83 | 223.0 | 15358.0 |
| 2024-11-01 18:00:00 | AAPL | Stock | 222.9646 | 223.0 | 222.81 | 222.91 | 9577.0 |
| 2024-11-01 18:30:00 | AAPL | Stock | 222.98 | 222.98 | 222.88 | 222.93 | 6565.0 |
| 2024-11-01 19:00:00 | AAPL | Stock | 222.84 | 222.85 | 222.8 | 222.81 | 1587.0 |
| 2024-11-01 19:30:00 | AAPL | Stock | 222.8694 | 222.89 | 222.55 | 222.68 | 10128.0 |
| 2024-11-01 04:00:00 | MSFT | Stock | 409.53 | 410.74 | 409.53 | 410.37 | 10569.0 |
| 2024-11-01 04:30:00 | MSFT | Stock | 410.38 | 411.36 | 410.38 | 410.89 | 10127.0 |
| 2024-11-01 05:00:00 | MSFT | Stock | 411.0 | 411.4 | 410.98 | 411.37 | 8221.0 |
| 2024-11-01 05:30:00 | MSFT | Stock | 411.47 | 411.47 | 410.19 | 410.5 | 7977.0 |
| 2024-11-01 06:00:00 | MSFT | Stock | 410.51 | 411.98 | 410.51 | 411.53 | 6485.0 |
| 2024-11-01 06:30:00 | MSFT | Stock | 411.99 | 412.0 | 411.46 | 411.79 | 5889.0 |
| 2024-11-01 07:00:00 | MSFT | Stock | 411.68 | 411.8 | 410.24 | 410.4 | 15672.0 |
| 2024-11-01 07:30:00 | MSFT | Stock | 410.65 | 411.0 | 410.25 | 410.89 | 13219.0 |
| 2024-11-01 08:00:00 | MSFT | Stock | 410.72 | 411.77 | 409.38 | 410.1127 | 85772.0 |
| 2024-11-01 08:30:00 | MSFT | Stock | 410.11 | 411.05 | 406.35 | 409.66 | 82889.0 |
| 2024-11-01 09:00:00 | MSFT | Stock | 409.77 | 410.93 | 409.0 | 409.13 | 77833.0 |
| 2024-11-01 09:30:00 | MSFT | Stock | 409.0 | 411.69 | 407.5 | 410.37 | 3042938.0 |
| 2024-11-01 10:00:00 | MSFT | Stock | 410.47 | 412.0 | 409.5515 | 411.88 | 1214181.0 |
| 2024-11-01 10:30:00 | MSFT | Stock | 411.88 | 413.43 | 411.4 | 413.385 | 1025294.0 |
| 2024-11-01 11:00:00 | MSFT | Stock | 413.375 | 415.13 | 413.32 | 414.97 | 1166691.0 |
| 2024-11-01 11:30:00 | MSFT | Stock | 414.95 | 415.5 | 413.97 | 414.07 | 776911.0 |
| 2024-11-01 12:00:00 | MSFT | Stock | 414.0 | 414.35 | 413.52 | 413.72 | 402106.0 |
| 2024-11-01 12:30:00 | MSFT | Stock | 413.705 | 414.95 | 413.11 | 413.6999 | 447151.0 |
> showing 50 of 98,602 rows — these rows as CSV