PREVIEW / stock_1hour / 2000-04-05
file: by_date/stock_1hour/2000/2000-04-05.parquet size: 288 KB rows: 14,565 symbols: 1,146
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-04-05 09:00:00 | AAPL | Stock | 1.1292 | 1.1607 | 1.1116 | 1.1529 | 47712000.0 |
| 2000-04-05 10:00:00 | AAPL | Stock | 1.144 | 1.1607 | 1.1239 | 1.1373 | 80774400.0 |
| 2000-04-05 11:00:00 | AAPL | Stock | 1.1367 | 1.1451 | 1.1189 | 1.1309 | 45248000.0 |
| 2000-04-05 12:00:00 | AAPL | Stock | 1.1295 | 1.1473 | 1.1071 | 1.1423 | 64108800.0 |
| 2000-04-05 13:00:00 | AAPL | Stock | 1.1423 | 1.1607 | 1.1339 | 1.1529 | 64276800.0 |
| 2000-04-05 14:00:00 | AAPL | Stock | 1.1529 | 1.1858 | 1.1507 | 1.1763 | 57624000.0 |
| 2000-04-05 15:00:00 | AAPL | Stock | 1.1769 | 1.1864 | 1.1579 | 1.1635 | 70414400.0 |
| 2000-04-05 16:00:00 | AAPL | Stock | 1.1629 | 1.1646 | 1.1629 | 1.1641 | 492800.0 |
| 2000-04-05 09:00:00 | MSFT | Stock | 44.125 | 44.25 | 42.9375 | 43.25 | 11682800.0 |
| 2000-04-05 10:00:00 | MSFT | Stock | 43.25 | 43.6562 | 43.0 | 43.25 | 13416200.0 |
| 2000-04-05 11:00:00 | MSFT | Stock | 43.25 | 43.875 | 43.0 | 43.1875 | 11112400.0 |
| 2000-04-05 12:00:00 | MSFT | Stock | 43.125 | 43.75 | 43.0312 | 43.5 | 9205600.0 |
| 2000-04-05 13:00:00 | MSFT | Stock | 43.4375 | 43.8438 | 43.25 | 43.375 | 9014800.0 |
| 2000-04-05 14:00:00 | MSFT | Stock | 43.375 | 43.625 | 43.1875 | 43.5312 | 8505600.0 |
| 2000-04-05 15:00:00 | MSFT | Stock | 43.5 | 43.625 | 43.0 | 43.1562 | 12399600.0 |
| 2000-04-05 16:00:00 | MSFT | Stock | 43.1875 | 43.1875 | 43.125 | 43.1875 | 103800.0 |
| 2000-04-05 09:00:00 | NVDA | Stock | 0.1578 | 0.1667 | 0.1497 | 0.1651 | 47568000.0 |
| 2000-04-05 10:00:00 | NVDA | Stock | 0.1635 | 0.1674 | 0.1578 | 0.1656 | 84432000.0 |
| 2000-04-05 11:00:00 | NVDA | Stock | 0.1656 | 0.1674 | 0.1599 | 0.1651 | 51456000.0 |
| 2000-04-05 12:00:00 | NVDA | Stock | 0.1646 | 0.1823 | 0.1625 | 0.1812 | 113040000.0 |
| 2000-04-05 13:00:00 | NVDA | Stock | 0.1809 | 0.1924 | 0.1803 | 0.1896 | 93936000.0 |
| 2000-04-05 14:00:00 | NVDA | Stock | 0.1913 | 0.2031 | 0.1901 | 0.1937 | 131616000.0 |
| 2000-04-05 15:00:00 | NVDA | Stock | 0.1937 | 0.1971 | 0.1901 | 0.1927 | 71184000.0 |
| 2000-04-05 16:00:00 | NVDA | Stock | 0.191 | 0.191 | 0.191 | 0.191 | 144000.0 |
| 2000-04-05 09:00:00 | AMZN | Stock | 3.0875 | 3.1281 | 3.025 | 3.0469 | 14574000.0 |
| 2000-04-05 10:00:00 | AMZN | Stock | 3.0406 | 3.1688 | 3.0344 | 3.15 | 20692000.0 |
| 2000-04-05 11:00:00 | AMZN | Stock | 3.1625 | 3.1875 | 3.0938 | 3.1156 | 9474000.0 |
| 2000-04-05 12:00:00 | AMZN | Stock | 3.1125 | 3.1625 | 3.075 | 3.1125 | 7560000.0 |
| 2000-04-05 13:00:00 | AMZN | Stock | 3.1156 | 3.2 | 3.1062 | 3.1969 | 11862000.0 |
| 2000-04-05 14:00:00 | AMZN | Stock | 3.1938 | 3.2469 | 3.1625 | 3.175 | 10972000.0 |
| 2000-04-05 15:00:00 | AMZN | Stock | 3.1781 | 3.2 | 3.075 | 3.1094 | 14614000.0 |
| 2000-04-05 16:00:00 | AMZN | Stock | 3.1094 | 3.1125 | 3.1 | 3.1094 | 240000.0 |
| 2000-04-05 09:00:00 | CL | Stock | 30.1875 | 30.5 | 30.125 | 30.4375 | 349600.0 |
| 2000-04-05 10:00:00 | CL | Stock | 30.5 | 30.875 | 30.0312 | 30.1875 | 446200.0 |
| 2000-04-05 11:00:00 | CL | Stock | 30.1562 | 30.1562 | 29.875 | 30.125 | 597400.0 |
| 2000-04-05 12:00:00 | CL | Stock | 30.125 | 30.2812 | 29.9688 | 30.25 | 396600.0 |
| 2000-04-05 13:00:00 | CL | Stock | 30.2188 | 30.2188 | 29.5 | 29.5 | 316800.0 |
| 2000-04-05 14:00:00 | CL | Stock | 29.5312 | 29.5625 | 29.125 | 29.2188 | 444800.0 |
| 2000-04-05 15:00:00 | CL | Stock | 29.1875 | 29.625 | 29.125 | 29.2188 | 747800.0 |
| 2000-04-05 16:00:00 | CL | Stock | 29.25 | 29.25 | 29.2188 | 29.2188 | 61800.0 |
> showing 40 of 14,565 rows — these rows as CSV