PREVIEW / stock_1hour / 2000-10-09
file: by_date/stock_1hour/2000/2000-10-09.parquet size: 294 KB rows: 15,087 symbols: 1,217
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 |
|---|---|---|---|---|---|---|---|
| 2000-10-09 08:00:00 | AAPL | Stock | 0.3951 | 0.3984 | 0.3929 | 0.3951 | 739200.0 |
| 2000-10-09 09:00:00 | AAPL | Stock | 0.3973 | 0.4085 | 0.3906 | 0.3917 | 90328000.0 |
| 2000-10-09 10:00:00 | AAPL | Stock | 0.3917 | 0.394 | 0.3828 | 0.3839 | 87147200.0 |
| 2000-10-09 11:00:00 | AAPL | Stock | 0.3839 | 0.3884 | 0.3772 | 0.3884 | 59740800.0 |
| 2000-10-09 12:00:00 | AAPL | Stock | 0.3884 | 0.3962 | 0.3862 | 0.3929 | 70117600.0 |
| 2000-10-09 13:00:00 | AAPL | Stock | 0.3951 | 0.3951 | 0.3906 | 0.3917 | 60860800.0 |
| 2000-10-09 14:00:00 | AAPL | Stock | 0.3917 | 0.3973 | 0.3895 | 0.3895 | 86027200.0 |
| 2000-10-09 15:00:00 | AAPL | Stock | 0.3906 | 0.394 | 0.3873 | 0.3884 | 118748000.0 |
| 2000-10-09 16:00:00 | AAPL | Stock | 0.3884 | 0.4051 | 0.3873 | 0.3895 | 13126400.0 |
| 2000-10-09 17:00:00 | AAPL | Stock | 0.3873 | 0.3895 | 0.3873 | 0.3895 | 67200.0 |
| 2000-10-09 18:00:00 | AAPL | Stock | 0.3895 | 0.3895 | 0.3884 | 0.3895 | 95200.0 |
| 2000-10-09 08:00:00 | MSFT | Stock | 27.7656 | 27.8125 | 27.7656 | 27.8125 | 33000.0 |
| 2000-10-09 09:00:00 | MSFT | Stock | 27.7812 | 27.875 | 27.3438 | 27.4062 | 4827000.0 |
| 2000-10-09 10:00:00 | MSFT | Stock | 27.4375 | 27.5 | 27.125 | 27.25 | 8563600.0 |
| 2000-10-09 11:00:00 | MSFT | Stock | 27.2812 | 27.375 | 27.0625 | 27.3438 | 6305000.0 |
| 2000-10-09 12:00:00 | MSFT | Stock | 27.3438 | 27.4375 | 27.0938 | 27.0938 | 5654000.0 |
| 2000-10-09 13:00:00 | MSFT | Stock | 27.0625 | 27.0938 | 26.5 | 26.6875 | 9610800.0 |
| 2000-10-09 14:00:00 | MSFT | Stock | 26.6875 | 27.0312 | 26.625 | 26.7812 | 8103400.0 |
| 2000-10-09 15:00:00 | MSFT | Stock | 26.75 | 27.0938 | 26.75 | 27.0625 | 12327200.0 |
| 2000-10-09 16:00:00 | MSFT | Stock | 27.0625 | 27.125 | 26.8438 | 27.125 | 2147600.0 |
| 2000-10-09 17:00:00 | MSFT | Stock | 27.0938 | 27.125 | 27.0 | 27.0469 | 16400.0 |
| 2000-10-09 18:00:00 | MSFT | Stock | 27.0469 | 27.0469 | 27.0312 | 27.0312 | 4200.0 |
| 2000-10-09 08:00:00 | NVDA | Stock | 0.275 | 0.2781 | 0.2664 | 0.275 | 600000.0 |
| 2000-10-09 09:00:00 | NVDA | Stock | 0.2708 | 0.2792 | 0.2625 | 0.2638 | 101184000.0 |
| 2000-10-09 10:00:00 | NVDA | Stock | 0.2635 | 0.2667 | 0.2583 | 0.2655 | 139968000.0 |
| 2000-10-09 11:00:00 | NVDA | Stock | 0.2665 | 0.2719 | 0.2625 | 0.2708 | 67464000.0 |
| 2000-10-09 12:00:00 | NVDA | Stock | 0.2703 | 0.2833 | 0.2703 | 0.2786 | 74952000.0 |
| 2000-10-09 13:00:00 | NVDA | Stock | 0.2789 | 0.2885 | 0.2776 | 0.2875 | 80112000.0 |
| 2000-10-09 14:00:00 | NVDA | Stock | 0.2878 | 0.2927 | 0.2836 | 0.2844 | 84168000.0 |
| 2000-10-09 15:00:00 | NVDA | Stock | 0.2854 | 0.2958 | 0.2852 | 0.2914 | 95160000.0 |
| 2000-10-09 16:00:00 | NVDA | Stock | 0.2904 | 0.2917 | 0.2901 | 0.2917 | 1704000.0 |
| 2000-10-09 17:00:00 | NVDA | Stock | 0.2906 | 0.2906 | 0.2875 | 0.2875 | 48000.0 |
| 2000-10-09 08:00:00 | AMZN | Stock | 1.5875 | 1.5875 | 1.5312 | 1.5594 | 58000.0 |
| 2000-10-09 09:00:00 | AMZN | Stock | 1.55 | 1.5688 | 1.4375 | 1.4406 | 27988000.0 |
| 2000-10-09 10:00:00 | AMZN | Stock | 1.4375 | 1.45 | 1.3688 | 1.3812 | 66330000.0 |
| 2000-10-09 11:00:00 | AMZN | Stock | 1.3812 | 1.425 | 1.3688 | 1.4156 | 39220000.0 |
| 2000-10-09 12:00:00 | AMZN | Stock | 1.4188 | 1.4938 | 1.4094 | 1.4531 | 39364000.0 |
| 2000-10-09 13:00:00 | AMZN | Stock | 1.4562 | 1.4688 | 1.4375 | 1.4594 | 10720000.0 |
| 2000-10-09 14:00:00 | AMZN | Stock | 1.4562 | 1.5281 | 1.4562 | 1.4938 | 31554000.0 |
| 2000-10-09 15:00:00 | AMZN | Stock | 1.4969 | 1.5156 | 1.475 | 1.5031 | 22956000.0 |
| 2000-10-09 16:00:00 | AMZN | Stock | 1.5031 | 1.525 | 1.5 | 1.5188 | 1052000.0 |
| 2000-10-09 17:00:00 | AMZN | Stock | 1.5062 | 1.5156 | 1.5062 | 1.5062 | 12000.0 |
| 2000-10-09 18:00:00 | AMZN | Stock | 1.5125 | 1.5125 | 1.5062 | 1.5062 | 10000.0 |
| 2000-10-09 09:00:00 | CL | Stock | 25.0 | 25.075 | 25.0 | 25.05 | 270800.0 |
| 2000-10-09 10:00:00 | CL | Stock | 25.06 | 25.125 | 24.85 | 24.875 | 500800.0 |
| 2000-10-09 11:00:00 | CL | Stock | 24.895 | 25.0 | 24.875 | 24.96 | 322800.0 |
| 2000-10-09 12:00:00 | CL | Stock | 24.99 | 25.02 | 24.725 | 24.725 | 432200.0 |
| 2000-10-09 13:00:00 | CL | Stock | 24.73 | 24.9 | 24.7 | 24.89 | 253400.0 |
| 2000-10-09 14:00:00 | CL | Stock | 24.9 | 25.05 | 24.8 | 24.8 | 233000.0 |
| 2000-10-09 15:00:00 | CL | Stock | 24.805 | 25.075 | 24.805 | 25.055 | 656400.0 |
> showing 50 of 15,087 rows — these rows as CSV