PREVIEW / stock_1hour / 2001-11-29
file: by_date/stock_1hour/2001/2001-11-29.parquet size: 377 KB rows: 17,940 symbols: 1,358
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-11-29 08:00:00 | AAPL | Stock | 0.3667 | 0.3679 | 0.3666 | 0.3679 | 436800.0 |
| 2001-11-29 09:00:00 | AAPL | Stock | 0.3679 | 0.3696 | 0.3616 | 0.3627 | 26700800.0 |
| 2001-11-29 10:00:00 | AAPL | Stock | 0.363 | 0.3657 | 0.3613 | 0.3641 | 36209600.0 |
| 2001-11-29 11:00:00 | AAPL | Stock | 0.3641 | 0.3689 | 0.3636 | 0.3677 | 23609600.0 |
| 2001-11-29 12:00:00 | AAPL | Stock | 0.3673 | 0.3682 | 0.3643 | 0.3664 | 10141600.0 |
| 2001-11-29 13:00:00 | AAPL | Stock | 0.3664 | 0.3664 | 0.3605 | 0.3646 | 15836800.0 |
| 2001-11-29 14:00:00 | AAPL | Stock | 0.3646 | 0.3684 | 0.362 | 0.3643 | 31791200.0 |
| 2001-11-29 15:00:00 | AAPL | Stock | 0.3634 | 0.3693 | 0.3627 | 0.3639 | 41255200.0 |
| 2001-11-29 16:00:00 | AAPL | Stock | 0.3646 | 0.3679 | 0.3634 | 0.3646 | 9122400.0 |
| 2001-11-29 17:00:00 | AAPL | Stock | 0.3661 | 0.3661 | 0.3661 | 0.3661 | 56000.0 |
| 2001-11-29 08:00:00 | MSFT | Stock | 31.5 | 31.615 | 31.4025 | 31.505 | 52400.0 |
| 2001-11-29 09:00:00 | MSFT | Stock | 31.5 | 31.875 | 31.4795 | 31.655 | 6257600.0 |
| 2001-11-29 10:00:00 | MSFT | Stock | 31.655 | 31.9985 | 31.58 | 31.81 | 8401400.0 |
| 2001-11-29 11:00:00 | MSFT | Stock | 31.81 | 31.885 | 31.57 | 31.8355 | 5270000.0 |
| 2001-11-29 12:00:00 | MSFT | Stock | 31.8355 | 32.0255 | 31.775 | 31.875 | 6337400.0 |
| 2001-11-29 13:00:00 | MSFT | Stock | 31.87 | 32.1195 | 31.72 | 32.11 | 5466200.0 |
| 2001-11-29 14:00:00 | MSFT | Stock | 32.115 | 32.4 | 32.09 | 32.245 | 8166600.0 |
| 2001-11-29 15:00:00 | MSFT | Stock | 32.246 | 32.45 | 32.065 | 32.345 | 9494000.0 |
| 2001-11-29 16:00:00 | MSFT | Stock | 32.425 | 32.475 | 31.9458 | 32.43 | 2847000.0 |
| 2001-11-29 17:00:00 | MSFT | Stock | 32.375 | 32.42 | 32.25 | 32.275 | 84200.0 |
| 2001-11-29 18:00:00 | MSFT | Stock | 32.275 | 32.32 | 32.275 | 32.29 | 8000.0 |
| 2001-11-29 08:00:00 | NVDA | Stock | 0.4617 | 0.47 | 0.4542 | 0.4562 | 38016000.0 |
| 2001-11-29 09:00:00 | NVDA | Stock | 0.4575 | 0.4707 | 0.4504 | 0.4526 | 429180000.0 |
| 2001-11-29 10:00:00 | NVDA | Stock | 0.4526 | 0.4562 | 0.4502 | 0.453 | 327336000.0 |
| 2001-11-29 11:00:00 | NVDA | Stock | 0.453 | 0.454 | 0.4488 | 0.4539 | 221760000.0 |
| 2001-11-29 12:00:00 | NVDA | Stock | 0.4539 | 0.458 | 0.4538 | 0.4575 | 203112000.0 |
| 2001-11-29 13:00:00 | NVDA | Stock | 0.4575 | 0.4583 | 0.455 | 0.4583 | 237204000.0 |
| 2001-11-29 14:00:00 | NVDA | Stock | 0.4583 | 0.4614 | 0.4555 | 0.4588 | 407736000.0 |
| 2001-11-29 15:00:00 | NVDA | Stock | 0.4592 | 0.4594 | 0.445 | 0.4469 | 1317348000.0 |
| 2001-11-29 16:00:00 | NVDA | Stock | 0.4467 | 0.459 | 0.4417 | 0.4467 | 1887132000.0 |
| 2001-11-29 17:00:00 | NVDA | Stock | 0.4426 | 0.4467 | 0.4426 | 0.4446 | 138948000.0 |
| 2001-11-29 18:00:00 | NVDA | Stock | 0.4446 | 0.445 | 0.444 | 0.445 | 456000.0 |
| 2001-11-29 08:00:00 | AMZN | Stock | 0.5788 | 0.6075 | 0.5788 | 0.592 | 4704000.0 |
| 2001-11-29 09:00:00 | AMZN | Stock | 0.5935 | 0.6005 | 0.5615 | 0.5675 | 70236000.0 |
| 2001-11-29 10:00:00 | AMZN | Stock | 0.5675 | 0.5715 | 0.5415 | 0.546 | 94678000.0 |
| 2001-11-29 11:00:00 | AMZN | Stock | 0.5455 | 0.567 | 0.5395 | 0.559 | 54276000.0 |
| 2001-11-29 12:00:00 | AMZN | Stock | 0.559 | 0.5645 | 0.5485 | 0.551 | 31656000.0 |
| 2001-11-29 13:00:00 | AMZN | Stock | 0.551 | 0.5535 | 0.542 | 0.5505 | 29646000.0 |
| 2001-11-29 14:00:00 | AMZN | Stock | 0.551 | 0.5595 | 0.544 | 0.544 | 27484000.0 |
| 2001-11-29 15:00:00 | AMZN | Stock | 0.545 | 0.56 | 0.541 | 0.5585 | 48134000.0 |
| 2001-11-29 16:00:00 | AMZN | Stock | 0.559 | 0.565 | 0.5545 | 0.5575 | 10818000.0 |
| 2001-11-29 17:00:00 | AMZN | Stock | 0.559 | 0.559 | 0.556 | 0.5565 | 292000.0 |
| 2001-11-29 18:00:00 | AMZN | Stock | 0.5555 | 0.5555 | 0.5545 | 0.555 | 34000.0 |
| 2001-11-29 09:00:00 | CL | Stock | 29.05 | 29.05 | 28.61 | 28.61 | 340600.0 |
| 2001-11-29 10:00:00 | CL | Stock | 28.645 | 28.89 | 28.505 | 28.775 | 316200.0 |
| 2001-11-29 11:00:00 | CL | Stock | 28.775 | 28.81 | 28.71 | 28.805 | 128200.0 |
| 2001-11-29 12:00:00 | CL | Stock | 28.8 | 28.84 | 28.755 | 28.805 | 187600.0 |
| 2001-11-29 13:00:00 | CL | Stock | 28.805 | 28.805 | 28.67 | 28.68 | 246200.0 |
| 2001-11-29 14:00:00 | CL | Stock | 28.68 | 28.825 | 28.66 | 28.77 | 263600.0 |
| 2001-11-29 15:00:00 | CL | Stock | 28.73 | 28.9 | 28.625 | 28.85 | 684400.0 |
> showing 50 of 17,940 rows — these rows as CSV