PREVIEW / stock_1hour / 2001-05-08
file: by_date/stock_1hour/2001/2001-05-08.parquet size: 350 KB rows: 16,490 symbols: 1,291
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-05-08 08:00:00 | AAPL | Stock | 0.4486 | 0.4554 | 0.4486 | 0.4536 | 403200.0 |
| 2001-05-08 09:00:00 | AAPL | Stock | 0.4534 | 0.4545 | 0.4468 | 0.4514 | 36439200.0 |
| 2001-05-08 10:00:00 | AAPL | Stock | 0.4509 | 0.4509 | 0.4304 | 0.4368 | 93206400.0 |
| 2001-05-08 11:00:00 | AAPL | Stock | 0.4368 | 0.4389 | 0.4286 | 0.4286 | 36926400.0 |
| 2001-05-08 12:00:00 | AAPL | Stock | 0.4286 | 0.4348 | 0.4277 | 0.4329 | 24796800.0 |
| 2001-05-08 13:00:00 | AAPL | Stock | 0.4329 | 0.4357 | 0.4307 | 0.4345 | 22534400.0 |
| 2001-05-08 14:00:00 | AAPL | Stock | 0.4339 | 0.4384 | 0.4321 | 0.4354 | 27888000.0 |
| 2001-05-08 15:00:00 | AAPL | Stock | 0.4359 | 0.4398 | 0.4339 | 0.4393 | 43982400.0 |
| 2001-05-08 16:00:00 | AAPL | Stock | 0.4398 | 0.4418 | 0.4348 | 0.4388 | 12577600.0 |
| 2001-05-08 17:00:00 | AAPL | Stock | 0.4375 | 0.4375 | 0.4375 | 0.4375 | 11200.0 |
| 2001-05-08 18:00:00 | AAPL | Stock | 0.4357 | 0.4357 | 0.4357 | 0.4357 | 5600.0 |
| 2001-05-08 08:00:00 | MSFT | Stock | 35.925 | 36.25 | 35.745 | 36.0 | 334000.0 |
| 2001-05-08 09:00:00 | MSFT | Stock | 36.05 | 36.1 | 35.535 | 35.645 | 11788800.0 |
| 2001-05-08 10:00:00 | MSFT | Stock | 35.625 | 35.68 | 35.375 | 35.53 | 13538000.0 |
| 2001-05-08 11:00:00 | MSFT | Stock | 35.505 | 35.675 | 35.4 | 35.48 | 7346200.0 |
| 2001-05-08 12:00:00 | MSFT | Stock | 35.48 | 35.585 | 35.425 | 35.57 | 5249400.0 |
| 2001-05-08 13:00:00 | MSFT | Stock | 35.57 | 35.675 | 35.51 | 35.635 | 5162200.0 |
| 2001-05-08 14:00:00 | MSFT | Stock | 35.635 | 35.975 | 35.585 | 35.9 | 8377000.0 |
| 2001-05-08 15:00:00 | MSFT | Stock | 35.9 | 36.05 | 35.825 | 36.025 | 16026600.0 |
| 2001-05-08 16:00:00 | MSFT | Stock | 36.025 | 36.125 | 35.7 | 36.0 | 2100600.0 |
| 2001-05-08 17:00:00 | MSFT | Stock | 35.965 | 35.965 | 35.515 | 35.625 | 52200.0 |
| 2001-05-08 18:00:00 | MSFT | Stock | 35.6 | 35.66 | 35.55 | 35.66 | 1000.0 |
| 2001-05-08 08:00:00 | NVDA | Stock | 0.3917 | 0.4 | 0.3917 | 0.3983 | 3456000.0 |
| 2001-05-08 09:00:00 | NVDA | Stock | 0.3963 | 0.4 | 0.3742 | 0.3768 | 222096000.0 |
| 2001-05-08 10:00:00 | NVDA | Stock | 0.377 | 0.3854 | 0.3742 | 0.3796 | 319272000.0 |
| 2001-05-08 11:00:00 | NVDA | Stock | 0.3795 | 0.381 | 0.3774 | 0.3778 | 158904000.0 |
| 2001-05-08 12:00:00 | NVDA | Stock | 0.3778 | 0.3808 | 0.3771 | 0.38 | 81120000.0 |
| 2001-05-08 13:00:00 | NVDA | Stock | 0.3798 | 0.3801 | 0.3751 | 0.3771 | 143616000.0 |
| 2001-05-08 14:00:00 | NVDA | Stock | 0.3768 | 0.3772 | 0.3596 | 0.365 | 283272000.0 |
| 2001-05-08 15:00:00 | NVDA | Stock | 0.365 | 0.3674 | 0.3594 | 0.3628 | 311160000.0 |
| 2001-05-08 16:00:00 | NVDA | Stock | 0.3625 | 0.3695 | 0.3605 | 0.3625 | 12480000.0 |
| 2001-05-08 17:00:00 | NVDA | Stock | 0.3613 | 0.3625 | 0.3613 | 0.3613 | 600000.0 |
| 2001-05-08 18:00:00 | NVDA | Stock | 0.3598 | 0.3598 | 0.3588 | 0.3588 | 528000.0 |
| 2001-05-08 08:00:00 | AMZN | Stock | 0.845 | 0.86 | 0.8425 | 0.8455 | 436000.0 |
| 2001-05-08 09:00:00 | AMZN | Stock | 0.8455 | 0.8475 | 0.804 | 0.8185 | 17406000.0 |
| 2001-05-08 10:00:00 | AMZN | Stock | 0.8185 | 0.8185 | 0.8005 | 0.805 | 21962000.0 |
| 2001-05-08 11:00:00 | AMZN | Stock | 0.804 | 0.811 | 0.78 | 0.786 | 24032000.0 |
| 2001-05-08 12:00:00 | AMZN | Stock | 0.7855 | 0.7945 | 0.7825 | 0.788 | 12392000.0 |
| 2001-05-08 13:00:00 | AMZN | Stock | 0.7895 | 0.8 | 0.788 | 0.7915 | 7210000.0 |
| 2001-05-08 14:00:00 | AMZN | Stock | 0.7895 | 0.8015 | 0.7815 | 0.799 | 21236000.0 |
| 2001-05-08 15:00:00 | AMZN | Stock | 0.799 | 0.809 | 0.79 | 0.809 | 16718000.0 |
| 2001-05-08 16:00:00 | AMZN | Stock | 0.809 | 0.8095 | 0.79 | 0.79 | 1132000.0 |
| 2001-05-08 17:00:00 | AMZN | Stock | 0.79 | 0.809 | 0.786 | 0.7875 | 17430000.0 |
| 2001-05-08 18:00:00 | AMZN | Stock | 0.786 | 0.786 | 0.784 | 0.784 | 112000.0 |
| 2001-05-08 09:00:00 | CL | Stock | 28.7 | 28.7 | 28.4 | 28.45 | 296800.0 |
| 2001-05-08 10:00:00 | CL | Stock | 28.45 | 28.45 | 28.25 | 28.275 | 344600.0 |
| 2001-05-08 11:00:00 | CL | Stock | 28.3 | 28.425 | 28.15 | 28.2 | 223400.0 |
| 2001-05-08 12:00:00 | CL | Stock | 28.19 | 28.45 | 28.15 | 28.45 | 191800.0 |
| 2001-05-08 13:00:00 | CL | Stock | 28.445 | 28.7 | 28.4 | 28.7 | 252800.0 |
| 2001-05-08 14:00:00 | CL | Stock | 28.68 | 28.75 | 28.625 | 28.7 | 414000.0 |
> showing 50 of 16,490 rows — these rows as CSV