PREVIEW / stock_1hour / 2001-10-16
file: by_date/stock_1hour/2001/2001-10-16.parquet size: 369 KB rows: 17,741 symbols: 1,341
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-16 09:00:00 | AAPL | Stock | 0.3229 | 0.3234 | 0.3184 | 0.3216 | 20624800.0 |
| 2001-10-16 10:00:00 | AAPL | Stock | 0.3216 | 0.3243 | 0.3173 | 0.3198 | 21638400.0 |
| 2001-10-16 11:00:00 | AAPL | Stock | 0.3198 | 0.3214 | 0.3186 | 0.3195 | 16822400.0 |
| 2001-10-16 12:00:00 | AAPL | Stock | 0.3195 | 0.3232 | 0.3179 | 0.3232 | 22377600.0 |
| 2001-10-16 13:00:00 | AAPL | Stock | 0.3232 | 0.325 | 0.3213 | 0.3231 | 27972000.0 |
| 2001-10-16 14:00:00 | AAPL | Stock | 0.323 | 0.325 | 0.3205 | 0.3221 | 26762400.0 |
| 2001-10-16 15:00:00 | AAPL | Stock | 0.3221 | 0.3232 | 0.3209 | 0.3213 | 36674400.0 |
| 2001-10-16 16:00:00 | AAPL | Stock | 0.3216 | 0.3223 | 0.3202 | 0.3223 | 9900800.0 |
| 2001-10-16 17:00:00 | AAPL | Stock | 0.3202 | 0.3202 | 0.3202 | 0.3202 | 28000.0 |
| 2001-10-16 18:00:00 | AAPL | Stock | 0.3221 | 0.3223 | 0.3221 | 0.3223 | 112000.0 |
| 2001-10-16 08:00:00 | MSFT | Stock | 28.89 | 29.12 | 28.74 | 29.095 | 172200.0 |
| 2001-10-16 09:00:00 | MSFT | Stock | 29.01 | 29.455 | 28.84 | 29.379 | 12338200.0 |
| 2001-10-16 10:00:00 | MSFT | Stock | 29.385 | 29.455 | 28.8 | 29.0 | 11602000.0 |
| 2001-10-16 11:00:00 | MSFT | Stock | 28.99 | 29.1305 | 28.825 | 28.955 | 7267600.0 |
| 2001-10-16 12:00:00 | MSFT | Stock | 28.9505 | 28.9505 | 28.61 | 28.89 | 7134400.0 |
| 2001-10-16 13:00:00 | MSFT | Stock | 28.89 | 29.075 | 28.77 | 28.965 | 6159600.0 |
| 2001-10-16 14:00:00 | MSFT | Stock | 28.9945 | 29.15 | 28.815 | 28.995 | 6574200.0 |
| 2001-10-16 15:00:00 | MSFT | Stock | 28.9799 | 29.33 | 28.885 | 29.22 | 10027400.0 |
| 2001-10-16 16:00:00 | MSFT | Stock | 29.235 | 29.365 | 28.96 | 29.05 | 1790000.0 |
| 2001-10-16 17:00:00 | MSFT | Stock | 29.05 | 29.475 | 29.05 | 29.46 | 42400.0 |
| 2001-10-16 18:00:00 | MSFT | Stock | 29.46 | 29.5 | 29.225 | 29.495 | 42600.0 |
| 2001-10-16 08:00:00 | NVDA | Stock | 0.3362 | 0.34 | 0.335 | 0.3354 | 912000.0 |
| 2001-10-16 09:00:00 | NVDA | Stock | 0.3357 | 0.3458 | 0.3281 | 0.3424 | 131736000.0 |
| 2001-10-16 10:00:00 | NVDA | Stock | 0.3418 | 0.3489 | 0.3375 | 0.345 | 254592000.0 |
| 2001-10-16 11:00:00 | NVDA | Stock | 0.3452 | 0.3518 | 0.3435 | 0.3481 | 182568000.0 |
| 2001-10-16 12:00:00 | NVDA | Stock | 0.3479 | 0.35 | 0.3458 | 0.35 | 65256000.0 |
| 2001-10-16 13:00:00 | NVDA | Stock | 0.35 | 0.3567 | 0.3482 | 0.3549 | 155544000.0 |
| 2001-10-16 14:00:00 | NVDA | Stock | 0.3549 | 0.3596 | 0.3539 | 0.3593 | 133872000.0 |
| 2001-10-16 15:00:00 | NVDA | Stock | 0.3587 | 0.3718 | 0.3567 | 0.3692 | 374796000.0 |
| 2001-10-16 16:00:00 | NVDA | Stock | 0.3692 | 0.3737 | 0.3529 | 0.3692 | 27564000.0 |
| 2001-10-16 17:00:00 | NVDA | Stock | 0.3658 | 0.3733 | 0.3654 | 0.3721 | 3036000.0 |
| 2001-10-16 18:00:00 | NVDA | Stock | 0.3712 | 0.3734 | 0.3712 | 0.3734 | 588000.0 |
| 2001-10-16 08:00:00 | AMZN | Stock | 0.4495 | 0.465 | 0.4495 | 0.456 | 242000.0 |
| 2001-10-16 09:00:00 | AMZN | Stock | 0.4575 | 0.4875 | 0.455 | 0.4765 | 37426000.0 |
| 2001-10-16 10:00:00 | AMZN | Stock | 0.4755 | 0.479 | 0.4595 | 0.4685 | 29940000.0 |
| 2001-10-16 11:00:00 | AMZN | Stock | 0.4675 | 0.472 | 0.4585 | 0.4595 | 26460000.0 |
| 2001-10-16 12:00:00 | AMZN | Stock | 0.4595 | 0.474 | 0.4565 | 0.471 | 13056000.0 |
| 2001-10-16 13:00:00 | AMZN | Stock | 0.471 | 0.476 | 0.4645 | 0.473 | 8042000.0 |
| 2001-10-16 14:00:00 | AMZN | Stock | 0.473 | 0.4775 | 0.4705 | 0.4756 | 15654000.0 |
| 2001-10-16 15:00:00 | AMZN | Stock | 0.4755 | 0.485 | 0.4735 | 0.478 | 19704000.0 |
| 2001-10-16 16:00:00 | AMZN | Stock | 0.478 | 0.48 | 0.47 | 0.478 | 2046000.0 |
| 2001-10-16 17:00:00 | AMZN | Stock | 0.478 | 0.478 | 0.4615 | 0.4775 | 52000.0 |
| 2001-10-16 18:00:00 | AMZN | Stock | 0.4775 | 0.48 | 0.4775 | 0.48 | 88000.0 |
| 2001-10-16 09:00:00 | CL | Stock | 28.075 | 28.25 | 28.015 | 28.09 | 520400.0 |
| 2001-10-16 10:00:00 | CL | Stock | 28.09 | 28.1 | 27.825 | 27.965 | 715400.0 |
| 2001-10-16 11:00:00 | CL | Stock | 27.955 | 27.955 | 27.7 | 27.755 | 587200.0 |
| 2001-10-16 12:00:00 | CL | Stock | 27.77 | 28.025 | 27.77 | 27.995 | 419600.0 |
| 2001-10-16 13:00:00 | CL | Stock | 27.99 | 28.25 | 27.94 | 28.15 | 387600.0 |
| 2001-10-16 14:00:00 | CL | Stock | 28.15 | 28.35 | 28.14 | 28.305 | 352000.0 |
| 2001-10-16 15:00:00 | CL | Stock | 28.37 | 28.7 | 28.28 | 28.615 | 812200.0 |
> showing 50 of 17,741 rows — these rows as CSV