PREVIEW / stock_30min / 2006-11-10
file: by_date/stock_30min/2006/2006-11-10.parquet size: 939 KB rows: 51,077 symbols: 2,442
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-10 07:30:00 | AAPL | Stock | 2.9857 | 2.9857 | 2.9857 | 2.9857 | 2800.0 |
| 2006-11-10 08:00:00 | AAPL | Stock | 2.985 | 2.9907 | 2.9786 | 2.9832 | 376180.0 |
| 2006-11-10 08:30:00 | AAPL | Stock | 2.9832 | 2.9893 | 2.9821 | 2.9875 | 624428.0 |
| 2006-11-10 09:00:00 | AAPL | Stock | 2.9857 | 2.9879 | 2.9721 | 2.985 | 1362536.0 |
| 2006-11-10 09:30:00 | AAPL | Stock | 2.9857 | 2.9857 | 2.9464 | 2.9579 | 87746344.0 |
| 2006-11-10 10:00:00 | AAPL | Stock | 2.9579 | 2.9757 | 2.9536 | 2.9557 | 48664896.0 |
| 2006-11-10 10:30:00 | AAPL | Stock | 2.9558 | 2.9714 | 2.9511 | 2.9643 | 29657712.0 |
| 2006-11-10 11:00:00 | AAPL | Stock | 2.9643 | 2.965 | 2.9536 | 2.9582 | 19005980.0 |
| 2006-11-10 11:30:00 | AAPL | Stock | 2.9586 | 2.9661 | 2.95 | 2.9539 | 21549024.0 |
| 2006-11-10 12:00:00 | AAPL | Stock | 2.9539 | 2.9596 | 2.9511 | 2.9545 | 12026196.0 |
| 2006-11-10 12:30:00 | AAPL | Stock | 2.9543 | 2.96 | 2.9543 | 2.9579 | 13303976.0 |
| 2006-11-10 13:00:00 | AAPL | Stock | 2.9579 | 2.9582 | 2.9518 | 2.9571 | 12298216.0 |
| 2006-11-10 13:30:00 | AAPL | Stock | 2.9571 | 2.9646 | 2.9518 | 2.9625 | 17683260.0 |
| 2006-11-10 14:00:00 | AAPL | Stock | 2.9629 | 2.9732 | 2.9596 | 2.9696 | 18780804.0 |
| 2006-11-10 14:30:00 | AAPL | Stock | 2.9694 | 2.9757 | 2.9657 | 2.9704 | 18535468.0 |
| 2006-11-10 15:00:00 | AAPL | Stock | 2.9704 | 2.9714 | 2.9607 | 2.9654 | 21322812.0 |
| 2006-11-10 15:30:00 | AAPL | Stock | 2.9657 | 2.9732 | 2.965 | 2.9686 | 37065756.0 |
| 2006-11-10 16:00:00 | AAPL | Stock | 2.9696 | 2.9721 | 2.9679 | 2.9704 | 1314712.0 |
| 2006-11-10 16:30:00 | AAPL | Stock | 2.9696 | 2.9714 | 2.9696 | 2.9707 | 104524.0 |
| 2006-11-10 17:00:00 | AAPL | Stock | 2.9707 | 2.9711 | 2.9689 | 2.9696 | 264348.0 |
| 2006-11-10 17:30:00 | AAPL | Stock | 2.9707 | 2.9707 | 2.9686 | 2.9707 | 4469640.0 |
| 2006-11-10 18:00:00 | AAPL | Stock | 2.9707 | 2.9711 | 2.9696 | 2.9711 | 84000.0 |
| 2006-11-10 18:30:00 | AAPL | Stock | 2.9707 | 2.9707 | 2.9696 | 2.97 | 50064.0 |
| 2006-11-10 19:00:00 | AAPL | Stock | 2.97 | 2.9707 | 2.97 | 2.9707 | 64400.0 |
| 2006-11-10 19:30:00 | AAPL | Stock | 2.9704 | 2.9707 | 2.9682 | 2.9707 | 232568.0 |
| 2006-11-10 08:00:00 | MSFT | Stock | 29.22 | 29.3 | 29.22 | 29.27 | 3508.0 |
| 2006-11-10 08:30:00 | MSFT | Stock | 29.23 | 29.24 | 29.23 | 29.24 | 2625.0 |
| 2006-11-10 09:00:00 | MSFT | Stock | 29.22 | 29.26 | 29.17 | 29.17 | 43590.0 |
| 2006-11-10 09:30:00 | MSFT | Stock | 29.17 | 29.29 | 29.15 | 29.24 | 4545411.0 |
| 2006-11-10 10:00:00 | MSFT | Stock | 29.25 | 29.28 | 29.22 | 29.232 | 3252725.0 |
| 2006-11-10 10:30:00 | MSFT | Stock | 29.23 | 29.26 | 29.2 | 29.23 | 2036342.0 |
| 2006-11-10 11:00:00 | MSFT | Stock | 29.23 | 29.25 | 29.22 | 29.23 | 1863845.0 |
| 2006-11-10 11:30:00 | MSFT | Stock | 29.23 | 29.29 | 29.22 | 29.23 | 2304962.0 |
| 2006-11-10 12:00:00 | MSFT | Stock | 29.24 | 29.27 | 29.22 | 29.26 | 1836744.0 |
| 2006-11-10 12:30:00 | MSFT | Stock | 29.26 | 29.28 | 29.21 | 29.23 | 1587142.0 |
| 2006-11-10 13:00:00 | MSFT | Stock | 29.24 | 29.24 | 29.19 | 29.2 | 1109529.0 |
| 2006-11-10 13:30:00 | MSFT | Stock | 29.19 | 29.24 | 29.19 | 29.21 | 2084005.0 |
| 2006-11-10 14:00:00 | MSFT | Stock | 29.21 | 29.28 | 29.2 | 29.26 | 2243190.0 |
| 2006-11-10 14:30:00 | MSFT | Stock | 29.26 | 29.28 | 29.23 | 29.25 | 1600975.0 |
| 2006-11-10 15:00:00 | MSFT | Stock | 29.25 | 29.28 | 29.22 | 29.22 | 1897311.0 |
| 2006-11-10 15:30:00 | MSFT | Stock | 29.22 | 29.27 | 29.2 | 29.27 | 3432959.0 |
| 2006-11-10 16:00:00 | MSFT | Stock | 29.24 | 29.27 | 29.23 | 29.23 | 53064.0 |
| 2006-11-10 16:30:00 | MSFT | Stock | 29.23 | 29.23 | 29.23 | 29.23 | 3810.0 |
| 2006-11-10 17:00:00 | MSFT | Stock | 29.24 | 29.24 | 29.24 | 29.24 | 870150.0 |
| 2006-11-10 17:30:00 | MSFT | Stock | 29.24 | 29.26 | 29.24 | 29.26 | 1170.0 |
| 2006-11-10 18:00:00 | MSFT | Stock | 29.24 | 29.24 | 29.24 | 29.24 | 950.0 |
| 2006-11-10 18:30:00 | MSFT | Stock | 29.23 | 29.23 | 29.23 | 29.23 | 200.0 |
| 2006-11-10 19:30:00 | MSFT | Stock | 29.25 | 29.26 | 29.25 | 29.26 | 4944.0 |
| 2006-11-10 06:30:00 | NVDA | Stock | 0.5935 | 0.5935 | 0.5935 | 0.5935 | 90000.0 |
| 2006-11-10 07:00:00 | NVDA | Stock | 0.596 | 0.6035 | 0.5917 | 0.5917 | 1707180.0 |
> showing 50 of 51,077 rows — these rows as CSV