PREVIEW / stock_1hour / 2008-10-14
file: by_date/stock_1hour/2008/2008-10-14.parquet size: 839 KB rows: 42,242 symbols: 3,373
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 |
|---|---|---|---|---|---|---|---|
| 2008-10-14 04:00:00 | AAPL | Stock | 4.1071 | 4.1071 | 4.0804 | 4.0943 | 130200.0 |
| 2008-10-14 05:00:00 | AAPL | Stock | 4.0946 | 4.1046 | 4.0714 | 4.1046 | 122500.0 |
| 2008-10-14 06:00:00 | AAPL | Stock | 4.1046 | 4.125 | 4.1046 | 4.125 | 296492.0 |
| 2008-10-14 07:00:00 | AAPL | Stock | 4.1168 | 4.1357 | 4.0 | 4.0768 | 2274132.0 |
| 2008-10-14 08:00:00 | AAPL | Stock | 4.0821 | 4.1486 | 4.0714 | 4.1207 | 10687208.0 |
| 2008-10-14 09:00:00 | AAPL | Stock | 4.1207 | 4.1607 | 3.9371 | 3.9379 | 281525328.0 |
| 2008-10-14 10:00:00 | AAPL | Stock | 3.9372 | 4.0304 | 3.8393 | 3.9335 | 383680556.0 |
| 2008-10-14 11:00:00 | AAPL | Stock | 3.9321 | 3.9786 | 3.8179 | 3.9325 | 245495656.0 |
| 2008-10-14 12:00:00 | AAPL | Stock | 3.9336 | 3.9854 | 3.8886 | 3.9086 | 153119232.0 |
| 2008-10-14 13:00:00 | AAPL | Stock | 3.9089 | 3.9357 | 3.7682 | 3.7954 | 218019732.0 |
| 2008-10-14 14:00:00 | AAPL | Stock | 3.7954 | 3.8126 | 3.6836 | 3.745 | 278240060.0 |
| 2008-10-14 15:00:00 | AAPL | Stock | 3.7439 | 4.135 | 3.7143 | 3.7143 | 312903780.0 |
| 2008-10-14 16:00:00 | AAPL | Stock | 3.7143 | 4.0545 | 3.7039 | 3.7929 | 45786356.0 |
| 2008-10-14 17:00:00 | AAPL | Stock | 3.7921 | 3.7929 | 3.7171 | 3.745 | 12365024.0 |
| 2008-10-14 18:00:00 | AAPL | Stock | 3.7411 | 3.7589 | 3.74 | 3.7446 | 615384.0 |
| 2008-10-14 19:00:00 | AAPL | Stock | 3.7446 | 3.7657 | 3.7211 | 3.7211 | 664664.0 |
| 2008-10-14 05:00:00 | MSFT | Stock | 25.85 | 25.88 | 25.85 | 25.88 | 300.0 |
| 2008-10-14 06:00:00 | MSFT | Stock | 25.89 | 26.0 | 25.89 | 25.95 | 900.0 |
| 2008-10-14 07:00:00 | MSFT | Stock | 26.0 | 26.42 | 25.8 | 25.9 | 60733.0 |
| 2008-10-14 08:00:00 | MSFT | Stock | 25.9 | 26.0 | 25.7 | 25.75 | 276174.0 |
| 2008-10-14 09:00:00 | MSFT | Stock | 25.77 | 25.84 | 24.14 | 24.32 | 26377446.0 |
| 2008-10-14 10:00:00 | MSFT | Stock | 24.32 | 24.74 | 24.1 | 24.4 | 26327458.0 |
| 2008-10-14 11:00:00 | MSFT | Stock | 24.4 | 24.8 | 23.96 | 24.62 | 17924391.0 |
| 2008-10-14 12:00:00 | MSFT | Stock | 24.62 | 24.98 | 24.42 | 24.68 | 15740004.0 |
| 2008-10-14 13:00:00 | MSFT | Stock | 24.69 | 24.76 | 24.28 | 24.358 | 11918658.0 |
| 2008-10-14 14:00:00 | MSFT | Stock | 24.35 | 24.4 | 23.6 | 23.69 | 19491100.0 |
| 2008-10-14 15:00:00 | MSFT | Stock | 23.69 | 24.38 | 23.62 | 24.06 | 34834402.0 |
| 2008-10-14 16:00:00 | MSFT | Stock | 24.06 | 25.296 | 23.75 | 24.65 | 9190925.0 |
| 2008-10-14 17:00:00 | MSFT | Stock | 24.65 | 24.65 | 23.784 | 24.27 | 966752.0 |
| 2008-10-14 18:00:00 | MSFT | Stock | 24.27 | 24.3 | 24.26 | 24.3 | 2228.0 |
| 2008-10-14 19:00:00 | MSFT | Stock | 24.25 | 24.25 | 24.15 | 24.25 | 3905.0 |
| 2008-10-14 07:00:00 | NVDA | Stock | 0.2125 | 0.2125 | 0.2098 | 0.2098 | 100000.0 |
| 2008-10-14 08:00:00 | NVDA | Stock | 0.2088 | 0.2122 | 0.2065 | 0.2085 | 4339960.0 |
| 2008-10-14 09:00:00 | NVDA | Stock | 0.208 | 0.21 | 0.1938 | 0.194 | 152598400.0 |
| 2008-10-14 10:00:00 | NVDA | Stock | 0.1942 | 0.1995 | 0.192 | 0.1935 | 241114840.0 |
| 2008-10-14 11:00:00 | NVDA | Stock | 0.1935 | 0.1998 | 0.1913 | 0.1972 | 111193040.0 |
| 2008-10-14 12:00:00 | NVDA | Stock | 0.1972 | 0.2015 | 0.1952 | 0.1982 | 64020520.0 |
| 2008-10-14 13:00:00 | NVDA | Stock | 0.1983 | 0.21 | 0.1978 | 0.2015 | 313599760.0 |
| 2008-10-14 14:00:00 | NVDA | Stock | 0.2015 | 0.202 | 0.1933 | 0.1948 | 121733640.0 |
| 2008-10-14 15:00:00 | NVDA | Stock | 0.195 | 0.2005 | 0.1942 | 0.1968 | 158896680.0 |
| 2008-10-14 16:00:00 | NVDA | Stock | 0.1968 | 0.205 | 0.1962 | 0.2038 | 25340640.0 |
| 2008-10-14 17:00:00 | NVDA | Stock | 0.2045 | 0.205 | 0.1968 | 0.205 | 6895680.0 |
| 2008-10-14 18:00:00 | NVDA | Stock | 0.202 | 0.205 | 0.2018 | 0.205 | 506000.0 |
| 2008-10-14 19:00:00 | NVDA | Stock | 0.205 | 0.205 | 0.202 | 0.2025 | 376000.0 |
| 2008-10-14 04:00:00 | AMZN | Stock | 3.165 | 3.165 | 3.165 | 3.165 | 8000.0 |
| 2008-10-14 07:00:00 | AMZN | Stock | 3.2025 | 3.2025 | 3.2025 | 3.2025 | 2400.0 |
| 2008-10-14 08:00:00 | AMZN | Stock | 3.165 | 3.2175 | 3.1375 | 3.2 | 375280.0 |
| 2008-10-14 09:00:00 | AMZN | Stock | 3.195 | 3.2 | 2.8035 | 2.8042 | 47785760.0 |
| 2008-10-14 10:00:00 | AMZN | Stock | 2.805 | 2.989 | 2.8035 | 2.952 | 56608120.0 |
| 2008-10-14 11:00:00 | AMZN | Stock | 2.9515 | 2.969 | 2.8875 | 2.9395 | 30782080.0 |
> showing 50 of 42,242 rows — these rows as CSV