PREVIEW / stock_1hour / 2001-02-06
file: by_date/stock_1hour/2001/2001-02-06.parquet size: 348 KB rows: 16,272 symbols: 1,261
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-06 08:00:00 | AAPL | Stock | 0.3616 | 0.3616 | 0.3616 | 0.3616 | 78400.0 |
| 2001-02-06 09:00:00 | AAPL | Stock | 0.3616 | 0.3694 | 0.3571 | 0.3683 | 30464000.0 |
| 2001-02-06 10:00:00 | AAPL | Stock | 0.3683 | 0.3772 | 0.3661 | 0.3739 | 85573600.0 |
| 2001-02-06 11:00:00 | AAPL | Stock | 0.3739 | 0.3795 | 0.3728 | 0.3783 | 50114400.0 |
| 2001-02-06 12:00:00 | AAPL | Stock | 0.3772 | 0.3828 | 0.3756 | 0.3806 | 37077600.0 |
| 2001-02-06 13:00:00 | AAPL | Stock | 0.3806 | 0.3806 | 0.3739 | 0.3761 | 40952800.0 |
| 2001-02-06 14:00:00 | AAPL | Stock | 0.375 | 0.3795 | 0.3717 | 0.3761 | 89969600.0 |
| 2001-02-06 15:00:00 | AAPL | Stock | 0.3761 | 0.3783 | 0.3705 | 0.3772 | 110801600.0 |
| 2001-02-06 16:00:00 | AAPL | Stock | 0.3761 | 0.3795 | 0.3683 | 0.3705 | 15321600.0 |
| 2001-02-06 17:00:00 | AAPL | Stock | 0.3705 | 0.3806 | 0.3705 | 0.3806 | 117600.0 |
| 2001-02-06 18:00:00 | AAPL | Stock | 0.3795 | 0.3862 | 0.375 | 0.3862 | 128800.0 |
| 2001-02-06 08:00:00 | MSFT | Stock | 31.25 | 31.3438 | 30.875 | 31.0 | 249400.0 |
| 2001-02-06 09:00:00 | MSFT | Stock | 31.0312 | 31.5 | 30.8438 | 31.4844 | 9183400.0 |
| 2001-02-06 10:00:00 | MSFT | Stock | 31.4688 | 31.9062 | 31.2812 | 31.7812 | 13902600.0 |
| 2001-02-06 11:00:00 | MSFT | Stock | 31.7812 | 31.9062 | 31.2188 | 31.4688 | 20529600.0 |
| 2001-02-06 12:00:00 | MSFT | Stock | 31.5 | 31.5938 | 31.375 | 31.4062 | 7341000.0 |
| 2001-02-06 13:00:00 | MSFT | Stock | 31.4375 | 31.5 | 31.125 | 31.2812 | 18205000.0 |
| 2001-02-06 14:00:00 | MSFT | Stock | 31.2812 | 31.5625 | 31.1562 | 31.3438 | 9018600.0 |
| 2001-02-06 15:00:00 | MSFT | Stock | 31.3438 | 31.5 | 31.25 | 31.2812 | 12733800.0 |
| 2001-02-06 16:00:00 | MSFT | Stock | 31.2812 | 31.5625 | 30.625 | 30.875 | 3186400.0 |
| 2001-02-06 17:00:00 | MSFT | Stock | 30.875 | 30.9688 | 30.75 | 30.875 | 58600.0 |
| 2001-02-06 18:00:00 | MSFT | Stock | 30.9375 | 31.1094 | 30.875 | 30.9688 | 11600.0 |
| 2001-02-06 09:00:00 | NVDA | Stock | 0.1917 | 0.1969 | 0.1911 | 0.1943 | 44880000.0 |
| 2001-02-06 10:00:00 | NVDA | Stock | 0.1943 | 0.1995 | 0.1909 | 0.1971 | 53616000.0 |
| 2001-02-06 11:00:00 | NVDA | Stock | 0.1971 | 0.2 | 0.1958 | 0.1995 | 25176000.0 |
| 2001-02-06 12:00:00 | NVDA | Stock | 0.1995 | 0.1997 | 0.1974 | 0.1984 | 24072000.0 |
| 2001-02-06 13:00:00 | NVDA | Stock | 0.1982 | 0.1997 | 0.1953 | 0.1953 | 25896000.0 |
| 2001-02-06 14:00:00 | NVDA | Stock | 0.1953 | 0.1987 | 0.1948 | 0.1971 | 17712000.0 |
| 2001-02-06 15:00:00 | NVDA | Stock | 0.1979 | 0.2 | 0.1945 | 0.1958 | 38040000.0 |
| 2001-02-06 16:00:00 | NVDA | Stock | 0.1964 | 0.1969 | 0.1953 | 0.1969 | 5304000.0 |
| 2001-02-06 08:00:00 | AMZN | Stock | 0.7359 | 0.7375 | 0.6875 | 0.6906 | 1952000.0 |
| 2001-02-06 09:00:00 | AMZN | Stock | 0.6875 | 0.7094 | 0.6625 | 0.6969 | 66088000.0 |
| 2001-02-06 10:00:00 | AMZN | Stock | 0.6969 | 0.7188 | 0.6875 | 0.7062 | 50440000.0 |
| 2001-02-06 11:00:00 | AMZN | Stock | 0.7047 | 0.7281 | 0.7 | 0.7219 | 59202000.0 |
| 2001-02-06 12:00:00 | AMZN | Stock | 0.7203 | 0.7547 | 0.7188 | 0.7438 | 43946000.0 |
| 2001-02-06 13:00:00 | AMZN | Stock | 0.7438 | 0.7625 | 0.7406 | 0.7438 | 30118000.0 |
| 2001-02-06 14:00:00 | AMZN | Stock | 0.7438 | 0.7906 | 0.7406 | 0.7781 | 48394000.0 |
| 2001-02-06 15:00:00 | AMZN | Stock | 0.7781 | 0.7938 | 0.7563 | 0.7875 | 62994000.0 |
| 2001-02-06 16:00:00 | AMZN | Stock | 0.7875 | 0.8 | 0.7719 | 0.7719 | 10224000.0 |
| 2001-02-06 17:00:00 | AMZN | Stock | 0.7719 | 0.7812 | 0.7625 | 0.7781 | 246000.0 |
| 2001-02-06 18:00:00 | AMZN | Stock | 0.7812 | 0.7812 | 0.7781 | 0.7812 | 30000.0 |
| 2001-02-06 09:00:00 | CL | Stock | 30.025 | 30.05 | 29.625 | 29.78 | 314800.0 |
| 2001-02-06 10:00:00 | CL | Stock | 29.8 | 30.05 | 29.78 | 30.0 | 333600.0 |
| 2001-02-06 11:00:00 | CL | Stock | 29.985 | 30.3 | 29.95 | 30.295 | 284800.0 |
| 2001-02-06 12:00:00 | CL | Stock | 30.295 | 30.375 | 30.225 | 30.355 | 258000.0 |
| 2001-02-06 13:00:00 | CL | Stock | 30.375 | 30.395 | 30.25 | 30.285 | 150600.0 |
| 2001-02-06 14:00:00 | CL | Stock | 30.285 | 30.34 | 30.1 | 30.105 | 217000.0 |
| 2001-02-06 15:00:00 | CL | Stock | 30.135 | 30.345 | 30.075 | 30.075 | 419400.0 |
| 2001-02-06 16:00:00 | CL | Stock | 30.075 | 30.1 | 30.025 | 30.1 | 453400.0 |
| 2001-02-06 17:00:00 | CL | Stock | 30.025 | 30.025 | 29.875 | 29.875 | 20200.0 |
> showing 50 of 16,272 rows — these rows as CSV