PREVIEW / stock_1hour / 2001-10-04
file: by_date/stock_1hour/2001/2001-10-04.parquet size: 360 KB rows: 17,527 symbols: 1,337
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-10-04 08:00:00 | AAPL | Stock | 0.2672 | 0.2786 | 0.2672 | 0.2768 | 1596000.0 |
| 2001-10-04 09:00:00 | AAPL | Stock | 0.2768 | 0.2768 | 0.2678 | 0.2725 | 60709600.0 |
| 2001-10-04 10:00:00 | AAPL | Stock | 0.2725 | 0.2805 | 0.2721 | 0.2805 | 78248800.0 |
| 2001-10-04 11:00:00 | AAPL | Stock | 0.2804 | 0.2902 | 0.2798 | 0.2868 | 74328800.0 |
| 2001-10-04 12:00:00 | AAPL | Stock | 0.2868 | 0.2879 | 0.2848 | 0.2868 | 26437600.0 |
| 2001-10-04 13:00:00 | AAPL | Stock | 0.2868 | 0.2902 | 0.2857 | 0.2884 | 26997600.0 |
| 2001-10-04 14:00:00 | AAPL | Stock | 0.2882 | 0.2884 | 0.2813 | 0.2875 | 35050400.0 |
| 2001-10-04 15:00:00 | AAPL | Stock | 0.2875 | 0.2884 | 0.2732 | 0.2836 | 61717600.0 |
| 2001-10-04 16:00:00 | AAPL | Stock | 0.2834 | 0.2836 | 0.2768 | 0.2836 | 16251200.0 |
| 2001-10-04 08:00:00 | MSFT | Stock | 28.125 | 29.0 | 28.125 | 28.475 | 187200.0 |
| 2001-10-04 09:00:00 | MSFT | Stock | 28.455 | 28.57 | 28.2115 | 28.4405 | 12178600.0 |
| 2001-10-04 10:00:00 | MSFT | Stock | 28.4405 | 28.6295 | 28.1445 | 28.5 | 16790200.0 |
| 2001-10-04 11:00:00 | MSFT | Stock | 28.5 | 29.15 | 28.425 | 28.945 | 15182000.0 |
| 2001-10-04 12:00:00 | MSFT | Stock | 28.94 | 29.07 | 28.715 | 28.985 | 6682600.0 |
| 2001-10-04 13:00:00 | MSFT | Stock | 28.985 | 29.2005 | 28.375 | 28.625 | 11320800.0 |
| 2001-10-04 14:00:00 | MSFT | Stock | 28.6495 | 28.705 | 28.2 | 28.585 | 12951000.0 |
| 2001-10-04 15:00:00 | MSFT | Stock | 28.5855 | 28.825 | 28.105 | 28.195 | 17149400.0 |
| 2001-10-04 16:00:00 | MSFT | Stock | 28.215 | 28.79 | 28.185 | 28.5772 | 3681400.0 |
| 2001-10-04 17:00:00 | MSFT | Stock | 28.29 | 28.295 | 28.185 | 28.185 | 8600.0 |
| 2001-10-04 18:00:00 | MSFT | Stock | 28.1 | 28.1 | 28.1 | 28.1 | 800.0 |
| 2001-10-04 08:00:00 | NVDA | Stock | 0.2408 | 0.2507 | 0.2396 | 0.25 | 3240000.0 |
| 2001-10-04 09:00:00 | NVDA | Stock | 0.2492 | 0.2509 | 0.2422 | 0.2492 | 232788000.0 |
| 2001-10-04 10:00:00 | NVDA | Stock | 0.2496 | 0.2734 | 0.2492 | 0.2724 | 418800000.0 |
| 2001-10-04 11:00:00 | NVDA | Stock | 0.2724 | 0.2817 | 0.2715 | 0.2737 | 369600000.0 |
| 2001-10-04 12:00:00 | NVDA | Stock | 0.2737 | 0.275 | 0.2687 | 0.2724 | 132924000.0 |
| 2001-10-04 13:00:00 | NVDA | Stock | 0.2725 | 0.2792 | 0.2692 | 0.2718 | 104148000.0 |
| 2001-10-04 14:00:00 | NVDA | Stock | 0.2718 | 0.2729 | 0.2678 | 0.2718 | 243012000.0 |
| 2001-10-04 15:00:00 | NVDA | Stock | 0.2724 | 0.2749 | 0.2636 | 0.2692 | 333012000.0 |
| 2001-10-04 16:00:00 | NVDA | Stock | 0.2692 | 0.2708 | 0.2583 | 0.2691 | 31248000.0 |
| 2001-10-04 17:00:00 | NVDA | Stock | 0.2692 | 0.2707 | 0.2692 | 0.2692 | 360000.0 |
| 2001-10-04 08:00:00 | AMZN | Stock | 0.3378 | 0.345 | 0.3378 | 0.345 | 286000.0 |
| 2001-10-04 09:00:00 | AMZN | Stock | 0.3515 | 0.359 | 0.335 | 0.3425 | 11804000.0 |
| 2001-10-04 10:00:00 | AMZN | Stock | 0.3425 | 0.3635 | 0.342 | 0.363 | 16228000.0 |
| 2001-10-04 11:00:00 | AMZN | Stock | 0.363 | 0.3935 | 0.3605 | 0.376 | 32156000.0 |
| 2001-10-04 12:00:00 | AMZN | Stock | 0.376 | 0.38 | 0.365 | 0.372 | 8568000.0 |
| 2001-10-04 13:00:00 | AMZN | Stock | 0.3715 | 0.3775 | 0.3625 | 0.371 | 9298000.0 |
| 2001-10-04 14:00:00 | AMZN | Stock | 0.3715 | 0.372 | 0.3515 | 0.3595 | 13070000.0 |
| 2001-10-04 15:00:00 | AMZN | Stock | 0.3595 | 0.3625 | 0.351 | 0.3515 | 19360000.0 |
| 2001-10-04 16:00:00 | AMZN | Stock | 0.352 | 0.3656 | 0.35 | 0.355 | 4618000.0 |
| 2001-10-04 17:00:00 | AMZN | Stock | 0.3515 | 0.353 | 0.351 | 0.353 | 82000.0 |
| 2001-10-04 18:00:00 | AMZN | Stock | 0.35 | 0.35 | 0.349 | 0.349 | 12000.0 |
| 2001-10-04 09:00:00 | CL | Stock | 28.345 | 28.345 | 27.925 | 28.13 | 343400.0 |
| 2001-10-04 10:00:00 | CL | Stock | 28.155 | 28.285 | 28.0 | 28.245 | 394400.0 |
| 2001-10-04 11:00:00 | CL | Stock | 28.245 | 28.25 | 28.125 | 28.15 | 217800.0 |
| 2001-10-04 12:00:00 | CL | Stock | 28.15 | 28.425 | 28.085 | 28.4 | 235600.0 |
| 2001-10-04 13:00:00 | CL | Stock | 28.405 | 28.43 | 28.225 | 28.36 | 292200.0 |
| 2001-10-04 14:00:00 | CL | Stock | 28.365 | 28.365 | 28.165 | 28.32 | 303600.0 |
| 2001-10-04 15:00:00 | CL | Stock | 28.305 | 28.32 | 27.95 | 28.055 | 723200.0 |
| 2001-10-04 16:00:00 | CL | Stock | 28.055 | 28.165 | 28.055 | 28.075 | 12400.0 |
| 2001-10-04 17:00:00 | CL | Stock | 28.075 | 28.075 | 28.075 | 28.075 | 20000.0 |
> showing 50 of 17,527 rows — these rows as CSV