PREVIEW / stock_1hour / 2001-02-12
file: by_date/stock_1hour/2001/2001-02-12.parquet size: 356 KB rows: 16,654 symbols: 1,263
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-12 08:00:00 | AAPL | Stock | 0.3443 | 0.3471 | 0.3415 | 0.3415 | 386400.0 |
| 2001-02-12 09:00:00 | AAPL | Stock | 0.3404 | 0.3482 | 0.3382 | 0.3393 | 49268800.0 |
| 2001-02-12 10:00:00 | AAPL | Stock | 0.3393 | 0.346 | 0.3359 | 0.346 | 54521600.0 |
| 2001-02-12 11:00:00 | AAPL | Stock | 0.346 | 0.3471 | 0.3404 | 0.3432 | 34787200.0 |
| 2001-02-12 12:00:00 | AAPL | Stock | 0.3438 | 0.3449 | 0.3393 | 0.3415 | 12135200.0 |
| 2001-02-12 13:00:00 | AAPL | Stock | 0.3404 | 0.3438 | 0.3371 | 0.3415 | 18625600.0 |
| 2001-02-12 14:00:00 | AAPL | Stock | 0.3415 | 0.356 | 0.3415 | 0.3538 | 50439200.0 |
| 2001-02-12 15:00:00 | AAPL | Stock | 0.3549 | 0.3571 | 0.3493 | 0.3516 | 40364800.0 |
| 2001-02-12 16:00:00 | AAPL | Stock | 0.3516 | 0.3527 | 0.3465 | 0.3516 | 8344000.0 |
| 2001-02-12 17:00:00 | AAPL | Stock | 0.3482 | 0.3493 | 0.3482 | 0.3493 | 28000.0 |
| 2001-02-12 18:00:00 | AAPL | Stock | 0.3482 | 0.3527 | 0.3482 | 0.3527 | 128800.0 |
| 2001-02-12 08:00:00 | MSFT | Stock | 29.5312 | 30.0 | 29.4375 | 29.4375 | 63400.0 |
| 2001-02-12 09:00:00 | MSFT | Stock | 29.4375 | 29.5625 | 28.5938 | 28.6719 | 11329400.0 |
| 2001-02-12 10:00:00 | MSFT | Stock | 28.6875 | 29.625 | 28.625 | 29.5312 | 17068600.0 |
| 2001-02-12 11:00:00 | MSFT | Stock | 29.5312 | 29.7188 | 28.9375 | 29.1875 | 7055200.0 |
| 2001-02-12 12:00:00 | MSFT | Stock | 29.1562 | 29.3125 | 28.8125 | 28.8125 | 5452000.0 |
| 2001-02-12 13:00:00 | MSFT | Stock | 28.7969 | 29.0312 | 28.625 | 28.6562 | 6071200.0 |
| 2001-02-12 14:00:00 | MSFT | Stock | 28.6562 | 28.9688 | 28.625 | 28.9688 | 8703200.0 |
| 2001-02-12 15:00:00 | MSFT | Stock | 28.9688 | 29.5625 | 28.9062 | 29.3906 | 11965400.0 |
| 2001-02-12 16:00:00 | MSFT | Stock | 29.4062 | 29.5625 | 29.0312 | 29.3438 | 1905400.0 |
| 2001-02-12 17:00:00 | MSFT | Stock | 29.375 | 29.5 | 29.375 | 29.4375 | 11800.0 |
| 2001-02-12 08:00:00 | NVDA | Stock | 0.1848 | 0.1848 | 0.1848 | 0.1848 | 720000.0 |
| 2001-02-12 09:00:00 | NVDA | Stock | 0.1823 | 0.1826 | 0.1708 | 0.1721 | 40920000.0 |
| 2001-02-12 10:00:00 | NVDA | Stock | 0.1711 | 0.1846 | 0.1711 | 0.182 | 81336000.0 |
| 2001-02-12 11:00:00 | NVDA | Stock | 0.182 | 0.1839 | 0.1755 | 0.1771 | 28392000.0 |
| 2001-02-12 12:00:00 | NVDA | Stock | 0.1779 | 0.1779 | 0.1711 | 0.1724 | 24288000.0 |
| 2001-02-12 13:00:00 | NVDA | Stock | 0.1727 | 0.1755 | 0.1708 | 0.174 | 38544000.0 |
| 2001-02-12 14:00:00 | NVDA | Stock | 0.174 | 0.1776 | 0.1719 | 0.1772 | 37992000.0 |
| 2001-02-12 15:00:00 | NVDA | Stock | 0.1772 | 0.1823 | 0.1763 | 0.1797 | 80256000.0 |
| 2001-02-12 16:00:00 | NVDA | Stock | 0.1813 | 0.1813 | 0.1763 | 0.1771 | 3528000.0 |
| 2001-02-12 08:00:00 | AMZN | Stock | 0.675 | 0.7188 | 0.675 | 0.6812 | 544000.0 |
| 2001-02-12 09:00:00 | AMZN | Stock | 0.6844 | 0.7188 | 0.6844 | 0.7062 | 17160000.0 |
| 2001-02-12 10:00:00 | AMZN | Stock | 0.7 | 0.75 | 0.7 | 0.7313 | 33090000.0 |
| 2001-02-12 11:00:00 | AMZN | Stock | 0.7375 | 0.7406 | 0.7219 | 0.7281 | 12106000.0 |
| 2001-02-12 12:00:00 | AMZN | Stock | 0.7281 | 0.7281 | 0.7062 | 0.7062 | 8752000.0 |
| 2001-02-12 13:00:00 | AMZN | Stock | 0.7062 | 0.7219 | 0.6938 | 0.7125 | 7592000.0 |
| 2001-02-12 14:00:00 | AMZN | Stock | 0.7156 | 0.7375 | 0.7 | 0.7344 | 11864000.0 |
| 2001-02-12 15:00:00 | AMZN | Stock | 0.7344 | 0.7375 | 0.7156 | 0.7281 | 10516000.0 |
| 2001-02-12 16:00:00 | AMZN | Stock | 0.725 | 0.7344 | 0.7234 | 0.725 | 1366000.0 |
| 2001-02-12 17:00:00 | AMZN | Stock | 0.725 | 0.7313 | 0.725 | 0.7313 | 296000.0 |
| 2001-02-12 09:00:00 | CL | Stock | 29.69 | 29.79 | 29.535 | 29.79 | 241400.0 |
| 2001-02-12 10:00:00 | CL | Stock | 29.775 | 29.805 | 29.125 | 29.225 | 520200.0 |
| 2001-02-12 11:00:00 | CL | Stock | 29.21 | 29.24 | 28.935 | 28.995 | 370000.0 |
| 2001-02-12 12:00:00 | CL | Stock | 28.99 | 29.075 | 28.75 | 28.95 | 416800.0 |
| 2001-02-12 13:00:00 | CL | Stock | 28.95 | 29.16 | 28.9 | 29.125 | 362000.0 |
| 2001-02-12 14:00:00 | CL | Stock | 29.125 | 29.225 | 29.025 | 29.2 | 325600.0 |
| 2001-02-12 15:00:00 | CL | Stock | 29.205 | 29.575 | 29.205 | 29.41 | 745200.0 |
| 2001-02-12 16:00:00 | CL | Stock | 29.41 | 29.625 | 29.25 | 29.25 | 75600.0 |
| 2001-02-12 17:00:00 | CL | Stock | 29.25 | 29.25 | 29.25 | 29.25 | 100000.0 |
> showing 49 of 16,654 rows — these rows as CSV