PREVIEW / stock_1hour / 2001-10-26
file: by_date/stock_1hour/2001/2001-10-26.parquet size: 368 KB rows: 17,736 symbols: 1,355
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-10-26 09:00:00 | AAPL | Stock | 0.3375 | 0.342 | 0.3359 | 0.3388 | 29909600.0 |
| 2001-10-26 10:00:00 | AAPL | Stock | 0.3386 | 0.3411 | 0.3338 | 0.337 | 41703200.0 |
| 2001-10-26 11:00:00 | AAPL | Stock | 0.3368 | 0.34 | 0.3359 | 0.3388 | 26997600.0 |
| 2001-10-26 12:00:00 | AAPL | Stock | 0.3386 | 0.3411 | 0.3382 | 0.3407 | 21940800.0 |
| 2001-10-26 13:00:00 | AAPL | Stock | 0.3409 | 0.3438 | 0.3388 | 0.3414 | 22607200.0 |
| 2001-10-26 14:00:00 | AAPL | Stock | 0.3411 | 0.3425 | 0.3364 | 0.3384 | 34232800.0 |
| 2001-10-26 15:00:00 | AAPL | Stock | 0.3384 | 0.34 | 0.3325 | 0.3336 | 68499200.0 |
| 2001-10-26 16:00:00 | AAPL | Stock | 0.3334 | 0.3382 | 0.3214 | 0.3334 | 14386400.0 |
| 2001-10-26 17:00:00 | AAPL | Stock | 0.3334 | 0.3334 | 0.3334 | 0.3334 | 56000.0 |
| 2001-10-26 08:00:00 | MSFT | Stock | 31.075 | 31.3 | 31.075 | 31.22 | 88400.0 |
| 2001-10-26 09:00:00 | MSFT | Stock | 31.095 | 31.625 | 31.05 | 31.22 | 10122000.0 |
| 2001-10-26 10:00:00 | MSFT | Stock | 31.2 | 31.815 | 31.04 | 31.505 | 15036000.0 |
| 2001-10-26 11:00:00 | MSFT | Stock | 31.53 | 31.62 | 31.27 | 31.475 | 6737200.0 |
| 2001-10-26 12:00:00 | MSFT | Stock | 31.465 | 31.675 | 31.35 | 31.675 | 5568800.0 |
| 2001-10-26 13:00:00 | MSFT | Stock | 31.67 | 31.795 | 31.3995 | 31.48 | 6848200.0 |
| 2001-10-26 14:00:00 | MSFT | Stock | 31.48 | 31.525 | 31.06 | 31.2495 | 4805600.0 |
| 2001-10-26 15:00:00 | MSFT | Stock | 31.2495 | 31.725 | 31.085 | 31.1 | 10423200.0 |
| 2001-10-26 16:00:00 | MSFT | Stock | 31.1 | 31.4507 | 31.02 | 31.025 | 3326400.0 |
| 2001-10-26 17:00:00 | MSFT | Stock | 31.02 | 31.1 | 31.015 | 31.055 | 35000.0 |
| 2001-10-26 18:00:00 | MSFT | Stock | 31.085 | 31.09 | 31.085 | 31.09 | 1200.0 |
| 2001-10-26 08:00:00 | NVDA | Stock | 0.4042 | 0.4075 | 0.3983 | 0.4062 | 2388000.0 |
| 2001-10-26 09:00:00 | NVDA | Stock | 0.4077 | 0.4203 | 0.4044 | 0.4105 | 167856000.0 |
| 2001-10-26 10:00:00 | NVDA | Stock | 0.4106 | 0.4125 | 0.3952 | 0.4012 | 208968000.0 |
| 2001-10-26 11:00:00 | NVDA | Stock | 0.4004 | 0.4059 | 0.3975 | 0.4004 | 117384000.0 |
| 2001-10-26 12:00:00 | NVDA | Stock | 0.4001 | 0.4054 | 0.3967 | 0.4034 | 58044000.0 |
| 2001-10-26 13:00:00 | NVDA | Stock | 0.4034 | 0.4059 | 0.3967 | 0.3975 | 85464000.0 |
| 2001-10-26 14:00:00 | NVDA | Stock | 0.3975 | 0.4 | 0.3884 | 0.3912 | 123936000.0 |
| 2001-10-26 15:00:00 | NVDA | Stock | 0.3911 | 0.3915 | 0.3792 | 0.3816 | 268032000.0 |
| 2001-10-26 16:00:00 | NVDA | Stock | 0.3816 | 0.3926 | 0.3808 | 0.3837 | 18372000.0 |
| 2001-10-26 17:00:00 | NVDA | Stock | 0.3849 | 0.3849 | 0.3842 | 0.3849 | 216000.0 |
| 2001-10-26 18:00:00 | NVDA | Stock | 0.385 | 0.385 | 0.385 | 0.385 | 12000.0 |
| 2001-10-26 08:00:00 | AMZN | Stock | 0.3815 | 0.384 | 0.38 | 0.384 | 160000.0 |
| 2001-10-26 09:00:00 | AMZN | Stock | 0.384 | 0.396 | 0.3755 | 0.3835 | 16368000.0 |
| 2001-10-26 10:00:00 | AMZN | Stock | 0.3845 | 0.399 | 0.3825 | 0.397 | 23572000.0 |
| 2001-10-26 11:00:00 | AMZN | Stock | 0.397 | 0.3995 | 0.394 | 0.399 | 12336000.0 |
| 2001-10-26 12:00:00 | AMZN | Stock | 0.3995 | 0.4005 | 0.396 | 0.3975 | 14594000.0 |
| 2001-10-26 13:00:00 | AMZN | Stock | 0.3975 | 0.3985 | 0.382 | 0.385 | 25696000.0 |
| 2001-10-26 14:00:00 | AMZN | Stock | 0.3855 | 0.39 | 0.3835 | 0.3895 | 5484000.0 |
| 2001-10-26 15:00:00 | AMZN | Stock | 0.3895 | 0.39 | 0.378 | 0.3785 | 17382000.0 |
| 2001-10-26 16:00:00 | AMZN | Stock | 0.3785 | 0.383 | 0.375 | 0.3795 | 1660000.0 |
| 2001-10-26 17:00:00 | AMZN | Stock | 0.3795 | 0.3845 | 0.378 | 0.3805 | 136000.0 |
| 2001-10-26 18:00:00 | AMZN | Stock | 0.3845 | 0.3845 | 0.3845 | 0.3845 | 2000.0 |
| 2001-10-26 09:00:00 | CL | Stock | 29.325 | 29.325 | 28.85 | 28.93 | 349400.0 |
| 2001-10-26 10:00:00 | CL | Stock | 28.93 | 29.245 | 28.925 | 29.245 | 503200.0 |
| 2001-10-26 11:00:00 | CL | Stock | 29.24 | 29.375 | 29.2 | 29.345 | 500600.0 |
| 2001-10-26 12:00:00 | CL | Stock | 29.345 | 29.375 | 29.145 | 29.2 | 345800.0 |
| 2001-10-26 13:00:00 | CL | Stock | 29.2 | 29.255 | 29.1 | 29.19 | 211000.0 |
| 2001-10-26 14:00:00 | CL | Stock | 29.185 | 29.2 | 29.01 | 29.2 | 327400.0 |
| 2001-10-26 15:00:00 | CL | Stock | 29.2 | 29.365 | 29.105 | 29.25 | 1118000.0 |
| 2001-10-26 16:00:00 | CL | Stock | 29.25 | 29.25 | 29.25 | 29.25 | 36000.0 |
> showing 50 of 17,736 rows — these rows as CSV