PREVIEW / stock_1hour / 2004-12-15
file: by_date/stock_1hour/2004/2004-12-15.parquet size: 551 KB rows: 25,621 symbols: 1,899
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 |
|---|---|---|---|---|---|---|---|
| 2004-12-15 08:00:00 | AAPL | Stock | 1.1713 | 1.1745 | 1.1682 | 1.1684 | 464352.0 |
| 2004-12-15 09:00:00 | AAPL | Stock | 1.1679 | 1.1689 | 1.1588 | 1.163 | 55166216.0 |
| 2004-12-15 10:00:00 | AAPL | Stock | 1.1627 | 1.1677 | 1.1546 | 1.1589 | 91478744.0 |
| 2004-12-15 11:00:00 | AAPL | Stock | 1.1588 | 1.1625 | 1.1561 | 1.1605 | 68457816.0 |
| 2004-12-15 12:00:00 | AAPL | Stock | 1.1604 | 1.163 | 1.1586 | 1.1607 | 39578168.0 |
| 2004-12-15 13:00:00 | AAPL | Stock | 1.1609 | 1.1643 | 1.1596 | 1.1609 | 31972752.0 |
| 2004-12-15 14:00:00 | AAPL | Stock | 1.1609 | 1.1625 | 1.1596 | 1.1616 | 25843384.0 |
| 2004-12-15 15:00:00 | AAPL | Stock | 1.1616 | 1.1679 | 1.1613 | 1.1655 | 65517200.0 |
| 2004-12-15 16:00:00 | AAPL | Stock | 1.1655 | 1.1668 | 1.1639 | 1.1654 | 3174584.0 |
| 2004-12-15 17:00:00 | AAPL | Stock | 1.1652 | 1.167 | 1.1646 | 1.1652 | 560336.0 |
| 2004-12-15 18:00:00 | AAPL | Stock | 1.1652 | 1.1652 | 1.1652 | 1.1652 | 39480.0 |
| 2004-12-15 08:00:00 | MSFT | Stock | 27.245 | 27.33 | 27.245 | 27.25 | 308254.0 |
| 2004-12-15 09:00:00 | MSFT | Stock | 27.25 | 27.281 | 27.16 | 27.28 | 5870828.0 |
| 2004-12-15 10:00:00 | MSFT | Stock | 27.28 | 27.4 | 27.18 | 27.21 | 17174311.0 |
| 2004-12-15 11:00:00 | MSFT | Stock | 27.2 | 27.21 | 27.07 | 27.16 | 13786644.0 |
| 2004-12-15 12:00:00 | MSFT | Stock | 27.16 | 27.2 | 27.14 | 27.16 | 7725513.0 |
| 2004-12-15 13:00:00 | MSFT | Stock | 27.15 | 27.24 | 27.14 | 27.2 | 9128353.0 |
| 2004-12-15 14:00:00 | MSFT | Stock | 27.2 | 27.22 | 27.13 | 27.171 | 10354892.0 |
| 2004-12-15 15:00:00 | MSFT | Stock | 27.17 | 27.25 | 27.12 | 27.14 | 15654101.0 |
| 2004-12-15 16:00:00 | MSFT | Stock | 27.14 | 27.1966 | 27.1094 | 27.11 | 17266738.0 |
| 2004-12-15 17:00:00 | MSFT | Stock | 27.15 | 27.19 | 27.107 | 27.14 | 55305.0 |
| 2004-12-15 18:00:00 | MSFT | Stock | 27.15 | 27.15 | 27.14 | 27.15 | 4500.0 |
| 2004-12-15 08:00:00 | NVDA | Stock | 0.1949 | 0.1949 | 0.1929 | 0.1937 | 648000.0 |
| 2004-12-15 09:00:00 | NVDA | Stock | 0.1951 | 0.1951 | 0.1929 | 0.1938 | 71641440.0 |
| 2004-12-15 10:00:00 | NVDA | Stock | 0.1937 | 0.1951 | 0.1936 | 0.1943 | 73128600.0 |
| 2004-12-15 11:00:00 | NVDA | Stock | 0.1944 | 0.1945 | 0.1917 | 0.1925 | 71368800.0 |
| 2004-12-15 12:00:00 | NVDA | Stock | 0.1925 | 0.1942 | 0.1925 | 0.194 | 44360400.0 |
| 2004-12-15 13:00:00 | NVDA | Stock | 0.194 | 0.1948 | 0.1934 | 0.1935 | 37177800.0 |
| 2004-12-15 14:00:00 | NVDA | Stock | 0.1935 | 0.1942 | 0.1933 | 0.1939 | 38906040.0 |
| 2004-12-15 15:00:00 | NVDA | Stock | 0.194 | 0.1947 | 0.1937 | 0.1945 | 86500680.0 |
| 2004-12-15 16:00:00 | NVDA | Stock | 0.1945 | 0.1948 | 0.1938 | 0.1942 | 3231240.0 |
| 2004-12-15 17:00:00 | NVDA | Stock | 0.1945 | 0.1945 | 0.1942 | 0.1942 | 317400.0 |
| 2004-12-15 08:00:00 | AMZN | Stock | 2.025 | 2.0275 | 2.023 | 2.0245 | 242400.0 |
| 2004-12-15 09:00:00 | AMZN | Stock | 2.024 | 2.0255 | 2.0105 | 2.0225 | 10657420.0 |
| 2004-12-15 10:00:00 | AMZN | Stock | 2.0225 | 2.05 | 2.022 | 2.047 | 33882340.0 |
| 2004-12-15 11:00:00 | AMZN | Stock | 2.047 | 2.0475 | 2.026 | 2.034 | 28973700.0 |
| 2004-12-15 12:00:00 | AMZN | Stock | 2.034 | 2.037 | 2.0255 | 2.0305 | 13203580.0 |
| 2004-12-15 13:00:00 | AMZN | Stock | 2.031 | 2.0415 | 2.0278 | 2.0411 | 11804060.0 |
| 2004-12-15 14:00:00 | AMZN | Stock | 2.0415 | 2.044 | 2.0355 | 2.0435 | 8966760.0 |
| 2004-12-15 15:00:00 | AMZN | Stock | 2.044 | 2.05 | 2.0365 | 2.046 | 21282080.0 |
| 2004-12-15 16:00:00 | AMZN | Stock | 2.046 | 2.05 | 2.035 | 2.05 | 1926980.0 |
| 2004-12-15 17:00:00 | AMZN | Stock | 2.0385 | 2.05 | 2.0385 | 2.0415 | 2093440.0 |
| 2004-12-15 09:00:00 | CL | Stock | 25.15 | 25.169 | 25.05 | 25.055 | 427000.0 |
| 2004-12-15 10:00:00 | CL | Stock | 25.055 | 25.07 | 24.98 | 25.0 | 575000.0 |
| 2004-12-15 11:00:00 | CL | Stock | 25.0 | 25.015 | 24.83 | 24.92 | 542200.0 |
| 2004-12-15 12:00:00 | CL | Stock | 24.92 | 25.0 | 24.915 | 24.95 | 409000.0 |
| 2004-12-15 13:00:00 | CL | Stock | 24.945 | 25.085 | 24.915 | 25.06 | 533600.0 |
| 2004-12-15 14:00:00 | CL | Stock | 25.055 | 25.11 | 25.01 | 25.025 | 578200.0 |
| 2004-12-15 15:00:00 | CL | Stock | 25.025 | 25.16 | 24.975 | 25.105 | 1184200.0 |
| 2004-12-15 16:00:00 | CL | Stock | 25.1105 | 25.1105 | 25.11 | 25.11 | 12800.0 |
> showing 50 of 25,621 rows — these rows as CSV