PREVIEW / stock_1hour / 2001-11-01
file: by_date/stock_1hour/2001/2001-11-01.parquet size: 367 KB rows: 17,846 symbols: 1,356
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-11-01 08:00:00 | AAPL | Stock | 0.3184 | 0.3184 | 0.3145 | 0.3145 | 140000.0 |
| 2001-11-01 09:00:00 | AAPL | Stock | 0.3161 | 0.3195 | 0.308 | 0.3173 | 38892000.0 |
| 2001-11-01 10:00:00 | AAPL | Stock | 0.317 | 0.3221 | 0.31 | 0.3214 | 65436000.0 |
| 2001-11-01 11:00:00 | AAPL | Stock | 0.3221 | 0.3263 | 0.3207 | 0.3218 | 46429600.0 |
| 2001-11-01 12:00:00 | AAPL | Stock | 0.3218 | 0.3223 | 0.3173 | 0.3207 | 17544800.0 |
| 2001-11-01 13:00:00 | AAPL | Stock | 0.3211 | 0.3264 | 0.3207 | 0.323 | 33280800.0 |
| 2001-11-01 14:00:00 | AAPL | Stock | 0.3229 | 0.3255 | 0.3213 | 0.3234 | 35369600.0 |
| 2001-11-01 15:00:00 | AAPL | Stock | 0.323 | 0.3354 | 0.323 | 0.3321 | 52147200.0 |
| 2001-11-01 16:00:00 | AAPL | Stock | 0.3321 | 0.3327 | 0.3222 | 0.3318 | 10449600.0 |
| 2001-11-01 17:00:00 | AAPL | Stock | 0.3288 | 0.332 | 0.3288 | 0.332 | 2648800.0 |
| 2001-11-01 08:00:00 | MSFT | Stock | 29.915 | 30.245 | 29.53 | 29.975 | 2144800.0 |
| 2001-11-01 09:00:00 | MSFT | Stock | 30.0 | 31.525 | 29.07 | 30.105 | 20002200.0 |
| 2001-11-01 10:00:00 | MSFT | Stock | 30.105 | 30.425 | 29.8155 | 30.261 | 22206800.0 |
| 2001-11-01 11:00:00 | MSFT | Stock | 30.2625 | 30.38 | 30.2 | 30.275 | 8338000.0 |
| 2001-11-01 12:00:00 | MSFT | Stock | 30.28 | 30.56 | 30.25 | 30.505 | 8197800.0 |
| 2001-11-01 13:00:00 | MSFT | Stock | 30.505 | 30.8 | 30.48 | 30.685 | 10818600.0 |
| 2001-11-01 14:00:00 | MSFT | Stock | 30.6805 | 30.9 | 30.65 | 30.7005 | 10237800.0 |
| 2001-11-01 15:00:00 | MSFT | Stock | 30.71 | 31.1295 | 30.67 | 30.9 | 20531000.0 |
| 2001-11-01 16:00:00 | MSFT | Stock | 30.92 | 31.0 | 30.0325 | 30.145 | 3390000.0 |
| 2001-11-01 17:00:00 | MSFT | Stock | 30.624 | 30.92 | 30.515 | 30.65 | 844800.0 |
| 2001-11-01 18:00:00 | MSFT | Stock | 30.65 | 30.725 | 30.626 | 30.725 | 6600.0 |
| 2001-11-01 08:00:00 | NVDA | Stock | 0.3598 | 0.3633 | 0.3572 | 0.3633 | 444000.0 |
| 2001-11-01 09:00:00 | NVDA | Stock | 0.3604 | 0.3725 | 0.3562 | 0.3713 | 205992000.0 |
| 2001-11-01 10:00:00 | NVDA | Stock | 0.3721 | 0.3754 | 0.3633 | 0.3748 | 234120000.0 |
| 2001-11-01 11:00:00 | NVDA | Stock | 0.3748 | 0.3773 | 0.37 | 0.3717 | 80580000.0 |
| 2001-11-01 12:00:00 | NVDA | Stock | 0.3715 | 0.3742 | 0.3677 | 0.3728 | 60864000.0 |
| 2001-11-01 13:00:00 | NVDA | Stock | 0.3727 | 0.3829 | 0.3726 | 0.3826 | 123768000.0 |
| 2001-11-01 14:00:00 | NVDA | Stock | 0.3827 | 0.3854 | 0.3807 | 0.3822 | 164040000.0 |
| 2001-11-01 15:00:00 | NVDA | Stock | 0.3822 | 0.3906 | 0.3804 | 0.3875 | 194520000.0 |
| 2001-11-01 16:00:00 | NVDA | Stock | 0.3875 | 0.3885 | 0.3867 | 0.3882 | 9744000.0 |
| 2001-11-01 17:00:00 | NVDA | Stock | 0.3882 | 0.3882 | 0.3854 | 0.3854 | 1920000.0 |
| 2001-11-01 18:00:00 | NVDA | Stock | 0.3855 | 0.3867 | 0.3854 | 0.3867 | 84000.0 |
| 2001-11-01 08:00:00 | AMZN | Stock | 0.3525 | 0.3555 | 0.3525 | 0.354 | 88000.0 |
| 2001-11-01 09:00:00 | AMZN | Stock | 0.355 | 0.3575 | 0.333 | 0.3385 | 22858000.0 |
| 2001-11-01 10:00:00 | AMZN | Stock | 0.338 | 0.343 | 0.33 | 0.342 | 13412000.0 |
| 2001-11-01 11:00:00 | AMZN | Stock | 0.3415 | 0.3435 | 0.3375 | 0.338 | 8354000.0 |
| 2001-11-01 12:00:00 | AMZN | Stock | 0.338 | 0.3415 | 0.336 | 0.3386 | 6054000.0 |
| 2001-11-01 13:00:00 | AMZN | Stock | 0.3385 | 0.348 | 0.3385 | 0.347 | 9666000.0 |
| 2001-11-01 14:00:00 | AMZN | Stock | 0.347 | 0.351 | 0.345 | 0.3465 | 10718000.0 |
| 2001-11-01 15:00:00 | AMZN | Stock | 0.3465 | 0.3515 | 0.3455 | 0.3475 | 23772000.0 |
| 2001-11-01 16:00:00 | AMZN | Stock | 0.3485 | 0.352 | 0.347 | 0.3475 | 3424000.0 |
| 2001-11-01 17:00:00 | AMZN | Stock | 0.3475 | 0.3485 | 0.347 | 0.347 | 384000.0 |
| 2001-11-01 18:00:00 | AMZN | Stock | 0.3475 | 0.348 | 0.347 | 0.3475 | 46000.0 |
| 2001-11-01 09:00:00 | CL | Stock | 28.635 | 28.7 | 28.415 | 28.475 | 349200.0 |
| 2001-11-01 10:00:00 | CL | Stock | 28.475 | 28.825 | 28.44 | 28.7 | 604600.0 |
| 2001-11-01 11:00:00 | CL | Stock | 28.7 | 28.73 | 28.475 | 28.475 | 352600.0 |
| 2001-11-01 12:00:00 | CL | Stock | 28.5 | 28.7 | 28.485 | 28.69 | 336600.0 |
| 2001-11-01 13:00:00 | CL | Stock | 28.685 | 28.975 | 28.595 | 28.645 | 593800.0 |
| 2001-11-01 14:00:00 | CL | Stock | 28.645 | 28.645 | 28.5 | 28.57 | 803600.0 |
| 2001-11-01 15:00:00 | CL | Stock | 28.565 | 28.905 | 28.525 | 28.88 | 791000.0 |
> showing 50 of 17,846 rows — these rows as CSV