PREVIEW / stock_30min / 2024-12-24
file: by_date/stock_30min/2024/2024-12-24.parquet size: 1.5 MB rows: 67,713 symbols: 607
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-24 04:00:00 | AAPL | Stock | 255.05 | 255.42 | 255.0 | 255.42 | 3306.0 |
| 2024-12-24 04:30:00 | AAPL | Stock | 255.4 | 255.53 | 255.4 | 255.53 | 2974.0 |
| 2024-12-24 05:00:00 | AAPL | Stock | 255.54 | 255.59 | 255.43 | 255.43 | 1535.0 |
| 2024-12-24 05:30:00 | AAPL | Stock | 255.48 | 255.52 | 255.38 | 255.52 | 1892.0 |
| 2024-12-24 06:00:00 | AAPL | Stock | 255.57 | 255.7 | 255.57 | 255.57 | 1041.0 |
| 2024-12-24 06:30:00 | AAPL | Stock | 255.58 | 255.61 | 255.47 | 255.47 | 1547.0 |
| 2024-12-24 07:00:00 | AAPL | Stock | 255.41 | 255.5 | 255.0 | 255.25 | 10864.0 |
| 2024-12-24 07:30:00 | AAPL | Stock | 255.22 | 255.33 | 255.21 | 255.3 | 1707.0 |
| 2024-12-24 08:00:00 | AAPL | Stock | 255.0 | 255.5 | 254.95 | 255.04 | 21709.0 |
| 2024-12-24 08:30:00 | AAPL | Stock | 255.02 | 255.3955 | 255.01 | 255.35 | 7814.0 |
| 2024-12-24 09:00:00 | AAPL | Stock | 255.38 | 255.5 | 255.0 | 255.35 | 36341.0 |
| 2024-12-24 09:30:00 | AAPL | Stock | 255.49 | 257.0 | 255.29 | 256.765 | 2891151.0 |
| 2024-12-24 10:00:00 | AAPL | Stock | 256.79 | 257.45 | 256.56 | 257.105 | 1560431.0 |
| 2024-12-24 10:30:00 | AAPL | Stock | 257.115 | 258.01 | 257.1 | 257.55 | 1509015.0 |
| 2024-12-24 11:00:00 | AAPL | Stock | 257.54 | 257.72 | 257.26 | 257.293 | 840480.0 |
| 2024-12-24 11:30:00 | AAPL | Stock | 257.27 | 257.47 | 256.8701 | 257.08 | 1026983.0 |
| 2024-12-24 12:00:00 | AAPL | Stock | 257.11 | 257.54 | 257.0 | 257.37 | 751470.0 |
| 2024-12-24 12:30:00 | AAPL | Stock | 257.3776 | 258.21 | 257.05 | 258.21 | 2720163.0 |
| 2024-12-24 13:00:00 | AAPL | Stock | 258.178 | 258.36 | 257.99 | 258.09 | 4114667.0 |
| 2024-12-24 13:30:00 | AAPL | Stock | 258.2 | 258.2 | 257.98 | 258.0 | 60274.0 |
| 2024-12-24 14:00:00 | AAPL | Stock | 257.98 | 258.08 | 257.9573 | 258.08 | 9712.0 |
| 2024-12-24 14:30:00 | AAPL | Stock | 258.08 | 258.11 | 257.72 | 257.7989 | 7753.0 |
| 2024-12-24 15:00:00 | AAPL | Stock | 257.72 | 257.9791 | 257.7 | 257.9 | 15569.0 |
| 2024-12-24 15:30:00 | AAPL | Stock | 257.83 | 257.91 | 257.8 | 257.9 | 4460.0 |
| 2024-12-24 16:00:00 | AAPL | Stock | 257.82 | 257.95 | 257.82 | 257.95 | 1200.0 |
| 2024-12-24 16:30:00 | AAPL | Stock | 258.0 | 258.18 | 258.0 | 258.1 | 8659.0 |
| 2024-12-24 04:00:00 | MSFT | Stock | 434.6 | 434.72 | 434.4 | 434.6 | 1694.0 |
| 2024-12-24 04:30:00 | MSFT | Stock | 434.59 | 435.0 | 434.5 | 434.98 | 1349.0 |
| 2024-12-24 05:00:00 | MSFT | Stock | 434.71 | 434.71 | 434.59 | 434.59 | 200.0 |
| 2024-12-24 05:30:00 | MSFT | Stock | 434.71 | 435.0 | 434.71 | 435.0 | 406.0 |
| 2024-12-24 06:00:00 | MSFT | Stock | 434.94 | 434.94 | 434.75 | 434.75 | 501.0 |
| 2024-12-24 06:30:00 | MSFT | Stock | 434.88 | 434.88 | 434.64 | 434.64 | 325.0 |
| 2024-12-24 07:00:00 | MSFT | Stock | 434.72 | 434.72 | 434.67 | 434.67 | 279.0 |
| 2024-12-24 07:30:00 | MSFT | Stock | 434.6 | 434.62 | 434.6 | 434.6 | 482.0 |
| 2024-12-24 08:00:00 | MSFT | Stock | 434.5 | 434.72 | 433.72 | 434.4 | 7138.0 |
| 2024-12-24 08:30:00 | MSFT | Stock | 434.2607 | 434.81 | 434.25 | 434.74 | 6290.0 |
| 2024-12-24 09:00:00 | MSFT | Stock | 434.89 | 435.0 | 434.0 | 434.61 | 10238.0 |
| 2024-12-24 09:30:00 | MSFT | Stock | 434.65 | 436.35 | 434.19 | 436.09 | 710124.0 |
| 2024-12-24 10:00:00 | MSFT | Stock | 436.11 | 437.61 | 435.885 | 437.27 | 583846.0 |
| 2024-12-24 10:30:00 | MSFT | Stock | 437.255 | 438.67 | 437.14 | 438.18 | 372198.0 |
| 2024-12-24 11:00:00 | MSFT | Stock | 438.1994 | 438.35 | 437.2308 | 437.53 | 232999.0 |
| 2024-12-24 11:30:00 | MSFT | Stock | 437.47 | 438.23 | 437.37 | 437.51 | 222672.0 |
| 2024-12-24 12:00:00 | MSFT | Stock | 437.5 | 438.65 | 437.4 | 438.52 | 243146.0 |
| 2024-12-24 12:30:00 | MSFT | Stock | 438.49 | 439.6 | 438.1 | 439.24 | 819269.0 |
| 2024-12-24 13:00:00 | MSFT | Stock | 439.23 | 439.79 | 439.12 | 439.4021 | 1887399.0 |
| 2024-12-24 13:30:00 | MSFT | Stock | 439.33 | 439.49 | 439.2 | 439.33 | 3966.0 |
| 2024-12-24 14:00:00 | MSFT | Stock | 439.33 | 439.33 | 439.2 | 439.2 | 1194.0 |
| 2024-12-24 14:30:00 | MSFT | Stock | 439.15 | 439.15 | 439.08 | 439.08 | 1002.0 |
| 2024-12-24 15:00:00 | MSFT | Stock | 439.05 | 439.0509 | 439.05 | 439.0509 | 391.0 |
| 2024-12-24 16:00:00 | MSFT | Stock | 439.13 | 439.13 | 439.11 | 439.11 | 400.0 |
> showing 50 of 67,713 rows — these rows as CSV