PREVIEW / stock_30min / 2024-10-29
file: by_date/stock_30min/2024/2024-10-29.parquet size: 2.1 MB rows: 102,339 symbols: 746
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-29 04:00:00 | AAPL | Stock | 232.7 | 232.98 | 232.29 | 232.98 | 12019.0 |
| 2024-10-29 04:30:00 | AAPL | Stock | 232.89 | 233.2 | 232.89 | 232.98 | 4304.0 |
| 2024-10-29 05:00:00 | AAPL | Stock | 233.11 | 233.11 | 232.6 | 232.8 | 6483.0 |
| 2024-10-29 05:30:00 | AAPL | Stock | 232.7 | 232.75 | 232.5 | 232.68 | 3440.0 |
| 2024-10-29 06:00:00 | AAPL | Stock | 232.69 | 232.69 | 232.5 | 232.5 | 6181.0 |
| 2024-10-29 06:30:00 | AAPL | Stock | 232.58 | 232.66 | 232.42 | 232.6 | 2714.0 |
| 2024-10-29 07:00:00 | AAPL | Stock | 232.58 | 232.69 | 231.76 | 232.13 | 29103.0 |
| 2024-10-29 07:30:00 | AAPL | Stock | 232.21 | 232.68 | 232.1 | 232.27 | 13624.0 |
| 2024-10-29 08:00:00 | AAPL | Stock | 232.35 | 233.17 | 231.6 | 232.2619 | 77047.0 |
| 2024-10-29 08:30:00 | AAPL | Stock | 232.31 | 232.59 | 232.16 | 232.25 | 18585.0 |
| 2024-10-29 09:00:00 | AAPL | Stock | 232.36 | 233.4 | 232.01 | 233.37 | 73763.0 |
| 2024-10-29 09:30:00 | AAPL | Stock | 233.26 | 233.95 | 232.32 | 233.605 | 2973781.0 |
| 2024-10-29 10:00:00 | AAPL | Stock | 233.6 | 234.07 | 233.03 | 233.06 | 1923431.0 |
| 2024-10-29 10:30:00 | AAPL | Stock | 233.05 | 233.69 | 233.04 | 233.49 | 1186594.0 |
| 2024-10-29 11:00:00 | AAPL | Stock | 233.505 | 233.63 | 233.06 | 233.26 | 987690.0 |
| 2024-10-29 11:30:00 | AAPL | Stock | 233.26 | 233.47 | 233.0201 | 233.34 | 793855.0 |
| 2024-10-29 12:00:00 | AAPL | Stock | 233.35 | 233.59 | 233.1 | 233.1 | 709585.0 |
| 2024-10-29 12:30:00 | AAPL | Stock | 233.105 | 233.98 | 233.01 | 233.9501 | 1198484.0 |
| 2024-10-29 13:00:00 | AAPL | Stock | 233.95 | 234.21 | 233.87 | 233.89 | 815166.0 |
| 2024-10-29 13:30:00 | AAPL | Stock | 233.91 | 234.14 | 233.77 | 233.82 | 488274.0 |
| 2024-10-29 14:00:00 | AAPL | Stock | 233.815 | 234.13 | 233.76 | 233.99 | 761500.0 |
| 2024-10-29 14:30:00 | AAPL | Stock | 233.985 | 234.19 | 233.91 | 234.09 | 620825.0 |
| 2024-10-29 15:00:00 | AAPL | Stock | 234.095 | 234.2199 | 233.88 | 234.205 | 878986.0 |
| 2024-10-29 15:30:00 | AAPL | Stock | 234.2061 | 234.325 | 233.54 | 233.75 | 2543779.0 |
| 2024-10-29 16:00:00 | AAPL | Stock | 233.78 | 233.78 | 231.76 | 232.5 | 6021706.0 |
| 2024-10-29 16:30:00 | AAPL | Stock | 232.49 | 233.67 | 232.1 | 232.51 | 107019.0 |
| 2024-10-29 17:00:00 | AAPL | Stock | 232.51 | 233.67 | 232.49 | 232.67 | 125805.0 |
| 2024-10-29 17:30:00 | AAPL | Stock | 232.69 | 233.67 | 232.39 | 232.46 | 36984.0 |
| 2024-10-29 18:00:00 | AAPL | Stock | 232.4 | 232.89 | 232.4 | 232.8 | 19973.0 |
| 2024-10-29 18:30:00 | AAPL | Stock | 232.85 | 232.89 | 232.8 | 232.83 | 14417.0 |
| 2024-10-29 19:00:00 | AAPL | Stock | 232.8 | 233.19 | 232.75 | 233.19 | 11966.0 |
| 2024-10-29 19:30:00 | AAPL | Stock | 233.15 | 233.15 | 232.61 | 232.93 | 23155.0 |
| 2024-10-29 04:00:00 | MSFT | Stock | 427.4 | 427.6 | 427.11 | 427.11 | 3834.0 |
| 2024-10-29 04:30:00 | MSFT | Stock | 427.73 | 427.97 | 427.73 | 427.82 | 425.0 |
| 2024-10-29 05:00:00 | MSFT | Stock | 427.72 | 428.0 | 427.72 | 427.72 | 711.0 |
| 2024-10-29 05:30:00 | MSFT | Stock | 427.9 | 428.0 | 427.71 | 427.98 | 2075.0 |
| 2024-10-29 06:00:00 | MSFT | Stock | 427.9 | 427.9 | 427.51 | 427.51 | 316.0 |
| 2024-10-29 06:30:00 | MSFT | Stock | 427.73 | 427.81 | 427.6 | 427.61 | 1694.0 |
| 2024-10-29 07:00:00 | MSFT | Stock | 427.3 | 427.3 | 426.29 | 426.29 | 7825.0 |
| 2024-10-29 07:30:00 | MSFT | Stock | 426.4 | 426.4 | 425.4 | 425.9 | 6400.0 |
| 2024-10-29 08:00:00 | MSFT | Stock | 425.5 | 427.5 | 425.4 | 425.7 | 20774.0 |
| 2024-10-29 08:30:00 | MSFT | Stock | 426.0 | 426.02 | 425.637 | 425.94 | 6124.0 |
| 2024-10-29 09:00:00 | MSFT | Stock | 425.9 | 428.0 | 425.9 | 428.0 | 12591.0 |
| 2024-10-29 09:30:00 | MSFT | Stock | 428.0 | 428.54 | 425.8001 | 427.795 | 929214.0 |
| 2024-10-29 10:00:00 | MSFT | Stock | 427.835 | 429.28 | 427.16 | 428.23 | 586929.0 |
| 2024-10-29 10:30:00 | MSFT | Stock | 428.25 | 429.41 | 428.08 | 429.16 | 516907.0 |
| 2024-10-29 11:00:00 | MSFT | Stock | 429.13 | 430.1799 | 428.54 | 429.54 | 572348.0 |
| 2024-10-29 11:30:00 | MSFT | Stock | 429.49 | 430.35 | 429.3812 | 430.18 | 358412.0 |
| 2024-10-29 12:00:00 | MSFT | Stock | 430.22 | 430.67 | 429.935 | 430.02 | 404680.0 |
| 2024-10-29 12:30:00 | MSFT | Stock | 430.01 | 431.45 | 429.56 | 431.23 | 323900.0 |
> showing 50 of 102,339 rows — these rows as CSV