PREVIEW / stock_1hour / 2001-01-26
file: by_date/stock_1hour/2001/2001-01-26.parquet size: 309 KB rows: 16,226 symbols: 1,267
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-01-26 08:00:00 | AAPL | Stock | 0.3493 | 0.3493 | 0.3404 | 0.3415 | 604800.0 |
| 2001-01-26 09:00:00 | AAPL | Stock | 0.3482 | 0.356 | 0.3415 | 0.3471 | 41552000.0 |
| 2001-01-26 10:00:00 | AAPL | Stock | 0.346 | 0.3493 | 0.3415 | 0.3415 | 65318400.0 |
| 2001-01-26 11:00:00 | AAPL | Stock | 0.3415 | 0.346 | 0.3404 | 0.3449 | 56179200.0 |
| 2001-01-26 12:00:00 | AAPL | Stock | 0.3449 | 0.3493 | 0.3438 | 0.3477 | 87052000.0 |
| 2001-01-26 13:00:00 | AAPL | Stock | 0.3482 | 0.3504 | 0.3471 | 0.3493 | 121525600.0 |
| 2001-01-26 14:00:00 | AAPL | Stock | 0.3493 | 0.3538 | 0.3471 | 0.3516 | 37016000.0 |
| 2001-01-26 15:00:00 | AAPL | Stock | 0.3516 | 0.3538 | 0.3471 | 0.3493 | 34244000.0 |
| 2001-01-26 16:00:00 | AAPL | Stock | 0.3482 | 0.3516 | 0.346 | 0.3477 | 5863200.0 |
| 2001-01-26 18:00:00 | AAPL | Stock | 0.3527 | 0.3527 | 0.3516 | 0.3516 | 50400.0 |
| 2001-01-26 08:00:00 | MSFT | Stock | 30.2812 | 30.5 | 30.0 | 30.4375 | 296600.0 |
| 2001-01-26 09:00:00 | MSFT | Stock | 30.4688 | 31.375 | 30.25 | 31.25 | 10730400.0 |
| 2001-01-26 10:00:00 | MSFT | Stock | 31.25 | 31.4375 | 31.125 | 31.2812 | 11125200.0 |
| 2001-01-26 11:00:00 | MSFT | Stock | 31.2812 | 31.4688 | 31.1875 | 31.4219 | 9676600.0 |
| 2001-01-26 12:00:00 | MSFT | Stock | 31.4219 | 31.75 | 31.4062 | 31.6562 | 10378000.0 |
| 2001-01-26 13:00:00 | MSFT | Stock | 31.625 | 32.1562 | 31.625 | 31.8438 | 16057600.0 |
| 2001-01-26 14:00:00 | MSFT | Stock | 31.8438 | 32.0938 | 31.7812 | 32.0312 | 11529000.0 |
| 2001-01-26 15:00:00 | MSFT | Stock | 32.0 | 32.1562 | 31.8906 | 31.9844 | 14173400.0 |
| 2001-01-26 16:00:00 | MSFT | Stock | 32.0 | 32.0625 | 31.3906 | 31.5781 | 1721800.0 |
| 2001-01-26 17:00:00 | MSFT | Stock | 32.0 | 32.0625 | 31.9688 | 32.0625 | 1800.0 |
| 2001-01-26 18:00:00 | MSFT | Stock | 31.9375 | 31.9375 | 31.9375 | 31.9375 | 200.0 |
| 2001-01-26 08:00:00 | NVDA | Stock | 0.2048 | 0.2052 | 0.201 | 0.2016 | 1656000.0 |
| 2001-01-26 09:00:00 | NVDA | Stock | 0.2021 | 0.2026 | 0.1923 | 0.2013 | 41496000.0 |
| 2001-01-26 10:00:00 | NVDA | Stock | 0.2018 | 0.2047 | 0.1992 | 0.2033 | 40512000.0 |
| 2001-01-26 11:00:00 | NVDA | Stock | 0.2031 | 0.2042 | 0.1961 | 0.1969 | 19392000.0 |
| 2001-01-26 12:00:00 | NVDA | Stock | 0.1974 | 0.2068 | 0.1974 | 0.2057 | 28152000.0 |
| 2001-01-26 13:00:00 | NVDA | Stock | 0.206 | 0.2113 | 0.2057 | 0.2107 | 36744000.0 |
| 2001-01-26 14:00:00 | NVDA | Stock | 0.2107 | 0.2142 | 0.2083 | 0.2122 | 26112000.0 |
| 2001-01-26 15:00:00 | NVDA | Stock | 0.2117 | 0.2135 | 0.2068 | 0.2117 | 22704000.0 |
| 2001-01-26 16:00:00 | NVDA | Stock | 0.2115 | 0.2117 | 0.2102 | 0.2117 | 1632000.0 |
| 2001-01-26 08:00:00 | AMZN | Stock | 0.95 | 0.95 | 0.9344 | 0.9438 | 176000.0 |
| 2001-01-26 09:00:00 | AMZN | Stock | 0.9406 | 1.0125 | 0.9375 | 0.975 | 20084000.0 |
| 2001-01-26 10:00:00 | AMZN | Stock | 0.9719 | 0.9875 | 0.9562 | 0.9656 | 13476000.0 |
| 2001-01-26 11:00:00 | AMZN | Stock | 0.9688 | 0.975 | 0.95 | 0.9562 | 9090000.0 |
| 2001-01-26 12:00:00 | AMZN | Stock | 0.9562 | 0.9844 | 0.9531 | 0.9844 | 7722000.0 |
| 2001-01-26 13:00:00 | AMZN | Stock | 0.9812 | 1.0031 | 0.9781 | 0.9938 | 20168000.0 |
| 2001-01-26 14:00:00 | AMZN | Stock | 0.9938 | 1.0 | 0.9812 | 0.9906 | 8488000.0 |
| 2001-01-26 15:00:00 | AMZN | Stock | 0.9906 | 0.9969 | 0.975 | 0.9781 | 10624000.0 |
| 2001-01-26 16:00:00 | AMZN | Stock | 0.9781 | 0.9938 | 0.9734 | 0.975 | 1188000.0 |
| 2001-01-26 17:00:00 | AMZN | Stock | 0.9969 | 0.9969 | 0.9812 | 0.9875 | 58000.0 |
| 2001-01-26 09:00:00 | CL | Stock | 29.275 | 29.56 | 29.14 | 29.41 | 444400.0 |
| 2001-01-26 10:00:00 | CL | Stock | 29.425 | 29.45 | 28.75 | 28.86 | 530000.0 |
| 2001-01-26 11:00:00 | CL | Stock | 28.86 | 28.95 | 28.595 | 28.69 | 285000.0 |
| 2001-01-26 12:00:00 | CL | Stock | 28.675 | 28.71 | 28.5 | 28.675 | 290200.0 |
| 2001-01-26 13:00:00 | CL | Stock | 28.695 | 28.865 | 28.48 | 28.505 | 407400.0 |
| 2001-01-26 14:00:00 | CL | Stock | 28.505 | 28.63 | 28.45 | 28.525 | 409800.0 |
| 2001-01-26 15:00:00 | CL | Stock | 28.525 | 28.8 | 28.49 | 28.51 | 492000.0 |
| 2001-01-26 16:00:00 | CL | Stock | 28.505 | 28.505 | 28.505 | 28.505 | 23400.0 |
> showing 48 of 16,226 rows — these rows as CSV