PREVIEW / stock_1hour / 2004-04-07
file: by_date/stock_1hour/2004/2004-04-07.parquet size: 497 KB rows: 23,520 symbols: 1,759
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-07 09:00:00 | AAPL | Stock | 0.4921 | 0.4946 | 0.4873 | 0.4889 | 37239888.0 |
| 2004-04-07 10:00:00 | AAPL | Stock | 0.4888 | 0.49 | 0.483 | 0.4863 | 53307184.0 |
| 2004-04-07 11:00:00 | AAPL | Stock | 0.4863 | 0.4884 | 0.4838 | 0.4838 | 25823504.0 |
| 2004-04-07 12:00:00 | AAPL | Stock | 0.4838 | 0.4843 | 0.4807 | 0.4821 | 35180936.0 |
| 2004-04-07 13:00:00 | AAPL | Stock | 0.4821 | 0.4863 | 0.4821 | 0.4843 | 16224824.0 |
| 2004-04-07 14:00:00 | AAPL | Stock | 0.4843 | 0.4875 | 0.4836 | 0.4866 | 20557992.0 |
| 2004-04-07 15:00:00 | AAPL | Stock | 0.4868 | 0.4886 | 0.4834 | 0.4875 | 55932744.0 |
| 2004-04-07 16:00:00 | AAPL | Stock | 0.4875 | 0.4918 | 0.4875 | 0.4918 | 4057872.0 |
| 2004-04-07 17:00:00 | AAPL | Stock | 0.492 | 0.5016 | 0.4877 | 0.4982 | 1919512.0 |
| 2004-04-07 18:00:00 | AAPL | Stock | 0.4964 | 0.4964 | 0.4964 | 0.4964 | 56000.0 |
| 2004-04-07 08:00:00 | MSFT | Stock | 25.69 | 25.81 | 25.69 | 25.75 | 33150.0 |
| 2004-04-07 09:00:00 | MSFT | Stock | 25.7 | 25.78 | 25.53 | 25.53 | 6067487.0 |
| 2004-04-07 10:00:00 | MSFT | Stock | 25.53 | 25.63 | 25.49 | 25.5109 | 9514177.0 |
| 2004-04-07 11:00:00 | MSFT | Stock | 25.52 | 25.6 | 25.49 | 25.56 | 4940726.0 |
| 2004-04-07 12:00:00 | MSFT | Stock | 25.57 | 25.65 | 25.5175 | 25.53 | 6549063.0 |
| 2004-04-07 13:00:00 | MSFT | Stock | 25.53 | 25.59 | 25.49 | 25.54 | 5300841.0 |
| 2004-04-07 14:00:00 | MSFT | Stock | 25.54 | 25.69 | 25.51 | 25.64 | 9155283.0 |
| 2004-04-07 15:00:00 | MSFT | Stock | 25.64 | 25.75 | 25.52 | 25.58 | 12736031.0 |
| 2004-04-07 16:00:00 | MSFT | Stock | 25.6 | 25.7 | 25.5 | 25.7 | 6083675.0 |
| 2004-04-07 17:00:00 | MSFT | Stock | 25.7 | 25.98 | 25.68 | 25.77 | 135250.0 |
| 2004-04-07 18:00:00 | MSFT | Stock | 25.77 | 25.89 | 25.77 | 25.84 | 31251.0 |
| 2004-04-07 08:00:00 | NVDA | Stock | 0.2179 | 0.2179 | 0.2179 | 0.2179 | 5472000.0 |
| 2004-04-07 09:00:00 | NVDA | Stock | 0.2187 | 0.2196 | 0.2179 | 0.2186 | 37727640.0 |
| 2004-04-07 10:00:00 | NVDA | Stock | 0.2187 | 0.2189 | 0.2128 | 0.2138 | 149150640.0 |
| 2004-04-07 11:00:00 | NVDA | Stock | 0.2137 | 0.2152 | 0.2137 | 0.2146 | 49278720.0 |
| 2004-04-07 12:00:00 | NVDA | Stock | 0.2145 | 0.2156 | 0.2141 | 0.2147 | 21470640.0 |
| 2004-04-07 13:00:00 | NVDA | Stock | 0.2147 | 0.2154 | 0.2145 | 0.2154 | 18999960.0 |
| 2004-04-07 14:00:00 | NVDA | Stock | 0.2154 | 0.2172 | 0.2152 | 0.2168 | 50250360.0 |
| 2004-04-07 15:00:00 | NVDA | Stock | 0.2168 | 0.2183 | 0.2162 | 0.2163 | 83912640.0 |
| 2004-04-07 16:00:00 | NVDA | Stock | 0.2163 | 0.2182 | 0.216 | 0.2182 | 2528040.0 |
| 2004-04-07 17:00:00 | NVDA | Stock | 0.2182 | 0.22 | 0.216 | 0.22 | 1084680.0 |
| 2004-04-07 18:00:00 | NVDA | Stock | 0.2196 | 0.2196 | 0.2196 | 0.2196 | 60000.0 |
| 2004-04-07 08:00:00 | AMZN | Stock | 2.3255 | 2.3255 | 2.3235 | 2.324 | 31200.0 |
| 2004-04-07 09:00:00 | AMZN | Stock | 2.3215 | 2.34 | 2.305 | 2.335 | 9324960.0 |
| 2004-04-07 10:00:00 | AMZN | Stock | 2.334 | 2.336 | 2.291 | 2.2995 | 15143940.0 |
| 2004-04-07 11:00:00 | AMZN | Stock | 2.299 | 2.3 | 2.2795 | 2.283 | 13910600.0 |
| 2004-04-07 12:00:00 | AMZN | Stock | 2.2825 | 2.2845 | 2.2695 | 2.271 | 12818260.0 |
| 2004-04-07 13:00:00 | AMZN | Stock | 2.271 | 2.2885 | 2.27 | 2.2805 | 6451120.0 |
| 2004-04-07 14:00:00 | AMZN | Stock | 2.2805 | 2.2965 | 2.274 | 2.2925 | 9884280.0 |
| 2004-04-07 15:00:00 | AMZN | Stock | 2.2925 | 2.3085 | 2.285 | 2.294 | 18578320.0 |
| 2004-04-07 16:00:00 | AMZN | Stock | 2.2925 | 2.374 | 2.2875 | 2.356 | 2777920.0 |
| 2004-04-07 17:00:00 | AMZN | Stock | 2.3575 | 2.364 | 2.3525 | 2.3565 | 649000.0 |
| 2004-04-07 18:00:00 | AMZN | Stock | 2.3565 | 2.3575 | 2.3555 | 2.3575 | 42280.0 |
| 2004-04-07 09:00:00 | CL | Stock | 27.325 | 27.325 | 27.205 | 27.275 | 303800.0 |
| 2004-04-07 10:00:00 | CL | Stock | 27.265 | 27.43 | 27.26 | 27.275 | 637600.0 |
| 2004-04-07 11:00:00 | CL | Stock | 27.275 | 27.345 | 27.24 | 27.295 | 335200.0 |
| 2004-04-07 12:00:00 | CL | Stock | 27.325 | 27.325 | 27.125 | 27.13 | 253600.0 |
| 2004-04-07 13:00:00 | CL | Stock | 27.13 | 27.21 | 27.125 | 27.15 | 299600.0 |
| 2004-04-07 14:00:00 | CL | Stock | 27.15 | 27.18 | 27.065 | 27.155 | 452600.0 |
| 2004-04-07 15:00:00 | CL | Stock | 27.155 | 27.335 | 27.15 | 27.215 | 713800.0 |
> showing 50 of 23,520 rows — these rows as CSV