PREVIEW / stock_1hour / 2001-10-30
file: by_date/stock_1hour/2001/2001-10-30.parquet size: 368 KB rows: 17,765 symbols: 1,342
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-30 08:00:00 | AAPL | Stock | 0.3147 | 0.3147 | 0.3125 | 0.3134 | 1859200.0 |
| 2001-10-30 09:00:00 | AAPL | Stock | 0.3178 | 0.3178 | 0.3052 | 0.3115 | 46239200.0 |
| 2001-10-30 10:00:00 | AAPL | Stock | 0.3114 | 0.3195 | 0.3098 | 0.3189 | 53076800.0 |
| 2001-10-30 11:00:00 | AAPL | Stock | 0.3191 | 0.3213 | 0.3152 | 0.3202 | 39188800.0 |
| 2001-10-30 12:00:00 | AAPL | Stock | 0.3204 | 0.3209 | 0.3143 | 0.3161 | 27714400.0 |
| 2001-10-30 13:00:00 | AAPL | Stock | 0.3163 | 0.3207 | 0.3141 | 0.32 | 16912000.0 |
| 2001-10-30 14:00:00 | AAPL | Stock | 0.3202 | 0.3205 | 0.3161 | 0.3186 | 29797600.0 |
| 2001-10-30 15:00:00 | AAPL | Stock | 0.318 | 0.3196 | 0.3116 | 0.3143 | 46888800.0 |
| 2001-10-30 16:00:00 | AAPL | Stock | 0.3143 | 0.3151 | 0.313 | 0.3143 | 5336800.0 |
| 2001-10-30 17:00:00 | AAPL | Stock | 0.3143 | 0.3143 | 0.3143 | 0.3143 | 162400.0 |
| 2001-10-30 08:00:00 | MSFT | Stock | 29.645 | 29.65 | 29.5 | 29.65 | 67600.0 |
| 2001-10-30 09:00:00 | MSFT | Stock | 29.6 | 29.625 | 29.275 | 29.455 | 9191200.0 |
| 2001-10-30 10:00:00 | MSFT | Stock | 29.45 | 29.455 | 29.095 | 29.375 | 12791800.0 |
| 2001-10-30 11:00:00 | MSFT | Stock | 29.3615 | 29.675 | 29.225 | 29.56 | 8039400.0 |
| 2001-10-30 12:00:00 | MSFT | Stock | 29.5645 | 29.61 | 29.285 | 29.345 | 5140200.0 |
| 2001-10-30 13:00:00 | MSFT | Stock | 29.345 | 29.7745 | 29.3 | 29.735 | 4953800.0 |
| 2001-10-30 14:00:00 | MSFT | Stock | 29.735 | 29.74 | 29.35 | 29.475 | 4702400.0 |
| 2001-10-30 15:00:00 | MSFT | Stock | 29.4505 | 29.6 | 29.25 | 29.435 | 8532400.0 |
| 2001-10-30 16:00:00 | MSFT | Stock | 29.435 | 29.47 | 29.225 | 29.25 | 2478600.0 |
| 2001-10-30 17:00:00 | MSFT | Stock | 29.225 | 29.44 | 29.2 | 29.285 | 564200.0 |
| 2001-10-30 08:00:00 | NVDA | Stock | 0.3446 | 0.3508 | 0.3426 | 0.35 | 1968000.0 |
| 2001-10-30 09:00:00 | NVDA | Stock | 0.35 | 0.3562 | 0.3437 | 0.3472 | 185532000.0 |
| 2001-10-30 10:00:00 | NVDA | Stock | 0.3472 | 0.35 | 0.3362 | 0.3441 | 235980000.0 |
| 2001-10-30 11:00:00 | NVDA | Stock | 0.3437 | 0.3596 | 0.3422 | 0.3579 | 210924000.0 |
| 2001-10-30 12:00:00 | NVDA | Stock | 0.3579 | 0.3617 | 0.3533 | 0.3585 | 97296000.0 |
| 2001-10-30 13:00:00 | NVDA | Stock | 0.3587 | 0.3662 | 0.3542 | 0.3637 | 119592000.0 |
| 2001-10-30 14:00:00 | NVDA | Stock | 0.3639 | 0.3639 | 0.3513 | 0.3567 | 123252000.0 |
| 2001-10-30 15:00:00 | NVDA | Stock | 0.3564 | 0.3582 | 0.3492 | 0.3501 | 135300000.0 |
| 2001-10-30 16:00:00 | NVDA | Stock | 0.3501 | 0.355 | 0.35 | 0.3508 | 8820000.0 |
| 2001-10-30 17:00:00 | NVDA | Stock | 0.35 | 0.3505 | 0.3496 | 0.3496 | 492000.0 |
| 2001-10-30 18:00:00 | NVDA | Stock | 0.35 | 0.35 | 0.3494 | 0.3494 | 240000.0 |
| 2001-10-30 08:00:00 | AMZN | Stock | 0.3675 | 0.3675 | 0.34 | 0.347 | 304000.0 |
| 2001-10-30 09:00:00 | AMZN | Stock | 0.347 | 0.3525 | 0.338 | 0.35 | 19464000.0 |
| 2001-10-30 10:00:00 | AMZN | Stock | 0.3495 | 0.35 | 0.3265 | 0.3345 | 45832000.0 |
| 2001-10-30 11:00:00 | AMZN | Stock | 0.333 | 0.344 | 0.332 | 0.337 | 19796000.0 |
| 2001-10-30 12:00:00 | AMZN | Stock | 0.337 | 0.337 | 0.3164 | 0.32 | 34490000.0 |
| 2001-10-30 13:00:00 | AMZN | Stock | 0.32 | 0.334 | 0.3165 | 0.3275 | 26446000.0 |
| 2001-10-30 14:00:00 | AMZN | Stock | 0.328 | 0.3285 | 0.32 | 0.3225 | 20012000.0 |
| 2001-10-30 15:00:00 | AMZN | Stock | 0.3225 | 0.326 | 0.317 | 0.321 | 18666000.0 |
| 2001-10-30 16:00:00 | AMZN | Stock | 0.321 | 0.3301 | 0.318 | 0.321 | 2132000.0 |
| 2001-10-30 17:00:00 | AMZN | Stock | 0.321 | 0.321 | 0.321 | 0.321 | 6000.0 |
| 2001-10-30 18:00:00 | AMZN | Stock | 0.32 | 0.321 | 0.3175 | 0.321 | 612000.0 |
| 2001-10-30 09:00:00 | CL | Stock | 28.375 | 28.75 | 28.375 | 28.635 | 480000.0 |
| 2001-10-30 10:00:00 | CL | Stock | 28.605 | 28.625 | 28.45 | 28.475 | 413400.0 |
| 2001-10-30 11:00:00 | CL | Stock | 28.5 | 28.57 | 28.47 | 28.53 | 176800.0 |
| 2001-10-30 12:00:00 | CL | Stock | 28.545 | 28.75 | 28.505 | 28.73 | 146400.0 |
| 2001-10-30 13:00:00 | CL | Stock | 28.735 | 29.05 | 28.6 | 29.05 | 184200.0 |
| 2001-10-30 14:00:00 | CL | Stock | 29.035 | 29.035 | 28.825 | 28.965 | 301000.0 |
| 2001-10-30 15:00:00 | CL | Stock | 28.93 | 28.975 | 28.8 | 28.89 | 415800.0 |
| 2001-10-30 16:00:00 | CL | Stock | 28.89 | 28.89 | 28.69 | 28.69 | 90000.0 |
> showing 50 of 17,765 rows — these rows as CSV