PREVIEW / stock_1hour / 2002-09-26
file: by_date/stock_1hour/2002/2002-09-26.parquet size: 391 KB rows: 18,773 symbols: 1,482
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-09-26 09:00:00 | AAPL | Stock | 0.2684 | 0.2713 | 0.2671 | 0.2696 | 25081392.0 |
| 2002-09-26 10:00:00 | AAPL | Stock | 0.2698 | 0.2707 | 0.2609 | 0.2636 | 54759992.0 |
| 2002-09-26 11:00:00 | AAPL | Stock | 0.2636 | 0.2655 | 0.2625 | 0.2643 | 17930360.0 |
| 2002-09-26 12:00:00 | AAPL | Stock | 0.2643 | 0.2643 | 0.2614 | 0.2625 | 21012544.0 |
| 2002-09-26 13:00:00 | AAPL | Stock | 0.2625 | 0.2627 | 0.2598 | 0.2606 | 29042328.0 |
| 2002-09-26 14:00:00 | AAPL | Stock | 0.2607 | 0.265 | 0.2598 | 0.2636 | 20867280.0 |
| 2002-09-26 15:00:00 | AAPL | Stock | 0.2639 | 0.2654 | 0.2614 | 0.2623 | 26443480.0 |
| 2002-09-26 16:00:00 | AAPL | Stock | 0.2623 | 0.2634 | 0.2607 | 0.2625 | 3163104.0 |
| 2002-09-26 17:00:00 | AAPL | Stock | 0.2625 | 0.2625 | 0.2625 | 0.2625 | 548800.0 |
| 2002-09-26 08:00:00 | MSFT | Stock | 23.275 | 23.575 | 23.275 | 23.55 | 101294.0 |
| 2002-09-26 09:00:00 | MSFT | Stock | 23.55 | 23.685 | 23.255 | 23.6 | 17229302.0 |
| 2002-09-26 10:00:00 | MSFT | Stock | 23.595 | 23.75 | 23.225 | 23.42 | 18220874.0 |
| 2002-09-26 11:00:00 | MSFT | Stock | 23.415 | 23.62 | 23.345 | 23.345 | 10089162.0 |
| 2002-09-26 12:00:00 | MSFT | Stock | 23.3555 | 23.395 | 23.025 | 23.145 | 12850584.0 |
| 2002-09-26 13:00:00 | MSFT | Stock | 23.1465 | 23.2305 | 22.98 | 23.189 | 12382292.0 |
| 2002-09-26 14:00:00 | MSFT | Stock | 23.195 | 23.2925 | 23.03 | 23.157 | 11587032.0 |
| 2002-09-26 15:00:00 | MSFT | Stock | 23.158 | 23.35 | 22.975 | 23.1 | 15532934.0 |
| 2002-09-26 16:00:00 | MSFT | Stock | 23.095 | 23.13 | 22.95 | 22.95 | 1355568.0 |
| 2002-09-26 17:00:00 | MSFT | Stock | 22.975 | 23.1 | 22.975 | 22.975 | 113354.0 |
| 2002-09-26 18:00:00 | MSFT | Stock | 22.975 | 22.975 | 22.95 | 22.95 | 18546.0 |
| 2002-09-26 08:00:00 | NVDA | Stock | 0.0781 | 0.0804 | 0.0781 | 0.08 | 3090000.0 |
| 2002-09-26 09:00:00 | NVDA | Stock | 0.0809 | 0.0809 | 0.0771 | 0.0779 | 108810840.0 |
| 2002-09-26 10:00:00 | NVDA | Stock | 0.0779 | 0.0789 | 0.0766 | 0.0769 | 143486280.0 |
| 2002-09-26 11:00:00 | NVDA | Stock | 0.077 | 0.0776 | 0.0758 | 0.0761 | 55979160.0 |
| 2002-09-26 12:00:00 | NVDA | Stock | 0.0761 | 0.0762 | 0.0731 | 0.074 | 110019480.0 |
| 2002-09-26 13:00:00 | NVDA | Stock | 0.074 | 0.0744 | 0.0737 | 0.0738 | 67242360.0 |
| 2002-09-26 14:00:00 | NVDA | Stock | 0.0739 | 0.0752 | 0.0727 | 0.075 | 115549440.0 |
| 2002-09-26 15:00:00 | NVDA | Stock | 0.075 | 0.0758 | 0.0735 | 0.0739 | 119181120.0 |
| 2002-09-26 16:00:00 | NVDA | Stock | 0.0737 | 0.0741 | 0.0725 | 0.0739 | 12382920.0 |
| 2002-09-26 17:00:00 | NVDA | Stock | 0.0725 | 0.0739 | 0.072 | 0.0727 | 748800.0 |
| 2002-09-26 18:00:00 | NVDA | Stock | 0.0727 | 0.0727 | 0.0727 | 0.0727 | 252000.0 |
| 2002-09-26 08:00:00 | AMZN | Stock | 0.7925 | 0.799 | 0.7925 | 0.795 | 56000.0 |
| 2002-09-26 09:00:00 | AMZN | Stock | 0.795 | 0.8055 | 0.786 | 0.797 | 18028580.0 |
| 2002-09-26 10:00:00 | AMZN | Stock | 0.797 | 0.818 | 0.797 | 0.813 | 33124720.0 |
| 2002-09-26 11:00:00 | AMZN | Stock | 0.813 | 0.8255 | 0.8115 | 0.821 | 21778780.0 |
| 2002-09-26 12:00:00 | AMZN | Stock | 0.821 | 0.828 | 0.82 | 0.8225 | 34516680.0 |
| 2002-09-26 13:00:00 | AMZN | Stock | 0.8225 | 0.831 | 0.8165 | 0.8295 | 32926700.0 |
| 2002-09-26 14:00:00 | AMZN | Stock | 0.8295 | 0.84 | 0.8265 | 0.839 | 19493060.0 |
| 2002-09-26 15:00:00 | AMZN | Stock | 0.839 | 0.8675 | 0.839 | 0.8555 | 59854580.0 |
| 2002-09-26 16:00:00 | AMZN | Stock | 0.854 | 0.86 | 0.85 | 0.85 | 2534000.0 |
| 2002-09-26 17:00:00 | AMZN | Stock | 0.8525 | 0.8575 | 0.849 | 0.8575 | 375140.0 |
| 2002-09-26 18:00:00 | AMZN | Stock | 0.849 | 0.849 | 0.849 | 0.849 | 8000.0 |
| 2002-09-26 09:00:00 | CL | Stock | 26.9 | 26.99 | 26.83 | 26.96 | 276400.0 |
| 2002-09-26 10:00:00 | CL | Stock | 26.965 | 27.175 | 26.965 | 27.175 | 490600.0 |
| 2002-09-26 11:00:00 | CL | Stock | 27.16 | 27.625 | 27.15 | 27.54 | 798200.0 |
| 2002-09-26 12:00:00 | CL | Stock | 27.54 | 27.8 | 27.53 | 27.77 | 658000.0 |
| 2002-09-26 13:00:00 | CL | Stock | 27.765 | 27.775 | 27.625 | 27.65 | 554400.0 |
| 2002-09-26 14:00:00 | CL | Stock | 27.63 | 27.71 | 27.525 | 27.64 | 430200.0 |
| 2002-09-26 15:00:00 | CL | Stock | 27.61 | 27.825 | 27.61 | 27.76 | 759800.0 |
| 2002-09-26 16:00:00 | CL | Stock | 27.76 | 27.775 | 27.76 | 27.76 | 176000.0 |
> showing 50 of 18,773 rows — these rows as CSV