PREVIEW / stock_1hour / 2000-03-30
file: by_date/stock_1hour/2000/2000-03-30.parquet size: 285 KB rows: 14,504 symbols: 1,141
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-30 09:00:00 | AAPL | Stock | 1.1925 | 1.2104 | 1.1786 | 1.1987 | 33644800.0 |
| 2000-03-30 10:00:00 | AAPL | Stock | 1.1987 | 1.2294 | 1.192 | 1.1936 | 27563200.0 |
| 2000-03-30 11:00:00 | AAPL | Stock | 1.1936 | 1.202 | 1.1786 | 1.1836 | 34193600.0 |
| 2000-03-30 12:00:00 | AAPL | Stock | 1.1836 | 1.1836 | 1.1568 | 1.1618 | 65105600.0 |
| 2000-03-30 13:00:00 | AAPL | Stock | 1.1618 | 1.1741 | 1.1551 | 1.1574 | 41372800.0 |
| 2000-03-30 14:00:00 | AAPL | Stock | 1.1574 | 1.1607 | 1.1205 | 1.1256 | 61644800.0 |
| 2000-03-30 15:00:00 | AAPL | Stock | 1.125 | 1.1384 | 1.12 | 1.1228 | 120736000.0 |
| 2000-03-30 16:00:00 | AAPL | Stock | 1.1228 | 1.1239 | 1.1228 | 1.1228 | 1064000.0 |
| 2000-03-30 09:00:00 | MSFT | Stock | 53.0938 | 54.3125 | 52.8594 | 53.8438 | 8688400.0 |
| 2000-03-30 10:00:00 | MSFT | Stock | 53.7812 | 54.0 | 53.0312 | 53.0625 | 8508200.0 |
| 2000-03-30 11:00:00 | MSFT | Stock | 53.0625 | 53.4375 | 52.75 | 53.0625 | 6690200.0 |
| 2000-03-30 12:00:00 | MSFT | Stock | 53.0312 | 53.4375 | 52.7812 | 53.3125 | 4387800.0 |
| 2000-03-30 13:00:00 | MSFT | Stock | 53.3438 | 53.9062 | 53.0625 | 53.25 | 5649200.0 |
| 2000-03-30 14:00:00 | MSFT | Stock | 53.25 | 53.3125 | 52.125 | 52.4688 | 9813000.0 |
| 2000-03-30 15:00:00 | MSFT | Stock | 52.5 | 52.625 | 51.25 | 51.6875 | 14925000.0 |
| 2000-03-30 16:00:00 | MSFT | Stock | 51.6875 | 51.75 | 51.6562 | 51.7188 | 134600.0 |
| 2000-03-30 09:00:00 | NVDA | Stock | 0.1521 | 0.1672 | 0.15 | 0.1659 | 44256000.0 |
| 2000-03-30 10:00:00 | NVDA | Stock | 0.1645 | 0.1703 | 0.1615 | 0.1615 | 85008000.0 |
| 2000-03-30 11:00:00 | NVDA | Stock | 0.1609 | 0.1641 | 0.1583 | 0.1583 | 27408000.0 |
| 2000-03-30 12:00:00 | NVDA | Stock | 0.1585 | 0.1604 | 0.1576 | 0.1602 | 28032000.0 |
| 2000-03-30 13:00:00 | NVDA | Stock | 0.16 | 0.1612 | 0.1585 | 0.1608 | 22944000.0 |
| 2000-03-30 14:00:00 | NVDA | Stock | 0.1608 | 0.162 | 0.1509 | 0.1521 | 45120000.0 |
| 2000-03-30 15:00:00 | NVDA | Stock | 0.1526 | 0.1573 | 0.1469 | 0.1559 | 66960000.0 |
| 2000-03-30 09:00:00 | AMZN | Stock | 3.225 | 3.3031 | 3.225 | 3.2969 | 11318000.0 |
| 2000-03-30 10:00:00 | AMZN | Stock | 3.3047 | 3.3688 | 3.275 | 3.2844 | 17980000.0 |
| 2000-03-30 11:00:00 | AMZN | Stock | 3.2812 | 3.2938 | 3.2344 | 3.25 | 16642000.0 |
| 2000-03-30 12:00:00 | AMZN | Stock | 3.25 | 3.2688 | 3.225 | 3.25 | 5696000.0 |
| 2000-03-30 13:00:00 | AMZN | Stock | 3.25 | 3.325 | 3.2406 | 3.3156 | 8644000.0 |
| 2000-03-30 14:00:00 | AMZN | Stock | 3.3062 | 3.3062 | 3.2188 | 3.2719 | 11738000.0 |
| 2000-03-30 15:00:00 | AMZN | Stock | 3.2719 | 3.3562 | 3.2 | 3.3234 | 18494000.0 |
| 2000-03-30 16:00:00 | AMZN | Stock | 3.325 | 3.3312 | 3.3219 | 3.325 | 252000.0 |
| 2000-03-30 09:00:00 | CL | Stock | 27.625 | 27.75 | 27.4375 | 27.75 | 635400.0 |
| 2000-03-30 10:00:00 | CL | Stock | 27.75 | 27.8125 | 27.2812 | 27.5 | 827000.0 |
| 2000-03-30 11:00:00 | CL | Stock | 27.5 | 27.9375 | 27.4062 | 27.875 | 801000.0 |
| 2000-03-30 12:00:00 | CL | Stock | 27.9062 | 28.125 | 27.8125 | 28.0625 | 1455800.0 |
| 2000-03-30 13:00:00 | CL | Stock | 28.0312 | 28.125 | 27.875 | 28.0625 | 592400.0 |
| 2000-03-30 14:00:00 | CL | Stock | 28.0625 | 28.2188 | 27.9375 | 27.9688 | 523200.0 |
| 2000-03-30 15:00:00 | CL | Stock | 28.0 | 28.1562 | 27.9062 | 28.125 | 831000.0 |
| 2000-03-30 16:00:00 | CL | Stock | 28.125 | 28.125 | 28.0938 | 28.0938 | 93200.0 |
> showing 39 of 14,504 rows — these rows as CSV