PREVIEW / stock_30min / 2024-12-04
file: by_date/stock_30min/2024/2024-12-04.parquet size: 2.2 MB rows: 105,517 symbols: 683
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-12-04 04:00:00 | AAPL | Stock | 242.76 | 243.69 | 242.76 | 243.4 | 12781.0 |
| 2024-12-04 04:30:00 | AAPL | Stock | 243.45 | 243.45 | 243.22 | 243.24 | 3159.0 |
| 2024-12-04 05:00:00 | AAPL | Stock | 243.2 | 243.21 | 243.18 | 243.18 | 4402.0 |
| 2024-12-04 05:30:00 | AAPL | Stock | 243.08 | 243.35 | 243.08 | 243.35 | 527.0 |
| 2024-12-04 06:00:00 | AAPL | Stock | 243.42 | 243.6 | 243.11 | 243.11 | 14511.0 |
| 2024-12-04 06:30:00 | AAPL | Stock | 243.11 | 243.25 | 242.97 | 243.0 | 4672.0 |
| 2024-12-04 07:00:00 | AAPL | Stock | 243.01 | 243.35 | 242.94 | 243.06 | 16696.0 |
| 2024-12-04 07:30:00 | AAPL | Stock | 243.03 | 243.3 | 243.02 | 243.08 | 6653.0 |
| 2024-12-04 08:00:00 | AAPL | Stock | 242.99 | 243.35 | 242.044 | 243.1 | 64670.0 |
| 2024-12-04 08:30:00 | AAPL | Stock | 243.1 | 243.3 | 242.65 | 243.28 | 185147.0 |
| 2024-12-04 09:00:00 | AAPL | Stock | 243.28 | 243.49 | 242.56 | 243.0 | 153597.0 |
| 2024-12-04 09:30:00 | AAPL | Stock | 242.87 | 243.88 | 242.51 | 243.555 | 3498926.0 |
| 2024-12-04 10:00:00 | AAPL | Stock | 243.54 | 244.11 | 243.15 | 243.46 | 2659658.0 |
| 2024-12-04 10:30:00 | AAPL | Stock | 243.44 | 243.69 | 243.18 | 243.465 | 1452570.0 |
| 2024-12-04 11:00:00 | AAPL | Stock | 243.47 | 243.83 | 242.85 | 242.905 | 1301533.0 |
| 2024-12-04 11:30:00 | AAPL | Stock | 242.905 | 242.9099 | 242.11 | 242.5 | 1539004.0 |
| 2024-12-04 12:00:00 | AAPL | Stock | 242.48 | 242.485 | 241.25 | 242.0399 | 1655331.0 |
| 2024-12-04 12:30:00 | AAPL | Stock | 242.04 | 242.5 | 241.64 | 242.3687 | 931717.0 |
| 2024-12-04 13:00:00 | AAPL | Stock | 242.365 | 242.51 | 242.2 | 242.2587 | 715903.0 |
| 2024-12-04 13:30:00 | AAPL | Stock | 242.25 | 242.88 | 241.92 | 242.51 | 929915.0 |
| 2024-12-04 14:00:00 | AAPL | Stock | 242.525 | 243.1764 | 242.39 | 243.07 | 857485.0 |
| 2024-12-04 14:30:00 | AAPL | Stock | 243.06 | 243.125 | 242.78 | 242.9101 | 853350.0 |
| 2024-12-04 15:00:00 | AAPL | Stock | 242.91 | 243.05 | 242.83 | 242.985 | 864311.0 |
| 2024-12-04 15:30:00 | AAPL | Stock | 242.985 | 243.54 | 242.82 | 243.02 | 2957840.0 |
| 2024-12-04 16:00:00 | AAPL | Stock | 243.01 | 243.02 | 242.71 | 242.9 | 8154617.0 |
| 2024-12-04 16:30:00 | AAPL | Stock | 242.909 | 243.02 | 242.87 | 243.0081 | 28595.0 |
| 2024-12-04 17:00:00 | AAPL | Stock | 242.9608 | 243.01 | 242.9015 | 242.95 | 9947.0 |
| 2024-12-04 17:30:00 | AAPL | Stock | 243.0202 | 243.0299 | 242.9 | 242.9 | 1799.0 |
| 2024-12-04 18:00:00 | AAPL | Stock | 242.95 | 243.02 | 242.8258 | 243.0 | 5284.0 |
| 2024-12-04 18:30:00 | AAPL | Stock | 242.9616 | 243.0 | 242.9 | 242.92 | 3566.0 |
| 2024-12-04 19:00:00 | AAPL | Stock | 242.91 | 242.93 | 242.807 | 242.807 | 7372.0 |
| 2024-12-04 19:30:00 | AAPL | Stock | 242.79 | 242.9 | 242.75 | 242.75 | 8537.0 |
| 2024-12-04 04:00:00 | MSFT | Stock | 433.05 | 434.17 | 432.99 | 433.92 | 6273.0 |
| 2024-12-04 04:30:00 | MSFT | Stock | 434.0 | 434.31 | 433.93 | 434.3 | 2783.0 |
| 2024-12-04 05:00:00 | MSFT | Stock | 434.38 | 435.25 | 434.38 | 434.74 | 4547.0 |
| 2024-12-04 05:30:00 | MSFT | Stock | 434.69 | 434.9 | 434.69 | 434.76 | 904.0 |
| 2024-12-04 06:00:00 | MSFT | Stock | 434.89 | 435.47 | 434.89 | 435.09 | 2687.0 |
| 2024-12-04 06:30:00 | MSFT | Stock | 435.16 | 435.47 | 435.16 | 435.33 | 2724.0 |
| 2024-12-04 07:00:00 | MSFT | Stock | 435.01 | 435.29 | 434.55 | 435.1 | 18491.0 |
| 2024-12-04 07:30:00 | MSFT | Stock | 435.05 | 435.15 | 434.79 | 434.79 | 5868.0 |
| 2024-12-04 08:00:00 | MSFT | Stock | 435.19 | 435.31 | 430.122 | 434.86 | 39021.0 |
| 2024-12-04 08:30:00 | MSFT | Stock | 434.48 | 434.86 | 434.41 | 434.72 | 10914.0 |
| 2024-12-04 09:00:00 | MSFT | Stock | 434.6 | 434.75 | 432.61 | 433.1 | 50951.0 |
| 2024-12-04 09:30:00 | MSFT | Stock | 433.08 | 439.545 | 432.63 | 438.05 | 3064999.0 |
| 2024-12-04 10:00:00 | MSFT | Stock | 437.96 | 438.45 | 436.06 | 438.12 | 1235928.0 |
| 2024-12-04 10:30:00 | MSFT | Stock | 438.115 | 439.08 | 437.38 | 438.9701 | 845117.0 |
| 2024-12-04 11:00:00 | MSFT | Stock | 438.9601 | 439.67 | 437.1513 | 437.455 | 645854.0 |
| 2024-12-04 11:30:00 | MSFT | Stock | 437.42 | 437.55 | 436.4 | 436.97 | 570825.0 |
| 2024-12-04 12:00:00 | MSFT | Stock | 436.96 | 437.72 | 436.32 | 437.45 | 397489.0 |
| 2024-12-04 12:30:00 | MSFT | Stock | 437.515 | 437.67 | 436.56 | 437.04 | 384210.0 |
> showing 50 of 105,517 rows — these rows as CSV