PREVIEW / stock_1hour / 2001-05-15
file: by_date/stock_1hour/2001/2001-05-15.parquet size: 357 KB rows: 16,962 symbols: 1,286
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-15 08:00:00 | AAPL | Stock | 0.4159 | 0.4202 | 0.4159 | 0.4179 | 4547200.0 |
| 2001-05-15 09:00:00 | AAPL | Stock | 0.4182 | 0.4239 | 0.4161 | 0.4205 | 26846400.0 |
| 2001-05-15 10:00:00 | AAPL | Stock | 0.4205 | 0.432 | 0.4177 | 0.4188 | 40807200.0 |
| 2001-05-15 11:00:00 | AAPL | Stock | 0.4189 | 0.4232 | 0.4152 | 0.4211 | 22932000.0 |
| 2001-05-15 12:00:00 | AAPL | Stock | 0.4214 | 0.4248 | 0.42 | 0.4239 | 20809600.0 |
| 2001-05-15 13:00:00 | AAPL | Stock | 0.4236 | 0.4259 | 0.4223 | 0.4229 | 11110400.0 |
| 2001-05-15 14:00:00 | AAPL | Stock | 0.4229 | 0.4309 | 0.4154 | 0.4302 | 49660800.0 |
| 2001-05-15 15:00:00 | AAPL | Stock | 0.4302 | 0.4313 | 0.4114 | 0.4143 | 47650400.0 |
| 2001-05-15 16:00:00 | AAPL | Stock | 0.4138 | 0.4429 | 0.4127 | 0.4193 | 4401600.0 |
| 2001-05-15 18:00:00 | AAPL | Stock | 0.4154 | 0.4154 | 0.4141 | 0.4141 | 16800.0 |
| 2001-05-15 08:00:00 | MSFT | Stock | 34.36 | 34.4 | 34.25 | 34.375 | 11600.0 |
| 2001-05-15 09:00:00 | MSFT | Stock | 34.395 | 34.45 | 34.115 | 34.275 | 6242600.0 |
| 2001-05-15 10:00:00 | MSFT | Stock | 34.29 | 34.49 | 34.28 | 34.33 | 9859200.0 |
| 2001-05-15 11:00:00 | MSFT | Stock | 34.34 | 34.375 | 34.125 | 34.165 | 3834400.0 |
| 2001-05-15 12:00:00 | MSFT | Stock | 34.165 | 34.265 | 34.16 | 34.21 | 3217400.0 |
| 2001-05-15 13:00:00 | MSFT | Stock | 34.21 | 34.25 | 34.095 | 34.155 | 4052000.0 |
| 2001-05-15 14:00:00 | MSFT | Stock | 34.16 | 34.65 | 34.005 | 34.345 | 14654400.0 |
| 2001-05-15 15:00:00 | MSFT | Stock | 34.35 | 34.45 | 34.0 | 34.145 | 14740600.0 |
| 2001-05-15 16:00:00 | MSFT | Stock | 34.14 | 34.42 | 34.125 | 34.25 | 2505000.0 |
| 2001-05-15 17:00:00 | MSFT | Stock | 34.25 | 34.25 | 34.185 | 34.185 | 6800.0 |
| 2001-05-15 18:00:00 | MSFT | Stock | 34.185 | 34.275 | 34.175 | 34.2 | 3000.0 |
| 2001-05-15 08:00:00 | NVDA | Stock | 0.3296 | 0.3302 | 0.3294 | 0.33 | 936000.0 |
| 2001-05-15 09:00:00 | NVDA | Stock | 0.3302 | 0.3346 | 0.3275 | 0.3313 | 96288000.0 |
| 2001-05-15 10:00:00 | NVDA | Stock | 0.3313 | 0.3435 | 0.3313 | 0.3404 | 258576000.0 |
| 2001-05-15 11:00:00 | NVDA | Stock | 0.3403 | 0.3424 | 0.34 | 0.3407 | 72480000.0 |
| 2001-05-15 12:00:00 | NVDA | Stock | 0.3408 | 0.3463 | 0.3402 | 0.3449 | 67056000.0 |
| 2001-05-15 13:00:00 | NVDA | Stock | 0.3446 | 0.3447 | 0.3406 | 0.3416 | 76584000.0 |
| 2001-05-15 14:00:00 | NVDA | Stock | 0.3414 | 0.3498 | 0.3393 | 0.3481 | 289416000.0 |
| 2001-05-15 15:00:00 | NVDA | Stock | 0.3477 | 0.3542 | 0.3344 | 0.3402 | 332496000.0 |
| 2001-05-15 16:00:00 | NVDA | Stock | 0.3402 | 0.3417 | 0.3391 | 0.3399 | 13200000.0 |
| 2001-05-15 17:00:00 | NVDA | Stock | 0.3399 | 0.3402 | 0.3333 | 0.3352 | 936000.0 |
| 2001-05-15 18:00:00 | NVDA | Stock | 0.3384 | 0.3417 | 0.3384 | 0.3417 | 192000.0 |
| 2001-05-15 08:00:00 | AMZN | Stock | 0.667 | 0.673 | 0.667 | 0.673 | 24000.0 |
| 2001-05-15 09:00:00 | AMZN | Stock | 0.67 | 0.69 | 0.657 | 0.6765 | 9700000.0 |
| 2001-05-15 10:00:00 | AMZN | Stock | 0.677 | 0.7045 | 0.6765 | 0.702 | 20458000.0 |
| 2001-05-15 11:00:00 | AMZN | Stock | 0.7025 | 0.714 | 0.701 | 0.709 | 15938000.0 |
| 2001-05-15 12:00:00 | AMZN | Stock | 0.71 | 0.7125 | 0.7015 | 0.705 | 10140000.0 |
| 2001-05-15 13:00:00 | AMZN | Stock | 0.7055 | 0.708 | 0.681 | 0.684 | 9394000.0 |
| 2001-05-15 14:00:00 | AMZN | Stock | 0.684 | 0.7 | 0.67 | 0.687 | 21036000.0 |
| 2001-05-15 15:00:00 | AMZN | Stock | 0.687 | 0.7025 | 0.6715 | 0.6775 | 25288000.0 |
| 2001-05-15 16:00:00 | AMZN | Stock | 0.677 | 0.688 | 0.667 | 0.677 | 2664000.0 |
| 2001-05-15 17:00:00 | AMZN | Stock | 0.687 | 0.687 | 0.677 | 0.685 | 14000.0 |
| 2001-05-15 09:00:00 | CL | Stock | 29.1 | 29.16 | 28.925 | 29.0 | 363000.0 |
| 2001-05-15 10:00:00 | CL | Stock | 28.95 | 29.025 | 28.625 | 28.7 | 657200.0 |
| 2001-05-15 11:00:00 | CL | Stock | 28.72 | 28.745 | 28.55 | 28.625 | 435800.0 |
| 2001-05-15 12:00:00 | CL | Stock | 28.615 | 28.75 | 28.575 | 28.66 | 231600.0 |
| 2001-05-15 13:00:00 | CL | Stock | 28.66 | 28.66 | 28.25 | 28.255 | 428000.0 |
| 2001-05-15 14:00:00 | CL | Stock | 28.255 | 28.505 | 28.255 | 28.5 | 820600.0 |
| 2001-05-15 15:00:00 | CL | Stock | 28.495 | 28.55 | 28.325 | 28.41 | 1254000.0 |
| 2001-05-15 16:00:00 | CL | Stock | 28.35 | 28.35 | 28.35 | 28.35 | 221000.0 |
> showing 50 of 16,962 rows — these rows as CSV