PREVIEW / stock_1hour / 2000-04-10
file: by_date/stock_1hour/2000/2000-04-10.parquet size: 280 KB rows: 14,570 symbols: 1,157
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-04-10 09:00:00 | AAPL | Stock | 1.1758 | 1.1758 | 1.1451 | 1.1652 | 24203200.0 |
| 2000-04-10 10:00:00 | AAPL | Stock | 1.1635 | 1.1853 | 1.1518 | 1.1607 | 48361600.0 |
| 2000-04-10 11:00:00 | AAPL | Stock | 1.1602 | 1.1702 | 1.1551 | 1.1624 | 20092800.0 |
| 2000-04-10 12:00:00 | AAPL | Stock | 1.1624 | 1.1624 | 1.1501 | 1.1523 | 13216000.0 |
| 2000-04-10 13:00:00 | AAPL | Stock | 1.1507 | 1.1523 | 1.125 | 1.1493 | 29769600.0 |
| 2000-04-10 14:00:00 | AAPL | Stock | 1.1507 | 1.1507 | 1.1295 | 1.1373 | 16094400.0 |
| 2000-04-10 15:00:00 | AAPL | Stock | 1.1373 | 1.1401 | 1.1138 | 1.1166 | 35873600.0 |
| 2000-04-10 16:00:00 | AAPL | Stock | 1.1161 | 1.1166 | 1.1161 | 1.1161 | 2363200.0 |
| 2000-04-10 09:00:00 | MSFT | Stock | 44.3125 | 44.3125 | 43.25 | 43.5 | 9208600.0 |
| 2000-04-10 10:00:00 | MSFT | Stock | 43.5312 | 43.8125 | 43.3125 | 43.4375 | 8591400.0 |
| 2000-04-10 11:00:00 | MSFT | Stock | 43.4375 | 43.5625 | 43.375 | 43.4688 | 6732200.0 |
| 2000-04-10 12:00:00 | MSFT | Stock | 43.4688 | 43.5 | 43.25 | 43.3438 | 5784600.0 |
| 2000-04-10 13:00:00 | MSFT | Stock | 43.3438 | 43.5625 | 43.0312 | 43.1875 | 6769400.0 |
| 2000-04-10 14:00:00 | MSFT | Stock | 43.1875 | 43.4688 | 43.0938 | 43.3125 | 5832200.0 |
| 2000-04-10 15:00:00 | MSFT | Stock | 43.2812 | 43.6875 | 43.0 | 43.0312 | 10776800.0 |
| 2000-04-10 16:00:00 | MSFT | Stock | 43.0625 | 43.125 | 43.0312 | 43.0312 | 360600.0 |
| 2000-04-10 09:00:00 | NVDA | Stock | 0.2173 | 0.2299 | 0.2164 | 0.2194 | 94320000.0 |
| 2000-04-10 10:00:00 | NVDA | Stock | 0.2214 | 0.225 | 0.2201 | 0.2234 | 45072000.0 |
| 2000-04-10 11:00:00 | NVDA | Stock | 0.2234 | 0.2286 | 0.2227 | 0.2268 | 36288000.0 |
| 2000-04-10 12:00:00 | NVDA | Stock | 0.2258 | 0.2271 | 0.2117 | 0.2167 | 38832000.0 |
| 2000-04-10 13:00:00 | NVDA | Stock | 0.2143 | 0.2146 | 0.1995 | 0.2 | 77760000.0 |
| 2000-04-10 14:00:00 | NVDA | Stock | 0.2 | 0.2073 | 0.2 | 0.2021 | 37392000.0 |
| 2000-04-10 15:00:00 | NVDA | Stock | 0.2014 | 0.2034 | 0.1908 | 0.1948 | 46944000.0 |
| 2000-04-10 16:00:00 | NVDA | Stock | 0.1948 | 0.1948 | 0.1948 | 0.1948 | 816000.0 |
| 2000-04-10 09:00:00 | AMZN | Stock | 3.3625 | 3.3938 | 3.3094 | 3.3828 | 9928000.0 |
| 2000-04-10 10:00:00 | AMZN | Stock | 3.3844 | 3.4062 | 3.325 | 3.3438 | 11596000.0 |
| 2000-04-10 11:00:00 | AMZN | Stock | 3.3531 | 3.3656 | 3.3281 | 3.3438 | 6542000.0 |
| 2000-04-10 12:00:00 | AMZN | Stock | 3.3406 | 3.3812 | 3.3344 | 3.3375 | 8522000.0 |
| 2000-04-10 13:00:00 | AMZN | Stock | 3.3406 | 3.35 | 3.2531 | 3.3219 | 20882000.0 |
| 2000-04-10 14:00:00 | AMZN | Stock | 3.3125 | 3.3219 | 3.25 | 3.2625 | 7884000.0 |
| 2000-04-10 15:00:00 | AMZN | Stock | 3.2625 | 3.2953 | 3.1656 | 3.1688 | 18530000.0 |
| 2000-04-10 16:00:00 | AMZN | Stock | 3.1688 | 3.175 | 3.1625 | 3.1688 | 486000.0 |
| 2000-04-10 09:00:00 | CL | Stock | 29.0 | 29.9375 | 28.9375 | 29.9375 | 440400.0 |
| 2000-04-10 10:00:00 | CL | Stock | 29.9375 | 30.0 | 29.625 | 30.0 | 691000.0 |
| 2000-04-10 11:00:00 | CL | Stock | 30.0 | 30.125 | 29.9062 | 29.9688 | 581400.0 |
| 2000-04-10 12:00:00 | CL | Stock | 29.9688 | 30.0625 | 29.875 | 29.9062 | 387600.0 |
| 2000-04-10 13:00:00 | CL | Stock | 29.9062 | 29.9688 | 29.8438 | 29.9688 | 607800.0 |
| 2000-04-10 14:00:00 | CL | Stock | 29.9688 | 30.0625 | 29.9062 | 30.0625 | 365200.0 |
| 2000-04-10 15:00:00 | CL | Stock | 30.0312 | 30.4375 | 29.9688 | 30.125 | 1236400.0 |
| 2000-04-10 16:00:00 | CL | Stock | 30.1562 | 30.1562 | 30.125 | 30.125 | 50600.0 |
> showing 40 of 14,570 rows — these rows as CSV