PREVIEW / stock_30min / 2004-07-20
file: by_date/stock_30min/2004/2004-07-20.parquet size: 783 KB rows: 42,657 symbols: 1,800
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 |
|---|---|---|---|---|---|---|---|
| 2004-07-20 09:00:00 | AAPL | Stock | 0.5709 | 0.5713 | 0.5705 | 0.5705 | 467824.0 |
| 2004-07-20 09:30:00 | AAPL | Stock | 0.5702 | 0.5707 | 0.5634 | 0.5661 | 39560192.0 |
| 2004-07-20 10:00:00 | AAPL | Stock | 0.5659 | 0.5682 | 0.565 | 0.5663 | 15072176.0 |
| 2004-07-20 10:30:00 | AAPL | Stock | 0.5663 | 0.5677 | 0.5643 | 0.5671 | 19963944.0 |
| 2004-07-20 11:00:00 | AAPL | Stock | 0.567 | 0.5688 | 0.567 | 0.5682 | 11901344.0 |
| 2004-07-20 11:30:00 | AAPL | Stock | 0.5682 | 0.5714 | 0.567 | 0.5705 | 23193408.0 |
| 2004-07-20 12:00:00 | AAPL | Stock | 0.5705 | 0.5723 | 0.5705 | 0.5721 | 16823632.0 |
| 2004-07-20 12:30:00 | AAPL | Stock | 0.5721 | 0.5725 | 0.5705 | 0.5709 | 10504816.0 |
| 2004-07-20 13:00:00 | AAPL | Stock | 0.5709 | 0.5723 | 0.5709 | 0.5715 | 6225912.0 |
| 2004-07-20 13:30:00 | AAPL | Stock | 0.5716 | 0.572 | 0.5711 | 0.5716 | 16637152.0 |
| 2004-07-20 14:00:00 | AAPL | Stock | 0.5716 | 0.5739 | 0.5714 | 0.5734 | 13534080.0 |
| 2004-07-20 14:30:00 | AAPL | Stock | 0.5734 | 0.5739 | 0.5713 | 0.5714 | 36055768.0 |
| 2004-07-20 15:00:00 | AAPL | Stock | 0.5714 | 0.573 | 0.5713 | 0.573 | 22500632.0 |
| 2004-07-20 15:30:00 | AAPL | Stock | 0.5727 | 0.5746 | 0.5723 | 0.5746 | 19515608.0 |
| 2004-07-20 16:00:00 | AAPL | Stock | 0.5746 | 0.5752 | 0.5736 | 0.575 | 4560304.0 |
| 2004-07-20 16:30:00 | AAPL | Stock | 0.575 | 0.5768 | 0.575 | 0.575 | 60088.0 |
| 2004-07-20 17:00:00 | AAPL | Stock | 0.5777 | 0.5782 | 0.5643 | 0.5782 | 11359040.0 |
| 2004-07-20 17:30:00 | AAPL | Stock | 0.5782 | 0.58 | 0.5782 | 0.58 | 56000.0 |
| 2004-07-20 18:00:00 | AAPL | Stock | 0.5795 | 0.5795 | 0.5786 | 0.5786 | 78400.0 |
| 2004-07-20 08:00:00 | MSFT | Stock | 27.9 | 28.08 | 27.9 | 28.0787 | 19343.0 |
| 2004-07-20 08:30:00 | MSFT | Stock | 28.05 | 28.0787 | 28.0143 | 28.0143 | 16970.0 |
| 2004-07-20 09:00:00 | MSFT | Stock | 27.95 | 28.06 | 27.95 | 28.03 | 272190.0 |
| 2004-07-20 09:30:00 | MSFT | Stock | 28.01 | 28.04 | 27.91 | 27.94 | 6673406.0 |
| 2004-07-20 10:00:00 | MSFT | Stock | 27.94 | 28.0 | 27.86 | 27.93 | 3461117.0 |
| 2004-07-20 10:30:00 | MSFT | Stock | 27.93 | 28.05 | 27.9 | 28.04 | 4972826.0 |
| 2004-07-20 11:00:00 | MSFT | Stock | 28.04 | 28.05 | 27.98 | 28.01 | 3439820.0 |
| 2004-07-20 11:30:00 | MSFT | Stock | 28.01 | 28.25 | 28.0 | 28.19 | 5077883.0 |
| 2004-07-20 12:00:00 | MSFT | Stock | 28.19 | 28.33 | 28.17 | 28.26 | 4496399.0 |
| 2004-07-20 12:30:00 | MSFT | Stock | 28.265 | 28.38 | 28.26 | 28.34 | 3211693.0 |
| 2004-07-20 13:00:00 | MSFT | Stock | 28.34 | 28.4 | 28.27 | 28.34 | 3744844.0 |
| 2004-07-20 13:30:00 | MSFT | Stock | 28.34 | 28.48 | 28.32 | 28.44 | 4069611.0 |
| 2004-07-20 14:00:00 | MSFT | Stock | 28.439 | 28.44 | 28.31 | 28.35 | 4533450.0 |
| 2004-07-20 14:30:00 | MSFT | Stock | 28.35 | 28.37 | 28.11 | 28.15 | 6791878.0 |
| 2004-07-20 15:00:00 | MSFT | Stock | 28.15 | 28.32 | 28.15 | 28.27 | 5448852.0 |
| 2004-07-20 15:30:00 | MSFT | Stock | 28.27 | 28.31 | 28.19 | 28.3 | 4900454.0 |
| 2004-07-20 16:00:00 | MSFT | Stock | 28.29 | 29.71 | 28.1787 | 29.2 | 15213091.0 |
| 2004-07-20 16:30:00 | MSFT | Stock | 29.19 | 29.71 | 28.32 | 29.45 | 5009609.0 |
| 2004-07-20 17:00:00 | MSFT | Stock | 29.45 | 29.73 | 27.95 | 29.68 | 3218497.0 |
| 2004-07-20 17:30:00 | MSFT | Stock | 29.69 | 29.94 | 29.67 | 29.8 | 1085167.0 |
| 2004-07-20 18:00:00 | MSFT | Stock | 29.8 | 29.87 | 29.7 | 29.8 | 571872.0 |
| 2004-07-20 18:30:00 | MSFT | Stock | 29.8 | 29.81 | 29.8 | 29.81 | 754.0 |
| 2004-07-20 09:00:00 | NVDA | Stock | 0.1279 | 0.1287 | 0.1275 | 0.1287 | 3143040.0 |
| 2004-07-20 09:30:00 | NVDA | Stock | 0.1278 | 0.1289 | 0.1274 | 0.1281 | 32218440.0 |
| 2004-07-20 10:00:00 | NVDA | Stock | 0.1279 | 0.1279 | 0.1266 | 0.1271 | 18912000.0 |
| 2004-07-20 10:30:00 | NVDA | Stock | 0.1269 | 0.1277 | 0.1268 | 0.1269 | 16117680.0 |
| 2004-07-20 11:00:00 | NVDA | Stock | 0.127 | 0.1277 | 0.1267 | 0.1276 | 23422920.0 |
| 2004-07-20 11:30:00 | NVDA | Stock | 0.1276 | 0.1294 | 0.1274 | 0.1294 | 24444720.0 |
| 2004-07-20 12:00:00 | NVDA | Stock | 0.1292 | 0.1293 | 0.1284 | 0.1289 | 10827120.0 |
| 2004-07-20 12:30:00 | NVDA | Stock | 0.1288 | 0.1289 | 0.128 | 0.128 | 19801920.0 |
| 2004-07-20 13:00:00 | NVDA | Stock | 0.1279 | 0.129 | 0.1279 | 0.1287 | 22918320.0 |
> showing 50 of 42,657 rows — these rows as CSV