PREVIEW / stock_1hour / 2001-02-16
file: by_date/stock_1hour/2001/2001-02-16.parquet size: 347 KB rows: 16,408 symbols: 1,268
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-16 08:00:00 | AAPL | Stock | 0.3482 | 0.3482 | 0.3382 | 0.3415 | 1164800.0 |
| 2001-02-16 09:00:00 | AAPL | Stock | 0.3438 | 0.3449 | 0.3348 | 0.3415 | 48126400.0 |
| 2001-02-16 10:00:00 | AAPL | Stock | 0.3421 | 0.3482 | 0.3398 | 0.3404 | 37290400.0 |
| 2001-02-16 11:00:00 | AAPL | Stock | 0.3404 | 0.3426 | 0.3393 | 0.3415 | 30217600.0 |
| 2001-02-16 12:00:00 | AAPL | Stock | 0.3415 | 0.3426 | 0.3393 | 0.3415 | 28246400.0 |
| 2001-02-16 13:00:00 | AAPL | Stock | 0.3415 | 0.3426 | 0.3371 | 0.3371 | 25435200.0 |
| 2001-02-16 14:00:00 | AAPL | Stock | 0.3371 | 0.3426 | 0.3348 | 0.3415 | 28879200.0 |
| 2001-02-16 15:00:00 | AAPL | Stock | 0.3415 | 0.3426 | 0.3371 | 0.3393 | 35868000.0 |
| 2001-02-16 16:00:00 | AAPL | Stock | 0.3382 | 0.3415 | 0.3382 | 0.3393 | 5941600.0 |
| 2001-02-16 17:00:00 | AAPL | Stock | 0.3415 | 0.3415 | 0.3393 | 0.3393 | 61600.0 |
| 2001-02-16 18:00:00 | AAPL | Stock | 0.3393 | 0.3393 | 0.3393 | 0.3393 | 5600.0 |
| 2001-02-16 08:00:00 | MSFT | Stock | 28.6875 | 28.875 | 28.5 | 28.625 | 330200.0 |
| 2001-02-16 09:00:00 | MSFT | Stock | 28.6562 | 28.875 | 28.375 | 28.7188 | 10846000.0 |
| 2001-02-16 10:00:00 | MSFT | Stock | 28.7188 | 28.8125 | 28.125 | 28.4375 | 13212600.0 |
| 2001-02-16 11:00:00 | MSFT | Stock | 28.4375 | 28.625 | 28.3125 | 28.3438 | 5701200.0 |
| 2001-02-16 12:00:00 | MSFT | Stock | 28.3438 | 28.5 | 28.3125 | 28.4375 | 3741200.0 |
| 2001-02-16 13:00:00 | MSFT | Stock | 28.4062 | 28.4688 | 28.125 | 28.1875 | 5336000.0 |
| 2001-02-16 14:00:00 | MSFT | Stock | 28.1875 | 28.5625 | 28.0625 | 28.5 | 8726200.0 |
| 2001-02-16 15:00:00 | MSFT | Stock | 28.5 | 29.125 | 28.2188 | 28.625 | 11632400.0 |
| 2001-02-16 16:00:00 | MSFT | Stock | 28.625 | 28.7812 | 28.1719 | 28.625 | 1942600.0 |
| 2001-02-16 17:00:00 | MSFT | Stock | 28.625 | 28.75 | 28.625 | 28.7188 | 19000.0 |
| 2001-02-16 18:00:00 | MSFT | Stock | 28.75 | 28.8438 | 28.6562 | 28.8438 | 325200.0 |
| 2001-02-16 08:00:00 | NVDA | Stock | 0.2299 | 0.2299 | 0.225 | 0.2253 | 3144000.0 |
| 2001-02-16 09:00:00 | NVDA | Stock | 0.225 | 0.2313 | 0.2229 | 0.2281 | 100776000.0 |
| 2001-02-16 10:00:00 | NVDA | Stock | 0.2292 | 0.2307 | 0.2253 | 0.2279 | 63528000.0 |
| 2001-02-16 11:00:00 | NVDA | Stock | 0.2279 | 0.2323 | 0.2273 | 0.2313 | 71400000.0 |
| 2001-02-16 12:00:00 | NVDA | Stock | 0.2313 | 0.2487 | 0.2307 | 0.2466 | 185544000.0 |
| 2001-02-16 13:00:00 | NVDA | Stock | 0.2479 | 0.2542 | 0.2451 | 0.251 | 286680000.0 |
| 2001-02-16 14:00:00 | NVDA | Stock | 0.25 | 0.2508 | 0.2414 | 0.243 | 153912000.0 |
| 2001-02-16 15:00:00 | NVDA | Stock | 0.2427 | 0.25 | 0.2427 | 0.2477 | 140880000.0 |
| 2001-02-16 16:00:00 | NVDA | Stock | 0.2477 | 0.249 | 0.2232 | 0.2479 | 37272000.0 |
| 2001-02-16 17:00:00 | NVDA | Stock | 0.2479 | 0.25 | 0.2419 | 0.25 | 312000.0 |
| 2001-02-16 08:00:00 | AMZN | Stock | 0.7125 | 0.7188 | 0.6875 | 0.7031 | 1460000.0 |
| 2001-02-16 09:00:00 | AMZN | Stock | 0.7031 | 0.7062 | 0.6812 | 0.6906 | 17450000.0 |
| 2001-02-16 10:00:00 | AMZN | Stock | 0.6906 | 0.6938 | 0.6812 | 0.6844 | 18332000.0 |
| 2001-02-16 11:00:00 | AMZN | Stock | 0.6844 | 0.6938 | 0.6781 | 0.6906 | 20930000.0 |
| 2001-02-16 12:00:00 | AMZN | Stock | 0.6875 | 0.6906 | 0.675 | 0.6781 | 11768000.0 |
| 2001-02-16 13:00:00 | AMZN | Stock | 0.6781 | 0.6812 | 0.6688 | 0.675 | 11792000.0 |
| 2001-02-16 14:00:00 | AMZN | Stock | 0.675 | 0.6781 | 0.6656 | 0.6688 | 14348000.0 |
| 2001-02-16 15:00:00 | AMZN | Stock | 0.6656 | 0.6906 | 0.6656 | 0.6844 | 22470000.0 |
| 2001-02-16 16:00:00 | AMZN | Stock | 0.6844 | 0.6938 | 0.6719 | 0.6781 | 3722000.0 |
| 2001-02-16 17:00:00 | AMZN | Stock | 0.6781 | 0.6844 | 0.6719 | 0.6719 | 52000.0 |
| 2001-02-16 18:00:00 | AMZN | Stock | 0.6812 | 0.6812 | 0.6812 | 0.6812 | 4000.0 |
| 2001-02-16 09:00:00 | CL | Stock | 29.125 | 29.225 | 29.1 | 29.13 | 828600.0 |
| 2001-02-16 10:00:00 | CL | Stock | 29.13 | 29.35 | 29.105 | 29.325 | 638000.0 |
| 2001-02-16 11:00:00 | CL | Stock | 29.325 | 29.485 | 29.325 | 29.475 | 460600.0 |
| 2001-02-16 12:00:00 | CL | Stock | 29.45 | 29.545 | 29.45 | 29.465 | 380000.0 |
| 2001-02-16 13:00:00 | CL | Stock | 29.46 | 29.6 | 29.435 | 29.485 | 391400.0 |
| 2001-02-16 14:00:00 | CL | Stock | 29.485 | 29.555 | 29.46 | 29.5 | 354800.0 |
| 2001-02-16 15:00:00 | CL | Stock | 29.5 | 29.695 | 29.48 | 29.58 | 644200.0 |
> showing 50 of 16,408 rows — these rows as CSV