PREVIEW / stock_1hour / 2000-05-15
file: by_date/stock_1hour/2000/2000-05-15.parquet size: 277 KB rows: 14,266 symbols: 1,162
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-15 09:00:00 | AAPL | Stock | 0.9648 | 0.9648 | 0.9353 | 0.9353 | 50836800.0 |
| 2000-05-15 10:00:00 | AAPL | Stock | 0.9375 | 0.9375 | 0.894 | 0.909 | 124600000.0 |
| 2000-05-15 11:00:00 | AAPL | Stock | 0.909 | 0.9163 | 0.8962 | 0.9152 | 138454400.0 |
| 2000-05-15 12:00:00 | AAPL | Stock | 0.9157 | 0.9174 | 0.904 | 0.9096 | 82779200.0 |
| 2000-05-15 13:00:00 | AAPL | Stock | 0.9102 | 0.9275 | 0.9102 | 0.9118 | 44564800.0 |
| 2000-05-15 14:00:00 | AAPL | Stock | 0.9118 | 0.9263 | 0.9085 | 0.9241 | 46054400.0 |
| 2000-05-15 15:00:00 | AAPL | Stock | 0.923 | 0.9263 | 0.8996 | 0.9012 | 160921600.0 |
| 2000-05-15 16:00:00 | AAPL | Stock | 0.9018 | 0.9018 | 0.8996 | 0.9018 | 4188800.0 |
| 2000-05-15 09:00:00 | MSFT | Stock | 34.5 | 34.6875 | 34.3438 | 34.5938 | 3538000.0 |
| 2000-05-15 10:00:00 | MSFT | Stock | 34.5938 | 34.625 | 34.1875 | 34.2188 | 5115600.0 |
| 2000-05-15 11:00:00 | MSFT | Stock | 34.2344 | 34.2812 | 34.125 | 34.2188 | 4568200.0 |
| 2000-05-15 12:00:00 | MSFT | Stock | 34.2188 | 34.3125 | 34.0938 | 34.1875 | 4247400.0 |
| 2000-05-15 13:00:00 | MSFT | Stock | 34.125 | 34.3125 | 34.0 | 34.2188 | 2885200.0 |
| 2000-05-15 14:00:00 | MSFT | Stock | 34.2188 | 34.5312 | 34.1562 | 34.5 | 3318400.0 |
| 2000-05-15 15:00:00 | MSFT | Stock | 34.4688 | 34.6875 | 34.4375 | 34.6562 | 7670000.0 |
| 2000-05-15 16:00:00 | MSFT | Stock | 34.6562 | 34.7188 | 34.5938 | 34.6875 | 192600.0 |
| 2000-05-15 09:00:00 | NVDA | Stock | 0.1654 | 0.1695 | 0.1635 | 0.1651 | 34224000.0 |
| 2000-05-15 10:00:00 | NVDA | Stock | 0.1651 | 0.1651 | 0.1591 | 0.1617 | 49440000.0 |
| 2000-05-15 11:00:00 | NVDA | Stock | 0.162 | 0.1645 | 0.1573 | 0.1645 | 19584000.0 |
| 2000-05-15 12:00:00 | NVDA | Stock | 0.1646 | 0.1728 | 0.163 | 0.1708 | 48240000.0 |
| 2000-05-15 13:00:00 | NVDA | Stock | 0.1708 | 0.1728 | 0.1687 | 0.1704 | 34944000.0 |
| 2000-05-15 14:00:00 | NVDA | Stock | 0.1703 | 0.1745 | 0.1671 | 0.1719 | 27408000.0 |
| 2000-05-15 15:00:00 | NVDA | Stock | 0.1729 | 0.1805 | 0.1714 | 0.1783 | 58368000.0 |
| 2000-05-15 16:00:00 | NVDA | Stock | 0.1789 | 0.1789 | 0.1776 | 0.1776 | 6000000.0 |
| 2000-05-15 09:00:00 | AMZN | Stock | 2.6813 | 2.6906 | 2.625 | 2.6531 | 8938000.0 |
| 2000-05-15 10:00:00 | AMZN | Stock | 2.6531 | 2.6625 | 2.6 | 2.6125 | 8310000.0 |
| 2000-05-15 11:00:00 | AMZN | Stock | 2.6094 | 2.6438 | 2.5438 | 2.6406 | 10796000.0 |
| 2000-05-15 12:00:00 | AMZN | Stock | 2.6438 | 2.6562 | 2.6 | 2.6281 | 8396000.0 |
| 2000-05-15 13:00:00 | AMZN | Stock | 2.6281 | 2.6594 | 2.6219 | 2.6531 | 6766000.0 |
| 2000-05-15 14:00:00 | AMZN | Stock | 2.6562 | 2.75 | 2.6344 | 2.7438 | 12958000.0 |
| 2000-05-15 15:00:00 | AMZN | Stock | 2.7406 | 2.825 | 2.725 | 2.8063 | 23980000.0 |
| 2000-05-15 16:00:00 | AMZN | Stock | 2.8031 | 2.8031 | 2.8 | 2.8031 | 72000.0 |
| 2000-05-15 09:00:00 | CL | Stock | 29.375 | 29.5625 | 29.3125 | 29.5625 | 141400.0 |
| 2000-05-15 10:00:00 | CL | Stock | 29.5312 | 29.875 | 29.5312 | 29.75 | 306200.0 |
| 2000-05-15 11:00:00 | CL | Stock | 29.7188 | 29.875 | 29.6562 | 29.875 | 412400.0 |
| 2000-05-15 12:00:00 | CL | Stock | 29.875 | 29.875 | 29.625 | 29.625 | 207800.0 |
| 2000-05-15 13:00:00 | CL | Stock | 29.625 | 29.7812 | 29.5938 | 29.7812 | 186200.0 |
| 2000-05-15 14:00:00 | CL | Stock | 29.75 | 29.7812 | 29.6875 | 29.6875 | 248200.0 |
| 2000-05-15 15:00:00 | CL | Stock | 29.6875 | 29.7812 | 29.4688 | 29.625 | 486000.0 |
| 2000-05-15 16:00:00 | CL | Stock | 29.625 | 29.625 | 29.625 | 29.625 | 62000.0 |
> showing 40 of 14,266 rows — these rows as CSV