PREVIEW / stock_1hour / 2000-03-07
file: by_date/stock_1hour/2000/2000-03-07.parquet size: 289 KB rows: 14,793 symbols: 1,152
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-03-07 09:00:00 | AAPL | Stock | 1.1289 | 1.1378 | 1.1038 | 1.1071 | 32323200.0 |
| 2000-03-07 10:00:00 | AAPL | Stock | 1.1071 | 1.1071 | 1.0826 | 1.0904 | 85019200.0 |
| 2000-03-07 11:00:00 | AAPL | Stock | 1.0904 | 1.1161 | 1.0904 | 1.1083 | 33880000.0 |
| 2000-03-07 12:00:00 | AAPL | Stock | 1.1071 | 1.1127 | 1.0993 | 1.111 | 11480000.0 |
| 2000-03-07 13:00:00 | AAPL | Stock | 1.1088 | 1.1105 | 1.0898 | 1.0904 | 19689600.0 |
| 2000-03-07 14:00:00 | AAPL | Stock | 1.0904 | 1.106 | 1.0882 | 1.0993 | 24057600.0 |
| 2000-03-07 15:00:00 | AAPL | Stock | 1.0993 | 1.1016 | 1.0815 | 1.0971 | 37856000.0 |
| 2000-03-07 16:00:00 | AAPL | Stock | 1.0977 | 1.0977 | 1.0971 | 1.0971 | 918400.0 |
| 2000-03-07 09:00:00 | MSFT | Stock | 48.0625 | 48.75 | 47.7812 | 48.3125 | 23562000.0 |
| 2000-03-07 10:00:00 | MSFT | Stock | 48.3125 | 48.5 | 46.75 | 47.6562 | 19084400.0 |
| 2000-03-07 11:00:00 | MSFT | Stock | 47.5312 | 48.2188 | 47.4375 | 48.2188 | 11426600.0 |
| 2000-03-07 12:00:00 | MSFT | Stock | 48.1875 | 48.25 | 47.4375 | 47.6562 | 6820800.0 |
| 2000-03-07 13:00:00 | MSFT | Stock | 47.625 | 47.6562 | 46.8438 | 46.875 | 9284200.0 |
| 2000-03-07 14:00:00 | MSFT | Stock | 46.9375 | 47.875 | 46.8438 | 47.2188 | 16244600.0 |
| 2000-03-07 15:00:00 | MSFT | Stock | 47.2188 | 47.25 | 45.9688 | 46.4375 | 34041800.0 |
| 2000-03-07 16:00:00 | MSFT | Stock | 46.4375 | 46.4688 | 46.375 | 46.4375 | 299800.0 |
| 2000-03-07 09:00:00 | NVDA | Stock | 0.1562 | 0.1729 | 0.1542 | 0.1633 | 254640000.0 |
| 2000-03-07 10:00:00 | NVDA | Stock | 0.1633 | 0.1687 | 0.1573 | 0.1625 | 394848000.0 |
| 2000-03-07 11:00:00 | NVDA | Stock | 0.1625 | 0.1652 | 0.1573 | 0.1583 | 189120000.0 |
| 2000-03-07 12:00:00 | NVDA | Stock | 0.1579 | 0.1599 | 0.1495 | 0.1589 | 138960000.0 |
| 2000-03-07 13:00:00 | NVDA | Stock | 0.1589 | 0.1651 | 0.1578 | 0.1641 | 103296000.0 |
| 2000-03-07 14:00:00 | NVDA | Stock | 0.1641 | 0.1693 | 0.1622 | 0.1672 | 263616000.0 |
| 2000-03-07 15:00:00 | NVDA | Stock | 0.1672 | 0.1818 | 0.1667 | 0.1741 | 460176000.0 |
| 2000-03-07 16:00:00 | NVDA | Stock | 0.1736 | 0.1737 | 0.1736 | 0.1736 | 5040000.0 |
| 2000-03-07 09:00:00 | AMZN | Stock | 3.2438 | 3.2906 | 3.175 | 3.1813 | 10462000.0 |
| 2000-03-07 10:00:00 | AMZN | Stock | 3.1781 | 3.2063 | 3.1062 | 3.1766 | 13080000.0 |
| 2000-03-07 11:00:00 | AMZN | Stock | 3.175 | 3.225 | 3.1531 | 3.2125 | 8622000.0 |
| 2000-03-07 12:00:00 | AMZN | Stock | 3.2125 | 3.2219 | 3.175 | 3.2 | 6856000.0 |
| 2000-03-07 13:00:00 | AMZN | Stock | 3.2031 | 3.2344 | 3.175 | 3.1781 | 8808000.0 |
| 2000-03-07 14:00:00 | AMZN | Stock | 3.1813 | 3.25 | 3.1625 | 3.2375 | 10212000.0 |
| 2000-03-07 15:00:00 | AMZN | Stock | 3.2438 | 3.2594 | 3.15 | 3.175 | 16944000.0 |
| 2000-03-07 16:00:00 | AMZN | Stock | 3.175 | 3.1781 | 3.175 | 3.175 | 262000.0 |
| 2000-03-07 09:00:00 | CL | Stock | 23.0 | 24.0 | 22.875 | 24.0 | 2170000.0 |
| 2000-03-07 10:00:00 | CL | Stock | 23.75 | 24.5625 | 23.5 | 24.1562 | 3822600.0 |
| 2000-03-07 11:00:00 | CL | Stock | 24.1562 | 24.875 | 23.5 | 23.625 | 4203000.0 |
| 2000-03-07 12:00:00 | CL | Stock | 23.5625 | 23.6875 | 23.0 | 23.125 | 1728000.0 |
| 2000-03-07 13:00:00 | CL | Stock | 23.1875 | 23.75 | 23.1875 | 23.5625 | 1406800.0 |
| 2000-03-07 14:00:00 | CL | Stock | 23.5312 | 23.6875 | 23.375 | 23.5625 | 1274800.0 |
| 2000-03-07 15:00:00 | CL | Stock | 23.5625 | 23.5938 | 23.1875 | 23.3438 | 1539000.0 |
| 2000-03-07 16:00:00 | CL | Stock | 23.375 | 23.375 | 23.3438 | 23.375 | 67600.0 |
> showing 40 of 14,793 rows — these rows as CSV