PREVIEW / stock_1hour / 2001-04-06
file: by_date/stock_1hour/2001/2001-04-06.parquet size: 343 KB rows: 16,249 symbols: 1,279
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-06 08:00:00 | AAPL | Stock | 0.3725 | 0.3725 | 0.3593 | 0.3616 | 1008000.0 |
| 2001-04-06 09:00:00 | AAPL | Stock | 0.3629 | 0.375 | 0.3629 | 0.3729 | 39295200.0 |
| 2001-04-06 10:00:00 | AAPL | Stock | 0.3729 | 0.373 | 0.3563 | 0.3602 | 54790400.0 |
| 2001-04-06 11:00:00 | AAPL | Stock | 0.3604 | 0.3714 | 0.3571 | 0.3714 | 36450400.0 |
| 2001-04-06 12:00:00 | AAPL | Stock | 0.3709 | 0.3757 | 0.3613 | 0.3705 | 44049600.0 |
| 2001-04-06 13:00:00 | AAPL | Stock | 0.3698 | 0.375 | 0.3663 | 0.3693 | 28812000.0 |
| 2001-04-06 14:00:00 | AAPL | Stock | 0.3693 | 0.3705 | 0.3571 | 0.3595 | 37699200.0 |
| 2001-04-06 15:00:00 | AAPL | Stock | 0.3598 | 0.3679 | 0.3554 | 0.3675 | 65777600.0 |
| 2001-04-06 16:00:00 | AAPL | Stock | 0.3677 | 0.3682 | 0.3648 | 0.3677 | 13344800.0 |
| 2001-04-06 17:00:00 | AAPL | Stock | 0.3677 | 0.3677 | 0.3661 | 0.3661 | 33600.0 |
| 2001-04-06 08:00:00 | MSFT | Stock | 28.3125 | 28.3906 | 27.9375 | 28.25 | 279600.0 |
| 2001-04-06 09:00:00 | MSFT | Stock | 28.25 | 28.375 | 27.8125 | 27.9219 | 17860600.0 |
| 2001-04-06 10:00:00 | MSFT | Stock | 27.9062 | 28.2188 | 27.75 | 28.0625 | 15948800.0 |
| 2001-04-06 11:00:00 | MSFT | Stock | 28.0469 | 28.2812 | 27.8438 | 28.2188 | 8292000.0 |
| 2001-04-06 12:00:00 | MSFT | Stock | 28.2812 | 28.3438 | 27.75 | 28.0938 | 11646800.0 |
| 2001-04-06 13:00:00 | MSFT | Stock | 28.0938 | 28.5938 | 28.0 | 28.4375 | 7206800.0 |
| 2001-04-06 14:00:00 | MSFT | Stock | 28.4375 | 28.5 | 27.6875 | 27.8125 | 11816600.0 |
| 2001-04-06 15:00:00 | MSFT | Stock | 27.8125 | 28.1875 | 27.5312 | 28.125 | 14144600.0 |
| 2001-04-06 16:00:00 | MSFT | Stock | 28.0938 | 28.2812 | 28.0312 | 28.25 | 4127200.0 |
| 2001-04-06 17:00:00 | MSFT | Stock | 28.0938 | 28.2656 | 28.0938 | 28.2656 | 64400.0 |
| 2001-04-06 18:00:00 | MSFT | Stock | 28.1562 | 28.1719 | 28.1562 | 28.1562 | 2200.0 |
| 2001-04-06 08:00:00 | NVDA | Stock | 0.2625 | 0.2625 | 0.2568 | 0.2594 | 3312000.0 |
| 2001-04-06 09:00:00 | NVDA | Stock | 0.2568 | 0.2656 | 0.2557 | 0.2617 | 169368000.0 |
| 2001-04-06 10:00:00 | NVDA | Stock | 0.2615 | 0.262 | 0.2544 | 0.2612 | 184656000.0 |
| 2001-04-06 11:00:00 | NVDA | Stock | 0.2615 | 0.2724 | 0.2609 | 0.2721 | 215088000.0 |
| 2001-04-06 12:00:00 | NVDA | Stock | 0.2719 | 0.2734 | 0.2656 | 0.2729 | 196464000.0 |
| 2001-04-06 13:00:00 | NVDA | Stock | 0.2729 | 0.275 | 0.269 | 0.2719 | 156888000.0 |
| 2001-04-06 14:00:00 | NVDA | Stock | 0.2716 | 0.2729 | 0.2646 | 0.2656 | 268608000.0 |
| 2001-04-06 15:00:00 | NVDA | Stock | 0.2656 | 0.2656 | 0.2565 | 0.2612 | 287592000.0 |
| 2001-04-06 16:00:00 | NVDA | Stock | 0.2612 | 0.263 | 0.257 | 0.2625 | 31248000.0 |
| 2001-04-06 17:00:00 | NVDA | Stock | 0.2612 | 0.2646 | 0.2612 | 0.2646 | 360000.0 |
| 2001-04-06 08:00:00 | AMZN | Stock | 0.4625 | 0.4625 | 0.442 | 0.4465 | 94000.0 |
| 2001-04-06 09:00:00 | AMZN | Stock | 0.445 | 0.45 | 0.4165 | 0.421 | 11500000.0 |
| 2001-04-06 10:00:00 | AMZN | Stock | 0.4215 | 0.428 | 0.417 | 0.422 | 10484000.0 |
| 2001-04-06 11:00:00 | AMZN | Stock | 0.422 | 0.4265 | 0.421 | 0.424 | 11782000.0 |
| 2001-04-06 12:00:00 | AMZN | Stock | 0.4235 | 0.4275 | 0.4205 | 0.4255 | 13184000.0 |
| 2001-04-06 13:00:00 | AMZN | Stock | 0.426 | 0.429 | 0.425 | 0.426 | 15482000.0 |
| 2001-04-06 14:00:00 | AMZN | Stock | 0.4255 | 0.43 | 0.41 | 0.4145 | 10074000.0 |
| 2001-04-06 15:00:00 | AMZN | Stock | 0.4145 | 0.425 | 0.4135 | 0.4185 | 19810000.0 |
| 2001-04-06 16:00:00 | AMZN | Stock | 0.4185 | 0.4245 | 0.4175 | 0.4185 | 2776000.0 |
| 2001-04-06 17:00:00 | AMZN | Stock | 0.4225 | 0.4225 | 0.4225 | 0.4225 | 12000.0 |
| 2001-04-06 09:00:00 | CL | Stock | 27.25 | 27.325 | 27.22 | 27.285 | 315600.0 |
| 2001-04-06 10:00:00 | CL | Stock | 27.285 | 27.29 | 26.85 | 26.92 | 451200.0 |
| 2001-04-06 11:00:00 | CL | Stock | 26.92 | 27.0 | 26.6 | 26.64 | 453800.0 |
| 2001-04-06 12:00:00 | CL | Stock | 26.635 | 26.635 | 26.05 | 26.475 | 606600.0 |
| 2001-04-06 13:00:00 | CL | Stock | 26.425 | 26.775 | 26.225 | 26.775 | 426000.0 |
| 2001-04-06 14:00:00 | CL | Stock | 26.775 | 26.825 | 26.535 | 26.825 | 393000.0 |
| 2001-04-06 15:00:00 | CL | Stock | 26.725 | 26.84 | 26.695 | 26.84 | 542400.0 |
| 2001-04-06 16:00:00 | CL | Stock | 26.875 | 26.875 | 26.875 | 26.875 | 103800.0 |
| 2001-04-06 17:00:00 | CL | Stock | 26.875 | 26.875 | 26.875 | 26.875 | 2000.0 |
> showing 50 of 16,249 rows — these rows as CSV