PREVIEW / stock_30min / 2004-11-02
file: by_date/stock_30min/2004/2004-11-02.parquet size: 784 KB rows: 41,615 symbols: 1,868
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-11-02 08:00:00 | AAPL | Stock | 0.9393 | 0.9402 | 0.9384 | 0.9393 | 230608.0 |
| 2004-11-02 08:30:00 | AAPL | Stock | 0.9402 | 0.9402 | 0.9384 | 0.9384 | 73976.0 |
| 2004-11-02 09:00:00 | AAPL | Stock | 0.9393 | 0.9436 | 0.9348 | 0.9355 | 3996664.0 |
| 2004-11-02 09:30:00 | AAPL | Stock | 0.9363 | 0.9427 | 0.9357 | 0.9393 | 85462160.0 |
| 2004-11-02 10:00:00 | AAPL | Stock | 0.9396 | 0.9439 | 0.9382 | 0.9434 | 68530000.0 |
| 2004-11-02 10:30:00 | AAPL | Stock | 0.9436 | 0.9464 | 0.9425 | 0.9461 | 56831824.0 |
| 2004-11-02 11:00:00 | AAPL | Stock | 0.9461 | 0.9477 | 0.9446 | 0.9457 | 36283296.0 |
| 2004-11-02 11:30:00 | AAPL | Stock | 0.9463 | 0.9473 | 0.9454 | 0.9463 | 25126192.0 |
| 2004-11-02 12:00:00 | AAPL | Stock | 0.9464 | 0.947 | 0.9455 | 0.9463 | 23596664.0 |
| 2004-11-02 12:30:00 | AAPL | Stock | 0.9466 | 0.9516 | 0.9459 | 0.9475 | 49650440.0 |
| 2004-11-02 13:00:00 | AAPL | Stock | 0.9475 | 0.9539 | 0.9471 | 0.9536 | 41144992.0 |
| 2004-11-02 13:30:00 | AAPL | Stock | 0.9536 | 0.9584 | 0.953 | 0.9552 | 44453976.0 |
| 2004-11-02 14:00:00 | AAPL | Stock | 0.9552 | 0.9633 | 0.9529 | 0.9609 | 47737536.0 |
| 2004-11-02 14:30:00 | AAPL | Stock | 0.9611 | 0.9657 | 0.9557 | 0.9605 | 74863040.0 |
| 2004-11-02 15:00:00 | AAPL | Stock | 0.9605 | 0.9613 | 0.9502 | 0.9516 | 78516088.0 |
| 2004-11-02 15:30:00 | AAPL | Stock | 0.9514 | 0.9563 | 0.9514 | 0.9532 | 64469104.0 |
| 2004-11-02 16:00:00 | AAPL | Stock | 0.9532 | 0.958 | 0.953 | 0.958 | 7551096.0 |
| 2004-11-02 16:30:00 | AAPL | Stock | 0.958 | 0.958 | 0.9554 | 0.958 | 210000.0 |
| 2004-11-02 17:30:00 | AAPL | Stock | 0.9442 | 0.958 | 0.9442 | 0.958 | 112056.0 |
| 2004-11-02 18:00:00 | AAPL | Stock | 0.9554 | 0.9588 | 0.9554 | 0.9588 | 114576.0 |
| 2004-11-02 08:00:00 | MSFT | Stock | 28.11 | 28.15 | 28.11 | 28.13 | 7100.0 |
| 2004-11-02 08:30:00 | MSFT | Stock | 28.13 | 28.13 | 28.12 | 28.13 | 700.0 |
| 2004-11-02 09:00:00 | MSFT | Stock | 28.12 | 28.24 | 28.08 | 28.24 | 354032.0 |
| 2004-11-02 09:30:00 | MSFT | Stock | 28.24 | 28.31 | 28.19 | 28.3 | 8687149.0 |
| 2004-11-02 10:00:00 | MSFT | Stock | 28.29 | 28.44 | 28.26 | 28.42 | 6883957.0 |
| 2004-11-02 10:30:00 | MSFT | Stock | 28.41 | 28.46 | 28.35 | 28.39 | 7328162.0 |
| 2004-11-02 11:00:00 | MSFT | Stock | 28.4 | 28.44 | 28.37 | 28.43 | 5311406.0 |
| 2004-11-02 11:30:00 | MSFT | Stock | 28.43 | 28.46 | 28.4 | 28.43 | 4071218.0 |
| 2004-11-02 12:00:00 | MSFT | Stock | 28.43 | 28.44 | 28.36 | 28.39 | 3494948.0 |
| 2004-11-02 12:30:00 | MSFT | Stock | 28.4 | 28.42 | 28.38 | 28.41 | 2887134.0 |
| 2004-11-02 13:00:00 | MSFT | Stock | 28.42 | 28.46 | 28.36 | 28.44 | 3479149.0 |
| 2004-11-02 13:30:00 | MSFT | Stock | 28.44 | 28.4464 | 28.3899 | 28.44 | 2127402.0 |
| 2004-11-02 14:00:00 | MSFT | Stock | 28.44 | 28.47 | 28.38 | 28.39 | 3768468.0 |
| 2004-11-02 14:30:00 | MSFT | Stock | 28.39 | 28.4 | 28.22 | 28.3 | 5648330.0 |
| 2004-11-02 15:00:00 | MSFT | Stock | 28.3 | 28.3 | 28.09 | 28.13 | 8745038.0 |
| 2004-11-02 15:30:00 | MSFT | Stock | 28.13 | 28.26 | 28.029 | 28.24 | 15009494.0 |
| 2004-11-02 16:00:00 | MSFT | Stock | 28.24 | 28.25 | 28.11 | 28.22 | 6258430.0 |
| 2004-11-02 16:30:00 | MSFT | Stock | 28.11 | 28.41 | 28.11 | 28.41 | 2594842.0 |
| 2004-11-02 17:00:00 | MSFT | Stock | 28.2 | 28.2 | 28.16 | 28.2 | 5360.0 |
| 2004-11-02 17:30:00 | MSFT | Stock | 28.2814 | 28.3163 | 28.11 | 28.11 | 34578.0 |
| 2004-11-02 18:00:00 | MSFT | Stock | 28.21 | 28.21 | 28.11 | 28.18 | 26314.0 |
| 2004-11-02 08:30:00 | NVDA | Stock | 0.1225 | 0.1225 | 0.1225 | 0.1225 | 138000.0 |
| 2004-11-02 09:00:00 | NVDA | Stock | 0.1225 | 0.1228 | 0.1222 | 0.1226 | 1252800.0 |
| 2004-11-02 09:30:00 | NVDA | Stock | 0.1224 | 0.1248 | 0.1218 | 0.1244 | 112071480.0 |
| 2004-11-02 10:00:00 | NVDA | Stock | 0.1244 | 0.1273 | 0.1243 | 0.1267 | 178749240.0 |
| 2004-11-02 10:30:00 | NVDA | Stock | 0.1267 | 0.127 | 0.126 | 0.1269 | 95067600.0 |
| 2004-11-02 11:00:00 | NVDA | Stock | 0.1268 | 0.1275 | 0.1266 | 0.1273 | 70433880.0 |
| 2004-11-02 11:30:00 | NVDA | Stock | 0.1274 | 0.1275 | 0.1262 | 0.1267 | 60542880.0 |
| 2004-11-02 12:00:00 | NVDA | Stock | 0.1267 | 0.127 | 0.1264 | 0.1267 | 23019120.0 |
| 2004-11-02 12:30:00 | NVDA | Stock | 0.1267 | 0.1269 | 0.1258 | 0.126 | 33104400.0 |
> showing 50 of 41,615 rows — these rows as CSV