PREVIEW / stock_1hour / 2001-03-02
file: by_date/stock_1hour/2001/2001-03-02.parquet size: 350 KB rows: 16,169 symbols: 1,268
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-03-02 08:00:00 | AAPL | Stock | 0.3304 | 0.3326 | 0.3281 | 0.3326 | 604800.0 |
| 2001-03-02 09:00:00 | AAPL | Stock | 0.3304 | 0.3393 | 0.3259 | 0.3359 | 29999200.0 |
| 2001-03-02 10:00:00 | AAPL | Stock | 0.3348 | 0.346 | 0.3337 | 0.346 | 89493600.0 |
| 2001-03-02 11:00:00 | AAPL | Stock | 0.3449 | 0.3471 | 0.3393 | 0.3415 | 30996000.0 |
| 2001-03-02 12:00:00 | AAPL | Stock | 0.3415 | 0.3538 | 0.3404 | 0.3527 | 56218400.0 |
| 2001-03-02 13:00:00 | AAPL | Stock | 0.3538 | 0.365 | 0.3516 | 0.3627 | 81944800.0 |
| 2001-03-02 14:00:00 | AAPL | Stock | 0.3627 | 0.3638 | 0.3516 | 0.3527 | 47006400.0 |
| 2001-03-02 15:00:00 | AAPL | Stock | 0.3527 | 0.3549 | 0.3426 | 0.3449 | 45001600.0 |
| 2001-03-02 16:00:00 | AAPL | Stock | 0.3438 | 0.3594 | 0.3415 | 0.3449 | 12566400.0 |
| 2001-03-02 17:00:00 | AAPL | Stock | 0.3493 | 0.3493 | 0.3493 | 0.3493 | 280000.0 |
| 2001-03-02 08:00:00 | MSFT | Stock | 28.75 | 29.0625 | 28.5 | 28.625 | 811800.0 |
| 2001-03-02 09:00:00 | MSFT | Stock | 28.6562 | 29.6719 | 28.5625 | 28.6875 | 10021000.0 |
| 2001-03-02 10:00:00 | MSFT | Stock | 28.6562 | 28.875 | 28.5625 | 28.6406 | 12874400.0 |
| 2001-03-02 11:00:00 | MSFT | Stock | 28.6562 | 28.8438 | 28.5 | 28.6875 | 6739200.0 |
| 2001-03-02 12:00:00 | MSFT | Stock | 28.6875 | 28.9375 | 28.625 | 28.6875 | 8715800.0 |
| 2001-03-02 13:00:00 | MSFT | Stock | 28.6875 | 29.0625 | 28.5625 | 28.7812 | 11246600.0 |
| 2001-03-02 14:00:00 | MSFT | Stock | 28.7812 | 28.8125 | 28.5 | 28.5938 | 7937400.0 |
| 2001-03-02 15:00:00 | MSFT | Stock | 28.5938 | 28.7812 | 28.2188 | 28.3438 | 17089800.0 |
| 2001-03-02 16:00:00 | MSFT | Stock | 28.3125 | 28.9375 | 28.2812 | 28.3438 | 1801800.0 |
| 2001-03-02 17:00:00 | MSFT | Stock | 28.3438 | 28.375 | 28.3438 | 28.375 | 2400.0 |
| 2001-03-02 18:00:00 | MSFT | Stock | 28.3438 | 28.4375 | 28.25 | 28.4375 | 4400.0 |
| 2001-03-02 08:00:00 | NVDA | Stock | 0.1906 | 0.1906 | 0.1906 | 0.1906 | 24000.0 |
| 2001-03-02 09:00:00 | NVDA | Stock | 0.1896 | 0.1932 | 0.1846 | 0.1896 | 129432000.0 |
| 2001-03-02 10:00:00 | NVDA | Stock | 0.1898 | 0.1914 | 0.1867 | 0.1885 | 138864000.0 |
| 2001-03-02 11:00:00 | NVDA | Stock | 0.1885 | 0.1889 | 0.1815 | 0.1875 | 114744000.0 |
| 2001-03-02 12:00:00 | NVDA | Stock | 0.1874 | 0.1938 | 0.1854 | 0.1889 | 140064000.0 |
| 2001-03-02 13:00:00 | NVDA | Stock | 0.1889 | 0.1997 | 0.188 | 0.1917 | 193512000.0 |
| 2001-03-02 14:00:00 | NVDA | Stock | 0.1917 | 0.1958 | 0.188 | 0.1935 | 376392000.0 |
| 2001-03-02 15:00:00 | NVDA | Stock | 0.1936 | 0.1938 | 0.1792 | 0.1815 | 203328000.0 |
| 2001-03-02 16:00:00 | NVDA | Stock | 0.1799 | 0.1833 | 0.1792 | 0.1815 | 79392000.0 |
| 2001-03-02 08:00:00 | AMZN | Stock | 0.5125 | 0.5234 | 0.45 | 0.5188 | 242000.0 |
| 2001-03-02 09:00:00 | AMZN | Stock | 0.5031 | 0.5203 | 0.4938 | 0.5125 | 18996000.0 |
| 2001-03-02 10:00:00 | AMZN | Stock | 0.5094 | 0.5172 | 0.5094 | 0.5125 | 32660000.0 |
| 2001-03-02 11:00:00 | AMZN | Stock | 0.5125 | 0.5188 | 0.5094 | 0.5156 | 17874000.0 |
| 2001-03-02 12:00:00 | AMZN | Stock | 0.5188 | 0.5312 | 0.5156 | 0.5219 | 14466000.0 |
| 2001-03-02 13:00:00 | AMZN | Stock | 0.5219 | 0.525 | 0.5188 | 0.5188 | 20316000.0 |
| 2001-03-02 14:00:00 | AMZN | Stock | 0.5203 | 0.525 | 0.5125 | 0.5188 | 13638000.0 |
| 2001-03-02 15:00:00 | AMZN | Stock | 0.5203 | 0.5219 | 0.5 | 0.5031 | 26478000.0 |
| 2001-03-02 16:00:00 | AMZN | Stock | 0.5 | 0.5094 | 0.5 | 0.5062 | 1512000.0 |
| 2001-03-02 17:00:00 | AMZN | Stock | 0.5062 | 0.5094 | 0.5 | 0.5 | 94000.0 |
| 2001-03-02 09:00:00 | CL | Stock | 28.7 | 28.975 | 28.7 | 28.825 | 292000.0 |
| 2001-03-02 10:00:00 | CL | Stock | 28.825 | 29.065 | 28.795 | 28.9 | 389400.0 |
| 2001-03-02 11:00:00 | CL | Stock | 28.895 | 28.96 | 28.85 | 28.875 | 157400.0 |
| 2001-03-02 12:00:00 | CL | Stock | 28.88 | 29.15 | 28.86 | 29.06 | 168000.0 |
| 2001-03-02 13:00:00 | CL | Stock | 29.05 | 29.145 | 29.005 | 29.1 | 242000.0 |
| 2001-03-02 14:00:00 | CL | Stock | 29.125 | 29.245 | 29.095 | 29.18 | 262600.0 |
| 2001-03-02 15:00:00 | CL | Stock | 29.18 | 29.26 | 28.915 | 29.05 | 1441000.0 |
| 2001-03-02 16:00:00 | CL | Stock | 29.06 | 29.065 | 29.06 | 29.065 | 70800.0 |
> showing 48 of 16,169 rows — these rows as CSV