PREVIEW / stock_1hour / 2001-02-01
file: by_date/stock_1hour/2001/2001-02-01.parquet size: 355 KB rows: 16,513 symbols: 1,269
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-02-01 08:00:00 | AAPL | Stock | 0.3839 | 0.3839 | 0.365 | 0.3728 | 3494400.0 |
| 2001-02-01 09:00:00 | AAPL | Stock | 0.3672 | 0.3839 | 0.3661 | 0.3783 | 55417600.0 |
| 2001-02-01 10:00:00 | AAPL | Stock | 0.3772 | 0.3783 | 0.3661 | 0.3705 | 91784000.0 |
| 2001-02-01 11:00:00 | AAPL | Stock | 0.3694 | 0.3828 | 0.3694 | 0.3817 | 62725600.0 |
| 2001-02-01 12:00:00 | AAPL | Stock | 0.3806 | 0.3839 | 0.3772 | 0.3772 | 23536800.0 |
| 2001-02-01 13:00:00 | AAPL | Stock | 0.3772 | 0.3795 | 0.3728 | 0.3739 | 26404000.0 |
| 2001-02-01 14:00:00 | AAPL | Stock | 0.375 | 0.375 | 0.3705 | 0.3717 | 23525600.0 |
| 2001-02-01 15:00:00 | AAPL | Stock | 0.3722 | 0.3783 | 0.3717 | 0.3772 | 31354400.0 |
| 2001-02-01 16:00:00 | AAPL | Stock | 0.3761 | 0.3817 | 0.3717 | 0.3761 | 6210400.0 |
| 2001-02-01 17:00:00 | AAPL | Stock | 0.375 | 0.3772 | 0.375 | 0.3772 | 78400.0 |
| 2001-02-01 08:00:00 | MSFT | Stock | 30.75 | 31.0 | 30.1875 | 30.5 | 122600.0 |
| 2001-02-01 09:00:00 | MSFT | Stock | 30.5312 | 30.75 | 30.1875 | 30.5 | 12791000.0 |
| 2001-02-01 10:00:00 | MSFT | Stock | 30.4844 | 30.6875 | 30.25 | 30.4688 | 8987000.0 |
| 2001-02-01 11:00:00 | MSFT | Stock | 30.5 | 31.3125 | 30.4688 | 31.125 | 9890800.0 |
| 2001-02-01 12:00:00 | MSFT | Stock | 31.125 | 31.1875 | 30.7188 | 30.9062 | 5282600.0 |
| 2001-02-01 13:00:00 | MSFT | Stock | 30.8906 | 30.9062 | 30.5 | 30.5938 | 7899800.0 |
| 2001-02-01 14:00:00 | MSFT | Stock | 30.5625 | 30.9375 | 30.5625 | 30.8125 | 8135200.0 |
| 2001-02-01 15:00:00 | MSFT | Stock | 30.8125 | 31.25 | 30.75 | 31.1875 | 11928200.0 |
| 2001-02-01 16:00:00 | MSFT | Stock | 31.125 | 31.5625 | 30.5625 | 31.4688 | 2064400.0 |
| 2001-02-01 17:00:00 | MSFT | Stock | 31.1875 | 31.4375 | 30.4375 | 30.4375 | 189400.0 |
| 2001-02-01 18:00:00 | MSFT | Stock | 31.3438 | 31.4062 | 31.3125 | 31.4062 | 3200.0 |
| 2001-02-01 09:00:00 | NVDA | Stock | 0.2151 | 0.2156 | 0.2083 | 0.2107 | 27984000.0 |
| 2001-02-01 10:00:00 | NVDA | Stock | 0.2109 | 0.2109 | 0.2057 | 0.2081 | 97224000.0 |
| 2001-02-01 11:00:00 | NVDA | Stock | 0.2081 | 0.2135 | 0.2078 | 0.2115 | 39624000.0 |
| 2001-02-01 12:00:00 | NVDA | Stock | 0.2112 | 0.2122 | 0.2104 | 0.2109 | 39720000.0 |
| 2001-02-01 13:00:00 | NVDA | Stock | 0.2107 | 0.2125 | 0.2094 | 0.2115 | 28872000.0 |
| 2001-02-01 14:00:00 | NVDA | Stock | 0.212 | 0.2167 | 0.2099 | 0.2158 | 49704000.0 |
| 2001-02-01 15:00:00 | NVDA | Stock | 0.2163 | 0.2177 | 0.2125 | 0.2161 | 37392000.0 |
| 2001-02-01 16:00:00 | NVDA | Stock | 0.2161 | 0.2174 | 0.2099 | 0.2141 | 22464000.0 |
| 2001-02-01 08:00:00 | AMZN | Stock | 0.8719 | 0.875 | 0.8656 | 0.8656 | 348000.0 |
| 2001-02-01 09:00:00 | AMZN | Stock | 0.8688 | 0.8719 | 0.8188 | 0.8312 | 27384000.0 |
| 2001-02-01 10:00:00 | AMZN | Stock | 0.8312 | 0.8344 | 0.7875 | 0.8094 | 48858000.0 |
| 2001-02-01 11:00:00 | AMZN | Stock | 0.8094 | 0.8281 | 0.8062 | 0.8156 | 27582000.0 |
| 2001-02-01 12:00:00 | AMZN | Stock | 0.8156 | 0.8375 | 0.8156 | 0.8219 | 21418000.0 |
| 2001-02-01 13:00:00 | AMZN | Stock | 0.8219 | 0.8312 | 0.8094 | 0.8156 | 9316000.0 |
| 2001-02-01 14:00:00 | AMZN | Stock | 0.8125 | 0.8234 | 0.8 | 0.8156 | 14884000.0 |
| 2001-02-01 15:00:00 | AMZN | Stock | 0.8188 | 0.825 | 0.8062 | 0.8125 | 16468000.0 |
| 2001-02-01 16:00:00 | AMZN | Stock | 0.8125 | 0.8156 | 0.8031 | 0.8125 | 2628000.0 |
| 2001-02-01 17:00:00 | AMZN | Stock | 0.8156 | 0.8188 | 0.8125 | 0.8188 | 52000.0 |
| 2001-02-01 18:00:00 | AMZN | Stock | 0.8188 | 0.8188 | 0.8156 | 0.8156 | 54000.0 |
| 2001-02-01 09:00:00 | CL | Stock | 30.04 | 30.275 | 30.04 | 30.2 | 652600.0 |
| 2001-02-01 10:00:00 | CL | Stock | 30.2 | 30.72 | 30.2 | 30.6 | 742600.0 |
| 2001-02-01 11:00:00 | CL | Stock | 30.625 | 30.725 | 30.35 | 30.365 | 1074800.0 |
| 2001-02-01 12:00:00 | CL | Stock | 30.385 | 30.59 | 30.325 | 30.55 | 418800.0 |
| 2001-02-01 13:00:00 | CL | Stock | 30.575 | 30.645 | 30.175 | 30.175 | 608000.0 |
| 2001-02-01 14:00:00 | CL | Stock | 30.195 | 30.65 | 30.195 | 30.65 | 404200.0 |
| 2001-02-01 15:00:00 | CL | Stock | 30.625 | 30.75 | 30.46 | 30.535 | 596200.0 |
| 2001-02-01 16:00:00 | CL | Stock | 30.54 | 30.625 | 30.54 | 30.625 | 214200.0 |
| 2001-02-01 17:00:00 | CL | Stock | 30.54 | 30.54 | 30.54 | 30.54 | 21400.0 |
> showing 49 of 16,513 rows — these rows as CSV