PREVIEW / stock_1hour / 2002-10-03
file: by_date/stock_1hour/2002/2002-10-03.parquet size: 407 KB rows: 19,371 symbols: 1,485
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-10-03 08:00:00 | AAPL | Stock | 0.2529 | 0.2529 | 0.2521 | 0.2529 | 369600.0 |
| 2002-10-03 09:00:00 | AAPL | Stock | 0.2527 | 0.2551 | 0.2511 | 0.2545 | 26007968.0 |
| 2002-10-03 10:00:00 | AAPL | Stock | 0.2544 | 0.2591 | 0.2539 | 0.2545 | 43325576.0 |
| 2002-10-03 11:00:00 | AAPL | Stock | 0.2545 | 0.2554 | 0.2529 | 0.2539 | 28488376.0 |
| 2002-10-03 12:00:00 | AAPL | Stock | 0.2539 | 0.255 | 0.2525 | 0.2536 | 13673688.0 |
| 2002-10-03 13:00:00 | AAPL | Stock | 0.2536 | 0.2554 | 0.2529 | 0.2545 | 17488464.0 |
| 2002-10-03 14:00:00 | AAPL | Stock | 0.2546 | 0.2584 | 0.2543 | 0.2573 | 30587088.0 |
| 2002-10-03 15:00:00 | AAPL | Stock | 0.2571 | 0.26 | 0.2546 | 0.2554 | 46735640.0 |
| 2002-10-03 16:00:00 | AAPL | Stock | 0.2552 | 0.2554 | 0.2534 | 0.2534 | 3320800.0 |
| 2002-10-03 17:00:00 | AAPL | Stock | 0.2527 | 0.2554 | 0.2527 | 0.2554 | 526400.0 |
| 2002-10-03 08:00:00 | MSFT | Stock | 22.375 | 22.8155 | 22.375 | 22.795 | 57040.0 |
| 2002-10-03 09:00:00 | MSFT | Stock | 22.805 | 22.8625 | 22.58 | 22.685 | 10745336.0 |
| 2002-10-03 10:00:00 | MSFT | Stock | 22.706 | 23.297 | 22.65 | 22.825 | 19962716.0 |
| 2002-10-03 11:00:00 | MSFT | Stock | 22.815 | 22.89 | 22.385 | 22.605 | 18115362.0 |
| 2002-10-03 12:00:00 | MSFT | Stock | 22.61 | 22.64 | 22.335 | 22.575 | 8872206.0 |
| 2002-10-03 13:00:00 | MSFT | Stock | 22.565 | 22.756 | 22.375 | 22.5655 | 11540350.0 |
| 2002-10-03 14:00:00 | MSFT | Stock | 22.575 | 22.88 | 22.485 | 22.716 | 15257586.0 |
| 2002-10-03 15:00:00 | MSFT | Stock | 22.7155 | 23.03 | 22.3 | 22.36 | 17388768.0 |
| 2002-10-03 16:00:00 | MSFT | Stock | 22.36 | 22.985 | 22.25 | 22.275 | 1926018.0 |
| 2002-10-03 17:00:00 | MSFT | Stock | 22.265 | 22.92 | 22.265 | 22.295 | 115860.0 |
| 2002-10-03 18:00:00 | MSFT | Stock | 22.33 | 22.7137 | 22.32 | 22.32 | 31800.0 |
| 2002-10-03 08:00:00 | NVDA | Stock | 0.075 | 0.075 | 0.075 | 0.075 | 84000.0 |
| 2002-10-03 09:00:00 | NVDA | Stock | 0.075 | 0.0754 | 0.0709 | 0.0737 | 108100560.0 |
| 2002-10-03 10:00:00 | NVDA | Stock | 0.0737 | 0.0754 | 0.0721 | 0.0724 | 138824160.0 |
| 2002-10-03 11:00:00 | NVDA | Stock | 0.0725 | 0.0739 | 0.0712 | 0.0737 | 71371200.0 |
| 2002-10-03 12:00:00 | NVDA | Stock | 0.0737 | 0.0737 | 0.0721 | 0.0727 | 41219280.0 |
| 2002-10-03 13:00:00 | NVDA | Stock | 0.0727 | 0.0736 | 0.0724 | 0.0726 | 45806880.0 |
| 2002-10-03 14:00:00 | NVDA | Stock | 0.0725 | 0.0739 | 0.0723 | 0.073 | 68867280.0 |
| 2002-10-03 15:00:00 | NVDA | Stock | 0.073 | 0.0741 | 0.0712 | 0.0713 | 101479560.0 |
| 2002-10-03 16:00:00 | NVDA | Stock | 0.0713 | 0.0722 | 0.0712 | 0.0714 | 10290000.0 |
| 2002-10-03 17:00:00 | NVDA | Stock | 0.0724 | 0.0724 | 0.0709 | 0.0709 | 1056000.0 |
| 2002-10-03 18:00:00 | NVDA | Stock | 0.0709 | 0.0714 | 0.0709 | 0.0709 | 243000.0 |
| 2002-10-03 08:00:00 | AMZN | Stock | 0.843 | 0.845 | 0.825 | 0.845 | 517000.0 |
| 2002-10-03 09:00:00 | AMZN | Stock | 0.8446 | 0.8495 | 0.835 | 0.8405 | 10243860.0 |
| 2002-10-03 10:00:00 | AMZN | Stock | 0.841 | 0.8625 | 0.8405 | 0.8475 | 24935620.0 |
| 2002-10-03 11:00:00 | AMZN | Stock | 0.8475 | 0.852 | 0.8455 | 0.846 | 10581280.0 |
| 2002-10-03 12:00:00 | AMZN | Stock | 0.846 | 0.8475 | 0.833 | 0.8395 | 21408260.0 |
| 2002-10-03 13:00:00 | AMZN | Stock | 0.8395 | 0.85 | 0.8345 | 0.8435 | 21066980.0 |
| 2002-10-03 14:00:00 | AMZN | Stock | 0.8435 | 0.8515 | 0.842 | 0.8475 | 11138280.0 |
| 2002-10-03 15:00:00 | AMZN | Stock | 0.8475 | 0.8535 | 0.838 | 0.8385 | 20232980.0 |
| 2002-10-03 16:00:00 | AMZN | Stock | 0.8395 | 0.8485 | 0.8355 | 0.8365 | 3362000.0 |
| 2002-10-03 17:00:00 | AMZN | Stock | 0.84 | 0.84 | 0.8365 | 0.8365 | 500000.0 |
| 2002-10-03 18:00:00 | AMZN | Stock | 0.839 | 0.84 | 0.839 | 0.84 | 16000.0 |
| 2002-10-03 09:00:00 | CL | Stock | 27.0 | 27.045 | 26.94 | 26.995 | 563200.0 |
| 2002-10-03 10:00:00 | CL | Stock | 27.0 | 27.27 | 26.97 | 26.97 | 796600.0 |
| 2002-10-03 11:00:00 | CL | Stock | 26.96 | 27.185 | 26.85 | 27.18 | 457800.0 |
| 2002-10-03 12:00:00 | CL | Stock | 27.185 | 27.215 | 27.0 | 27.145 | 389200.0 |
| 2002-10-03 13:00:00 | CL | Stock | 27.16 | 27.225 | 27.0 | 27.075 | 333800.0 |
| 2002-10-03 14:00:00 | CL | Stock | 27.07 | 27.215 | 27.035 | 27.16 | 349000.0 |
| 2002-10-03 15:00:00 | CL | Stock | 27.155 | 27.275 | 27.04 | 27.075 | 618600.0 |
> showing 50 of 19,371 rows — these rows as CSV