PREVIEW / stock_30min / 2006-11-06
file: by_date/stock_30min/2006/2006-11-06.parquet size: 961 KB rows: 52,259 symbols: 2,433
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 |
|---|---|---|---|---|---|---|---|
| 2006-11-06 07:00:00 | AAPL | Stock | 2.81 | 2.81 | 2.8054 | 2.8054 | 16800.0 |
| 2006-11-06 07:30:00 | AAPL | Stock | 2.815 | 2.815 | 2.815 | 2.815 | 50960.0 |
| 2006-11-06 08:00:00 | AAPL | Stock | 2.8157 | 2.8271 | 2.81 | 2.8264 | 980140.0 |
| 2006-11-06 08:30:00 | AAPL | Stock | 2.8218 | 2.825 | 2.8121 | 2.8182 | 666176.0 |
| 2006-11-06 09:00:00 | AAPL | Stock | 2.8182 | 2.8232 | 2.8179 | 2.8186 | 423108.0 |
| 2006-11-06 09:30:00 | AAPL | Stock | 2.8196 | 2.8307 | 2.8011 | 2.8279 | 68929952.0 |
| 2006-11-06 10:00:00 | AAPL | Stock | 2.8279 | 2.8554 | 2.8239 | 2.8504 | 75664064.0 |
| 2006-11-06 10:30:00 | AAPL | Stock | 2.85 | 2.8568 | 2.8414 | 2.8471 | 42434644.0 |
| 2006-11-06 11:00:00 | AAPL | Stock | 2.8481 | 2.8557 | 2.8425 | 2.8539 | 21396116.0 |
| 2006-11-06 11:30:00 | AAPL | Stock | 2.8539 | 2.8593 | 2.8489 | 2.8554 | 31668392.0 |
| 2006-11-06 12:00:00 | AAPL | Stock | 2.8557 | 2.8564 | 2.8393 | 2.845 | 35410284.0 |
| 2006-11-06 12:30:00 | AAPL | Stock | 2.8447 | 2.8518 | 2.8414 | 2.8511 | 14656824.0 |
| 2006-11-06 13:00:00 | AAPL | Stock | 2.8507 | 2.8554 | 2.8471 | 2.8543 | 17101140.0 |
| 2006-11-06 13:30:00 | AAPL | Stock | 2.8543 | 2.8543 | 2.8429 | 2.8489 | 17444224.0 |
| 2006-11-06 14:00:00 | AAPL | Stock | 2.8489 | 2.8525 | 2.8464 | 2.8518 | 11034772.0 |
| 2006-11-06 14:30:00 | AAPL | Stock | 2.8518 | 2.8536 | 2.8479 | 2.8507 | 15344868.0 |
| 2006-11-06 15:00:00 | AAPL | Stock | 2.8507 | 2.8546 | 2.8482 | 2.849 | 21227724.0 |
| 2006-11-06 15:30:00 | AAPL | Stock | 2.8489 | 2.8511 | 2.8414 | 2.8464 | 42527128.0 |
| 2006-11-06 16:00:00 | AAPL | Stock | 2.8436 | 2.8482 | 2.8429 | 2.8454 | 583016.0 |
| 2006-11-06 16:30:00 | AAPL | Stock | 2.8464 | 2.8471 | 2.8461 | 2.8464 | 149800.0 |
| 2006-11-06 17:00:00 | AAPL | Stock | 2.8461 | 2.8471 | 2.8454 | 2.8464 | 77000.0 |
| 2006-11-06 17:30:00 | AAPL | Stock | 2.8464 | 2.8464 | 2.8457 | 2.8464 | 8689548.0 |
| 2006-11-06 18:00:00 | AAPL | Stock | 2.8464 | 2.8471 | 2.8464 | 2.8464 | 103740.0 |
| 2006-11-06 18:30:00 | AAPL | Stock | 2.8489 | 2.8489 | 2.8489 | 2.8489 | 9800.0 |
| 2006-11-06 19:30:00 | AAPL | Stock | 2.8468 | 2.8468 | 2.8468 | 2.8468 | 2800.0 |
| 2006-11-06 08:00:00 | MSFT | Stock | 28.7 | 28.84 | 28.7 | 28.8 | 13500.0 |
| 2006-11-06 08:30:00 | MSFT | Stock | 28.82 | 28.83 | 28.0 | 28.65 | 123396.0 |
| 2006-11-06 09:00:00 | MSFT | Stock | 28.67 | 28.78 | 28.64 | 28.78 | 48047.0 |
| 2006-11-06 09:30:00 | MSFT | Stock | 28.77 | 28.99 | 28.76 | 28.96 | 7358894.0 |
| 2006-11-06 10:00:00 | MSFT | Stock | 28.97 | 29.05 | 28.87 | 28.89 | 11037384.0 |
| 2006-11-06 10:30:00 | MSFT | Stock | 28.89 | 28.91 | 28.88 | 28.902 | 4147649.0 |
| 2006-11-06 11:00:00 | MSFT | Stock | 28.91 | 28.94 | 28.87 | 28.93 | 2296045.0 |
| 2006-11-06 11:30:00 | MSFT | Stock | 28.93 | 29.04 | 28.91 | 28.94 | 3326866.0 |
| 2006-11-06 12:00:00 | MSFT | Stock | 28.94 | 28.97 | 28.9 | 28.92 | 1668780.0 |
| 2006-11-06 12:30:00 | MSFT | Stock | 28.922 | 28.93 | 28.88 | 28.9 | 1512308.0 |
| 2006-11-06 13:00:00 | MSFT | Stock | 28.9 | 28.95 | 28.9 | 28.92 | 1477611.0 |
| 2006-11-06 13:30:00 | MSFT | Stock | 28.92 | 28.93 | 28.9 | 28.9 | 1683595.0 |
| 2006-11-06 14:00:00 | MSFT | Stock | 28.9 | 28.93 | 28.88 | 28.92 | 2254717.0 |
| 2006-11-06 14:30:00 | MSFT | Stock | 28.92 | 28.93 | 28.9 | 28.9 | 2498842.0 |
| 2006-11-06 15:00:00 | MSFT | Stock | 28.9 | 28.93 | 28.89 | 28.91 | 2298668.0 |
| 2006-11-06 15:30:00 | MSFT | Stock | 28.92 | 28.97 | 28.8 | 28.8 | 8495552.0 |
| 2006-11-06 16:00:00 | MSFT | Stock | 28.82 | 28.913 | 28.8 | 28.82 | 111927.0 |
| 2006-11-06 16:30:00 | MSFT | Stock | 28.84 | 28.88 | 28.82 | 28.82 | 12456.0 |
| 2006-11-06 17:00:00 | MSFT | Stock | 28.84 | 28.84 | 28.82 | 28.83 | 372550.0 |
| 2006-11-06 17:30:00 | MSFT | Stock | 28.81 | 28.84 | 28.81 | 28.84 | 5951.0 |
| 2006-11-06 18:00:00 | MSFT | Stock | 28.81 | 28.81 | 28.81 | 28.81 | 200.0 |
| 2006-11-06 19:00:00 | MSFT | Stock | 28.82 | 28.82 | 28.82 | 28.82 | 619.0 |
| 2006-11-06 19:30:00 | MSFT | Stock | 28.83 | 28.83 | 28.82 | 28.83 | 5519.0 |
| 2006-11-06 08:00:00 | NVDA | Stock | 0.55 | 0.55 | 0.55 | 0.55 | 12000.0 |
| 2006-11-06 08:30:00 | NVDA | Stock | 0.548 | 0.548 | 0.5478 | 0.5478 | 75000.0 |
> showing 50 of 52,259 rows — these rows as CSV