PREVIEW / stock_30min / 2007-12-07
file: by_date/stock_30min/2007/2007-12-07.parquet size: 1.2 MB rows: 70,346 symbols: 3,235
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 |
|---|---|---|---|---|---|---|---|
| 2007-12-07 04:00:00 | AAPL | Stock | 6.7643 | 6.7643 | 6.7643 | 6.7643 | 11200.0 |
| 2007-12-07 07:00:00 | AAPL | Stock | 6.7786 | 6.7786 | 6.7786 | 6.7786 | 28000.0 |
| 2007-12-07 07:30:00 | AAPL | Stock | 6.7679 | 6.7679 | 6.7607 | 6.7625 | 78148.0 |
| 2007-12-07 08:00:00 | AAPL | Stock | 6.7675 | 6.7854 | 6.7607 | 6.775 | 1633240.0 |
| 2007-12-07 08:30:00 | AAPL | Stock | 6.7775 | 6.8382 | 6.7775 | 6.7971 | 9067576.0 |
| 2007-12-07 09:00:00 | AAPL | Stock | 6.7968 | 6.8125 | 6.7807 | 6.8004 | 5354412.0 |
| 2007-12-07 09:30:00 | AAPL | Stock | 6.8 | 6.8086 | 6.7157 | 6.7536 | 155271172.0 |
| 2007-12-07 10:00:00 | AAPL | Stock | 6.7539 | 6.7768 | 6.7329 | 6.7636 | 81134424.0 |
| 2007-12-07 10:30:00 | AAPL | Stock | 6.7632 | 6.8139 | 6.7557 | 6.8125 | 76614580.0 |
| 2007-12-07 11:00:00 | AAPL | Stock | 6.8132 | 6.8214 | 6.7871 | 6.7979 | 56914172.0 |
| 2007-12-07 11:30:00 | AAPL | Stock | 6.7971 | 6.8368 | 6.7961 | 6.8318 | 65235968.0 |
| 2007-12-07 12:00:00 | AAPL | Stock | 6.8318 | 6.8529 | 6.8186 | 6.8436 | 49053480.0 |
| 2007-12-07 12:30:00 | AAPL | Stock | 6.8429 | 6.8529 | 6.8254 | 6.8271 | 30444484.0 |
| 2007-12-07 13:00:00 | AAPL | Stock | 6.8261 | 6.8414 | 6.8054 | 6.8204 | 41433392.0 |
| 2007-12-07 13:30:00 | AAPL | Stock | 6.8204 | 6.8382 | 6.8168 | 6.8346 | 31299352.0 |
| 2007-12-07 14:00:00 | AAPL | Stock | 6.8343 | 6.8568 | 6.8321 | 6.8568 | 34285860.0 |
| 2007-12-07 14:30:00 | AAPL | Stock | 6.8561 | 6.9336 | 6.8482 | 6.8971 | 139973008.0 |
| 2007-12-07 15:00:00 | AAPL | Stock | 6.8964 | 6.9639 | 6.8957 | 6.9407 | 140131544.0 |
| 2007-12-07 15:30:00 | AAPL | Stock | 6.9407 | 6.9457 | 6.9143 | 6.9379 | 126312648.0 |
| 2007-12-07 16:00:00 | AAPL | Stock | 6.9375 | 6.945 | 6.8462 | 6.9411 | 15392580.0 |
| 2007-12-07 16:30:00 | AAPL | Stock | 6.9382 | 6.9404 | 6.8907 | 6.9364 | 4283552.0 |
| 2007-12-07 17:00:00 | AAPL | Stock | 6.9364 | 6.9425 | 6.9364 | 6.9425 | 321608.0 |
| 2007-12-07 17:30:00 | AAPL | Stock | 6.9425 | 6.9425 | 6.9321 | 6.9375 | 1344112.0 |
| 2007-12-07 18:00:00 | AAPL | Stock | 6.9393 | 6.9396 | 6.9361 | 6.9393 | 94528.0 |
| 2007-12-07 18:30:00 | AAPL | Stock | 6.9393 | 6.94 | 6.9371 | 6.9371 | 184436.0 |
| 2007-12-07 19:00:00 | AAPL | Stock | 6.9379 | 6.9389 | 6.9357 | 6.9375 | 67536.0 |
| 2007-12-07 19:30:00 | AAPL | Stock | 6.9357 | 6.9379 | 6.9329 | 6.9329 | 115472.0 |
| 2007-12-07 07:00:00 | MSFT | Stock | 34.5 | 34.5 | 34.5 | 34.5 | 100.0 |
| 2007-12-07 07:30:00 | MSFT | Stock | 34.51 | 34.57 | 34.51 | 34.57 | 6461.0 |
| 2007-12-07 08:00:00 | MSFT | Stock | 34.55 | 34.6 | 34.49 | 34.56 | 5391.0 |
| 2007-12-07 08:30:00 | MSFT | Stock | 34.57 | 34.73 | 34.55 | 34.7 | 66121.0 |
| 2007-12-07 09:00:00 | MSFT | Stock | 34.73 | 34.73 | 34.6 | 34.61 | 57000.0 |
| 2007-12-07 09:30:00 | MSFT | Stock | 34.6 | 34.72 | 34.3 | 34.44 | 3949243.0 |
| 2007-12-07 10:00:00 | MSFT | Stock | 34.43 | 34.47 | 34.25 | 34.29 | 3267279.0 |
| 2007-12-07 10:30:00 | MSFT | Stock | 34.29 | 34.36 | 34.22 | 34.34 | 2161408.0 |
| 2007-12-07 11:00:00 | MSFT | Stock | 34.34 | 34.55 | 34.33 | 34.487 | 2392381.0 |
| 2007-12-07 11:30:00 | MSFT | Stock | 34.48 | 34.6 | 34.48 | 34.52 | 2112163.0 |
| 2007-12-07 12:00:00 | MSFT | Stock | 34.52 | 34.61 | 34.47 | 34.56 | 2298161.0 |
| 2007-12-07 12:30:00 | MSFT | Stock | 34.558 | 34.59 | 34.4 | 34.42 | 2091735.0 |
| 2007-12-07 13:00:00 | MSFT | Stock | 34.422 | 34.45 | 34.36 | 34.42 | 1330097.0 |
| 2007-12-07 13:30:00 | MSFT | Stock | 34.41 | 34.48 | 34.4 | 34.41 | 1139538.0 |
| 2007-12-07 14:00:00 | MSFT | Stock | 34.42 | 34.57 | 34.4 | 34.54 | 2615625.0 |
| 2007-12-07 14:30:00 | MSFT | Stock | 34.545 | 34.62 | 34.44 | 34.515 | 2215604.0 |
| 2007-12-07 15:00:00 | MSFT | Stock | 34.52 | 34.65 | 34.49 | 34.53 | 2986678.0 |
| 2007-12-07 15:30:00 | MSFT | Stock | 34.53 | 34.65 | 34.46 | 34.52 | 4409683.0 |
| 2007-12-07 16:00:00 | MSFT | Stock | 34.52 | 34.563 | 34.45 | 34.53 | 6784663.0 |
| 2007-12-07 16:30:00 | MSFT | Stock | 34.53 | 34.53 | 34.519 | 34.53 | 568901.0 |
| 2007-12-07 17:00:00 | MSFT | Stock | 34.51 | 34.53 | 34.45 | 34.5 | 4842.0 |
| 2007-12-07 17:30:00 | MSFT | Stock | 34.53 | 34.57 | 34.5 | 34.57 | 308073.0 |
| 2007-12-07 08:00:00 | NVDA | Stock | 0.8538 | 0.8538 | 0.8538 | 0.8538 | 7200.0 |
> showing 50 of 70,346 rows — these rows as CSV