PREVIEW / stock_30min / 2024-12-27
file: by_date/stock_30min/2024/2024-12-27.parquet size: 2.2 MB rows: 107,761 symbols: 613
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-27 04:00:00 | AAPL | Stock | 258.37 | 258.8 | 258.37 | 258.71 | 4176.0 |
| 2024-12-27 04:30:00 | AAPL | Stock | 258.8 | 258.83 | 258.78 | 258.78 | 1407.0 |
| 2024-12-27 05:00:00 | AAPL | Stock | 258.81 | 258.85 | 258.81 | 258.81 | 819.0 |
| 2024-12-27 05:30:00 | AAPL | Stock | 258.83 | 258.9 | 258.82 | 258.9 | 861.0 |
| 2024-12-27 06:00:00 | AAPL | Stock | 258.93 | 258.93 | 258.9 | 258.9 | 982.0 |
| 2024-12-27 06:30:00 | AAPL | Stock | 258.9 | 258.95 | 258.89 | 258.95 | 1913.0 |
| 2024-12-27 07:00:00 | AAPL | Stock | 258.95 | 259.51 | 258.95 | 259.31 | 9849.0 |
| 2024-12-27 07:30:00 | AAPL | Stock | 259.32 | 259.41 | 259.23 | 259.28 | 4403.0 |
| 2024-12-27 08:00:00 | AAPL | Stock | 258.9996 | 259.59 | 258.38 | 259.04 | 54226.0 |
| 2024-12-27 08:30:00 | AAPL | Stock | 259.0 | 259.02 | 258.55 | 258.57 | 15435.0 |
| 2024-12-27 09:00:00 | AAPL | Stock | 258.55 | 258.6099 | 257.83 | 257.84 | 79756.0 |
| 2024-12-27 09:30:00 | AAPL | Stock | 257.83 | 258.7 | 256.11 | 256.6197 | 2876600.0 |
| 2024-12-27 10:00:00 | AAPL | Stock | 256.64 | 256.66 | 254.91 | 254.99 | 2545547.0 |
| 2024-12-27 10:30:00 | AAPL | Stock | 254.98 | 255.4 | 254.5 | 254.95 | 2112034.0 |
| 2024-12-27 11:00:00 | AAPL | Stock | 254.95 | 255.04 | 254.04 | 254.73 | 1682035.0 |
| 2024-12-27 11:30:00 | AAPL | Stock | 254.74 | 254.8 | 253.36 | 253.635 | 1866497.0 |
| 2024-12-27 12:00:00 | AAPL | Stock | 253.62 | 254.0 | 253.06 | 253.68 | 1568132.0 |
| 2024-12-27 12:30:00 | AAPL | Stock | 253.67 | 254.55 | 253.6478 | 254.5 | 1191841.0 |
| 2024-12-27 13:00:00 | AAPL | Stock | 254.48 | 254.9799 | 254.29 | 254.95 | 967944.0 |
| 2024-12-27 13:30:00 | AAPL | Stock | 254.94 | 255.34 | 254.86 | 255.3 | 922648.0 |
| 2024-12-27 14:00:00 | AAPL | Stock | 255.29 | 255.51 | 254.9701 | 255.015 | 915279.0 |
| 2024-12-27 14:30:00 | AAPL | Stock | 255.03 | 255.5599 | 254.98 | 255.465 | 753015.0 |
| 2024-12-27 15:00:00 | AAPL | Stock | 255.4501 | 255.46 | 254.95 | 255.18 | 1124734.0 |
| 2024-12-27 15:30:00 | AAPL | Stock | 255.18 | 255.82 | 254.97 | 255.73 | 4245785.0 |
| 2024-12-27 16:00:00 | AAPL | Stock | 255.72 | 256.38 | 255.55 | 255.64 | 8939869.0 |
| 2024-12-27 16:30:00 | AAPL | Stock | 255.65 | 255.65 | 254.94 | 255.11 | 52693.0 |
| 2024-12-27 17:00:00 | AAPL | Stock | 255.07 | 255.59 | 254.75 | 255.01 | 83028.0 |
| 2024-12-27 17:30:00 | AAPL | Stock | 255.0 | 255.0 | 254.5401 | 254.95 | 14081.0 |
| 2024-12-27 18:00:00 | AAPL | Stock | 254.84 | 254.93 | 254.84 | 254.8618 | 5398.0 |
| 2024-12-27 18:30:00 | AAPL | Stock | 254.8524 | 254.9405 | 254.72 | 254.77 | 11058.0 |
| 2024-12-27 19:00:00 | AAPL | Stock | 254.83 | 254.85 | 254.77 | 254.83 | 3700.0 |
| 2024-12-27 19:30:00 | AAPL | Stock | 254.83 | 254.9783 | 254.77 | 254.77 | 8534.0 |
| 2024-12-27 04:00:00 | MSFT | Stock | 437.0 | 437.1 | 436.31 | 436.74 | 2192.0 |
| 2024-12-27 04:30:00 | MSFT | Stock | 436.74 | 436.74 | 436.55 | 436.73 | 1400.0 |
| 2024-12-27 05:00:00 | MSFT | Stock | 436.89 | 437.2 | 436.89 | 437.2 | 810.0 |
| 2024-12-27 05:30:00 | MSFT | Stock | 437.2 | 437.33 | 437.1 | 437.1 | 1286.0 |
| 2024-12-27 06:30:00 | MSFT | Stock | 437.05 | 437.05 | 436.98 | 436.98 | 808.0 |
| 2024-12-27 07:00:00 | MSFT | Stock | 437.0 | 437.77 | 437.0 | 437.49 | 2617.0 |
| 2024-12-27 07:30:00 | MSFT | Stock | 437.61 | 437.63 | 437.3 | 437.3 | 1944.0 |
| 2024-12-27 08:00:00 | MSFT | Stock | 436.9 | 437.75 | 436.85 | 437.2617 | 9214.0 |
| 2024-12-27 08:30:00 | MSFT | Stock | 437.1 | 437.15 | 436.48 | 437.0 | 3295.0 |
| 2024-12-27 09:00:00 | MSFT | Stock | 436.6 | 436.72 | 434.78 | 435.0 | 12560.0 |
| 2024-12-27 09:30:00 | MSFT | Stock | 435.0 | 435.22 | 429.24 | 430.47 | 1155908.0 |
| 2024-12-27 10:00:00 | MSFT | Stock | 430.47 | 430.7 | 427.36 | 428.34 | 785319.0 |
| 2024-12-27 10:30:00 | MSFT | Stock | 428.31 | 429.7 | 427.4 | 429.3 | 571208.0 |
| 2024-12-27 11:00:00 | MSFT | Stock | 429.3 | 429.75 | 427.8 | 429.685 | 454691.0 |
| 2024-12-27 11:30:00 | MSFT | Stock | 429.69 | 429.9164 | 426.71 | 427.7199 | 542929.0 |
| 2024-12-27 12:00:00 | MSFT | Stock | 427.655 | 427.87 | 426.525 | 426.8411 | 401882.0 |
| 2024-12-27 12:30:00 | MSFT | Stock | 426.835 | 427.84 | 426.35 | 427.75 | 372240.0 |
| 2024-12-27 13:00:00 | MSFT | Stock | 427.75 | 428.48 | 427.41 | 428.31 | 259359.0 |
> showing 50 of 107,761 rows — these rows as CSV