PREVIEW / stock_1hour / 2000-05-16
file: by_date/stock_1hour/2000/2000-05-16.parquet size: 282 KB rows: 14,400 symbols: 1,170
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-05-16 09:00:00 | AAPL | Stock | 0.933 | 0.9481 | 0.933 | 0.9459 | 88032000.0 |
| 2000-05-16 10:00:00 | AAPL | Stock | 0.9442 | 0.9621 | 0.9442 | 0.9554 | 85064000.0 |
| 2000-05-16 11:00:00 | AAPL | Stock | 0.9554 | 0.9738 | 0.9542 | 0.9676 | 48048000.0 |
| 2000-05-16 12:00:00 | AAPL | Stock | 0.9688 | 0.971 | 0.9581 | 0.9587 | 26264000.0 |
| 2000-05-16 13:00:00 | AAPL | Stock | 0.9587 | 0.9593 | 0.9442 | 0.947 | 28459200.0 |
| 2000-05-16 14:00:00 | AAPL | Stock | 0.9475 | 0.9576 | 0.9174 | 0.942 | 78243200.0 |
| 2000-05-16 15:00:00 | AAPL | Stock | 0.942 | 0.9548 | 0.9347 | 0.9431 | 61532800.0 |
| 2000-05-16 16:00:00 | AAPL | Stock | 0.9475 | 0.9475 | 0.9436 | 0.9436 | 716800.0 |
| 2000-05-16 09:00:00 | MSFT | Stock | 34.7812 | 35.1875 | 34.7812 | 35.0 | 6836600.0 |
| 2000-05-16 10:00:00 | MSFT | Stock | 35.0 | 35.3125 | 34.9688 | 35.2031 | 5912400.0 |
| 2000-05-16 11:00:00 | MSFT | Stock | 35.2188 | 35.3125 | 35.0 | 35.2188 | 4381000.0 |
| 2000-05-16 12:00:00 | MSFT | Stock | 35.2188 | 35.2812 | 35.0625 | 35.0625 | 3184600.0 |
| 2000-05-16 13:00:00 | MSFT | Stock | 35.1094 | 35.2812 | 35.0625 | 35.125 | 5799800.0 |
| 2000-05-16 14:00:00 | MSFT | Stock | 35.0938 | 35.2188 | 34.5312 | 34.8594 | 11283200.0 |
| 2000-05-16 15:00:00 | MSFT | Stock | 34.875 | 35.0625 | 34.5938 | 34.75 | 8099800.0 |
| 2000-05-16 16:00:00 | MSFT | Stock | 34.75 | 34.8125 | 34.75 | 34.75 | 112600.0 |
| 2000-05-16 09:00:00 | NVDA | Stock | 0.1854 | 0.1885 | 0.184 | 0.1857 | 51648000.0 |
| 2000-05-16 10:00:00 | NVDA | Stock | 0.1842 | 0.1911 | 0.1842 | 0.1901 | 49824000.0 |
| 2000-05-16 11:00:00 | NVDA | Stock | 0.1905 | 0.2014 | 0.1905 | 0.1964 | 82224000.0 |
| 2000-05-16 12:00:00 | NVDA | Stock | 0.1958 | 0.1978 | 0.1917 | 0.1956 | 31632000.0 |
| 2000-05-16 13:00:00 | NVDA | Stock | 0.1956 | 0.1973 | 0.193 | 0.193 | 36768000.0 |
| 2000-05-16 14:00:00 | NVDA | Stock | 0.193 | 0.1953 | 0.1833 | 0.1914 | 58416000.0 |
| 2000-05-16 15:00:00 | NVDA | Stock | 0.1914 | 0.1964 | 0.1896 | 0.1961 | 47904000.0 |
| 2000-05-16 16:00:00 | NVDA | Stock | 0.1958 | 0.1958 | 0.1958 | 0.1958 | 384000.0 |
| 2000-05-16 09:00:00 | AMZN | Stock | 2.8562 | 2.8812 | 2.8375 | 2.8562 | 15576000.0 |
| 2000-05-16 10:00:00 | AMZN | Stock | 2.8562 | 2.8688 | 2.8125 | 2.8125 | 22038000.0 |
| 2000-05-16 11:00:00 | AMZN | Stock | 2.825 | 2.8656 | 2.8125 | 2.8469 | 12764000.0 |
| 2000-05-16 12:00:00 | AMZN | Stock | 2.85 | 2.8578 | 2.8406 | 2.8469 | 6972000.0 |
| 2000-05-16 13:00:00 | AMZN | Stock | 2.8469 | 2.8812 | 2.8469 | 2.8688 | 8356000.0 |
| 2000-05-16 14:00:00 | AMZN | Stock | 2.8688 | 2.9062 | 2.825 | 2.8688 | 21444000.0 |
| 2000-05-16 15:00:00 | AMZN | Stock | 2.8688 | 2.9938 | 2.8562 | 2.9531 | 34736000.0 |
| 2000-05-16 16:00:00 | AMZN | Stock | 2.9531 | 2.9531 | 2.95 | 2.9531 | 192000.0 |
| 2000-05-16 09:00:00 | CL | Stock | 29.5312 | 29.5312 | 29.0 | 29.0312 | 225400.0 |
| 2000-05-16 10:00:00 | CL | Stock | 29.0312 | 29.25 | 29.0 | 29.0312 | 302200.0 |
| 2000-05-16 11:00:00 | CL | Stock | 29.0625 | 29.125 | 29.0 | 29.0312 | 283600.0 |
| 2000-05-16 12:00:00 | CL | Stock | 29.0312 | 29.0938 | 28.9375 | 28.9688 | 126200.0 |
| 2000-05-16 13:00:00 | CL | Stock | 28.9688 | 29.0938 | 28.8438 | 28.8438 | 202800.0 |
| 2000-05-16 14:00:00 | CL | Stock | 28.8125 | 29.125 | 28.8125 | 29.125 | 619200.0 |
| 2000-05-16 15:00:00 | CL | Stock | 29.125 | 29.4375 | 28.875 | 29.0312 | 557200.0 |
| 2000-05-16 16:00:00 | CL | Stock | 29.0312 | 29.0312 | 29.0312 | 29.0312 | 37800.0 |
| 2000-05-16 17:00:00 | CL | Stock | 29.0312 | 29.0312 | 29.0312 | 29.0312 | 200.0 |
> showing 41 of 14,400 rows — these rows as CSV