PREVIEW / stock_30min / 2006-12-21
file: by_date/stock_30min/2006/2006-12-21.parquet size: 960 KB rows: 51,950 symbols: 2,482
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-12-21 07:00:00 | AAPL | Stock | 3.0071 | 3.0389 | 2.9821 | 3.0389 | 18200.0 |
| 2006-12-21 07:30:00 | AAPL | Stock | 3.0364 | 3.0364 | 3.0318 | 3.0318 | 16800.0 |
| 2006-12-21 08:00:00 | AAPL | Stock | 3.0318 | 3.0357 | 3.0286 | 3.0336 | 576772.0 |
| 2006-12-21 08:30:00 | AAPL | Stock | 3.0321 | 3.0339 | 3.0243 | 3.0243 | 630168.0 |
| 2006-12-21 09:00:00 | AAPL | Stock | 3.0275 | 3.0286 | 3.025 | 3.0268 | 557760.0 |
| 2006-12-21 09:30:00 | AAPL | Stock | 3.0249 | 3.0529 | 3.0114 | 3.0357 | 85788612.0 |
| 2006-12-21 10:00:00 | AAPL | Stock | 3.0357 | 3.0429 | 3.0257 | 3.035 | 54690328.0 |
| 2006-12-21 10:30:00 | AAPL | Stock | 3.035 | 3.0382 | 3.0132 | 3.0161 | 41381340.0 |
| 2006-12-21 11:00:00 | AAPL | Stock | 3.0161 | 3.0246 | 3.0014 | 3.0225 | 57753808.0 |
| 2006-12-21 11:30:00 | AAPL | Stock | 3.0225 | 3.0325 | 3.0189 | 3.0257 | 32648224.0 |
| 2006-12-21 12:00:00 | AAPL | Stock | 3.0257 | 3.0268 | 3.0064 | 3.0071 | 47628672.0 |
| 2006-12-21 12:30:00 | AAPL | Stock | 3.0064 | 3.0071 | 2.97 | 2.9721 | 91928536.0 |
| 2006-12-21 13:00:00 | AAPL | Stock | 2.9714 | 2.9796 | 2.9532 | 2.9636 | 104762560.0 |
| 2006-12-21 13:30:00 | AAPL | Stock | 2.9632 | 2.9643 | 2.9357 | 2.9464 | 107927484.0 |
| 2006-12-21 14:00:00 | AAPL | Stock | 2.9468 | 2.9739 | 2.9396 | 2.9682 | 67381244.0 |
| 2006-12-21 14:30:00 | AAPL | Stock | 2.9675 | 2.9846 | 2.9654 | 2.9732 | 67778900.0 |
| 2006-12-21 15:00:00 | AAPL | Stock | 2.9732 | 2.9793 | 2.9589 | 2.9654 | 53534152.0 |
| 2006-12-21 15:30:00 | AAPL | Stock | 2.9654 | 2.9721 | 2.9582 | 2.9607 | 62895952.0 |
| 2006-12-21 16:00:00 | AAPL | Stock | 2.9607 | 2.9821 | 2.9593 | 2.9707 | 1585220.0 |
| 2006-12-21 16:30:00 | AAPL | Stock | 2.9696 | 2.9729 | 2.9607 | 2.9714 | 6794228.0 |
| 2006-12-21 17:00:00 | AAPL | Stock | 2.9729 | 2.9729 | 2.9643 | 2.9704 | 311976.0 |
| 2006-12-21 17:30:00 | AAPL | Stock | 2.9704 | 2.9718 | 2.9668 | 2.9707 | 271880.0 |
| 2006-12-21 18:00:00 | AAPL | Stock | 2.9607 | 2.9725 | 2.9607 | 2.9714 | 6645156.0 |
| 2006-12-21 18:30:00 | AAPL | Stock | 2.9693 | 2.9729 | 2.9693 | 2.9729 | 22288.0 |
| 2006-12-21 19:00:00 | AAPL | Stock | 2.9725 | 2.9729 | 2.9718 | 2.9729 | 24248.0 |
| 2006-12-21 19:30:00 | AAPL | Stock | 2.9714 | 2.9739 | 2.9714 | 2.9725 | 180460.0 |
| 2006-12-21 04:30:00 | MSFT | Stock | 30.09 | 30.09 | 30.09 | 30.09 | 100.0 |
| 2006-12-21 05:30:00 | MSFT | Stock | 30.09 | 30.09 | 30.09 | 30.09 | 200.0 |
| 2006-12-21 08:00:00 | MSFT | Stock | 30.1 | 30.1 | 30.1 | 30.1 | 3070.0 |
| 2006-12-21 08:30:00 | MSFT | Stock | 30.1 | 30.11 | 30.07 | 30.11 | 9745.0 |
| 2006-12-21 09:00:00 | MSFT | Stock | 30.08 | 30.14 | 30.07 | 30.13 | 38925.0 |
| 2006-12-21 09:30:00 | MSFT | Stock | 30.13 | 30.14 | 29.93 | 30.0 | 4253112.0 |
| 2006-12-21 10:00:00 | MSFT | Stock | 30.0 | 30.01 | 29.89 | 30.0 | 2504960.0 |
| 2006-12-21 10:30:00 | MSFT | Stock | 30.0 | 30.06 | 29.99 | 30.03 | 1793247.0 |
| 2006-12-21 11:00:00 | MSFT | Stock | 30.04 | 30.13 | 30.03 | 30.09 | 1761648.0 |
| 2006-12-21 11:30:00 | MSFT | Stock | 30.09 | 30.11 | 30.06 | 30.08 | 1570656.0 |
| 2006-12-21 12:00:00 | MSFT | Stock | 30.08 | 30.09 | 29.97 | 29.98 | 2329211.0 |
| 2006-12-21 12:30:00 | MSFT | Stock | 29.98 | 30.03 | 29.93 | 29.99 | 3001220.0 |
| 2006-12-21 13:00:00 | MSFT | Stock | 29.99 | 30.07 | 29.95 | 30.07 | 1780408.0 |
| 2006-12-21 13:30:00 | MSFT | Stock | 30.07 | 30.09 | 30.0 | 30.0 | 1525192.0 |
| 2006-12-21 14:00:00 | MSFT | Stock | 30.0 | 30.05 | 29.99 | 30.01 | 1529382.0 |
| 2006-12-21 14:30:00 | MSFT | Stock | 30.02 | 30.05 | 29.99 | 30.04 | 1462746.0 |
| 2006-12-21 15:00:00 | MSFT | Stock | 30.04 | 30.14 | 30.04 | 30.06 | 2511687.0 |
| 2006-12-21 15:30:00 | MSFT | Stock | 30.06 | 30.06 | 29.98 | 29.98 | 4639494.0 |
| 2006-12-21 16:00:00 | MSFT | Stock | 29.98 | 29.99 | 29.92 | 29.95 | 53205.0 |
| 2006-12-21 16:30:00 | MSFT | Stock | 29.95 | 29.98 | 29.95 | 29.98 | 3467.0 |
| 2006-12-21 17:30:00 | MSFT | Stock | 30.0 | 30.0 | 30.0 | 30.0 | 100.0 |
| 2006-12-21 19:00:00 | MSFT | Stock | 29.98 | 29.98 | 29.98 | 29.98 | 100.0 |
| 2006-12-21 19:30:00 | MSFT | Stock | 30.01 | 30.01 | 30.01 | 30.01 | 1400.0 |
| 2006-12-21 08:00:00 | NVDA | Stock | 0.6397 | 0.6397 | 0.6397 | 0.6397 | 30000.0 |
> showing 50 of 51,950 rows — these rows as CSV