PREVIEW / stock_1hour / 2001-04-12
file: by_date/stock_1hour/2001/2001-04-12.parquet size: 332 KB rows: 15,829 symbols: 1,277
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-04-12 08:00:00 | AAPL | Stock | 0.3891 | 0.3898 | 0.3889 | 0.3889 | 705600.0 |
| 2001-04-12 09:00:00 | AAPL | Stock | 0.3864 | 0.3902 | 0.3786 | 0.3857 | 44083200.0 |
| 2001-04-12 10:00:00 | AAPL | Stock | 0.3854 | 0.3857 | 0.3777 | 0.3814 | 30296000.0 |
| 2001-04-12 11:00:00 | AAPL | Stock | 0.382 | 0.3929 | 0.378 | 0.3927 | 34048000.0 |
| 2001-04-12 12:00:00 | AAPL | Stock | 0.3923 | 0.4045 | 0.3914 | 0.4011 | 40751200.0 |
| 2001-04-12 13:00:00 | AAPL | Stock | 0.4011 | 0.4111 | 0.3982 | 0.4046 | 54320000.0 |
| 2001-04-12 14:00:00 | AAPL | Stock | 0.4046 | 0.407 | 0.3968 | 0.4034 | 34781600.0 |
| 2001-04-12 15:00:00 | AAPL | Stock | 0.4036 | 0.4073 | 0.3991 | 0.4002 | 44346400.0 |
| 2001-04-12 16:00:00 | AAPL | Stock | 0.4004 | 0.4039 | 0.3991 | 0.4009 | 13204800.0 |
| 2001-04-12 17:00:00 | AAPL | Stock | 0.4014 | 0.4014 | 0.4014 | 0.4014 | 5600.0 |
| 2001-04-12 18:00:00 | AAPL | Stock | 0.4016 | 0.4018 | 0.4016 | 0.4018 | 16800.0 |
| 2001-04-12 08:00:00 | MSFT | Stock | 30.0 | 30.25 | 29.925 | 29.985 | 98600.0 |
| 2001-04-12 09:00:00 | MSFT | Stock | 29.9 | 30.125 | 29.655 | 29.84 | 9486200.0 |
| 2001-04-12 10:00:00 | MSFT | Stock | 29.84 | 30.075 | 29.675 | 30.03 | 9834800.0 |
| 2001-04-12 11:00:00 | MSFT | Stock | 30.025 | 30.865 | 29.965 | 30.85 | 17437800.0 |
| 2001-04-12 12:00:00 | MSFT | Stock | 30.87 | 30.975 | 30.65 | 30.835 | 9985600.0 |
| 2001-04-12 13:00:00 | MSFT | Stock | 30.835 | 31.0 | 30.5 | 30.8 | 6530600.0 |
| 2001-04-12 14:00:00 | MSFT | Stock | 30.795 | 31.125 | 30.765 | 31.055 | 11265200.0 |
| 2001-04-12 15:00:00 | MSFT | Stock | 31.055 | 31.155 | 30.775 | 31.09 | 15602000.0 |
| 2001-04-12 16:00:00 | MSFT | Stock | 31.095 | 31.145 | 30.6 | 31.075 | 4694000.0 |
| 2001-04-12 17:00:00 | MSFT | Stock | 31.075 | 31.09 | 31.0 | 31.025 | 48000.0 |
| 2001-04-12 18:00:00 | MSFT | Stock | 31.015 | 31.15 | 31.015 | 31.15 | 6800.0 |
| 2001-04-12 08:00:00 | NVDA | Stock | 0.2927 | 0.2927 | 0.2858 | 0.2858 | 96000.0 |
| 2001-04-12 09:00:00 | NVDA | Stock | 0.2858 | 0.2916 | 0.2781 | 0.2819 | 167592000.0 |
| 2001-04-12 10:00:00 | NVDA | Stock | 0.2823 | 0.2913 | 0.2776 | 0.2907 | 219432000.0 |
| 2001-04-12 11:00:00 | NVDA | Stock | 0.2907 | 0.2942 | 0.2865 | 0.2938 | 218520000.0 |
| 2001-04-12 12:00:00 | NVDA | Stock | 0.2938 | 0.2948 | 0.2898 | 0.2925 | 130872000.0 |
| 2001-04-12 13:00:00 | NVDA | Stock | 0.2925 | 0.3046 | 0.2922 | 0.2991 | 197880000.0 |
| 2001-04-12 14:00:00 | NVDA | Stock | 0.2991 | 0.3001 | 0.2908 | 0.2958 | 226200000.0 |
| 2001-04-12 15:00:00 | NVDA | Stock | 0.2958 | 0.3008 | 0.2917 | 0.293 | 214032000.0 |
| 2001-04-12 16:00:00 | NVDA | Stock | 0.2917 | 0.3008 | 0.2909 | 0.2927 | 41472000.0 |
| 2001-04-12 17:00:00 | NVDA | Stock | 0.2948 | 0.2948 | 0.2948 | 0.2948 | 576000.0 |
| 2001-04-12 08:00:00 | AMZN | Stock | 0.671 | 0.6825 | 0.6675 | 0.6775 | 196000.0 |
| 2001-04-12 09:00:00 | AMZN | Stock | 0.6725 | 0.6925 | 0.6475 | 0.678 | 31398000.0 |
| 2001-04-12 10:00:00 | AMZN | Stock | 0.6775 | 0.702 | 0.669 | 0.694 | 44572000.0 |
| 2001-04-12 11:00:00 | AMZN | Stock | 0.694 | 0.7025 | 0.686 | 0.7 | 28672000.0 |
| 2001-04-12 12:00:00 | AMZN | Stock | 0.702 | 0.725 | 0.7005 | 0.7165 | 29470000.0 |
| 2001-04-12 13:00:00 | AMZN | Stock | 0.715 | 0.7505 | 0.713 | 0.7205 | 40082000.0 |
| 2001-04-12 14:00:00 | AMZN | Stock | 0.72 | 0.73 | 0.71 | 0.713 | 18708000.0 |
| 2001-04-12 15:00:00 | AMZN | Stock | 0.713 | 0.739 | 0.713 | 0.733 | 24238000.0 |
| 2001-04-12 16:00:00 | AMZN | Stock | 0.7335 | 0.7475 | 0.7305 | 0.7425 | 6306000.0 |
| 2001-04-12 17:00:00 | AMZN | Stock | 0.7425 | 0.7455 | 0.7425 | 0.7445 | 128000.0 |
| 2001-04-12 18:00:00 | AMZN | Stock | 0.745 | 0.7455 | 0.7435 | 0.745 | 60000.0 |
| 2001-04-12 09:00:00 | CL | Stock | 25.85 | 26.2 | 25.75 | 26.125 | 385200.0 |
| 2001-04-12 10:00:00 | CL | Stock | 26.125 | 26.225 | 26.0 | 26.05 | 527600.0 |
| 2001-04-12 11:00:00 | CL | Stock | 26.05 | 26.375 | 26.04 | 26.375 | 590400.0 |
| 2001-04-12 12:00:00 | CL | Stock | 26.405 | 26.57 | 26.28 | 26.475 | 658000.0 |
| 2001-04-12 13:00:00 | CL | Stock | 26.475 | 26.5 | 26.4 | 26.425 | 263200.0 |
| 2001-04-12 14:00:00 | CL | Stock | 26.43 | 26.525 | 26.385 | 26.425 | 469200.0 |
| 2001-04-12 15:00:00 | CL | Stock | 26.43 | 26.56 | 26.4 | 26.555 | 761400.0 |
> showing 50 of 15,829 rows — these rows as CSV