PREVIEW / stock_1hour / 2001-04-11
file: by_date/stock_1hour/2001/2001-04-11.parquet size: 349 KB rows: 16,545 symbols: 1,290
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-11 08:00:00 | AAPL | Stock | 0.3936 | 0.4107 | 0.3936 | 0.4107 | 5336800.0 |
| 2001-04-11 09:00:00 | AAPL | Stock | 0.4084 | 0.4107 | 0.4009 | 0.402 | 57097600.0 |
| 2001-04-11 10:00:00 | AAPL | Stock | 0.402 | 0.4041 | 0.3945 | 0.3946 | 51016000.0 |
| 2001-04-11 11:00:00 | AAPL | Stock | 0.3945 | 0.3946 | 0.3804 | 0.3857 | 47090400.0 |
| 2001-04-11 12:00:00 | AAPL | Stock | 0.3864 | 0.39 | 0.38 | 0.3825 | 26667200.0 |
| 2001-04-11 13:00:00 | AAPL | Stock | 0.3825 | 0.3934 | 0.3821 | 0.3884 | 29758400.0 |
| 2001-04-11 14:00:00 | AAPL | Stock | 0.3886 | 0.3979 | 0.3859 | 0.3859 | 38701600.0 |
| 2001-04-11 15:00:00 | AAPL | Stock | 0.3854 | 0.39 | 0.3809 | 0.3891 | 45147200.0 |
| 2001-04-11 16:00:00 | AAPL | Stock | 0.3882 | 0.3939 | 0.387 | 0.3893 | 17455200.0 |
| 2001-04-11 17:00:00 | AAPL | Stock | 0.3893 | 0.3893 | 0.3875 | 0.3875 | 95200.0 |
| 2001-04-11 18:00:00 | AAPL | Stock | 0.3877 | 0.3877 | 0.3877 | 0.3877 | 5600.0 |
| 2001-04-11 08:00:00 | MSFT | Stock | 30.05 | 30.56 | 29.84 | 30.195 | 764600.0 |
| 2001-04-11 09:00:00 | MSFT | Stock | 30.25 | 30.5 | 29.9 | 30.215 | 18504200.0 |
| 2001-04-11 10:00:00 | MSFT | Stock | 30.21 | 30.44 | 30.125 | 30.275 | 15359400.0 |
| 2001-04-11 11:00:00 | MSFT | Stock | 30.28 | 30.35 | 30.1 | 30.195 | 17363400.0 |
| 2001-04-11 12:00:00 | MSFT | Stock | 30.195 | 30.305 | 29.98 | 30.195 | 7299000.0 |
| 2001-04-11 13:00:00 | MSFT | Stock | 30.2 | 30.75 | 30.18 | 30.365 | 16352600.0 |
| 2001-04-11 14:00:00 | MSFT | Stock | 30.375 | 30.48 | 29.985 | 30.075 | 10516800.0 |
| 2001-04-11 15:00:00 | MSFT | Stock | 30.055 | 30.135 | 29.85 | 30.025 | 15517600.0 |
| 2001-04-11 16:00:00 | MSFT | Stock | 30.025 | 30.5 | 30.0 | 30.02 | 2452400.0 |
| 2001-04-11 17:00:00 | MSFT | Stock | 30.05 | 30.17 | 30.005 | 30.165 | 12200.0 |
| 2001-04-11 18:00:00 | MSFT | Stock | 30.02 | 30.02 | 30.02 | 30.02 | 200.0 |
| 2001-04-11 08:00:00 | NVDA | Stock | 0.275 | 0.2909 | 0.275 | 0.2854 | 4248000.0 |
| 2001-04-11 09:00:00 | NVDA | Stock | 0.2854 | 0.2992 | 0.2854 | 0.2898 | 249360000.0 |
| 2001-04-11 10:00:00 | NVDA | Stock | 0.2898 | 0.2958 | 0.2854 | 0.2917 | 318888000.0 |
| 2001-04-11 11:00:00 | NVDA | Stock | 0.2917 | 0.2924 | 0.2827 | 0.2835 | 233664000.0 |
| 2001-04-11 12:00:00 | NVDA | Stock | 0.2836 | 0.2854 | 0.2804 | 0.2835 | 176448000.0 |
| 2001-04-11 13:00:00 | NVDA | Stock | 0.2835 | 0.2857 | 0.2829 | 0.283 | 105000000.0 |
| 2001-04-11 14:00:00 | NVDA | Stock | 0.283 | 0.2869 | 0.2825 | 0.2858 | 70992000.0 |
| 2001-04-11 15:00:00 | NVDA | Stock | 0.2853 | 0.2917 | 0.2844 | 0.2884 | 173352000.0 |
| 2001-04-11 16:00:00 | NVDA | Stock | 0.2884 | 0.2917 | 0.2878 | 0.2917 | 10944000.0 |
| 2001-04-11 17:00:00 | NVDA | Stock | 0.2916 | 0.2938 | 0.2916 | 0.2938 | 768000.0 |
| 2001-04-11 18:00:00 | NVDA | Stock | 0.2933 | 0.2952 | 0.2933 | 0.2952 | 96000.0 |
| 2001-04-11 08:00:00 | AMZN | Stock | 0.6705 | 0.675 | 0.625 | 0.6275 | 1924000.0 |
| 2001-04-11 09:00:00 | AMZN | Stock | 0.6275 | 0.668 | 0.6155 | 0.6475 | 48292000.0 |
| 2001-04-11 10:00:00 | AMZN | Stock | 0.649 | 0.6535 | 0.641 | 0.645 | 39526000.0 |
| 2001-04-11 11:00:00 | AMZN | Stock | 0.645 | 0.647 | 0.609 | 0.6155 | 27452000.0 |
| 2001-04-11 12:00:00 | AMZN | Stock | 0.6155 | 0.6455 | 0.614 | 0.644 | 30322000.0 |
| 2001-04-11 13:00:00 | AMZN | Stock | 0.644 | 0.6825 | 0.6405 | 0.6675 | 44744000.0 |
| 2001-04-11 14:00:00 | AMZN | Stock | 0.664 | 0.67 | 0.635 | 0.6495 | 30306000.0 |
| 2001-04-11 15:00:00 | AMZN | Stock | 0.648 | 0.6665 | 0.642 | 0.6665 | 26194000.0 |
| 2001-04-11 16:00:00 | AMZN | Stock | 0.666 | 0.6925 | 0.648 | 0.6675 | 5300000.0 |
| 2001-04-11 17:00:00 | AMZN | Stock | 0.6695 | 0.671 | 0.666 | 0.6665 | 268000.0 |
| 2001-04-11 18:00:00 | AMZN | Stock | 0.667 | 0.6725 | 0.667 | 0.6725 | 48000.0 |
| 2001-04-11 09:00:00 | CL | Stock | 25.775 | 25.8 | 25.42 | 25.445 | 596800.0 |
| 2001-04-11 10:00:00 | CL | Stock | 25.43 | 25.525 | 25.3 | 25.475 | 761600.0 |
| 2001-04-11 11:00:00 | CL | Stock | 25.5 | 25.675 | 25.45 | 25.52 | 767400.0 |
| 2001-04-11 12:00:00 | CL | Stock | 25.54 | 25.6 | 25.45 | 25.45 | 347800.0 |
| 2001-04-11 13:00:00 | CL | Stock | 25.45 | 25.71 | 25.435 | 25.615 | 404800.0 |
| 2001-04-11 14:00:00 | CL | Stock | 25.6 | 25.665 | 25.455 | 25.5 | 519200.0 |
> showing 50 of 16,545 rows — these rows as CSV