PREVIEW / stock_30min / 2024-10-08
file: by_date/stock_30min/2024/2024-10-08.parquet size: 2.1 MB rows: 99,267 symbols: 779
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-08 04:00:00 | AAPL | Stock | 222.1 | 222.3 | 221.84 | 222.14 | 8998.0 |
| 2024-10-08 04:30:00 | AAPL | Stock | 222.01 | 222.01 | 221.7 | 221.97 | 3396.0 |
| 2024-10-08 05:00:00 | AAPL | Stock | 222.07 | 222.45 | 222.07 | 222.45 | 4132.0 |
| 2024-10-08 05:30:00 | AAPL | Stock | 222.43 | 222.8 | 222.4 | 222.8 | 6953.0 |
| 2024-10-08 06:00:00 | AAPL | Stock | 222.77 | 222.82 | 222.68 | 222.7 | 3892.0 |
| 2024-10-08 06:30:00 | AAPL | Stock | 222.83 | 223.24 | 222.73 | 223.13 | 14130.0 |
| 2024-10-08 07:00:00 | AAPL | Stock | 223.08 | 223.35 | 222.78 | 222.9 | 21136.0 |
| 2024-10-08 07:30:00 | AAPL | Stock | 223.0 | 223.25 | 223.0 | 223.18 | 7760.0 |
| 2024-10-08 08:00:00 | AAPL | Stock | 223.2 | 223.26 | 221.136 | 223.1503 | 74024.0 |
| 2024-10-08 08:30:00 | AAPL | Stock | 223.15 | 223.58 | 223.15 | 223.4404 | 43721.0 |
| 2024-10-08 09:00:00 | AAPL | Stock | 223.45 | 224.29 | 223.06 | 224.25 | 109628.0 |
| 2024-10-08 09:30:00 | AAPL | Stock | 224.3 | 225.17 | 223.25 | 225.07 | 3650741.0 |
| 2024-10-08 10:00:00 | AAPL | Stock | 225.08 | 225.88 | 224.54 | 224.9 | 2229574.0 |
| 2024-10-08 10:30:00 | AAPL | Stock | 224.8976 | 225.97 | 224.808 | 225.04 | 1832481.0 |
| 2024-10-08 11:00:00 | AAPL | Stock | 225.045 | 225.35 | 224.66 | 225.33 | 967001.0 |
| 2024-10-08 11:30:00 | AAPL | Stock | 225.3393 | 225.6 | 225.07 | 225.3452 | 924690.0 |
| 2024-10-08 12:00:00 | AAPL | Stock | 225.34 | 225.35 | 224.74 | 224.82 | 740565.0 |
| 2024-10-08 12:30:00 | AAPL | Stock | 224.83 | 225.01 | 224.57 | 224.7098 | 542722.0 |
| 2024-10-08 13:00:00 | AAPL | Stock | 224.692 | 224.8 | 224.22 | 224.74 | 705404.0 |
| 2024-10-08 13:30:00 | AAPL | Stock | 224.74 | 224.99 | 224.66 | 224.9611 | 548923.0 |
| 2024-10-08 14:00:00 | AAPL | Stock | 224.96 | 225.115 | 224.87 | 224.9297 | 560276.0 |
| 2024-10-08 14:30:00 | AAPL | Stock | 224.92 | 225.44 | 224.77 | 225.34 | 836678.0 |
| 2024-10-08 15:00:00 | AAPL | Stock | 225.32 | 225.59 | 225.1 | 225.27 | 1101733.0 |
| 2024-10-08 15:30:00 | AAPL | Stock | 225.27 | 225.98 | 225.23 | 225.78 | 2712927.0 |
| 2024-10-08 16:00:00 | AAPL | Stock | 225.77 | 225.9 | 225.45 | 225.49 | 5210852.0 |
| 2024-10-08 16:30:00 | AAPL | Stock | 225.49 | 225.77 | 225.44 | 225.51 | 79699.0 |
| 2024-10-08 17:00:00 | AAPL | Stock | 225.5 | 225.77 | 225.4415 | 225.4415 | 31055.0 |
| 2024-10-08 17:30:00 | AAPL | Stock | 225.4875 | 225.4875 | 225.37 | 225.4 | 3271.0 |
| 2024-10-08 18:00:00 | AAPL | Stock | 225.49 | 225.4915 | 225.2 | 225.35 | 13082.0 |
| 2024-10-08 18:30:00 | AAPL | Stock | 225.3601 | 225.53 | 225.35 | 225.53 | 5360.0 |
| 2024-10-08 19:00:00 | AAPL | Stock | 225.53 | 225.53 | 225.2513 | 225.2513 | 1942.0 |
| 2024-10-08 19:30:00 | AAPL | Stock | 225.25 | 225.3447 | 225.2212 | 225.2212 | 6640.0 |
| 2024-10-08 04:00:00 | MSFT | Stock | 410.94 | 412.71 | 410.8 | 412.71 | 4771.0 |
| 2024-10-08 04:30:00 | MSFT | Stock | 412.38 | 412.38 | 411.5 | 411.5 | 2451.0 |
| 2024-10-08 05:00:00 | MSFT | Stock | 412.75 | 413.6 | 412.75 | 413.6 | 2839.0 |
| 2024-10-08 05:30:00 | MSFT | Stock | 413.7 | 413.98 | 412.71 | 413.14 | 6214.0 |
| 2024-10-08 06:00:00 | MSFT | Stock | 413.26 | 413.26 | 413.04 | 413.04 | 300.0 |
| 2024-10-08 06:30:00 | MSFT | Stock | 413.47 | 413.47 | 405.5 | 407.69 | 116585.0 |
| 2024-10-08 07:00:00 | MSFT | Stock | 407.72 | 407.95 | 407.34 | 407.7 | 36229.0 |
| 2024-10-08 07:30:00 | MSFT | Stock | 407.61 | 408.58 | 407.6 | 408.05 | 19615.0 |
| 2024-10-08 08:00:00 | MSFT | Stock | 407.4 | 410.0 | 407.01 | 409.15 | 62923.0 |
| 2024-10-08 08:30:00 | MSFT | Stock | 409.24 | 410.5 | 409.15 | 409.44 | 39795.0 |
| 2024-10-08 09:00:00 | MSFT | Stock | 409.43 | 411.0 | 409.25 | 410.9 | 56595.0 |
| 2024-10-08 09:30:00 | MSFT | Stock | 410.9 | 413.99 | 408.17 | 413.33 | 2664233.0 |
| 2024-10-08 10:00:00 | MSFT | Stock | 413.33 | 413.88 | 412.16 | 412.97 | 785030.0 |
| 2024-10-08 10:30:00 | MSFT | Stock | 412.99 | 414.85 | 412.85 | 413.735 | 737653.0 |
| 2024-10-08 11:00:00 | MSFT | Stock | 413.7 | 414.6 | 412.9 | 413.55 | 525478.0 |
| 2024-10-08 11:30:00 | MSFT | Stock | 413.57 | 414.62 | 413.35 | 414.5 | 469116.0 |
| 2024-10-08 12:00:00 | MSFT | Stock | 414.495 | 414.72 | 413.65 | 414.265 | 418825.0 |
| 2024-10-08 12:30:00 | MSFT | Stock | 414.216 | 414.72 | 413.25 | 413.585 | 420411.0 |
> showing 50 of 99,267 rows — these rows as CSV