PREVIEW / stock_1hour / 2000-03-13
file: by_date/stock_1hour/2000/2000-03-13.parquet size: 283 KB rows: 14,624 symbols: 1,151
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-03-13 09:00:00 | AAPL | Stock | 1.0904 | 1.106 | 1.0759 | 1.0904 | 29702400.0 |
| 2000-03-13 10:00:00 | AAPL | Stock | 1.0915 | 1.1155 | 1.0848 | 1.106 | 48652800.0 |
| 2000-03-13 11:00:00 | AAPL | Stock | 1.1066 | 1.1116 | 1.1013 | 1.1049 | 25345600.0 |
| 2000-03-13 12:00:00 | AAPL | Stock | 1.106 | 1.1239 | 1.1032 | 1.1228 | 25894400.0 |
| 2000-03-13 13:00:00 | AAPL | Stock | 1.1228 | 1.1295 | 1.0848 | 1.0848 | 39928000.0 |
| 2000-03-13 14:00:00 | AAPL | Stock | 1.0848 | 1.0926 | 1.077 | 1.0776 | 56772800.0 |
| 2000-03-13 15:00:00 | AAPL | Stock | 1.0773 | 1.0837 | 1.0675 | 1.0826 | 48888000.0 |
| 2000-03-13 16:00:00 | AAPL | Stock | 1.082 | 1.0831 | 1.0815 | 1.0831 | 1579200.0 |
| 2000-03-13 09:00:00 | MSFT | Stock | 48.8125 | 49.9688 | 48.8125 | 49.6875 | 8253600.0 |
| 2000-03-13 10:00:00 | MSFT | Stock | 49.625 | 49.8438 | 48.9062 | 49.5 | 12072600.0 |
| 2000-03-13 11:00:00 | MSFT | Stock | 49.5 | 49.625 | 48.9062 | 49.1562 | 6013400.0 |
| 2000-03-13 12:00:00 | MSFT | Stock | 49.1562 | 50.0 | 49.125 | 49.9375 | 7009600.0 |
| 2000-03-13 13:00:00 | MSFT | Stock | 49.9688 | 50.125 | 49.125 | 49.1875 | 6761600.0 |
| 2000-03-13 14:00:00 | MSFT | Stock | 49.1875 | 49.6875 | 49.0938 | 49.0938 | 6332600.0 |
| 2000-03-13 15:00:00 | MSFT | Stock | 49.0938 | 49.1875 | 48.8125 | 49.0 | 9604800.0 |
| 2000-03-13 16:00:00 | MSFT | Stock | 49.0156 | 49.0312 | 48.9688 | 49.0 | 384200.0 |
| 2000-03-13 09:00:00 | NVDA | Stock | 0.2229 | 0.2727 | 0.2208 | 0.2687 | 128544000.0 |
| 2000-03-13 10:00:00 | NVDA | Stock | 0.2661 | 0.2979 | 0.251 | 0.2771 | 298656000.0 |
| 2000-03-13 11:00:00 | NVDA | Stock | 0.276 | 0.2807 | 0.2648 | 0.276 | 126480000.0 |
| 2000-03-13 12:00:00 | NVDA | Stock | 0.2763 | 0.2936 | 0.2755 | 0.2896 | 195792000.0 |
| 2000-03-13 13:00:00 | NVDA | Stock | 0.2901 | 0.2947 | 0.2812 | 0.288 | 140112000.0 |
| 2000-03-13 14:00:00 | NVDA | Stock | 0.288 | 0.2891 | 0.2721 | 0.2779 | 181008000.0 |
| 2000-03-13 15:00:00 | NVDA | Stock | 0.2772 | 0.3125 | 0.2703 | 0.3109 | 554976000.0 |
| 2000-03-13 16:00:00 | NVDA | Stock | 0.3111 | 0.3115 | 0.3083 | 0.3083 | 6336000.0 |
| 2000-03-13 09:00:00 | AMZN | Stock | 3.2 | 3.2438 | 3.15 | 3.2188 | 15286000.0 |
| 2000-03-13 10:00:00 | AMZN | Stock | 3.2188 | 3.25 | 3.2 | 3.2344 | 18444000.0 |
| 2000-03-13 11:00:00 | AMZN | Stock | 3.2344 | 3.2469 | 3.2031 | 3.2078 | 10476000.0 |
| 2000-03-13 12:00:00 | AMZN | Stock | 3.2063 | 3.2688 | 3.2031 | 3.2688 | 13292000.0 |
| 2000-03-13 13:00:00 | AMZN | Stock | 3.2656 | 3.3312 | 3.25 | 3.2688 | 19966000.0 |
| 2000-03-13 14:00:00 | AMZN | Stock | 3.2688 | 3.325 | 3.2594 | 3.3062 | 11884000.0 |
| 2000-03-13 15:00:00 | AMZN | Stock | 3.3062 | 3.3125 | 3.2375 | 3.2656 | 12742000.0 |
| 2000-03-13 16:00:00 | AMZN | Stock | 3.2656 | 3.2656 | 3.2625 | 3.2656 | 252000.0 |
| 2000-03-13 09:00:00 | CL | Stock | 20.25 | 21.4375 | 20.25 | 21.2188 | 767200.0 |
| 2000-03-13 10:00:00 | CL | Stock | 21.2188 | 21.875 | 21.0938 | 21.7188 | 1822000.0 |
| 2000-03-13 11:00:00 | CL | Stock | 21.75 | 22.0625 | 21.7188 | 21.9688 | 897400.0 |
| 2000-03-13 12:00:00 | CL | Stock | 21.9688 | 22.0938 | 21.8438 | 22.0 | 506800.0 |
| 2000-03-13 13:00:00 | CL | Stock | 22.0 | 22.0 | 21.625 | 21.6562 | 451400.0 |
| 2000-03-13 14:00:00 | CL | Stock | 21.6562 | 21.875 | 21.5 | 21.8125 | 507400.0 |
| 2000-03-13 15:00:00 | CL | Stock | 21.8125 | 21.8438 | 21.5 | 21.6875 | 656000.0 |
| 2000-03-13 16:00:00 | CL | Stock | 21.6875 | 21.6875 | 21.6875 | 21.6875 | 84800.0 |
> showing 40 of 14,624 rows — these rows as CSV