PREVIEW / stock_1hour / 2005-05-10
file: by_date/stock_1hour/2005/2005-05-10.parquet size: 555 KB rows: 26,633 symbols: 1,963
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 |
|---|---|---|---|---|---|---|---|
| 2005-05-10 08:00:00 | AAPL | Stock | 1.3204 | 1.325 | 1.3161 | 1.3164 | 312760.0 |
| 2005-05-10 09:00:00 | AAPL | Stock | 1.3161 | 1.3211 | 1.3096 | 1.3168 | 45737020.0 |
| 2005-05-10 10:00:00 | AAPL | Stock | 1.3164 | 1.3204 | 1.3111 | 1.3179 | 48001408.0 |
| 2005-05-10 11:00:00 | AAPL | Stock | 1.3175 | 1.3243 | 1.3154 | 1.3171 | 39948160.0 |
| 2005-05-10 12:00:00 | AAPL | Stock | 1.3171 | 1.3296 | 1.3168 | 1.3286 | 41600888.0 |
| 2005-05-10 13:00:00 | AAPL | Stock | 1.3286 | 1.3304 | 1.3225 | 1.3264 | 32159792.0 |
| 2005-05-10 14:00:00 | AAPL | Stock | 1.3264 | 1.3275 | 1.3071 | 1.3107 | 90757660.0 |
| 2005-05-10 15:00:00 | AAPL | Stock | 1.3107 | 1.3121 | 1.2975 | 1.2993 | 133130368.0 |
| 2005-05-10 16:00:00 | AAPL | Stock | 1.2986 | 1.3054 | 1.2854 | 1.2857 | 6928292.0 |
| 2005-05-10 17:00:00 | AAPL | Stock | 1.2875 | 1.3007 | 1.2696 | 1.2707 | 2958872.0 |
| 2005-05-10 18:00:00 | AAPL | Stock | 1.2707 | 1.2729 | 1.2643 | 1.2729 | 1492372.0 |
| 2005-05-10 07:00:00 | MSFT | Stock | 25.15 | 25.15 | 25.15 | 25.15 | 3300.0 |
| 2005-05-10 08:00:00 | MSFT | Stock | 25.15 | 25.15 | 25.0 | 25.15 | 1155944.0 |
| 2005-05-10 09:00:00 | MSFT | Stock | 25.15 | 25.299 | 24.9 | 24.96 | 10337100.0 |
| 2005-05-10 10:00:00 | MSFT | Stock | 24.96 | 25.0 | 24.86 | 24.9 | 10060366.0 |
| 2005-05-10 11:00:00 | MSFT | Stock | 24.9 | 24.94 | 24.84 | 24.88 | 7126751.0 |
| 2005-05-10 12:00:00 | MSFT | Stock | 24.88 | 24.95 | 24.87 | 24.93 | 6434451.0 |
| 2005-05-10 13:00:00 | MSFT | Stock | 24.92 | 24.99 | 24.9 | 24.95 | 4018857.0 |
| 2005-05-10 14:00:00 | MSFT | Stock | 24.95 | 24.96 | 24.84 | 24.87 | 7225116.0 |
| 2005-05-10 15:00:00 | MSFT | Stock | 24.86 | 24.95 | 24.82 | 24.89 | 10984960.0 |
| 2005-05-10 16:00:00 | MSFT | Stock | 24.89 | 24.91 | 24.78 | 24.82 | 1661846.0 |
| 2005-05-10 17:00:00 | MSFT | Stock | 24.82 | 24.9 | 24.82 | 24.82 | 38410.0 |
| 2005-05-10 18:00:00 | MSFT | Stock | 24.8 | 24.83 | 24.8 | 24.83 | 4605.0 |
| 2005-05-10 08:00:00 | NVDA | Stock | 0.1935 | 0.1952 | 0.1933 | 0.1952 | 132000.0 |
| 2005-05-10 09:00:00 | NVDA | Stock | 0.1947 | 0.1953 | 0.19 | 0.1906 | 152312880.0 |
| 2005-05-10 10:00:00 | NVDA | Stock | 0.1907 | 0.1927 | 0.1903 | 0.191 | 87771600.0 |
| 2005-05-10 11:00:00 | NVDA | Stock | 0.191 | 0.1914 | 0.1897 | 0.1899 | 66768240.0 |
| 2005-05-10 12:00:00 | NVDA | Stock | 0.1899 | 0.1904 | 0.1892 | 0.19 | 61371480.0 |
| 2005-05-10 13:00:00 | NVDA | Stock | 0.1899 | 0.1901 | 0.1887 | 0.1895 | 62799120.0 |
| 2005-05-10 14:00:00 | NVDA | Stock | 0.1895 | 0.1897 | 0.1868 | 0.1877 | 131658120.0 |
| 2005-05-10 15:00:00 | NVDA | Stock | 0.1877 | 0.1891 | 0.1868 | 0.189 | 133906320.0 |
| 2005-05-10 16:00:00 | NVDA | Stock | 0.1891 | 0.1892 | 0.1883 | 0.1887 | 2669520.0 |
| 2005-05-10 17:00:00 | NVDA | Stock | 0.1892 | 0.1892 | 0.1883 | 0.1892 | 705840.0 |
| 2005-05-10 08:00:00 | AMZN | Stock | 1.725 | 1.725 | 1.72 | 1.7245 | 178400.0 |
| 2005-05-10 09:00:00 | AMZN | Stock | 1.7245 | 1.7245 | 1.7125 | 1.7125 | 10651860.0 |
| 2005-05-10 10:00:00 | AMZN | Stock | 1.7125 | 1.7225 | 1.7095 | 1.7125 | 23194560.0 |
| 2005-05-10 11:00:00 | AMZN | Stock | 1.7125 | 1.7145 | 1.707 | 1.7075 | 8248280.0 |
| 2005-05-10 12:00:00 | AMZN | Stock | 1.707 | 1.7125 | 1.706 | 1.71 | 7330280.0 |
| 2005-05-10 13:00:00 | AMZN | Stock | 1.7105 | 1.7125 | 1.705 | 1.708 | 8237200.0 |
| 2005-05-10 14:00:00 | AMZN | Stock | 1.708 | 1.715 | 1.705 | 1.7075 | 11479900.0 |
| 2005-05-10 15:00:00 | AMZN | Stock | 1.7075 | 1.7177 | 1.701 | 1.711 | 33516540.0 |
| 2005-05-10 16:00:00 | AMZN | Stock | 1.713 | 1.7165 | 1.7115 | 1.7165 | 378760.0 |
| 2005-05-10 17:00:00 | AMZN | Stock | 1.7125 | 1.7125 | 1.7105 | 1.7105 | 50000.0 |
| 2005-05-10 09:00:00 | CL | Stock | 24.495 | 24.525 | 24.38 | 24.43 | 366800.0 |
| 2005-05-10 10:00:00 | CL | Stock | 24.43 | 24.51 | 24.375 | 24.4 | 807400.0 |
| 2005-05-10 11:00:00 | CL | Stock | 24.415 | 24.475 | 24.375 | 24.38 | 443800.0 |
| 2005-05-10 12:00:00 | CL | Stock | 24.38 | 24.4 | 24.31 | 24.385 | 433800.0 |
| 2005-05-10 13:00:00 | CL | Stock | 24.38 | 24.45 | 24.345 | 24.395 | 430400.0 |
| 2005-05-10 14:00:00 | CL | Stock | 24.395 | 24.405 | 24.15 | 24.26 | 677600.0 |
| 2005-05-10 15:00:00 | CL | Stock | 24.255 | 24.33 | 24.21 | 24.31 | 1015400.0 |
> showing 50 of 26,633 rows — these rows as CSV