PREVIEW / stock_1hour / 2001-06-06
file: by_date/stock_1hour/2001/2001-06-06.parquet size: 365 KB rows: 17,214 symbols: 1,304
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 |
|---|---|---|---|---|---|---|---|
| 2001-06-06 08:00:00 | AAPL | Stock | 0.3748 | 0.3748 | 0.3739 | 0.3741 | 134400.0 |
| 2001-06-06 09:00:00 | AAPL | Stock | 0.3732 | 0.3745 | 0.367 | 0.3691 | 32782400.0 |
| 2001-06-06 10:00:00 | AAPL | Stock | 0.3689 | 0.3732 | 0.367 | 0.3693 | 42369600.0 |
| 2001-06-06 11:00:00 | AAPL | Stock | 0.3693 | 0.3693 | 0.363 | 0.3652 | 31701600.0 |
| 2001-06-06 12:00:00 | AAPL | Stock | 0.3646 | 0.3695 | 0.3645 | 0.3688 | 11894400.0 |
| 2001-06-06 13:00:00 | AAPL | Stock | 0.3693 | 0.37 | 0.3652 | 0.3689 | 12868800.0 |
| 2001-06-06 14:00:00 | AAPL | Stock | 0.3689 | 0.3705 | 0.367 | 0.3689 | 22366400.0 |
| 2001-06-06 15:00:00 | AAPL | Stock | 0.3693 | 0.3718 | 0.3688 | 0.3704 | 44525600.0 |
| 2001-06-06 16:00:00 | AAPL | Stock | 0.3704 | 0.3705 | 0.3682 | 0.3702 | 6792800.0 |
| 2001-06-06 17:00:00 | AAPL | Stock | 0.3702 | 0.3702 | 0.3696 | 0.3702 | 336000.0 |
| 2001-06-06 18:00:00 | AAPL | Stock | 0.3696 | 0.3696 | 0.3696 | 0.3696 | 5600.0 |
| 2001-06-06 08:00:00 | MSFT | Stock | 36.425 | 36.58 | 36.15 | 36.375 | 437600.0 |
| 2001-06-06 09:00:00 | MSFT | Stock | 36.385 | 36.74 | 36.3 | 36.39 | 22172000.0 |
| 2001-06-06 10:00:00 | MSFT | Stock | 36.385 | 36.62 | 36.13 | 36.355 | 17090600.0 |
| 2001-06-06 11:00:00 | MSFT | Stock | 36.355 | 36.355 | 35.775 | 35.98 | 11975000.0 |
| 2001-06-06 12:00:00 | MSFT | Stock | 35.98 | 36.245 | 35.93 | 36.18 | 5378600.0 |
| 2001-06-06 13:00:00 | MSFT | Stock | 36.175 | 36.355 | 36.125 | 36.35 | 3921400.0 |
| 2001-06-06 14:00:00 | MSFT | Stock | 36.35 | 36.46 | 36.0 | 36.09 | 6971000.0 |
| 2001-06-06 15:00:00 | MSFT | Stock | 36.09 | 36.25 | 36.0 | 36.175 | 7935800.0 |
| 2001-06-06 16:00:00 | MSFT | Stock | 36.18 | 36.31 | 36.1 | 36.18 | 990400.0 |
| 2001-06-06 17:00:00 | MSFT | Stock | 36.18 | 36.27 | 36.12 | 36.12 | 57600.0 |
| 2001-06-06 18:00:00 | MSFT | Stock | 36.11 | 36.11 | 36.11 | 36.11 | 400.0 |
| 2001-06-06 08:00:00 | NVDA | Stock | 0.3927 | 0.3958 | 0.391 | 0.391 | 1152000.0 |
| 2001-06-06 09:00:00 | NVDA | Stock | 0.391 | 0.3917 | 0.3858 | 0.3889 | 83448000.0 |
| 2001-06-06 10:00:00 | NVDA | Stock | 0.3888 | 0.3963 | 0.3878 | 0.3917 | 155784000.0 |
| 2001-06-06 11:00:00 | NVDA | Stock | 0.3916 | 0.3935 | 0.3897 | 0.3918 | 86232000.0 |
| 2001-06-06 12:00:00 | NVDA | Stock | 0.3919 | 0.3951 | 0.3917 | 0.3928 | 52896000.0 |
| 2001-06-06 13:00:00 | NVDA | Stock | 0.3933 | 0.3969 | 0.3912 | 0.3958 | 114576000.0 |
| 2001-06-06 14:00:00 | NVDA | Stock | 0.3961 | 0.3961 | 0.3921 | 0.3923 | 68136000.0 |
| 2001-06-06 15:00:00 | NVDA | Stock | 0.3923 | 0.3942 | 0.3869 | 0.3917 | 83208000.0 |
| 2001-06-06 16:00:00 | NVDA | Stock | 0.392 | 0.3958 | 0.39 | 0.3918 | 11640000.0 |
| 2001-06-06 17:00:00 | NVDA | Stock | 0.3917 | 0.3918 | 0.3917 | 0.3918 | 480000.0 |
| 2001-06-06 18:00:00 | NVDA | Stock | 0.3917 | 0.3917 | 0.3917 | 0.3917 | 144000.0 |
| 2001-06-06 08:00:00 | AMZN | Stock | 0.8255 | 0.83 | 0.8145 | 0.8265 | 202000.0 |
| 2001-06-06 09:00:00 | AMZN | Stock | 0.8265 | 0.837 | 0.816 | 0.8205 | 20928000.0 |
| 2001-06-06 10:00:00 | AMZN | Stock | 0.8205 | 0.829 | 0.796 | 0.799 | 33774000.0 |
| 2001-06-06 11:00:00 | AMZN | Stock | 0.799 | 0.8055 | 0.79 | 0.7975 | 30842000.0 |
| 2001-06-06 12:00:00 | AMZN | Stock | 0.7985 | 0.8075 | 0.796 | 0.804 | 12644000.0 |
| 2001-06-06 13:00:00 | AMZN | Stock | 0.804 | 0.8095 | 0.785 | 0.7885 | 29508000.0 |
| 2001-06-06 14:00:00 | AMZN | Stock | 0.7885 | 0.7975 | 0.775 | 0.7755 | 23660000.0 |
| 2001-06-06 15:00:00 | AMZN | Stock | 0.775 | 0.805 | 0.774 | 0.7995 | 28422000.0 |
| 2001-06-06 16:00:00 | AMZN | Stock | 0.8 | 0.8005 | 0.7955 | 0.7995 | 2982000.0 |
| 2001-06-06 17:00:00 | AMZN | Stock | 0.7995 | 0.7995 | 0.7905 | 0.798 | 136000.0 |
| 2001-06-06 18:00:00 | AMZN | Stock | 0.795 | 0.795 | 0.791 | 0.795 | 10000.0 |
| 2001-06-06 09:00:00 | CL | Stock | 29.225 | 29.45 | 29.075 | 29.425 | 380000.0 |
| 2001-06-06 10:00:00 | CL | Stock | 29.4 | 29.505 | 29.265 | 29.475 | 414600.0 |
| 2001-06-06 11:00:00 | CL | Stock | 29.505 | 29.525 | 29.355 | 29.4 | 205400.0 |
| 2001-06-06 12:00:00 | CL | Stock | 29.4 | 29.41 | 29.25 | 29.34 | 334600.0 |
| 2001-06-06 13:00:00 | CL | Stock | 29.34 | 29.45 | 29.325 | 29.45 | 193800.0 |
| 2001-06-06 14:00:00 | CL | Stock | 29.45 | 29.475 | 29.255 | 29.29 | 290800.0 |
> showing 50 of 17,214 rows — these rows as CSV