PREVIEW / stock_1hour / 2004-02-17
file: by_date/stock_1hour/2004/2004-02-17.parquet size: 530 KB rows: 24,012 symbols: 1,732
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-17 08:00:00 | AAPL | Stock | 0.4113 | 0.4152 | 0.4113 | 0.4152 | 39200.0 |
| 2004-02-17 09:00:00 | AAPL | Stock | 0.4139 | 0.4195 | 0.4125 | 0.4152 | 40820920.0 |
| 2004-02-17 10:00:00 | AAPL | Stock | 0.4152 | 0.4159 | 0.4127 | 0.4141 | 26151944.0 |
| 2004-02-17 11:00:00 | AAPL | Stock | 0.4141 | 0.4157 | 0.4139 | 0.4152 | 15975344.0 |
| 2004-02-17 12:00:00 | AAPL | Stock | 0.4152 | 0.4179 | 0.415 | 0.4173 | 11362568.0 |
| 2004-02-17 13:00:00 | AAPL | Stock | 0.4171 | 0.4179 | 0.4143 | 0.4157 | 14962864.0 |
| 2004-02-17 14:00:00 | AAPL | Stock | 0.4157 | 0.4171 | 0.415 | 0.4166 | 19709200.0 |
| 2004-02-17 15:00:00 | AAPL | Stock | 0.4163 | 0.4168 | 0.4134 | 0.4136 | 28747600.0 |
| 2004-02-17 16:00:00 | AAPL | Stock | 0.4136 | 0.4139 | 0.4136 | 0.4136 | 4143720.0 |
| 2004-02-17 17:00:00 | AAPL | Stock | 0.4138 | 0.4138 | 0.4136 | 0.4136 | 532000.0 |
| 2004-02-17 08:00:00 | MSFT | Stock | 26.77 | 26.79 | 26.68 | 26.76 | 42209.0 |
| 2004-02-17 09:00:00 | MSFT | Stock | 26.75 | 26.77 | 26.66 | 26.75 | 5827880.0 |
| 2004-02-17 10:00:00 | MSFT | Stock | 26.76 | 26.97 | 26.73 | 26.91 | 7158063.0 |
| 2004-02-17 11:00:00 | MSFT | Stock | 26.91 | 26.98 | 26.91 | 26.96 | 4742824.0 |
| 2004-02-17 12:00:00 | MSFT | Stock | 26.955 | 26.98 | 26.909 | 26.96 | 3993511.0 |
| 2004-02-17 13:00:00 | MSFT | Stock | 26.96 | 27.0 | 26.91 | 26.96 | 3969656.0 |
| 2004-02-17 14:00:00 | MSFT | Stock | 26.96 | 27.1 | 26.93 | 27.09 | 6060224.0 |
| 2004-02-17 15:00:00 | MSFT | Stock | 27.085 | 27.09 | 26.97 | 27.0 | 9097718.0 |
| 2004-02-17 16:00:00 | MSFT | Stock | 27.0 | 27.02 | 26.96 | 26.96 | 855500.0 |
| 2004-02-17 17:00:00 | MSFT | Stock | 27.0 | 27.0 | 26.98 | 27.0 | 84880.0 |
| 2004-02-17 18:00:00 | MSFT | Stock | 27.01 | 27.01 | 27.01 | 27.01 | 400.0 |
| 2004-02-17 08:00:00 | NVDA | Stock | 0.1953 | 0.1958 | 0.1942 | 0.1942 | 981000.0 |
| 2004-02-17 09:00:00 | NVDA | Stock | 0.1946 | 0.1962 | 0.194 | 0.1942 | 68724600.0 |
| 2004-02-17 10:00:00 | NVDA | Stock | 0.1942 | 0.195 | 0.1922 | 0.1942 | 108229440.0 |
| 2004-02-17 11:00:00 | NVDA | Stock | 0.1942 | 0.1957 | 0.1938 | 0.1941 | 73715280.0 |
| 2004-02-17 12:00:00 | NVDA | Stock | 0.194 | 0.1952 | 0.194 | 0.1951 | 46557840.0 |
| 2004-02-17 13:00:00 | NVDA | Stock | 0.1951 | 0.1952 | 0.1946 | 0.1949 | 29115960.0 |
| 2004-02-17 14:00:00 | NVDA | Stock | 0.1949 | 0.1961 | 0.1947 | 0.1958 | 58689840.0 |
| 2004-02-17 15:00:00 | NVDA | Stock | 0.1958 | 0.1967 | 0.1956 | 0.1967 | 177044400.0 |
| 2004-02-17 16:00:00 | NVDA | Stock | 0.1967 | 0.1969 | 0.1956 | 0.1963 | 6163680.0 |
| 2004-02-17 17:00:00 | NVDA | Stock | 0.1957 | 0.1968 | 0.1957 | 0.1966 | 993600.0 |
| 2004-02-17 18:00:00 | NVDA | Stock | 0.1959 | 0.1959 | 0.1959 | 0.1959 | 12000.0 |
| 2004-02-17 08:00:00 | AMZN | Stock | 2.324 | 2.3325 | 2.324 | 2.33 | 46000.0 |
| 2004-02-17 09:00:00 | AMZN | Stock | 2.3414 | 2.3414 | 2.272 | 2.2731 | 35676600.0 |
| 2004-02-17 10:00:00 | AMZN | Stock | 2.273 | 2.274 | 2.24 | 2.256 | 57438180.0 |
| 2004-02-17 11:00:00 | AMZN | Stock | 2.256 | 2.2725 | 2.249 | 2.2685 | 19976760.0 |
| 2004-02-17 12:00:00 | AMZN | Stock | 2.2685 | 2.2815 | 2.2625 | 2.272 | 24573900.0 |
| 2004-02-17 13:00:00 | AMZN | Stock | 2.272 | 2.2845 | 2.261 | 2.263 | 15307400.0 |
| 2004-02-17 14:00:00 | AMZN | Stock | 2.2635 | 2.2815 | 2.2555 | 2.281 | 19937080.0 |
| 2004-02-17 15:00:00 | AMZN | Stock | 2.2815 | 2.282 | 2.2685 | 2.2745 | 34699420.0 |
| 2004-02-17 16:00:00 | AMZN | Stock | 2.2765 | 2.28 | 2.2655 | 2.2775 | 6523560.0 |
| 2004-02-17 17:00:00 | AMZN | Stock | 2.2775 | 2.2775 | 2.272 | 2.272 | 119600.0 |
| 2004-02-17 18:00:00 | AMZN | Stock | 2.2814 | 2.2825 | 2.2795 | 2.2825 | 68000.0 |
| 2004-02-17 09:00:00 | CL | Stock | 27.7 | 27.75 | 27.655 | 27.7 | 386800.0 |
| 2004-02-17 10:00:00 | CL | Stock | 27.695 | 27.77 | 27.67 | 27.765 | 548400.0 |
| 2004-02-17 11:00:00 | CL | Stock | 27.765 | 27.79 | 27.63 | 27.655 | 448600.0 |
| 2004-02-17 12:00:00 | CL | Stock | 27.65 | 27.74 | 27.635 | 27.665 | 351600.0 |
| 2004-02-17 13:00:00 | CL | Stock | 27.665 | 27.71 | 27.625 | 27.655 | 271400.0 |
| 2004-02-17 14:00:00 | CL | Stock | 27.66 | 27.79 | 27.625 | 27.725 | 344200.0 |
| 2004-02-17 15:00:00 | CL | Stock | 27.725 | 27.725 | 27.65 | 27.705 | 868400.0 |
> showing 50 of 24,012 rows — these rows as CSV