PREVIEW / stock_1hour / 2001-02-14
file: by_date/stock_1hour/2001/2001-02-14.parquet size: 359 KB rows: 16,576 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-02-14 08:00:00 | AAPL | Stock | 0.3382 | 0.3438 | 0.3371 | 0.3438 | 1657600.0 |
| 2001-02-14 09:00:00 | AAPL | Stock | 0.3438 | 0.3438 | 0.3393 | 0.3404 | 17236800.0 |
| 2001-02-14 10:00:00 | AAPL | Stock | 0.3415 | 0.3415 | 0.3304 | 0.3382 | 54409600.0 |
| 2001-02-14 11:00:00 | AAPL | Stock | 0.3371 | 0.3415 | 0.3337 | 0.3404 | 62776000.0 |
| 2001-02-14 12:00:00 | AAPL | Stock | 0.3404 | 0.3438 | 0.3371 | 0.3382 | 27664000.0 |
| 2001-02-14 13:00:00 | AAPL | Stock | 0.3382 | 0.3438 | 0.3337 | 0.3415 | 24600800.0 |
| 2001-02-14 14:00:00 | AAPL | Stock | 0.3415 | 0.3504 | 0.3404 | 0.3449 | 49168000.0 |
| 2001-02-14 15:00:00 | AAPL | Stock | 0.346 | 0.3504 | 0.3426 | 0.3493 | 46552800.0 |
| 2001-02-14 16:00:00 | AAPL | Stock | 0.3493 | 0.3516 | 0.3371 | 0.3516 | 12292000.0 |
| 2001-02-14 17:00:00 | AAPL | Stock | 0.3482 | 0.3482 | 0.3482 | 0.3482 | 800800.0 |
| 2001-02-14 08:00:00 | MSFT | Stock | 28.8594 | 29.1094 | 28.5 | 29.0 | 218200.0 |
| 2001-02-14 09:00:00 | MSFT | Stock | 29.0 | 29.0 | 28.375 | 28.875 | 8847400.0 |
| 2001-02-14 10:00:00 | MSFT | Stock | 28.875 | 28.9375 | 28.4062 | 28.625 | 10667600.0 |
| 2001-02-14 11:00:00 | MSFT | Stock | 28.6562 | 29.25 | 28.1875 | 29.1562 | 8558000.0 |
| 2001-02-14 12:00:00 | MSFT | Stock | 29.1875 | 29.1875 | 28.6562 | 28.6562 | 3607400.0 |
| 2001-02-14 13:00:00 | MSFT | Stock | 28.6562 | 28.875 | 28.4375 | 28.8438 | 6522200.0 |
| 2001-02-14 14:00:00 | MSFT | Stock | 28.875 | 29.2812 | 28.7812 | 29.0 | 7354200.0 |
| 2001-02-14 15:00:00 | MSFT | Stock | 29.0 | 29.5 | 28.8438 | 29.2188 | 10574400.0 |
| 2001-02-14 16:00:00 | MSFT | Stock | 29.2188 | 29.4531 | 28.875 | 29.375 | 3189400.0 |
| 2001-02-14 17:00:00 | MSFT | Stock | 29.1875 | 29.4062 | 29.1875 | 29.3438 | 298200.0 |
| 2001-02-14 18:00:00 | MSFT | Stock | 29.3125 | 29.3125 | 29.3125 | 29.3125 | 400.0 |
| 2001-02-14 09:00:00 | NVDA | Stock | 0.1857 | 0.1857 | 0.1768 | 0.1802 | 93720000.0 |
| 2001-02-14 10:00:00 | NVDA | Stock | 0.1799 | 0.1802 | 0.175 | 0.1766 | 79224000.0 |
| 2001-02-14 11:00:00 | NVDA | Stock | 0.1766 | 0.1833 | 0.1763 | 0.1805 | 69744000.0 |
| 2001-02-14 12:00:00 | NVDA | Stock | 0.181 | 0.1831 | 0.1792 | 0.1802 | 123360000.0 |
| 2001-02-14 13:00:00 | NVDA | Stock | 0.1802 | 0.1826 | 0.1792 | 0.182 | 29376000.0 |
| 2001-02-14 14:00:00 | NVDA | Stock | 0.1823 | 0.1948 | 0.1813 | 0.1927 | 105240000.0 |
| 2001-02-14 15:00:00 | NVDA | Stock | 0.1927 | 0.2034 | 0.1911 | 0.1984 | 119664000.0 |
| 2001-02-14 16:00:00 | NVDA | Stock | 0.1987 | 0.2117 | 0.1975 | 0.2083 | 26256000.0 |
| 2001-02-14 17:00:00 | NVDA | Stock | 0.2092 | 0.2125 | 0.2042 | 0.2115 | 5808000.0 |
| 2001-02-14 18:00:00 | NVDA | Stock | 0.2121 | 0.2135 | 0.2121 | 0.213 | 1104000.0 |
| 2001-02-14 08:00:00 | AMZN | Stock | 0.6969 | 0.7 | 0.6969 | 0.7 | 24000.0 |
| 2001-02-14 09:00:00 | AMZN | Stock | 0.7 | 0.7125 | 0.6938 | 0.7 | 11024000.0 |
| 2001-02-14 10:00:00 | AMZN | Stock | 0.7 | 0.7 | 0.6781 | 0.6906 | 12358000.0 |
| 2001-02-14 11:00:00 | AMZN | Stock | 0.6906 | 0.7031 | 0.675 | 0.6938 | 16538000.0 |
| 2001-02-14 12:00:00 | AMZN | Stock | 0.6938 | 0.6969 | 0.675 | 0.6781 | 8952000.0 |
| 2001-02-14 13:00:00 | AMZN | Stock | 0.6781 | 0.6938 | 0.675 | 0.6906 | 10648000.0 |
| 2001-02-14 14:00:00 | AMZN | Stock | 0.6938 | 0.7375 | 0.6875 | 0.7125 | 42172000.0 |
| 2001-02-14 15:00:00 | AMZN | Stock | 0.7125 | 0.7313 | 0.7062 | 0.725 | 51020000.0 |
| 2001-02-14 16:00:00 | AMZN | Stock | 0.725 | 0.7313 | 0.7203 | 0.7219 | 5274000.0 |
| 2001-02-14 17:00:00 | AMZN | Stock | 0.7313 | 0.7375 | 0.7219 | 0.725 | 40000.0 |
| 2001-02-14 18:00:00 | AMZN | Stock | 0.7313 | 0.7313 | 0.7313 | 0.7313 | 4000.0 |
| 2001-02-14 09:00:00 | CL | Stock | 29.0 | 29.0 | 28.28 | 28.29 | 426200.0 |
| 2001-02-14 10:00:00 | CL | Stock | 28.275 | 28.51 | 28.195 | 28.495 | 613400.0 |
| 2001-02-14 11:00:00 | CL | Stock | 28.495 | 28.51 | 28.215 | 28.31 | 409200.0 |
| 2001-02-14 12:00:00 | CL | Stock | 28.31 | 28.5 | 28.255 | 28.49 | 406800.0 |
| 2001-02-14 13:00:00 | CL | Stock | 28.485 | 28.485 | 28.27 | 28.295 | 613600.0 |
| 2001-02-14 14:00:00 | CL | Stock | 28.31 | 28.325 | 28.15 | 28.24 | 626000.0 |
| 2001-02-14 15:00:00 | CL | Stock | 28.275 | 28.305 | 28.2 | 28.25 | 887400.0 |
| 2001-02-14 16:00:00 | CL | Stock | 28.25 | 28.255 | 28.2 | 28.2 | 164400.0 |
> showing 50 of 16,576 rows — these rows as CSV