PREVIEW / stock_1hour / 2001-06-12
file: by_date/stock_1hour/2001/2001-06-12.parquet size: 361 KB rows: 17,054 symbols: 1,303
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-06-12 08:00:00 | AAPL | Stock | 0.373 | 0.373 | 0.3561 | 0.3561 | 44800.0 |
| 2001-06-12 09:00:00 | AAPL | Stock | 0.3545 | 0.3586 | 0.3529 | 0.3579 | 55014400.0 |
| 2001-06-12 10:00:00 | AAPL | Stock | 0.3586 | 0.3596 | 0.3529 | 0.3575 | 54661600.0 |
| 2001-06-12 11:00:00 | AAPL | Stock | 0.3575 | 0.3586 | 0.3563 | 0.3573 | 30021600.0 |
| 2001-06-12 12:00:00 | AAPL | Stock | 0.3573 | 0.3579 | 0.3548 | 0.3563 | 17953600.0 |
| 2001-06-12 13:00:00 | AAPL | Stock | 0.3564 | 0.3627 | 0.3557 | 0.3577 | 36349600.0 |
| 2001-06-12 14:00:00 | AAPL | Stock | 0.3577 | 0.3648 | 0.3575 | 0.3629 | 38102400.0 |
| 2001-06-12 15:00:00 | AAPL | Stock | 0.3627 | 0.3695 | 0.3604 | 0.3627 | 55020000.0 |
| 2001-06-12 16:00:00 | AAPL | Stock | 0.3627 | 0.3629 | 0.3545 | 0.3614 | 4256000.0 |
| 2001-06-12 17:00:00 | AAPL | Stock | 0.3589 | 0.3614 | 0.3586 | 0.3586 | 22400.0 |
| 2001-06-12 08:00:00 | MSFT | Stock | 35.875 | 36.085 | 35.475 | 35.55 | 567000.0 |
| 2001-06-12 09:00:00 | MSFT | Stock | 35.525 | 35.72 | 35.47 | 35.68 | 10377800.0 |
| 2001-06-12 10:00:00 | MSFT | Stock | 35.68 | 35.715 | 35.405 | 35.565 | 10181000.0 |
| 2001-06-12 11:00:00 | MSFT | Stock | 35.56 | 35.61 | 35.425 | 35.54 | 8202600.0 |
| 2001-06-12 12:00:00 | MSFT | Stock | 35.545 | 35.55 | 35.465 | 35.525 | 4781600.0 |
| 2001-06-12 13:00:00 | MSFT | Stock | 35.525 | 35.775 | 35.485 | 35.7 | 6349200.0 |
| 2001-06-12 14:00:00 | MSFT | Stock | 35.7 | 35.99 | 35.67 | 35.945 | 6368000.0 |
| 2001-06-12 15:00:00 | MSFT | Stock | 35.945 | 36.205 | 35.865 | 36.035 | 13985000.0 |
| 2001-06-12 16:00:00 | MSFT | Stock | 36.04 | 36.06 | 35.715 | 36.04 | 3107000.0 |
| 2001-06-12 17:00:00 | MSFT | Stock | 36.035 | 36.035 | 35.975 | 36.0 | 3200.0 |
| 2001-06-12 08:00:00 | NVDA | Stock | 0.3887 | 0.3887 | 0.3867 | 0.3867 | 216000.0 |
| 2001-06-12 09:00:00 | NVDA | Stock | 0.3854 | 0.3885 | 0.383 | 0.3871 | 96096000.0 |
| 2001-06-12 10:00:00 | NVDA | Stock | 0.3871 | 0.3875 | 0.3823 | 0.3846 | 138960000.0 |
| 2001-06-12 11:00:00 | NVDA | Stock | 0.3849 | 0.3952 | 0.3844 | 0.3927 | 153840000.0 |
| 2001-06-12 12:00:00 | NVDA | Stock | 0.3928 | 0.3928 | 0.3903 | 0.3916 | 101808000.0 |
| 2001-06-12 13:00:00 | NVDA | Stock | 0.3915 | 0.4013 | 0.391 | 0.3994 | 171144000.0 |
| 2001-06-12 14:00:00 | NVDA | Stock | 0.3994 | 0.4088 | 0.3988 | 0.4088 | 142032000.0 |
| 2001-06-12 15:00:00 | NVDA | Stock | 0.4088 | 0.4102 | 0.4033 | 0.4042 | 234048000.0 |
| 2001-06-12 16:00:00 | NVDA | Stock | 0.4045 | 0.406 | 0.3957 | 0.4052 | 23376000.0 |
| 2001-06-12 17:00:00 | NVDA | Stock | 0.405 | 0.4064 | 0.405 | 0.405 | 408000.0 |
| 2001-06-12 18:00:00 | NVDA | Stock | 0.4054 | 0.4054 | 0.4052 | 0.4052 | 48000.0 |
| 2001-06-12 08:00:00 | AMZN | Stock | 0.743 | 0.743 | 0.725 | 0.725 | 108000.0 |
| 2001-06-12 09:00:00 | AMZN | Stock | 0.7225 | 0.739 | 0.721 | 0.736 | 6924000.0 |
| 2001-06-12 10:00:00 | AMZN | Stock | 0.736 | 0.737 | 0.7185 | 0.7245 | 21552000.0 |
| 2001-06-12 11:00:00 | AMZN | Stock | 0.7245 | 0.73 | 0.724 | 0.7295 | 6540000.0 |
| 2001-06-12 12:00:00 | AMZN | Stock | 0.729 | 0.731 | 0.716 | 0.7165 | 11374000.0 |
| 2001-06-12 13:00:00 | AMZN | Stock | 0.717 | 0.727 | 0.716 | 0.7215 | 12812000.0 |
| 2001-06-12 14:00:00 | AMZN | Stock | 0.7215 | 0.731 | 0.721 | 0.73 | 8456000.0 |
| 2001-06-12 15:00:00 | AMZN | Stock | 0.73 | 0.7395 | 0.728 | 0.732 | 14042000.0 |
| 2001-06-12 16:00:00 | AMZN | Stock | 0.7315 | 0.733 | 0.73 | 0.733 | 1872000.0 |
| 2001-06-12 18:00:00 | AMZN | Stock | 0.7255 | 0.7255 | 0.7255 | 0.7255 | 2000.0 |
| 2001-06-12 09:00:00 | CL | Stock | 29.45 | 29.525 | 29.38 | 29.45 | 389200.0 |
| 2001-06-12 10:00:00 | CL | Stock | 29.45 | 29.45 | 29.165 | 29.225 | 306400.0 |
| 2001-06-12 11:00:00 | CL | Stock | 29.225 | 29.225 | 29.1 | 29.16 | 187400.0 |
| 2001-06-12 12:00:00 | CL | Stock | 29.16 | 29.16 | 29.11 | 29.135 | 158800.0 |
| 2001-06-12 13:00:00 | CL | Stock | 29.135 | 29.29 | 29.13 | 29.24 | 168800.0 |
| 2001-06-12 14:00:00 | CL | Stock | 29.24 | 29.3 | 29.235 | 29.3 | 211800.0 |
| 2001-06-12 15:00:00 | CL | Stock | 29.295 | 29.48 | 29.285 | 29.425 | 465800.0 |
| 2001-06-12 16:00:00 | CL | Stock | 29.415 | 29.415 | 29.32 | 29.32 | 27400.0 |
> showing 49 of 17,054 rows — these rows as CSV