PREVIEW / stock_1hour / 2001-01-11
file: by_date/stock_1hour/2001/2001-01-11.parquet size: 317 KB rows: 16,513 symbols: 1,256
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-01-11 08:00:00 | AAPL | Stock | 0.2913 | 0.2963 | 0.2857 | 0.2891 | 1064000.0 |
| 2001-01-11 09:00:00 | AAPL | Stock | 0.2913 | 0.3013 | 0.2902 | 0.3013 | 52948000.0 |
| 2001-01-11 10:00:00 | AAPL | Stock | 0.3013 | 0.3136 | 0.2991 | 0.3092 | 146876800.0 |
| 2001-01-11 11:00:00 | AAPL | Stock | 0.3092 | 0.317 | 0.308 | 0.3158 | 109888800.0 |
| 2001-01-11 12:00:00 | AAPL | Stock | 0.3158 | 0.3281 | 0.3158 | 0.3259 | 157572800.0 |
| 2001-01-11 13:00:00 | AAPL | Stock | 0.3259 | 0.3304 | 0.3214 | 0.3259 | 84358400.0 |
| 2001-01-11 14:00:00 | AAPL | Stock | 0.3281 | 0.3304 | 0.3225 | 0.3259 | 65452800.0 |
| 2001-01-11 15:00:00 | AAPL | Stock | 0.3259 | 0.3292 | 0.3181 | 0.3203 | 106764000.0 |
| 2001-01-11 16:00:00 | AAPL | Stock | 0.3214 | 0.3214 | 0.2997 | 0.308 | 14280000.0 |
| 2001-01-11 17:00:00 | AAPL | Stock | 0.3214 | 0.3214 | 0.308 | 0.3181 | 560000.0 |
| 2001-01-11 18:00:00 | AAPL | Stock | 0.317 | 0.3181 | 0.317 | 0.317 | 336000.0 |
| 2001-01-11 08:00:00 | MSFT | Stock | 26.0 | 26.375 | 26.0 | 26.375 | 6000.0 |
| 2001-01-11 09:00:00 | MSFT | Stock | 26.3125 | 26.875 | 26.125 | 26.4375 | 10644400.0 |
| 2001-01-11 10:00:00 | MSFT | Stock | 26.4219 | 27.25 | 26.4062 | 27.0312 | 13094800.0 |
| 2001-01-11 11:00:00 | MSFT | Stock | 27.0312 | 27.375 | 26.9688 | 27.3438 | 15195200.0 |
| 2001-01-11 12:00:00 | MSFT | Stock | 27.3438 | 27.4062 | 27.25 | 27.25 | 6741400.0 |
| 2001-01-11 13:00:00 | MSFT | Stock | 27.25 | 27.3438 | 27.0938 | 27.2812 | 7152800.0 |
| 2001-01-11 14:00:00 | MSFT | Stock | 27.25 | 27.5312 | 27.25 | 27.4688 | 13231600.0 |
| 2001-01-11 15:00:00 | MSFT | Stock | 27.4375 | 27.6562 | 27.25 | 27.5 | 18887000.0 |
| 2001-01-11 16:00:00 | MSFT | Stock | 27.5 | 27.5312 | 26.875 | 27.2344 | 8084400.0 |
| 2001-01-11 17:00:00 | MSFT | Stock | 27.2344 | 27.5 | 27.0156 | 27.0938 | 85600.0 |
| 2001-01-11 18:00:00 | MSFT | Stock | 27.125 | 27.2188 | 27.0625 | 27.2188 | 5600.0 |
| 2001-01-11 09:00:00 | NVDA | Stock | 0.1813 | 0.1846 | 0.1771 | 0.1845 | 15072000.0 |
| 2001-01-11 10:00:00 | NVDA | Stock | 0.1836 | 0.1917 | 0.1786 | 0.1875 | 45624000.0 |
| 2001-01-11 11:00:00 | NVDA | Stock | 0.1883 | 0.201 | 0.1878 | 0.1969 | 75864000.0 |
| 2001-01-11 12:00:00 | NVDA | Stock | 0.1971 | 0.2005 | 0.1927 | 0.1964 | 38112000.0 |
| 2001-01-11 13:00:00 | NVDA | Stock | 0.1964 | 0.2005 | 0.1935 | 0.2 | 28464000.0 |
| 2001-01-11 14:00:00 | NVDA | Stock | 0.1987 | 0.2076 | 0.1964 | 0.2057 | 114480000.0 |
| 2001-01-11 15:00:00 | NVDA | Stock | 0.2047 | 0.2078 | 0.1992 | 0.201 | 79008000.0 |
| 2001-01-11 16:00:00 | NVDA | Stock | 0.2 | 0.2063 | 0.1924 | 0.1938 | 12096000.0 |
| 2001-01-11 17:00:00 | NVDA | Stock | 0.2039 | 0.2039 | 0.1917 | 0.1917 | 696000.0 |
| 2001-01-11 18:00:00 | NVDA | Stock | 0.1958 | 0.1958 | 0.1958 | 0.1958 | 48000.0 |
| 2001-01-11 08:00:00 | AMZN | Stock | 0.7781 | 0.7844 | 0.7688 | 0.7766 | 790000.0 |
| 2001-01-11 09:00:00 | AMZN | Stock | 0.775 | 0.825 | 0.775 | 0.825 | 22264000.0 |
| 2001-01-11 10:00:00 | AMZN | Stock | 0.8125 | 0.8188 | 0.7906 | 0.8062 | 20536000.0 |
| 2001-01-11 11:00:00 | AMZN | Stock | 0.8062 | 0.8344 | 0.8062 | 0.8344 | 29662000.0 |
| 2001-01-11 12:00:00 | AMZN | Stock | 0.8312 | 0.8656 | 0.8312 | 0.8469 | 43496000.0 |
| 2001-01-11 13:00:00 | AMZN | Stock | 0.8469 | 0.85 | 0.8344 | 0.85 | 16224000.0 |
| 2001-01-11 14:00:00 | AMZN | Stock | 0.85 | 0.8656 | 0.8438 | 0.8469 | 42902000.0 |
| 2001-01-11 15:00:00 | AMZN | Stock | 0.8438 | 0.8594 | 0.8406 | 0.8531 | 50684000.0 |
| 2001-01-11 16:00:00 | AMZN | Stock | 0.85 | 0.8531 | 0.825 | 0.8406 | 4994000.0 |
| 2001-01-11 17:00:00 | AMZN | Stock | 0.8406 | 0.8469 | 0.8312 | 0.8469 | 116000.0 |
| 2001-01-11 18:00:00 | AMZN | Stock | 0.8469 | 0.8469 | 0.8344 | 0.8469 | 40000.0 |
| 2001-01-11 09:00:00 | CL | Stock | 29.65 | 29.65 | 29.3 | 29.325 | 164400.0 |
| 2001-01-11 10:00:00 | CL | Stock | 29.33 | 29.44 | 29.175 | 29.415 | 547400.0 |
| 2001-01-11 11:00:00 | CL | Stock | 29.4 | 29.425 | 28.95 | 29.025 | 680200.0 |
| 2001-01-11 12:00:00 | CL | Stock | 29.025 | 29.39 | 29.0 | 29.255 | 283000.0 |
| 2001-01-11 13:00:00 | CL | Stock | 29.255 | 29.36 | 29.22 | 29.335 | 247200.0 |
| 2001-01-11 14:00:00 | CL | Stock | 29.32 | 29.32 | 29.05 | 29.2 | 372600.0 |
| 2001-01-11 15:00:00 | CL | Stock | 29.205 | 29.255 | 29.03 | 29.12 | 932600.0 |
> showing 50 of 16,513 rows — these rows as CSV