PREVIEW / stock_1hour / 2001-12-12
file: by_date/stock_1hour/2001/2001-12-12.parquet size: 373 KB rows: 18,103 symbols: 1,360
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 |
|---|---|---|---|---|---|---|---|
| 2001-12-12 08:00:00 | AAPL | Stock | 0.3855 | 0.3884 | 0.3855 | 0.3882 | 89600.0 |
| 2001-12-12 09:00:00 | AAPL | Stock | 0.3877 | 0.3914 | 0.3846 | 0.3882 | 29024800.0 |
| 2001-12-12 10:00:00 | AAPL | Stock | 0.3882 | 0.3884 | 0.3802 | 0.3814 | 34339200.0 |
| 2001-12-12 11:00:00 | AAPL | Stock | 0.3813 | 0.3854 | 0.3795 | 0.3818 | 17276000.0 |
| 2001-12-12 12:00:00 | AAPL | Stock | 0.3814 | 0.3879 | 0.3814 | 0.3846 | 18194400.0 |
| 2001-12-12 13:00:00 | AAPL | Stock | 0.3846 | 0.3861 | 0.3813 | 0.3839 | 10712800.0 |
| 2001-12-12 14:00:00 | AAPL | Stock | 0.3836 | 0.3853 | 0.3795 | 0.3805 | 25827200.0 |
| 2001-12-12 15:00:00 | AAPL | Stock | 0.3807 | 0.3879 | 0.3805 | 0.3836 | 33908000.0 |
| 2001-12-12 16:00:00 | AAPL | Stock | 0.3836 | 0.3866 | 0.3834 | 0.3866 | 9962400.0 |
| 2001-12-12 17:00:00 | AAPL | Stock | 0.3838 | 0.3838 | 0.3838 | 0.3838 | 28000.0 |
| 2001-12-12 08:00:00 | MSFT | Stock | 33.665 | 33.775 | 33.59 | 33.63 | 687400.0 |
| 2001-12-12 09:00:00 | MSFT | Stock | 33.625 | 33.645 | 33.375 | 33.625 | 5310600.0 |
| 2001-12-12 10:00:00 | MSFT | Stock | 33.635 | 33.875 | 33.275 | 33.315 | 8531000.0 |
| 2001-12-12 11:00:00 | MSFT | Stock | 33.315 | 33.5255 | 33.15 | 33.225 | 5610600.0 |
| 2001-12-12 12:00:00 | MSFT | Stock | 33.225 | 33.35 | 33.1555 | 33.245 | 4245000.0 |
| 2001-12-12 13:00:00 | MSFT | Stock | 33.245 | 33.375 | 33.175 | 33.33 | 3143200.0 |
| 2001-12-12 14:00:00 | MSFT | Stock | 33.325 | 33.35 | 33.125 | 33.2049 | 3707200.0 |
| 2001-12-12 15:00:00 | MSFT | Stock | 33.2049 | 33.975 | 33.175 | 33.97 | 10575200.0 |
| 2001-12-12 16:00:00 | MSFT | Stock | 33.97 | 33.995 | 33.2 | 33.945 | 4289600.0 |
| 2001-12-12 17:00:00 | MSFT | Stock | 33.975 | 33.975 | 33.22 | 33.945 | 36400.0 |
| 2001-12-12 08:00:00 | NVDA | Stock | 0.5227 | 0.5309 | 0.5227 | 0.526 | 4296000.0 |
| 2001-12-12 09:00:00 | NVDA | Stock | 0.525 | 0.5317 | 0.5232 | 0.5304 | 88608000.0 |
| 2001-12-12 10:00:00 | NVDA | Stock | 0.5306 | 0.5325 | 0.5175 | 0.522 | 180552000.0 |
| 2001-12-12 11:00:00 | NVDA | Stock | 0.5224 | 0.5287 | 0.5182 | 0.5223 | 119016000.0 |
| 2001-12-12 12:00:00 | NVDA | Stock | 0.5225 | 0.5231 | 0.5165 | 0.5173 | 85560000.0 |
| 2001-12-12 13:00:00 | NVDA | Stock | 0.5171 | 0.5308 | 0.5168 | 0.5291 | 104028000.0 |
| 2001-12-12 14:00:00 | NVDA | Stock | 0.5289 | 0.5328 | 0.5242 | 0.5286 | 102828000.0 |
| 2001-12-12 15:00:00 | NVDA | Stock | 0.5286 | 0.5392 | 0.5262 | 0.5389 | 253332000.0 |
| 2001-12-12 16:00:00 | NVDA | Stock | 0.5392 | 0.5396 | 0.525 | 0.5259 | 12396000.0 |
| 2001-12-12 17:00:00 | NVDA | Stock | 0.5234 | 0.5396 | 0.5202 | 0.5396 | 588000.0 |
| 2001-12-12 18:00:00 | NVDA | Stock | 0.5396 | 0.5405 | 0.5396 | 0.5405 | 1368000.0 |
| 2001-12-12 08:00:00 | AMZN | Stock | 0.625 | 0.625 | 0.616 | 0.62 | 482000.0 |
| 2001-12-12 09:00:00 | AMZN | Stock | 0.62 | 0.625 | 0.611 | 0.62 | 21854000.0 |
| 2001-12-12 10:00:00 | AMZN | Stock | 0.622 | 0.622 | 0.582 | 0.5915 | 43906000.0 |
| 2001-12-12 11:00:00 | AMZN | Stock | 0.592 | 0.5965 | 0.585 | 0.59 | 17148000.0 |
| 2001-12-12 12:00:00 | AMZN | Stock | 0.591 | 0.5935 | 0.5855 | 0.5905 | 8392000.0 |
| 2001-12-12 13:00:00 | AMZN | Stock | 0.5904 | 0.6035 | 0.589 | 0.597 | 16438000.0 |
| 2001-12-12 14:00:00 | AMZN | Stock | 0.597 | 0.5995 | 0.5865 | 0.5895 | 9244000.0 |
| 2001-12-12 15:00:00 | AMZN | Stock | 0.589 | 0.6 | 0.5875 | 0.596 | 17352000.0 |
| 2001-12-12 16:00:00 | AMZN | Stock | 0.5955 | 0.6215 | 0.5955 | 0.6215 | 2218000.0 |
| 2001-12-12 17:00:00 | AMZN | Stock | 0.5955 | 0.5975 | 0.5955 | 0.5965 | 200000.0 |
| 2001-12-12 18:00:00 | AMZN | Stock | 0.5985 | 0.5985 | 0.5965 | 0.5965 | 28000.0 |
| 2001-12-12 09:00:00 | CL | Stock | 28.75 | 28.9 | 28.675 | 28.825 | 485200.0 |
| 2001-12-12 10:00:00 | CL | Stock | 28.825 | 28.92 | 28.715 | 28.74 | 428000.0 |
| 2001-12-12 11:00:00 | CL | Stock | 28.725 | 28.925 | 28.69 | 28.8 | 420000.0 |
| 2001-12-12 12:00:00 | CL | Stock | 28.795 | 28.8 | 28.6 | 28.675 | 247200.0 |
| 2001-12-12 13:00:00 | CL | Stock | 28.665 | 28.73 | 28.6 | 28.65 | 143600.0 |
| 2001-12-12 14:00:00 | CL | Stock | 28.625 | 28.67 | 28.5 | 28.59 | 285000.0 |
| 2001-12-12 15:00:00 | CL | Stock | 28.59 | 28.75 | 28.45 | 28.475 | 604800.0 |
| 2001-12-12 16:00:00 | CL | Stock | 28.485 | 28.485 | 28.48 | 28.48 | 124600.0 |
> showing 50 of 18,103 rows — these rows as CSV