PREVIEW / stock_1hour / 2003-12-11
file: by_date/stock_1hour/2003/2003-12-11.parquet size: 521 KB rows: 23,842 symbols: 1,691
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 |
|---|---|---|---|---|---|---|---|
| 2003-12-11 09:00:00 | AAPL | Stock | 0.3639 | 0.3677 | 0.3609 | 0.3668 | 16304680.0 |
| 2003-12-11 10:00:00 | AAPL | Stock | 0.3664 | 0.3687 | 0.3643 | 0.368 | 18831512.0 |
| 2003-12-11 11:00:00 | AAPL | Stock | 0.368 | 0.3705 | 0.3664 | 0.3695 | 13177472.0 |
| 2003-12-11 12:00:00 | AAPL | Stock | 0.3695 | 0.3732 | 0.3693 | 0.372 | 16749544.0 |
| 2003-12-11 13:00:00 | AAPL | Stock | 0.3721 | 0.375 | 0.3718 | 0.3739 | 21826728.0 |
| 2003-12-11 14:00:00 | AAPL | Stock | 0.3739 | 0.3802 | 0.3732 | 0.3802 | 31348072.0 |
| 2003-12-11 15:00:00 | AAPL | Stock | 0.3802 | 0.3811 | 0.3771 | 0.378 | 55771128.0 |
| 2003-12-11 16:00:00 | AAPL | Stock | 0.3788 | 0.3788 | 0.378 | 0.3786 | 1878800.0 |
| 2003-12-11 17:00:00 | AAPL | Stock | 0.3786 | 0.382 | 0.3777 | 0.3795 | 1103200.0 |
| 2003-12-11 18:00:00 | AAPL | Stock | 0.3798 | 0.3798 | 0.3798 | 0.3798 | 28000.0 |
| 2003-12-11 08:00:00 | MSFT | Stock | 26.63 | 26.68 | 26.55 | 26.58 | 65297.0 |
| 2003-12-11 09:00:00 | MSFT | Stock | 26.59 | 26.74 | 26.54 | 26.72 | 8203909.0 |
| 2003-12-11 10:00:00 | MSFT | Stock | 26.73 | 26.77 | 26.61 | 26.66 | 10961166.0 |
| 2003-12-11 11:00:00 | MSFT | Stock | 26.66 | 26.68 | 26.45 | 26.52 | 12487962.0 |
| 2003-12-11 12:00:00 | MSFT | Stock | 26.53 | 26.56 | 26.46 | 26.52 | 5440370.0 |
| 2003-12-11 13:00:00 | MSFT | Stock | 26.52 | 26.52 | 26.28 | 26.39 | 8921424.0 |
| 2003-12-11 14:00:00 | MSFT | Stock | 26.38 | 26.63 | 26.35 | 26.62 | 10600374.0 |
| 2003-12-11 15:00:00 | MSFT | Stock | 26.62 | 26.73 | 26.53 | 26.61 | 17272752.0 |
| 2003-12-11 16:00:00 | MSFT | Stock | 26.6 | 26.6405 | 26.5 | 26.61 | 2653628.0 |
| 2003-12-11 17:00:00 | MSFT | Stock | 26.61 | 26.65 | 26.577 | 26.65 | 70360.0 |
| 2003-12-11 18:00:00 | MSFT | Stock | 26.65 | 26.66 | 26.64 | 26.65 | 8890.0 |
| 2003-12-11 08:00:00 | NVDA | Stock | 0.1661 | 0.1661 | 0.1661 | 0.1661 | 99600.0 |
| 2003-12-11 09:00:00 | NVDA | Stock | 0.1667 | 0.1707 | 0.1657 | 0.1706 | 83812920.0 |
| 2003-12-11 10:00:00 | NVDA | Stock | 0.1704 | 0.1734 | 0.1693 | 0.1731 | 98750400.0 |
| 2003-12-11 11:00:00 | NVDA | Stock | 0.1732 | 0.175 | 0.1724 | 0.1744 | 111197280.0 |
| 2003-12-11 12:00:00 | NVDA | Stock | 0.1744 | 0.1745 | 0.1727 | 0.1733 | 75545280.0 |
| 2003-12-11 13:00:00 | NVDA | Stock | 0.1733 | 0.1737 | 0.1723 | 0.1732 | 58395960.0 |
| 2003-12-11 14:00:00 | NVDA | Stock | 0.1732 | 0.1763 | 0.173 | 0.1757 | 121299120.0 |
| 2003-12-11 15:00:00 | NVDA | Stock | 0.1757 | 0.1767 | 0.1743 | 0.175 | 124563360.0 |
| 2003-12-11 16:00:00 | NVDA | Stock | 0.175 | 0.1754 | 0.1743 | 0.1751 | 6402240.0 |
| 2003-12-11 17:00:00 | NVDA | Stock | 0.1753 | 0.1754 | 0.1749 | 0.1749 | 588000.0 |
| 2003-12-11 18:00:00 | NVDA | Stock | 0.176 | 0.176 | 0.176 | 0.176 | 72000.0 |
| 2003-12-11 08:00:00 | AMZN | Stock | 2.464 | 2.464 | 2.461 | 2.462 | 40000.0 |
| 2003-12-11 09:00:00 | AMZN | Stock | 2.464 | 2.5135 | 2.4595 | 2.4965 | 23467320.0 |
| 2003-12-11 10:00:00 | AMZN | Stock | 2.4974 | 2.4995 | 2.4605 | 2.4935 | 31920440.0 |
| 2003-12-11 11:00:00 | AMZN | Stock | 2.493 | 2.4955 | 2.48 | 2.4925 | 13208380.0 |
| 2003-12-11 12:00:00 | AMZN | Stock | 2.4925 | 2.4995 | 2.4815 | 2.494 | 13769100.0 |
| 2003-12-11 13:00:00 | AMZN | Stock | 2.494 | 2.499 | 2.485 | 2.494 | 13927940.0 |
| 2003-12-11 14:00:00 | AMZN | Stock | 2.4935 | 2.5105 | 2.492 | 2.507 | 30222360.0 |
| 2003-12-11 15:00:00 | AMZN | Stock | 2.5055 | 2.5575 | 2.5055 | 2.539 | 54530080.0 |
| 2003-12-11 16:00:00 | AMZN | Stock | 2.54 | 2.544 | 2.5385 | 2.543 | 2642220.0 |
| 2003-12-11 17:00:00 | AMZN | Stock | 2.5435 | 2.544 | 2.5389 | 2.5389 | 605320.0 |
| 2003-12-11 18:00:00 | AMZN | Stock | 2.5425 | 2.5435 | 2.5425 | 2.5435 | 42000.0 |
| 2003-12-11 09:00:00 | CL | Stock | 26.25 | 26.375 | 26.225 | 26.375 | 460400.0 |
| 2003-12-11 10:00:00 | CL | Stock | 26.375 | 26.45 | 26.35 | 26.375 | 738600.0 |
| 2003-12-11 11:00:00 | CL | Stock | 26.375 | 26.4 | 26.31 | 26.37 | 505600.0 |
| 2003-12-11 12:00:00 | CL | Stock | 26.365 | 26.365 | 26.265 | 26.265 | 349000.0 |
| 2003-12-11 13:00:00 | CL | Stock | 26.26 | 26.34 | 26.245 | 26.255 | 459200.0 |
| 2003-12-11 14:00:00 | CL | Stock | 26.255 | 26.34 | 26.255 | 26.27 | 503600.0 |
| 2003-12-11 15:00:00 | CL | Stock | 26.275 | 26.345 | 26.265 | 26.3 | 948800.0 |
> showing 50 of 23,842 rows — these rows as CSV