PREVIEW / stock_1hour / 2004-04-13
file: by_date/stock_1hour/2004/2004-04-13.parquet size: 516 KB rows: 24,347 symbols: 1,758
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-04-13 08:00:00 | AAPL | Stock | 0.5034 | 0.5034 | 0.5027 | 0.5027 | 11200.0 |
| 2004-04-13 09:00:00 | AAPL | Stock | 0.5016 | 0.5016 | 0.4968 | 0.4979 | 21465640.0 |
| 2004-04-13 10:00:00 | AAPL | Stock | 0.4975 | 0.4977 | 0.4875 | 0.4898 | 62985776.0 |
| 2004-04-13 11:00:00 | AAPL | Stock | 0.49 | 0.4904 | 0.4796 | 0.4857 | 70482664.0 |
| 2004-04-13 12:00:00 | AAPL | Stock | 0.4859 | 0.4866 | 0.4832 | 0.4852 | 25007416.0 |
| 2004-04-13 13:00:00 | AAPL | Stock | 0.4852 | 0.4866 | 0.4809 | 0.4818 | 42339696.0 |
| 2004-04-13 14:00:00 | AAPL | Stock | 0.4814 | 0.4829 | 0.4795 | 0.48 | 47571384.0 |
| 2004-04-13 15:00:00 | AAPL | Stock | 0.4801 | 0.4823 | 0.4793 | 0.4813 | 50427328.0 |
| 2004-04-13 16:00:00 | AAPL | Stock | 0.4811 | 0.4821 | 0.4763 | 0.4766 | 6878928.0 |
| 2004-04-13 17:00:00 | AAPL | Stock | 0.4805 | 0.4821 | 0.477 | 0.4777 | 1072120.0 |
| 2004-04-13 18:00:00 | AAPL | Stock | 0.4809 | 0.4816 | 0.4809 | 0.4816 | 95200.0 |
| 2004-04-13 08:00:00 | MSFT | Stock | 25.69 | 25.75 | 25.66 | 25.7 | 27924.0 |
| 2004-04-13 09:00:00 | MSFT | Stock | 25.7 | 25.77 | 25.62 | 25.68 | 3320536.0 |
| 2004-04-13 10:00:00 | MSFT | Stock | 25.68 | 25.7 | 25.55 | 25.6 | 5913393.0 |
| 2004-04-13 11:00:00 | MSFT | Stock | 25.61 | 25.651 | 25.58 | 25.581 | 4534449.0 |
| 2004-04-13 12:00:00 | MSFT | Stock | 25.58 | 25.61 | 25.5 | 25.57 | 4576302.0 |
| 2004-04-13 13:00:00 | MSFT | Stock | 25.57 | 25.59 | 25.48 | 25.52 | 6607958.0 |
| 2004-04-13 14:00:00 | MSFT | Stock | 25.52 | 25.54 | 25.459 | 25.5 | 8394388.0 |
| 2004-04-13 15:00:00 | MSFT | Stock | 25.5 | 25.55 | 25.41 | 25.44 | 8533100.0 |
| 2004-04-13 16:00:00 | MSFT | Stock | 25.44 | 25.6 | 25.39 | 25.439 | 725681.0 |
| 2004-04-13 17:00:00 | MSFT | Stock | 25.439 | 25.58 | 25.4 | 25.41 | 112433.0 |
| 2004-04-13 18:00:00 | MSFT | Stock | 25.4 | 25.4 | 25.39 | 25.4 | 5300.0 |
| 2004-04-13 08:00:00 | NVDA | Stock | 0.2188 | 0.2212 | 0.2188 | 0.2192 | 708000.0 |
| 2004-04-13 09:00:00 | NVDA | Stock | 0.2192 | 0.2208 | 0.2163 | 0.2182 | 28486320.0 |
| 2004-04-13 10:00:00 | NVDA | Stock | 0.2181 | 0.2183 | 0.2145 | 0.216 | 61767600.0 |
| 2004-04-13 11:00:00 | NVDA | Stock | 0.216 | 0.2166 | 0.2153 | 0.2164 | 24363600.0 |
| 2004-04-13 12:00:00 | NVDA | Stock | 0.2163 | 0.2164 | 0.2156 | 0.2157 | 22407360.0 |
| 2004-04-13 13:00:00 | NVDA | Stock | 0.2157 | 0.2159 | 0.2134 | 0.2134 | 27909120.0 |
| 2004-04-13 14:00:00 | NVDA | Stock | 0.2135 | 0.2145 | 0.2127 | 0.2136 | 55419840.0 |
| 2004-04-13 15:00:00 | NVDA | Stock | 0.2137 | 0.215 | 0.2125 | 0.2135 | 81576000.0 |
| 2004-04-13 16:00:00 | NVDA | Stock | 0.2137 | 0.2142 | 0.2122 | 0.2137 | 1964640.0 |
| 2004-04-13 17:00:00 | NVDA | Stock | 0.2137 | 0.2145 | 0.2132 | 0.2141 | 3124200.0 |
| 2004-04-13 18:00:00 | NVDA | Stock | 0.2143 | 0.2143 | 0.2143 | 0.2143 | 60000.0 |
| 2004-04-13 08:00:00 | AMZN | Stock | 2.398 | 2.4125 | 2.398 | 2.4095 | 78140.0 |
| 2004-04-13 09:00:00 | AMZN | Stock | 2.4125 | 2.417 | 2.3885 | 2.3885 | 8770760.0 |
| 2004-04-13 10:00:00 | AMZN | Stock | 2.3885 | 2.39 | 2.3625 | 2.369 | 14859480.0 |
| 2004-04-13 11:00:00 | AMZN | Stock | 2.3685 | 2.3735 | 2.3575 | 2.3685 | 9042780.0 |
| 2004-04-13 12:00:00 | AMZN | Stock | 2.3685 | 2.369 | 2.358 | 2.3645 | 6633500.0 |
| 2004-04-13 13:00:00 | AMZN | Stock | 2.3635 | 2.3645 | 2.3445 | 2.346 | 8875620.0 |
| 2004-04-13 14:00:00 | AMZN | Stock | 2.346 | 2.349 | 2.3245 | 2.328 | 15203600.0 |
| 2004-04-13 15:00:00 | AMZN | Stock | 2.3275 | 2.3375 | 2.318 | 2.3285 | 15442140.0 |
| 2004-04-13 16:00:00 | AMZN | Stock | 2.3275 | 2.33 | 2.32 | 2.32 | 3770200.0 |
| 2004-04-13 17:00:00 | AMZN | Stock | 2.322 | 2.3402 | 2.318 | 2.318 | 352280.0 |
| 2004-04-13 18:00:00 | AMZN | Stock | 2.3155 | 2.3155 | 2.3155 | 2.3155 | 24000.0 |
| 2004-04-13 09:00:00 | CL | Stock | 27.0 | 27.01 | 26.96 | 27.0 | 314400.0 |
| 2004-04-13 10:00:00 | CL | Stock | 27.0 | 27.135 | 26.965 | 27.055 | 586800.0 |
| 2004-04-13 11:00:00 | CL | Stock | 27.04 | 27.065 | 26.93 | 26.965 | 1020000.0 |
| 2004-04-13 12:00:00 | CL | Stock | 26.955 | 26.975 | 26.81 | 26.85 | 398200.0 |
| 2004-04-13 13:00:00 | CL | Stock | 26.855 | 26.87 | 26.725 | 26.74 | 411400.0 |
| 2004-04-13 14:00:00 | CL | Stock | 26.73 | 26.74 | 26.635 | 26.735 | 625800.0 |
> showing 50 of 24,347 rows — these rows as CSV