PREVIEW / stock_1hour / 2001-02-26
file: by_date/stock_1hour/2001/2001-02-26.parquet size: 354 KB rows: 16,510 symbols: 1,269
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 |
|---|---|---|---|---|---|---|---|
| 2001-02-26 08:00:00 | AAPL | Stock | 0.3371 | 0.3393 | 0.3371 | 0.3382 | 263200.0 |
| 2001-02-26 09:00:00 | AAPL | Stock | 0.3393 | 0.3426 | 0.3371 | 0.3382 | 27675200.0 |
| 2001-02-26 10:00:00 | AAPL | Stock | 0.3382 | 0.3393 | 0.3315 | 0.3359 | 33006400.0 |
| 2001-02-26 11:00:00 | AAPL | Stock | 0.3359 | 0.3438 | 0.3343 | 0.3415 | 30021600.0 |
| 2001-02-26 12:00:00 | AAPL | Stock | 0.3426 | 0.346 | 0.3393 | 0.3415 | 17466400.0 |
| 2001-02-26 13:00:00 | AAPL | Stock | 0.3415 | 0.3438 | 0.3371 | 0.3393 | 10763200.0 |
| 2001-02-26 14:00:00 | AAPL | Stock | 0.3393 | 0.3471 | 0.3371 | 0.3471 | 32681600.0 |
| 2001-02-26 15:00:00 | AAPL | Stock | 0.3471 | 0.3516 | 0.3449 | 0.3504 | 37570400.0 |
| 2001-02-26 16:00:00 | AAPL | Stock | 0.3482 | 0.3504 | 0.3404 | 0.3482 | 9032800.0 |
| 2001-02-26 17:00:00 | AAPL | Stock | 0.3438 | 0.3482 | 0.3438 | 0.3482 | 151200.0 |
| 2001-02-26 18:00:00 | AAPL | Stock | 0.3471 | 0.3471 | 0.3471 | 0.3471 | 16800.0 |
| 2001-02-26 07:00:00 | MSFT | Stock | 28.8438 | 28.8438 | 28.8438 | 28.8438 | 200.0 |
| 2001-02-26 08:00:00 | MSFT | Stock | 28.75 | 29.0 | 28.3906 | 28.75 | 436200.0 |
| 2001-02-26 09:00:00 | MSFT | Stock | 28.75 | 29.0 | 28.6875 | 28.9688 | 15329800.0 |
| 2001-02-26 10:00:00 | MSFT | Stock | 28.9688 | 29.3125 | 28.7812 | 28.9688 | 16087800.0 |
| 2001-02-26 11:00:00 | MSFT | Stock | 28.9688 | 29.6875 | 28.9375 | 29.6562 | 12999400.0 |
| 2001-02-26 12:00:00 | MSFT | Stock | 29.6875 | 29.9062 | 29.5312 | 29.8125 | 8299000.0 |
| 2001-02-26 13:00:00 | MSFT | Stock | 29.7812 | 29.875 | 29.5938 | 29.6875 | 6816400.0 |
| 2001-02-26 14:00:00 | MSFT | Stock | 29.7188 | 29.9375 | 29.625 | 29.875 | 8665200.0 |
| 2001-02-26 15:00:00 | MSFT | Stock | 29.9062 | 29.9688 | 29.5625 | 29.7812 | 13717200.0 |
| 2001-02-26 16:00:00 | MSFT | Stock | 29.7812 | 29.8125 | 29.375 | 29.7188 | 2854600.0 |
| 2001-02-26 17:00:00 | MSFT | Stock | 29.7188 | 29.75 | 29.6875 | 29.6875 | 4800.0 |
| 2001-02-26 18:00:00 | MSFT | Stock | 29.6875 | 29.6875 | 29.6875 | 29.6875 | 1800.0 |
| 2001-02-26 08:00:00 | NVDA | Stock | 0.2151 | 0.2266 | 0.2042 | 0.2167 | 12024000.0 |
| 2001-02-26 09:00:00 | NVDA | Stock | 0.2201 | 0.2273 | 0.2167 | 0.2214 | 212832000.0 |
| 2001-02-26 10:00:00 | NVDA | Stock | 0.2214 | 0.2224 | 0.2133 | 0.2156 | 113256000.0 |
| 2001-02-26 11:00:00 | NVDA | Stock | 0.2156 | 0.2208 | 0.2135 | 0.2188 | 72744000.0 |
| 2001-02-26 12:00:00 | NVDA | Stock | 0.2188 | 0.2199 | 0.2172 | 0.218 | 50520000.0 |
| 2001-02-26 13:00:00 | NVDA | Stock | 0.2182 | 0.2188 | 0.2117 | 0.2151 | 67536000.0 |
| 2001-02-26 14:00:00 | NVDA | Stock | 0.2146 | 0.2208 | 0.2125 | 0.2208 | 57168000.0 |
| 2001-02-26 15:00:00 | NVDA | Stock | 0.2208 | 0.2214 | 0.2169 | 0.2208 | 102312000.0 |
| 2001-02-26 16:00:00 | NVDA | Stock | 0.2206 | 0.2214 | 0.219 | 0.2214 | 31176000.0 |
| 2001-02-26 17:00:00 | NVDA | Stock | 0.2198 | 0.2208 | 0.2198 | 0.2208 | 96000.0 |
| 2001-02-26 08:00:00 | AMZN | Stock | 0.5953 | 0.6047 | 0.5953 | 0.6 | 2648000.0 |
| 2001-02-26 09:00:00 | AMZN | Stock | 0.5969 | 0.6094 | 0.5969 | 0.6031 | 9890000.0 |
| 2001-02-26 10:00:00 | AMZN | Stock | 0.6031 | 0.6094 | 0.575 | 0.5844 | 12344000.0 |
| 2001-02-26 11:00:00 | AMZN | Stock | 0.5844 | 0.5969 | 0.5812 | 0.5859 | 13228000.0 |
| 2001-02-26 12:00:00 | AMZN | Stock | 0.5844 | 0.5938 | 0.575 | 0.5906 | 12104000.0 |
| 2001-02-26 13:00:00 | AMZN | Stock | 0.5875 | 0.5906 | 0.5844 | 0.5875 | 6988000.0 |
| 2001-02-26 14:00:00 | AMZN | Stock | 0.5844 | 0.6094 | 0.5844 | 0.6031 | 15746000.0 |
| 2001-02-26 15:00:00 | AMZN | Stock | 0.6 | 0.6125 | 0.5906 | 0.5969 | 36768000.0 |
| 2001-02-26 16:00:00 | AMZN | Stock | 0.5969 | 0.6172 | 0.5938 | 0.6063 | 12156000.0 |
| 2001-02-26 17:00:00 | AMZN | Stock | 0.5969 | 0.6016 | 0.5969 | 0.6016 | 48000.0 |
| 2001-02-26 18:00:00 | AMZN | Stock | 0.6 | 0.6 | 0.6 | 0.6 | 2000.0 |
| 2001-02-26 09:00:00 | CL | Stock | 28.8 | 28.85 | 28.675 | 28.75 | 436200.0 |
| 2001-02-26 10:00:00 | CL | Stock | 28.75 | 29.05 | 28.75 | 28.925 | 334600.0 |
| 2001-02-26 11:00:00 | CL | Stock | 28.925 | 29.05 | 28.875 | 28.95 | 280000.0 |
| 2001-02-26 12:00:00 | CL | Stock | 28.945 | 29.09 | 28.935 | 29.015 | 198200.0 |
| 2001-02-26 13:00:00 | CL | Stock | 29.025 | 29.105 | 29.0 | 29.08 | 342800.0 |
| 2001-02-26 14:00:00 | CL | Stock | 29.08 | 29.25 | 29.06 | 29.1 | 381200.0 |
> showing 50 of 16,510 rows — these rows as CSV