PREVIEW / stock_1hour / 2004-02-10
file: by_date/stock_1hour/2004/2004-02-10.parquet size: 537 KB rows: 24,647 symbols: 1,715
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 |
|---|---|---|---|---|---|---|---|
| 2004-02-10 08:00:00 | AAPL | Stock | 0.405 | 0.405 | 0.405 | 0.405 | 56000.0 |
| 2004-02-10 09:00:00 | AAPL | Stock | 0.4052 | 0.4087 | 0.4007 | 0.4077 | 25772880.0 |
| 2004-02-10 10:00:00 | AAPL | Stock | 0.4079 | 0.4091 | 0.4071 | 0.408 | 23017232.0 |
| 2004-02-10 11:00:00 | AAPL | Stock | 0.408 | 0.4104 | 0.4071 | 0.4098 | 35373296.0 |
| 2004-02-10 12:00:00 | AAPL | Stock | 0.4098 | 0.4124 | 0.4096 | 0.4123 | 33597312.0 |
| 2004-02-10 13:00:00 | AAPL | Stock | 0.4123 | 0.4125 | 0.4107 | 0.4109 | 18655952.0 |
| 2004-02-10 14:00:00 | AAPL | Stock | 0.4111 | 0.4129 | 0.4105 | 0.4111 | 42814128.0 |
| 2004-02-10 15:00:00 | AAPL | Stock | 0.4111 | 0.4121 | 0.41 | 0.4105 | 41047720.0 |
| 2004-02-10 16:00:00 | AAPL | Stock | 0.4105 | 0.4118 | 0.4096 | 0.4104 | 3086832.0 |
| 2004-02-10 17:00:00 | AAPL | Stock | 0.4105 | 0.4121 | 0.4104 | 0.4104 | 304080.0 |
| 2004-02-10 18:00:00 | AAPL | Stock | 0.4104 | 0.4104 | 0.4104 | 0.4104 | 178640.0 |
| 2004-02-10 08:00:00 | MSFT | Stock | 26.95 | 26.97 | 26.9 | 26.92 | 35500.0 |
| 2004-02-10 09:00:00 | MSFT | Stock | 26.93 | 27.25 | 26.82 | 26.99 | 4219318.0 |
| 2004-02-10 10:00:00 | MSFT | Stock | 26.99 | 27.13 | 26.94 | 27.11 | 6001508.0 |
| 2004-02-10 11:00:00 | MSFT | Stock | 27.12 | 27.13 | 26.94 | 27.0 | 5635332.0 |
| 2004-02-10 12:00:00 | MSFT | Stock | 27.0 | 27.08 | 26.99 | 27.07 | 3782752.0 |
| 2004-02-10 13:00:00 | MSFT | Stock | 27.07 | 27.09 | 27.01 | 27.06 | 2994602.0 |
| 2004-02-10 14:00:00 | MSFT | Stock | 27.06 | 27.08 | 26.95 | 27.0 | 5845944.0 |
| 2004-02-10 15:00:00 | MSFT | Stock | 27.0 | 27.09 | 26.94 | 27.07 | 6969214.0 |
| 2004-02-10 16:00:00 | MSFT | Stock | 27.06 | 27.138 | 27.0 | 27.05 | 463803.0 |
| 2004-02-10 17:00:00 | MSFT | Stock | 27.04 | 27.07 | 27.04 | 27.06 | 54010.0 |
| 2004-02-10 18:00:00 | MSFT | Stock | 27.06 | 27.07 | 27.05 | 27.07 | 26084.0 |
| 2004-02-10 08:00:00 | NVDA | Stock | 0.1892 | 0.1892 | 0.1889 | 0.1889 | 60000.0 |
| 2004-02-10 09:00:00 | NVDA | Stock | 0.1889 | 0.1921 | 0.1888 | 0.1908 | 70649640.0 |
| 2004-02-10 10:00:00 | NVDA | Stock | 0.1908 | 0.1931 | 0.1896 | 0.1922 | 79411440.0 |
| 2004-02-10 11:00:00 | NVDA | Stock | 0.1923 | 0.1923 | 0.1907 | 0.1917 | 50222400.0 |
| 2004-02-10 12:00:00 | NVDA | Stock | 0.1917 | 0.1945 | 0.1917 | 0.1942 | 56736000.0 |
| 2004-02-10 13:00:00 | NVDA | Stock | 0.1942 | 0.195 | 0.1941 | 0.1944 | 60636000.0 |
| 2004-02-10 14:00:00 | NVDA | Stock | 0.1944 | 0.1952 | 0.1933 | 0.1936 | 68586840.0 |
| 2004-02-10 15:00:00 | NVDA | Stock | 0.1936 | 0.1954 | 0.193 | 0.1954 | 102117720.0 |
| 2004-02-10 16:00:00 | NVDA | Stock | 0.1954 | 0.1957 | 0.1945 | 0.1953 | 3485280.0 |
| 2004-02-10 17:00:00 | NVDA | Stock | 0.1953 | 0.1954 | 0.195 | 0.1954 | 948000.0 |
| 2004-02-10 18:00:00 | NVDA | Stock | 0.1954 | 0.1957 | 0.1953 | 0.1957 | 446640.0 |
| 2004-02-10 08:00:00 | AMZN | Stock | 2.285 | 2.285 | 2.2825 | 2.2825 | 120000.0 |
| 2004-02-10 09:00:00 | AMZN | Stock | 2.285 | 2.309 | 2.281 | 2.2954 | 13250960.0 |
| 2004-02-10 10:00:00 | AMZN | Stock | 2.2955 | 2.3095 | 2.2825 | 2.304 | 19250140.0 |
| 2004-02-10 11:00:00 | AMZN | Stock | 2.304 | 2.3125 | 2.2965 | 2.305 | 10336060.0 |
| 2004-02-10 12:00:00 | AMZN | Stock | 2.305 | 2.3095 | 2.301 | 2.3055 | 6523840.0 |
| 2004-02-10 13:00:00 | AMZN | Stock | 2.3055 | 2.3065 | 2.297 | 2.301 | 8171380.0 |
| 2004-02-10 14:00:00 | AMZN | Stock | 2.3005 | 2.307 | 2.2775 | 2.278 | 17328320.0 |
| 2004-02-10 15:00:00 | AMZN | Stock | 2.278 | 2.2865 | 2.2755 | 2.282 | 17450880.0 |
| 2004-02-10 16:00:00 | AMZN | Stock | 2.2805 | 2.287 | 2.275 | 2.276 | 736580.0 |
| 2004-02-10 17:00:00 | AMZN | Stock | 2.278 | 2.286 | 2.278 | 2.2825 | 196500.0 |
| 2004-02-10 18:00:00 | AMZN | Stock | 2.286 | 2.286 | 2.2795 | 2.2795 | 45200.0 |
| 2004-02-10 08:00:00 | CL | Stock | 28.0 | 28.0 | 28.0 | 28.0 | 200.0 |
| 2004-02-10 09:00:00 | CL | Stock | 27.535 | 27.875 | 27.535 | 27.8 | 1385600.0 |
| 2004-02-10 10:00:00 | CL | Stock | 27.795 | 27.8 | 27.525 | 27.575 | 1202800.0 |
| 2004-02-10 11:00:00 | CL | Stock | 27.575 | 27.65 | 27.54 | 27.65 | 632600.0 |
| 2004-02-10 12:00:00 | CL | Stock | 27.655 | 27.795 | 27.63 | 27.77 | 830600.0 |
| 2004-02-10 13:00:00 | CL | Stock | 27.77 | 27.775 | 27.67 | 27.7 | 343400.0 |
> showing 50 of 24,647 rows — these rows as CSV