PREVIEW / stock_1hour / 2004-03-26
file: by_date/stock_1hour/2004/2004-03-26.parquet size: 479 KB rows: 22,738 symbols: 1,749
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-03-26 08:00:00 | AAPL | Stock | 0.4821 | 0.4998 | 0.4821 | 0.4893 | 792624.0 |
| 2004-03-26 09:00:00 | AAPL | Stock | 0.483 | 0.4864 | 0.4805 | 0.4855 | 61502392.0 |
| 2004-03-26 10:00:00 | AAPL | Stock | 0.4854 | 0.487 | 0.482 | 0.4838 | 72650088.0 |
| 2004-03-26 11:00:00 | AAPL | Stock | 0.4836 | 0.4886 | 0.4836 | 0.487 | 57511104.0 |
| 2004-03-26 12:00:00 | AAPL | Stock | 0.4871 | 0.4875 | 0.4845 | 0.4855 | 29087296.0 |
| 2004-03-26 13:00:00 | AAPL | Stock | 0.4854 | 0.488 | 0.4854 | 0.4861 | 28780752.0 |
| 2004-03-26 14:00:00 | AAPL | Stock | 0.4861 | 0.4884 | 0.4857 | 0.4861 | 47272288.0 |
| 2004-03-26 15:00:00 | AAPL | Stock | 0.4859 | 0.488 | 0.4843 | 0.4846 | 69923784.0 |
| 2004-03-26 16:00:00 | AAPL | Stock | 0.4846 | 0.4925 | 0.4827 | 0.4896 | 7812840.0 |
| 2004-03-26 17:00:00 | AAPL | Stock | 0.4893 | 0.4893 | 0.4884 | 0.4884 | 106400.0 |
| 2004-03-26 08:00:00 | MSFT | Stock | 25.25 | 25.27 | 25.12 | 25.25 | 23970.0 |
| 2004-03-26 09:00:00 | MSFT | Stock | 25.2 | 25.25 | 25.0 | 25.17 | 7294361.0 |
| 2004-03-26 10:00:00 | MSFT | Stock | 25.169 | 25.37 | 25.15 | 25.29 | 9862683.0 |
| 2004-03-26 11:00:00 | MSFT | Stock | 25.3 | 25.51 | 25.25 | 25.35 | 9444773.0 |
| 2004-03-26 12:00:00 | MSFT | Stock | 25.35 | 25.38 | 25.22 | 25.32 | 4732178.0 |
| 2004-03-26 13:00:00 | MSFT | Stock | 25.31 | 25.35 | 25.14 | 25.21 | 6136319.0 |
| 2004-03-26 14:00:00 | MSFT | Stock | 25.21 | 25.33 | 25.2 | 25.3 | 5403423.0 |
| 2004-03-26 15:00:00 | MSFT | Stock | 25.29 | 25.34 | 25.01 | 25.02 | 10029191.0 |
| 2004-03-26 16:00:00 | MSFT | Stock | 25.03 | 25.32 | 24.95 | 25.02 | 4236497.0 |
| 2004-03-26 17:00:00 | MSFT | Stock | 25.02 | 25.02 | 24.96 | 24.96 | 23555.0 |
| 2004-03-26 18:00:00 | MSFT | Stock | 24.96 | 25.02 | 24.96 | 25.02 | 3275.0 |
| 2004-03-26 08:00:00 | NVDA | Stock | 0.2042 | 0.2042 | 0.2028 | 0.2028 | 155760.0 |
| 2004-03-26 09:00:00 | NVDA | Stock | 0.2028 | 0.2037 | 0.2002 | 0.2034 | 75162000.0 |
| 2004-03-26 10:00:00 | NVDA | Stock | 0.2034 | 0.2061 | 0.2025 | 0.2033 | 110228520.0 |
| 2004-03-26 11:00:00 | NVDA | Stock | 0.2032 | 0.2047 | 0.2027 | 0.2045 | 51502560.0 |
| 2004-03-26 12:00:00 | NVDA | Stock | 0.2046 | 0.2054 | 0.2043 | 0.2052 | 43310880.0 |
| 2004-03-26 13:00:00 | NVDA | Stock | 0.2051 | 0.2052 | 0.2037 | 0.2039 | 44285040.0 |
| 2004-03-26 14:00:00 | NVDA | Stock | 0.204 | 0.2049 | 0.2038 | 0.2042 | 27319800.0 |
| 2004-03-26 15:00:00 | NVDA | Stock | 0.2043 | 0.2054 | 0.2024 | 0.2029 | 155736600.0 |
| 2004-03-26 16:00:00 | NVDA | Stock | 0.2025 | 0.2032 | 0.2017 | 0.2027 | 5845320.0 |
| 2004-03-26 17:00:00 | NVDA | Stock | 0.2041 | 0.2041 | 0.2041 | 0.2041 | 18000.0 |
| 2004-03-26 18:00:00 | NVDA | Stock | 0.2025 | 0.2025 | 0.2025 | 0.2025 | 48000.0 |
| 2004-03-26 08:00:00 | AMZN | Stock | 2.115 | 2.115 | 2.061 | 2.1015 | 247040.0 |
| 2004-03-26 09:00:00 | AMZN | Stock | 2.1025 | 2.1245 | 2.0735 | 2.0796 | 23845880.0 |
| 2004-03-26 10:00:00 | AMZN | Stock | 2.0785 | 2.0995 | 2.075 | 2.086 | 19036000.0 |
| 2004-03-26 11:00:00 | AMZN | Stock | 2.086 | 2.0905 | 2.0735 | 2.0735 | 9234800.0 |
| 2004-03-26 12:00:00 | AMZN | Stock | 2.0745 | 2.086 | 2.067 | 2.0715 | 11941960.0 |
| 2004-03-26 13:00:00 | AMZN | Stock | 2.0725 | 2.0755 | 2.0645 | 2.0705 | 6505620.0 |
| 2004-03-26 14:00:00 | AMZN | Stock | 2.07 | 2.1 | 2.0695 | 2.097 | 12214360.0 |
| 2004-03-26 15:00:00 | AMZN | Stock | 2.0975 | 2.115 | 2.081 | 2.085 | 22876100.0 |
| 2004-03-26 16:00:00 | AMZN | Stock | 2.089 | 2.0925 | 2.08 | 2.083 | 1759100.0 |
| 2004-03-26 17:00:00 | AMZN | Stock | 2.099 | 2.099 | 2.099 | 2.099 | 2000.0 |
| 2004-03-26 09:00:00 | CL | Stock | 27.515 | 27.53 | 27.355 | 27.385 | 448200.0 |
| 2004-03-26 10:00:00 | CL | Stock | 27.375 | 27.535 | 27.35 | 27.46 | 393400.0 |
| 2004-03-26 11:00:00 | CL | Stock | 27.46 | 27.55 | 27.44 | 27.51 | 196800.0 |
| 2004-03-26 12:00:00 | CL | Stock | 27.51 | 27.535 | 27.5 | 27.515 | 189200.0 |
| 2004-03-26 13:00:00 | CL | Stock | 27.515 | 27.52 | 27.405 | 27.41 | 182000.0 |
| 2004-03-26 14:00:00 | CL | Stock | 27.415 | 27.45 | 27.38 | 27.42 | 228800.0 |
| 2004-03-26 15:00:00 | CL | Stock | 27.42 | 27.46 | 27.365 | 27.385 | 549200.0 |
| 2004-03-26 16:00:00 | CL | Stock | 27.36 | 27.36 | 27.36 | 27.36 | 87800.0 |
> showing 50 of 22,738 rows — these rows as CSV