PREVIEW / stock_1hour / 2004-03-29
file: by_date/stock_1hour/2004/2004-03-29.parquet size: 516 KB rows: 24,456 symbols: 1,752
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-29 08:00:00 | AAPL | Stock | 0.4911 | 0.4955 | 0.4902 | 0.4955 | 132160.0 |
| 2004-03-29 09:00:00 | AAPL | Stock | 0.4927 | 0.4961 | 0.488 | 0.4944 | 38413816.0 |
| 2004-03-29 10:00:00 | AAPL | Stock | 0.4946 | 0.4964 | 0.4909 | 0.4943 | 37380952.0 |
| 2004-03-29 11:00:00 | AAPL | Stock | 0.4946 | 0.4977 | 0.4932 | 0.4977 | 31703840.0 |
| 2004-03-29 12:00:00 | AAPL | Stock | 0.4977 | 0.4998 | 0.4975 | 0.4989 | 46697896.0 |
| 2004-03-29 13:00:00 | AAPL | Stock | 0.4989 | 0.4989 | 0.4966 | 0.498 | 33476856.0 |
| 2004-03-29 14:00:00 | AAPL | Stock | 0.498 | 0.4988 | 0.4961 | 0.4973 | 49477736.0 |
| 2004-03-29 15:00:00 | AAPL | Stock | 0.4973 | 0.4986 | 0.4941 | 0.4986 | 80503528.0 |
| 2004-03-29 16:00:00 | AAPL | Stock | 0.4984 | 0.4993 | 0.4977 | 0.4988 | 9740808.0 |
| 2004-03-29 08:00:00 | MSFT | Stock | 25.17 | 25.27 | 25.17 | 25.26 | 55800.0 |
| 2004-03-29 09:00:00 | MSFT | Stock | 25.25 | 25.31 | 25.13 | 25.23 | 6893610.0 |
| 2004-03-29 10:00:00 | MSFT | Stock | 25.23 | 25.4 | 25.22 | 25.27 | 7567023.0 |
| 2004-03-29 11:00:00 | MSFT | Stock | 25.27 | 25.3 | 25.225 | 25.26 | 6155050.0 |
| 2004-03-29 12:00:00 | MSFT | Stock | 25.26 | 25.29 | 25.2 | 25.221 | 4742465.0 |
| 2004-03-29 13:00:00 | MSFT | Stock | 25.22 | 25.28 | 25.2 | 25.23 | 3379688.0 |
| 2004-03-29 14:00:00 | MSFT | Stock | 25.23 | 25.37 | 25.21 | 25.37 | 4952004.0 |
| 2004-03-29 15:00:00 | MSFT | Stock | 25.37 | 25.4 | 25.17 | 25.3 | 13420039.0 |
| 2004-03-29 16:00:00 | MSFT | Stock | 25.3 | 25.33 | 25.21 | 25.25 | 1384465.0 |
| 2004-03-29 17:00:00 | MSFT | Stock | 25.24 | 25.31 | 25.22 | 25.25 | 69400.0 |
| 2004-03-29 18:00:00 | MSFT | Stock | 25.26 | 25.27 | 25.25 | 25.25 | 3000.0 |
| 2004-03-29 08:00:00 | NVDA | Stock | 0.2057 | 0.2057 | 0.2029 | 0.2046 | 984000.0 |
| 2004-03-29 09:00:00 | NVDA | Stock | 0.2046 | 0.2121 | 0.2046 | 0.211 | 131728680.0 |
| 2004-03-29 10:00:00 | NVDA | Stock | 0.2112 | 0.2126 | 0.2107 | 0.2121 | 183272880.0 |
| 2004-03-29 11:00:00 | NVDA | Stock | 0.2122 | 0.2139 | 0.2119 | 0.2137 | 123478920.0 |
| 2004-03-29 12:00:00 | NVDA | Stock | 0.2138 | 0.2142 | 0.2132 | 0.2132 | 94337760.0 |
| 2004-03-29 13:00:00 | NVDA | Stock | 0.2132 | 0.2144 | 0.2131 | 0.2141 | 74087760.0 |
| 2004-03-29 14:00:00 | NVDA | Stock | 0.2141 | 0.2143 | 0.2128 | 0.2137 | 79840320.0 |
| 2004-03-29 15:00:00 | NVDA | Stock | 0.2137 | 0.214 | 0.2108 | 0.2113 | 182808480.0 |
| 2004-03-29 16:00:00 | NVDA | Stock | 0.2113 | 0.2124 | 0.2108 | 0.2117 | 20749080.0 |
| 2004-03-29 17:00:00 | NVDA | Stock | 0.212 | 0.2121 | 0.212 | 0.2121 | 108000.0 |
| 2004-03-29 08:00:00 | AMZN | Stock | 2.1 | 2.1095 | 2.1 | 2.105 | 20000.0 |
| 2004-03-29 09:00:00 | AMZN | Stock | 2.105 | 2.1285 | 2.095 | 2.12 | 13889440.0 |
| 2004-03-29 10:00:00 | AMZN | Stock | 2.12 | 2.129 | 2.105 | 2.113 | 19688380.0 |
| 2004-03-29 11:00:00 | AMZN | Stock | 2.1135 | 2.127 | 2.1125 | 2.1255 | 11293740.0 |
| 2004-03-29 12:00:00 | AMZN | Stock | 2.126 | 2.1325 | 2.123 | 2.125 | 9966240.0 |
| 2004-03-29 13:00:00 | AMZN | Stock | 2.1245 | 2.1315 | 2.1225 | 2.131 | 7152020.0 |
| 2004-03-29 14:00:00 | AMZN | Stock | 2.131 | 2.135 | 2.128 | 2.1315 | 10985820.0 |
| 2004-03-29 15:00:00 | AMZN | Stock | 2.1305 | 2.14 | 2.121 | 2.136 | 21029000.0 |
| 2004-03-29 16:00:00 | AMZN | Stock | 2.136 | 2.1545 | 2.134 | 2.148 | 2077640.0 |
| 2004-03-29 17:00:00 | AMZN | Stock | 2.148 | 2.149 | 2.1385 | 2.1415 | 494960.0 |
| 2004-03-29 09:00:00 | CL | Stock | 27.275 | 27.375 | 27.175 | 27.3 | 427600.0 |
| 2004-03-29 10:00:00 | CL | Stock | 27.305 | 27.415 | 27.295 | 27.38 | 358000.0 |
| 2004-03-29 11:00:00 | CL | Stock | 27.38 | 27.54 | 27.37 | 27.535 | 307400.0 |
| 2004-03-29 12:00:00 | CL | Stock | 27.54 | 27.575 | 27.495 | 27.57 | 296800.0 |
| 2004-03-29 13:00:00 | CL | Stock | 27.57 | 27.65 | 27.56 | 27.595 | 353000.0 |
| 2004-03-29 14:00:00 | CL | Stock | 27.6 | 27.665 | 27.555 | 27.62 | 285600.0 |
| 2004-03-29 15:00:00 | CL | Stock | 27.62 | 27.69 | 27.575 | 27.66 | 737400.0 |
| 2004-03-29 16:00:00 | CL | Stock | 27.675 | 27.675 | 27.675 | 27.675 | 1800.0 |
| 2004-03-29 17:00:00 | CL | Stock | 27.675 | 27.675 | 27.675 | 27.675 | 1000.0 |
| 2004-03-29 18:00:00 | CL | Stock | 27.675 | 27.675 | 27.675 | 27.675 | 1400.0 |
> showing 50 of 24,456 rows — these rows as CSV