PREVIEW / stock_1hour / 2001-04-25
file: by_date/stock_1hour/2001/2001-04-25.parquet size: 350 KB rows: 16,559 symbols: 1,285
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-04-25 08:00:00 | AAPL | Stock | 0.4291 | 0.4302 | 0.4209 | 0.4302 | 728000.0 |
| 2001-04-25 09:00:00 | AAPL | Stock | 0.4302 | 0.442 | 0.4293 | 0.4346 | 51324000.0 |
| 2001-04-25 10:00:00 | AAPL | Stock | 0.4346 | 0.4402 | 0.4321 | 0.4364 | 52914400.0 |
| 2001-04-25 11:00:00 | AAPL | Stock | 0.4359 | 0.4402 | 0.4313 | 0.4318 | 22640800.0 |
| 2001-04-25 12:00:00 | AAPL | Stock | 0.432 | 0.4321 | 0.4214 | 0.4223 | 35632800.0 |
| 2001-04-25 13:00:00 | AAPL | Stock | 0.4223 | 0.4307 | 0.4209 | 0.4295 | 26163200.0 |
| 2001-04-25 14:00:00 | AAPL | Stock | 0.4302 | 0.4375 | 0.425 | 0.4341 | 42179200.0 |
| 2001-04-25 15:00:00 | AAPL | Stock | 0.4341 | 0.4436 | 0.4323 | 0.4418 | 61420800.0 |
| 2001-04-25 16:00:00 | AAPL | Stock | 0.4414 | 0.4427 | 0.4398 | 0.4414 | 7940800.0 |
| 2001-04-25 17:00:00 | AAPL | Stock | 0.4414 | 0.4414 | 0.4414 | 0.4414 | 5600.0 |
| 2001-04-25 18:00:00 | AAPL | Stock | 0.442 | 0.442 | 0.442 | 0.442 | 5600.0 |
| 2001-04-25 08:00:00 | MSFT | Stock | 33.935 | 33.935 | 33.65 | 33.785 | 295000.0 |
| 2001-04-25 09:00:00 | MSFT | Stock | 33.785 | 34.2 | 33.625 | 34.07 | 8990600.0 |
| 2001-04-25 10:00:00 | MSFT | Stock | 34.095 | 34.51 | 34.005 | 34.165 | 13300000.0 |
| 2001-04-25 11:00:00 | MSFT | Stock | 34.16 | 34.375 | 34.1 | 34.18 | 6692000.0 |
| 2001-04-25 12:00:00 | MSFT | Stock | 34.17 | 34.31 | 34.13 | 34.15 | 4718400.0 |
| 2001-04-25 13:00:00 | MSFT | Stock | 34.16 | 34.525 | 34.115 | 34.525 | 7184000.0 |
| 2001-04-25 14:00:00 | MSFT | Stock | 34.49 | 34.875 | 34.455 | 34.82 | 12851800.0 |
| 2001-04-25 15:00:00 | MSFT | Stock | 34.82 | 34.89 | 34.64 | 34.845 | 14379200.0 |
| 2001-04-25 16:00:00 | MSFT | Stock | 34.845 | 35.0 | 34.395 | 34.665 | 3488200.0 |
| 2001-04-25 17:00:00 | MSFT | Stock | 34.75 | 34.96 | 34.61 | 34.85 | 132000.0 |
| 2001-04-25 18:00:00 | MSFT | Stock | 34.775 | 34.825 | 34.75 | 34.75 | 11000.0 |
| 2001-04-25 08:00:00 | NVDA | Stock | 0.3219 | 0.3219 | 0.3125 | 0.3208 | 4272000.0 |
| 2001-04-25 09:00:00 | NVDA | Stock | 0.3208 | 0.3294 | 0.3173 | 0.3239 | 230304000.0 |
| 2001-04-25 10:00:00 | NVDA | Stock | 0.3243 | 0.3288 | 0.32 | 0.3253 | 255936000.0 |
| 2001-04-25 11:00:00 | NVDA | Stock | 0.3251 | 0.3292 | 0.3238 | 0.3261 | 116040000.0 |
| 2001-04-25 12:00:00 | NVDA | Stock | 0.326 | 0.3281 | 0.3208 | 0.3226 | 87696000.0 |
| 2001-04-25 13:00:00 | NVDA | Stock | 0.3225 | 0.3277 | 0.3223 | 0.327 | 85224000.0 |
| 2001-04-25 14:00:00 | NVDA | Stock | 0.3271 | 0.345 | 0.3268 | 0.3378 | 309000000.0 |
| 2001-04-25 15:00:00 | NVDA | Stock | 0.3376 | 0.3398 | 0.331 | 0.3334 | 230040000.0 |
| 2001-04-25 16:00:00 | NVDA | Stock | 0.3343 | 0.337 | 0.331 | 0.3319 | 12312000.0 |
| 2001-04-25 17:00:00 | NVDA | Stock | 0.3319 | 0.3329 | 0.3292 | 0.3292 | 936000.0 |
| 2001-04-25 18:00:00 | NVDA | Stock | 0.3292 | 0.3292 | 0.3292 | 0.3292 | 96000.0 |
| 2001-04-25 08:00:00 | AMZN | Stock | 0.8145 | 0.82 | 0.789 | 0.789 | 1690000.0 |
| 2001-04-25 09:00:00 | AMZN | Stock | 0.789 | 0.8 | 0.73 | 0.7515 | 41590000.0 |
| 2001-04-25 10:00:00 | AMZN | Stock | 0.751 | 0.7625 | 0.7475 | 0.756 | 27560000.0 |
| 2001-04-25 11:00:00 | AMZN | Stock | 0.7555 | 0.771 | 0.754 | 0.7645 | 13608000.0 |
| 2001-04-25 12:00:00 | AMZN | Stock | 0.765 | 0.768 | 0.752 | 0.752 | 15440000.0 |
| 2001-04-25 13:00:00 | AMZN | Stock | 0.752 | 0.756 | 0.75 | 0.754 | 22778000.0 |
| 2001-04-25 14:00:00 | AMZN | Stock | 0.7535 | 0.789 | 0.7535 | 0.787 | 20288000.0 |
| 2001-04-25 15:00:00 | AMZN | Stock | 0.7875 | 0.805 | 0.7825 | 0.805 | 22730000.0 |
| 2001-04-25 16:00:00 | AMZN | Stock | 0.8045 | 0.8065 | 0.7505 | 0.7975 | 6468000.0 |
| 2001-04-25 17:00:00 | AMZN | Stock | 0.7975 | 0.804 | 0.795 | 0.795 | 108000.0 |
| 2001-04-25 18:00:00 | AMZN | Stock | 0.7925 | 0.8045 | 0.7925 | 0.795 | 136000.0 |
| 2001-04-25 09:00:00 | CL | Stock | 26.2 | 26.55 | 26.09 | 26.505 | 432600.0 |
| 2001-04-25 10:00:00 | CL | Stock | 26.505 | 26.505 | 26.32 | 26.35 | 397400.0 |
| 2001-04-25 11:00:00 | CL | Stock | 26.35 | 26.4 | 26.15 | 26.3 | 274200.0 |
| 2001-04-25 12:00:00 | CL | Stock | 26.265 | 26.52 | 26.225 | 26.52 | 291600.0 |
| 2001-04-25 13:00:00 | CL | Stock | 26.5 | 26.575 | 26.32 | 26.5 | 520000.0 |
| 2001-04-25 14:00:00 | CL | Stock | 26.515 | 26.575 | 26.45 | 26.57 | 435200.0 |
> showing 50 of 16,559 rows — these rows as CSV