PREVIEW / stock_30min / 2005-10-31
file: by_date/stock_30min/2005/2005-10-31.parquet size: 871 KB rows: 46,758 symbols: 2,116
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 |
|---|---|---|---|---|---|---|---|
| 2005-10-31 07:30:00 | AAPL | Stock | 1.9571 | 1.9571 | 1.9571 | 1.9571 | 2800.0 |
| 2005-10-31 08:00:00 | AAPL | Stock | 1.9518 | 1.9707 | 1.9518 | 1.9661 | 885360.0 |
| 2005-10-31 08:30:00 | AAPL | Stock | 1.9661 | 1.9796 | 1.9657 | 1.9786 | 2488724.0 |
| 2005-10-31 09:00:00 | AAPL | Stock | 1.9786 | 1.9839 | 1.9689 | 1.9732 | 3576552.0 |
| 2005-10-31 09:30:00 | AAPL | Stock | 1.9714 | 1.9818 | 1.9554 | 1.975 | 92975932.0 |
| 2005-10-31 10:00:00 | AAPL | Stock | 1.975 | 2.0079 | 1.9718 | 2.0004 | 83817832.0 |
| 2005-10-31 10:30:00 | AAPL | Stock | 2.0004 | 2.0125 | 1.9929 | 2.0039 | 67574808.0 |
| 2005-10-31 11:00:00 | AAPL | Stock | 2.0043 | 2.0161 | 1.9979 | 2.0146 | 40983068.0 |
| 2005-10-31 11:30:00 | AAPL | Stock | 2.0143 | 2.0339 | 1.9899 | 2.0286 | 63066584.0 |
| 2005-10-31 12:00:00 | AAPL | Stock | 2.0289 | 2.0529 | 2.025 | 2.0443 | 92928164.0 |
| 2005-10-31 12:30:00 | AAPL | Stock | 2.0436 | 2.0532 | 2.035 | 2.0489 | 51206624.0 |
| 2005-10-31 13:00:00 | AAPL | Stock | 2.0493 | 2.0611 | 2.0429 | 2.0561 | 73032736.0 |
| 2005-10-31 13:30:00 | AAPL | Stock | 2.0564 | 2.0589 | 2.0379 | 2.0436 | 56763812.0 |
| 2005-10-31 14:00:00 | AAPL | Stock | 2.0443 | 2.0554 | 2.0386 | 2.0525 | 53460484.0 |
| 2005-10-31 14:30:00 | AAPL | Stock | 2.0529 | 2.0568 | 2.0486 | 2.0561 | 40976684.0 |
| 2005-10-31 15:00:00 | AAPL | Stock | 2.0561 | 2.0696 | 2.0561 | 2.0675 | 78832012.0 |
| 2005-10-31 15:30:00 | AAPL | Stock | 2.0675 | 2.0707 | 2.0521 | 2.0564 | 103161856.0 |
| 2005-10-31 16:00:00 | AAPL | Stock | 2.0568 | 2.0639 | 2.0271 | 2.0386 | 15018948.0 |
| 2005-10-31 16:30:00 | AAPL | Stock | 2.0393 | 2.0568 | 2.035 | 2.0375 | 2718912.0 |
| 2005-10-31 17:00:00 | AAPL | Stock | 2.0375 | 2.0568 | 2.035 | 2.0393 | 1289316.0 |
| 2005-10-31 17:30:00 | AAPL | Stock | 2.0389 | 2.0393 | 2.0311 | 2.0318 | 667800.0 |
| 2005-10-31 18:00:00 | AAPL | Stock | 2.0339 | 2.0357 | 2.0311 | 2.0321 | 248472.0 |
| 2005-10-31 08:00:00 | MSFT | Stock | 25.62 | 25.64 | 25.59 | 25.59 | 41659.0 |
| 2005-10-31 08:30:00 | MSFT | Stock | 25.6 | 25.63 | 25.6 | 25.6 | 44000.0 |
| 2005-10-31 09:00:00 | MSFT | Stock | 25.61 | 25.63 | 25.58 | 25.6 | 82116.0 |
| 2005-10-31 09:30:00 | MSFT | Stock | 25.61 | 25.78 | 25.559 | 25.74 | 12140486.0 |
| 2005-10-31 10:00:00 | MSFT | Stock | 25.737 | 25.79 | 25.67 | 25.72 | 5764566.0 |
| 2005-10-31 10:30:00 | MSFT | Stock | 25.73 | 25.758 | 25.68 | 25.7 | 4823380.0 |
| 2005-10-31 11:00:00 | MSFT | Stock | 25.7 | 25.74 | 25.64 | 25.66 | 3463749.0 |
| 2005-10-31 11:30:00 | MSFT | Stock | 25.66 | 25.71 | 25.65 | 25.66 | 3951360.0 |
| 2005-10-31 12:00:00 | MSFT | Stock | 25.66 | 25.71 | 25.6 | 25.65 | 3693658.0 |
| 2005-10-31 12:30:00 | MSFT | Stock | 25.66 | 25.73 | 25.63 | 25.71 | 1956476.0 |
| 2005-10-31 13:00:00 | MSFT | Stock | 25.71 | 25.72 | 25.58 | 25.59 | 3895900.0 |
| 2005-10-31 13:30:00 | MSFT | Stock | 25.58 | 25.59 | 25.5 | 25.58 | 5313264.0 |
| 2005-10-31 14:00:00 | MSFT | Stock | 25.58 | 25.71 | 25.57 | 25.68 | 4887819.0 |
| 2005-10-31 14:30:00 | MSFT | Stock | 25.68 | 25.69 | 25.62 | 25.66 | 4184060.0 |
| 2005-10-31 15:00:00 | MSFT | Stock | 25.66 | 25.75 | 25.65 | 25.73 | 5869930.0 |
| 2005-10-31 15:30:00 | MSFT | Stock | 25.73 | 25.8 | 25.64 | 25.69 | 8593995.0 |
| 2005-10-31 16:00:00 | MSFT | Stock | 25.67 | 25.73 | 25.5 | 25.57 | 1525722.0 |
| 2005-10-31 16:30:00 | MSFT | Stock | 25.59 | 25.7 | 25.55 | 25.56 | 389884.0 |
| 2005-10-31 17:00:00 | MSFT | Stock | 25.56 | 25.7 | 25.55 | 25.59 | 305976.0 |
| 2005-10-31 17:30:00 | MSFT | Stock | 25.6 | 25.6 | 25.52 | 25.6 | 18600.0 |
| 2005-10-31 18:00:00 | MSFT | Stock | 25.59 | 25.59 | 25.56 | 25.57 | 6450.0 |
| 2005-10-31 09:00:00 | NVDA | Stock | 0.2712 | 0.2723 | 0.2708 | 0.2717 | 420000.0 |
| 2005-10-31 09:30:00 | NVDA | Stock | 0.2712 | 0.2742 | 0.2712 | 0.2733 | 38554560.0 |
| 2005-10-31 10:00:00 | NVDA | Stock | 0.2735 | 0.2766 | 0.2733 | 0.2759 | 50045400.0 |
| 2005-10-31 10:30:00 | NVDA | Stock | 0.2757 | 0.2766 | 0.2746 | 0.2753 | 30429600.0 |
| 2005-10-31 11:00:00 | NVDA | Stock | 0.2752 | 0.2767 | 0.275 | 0.276 | 21687000.0 |
| 2005-10-31 11:30:00 | NVDA | Stock | 0.276 | 0.2764 | 0.2752 | 0.2757 | 16778040.0 |
| 2005-10-31 12:00:00 | NVDA | Stock | 0.2757 | 0.2765 | 0.275 | 0.2762 | 13815240.0 |
> showing 50 of 46,758 rows — these rows as CSV