PREVIEW / stock_1hour / 2001-04-05
file: by_date/stock_1hour/2001/2001-04-05.parquet size: 351 KB rows: 16,650 symbols: 1,283
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-04-05 08:00:00 | AAPL | Stock | 0.3659 | 0.3784 | 0.3607 | 0.3661 | 2161600.0 |
| 2001-04-05 09:00:00 | AAPL | Stock | 0.3704 | 0.3705 | 0.3571 | 0.362 | 70425600.0 |
| 2001-04-05 10:00:00 | AAPL | Stock | 0.3646 | 0.375 | 0.3616 | 0.3675 | 75504800.0 |
| 2001-04-05 11:00:00 | AAPL | Stock | 0.3673 | 0.3705 | 0.3625 | 0.3702 | 48916000.0 |
| 2001-04-05 12:00:00 | AAPL | Stock | 0.3704 | 0.3723 | 0.3666 | 0.3705 | 34395200.0 |
| 2001-04-05 13:00:00 | AAPL | Stock | 0.3705 | 0.3764 | 0.3702 | 0.3736 | 40040000.0 |
| 2001-04-05 14:00:00 | AAPL | Stock | 0.3739 | 0.3839 | 0.372 | 0.3825 | 53284000.0 |
| 2001-04-05 15:00:00 | AAPL | Stock | 0.3827 | 0.3866 | 0.3721 | 0.3727 | 80802400.0 |
| 2001-04-05 16:00:00 | AAPL | Stock | 0.3725 | 0.3732 | 0.3625 | 0.3727 | 27165600.0 |
| 2001-04-05 17:00:00 | AAPL | Stock | 0.3727 | 0.3727 | 0.3696 | 0.3698 | 123200.0 |
| 2001-04-05 18:00:00 | AAPL | Stock | 0.3721 | 0.3721 | 0.3721 | 0.3721 | 16800.0 |
| 2001-04-05 08:00:00 | MSFT | Stock | 27.0156 | 27.25 | 25.8281 | 27.0 | 618400.0 |
| 2001-04-05 09:00:00 | MSFT | Stock | 27.0312 | 27.2188 | 26.125 | 27.0625 | 16583400.0 |
| 2001-04-05 10:00:00 | MSFT | Stock | 27.0781 | 27.5938 | 27.0156 | 27.5625 | 16987200.0 |
| 2001-04-05 11:00:00 | MSFT | Stock | 27.5938 | 27.6875 | 27.25 | 27.6875 | 9329200.0 |
| 2001-04-05 12:00:00 | MSFT | Stock | 27.6875 | 27.9375 | 27.5 | 27.9062 | 8903000.0 |
| 2001-04-05 13:00:00 | MSFT | Stock | 27.9062 | 28.1562 | 27.75 | 27.9688 | 8227400.0 |
| 2001-04-05 14:00:00 | MSFT | Stock | 27.9688 | 28.5469 | 27.9062 | 28.2188 | 15661200.0 |
| 2001-04-05 15:00:00 | MSFT | Stock | 28.2188 | 28.6875 | 28.2188 | 28.375 | 30548800.0 |
| 2001-04-05 16:00:00 | MSFT | Stock | 28.375 | 28.625 | 27.8438 | 28.4062 | 5511600.0 |
| 2001-04-05 17:00:00 | MSFT | Stock | 28.375 | 28.375 | 28.2812 | 28.2812 | 65800.0 |
| 2001-04-05 18:00:00 | MSFT | Stock | 28.2812 | 28.4062 | 28.2812 | 28.4062 | 2800.0 |
| 2001-04-05 08:00:00 | NVDA | Stock | 0.2542 | 0.2594 | 0.2505 | 0.2542 | 9288000.0 |
| 2001-04-05 09:00:00 | NVDA | Stock | 0.2542 | 0.2573 | 0.249 | 0.2526 | 329400000.0 |
| 2001-04-05 10:00:00 | NVDA | Stock | 0.2529 | 0.2573 | 0.249 | 0.2549 | 324984000.0 |
| 2001-04-05 11:00:00 | NVDA | Stock | 0.2549 | 0.257 | 0.2508 | 0.2534 | 150480000.0 |
| 2001-04-05 12:00:00 | NVDA | Stock | 0.2536 | 0.2635 | 0.2534 | 0.2622 | 234456000.0 |
| 2001-04-05 13:00:00 | NVDA | Stock | 0.2617 | 0.2646 | 0.2599 | 0.2641 | 152232000.0 |
| 2001-04-05 14:00:00 | NVDA | Stock | 0.2641 | 0.2656 | 0.2617 | 0.2638 | 244752000.0 |
| 2001-04-05 15:00:00 | NVDA | Stock | 0.2635 | 0.2664 | 0.2604 | 0.2622 | 220488000.0 |
| 2001-04-05 16:00:00 | NVDA | Stock | 0.2625 | 0.2629 | 0.2604 | 0.2625 | 15312000.0 |
| 2001-04-05 17:00:00 | NVDA | Stock | 0.2646 | 0.2646 | 0.2622 | 0.2625 | 600000.0 |
| 2001-04-05 18:00:00 | NVDA | Stock | 0.2625 | 0.2625 | 0.2615 | 0.262 | 720000.0 |
| 2001-04-05 08:00:00 | AMZN | Stock | 0.45 | 0.457 | 0.4175 | 0.45 | 396000.0 |
| 2001-04-05 09:00:00 | AMZN | Stock | 0.45 | 0.457 | 0.4455 | 0.4495 | 12618000.0 |
| 2001-04-05 10:00:00 | AMZN | Stock | 0.4495 | 0.465 | 0.448 | 0.4565 | 18736000.0 |
| 2001-04-05 11:00:00 | AMZN | Stock | 0.454 | 0.459 | 0.436 | 0.446 | 13000000.0 |
| 2001-04-05 12:00:00 | AMZN | Stock | 0.446 | 0.455 | 0.443 | 0.45 | 7928000.0 |
| 2001-04-05 13:00:00 | AMZN | Stock | 0.45 | 0.4515 | 0.4385 | 0.4405 | 6240000.0 |
| 2001-04-05 14:00:00 | AMZN | Stock | 0.4385 | 0.449 | 0.438 | 0.443 | 7220000.0 |
| 2001-04-05 15:00:00 | AMZN | Stock | 0.4425 | 0.46 | 0.4365 | 0.456 | 22076000.0 |
| 2001-04-05 16:00:00 | AMZN | Stock | 0.456 | 0.456 | 0.4525 | 0.4555 | 2590000.0 |
| 2001-04-05 17:00:00 | AMZN | Stock | 0.456 | 0.456 | 0.4525 | 0.454 | 24000.0 |
| 2001-04-05 18:00:00 | AMZN | Stock | 0.4555 | 0.4555 | 0.4555 | 0.4555 | 2000.0 |
| 2001-04-05 09:00:00 | CL | Stock | 27.25 | 27.25 | 27.0 | 27.0 | 274400.0 |
| 2001-04-05 10:00:00 | CL | Stock | 26.975 | 27.01 | 26.75 | 26.99 | 503200.0 |
| 2001-04-05 11:00:00 | CL | Stock | 26.97 | 26.98 | 26.77 | 26.85 | 249400.0 |
| 2001-04-05 12:00:00 | CL | Stock | 26.85 | 26.925 | 26.65 | 26.795 | 231400.0 |
| 2001-04-05 13:00:00 | CL | Stock | 26.795 | 27.115 | 26.79 | 27.08 | 338200.0 |
| 2001-04-05 14:00:00 | CL | Stock | 27.075 | 27.545 | 27.055 | 27.5 | 403400.0 |
> showing 50 of 16,650 rows — these rows as CSV