PREVIEW / stock_1hour / 2000-02-10
file: by_date/stock_1hour/2000/2000-02-10.parquet size: 279 KB rows: 14,461 symbols: 1,142
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 |
|---|---|---|---|---|---|---|---|
| 2000-02-10 09:00:00 | AAPL | Stock | 1.0078 | 1.0089 | 0.9844 | 0.9877 | 39312000.0 |
| 2000-02-10 10:00:00 | AAPL | Stock | 0.9872 | 1.0022 | 0.981 | 0.9833 | 81580800.0 |
| 2000-02-10 11:00:00 | AAPL | Stock | 0.9833 | 0.9989 | 0.9777 | 0.9905 | 57400000.0 |
| 2000-02-10 12:00:00 | AAPL | Stock | 0.9897 | 1.0045 | 0.9897 | 0.9983 | 29232000.0 |
| 2000-02-10 13:00:00 | AAPL | Stock | 1.0 | 1.0017 | 0.9916 | 0.9978 | 22803200.0 |
| 2000-02-10 14:00:00 | AAPL | Stock | 0.9978 | 1.0011 | 0.9821 | 0.9869 | 26488000.0 |
| 2000-02-10 15:00:00 | AAPL | Stock | 0.9872 | 1.0167 | 0.9833 | 1.014 | 35044800.0 |
| 2000-02-10 16:00:00 | AAPL | Stock | 1.0134 | 1.014 | 1.0134 | 1.0134 | 1512000.0 |
| 2000-02-10 09:00:00 | MSFT | Stock | 51.9375 | 52.0625 | 51.5625 | 51.8125 | 6619600.0 |
| 2000-02-10 10:00:00 | MSFT | Stock | 51.8125 | 52.0938 | 51.25 | 51.5 | 8066000.0 |
| 2000-02-10 11:00:00 | MSFT | Stock | 51.5 | 51.875 | 51.4062 | 51.5938 | 6059200.0 |
| 2000-02-10 12:00:00 | MSFT | Stock | 51.5938 | 53.125 | 51.5938 | 52.7188 | 10361000.0 |
| 2000-02-10 13:00:00 | MSFT | Stock | 52.75 | 52.9375 | 52.4688 | 52.8125 | 5803000.0 |
| 2000-02-10 14:00:00 | MSFT | Stock | 52.8438 | 53.2812 | 52.5625 | 52.875 | 6148800.0 |
| 2000-02-10 15:00:00 | MSFT | Stock | 52.8438 | 53.0 | 52.5625 | 53.0 | 8739000.0 |
| 2000-02-10 16:00:00 | MSFT | Stock | 52.9375 | 53.0 | 52.9375 | 53.0 | 202200.0 |
| 2000-02-10 09:00:00 | NVDA | Stock | 0.0904 | 0.0966 | 0.0904 | 0.0931 | 208560000.0 |
| 2000-02-10 10:00:00 | NVDA | Stock | 0.0927 | 0.0937 | 0.0906 | 0.0928 | 125040000.0 |
| 2000-02-10 11:00:00 | NVDA | Stock | 0.0935 | 0.0937 | 0.0917 | 0.0937 | 61728000.0 |
| 2000-02-10 12:00:00 | NVDA | Stock | 0.0937 | 0.0945 | 0.0927 | 0.0945 | 78624000.0 |
| 2000-02-10 13:00:00 | NVDA | Stock | 0.0945 | 0.0952 | 0.094 | 0.094 | 84048000.0 |
| 2000-02-10 14:00:00 | NVDA | Stock | 0.094 | 0.101 | 0.094 | 0.0999 | 206784000.0 |
| 2000-02-10 15:00:00 | NVDA | Stock | 0.1 | 0.1042 | 0.0999 | 0.1026 | 151584000.0 |
| 2000-02-10 16:00:00 | NVDA | Stock | 0.1026 | 0.1029 | 0.1023 | 0.1026 | 3216000.0 |
| 2000-02-10 09:00:00 | AMZN | Stock | 3.925 | 3.9938 | 3.9125 | 3.9344 | 16904000.0 |
| 2000-02-10 10:00:00 | AMZN | Stock | 3.9344 | 3.9844 | 3.85 | 3.8812 | 34218000.0 |
| 2000-02-10 11:00:00 | AMZN | Stock | 3.8906 | 3.9125 | 3.8312 | 3.8906 | 19572000.0 |
| 2000-02-10 12:00:00 | AMZN | Stock | 3.8906 | 3.9438 | 3.85 | 3.8562 | 22668000.0 |
| 2000-02-10 13:00:00 | AMZN | Stock | 3.8594 | 3.9 | 3.825 | 3.8312 | 21378000.0 |
| 2000-02-10 14:00:00 | AMZN | Stock | 3.8312 | 3.8375 | 3.775 | 3.8 | 30980000.0 |
| 2000-02-10 15:00:00 | AMZN | Stock | 3.7938 | 3.8375 | 3.7812 | 3.8125 | 39986000.0 |
| 2000-02-10 16:00:00 | AMZN | Stock | 3.8062 | 3.8125 | 3.8 | 3.8094 | 400000.0 |
| 2000-02-10 09:00:00 | CL | Stock | 29.125 | 29.25 | 28.875 | 28.9062 | 191000.0 |
| 2000-02-10 10:00:00 | CL | Stock | 28.875 | 29.125 | 28.7812 | 28.875 | 348400.0 |
| 2000-02-10 11:00:00 | CL | Stock | 28.875 | 28.9375 | 28.6875 | 28.6875 | 246400.0 |
| 2000-02-10 12:00:00 | CL | Stock | 28.6875 | 28.9062 | 28.6875 | 28.875 | 282200.0 |
| 2000-02-10 13:00:00 | CL | Stock | 28.875 | 28.9062 | 28.7188 | 28.8438 | 212000.0 |
| 2000-02-10 14:00:00 | CL | Stock | 28.8438 | 28.9375 | 28.7188 | 28.7188 | 321000.0 |
| 2000-02-10 15:00:00 | CL | Stock | 28.75 | 28.875 | 28.6875 | 28.75 | 705800.0 |
| 2000-02-10 16:00:00 | CL | Stock | 28.75 | 28.75 | 28.6875 | 28.75 | 86800.0 |
> showing 40 of 14,461 rows — these rows as CSV