PREVIEW / stock_1hour / 2000-12-05
file: by_date/stock_1hour/2000/2000-12-05.parquet size: 324 KB rows: 16,566 symbols: 1,249
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 |
|---|---|---|---|---|---|---|---|
| 2000-12-05 08:00:00 | AAPL | Stock | 0.3013 | 0.3103 | 0.2986 | 0.3058 | 1411200.0 |
| 2000-12-05 09:00:00 | AAPL | Stock | 0.3047 | 0.3047 | 0.2969 | 0.298 | 45724000.0 |
| 2000-12-05 10:00:00 | AAPL | Stock | 0.298 | 0.3058 | 0.2958 | 0.3058 | 84750400.0 |
| 2000-12-05 11:00:00 | AAPL | Stock | 0.3047 | 0.3114 | 0.3047 | 0.3092 | 100856000.0 |
| 2000-12-05 12:00:00 | AAPL | Stock | 0.308 | 0.3114 | 0.2991 | 0.3002 | 65352000.0 |
| 2000-12-05 13:00:00 | AAPL | Stock | 0.3013 | 0.3013 | 0.2946 | 0.2991 | 58973600.0 |
| 2000-12-05 14:00:00 | AAPL | Stock | 0.2991 | 0.3013 | 0.2924 | 0.2969 | 41955200.0 |
| 2000-12-05 15:00:00 | AAPL | Stock | 0.2969 | 0.3047 | 0.2958 | 0.3036 | 82454400.0 |
| 2000-12-05 16:00:00 | AAPL | Stock | 0.3025 | 0.308 | 0.3002 | 0.3002 | 10920000.0 |
| 2000-12-05 17:00:00 | AAPL | Stock | 0.2679 | 0.3036 | 0.2433 | 0.2667 | 45225600.0 |
| 2000-12-05 18:00:00 | AAPL | Stock | 0.2673 | 0.2746 | 0.202 | 0.2684 | 24556000.0 |
| 2000-12-05 08:00:00 | MSFT | Stock | 30.0312 | 30.0312 | 29.25 | 29.4062 | 345000.0 |
| 2000-12-05 09:00:00 | MSFT | Stock | 29.4062 | 29.75 | 29.0625 | 29.375 | 15861000.0 |
| 2000-12-05 10:00:00 | MSFT | Stock | 29.375 | 30.0625 | 29.3594 | 29.9688 | 17219800.0 |
| 2000-12-05 11:00:00 | MSFT | Stock | 29.9688 | 30.25 | 29.9062 | 30.0938 | 13555000.0 |
| 2000-12-05 12:00:00 | MSFT | Stock | 30.1562 | 30.1562 | 29.375 | 29.75 | 12143200.0 |
| 2000-12-05 13:00:00 | MSFT | Stock | 29.8125 | 29.875 | 29.5938 | 29.6875 | 6237600.0 |
| 2000-12-05 14:00:00 | MSFT | Stock | 29.6562 | 29.9062 | 29.625 | 29.7812 | 7495800.0 |
| 2000-12-05 15:00:00 | MSFT | Stock | 29.7812 | 30.125 | 29.7188 | 29.9375 | 14524200.0 |
| 2000-12-05 16:00:00 | MSFT | Stock | 29.9375 | 30.0312 | 29.375 | 29.5625 | 4141800.0 |
| 2000-12-05 17:00:00 | MSFT | Stock | 29.625 | 29.9375 | 29.5312 | 29.7812 | 352400.0 |
| 2000-12-05 18:00:00 | MSFT | Stock | 29.7812 | 29.875 | 29.6562 | 29.875 | 26600.0 |
| 2000-12-05 08:00:00 | NVDA | Stock | 0.2125 | 0.2125 | 0.1935 | 0.1935 | 216000.0 |
| 2000-12-05 09:00:00 | NVDA | Stock | 0.1979 | 0.2021 | 0.1854 | 0.1854 | 106752000.0 |
| 2000-12-05 10:00:00 | NVDA | Stock | 0.1857 | 0.1967 | 0.1828 | 0.1961 | 205848000.0 |
| 2000-12-05 11:00:00 | NVDA | Stock | 0.1958 | 0.2089 | 0.1922 | 0.2049 | 157944000.0 |
| 2000-12-05 12:00:00 | NVDA | Stock | 0.2042 | 0.2055 | 0.1932 | 0.1961 | 81384000.0 |
| 2000-12-05 13:00:00 | NVDA | Stock | 0.1958 | 0.1974 | 0.1943 | 0.1958 | 59712000.0 |
| 2000-12-05 14:00:00 | NVDA | Stock | 0.1958 | 0.1974 | 0.1927 | 0.1958 | 105552000.0 |
| 2000-12-05 15:00:00 | NVDA | Stock | 0.1961 | 0.2055 | 0.1943 | 0.2005 | 166632000.0 |
| 2000-12-05 16:00:00 | NVDA | Stock | 0.2005 | 0.2047 | 0.1901 | 0.1966 | 29376000.0 |
| 2000-12-05 17:00:00 | NVDA | Stock | 0.2021 | 0.2021 | 0.1966 | 0.2018 | 216000.0 |
| 2000-12-05 18:00:00 | NVDA | Stock | 0.1966 | 0.2013 | 0.1966 | 0.2013 | 384000.0 |
| 2000-12-05 08:00:00 | AMZN | Stock | 1.3844 | 1.4125 | 1.3563 | 1.4094 | 944000.0 |
| 2000-12-05 09:00:00 | AMZN | Stock | 1.3938 | 1.4125 | 1.2781 | 1.2906 | 27468000.0 |
| 2000-12-05 10:00:00 | AMZN | Stock | 1.2906 | 1.3812 | 1.2875 | 1.3438 | 27662000.0 |
| 2000-12-05 11:00:00 | AMZN | Stock | 1.3469 | 1.375 | 1.3375 | 1.35 | 19592000.0 |
| 2000-12-05 12:00:00 | AMZN | Stock | 1.3531 | 1.3563 | 1.2781 | 1.3 | 20586000.0 |
| 2000-12-05 13:00:00 | AMZN | Stock | 1.2969 | 1.3063 | 1.2625 | 1.2719 | 15994000.0 |
| 2000-12-05 14:00:00 | AMZN | Stock | 1.275 | 1.2875 | 1.2375 | 1.2594 | 29640000.0 |
| 2000-12-05 15:00:00 | AMZN | Stock | 1.2594 | 1.2984 | 1.2469 | 1.2656 | 34398000.0 |
| 2000-12-05 16:00:00 | AMZN | Stock | 1.2688 | 1.3 | 1.2594 | 1.2656 | 7802000.0 |
| 2000-12-05 17:00:00 | AMZN | Stock | 1.2625 | 1.3 | 1.2562 | 1.2719 | 216000.0 |
| 2000-12-05 18:00:00 | AMZN | Stock | 1.2719 | 1.2812 | 1.2656 | 1.275 | 46000.0 |
| 2000-12-05 09:00:00 | CL | Stock | 29.85 | 29.855 | 29.375 | 29.375 | 469200.0 |
| 2000-12-05 10:00:00 | CL | Stock | 29.38 | 29.42 | 29.2 | 29.3 | 490800.0 |
| 2000-12-05 11:00:00 | CL | Stock | 29.285 | 29.32 | 28.65 | 28.82 | 555600.0 |
| 2000-12-05 12:00:00 | CL | Stock | 28.82 | 28.95 | 28.82 | 28.865 | 519000.0 |
| 2000-12-05 13:00:00 | CL | Stock | 28.875 | 29.2 | 28.865 | 28.91 | 665200.0 |
| 2000-12-05 14:00:00 | CL | Stock | 28.93 | 29.13 | 28.925 | 29.075 | 513800.0 |
> showing 50 of 16,566 rows — these rows as CSV