PREVIEW / stock_30min / 2005-05-27
file: by_date/stock_30min/2005/2005-05-27.parquet size: 768 KB rows: 42,713 symbols: 1,973
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 |
|---|---|---|---|---|---|---|---|
| 2005-05-27 08:00:00 | AAPL | Stock | 1.4571 | 1.4621 | 1.455 | 1.4571 | 518924.0 |
| 2005-05-27 08:30:00 | AAPL | Stock | 1.4571 | 1.4604 | 1.4571 | 1.4589 | 372820.0 |
| 2005-05-27 09:00:00 | AAPL | Stock | 1.4604 | 1.4604 | 1.4486 | 1.4536 | 1230964.0 |
| 2005-05-27 09:30:00 | AAPL | Stock | 1.4514 | 1.4568 | 1.4304 | 1.435 | 76172516.0 |
| 2005-05-27 10:00:00 | AAPL | Stock | 1.435 | 1.4425 | 1.4289 | 1.4364 | 56111104.0 |
| 2005-05-27 10:30:00 | AAPL | Stock | 1.4364 | 1.4411 | 1.435 | 1.4396 | 26908168.0 |
| 2005-05-27 11:00:00 | AAPL | Stock | 1.4396 | 1.4436 | 1.4389 | 1.4429 | 16307088.0 |
| 2005-05-27 11:30:00 | AAPL | Stock | 1.4425 | 1.4436 | 1.4382 | 1.4393 | 12287828.0 |
| 2005-05-27 12:00:00 | AAPL | Stock | 1.4393 | 1.4429 | 1.4389 | 1.4411 | 12453280.0 |
| 2005-05-27 12:30:00 | AAPL | Stock | 1.4411 | 1.4421 | 1.4389 | 1.4414 | 9705192.0 |
| 2005-05-27 13:00:00 | AAPL | Stock | 1.4411 | 1.4461 | 1.4404 | 1.445 | 12834724.0 |
| 2005-05-27 13:30:00 | AAPL | Stock | 1.445 | 1.4464 | 1.4443 | 1.445 | 8120756.0 |
| 2005-05-27 14:00:00 | AAPL | Stock | 1.445 | 1.4468 | 1.445 | 1.4468 | 9204188.0 |
| 2005-05-27 14:30:00 | AAPL | Stock | 1.4464 | 1.4475 | 1.4436 | 1.4454 | 12665100.0 |
| 2005-05-27 15:00:00 | AAPL | Stock | 1.4454 | 1.4518 | 1.4429 | 1.4496 | 22504356.0 |
| 2005-05-27 15:30:00 | AAPL | Stock | 1.45 | 1.4568 | 1.4443 | 1.4471 | 31845548.0 |
| 2005-05-27 16:00:00 | AAPL | Stock | 1.4471 | 1.45 | 1.4446 | 1.45 | 1782816.0 |
| 2005-05-27 16:30:00 | AAPL | Stock | 1.4482 | 1.4482 | 1.4479 | 1.4479 | 14000.0 |
| 2005-05-27 17:00:00 | AAPL | Stock | 1.4471 | 1.4486 | 1.4471 | 1.4486 | 86800.0 |
| 2005-05-27 18:00:00 | AAPL | Stock | 1.4493 | 1.4514 | 1.4493 | 1.4493 | 65688.0 |
| 2005-05-27 07:00:00 | MSFT | Stock | 25.83 | 25.83 | 25.83 | 25.83 | 150.0 |
| 2005-05-27 07:30:00 | MSFT | Stock | 25.83 | 25.83 | 25.83 | 25.83 | 500.0 |
| 2005-05-27 08:00:00 | MSFT | Stock | 25.9 | 25.9 | 25.86 | 25.9 | 55636.0 |
| 2005-05-27 08:30:00 | MSFT | Stock | 25.88 | 25.88 | 25.86 | 25.86 | 2300.0 |
| 2005-05-27 09:00:00 | MSFT | Stock | 25.87 | 25.88 | 25.79 | 25.84 | 194536.0 |
| 2005-05-27 09:30:00 | MSFT | Stock | 25.83 | 26.0 | 25.81 | 25.97 | 7134329.0 |
| 2005-05-27 10:00:00 | MSFT | Stock | 25.96 | 26.03 | 25.95 | 26.0 | 7617799.0 |
| 2005-05-27 10:30:00 | MSFT | Stock | 26.0 | 26.07 | 25.989 | 26.03 | 8794115.0 |
| 2005-05-27 11:00:00 | MSFT | Stock | 26.03 | 26.06 | 26.0 | 26.05 | 3657458.0 |
| 2005-05-27 11:30:00 | MSFT | Stock | 26.05 | 26.06 | 25.99 | 26.03 | 3522633.0 |
| 2005-05-27 12:00:00 | MSFT | Stock | 26.03 | 26.08 | 26.01 | 26.04 | 1811027.0 |
| 2005-05-27 12:30:00 | MSFT | Stock | 26.04 | 26.05 | 26.02 | 26.02 | 1202505.0 |
| 2005-05-27 13:00:00 | MSFT | Stock | 26.02 | 26.05 | 25.99 | 26.0 | 3318900.0 |
| 2005-05-27 13:30:00 | MSFT | Stock | 26.0 | 26.01 | 25.95 | 25.98 | 2251746.0 |
| 2005-05-27 14:00:00 | MSFT | Stock | 25.98 | 26.03 | 25.9 | 26.03 | 3556232.0 |
| 2005-05-27 14:30:00 | MSFT | Stock | 26.03 | 26.03 | 25.99 | 25.99 | 1456254.0 |
| 2005-05-27 15:00:00 | MSFT | Stock | 25.999 | 26.03 | 25.98 | 26.01 | 1774500.0 |
| 2005-05-27 15:30:00 | MSFT | Stock | 26.01 | 26.09 | 26.0 | 26.08 | 7764141.0 |
| 2005-05-27 16:00:00 | MSFT | Stock | 26.08 | 26.09 | 26.06 | 26.07 | 174712.0 |
| 2005-05-27 16:30:00 | MSFT | Stock | 26.05 | 26.08 | 26.05 | 26.08 | 1061.0 |
| 2005-05-27 17:00:00 | MSFT | Stock | 26.08 | 26.08 | 26.08 | 26.08 | 311.0 |
| 2005-05-27 17:30:00 | MSFT | Stock | 26.06 | 26.08 | 26.06 | 26.08 | 877.0 |
| 2005-05-27 18:00:00 | MSFT | Stock | 26.08 | 26.08 | 26.08 | 26.08 | 715.0 |
| 2005-05-27 08:00:00 | NVDA | Stock | 0.2302 | 0.2302 | 0.2293 | 0.2293 | 216000.0 |
| 2005-05-27 08:30:00 | NVDA | Stock | 0.2296 | 0.2314 | 0.2296 | 0.2314 | 438000.0 |
| 2005-05-27 09:00:00 | NVDA | Stock | 0.2297 | 0.2312 | 0.2297 | 0.2312 | 904080.0 |
| 2005-05-27 09:30:00 | NVDA | Stock | 0.2315 | 0.2315 | 0.229 | 0.23 | 42203520.0 |
| 2005-05-27 10:00:00 | NVDA | Stock | 0.23 | 0.2302 | 0.2271 | 0.2281 | 43547280.0 |
| 2005-05-27 10:30:00 | NVDA | Stock | 0.2282 | 0.2289 | 0.2278 | 0.2285 | 19696320.0 |
| 2005-05-27 11:00:00 | NVDA | Stock | 0.2286 | 0.2289 | 0.2279 | 0.2279 | 14274960.0 |
> showing 50 of 42,713 rows — these rows as CSV