PREVIEW / stock_1hour / 2002-02-04
file: by_date/stock_1hour/2002/2002-02-04.parquet size: 380 KB rows: 18,384 symbols: 1,397
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 |
|---|---|---|---|---|---|---|---|
| 2002-02-04 08:00:00 | AAPL | Stock | 0.4339 | 0.4366 | 0.433 | 0.433 | 84000.0 |
| 2002-02-04 09:00:00 | AAPL | Stock | 0.4359 | 0.4404 | 0.4321 | 0.4398 | 33510400.0 |
| 2002-02-04 10:00:00 | AAPL | Stock | 0.4404 | 0.4464 | 0.4389 | 0.4446 | 73662400.0 |
| 2002-02-04 11:00:00 | AAPL | Stock | 0.4446 | 0.4463 | 0.442 | 0.445 | 50209600.0 |
| 2002-02-04 12:00:00 | AAPL | Stock | 0.445 | 0.4471 | 0.4439 | 0.4461 | 78512000.0 |
| 2002-02-04 13:00:00 | AAPL | Stock | 0.4459 | 0.4464 | 0.4425 | 0.4459 | 39765600.0 |
| 2002-02-04 14:00:00 | AAPL | Stock | 0.4455 | 0.4509 | 0.4446 | 0.45 | 73589600.0 |
| 2002-02-04 15:00:00 | AAPL | Stock | 0.4505 | 0.4556 | 0.4466 | 0.4525 | 122662400.0 |
| 2002-02-04 16:00:00 | AAPL | Stock | 0.4527 | 0.4607 | 0.4525 | 0.4554 | 13636000.0 |
| 2002-02-04 17:00:00 | AAPL | Stock | 0.4527 | 0.4616 | 0.4527 | 0.4571 | 1388800.0 |
| 2002-02-04 18:00:00 | AAPL | Stock | 0.4571 | 0.4571 | 0.4571 | 0.4571 | 11200.0 |
| 2002-02-04 08:00:00 | MSFT | Stock | 31.05 | 31.3325 | 30.88 | 31.095 | 82000.0 |
| 2002-02-04 09:00:00 | MSFT | Stock | 31.1 | 31.35 | 30.95 | 31.265 | 5683000.0 |
| 2002-02-04 10:00:00 | MSFT | Stock | 31.265 | 31.345 | 30.825 | 30.855 | 12735600.0 |
| 2002-02-04 11:00:00 | MSFT | Stock | 30.855 | 30.925 | 30.585 | 30.64 | 7991400.0 |
| 2002-02-04 12:00:00 | MSFT | Stock | 30.64 | 30.76 | 30.585 | 30.595 | 8624200.0 |
| 2002-02-04 13:00:00 | MSFT | Stock | 30.6005 | 30.725 | 30.5355 | 30.665 | 6970400.0 |
| 2002-02-04 14:00:00 | MSFT | Stock | 30.675 | 30.79 | 30.5295 | 30.54 | 7593600.0 |
| 2002-02-04 15:00:00 | MSFT | Stock | 30.545 | 30.585 | 30.375 | 30.57 | 16042800.0 |
| 2002-02-04 16:00:00 | MSFT | Stock | 30.575 | 30.772 | 30.53 | 30.65 | 2484800.0 |
| 2002-02-04 17:00:00 | MSFT | Stock | 30.605 | 30.635 | 30.56 | 30.6 | 170600.0 |
| 2002-02-04 18:00:00 | MSFT | Stock | 30.605 | 30.605 | 30.605 | 30.605 | 2000.0 |
| 2002-02-04 08:00:00 | NVDA | Stock | 0.5415 | 0.5507 | 0.5296 | 0.5297 | 1380000.0 |
| 2002-02-04 09:00:00 | NVDA | Stock | 0.5297 | 0.5507 | 0.5275 | 0.5328 | 131544000.0 |
| 2002-02-04 10:00:00 | NVDA | Stock | 0.5327 | 0.5373 | 0.5292 | 0.5296 | 173340000.0 |
| 2002-02-04 11:00:00 | NVDA | Stock | 0.5296 | 0.5296 | 0.5126 | 0.5132 | 237108000.0 |
| 2002-02-04 12:00:00 | NVDA | Stock | 0.5132 | 0.5221 | 0.5117 | 0.5175 | 137376000.0 |
| 2002-02-04 13:00:00 | NVDA | Stock | 0.5177 | 0.5197 | 0.5125 | 0.519 | 98064000.0 |
| 2002-02-04 14:00:00 | NVDA | Stock | 0.5189 | 0.5232 | 0.5147 | 0.5172 | 102048000.0 |
| 2002-02-04 15:00:00 | NVDA | Stock | 0.5174 | 0.5182 | 0.5087 | 0.5092 | 166248000.0 |
| 2002-02-04 16:00:00 | NVDA | Stock | 0.5092 | 0.5224 | 0.5077 | 0.5083 | 20088000.0 |
| 2002-02-04 17:00:00 | NVDA | Stock | 0.5077 | 0.5223 | 0.5073 | 0.5083 | 6732000.0 |
| 2002-02-04 18:00:00 | NVDA | Stock | 0.5072 | 0.5083 | 0.5072 | 0.5082 | 60000.0 |
| 2002-02-04 08:00:00 | AMZN | Stock | 0.6625 | 0.686 | 0.6175 | 0.6375 | 4036000.0 |
| 2002-02-04 09:00:00 | AMZN | Stock | 0.6375 | 0.67 | 0.6216 | 0.6305 | 69904000.0 |
| 2002-02-04 10:00:00 | AMZN | Stock | 0.63 | 0.6545 | 0.6275 | 0.649 | 63272000.0 |
| 2002-02-04 11:00:00 | AMZN | Stock | 0.6495 | 0.652 | 0.6275 | 0.63 | 47388000.0 |
| 2002-02-04 12:00:00 | AMZN | Stock | 0.63 | 0.6415 | 0.6215 | 0.639 | 44338000.0 |
| 2002-02-04 13:00:00 | AMZN | Stock | 0.639 | 0.6505 | 0.6315 | 0.6415 | 36402000.0 |
| 2002-02-04 14:00:00 | AMZN | Stock | 0.641 | 0.6485 | 0.6315 | 0.632 | 16640000.0 |
| 2002-02-04 15:00:00 | AMZN | Stock | 0.632 | 0.636 | 0.6225 | 0.6265 | 61344000.0 |
| 2002-02-04 16:00:00 | AMZN | Stock | 0.627 | 0.6358 | 0.619 | 0.6265 | 5344000.0 |
| 2002-02-04 17:00:00 | AMZN | Stock | 0.6265 | 0.6265 | 0.621 | 0.6215 | 562000.0 |
| 2002-02-04 18:00:00 | AMZN | Stock | 0.6225 | 0.6225 | 0.6225 | 0.6225 | 36000.0 |
| 2002-02-04 09:00:00 | CL | Stock | 28.575 | 28.575 | 28.375 | 28.42 | 220600.0 |
| 2002-02-04 10:00:00 | CL | Stock | 28.425 | 28.625 | 28.39 | 28.615 | 419000.0 |
| 2002-02-04 11:00:00 | CL | Stock | 28.615 | 28.75 | 28.525 | 28.55 | 501600.0 |
| 2002-02-04 12:00:00 | CL | Stock | 28.53 | 28.69 | 28.45 | 28.45 | 290000.0 |
| 2002-02-04 13:00:00 | CL | Stock | 28.45 | 28.45 | 28.255 | 28.365 | 393600.0 |
| 2002-02-04 14:00:00 | CL | Stock | 28.36 | 28.365 | 28.135 | 28.14 | 337400.0 |
> showing 50 of 18,384 rows — these rows as CSV