PREVIEW / stock_1hour / 2001-02-13
file: by_date/stock_1hour/2001/2001-02-13.parquet size: 358 KB rows: 16,561 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-13 09:00:00 | AAPL | Stock | 0.3516 | 0.3627 | 0.3504 | 0.3605 | 29002400.0 |
| 2001-02-13 10:00:00 | AAPL | Stock | 0.3605 | 0.365 | 0.356 | 0.3571 | 31612000.0 |
| 2001-02-13 11:00:00 | AAPL | Stock | 0.3571 | 0.3605 | 0.356 | 0.356 | 17343200.0 |
| 2001-02-13 12:00:00 | AAPL | Stock | 0.3571 | 0.3583 | 0.3538 | 0.3549 | 27356000.0 |
| 2001-02-13 13:00:00 | AAPL | Stock | 0.3549 | 0.356 | 0.3493 | 0.3504 | 34932800.0 |
| 2001-02-13 14:00:00 | AAPL | Stock | 0.3504 | 0.3549 | 0.3482 | 0.3516 | 31410400.0 |
| 2001-02-13 15:00:00 | AAPL | Stock | 0.3504 | 0.3527 | 0.3393 | 0.341 | 49828800.0 |
| 2001-02-13 16:00:00 | AAPL | Stock | 0.3404 | 0.3482 | 0.3393 | 0.3449 | 5773600.0 |
| 2001-02-13 17:00:00 | AAPL | Stock | 0.3415 | 0.3415 | 0.3415 | 0.3415 | 44800.0 |
| 2001-02-13 08:00:00 | MSFT | Stock | 29.5 | 29.8125 | 29.5 | 29.8125 | 63800.0 |
| 2001-02-13 09:00:00 | MSFT | Stock | 29.9375 | 30.375 | 29.7812 | 30.3125 | 10587000.0 |
| 2001-02-13 10:00:00 | MSFT | Stock | 30.3125 | 30.5312 | 30.0938 | 30.3125 | 16469000.0 |
| 2001-02-13 11:00:00 | MSFT | Stock | 30.3125 | 30.4375 | 30.2188 | 30.3125 | 5002600.0 |
| 2001-02-13 12:00:00 | MSFT | Stock | 30.3125 | 30.5 | 30.25 | 30.4688 | 5171600.0 |
| 2001-02-13 13:00:00 | MSFT | Stock | 30.4844 | 30.5 | 29.9062 | 29.9375 | 7038200.0 |
| 2001-02-13 14:00:00 | MSFT | Stock | 29.9062 | 30.0625 | 29.5 | 29.6875 | 15170000.0 |
| 2001-02-13 15:00:00 | MSFT | Stock | 29.6562 | 29.7188 | 29.0625 | 29.0938 | 11987600.0 |
| 2001-02-13 16:00:00 | MSFT | Stock | 29.0938 | 30.2188 | 29.0312 | 29.3906 | 1904000.0 |
| 2001-02-13 17:00:00 | MSFT | Stock | 29.0938 | 30.125 | 29.0938 | 29.125 | 58000.0 |
| 2001-02-13 18:00:00 | MSFT | Stock | 29.125 | 29.8125 | 29.125 | 29.1875 | 5600.0 |
| 2001-02-13 08:00:00 | NVDA | Stock | 0.1818 | 0.1818 | 0.1818 | 0.1818 | 168000.0 |
| 2001-02-13 09:00:00 | NVDA | Stock | 0.1818 | 0.1932 | 0.1792 | 0.1932 | 73056000.0 |
| 2001-02-13 10:00:00 | NVDA | Stock | 0.193 | 0.1938 | 0.1859 | 0.1859 | 76344000.0 |
| 2001-02-13 11:00:00 | NVDA | Stock | 0.1862 | 0.1909 | 0.1849 | 0.1878 | 41736000.0 |
| 2001-02-13 12:00:00 | NVDA | Stock | 0.1875 | 0.1891 | 0.1862 | 0.1885 | 9144000.0 |
| 2001-02-13 13:00:00 | NVDA | Stock | 0.1885 | 0.1885 | 0.1865 | 0.1878 | 29880000.0 |
| 2001-02-13 14:00:00 | NVDA | Stock | 0.1878 | 0.1914 | 0.1872 | 0.1896 | 63552000.0 |
| 2001-02-13 15:00:00 | NVDA | Stock | 0.1896 | 0.1906 | 0.1833 | 0.1852 | 136080000.0 |
| 2001-02-13 16:00:00 | NVDA | Stock | 0.1852 | 0.1885 | 0.1818 | 0.1885 | 21768000.0 |
| 2001-02-13 17:00:00 | NVDA | Stock | 0.1896 | 0.1896 | 0.1854 | 0.1854 | 456000.0 |
| 2001-02-13 09:00:00 | AMZN | Stock | 0.7438 | 0.7563 | 0.7219 | 0.7313 | 13366000.0 |
| 2001-02-13 10:00:00 | AMZN | Stock | 0.7313 | 0.75 | 0.7313 | 0.7438 | 16860000.0 |
| 2001-02-13 11:00:00 | AMZN | Stock | 0.7438 | 0.75 | 0.7313 | 0.7313 | 11498000.0 |
| 2001-02-13 12:00:00 | AMZN | Stock | 0.7344 | 0.7344 | 0.7281 | 0.7313 | 8056000.0 |
| 2001-02-13 13:00:00 | AMZN | Stock | 0.7344 | 0.7344 | 0.7094 | 0.7156 | 9210000.0 |
| 2001-02-13 14:00:00 | AMZN | Stock | 0.7188 | 0.7313 | 0.7062 | 0.7109 | 8298000.0 |
| 2001-02-13 15:00:00 | AMZN | Stock | 0.7109 | 0.7125 | 0.6875 | 0.6875 | 16270000.0 |
| 2001-02-13 16:00:00 | AMZN | Stock | 0.6875 | 0.7 | 0.6875 | 0.6875 | 6190000.0 |
| 2001-02-13 17:00:00 | AMZN | Stock | 0.7 | 0.7 | 0.6938 | 0.7 | 38000.0 |
| 2001-02-13 18:00:00 | AMZN | Stock | 0.7 | 0.7 | 0.7 | 0.7 | 6000.0 |
| 2001-02-13 09:00:00 | CL | Stock | 29.41 | 29.415 | 29.125 | 29.15 | 429800.0 |
| 2001-02-13 10:00:00 | CL | Stock | 29.15 | 29.15 | 28.905 | 28.925 | 741600.0 |
| 2001-02-13 11:00:00 | CL | Stock | 28.925 | 28.925 | 28.87 | 28.92 | 337000.0 |
| 2001-02-13 12:00:00 | CL | Stock | 28.905 | 28.975 | 28.875 | 28.915 | 323200.0 |
| 2001-02-13 13:00:00 | CL | Stock | 28.875 | 28.95 | 28.8 | 28.92 | 312200.0 |
| 2001-02-13 14:00:00 | CL | Stock | 28.92 | 29.135 | 28.91 | 28.975 | 499200.0 |
| 2001-02-13 15:00:00 | CL | Stock | 28.975 | 29.075 | 28.925 | 29.0 | 1036200.0 |
| 2001-02-13 16:00:00 | CL | Stock | 29.0 | 29.0 | 28.995 | 29.0 | 154800.0 |
| 2001-02-13 17:00:00 | CL | Stock | 29.0 | 29.0 | 29.0 | 29.0 | 6000.0 |
> showing 49 of 16,561 rows — these rows as CSV