PREVIEW / stock_1hour / 2001-01-30
file: by_date/stock_1hour/2001/2001-01-30.parquet size: 357 KB rows: 16,552 symbols: 1,275
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-01-30 08:00:00 | AAPL | Stock | 0.3878 | 0.3878 | 0.38 | 0.3839 | 666400.0 |
| 2001-01-30 09:00:00 | AAPL | Stock | 0.3845 | 0.3884 | 0.3783 | 0.3884 | 65060800.0 |
| 2001-01-30 10:00:00 | AAPL | Stock | 0.3884 | 0.3895 | 0.3728 | 0.3739 | 124292000.0 |
| 2001-01-30 11:00:00 | AAPL | Stock | 0.3739 | 0.3884 | 0.3739 | 0.3795 | 93458400.0 |
| 2001-01-30 12:00:00 | AAPL | Stock | 0.3795 | 0.3839 | 0.3739 | 0.3795 | 41641600.0 |
| 2001-01-30 13:00:00 | AAPL | Stock | 0.3795 | 0.3862 | 0.3783 | 0.3845 | 73684800.0 |
| 2001-01-30 14:00:00 | AAPL | Stock | 0.3839 | 0.3929 | 0.3817 | 0.3873 | 97288800.0 |
| 2001-01-30 15:00:00 | AAPL | Stock | 0.3873 | 0.3929 | 0.3828 | 0.3884 | 108320800.0 |
| 2001-01-30 16:00:00 | AAPL | Stock | 0.3878 | 0.3884 | 0.3795 | 0.3884 | 10892000.0 |
| 2001-01-30 17:00:00 | AAPL | Stock | 0.3862 | 0.3884 | 0.3839 | 0.3873 | 95200.0 |
| 2001-01-30 18:00:00 | AAPL | Stock | 0.3817 | 0.3817 | 0.3817 | 0.3817 | 11200.0 |
| 2001-01-30 08:00:00 | MSFT | Stock | 32.25 | 32.3438 | 32.1875 | 32.2812 | 17000.0 |
| 2001-01-30 09:00:00 | MSFT | Stock | 32.2188 | 32.375 | 31.9062 | 32.1875 | 6754400.0 |
| 2001-01-30 10:00:00 | MSFT | Stock | 32.1875 | 32.2188 | 31.5312 | 31.75 | 9719800.0 |
| 2001-01-30 11:00:00 | MSFT | Stock | 31.7812 | 31.9688 | 31.6875 | 31.7188 | 5138400.0 |
| 2001-01-30 12:00:00 | MSFT | Stock | 31.7188 | 31.8438 | 31.5625 | 31.7188 | 5863800.0 |
| 2001-01-30 13:00:00 | MSFT | Stock | 31.7188 | 31.875 | 31.6875 | 31.7188 | 4184600.0 |
| 2001-01-30 14:00:00 | MSFT | Stock | 31.75 | 31.75 | 31.4375 | 31.6406 | 8897200.0 |
| 2001-01-30 15:00:00 | MSFT | Stock | 31.625 | 31.9375 | 31.4688 | 31.7188 | 8796000.0 |
| 2001-01-30 16:00:00 | MSFT | Stock | 31.6875 | 32.0 | 31.375 | 31.625 | 2168800.0 |
| 2001-01-30 17:00:00 | MSFT | Stock | 31.5 | 31.7188 | 31.5 | 31.7188 | 11200.0 |
| 2001-01-30 18:00:00 | MSFT | Stock | 31.6562 | 31.6562 | 31.6562 | 31.6562 | 1000.0 |
| 2001-01-30 09:00:00 | NVDA | Stock | 0.2146 | 0.2219 | 0.2146 | 0.2216 | 27048000.0 |
| 2001-01-30 10:00:00 | NVDA | Stock | 0.2211 | 0.222 | 0.2128 | 0.2129 | 49944000.0 |
| 2001-01-30 11:00:00 | NVDA | Stock | 0.2125 | 0.2185 | 0.212 | 0.218 | 41736000.0 |
| 2001-01-30 12:00:00 | NVDA | Stock | 0.2182 | 0.2193 | 0.2151 | 0.2182 | 28848000.0 |
| 2001-01-30 13:00:00 | NVDA | Stock | 0.2182 | 0.2188 | 0.2167 | 0.2169 | 29424000.0 |
| 2001-01-30 14:00:00 | NVDA | Stock | 0.2167 | 0.2172 | 0.2151 | 0.2161 | 11232000.0 |
| 2001-01-30 15:00:00 | NVDA | Stock | 0.2167 | 0.2188 | 0.2156 | 0.2174 | 25512000.0 |
| 2001-01-30 16:00:00 | NVDA | Stock | 0.2174 | 0.2174 | 0.2143 | 0.2151 | 1152000.0 |
| 2001-01-30 08:00:00 | AMZN | Stock | 1.05 | 1.05 | 0.9875 | 1.0031 | 782000.0 |
| 2001-01-30 09:00:00 | AMZN | Stock | 1.0 | 1.0344 | 0.9938 | 0.9938 | 18530000.0 |
| 2001-01-30 10:00:00 | AMZN | Stock | 0.9938 | 1.0 | 0.95 | 0.9656 | 38056000.0 |
| 2001-01-30 11:00:00 | AMZN | Stock | 0.9656 | 0.9688 | 0.9438 | 0.95 | 19398000.0 |
| 2001-01-30 12:00:00 | AMZN | Stock | 0.9484 | 0.9625 | 0.9344 | 0.9562 | 23672000.0 |
| 2001-01-30 13:00:00 | AMZN | Stock | 0.9562 | 0.9625 | 0.95 | 0.9594 | 15324000.0 |
| 2001-01-30 14:00:00 | AMZN | Stock | 0.9562 | 0.9625 | 0.9344 | 0.9344 | 22206000.0 |
| 2001-01-30 15:00:00 | AMZN | Stock | 0.9375 | 0.9562 | 0.9328 | 0.9469 | 49382000.0 |
| 2001-01-30 16:00:00 | AMZN | Stock | 0.9438 | 1.0672 | 0.9 | 0.9234 | 19714000.0 |
| 2001-01-30 17:00:00 | AMZN | Stock | 0.9219 | 0.9344 | 0.8906 | 0.9 | 14346000.0 |
| 2001-01-30 18:00:00 | AMZN | Stock | 0.8938 | 0.9156 | 0.8875 | 0.9062 | 3028000.0 |
| 2001-01-30 09:00:00 | CL | Stock | 28.25 | 29.0 | 28.2 | 28.97 | 540400.0 |
| 2001-01-30 10:00:00 | CL | Stock | 28.965 | 29.655 | 28.925 | 29.475 | 977400.0 |
| 2001-01-30 11:00:00 | CL | Stock | 29.475 | 29.55 | 29.275 | 29.28 | 423600.0 |
| 2001-01-30 12:00:00 | CL | Stock | 29.28 | 29.525 | 29.25 | 29.44 | 242800.0 |
| 2001-01-30 13:00:00 | CL | Stock | 29.44 | 29.44 | 29.03 | 29.055 | 288600.0 |
| 2001-01-30 14:00:00 | CL | Stock | 29.05 | 29.45 | 29.04 | 29.355 | 414200.0 |
| 2001-01-30 15:00:00 | CL | Stock | 29.375 | 29.46 | 29.35 | 29.36 | 548400.0 |
| 2001-01-30 16:00:00 | CL | Stock | 29.355 | 29.36 | 29.355 | 29.36 | 27000.0 |
| 2001-01-30 17:00:00 | CL | Stock | 29.36 | 29.36 | 29.36 | 29.36 | 6000.0 |
> showing 50 of 16,552 rows — these rows as CSV