PREVIEW / stock_1hour / 2002-10-02
file: by_date/stock_1hour/2002/2002-10-02.parquet size: 413 KB rows: 19,539 symbols: 1,481
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-02 08:00:00 | AAPL | Stock | 0.2591 | 0.2591 | 0.2559 | 0.2566 | 341600.0 |
| 2002-10-02 09:00:00 | AAPL | Stock | 0.257 | 0.2571 | 0.2529 | 0.2529 | 40281752.0 |
| 2002-10-02 10:00:00 | AAPL | Stock | 0.253 | 0.2563 | 0.2527 | 0.2552 | 34543768.0 |
| 2002-10-02 11:00:00 | AAPL | Stock | 0.255 | 0.2571 | 0.2532 | 0.257 | 26250728.0 |
| 2002-10-02 12:00:00 | AAPL | Stock | 0.257 | 0.2613 | 0.255 | 0.2595 | 27354712.0 |
| 2002-10-02 13:00:00 | AAPL | Stock | 0.2595 | 0.2602 | 0.255 | 0.2561 | 17242568.0 |
| 2002-10-02 14:00:00 | AAPL | Stock | 0.2561 | 0.2563 | 0.2527 | 0.2541 | 26052208.0 |
| 2002-10-02 15:00:00 | AAPL | Stock | 0.2543 | 0.255 | 0.2518 | 0.2529 | 39418568.0 |
| 2002-10-02 16:00:00 | AAPL | Stock | 0.253 | 0.2539 | 0.2504 | 0.2539 | 6468000.0 |
| 2002-10-02 17:00:00 | AAPL | Stock | 0.253 | 0.253 | 0.25 | 0.25 | 817600.0 |
| 2002-10-02 18:00:00 | AAPL | Stock | 0.253 | 0.253 | 0.253 | 0.253 | 16800.0 |
| 2002-10-02 08:00:00 | MSFT | Stock | 23.18 | 23.45 | 22.98 | 23.095 | 330858.0 |
| 2002-10-02 09:00:00 | MSFT | Stock | 23.095 | 23.25 | 22.95 | 22.95 | 14039122.0 |
| 2002-10-02 10:00:00 | MSFT | Stock | 22.969 | 23.03 | 22.676 | 22.835 | 18072784.0 |
| 2002-10-02 11:00:00 | MSFT | Stock | 22.835 | 23.255 | 22.755 | 23.185 | 10841222.0 |
| 2002-10-02 12:00:00 | MSFT | Stock | 23.184 | 23.408 | 23.075 | 23.295 | 10504262.0 |
| 2002-10-02 13:00:00 | MSFT | Stock | 23.295 | 23.385 | 23.025 | 23.19 | 11490438.0 |
| 2002-10-02 14:00:00 | MSFT | Stock | 23.185 | 23.335 | 23.05 | 23.205 | 13293166.0 |
| 2002-10-02 15:00:00 | MSFT | Stock | 23.195 | 23.285 | 22.58 | 22.7905 | 20838368.0 |
| 2002-10-02 16:00:00 | MSFT | Stock | 22.795 | 22.936 | 22.635 | 22.75 | 1385622.0 |
| 2002-10-02 17:00:00 | MSFT | Stock | 22.75 | 22.805 | 22.69 | 22.69 | 412300.0 |
| 2002-10-02 18:00:00 | MSFT | Stock | 22.695 | 22.75 | 22.695 | 22.75 | 9000.0 |
| 2002-10-02 08:00:00 | NVDA | Stock | 0.0756 | 0.0809 | 0.072 | 0.0753 | 3701400.0 |
| 2002-10-02 09:00:00 | NVDA | Stock | 0.0752 | 0.0775 | 0.0752 | 0.0761 | 134124840.0 |
| 2002-10-02 10:00:00 | NVDA | Stock | 0.0761 | 0.077 | 0.0752 | 0.0763 | 123376560.0 |
| 2002-10-02 11:00:00 | NVDA | Stock | 0.0763 | 0.0789 | 0.0762 | 0.0784 | 83870040.0 |
| 2002-10-02 12:00:00 | NVDA | Stock | 0.0783 | 0.0796 | 0.0775 | 0.0783 | 86403360.0 |
| 2002-10-02 13:00:00 | NVDA | Stock | 0.0782 | 0.079 | 0.0765 | 0.0769 | 66811080.0 |
| 2002-10-02 14:00:00 | NVDA | Stock | 0.0769 | 0.0774 | 0.0761 | 0.0768 | 80223240.0 |
| 2002-10-02 15:00:00 | NVDA | Stock | 0.0768 | 0.077 | 0.0751 | 0.0757 | 152314680.0 |
| 2002-10-02 16:00:00 | NVDA | Stock | 0.0755 | 0.076 | 0.0742 | 0.075 | 12663000.0 |
| 2002-10-02 17:00:00 | NVDA | Stock | 0.0751 | 0.0751 | 0.0737 | 0.074 | 1641000.0 |
| 2002-10-02 08:00:00 | AMZN | Stock | 0.845 | 0.8475 | 0.841 | 0.8425 | 207600.0 |
| 2002-10-02 09:00:00 | AMZN | Stock | 0.8445 | 0.85 | 0.835 | 0.836 | 17403720.0 |
| 2002-10-02 10:00:00 | AMZN | Stock | 0.836 | 0.854 | 0.8355 | 0.85 | 17443840.0 |
| 2002-10-02 11:00:00 | AMZN | Stock | 0.85 | 0.875 | 0.8485 | 0.874 | 28981340.0 |
| 2002-10-02 12:00:00 | AMZN | Stock | 0.8745 | 0.8815 | 0.8685 | 0.876 | 26721540.0 |
| 2002-10-02 13:00:00 | AMZN | Stock | 0.8765 | 0.882 | 0.873 | 0.8745 | 27996040.0 |
| 2002-10-02 14:00:00 | AMZN | Stock | 0.8745 | 0.8748 | 0.8635 | 0.869 | 16918260.0 |
| 2002-10-02 15:00:00 | AMZN | Stock | 0.869 | 0.87 | 0.8495 | 0.8498 | 24063940.0 |
| 2002-10-02 16:00:00 | AMZN | Stock | 0.8495 | 0.8697 | 0.845 | 0.849 | 2062000.0 |
| 2002-10-02 17:00:00 | AMZN | Stock | 0.849 | 0.8545 | 0.849 | 0.8505 | 338000.0 |
| 2002-10-02 18:00:00 | AMZN | Stock | 0.864 | 0.864 | 0.8545 | 0.855 | 206000.0 |
| 2002-10-02 09:00:00 | CL | Stock | 27.0 | 27.19 | 27.0 | 27.08 | 431400.0 |
| 2002-10-02 10:00:00 | CL | Stock | 27.08 | 27.25 | 26.935 | 27.16 | 733600.0 |
| 2002-10-02 11:00:00 | CL | Stock | 27.16 | 27.375 | 27.04 | 27.375 | 409600.0 |
| 2002-10-02 12:00:00 | CL | Stock | 27.36 | 27.545 | 27.34 | 27.36 | 457200.0 |
| 2002-10-02 13:00:00 | CL | Stock | 27.355 | 27.475 | 27.295 | 27.365 | 279200.0 |
| 2002-10-02 14:00:00 | CL | Stock | 27.37 | 27.45 | 27.23 | 27.285 | 457800.0 |
| 2002-10-02 15:00:00 | CL | Stock | 27.26 | 27.34 | 26.715 | 27.06 | 508200.0 |
> showing 50 of 19,539 rows — these rows as CSV