PREVIEW / stock_30min / 2005-10-13
file: by_date/stock_30min/2005/2005-10-13.parquet size: 851 KB rows: 45,341 symbols: 2,087
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-13 07:30:00 | AAPL | Stock | 1.7589 | 1.7589 | 1.7589 | 1.7589 | 2800.0 |
| 2005-10-13 08:00:00 | AAPL | Stock | 1.7682 | 1.7775 | 1.7621 | 1.7675 | 896056.0 |
| 2005-10-13 08:30:00 | AAPL | Stock | 1.765 | 1.7704 | 1.7625 | 1.7664 | 1192632.0 |
| 2005-10-13 09:00:00 | AAPL | Stock | 1.7632 | 1.7721 | 1.7586 | 1.7689 | 3633868.0 |
| 2005-10-13 09:30:00 | AAPL | Stock | 1.7657 | 1.7896 | 1.7596 | 1.775 | 138362784.0 |
| 2005-10-13 10:00:00 | AAPL | Stock | 1.7746 | 1.8046 | 1.7689 | 1.8018 | 126578676.0 |
| 2005-10-13 10:30:00 | AAPL | Stock | 1.8014 | 1.8336 | 1.7657 | 1.8214 | 192325756.0 |
| 2005-10-13 11:00:00 | AAPL | Stock | 1.8214 | 1.8371 | 1.8196 | 1.8361 | 90544580.0 |
| 2005-10-13 11:30:00 | AAPL | Stock | 1.8364 | 1.84 | 1.8268 | 1.8375 | 118226556.0 |
| 2005-10-13 12:00:00 | AAPL | Stock | 1.8368 | 1.8493 | 1.8361 | 1.8411 | 100163196.0 |
| 2005-10-13 12:30:00 | AAPL | Stock | 1.8418 | 1.8775 | 1.8418 | 1.8604 | 174264412.0 |
| 2005-10-13 13:00:00 | AAPL | Stock | 1.86 | 1.8746 | 1.8393 | 1.8646 | 89006428.0 |
| 2005-10-13 13:30:00 | AAPL | Stock | 1.865 | 1.8825 | 1.86 | 1.8818 | 90796468.0 |
| 2005-10-13 14:00:00 | AAPL | Stock | 1.8818 | 1.9125 | 1.875 | 1.9 | 207978820.0 |
| 2005-10-13 14:30:00 | AAPL | Stock | 1.9 | 1.92 | 1.8989 | 1.9043 | 160021484.0 |
| 2005-10-13 15:00:00 | AAPL | Stock | 1.9057 | 1.9243 | 1.8929 | 1.9211 | 148759716.0 |
| 2005-10-13 15:30:00 | AAPL | Stock | 1.9204 | 1.9268 | 1.9075 | 1.9189 | 202449324.0 |
| 2005-10-13 16:00:00 | AAPL | Stock | 1.9161 | 1.925 | 1.8199 | 1.9214 | 8189384.0 |
| 2005-10-13 16:30:00 | AAPL | Stock | 1.9214 | 1.9257 | 1.92 | 1.9218 | 658700.0 |
| 2005-10-13 17:00:00 | AAPL | Stock | 1.9221 | 1.9239 | 1.9207 | 1.9214 | 367808.0 |
| 2005-10-13 17:30:00 | AAPL | Stock | 1.9207 | 1.9214 | 1.9132 | 1.9196 | 1161776.0 |
| 2005-10-13 18:00:00 | AAPL | Stock | 1.9196 | 1.9232 | 1.9154 | 1.9218 | 592760.0 |
| 2005-10-13 08:00:00 | MSFT | Stock | 24.35 | 24.37 | 24.35 | 24.35 | 1600.0 |
| 2005-10-13 08:30:00 | MSFT | Stock | 24.34 | 24.34 | 24.31 | 24.34 | 3560.0 |
| 2005-10-13 09:00:00 | MSFT | Stock | 24.35 | 24.37 | 24.27 | 24.31 | 47053.0 |
| 2005-10-13 09:30:00 | MSFT | Stock | 24.31 | 24.49 | 24.268 | 24.45 | 8895753.0 |
| 2005-10-13 10:00:00 | MSFT | Stock | 24.46 | 24.58 | 24.42 | 24.54 | 5722755.0 |
| 2005-10-13 10:30:00 | MSFT | Stock | 24.53 | 24.58 | 24.45 | 24.52 | 4375878.0 |
| 2005-10-13 11:00:00 | MSFT | Stock | 24.52 | 24.61 | 24.51 | 24.57 | 5862109.0 |
| 2005-10-13 11:30:00 | MSFT | Stock | 24.58 | 24.62 | 24.44 | 24.49 | 4553735.0 |
| 2005-10-13 12:00:00 | MSFT | Stock | 24.49 | 24.6 | 24.44 | 24.47 | 4078183.0 |
| 2005-10-13 12:30:00 | MSFT | Stock | 24.46 | 24.61 | 24.46 | 24.6 | 4293996.0 |
| 2005-10-13 13:00:00 | MSFT | Stock | 24.6 | 24.62 | 24.53 | 24.6 | 3088096.0 |
| 2005-10-13 13:30:00 | MSFT | Stock | 24.59 | 24.65 | 24.55 | 24.6 | 4514001.0 |
| 2005-10-13 14:00:00 | MSFT | Stock | 24.6 | 24.69 | 24.59 | 24.64 | 4708957.0 |
| 2005-10-13 14:30:00 | MSFT | Stock | 24.64 | 24.73 | 24.6 | 24.6 | 5670180.0 |
| 2005-10-13 15:00:00 | MSFT | Stock | 24.6 | 24.65 | 24.57 | 24.61 | 5240444.0 |
| 2005-10-13 15:30:00 | MSFT | Stock | 24.61 | 24.71 | 24.589 | 24.59 | 7312223.0 |
| 2005-10-13 16:00:00 | MSFT | Stock | 24.59 | 24.635 | 24.55 | 24.59 | 153082.0 |
| 2005-10-13 16:30:00 | MSFT | Stock | 24.59 | 24.59 | 24.59 | 24.59 | 905.0 |
| 2005-10-13 17:00:00 | MSFT | Stock | 24.59 | 24.59 | 24.58 | 24.58 | 515.0 |
| 2005-10-13 17:30:00 | MSFT | Stock | 24.6 | 24.6 | 24.58 | 24.58 | 193915.0 |
| 2005-10-13 18:00:00 | MSFT | Stock | 24.58 | 24.58 | 24.58 | 24.58 | 737.0 |
| 2005-10-13 08:30:00 | NVDA | Stock | 0.2675 | 0.2677 | 0.2667 | 0.2677 | 240000.0 |
| 2005-10-13 09:00:00 | NVDA | Stock | 0.2677 | 0.2677 | 0.267 | 0.267 | 156000.0 |
| 2005-10-13 09:30:00 | NVDA | Stock | 0.2677 | 0.2677 | 0.2605 | 0.2618 | 85436040.0 |
| 2005-10-13 10:00:00 | NVDA | Stock | 0.262 | 0.2636 | 0.2612 | 0.263 | 41166000.0 |
| 2005-10-13 10:30:00 | NVDA | Stock | 0.263 | 0.2642 | 0.2626 | 0.2638 | 24029640.0 |
| 2005-10-13 11:00:00 | NVDA | Stock | 0.2638 | 0.2643 | 0.2636 | 0.2639 | 10119840.0 |
| 2005-10-13 11:30:00 | NVDA | Stock | 0.2639 | 0.2642 | 0.2607 | 0.2609 | 17809080.0 |
> showing 50 of 45,341 rows — these rows as CSV