PREVIEW / stock_30min / 2006-01-18
file: by_date/stock_30min/2006/2006-01-18.parquet size: 895 KB rows: 48,632 symbols: 2,166
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-01-18 06:00:00 | AAPL | Stock | 2.9321 | 2.9429 | 2.9321 | 2.9429 | 22400.0 |
| 2006-01-18 06:30:00 | AAPL | Stock | 2.9411 | 2.9429 | 2.9393 | 2.9429 | 16800.0 |
| 2006-01-18 07:00:00 | AAPL | Stock | 2.9446 | 2.9586 | 2.9425 | 2.9571 | 187600.0 |
| 2006-01-18 07:30:00 | AAPL | Stock | 2.9586 | 2.9607 | 2.9536 | 2.9557 | 240996.0 |
| 2006-01-18 08:00:00 | AAPL | Stock | 2.9589 | 2.9714 | 2.9446 | 2.9554 | 6872012.0 |
| 2006-01-18 08:30:00 | AAPL | Stock | 2.9557 | 2.9721 | 2.9446 | 2.9707 | 5801964.0 |
| 2006-01-18 09:00:00 | AAPL | Stock | 2.9704 | 2.9761 | 2.9614 | 2.9654 | 7252812.0 |
| 2006-01-18 09:30:00 | AAPL | Stock | 2.9671 | 2.9882 | 2.9232 | 2.9725 | 189122444.0 |
| 2006-01-18 10:00:00 | AAPL | Stock | 2.9721 | 3.0018 | 2.965 | 2.9946 | 105808136.0 |
| 2006-01-18 10:30:00 | AAPL | Stock | 2.9946 | 3.0 | 2.9818 | 2.9861 | 51638524.0 |
| 2006-01-18 11:00:00 | AAPL | Stock | 2.9864 | 2.9896 | 2.9714 | 2.9807 | 46100432.0 |
| 2006-01-18 11:30:00 | AAPL | Stock | 2.9796 | 2.9817 | 2.9589 | 2.9661 | 55537636.0 |
| 2006-01-18 12:00:00 | AAPL | Stock | 2.9668 | 2.9725 | 2.9596 | 2.965 | 34606236.0 |
| 2006-01-18 12:30:00 | AAPL | Stock | 2.965 | 2.9696 | 2.9604 | 2.9635 | 28950796.0 |
| 2006-01-18 13:00:00 | AAPL | Stock | 2.9632 | 2.965 | 2.9464 | 2.95 | 44558752.0 |
| 2006-01-18 13:30:00 | AAPL | Stock | 2.9503 | 2.9646 | 2.9436 | 2.9607 | 53524688.0 |
| 2006-01-18 14:00:00 | AAPL | Stock | 2.9607 | 2.9729 | 2.9554 | 2.9711 | 58743384.0 |
| 2006-01-18 14:30:00 | AAPL | Stock | 2.9707 | 2.9775 | 2.9532 | 2.9621 | 66766140.0 |
| 2006-01-18 15:00:00 | AAPL | Stock | 2.9621 | 2.9714 | 2.9571 | 2.97 | 44279732.0 |
| 2006-01-18 15:30:00 | AAPL | Stock | 2.97 | 2.9743 | 2.9436 | 2.9454 | 96055176.0 |
| 2006-01-18 16:00:00 | AAPL | Stock | 2.9464 | 2.9639 | 2.75 | 2.7696 | 13564096.0 |
| 2006-01-18 16:30:00 | AAPL | Stock | 2.7689 | 2.8207 | 2.7114 | 2.7332 | 180732972.0 |
| 2006-01-18 17:00:00 | AAPL | Stock | 2.7329 | 2.9461 | 2.7304 | 2.8286 | 76936160.0 |
| 2006-01-18 17:30:00 | AAPL | Stock | 2.8286 | 2.9454 | 2.825 | 2.8475 | 26604900.0 |
| 2006-01-18 18:00:00 | AAPL | Stock | 2.8464 | 2.8518 | 2.8325 | 2.8493 | 6242516.0 |
| 2006-01-18 07:30:00 | MSFT | Stock | 26.6 | 26.65 | 26.6 | 26.6 | 4600.0 |
| 2006-01-18 08:00:00 | MSFT | Stock | 26.6 | 26.69 | 26.6 | 26.62 | 41084.0 |
| 2006-01-18 08:30:00 | MSFT | Stock | 26.62 | 26.66 | 26.55 | 26.66 | 60190.0 |
| 2006-01-18 09:00:00 | MSFT | Stock | 26.65 | 26.74 | 26.63 | 26.73 | 157204.0 |
| 2006-01-18 09:30:00 | MSFT | Stock | 26.74 | 26.86 | 26.7 | 26.812 | 7120388.0 |
| 2006-01-18 10:00:00 | MSFT | Stock | 26.82 | 26.98 | 26.81 | 26.89 | 5320902.0 |
| 2006-01-18 10:30:00 | MSFT | Stock | 26.89 | 26.93 | 26.8 | 26.86 | 3459595.0 |
| 2006-01-18 11:00:00 | MSFT | Stock | 26.86 | 26.9 | 26.81 | 26.85 | 3385587.0 |
| 2006-01-18 11:30:00 | MSFT | Stock | 26.85 | 26.86 | 26.79 | 26.84 | 2934435.0 |
| 2006-01-18 12:00:00 | MSFT | Stock | 26.832 | 26.87 | 26.75 | 26.77 | 2751565.0 |
| 2006-01-18 12:30:00 | MSFT | Stock | 26.77 | 26.83 | 26.75 | 26.8 | 2245966.0 |
| 2006-01-18 13:00:00 | MSFT | Stock | 26.81 | 26.85 | 26.77 | 26.77 | 2526302.0 |
| 2006-01-18 13:30:00 | MSFT | Stock | 26.78 | 26.85 | 26.76 | 26.79 | 2601803.0 |
| 2006-01-18 14:00:00 | MSFT | Stock | 26.79 | 26.89 | 26.79 | 26.86 | 4127385.0 |
| 2006-01-18 14:30:00 | MSFT | Stock | 26.86 | 26.91 | 26.8 | 26.82 | 3280434.0 |
| 2006-01-18 15:00:00 | MSFT | Stock | 26.83 | 26.87 | 26.79 | 26.85 | 3680459.0 |
| 2006-01-18 15:30:00 | MSFT | Stock | 26.85 | 26.88 | 26.8 | 26.82 | 6327298.0 |
| 2006-01-18 16:00:00 | MSFT | Stock | 26.83 | 26.91 | 26.76 | 26.79 | 288940.0 |
| 2006-01-18 16:30:00 | MSFT | Stock | 26.8 | 26.88 | 26.8 | 26.88 | 78575.0 |
| 2006-01-18 17:00:00 | MSFT | Stock | 26.85 | 26.88 | 26.8 | 26.82 | 11410.0 |
| 2006-01-18 17:30:00 | MSFT | Stock | 26.82 | 26.9 | 26.82 | 26.83 | 119841.0 |
| 2006-01-18 18:00:00 | MSFT | Stock | 26.83 | 26.83 | 26.83 | 26.83 | 100.0 |
| 2006-01-18 08:00:00 | NVDA | Stock | 0.3506 | 0.3506 | 0.345 | 0.3458 | 576000.0 |
| 2006-01-18 08:30:00 | NVDA | Stock | 0.3467 | 0.3471 | 0.3458 | 0.3471 | 396000.0 |
| 2006-01-18 09:00:00 | NVDA | Stock | 0.3458 | 0.3458 | 0.3433 | 0.3447 | 1215120.0 |
> showing 50 of 48,632 rows — these rows as CSV