PREVIEW / stock_1hour / 2000-11-16
file: by_date/stock_1hour/2000/2000-11-16.parquet size: 303 KB rows: 15,689 symbols: 1,239
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-11-16 08:00:00 | AAPL | Stock | 0.3538 | 0.3538 | 0.3527 | 0.3538 | 61600.0 |
| 2000-11-16 09:00:00 | AAPL | Stock | 0.3549 | 0.356 | 0.3438 | 0.3493 | 29528800.0 |
| 2000-11-16 10:00:00 | AAPL | Stock | 0.3493 | 0.3538 | 0.3493 | 0.3516 | 32340000.0 |
| 2000-11-16 11:00:00 | AAPL | Stock | 0.3516 | 0.3527 | 0.346 | 0.3482 | 15848000.0 |
| 2000-11-16 12:00:00 | AAPL | Stock | 0.3471 | 0.3482 | 0.3415 | 0.3438 | 22192800.0 |
| 2000-11-16 13:00:00 | AAPL | Stock | 0.3438 | 0.3449 | 0.3382 | 0.3393 | 44732800.0 |
| 2000-11-16 14:00:00 | AAPL | Stock | 0.3393 | 0.3415 | 0.3371 | 0.3371 | 29282400.0 |
| 2000-11-16 15:00:00 | AAPL | Stock | 0.3371 | 0.3438 | 0.3371 | 0.3404 | 45998400.0 |
| 2000-11-16 16:00:00 | AAPL | Stock | 0.3404 | 0.3415 | 0.3371 | 0.3393 | 4513600.0 |
| 2000-11-16 17:00:00 | AAPL | Stock | 0.3393 | 0.3393 | 0.3382 | 0.3382 | 308000.0 |
| 2000-11-16 18:00:00 | AAPL | Stock | 0.3415 | 0.3415 | 0.3415 | 0.3415 | 5600.0 |
| 2000-11-16 08:00:00 | MSFT | Stock | 35.0469 | 35.0469 | 34.75 | 34.8125 | 25200.0 |
| 2000-11-16 09:00:00 | MSFT | Stock | 34.75 | 35.2188 | 34.6875 | 35.125 | 6620200.0 |
| 2000-11-16 10:00:00 | MSFT | Stock | 35.0938 | 35.75 | 35.0625 | 35.3125 | 12097600.0 |
| 2000-11-16 11:00:00 | MSFT | Stock | 35.3125 | 35.4062 | 35.0 | 35.2188 | 6668600.0 |
| 2000-11-16 12:00:00 | MSFT | Stock | 35.2188 | 35.2812 | 35.0469 | 35.125 | 4949400.0 |
| 2000-11-16 13:00:00 | MSFT | Stock | 35.1562 | 35.4375 | 35.0 | 35.4062 | 11688000.0 |
| 2000-11-16 14:00:00 | MSFT | Stock | 35.4375 | 35.625 | 35.3438 | 35.3438 | 9736400.0 |
| 2000-11-16 15:00:00 | MSFT | Stock | 35.375 | 35.4688 | 34.4688 | 34.5 | 27578400.0 |
| 2000-11-16 16:00:00 | MSFT | Stock | 34.5 | 35.1875 | 34.4688 | 34.7188 | 4811200.0 |
| 2000-11-16 17:00:00 | MSFT | Stock | 34.6875 | 34.7812 | 34.4688 | 34.4688 | 1175000.0 |
| 2000-11-16 18:00:00 | MSFT | Stock | 34.625 | 34.6875 | 34.625 | 34.6875 | 1200.0 |
| 2000-11-16 09:00:00 | NVDA | Stock | 0.2792 | 0.2797 | 0.2729 | 0.2734 | 28680000.0 |
| 2000-11-16 10:00:00 | NVDA | Stock | 0.2745 | 0.2771 | 0.2682 | 0.2763 | 51192000.0 |
| 2000-11-16 11:00:00 | NVDA | Stock | 0.2771 | 0.2813 | 0.2755 | 0.2805 | 30120000.0 |
| 2000-11-16 12:00:00 | NVDA | Stock | 0.2802 | 0.2815 | 0.2763 | 0.2789 | 16032000.0 |
| 2000-11-16 13:00:00 | NVDA | Stock | 0.2794 | 0.2794 | 0.2719 | 0.2755 | 23064000.0 |
| 2000-11-16 14:00:00 | NVDA | Stock | 0.2755 | 0.2766 | 0.2721 | 0.2734 | 17040000.0 |
| 2000-11-16 15:00:00 | NVDA | Stock | 0.2734 | 0.2742 | 0.2667 | 0.2693 | 52896000.0 |
| 2000-11-16 16:00:00 | NVDA | Stock | 0.2698 | 0.2706 | 0.2667 | 0.2677 | 2664000.0 |
| 2000-11-16 08:00:00 | AMZN | Stock | 1.45 | 1.4781 | 1.45 | 1.45 | 128000.0 |
| 2000-11-16 09:00:00 | AMZN | Stock | 1.45 | 1.4938 | 1.425 | 1.4625 | 10676000.0 |
| 2000-11-16 10:00:00 | AMZN | Stock | 1.4625 | 1.525 | 1.45 | 1.5156 | 10802000.0 |
| 2000-11-16 11:00:00 | AMZN | Stock | 1.5125 | 1.525 | 1.4906 | 1.5156 | 9568000.0 |
| 2000-11-16 12:00:00 | AMZN | Stock | 1.5156 | 1.5188 | 1.4688 | 1.4844 | 7222000.0 |
| 2000-11-16 13:00:00 | AMZN | Stock | 1.4813 | 1.4875 | 1.45 | 1.4625 | 7338000.0 |
| 2000-11-16 14:00:00 | AMZN | Stock | 1.4625 | 1.4938 | 1.4031 | 1.4062 | 10796000.0 |
| 2000-11-16 15:00:00 | AMZN | Stock | 1.4062 | 1.4375 | 1.3875 | 1.3938 | 17636000.0 |
| 2000-11-16 16:00:00 | AMZN | Stock | 1.3938 | 1.425 | 1.3766 | 1.3938 | 2918000.0 |
| 2000-11-16 17:00:00 | AMZN | Stock | 1.3938 | 1.3938 | 1.3875 | 1.3906 | 64000.0 |
| 2000-11-16 18:00:00 | AMZN | Stock | 1.3906 | 1.4 | 1.3906 | 1.4 | 8000.0 |
| 2000-11-16 09:00:00 | CL | Stock | 29.5 | 29.625 | 29.27 | 29.27 | 246400.0 |
| 2000-11-16 10:00:00 | CL | Stock | 29.275 | 29.375 | 29.125 | 29.175 | 322800.0 |
| 2000-11-16 11:00:00 | CL | Stock | 29.2 | 29.29 | 29.125 | 29.225 | 319600.0 |
| 2000-11-16 12:00:00 | CL | Stock | 29.225 | 29.275 | 29.15 | 29.275 | 117000.0 |
| 2000-11-16 13:00:00 | CL | Stock | 29.295 | 29.35 | 29.19 | 29.2 | 151200.0 |
| 2000-11-16 14:00:00 | CL | Stock | 29.225 | 29.325 | 29.15 | 29.325 | 346600.0 |
| 2000-11-16 15:00:00 | CL | Stock | 29.325 | 29.47 | 29.325 | 29.445 | 594000.0 |
| 2000-11-16 16:00:00 | CL | Stock | 29.45 | 29.45 | 29.4 | 29.43 | 54200.0 |
| 2000-11-16 17:00:00 | CL | Stock | 29.43 | 29.43 | 29.43 | 29.43 | 86000.0 |
> showing 50 of 15,689 rows — these rows as CSV