PREVIEW / stock_1hour / 2001-02-21
file: by_date/stock_1hour/2001/2001-02-21.parquet size: 353 KB rows: 16,735 symbols: 1,270
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-02-21 08:00:00 | AAPL | Stock | 0.3265 | 0.3304 | 0.3259 | 0.3259 | 2268000.0 |
| 2001-02-21 09:00:00 | AAPL | Stock | 0.327 | 0.3359 | 0.3248 | 0.3354 | 34484800.0 |
| 2001-02-21 10:00:00 | AAPL | Stock | 0.3348 | 0.3471 | 0.3315 | 0.3438 | 74916800.0 |
| 2001-02-21 11:00:00 | AAPL | Stock | 0.3438 | 0.3488 | 0.3371 | 0.346 | 44497600.0 |
| 2001-02-21 12:00:00 | AAPL | Stock | 0.346 | 0.356 | 0.3449 | 0.3504 | 47090400.0 |
| 2001-02-21 13:00:00 | AAPL | Stock | 0.3493 | 0.3504 | 0.3371 | 0.3382 | 29450400.0 |
| 2001-02-21 14:00:00 | AAPL | Stock | 0.3393 | 0.3404 | 0.3359 | 0.3404 | 67922400.0 |
| 2001-02-21 15:00:00 | AAPL | Stock | 0.3404 | 0.3415 | 0.3371 | 0.3371 | 49179200.0 |
| 2001-02-21 16:00:00 | AAPL | Stock | 0.3371 | 0.3393 | 0.3348 | 0.3371 | 15271200.0 |
| 2001-02-21 17:00:00 | AAPL | Stock | 0.3359 | 0.3359 | 0.3326 | 0.3326 | 117600.0 |
| 2001-02-21 18:00:00 | AAPL | Stock | 0.3315 | 0.3315 | 0.3304 | 0.3304 | 72800.0 |
| 2001-02-21 08:00:00 | MSFT | Stock | 27.9375 | 28.0469 | 27.5938 | 27.6875 | 233600.0 |
| 2001-02-21 09:00:00 | MSFT | Stock | 27.625 | 28.5312 | 27.5 | 28.25 | 9848800.0 |
| 2001-02-21 10:00:00 | MSFT | Stock | 28.25 | 28.6562 | 27.875 | 28.4375 | 9650600.0 |
| 2001-02-21 11:00:00 | MSFT | Stock | 28.4375 | 28.75 | 28.1562 | 28.6875 | 8341400.0 |
| 2001-02-21 12:00:00 | MSFT | Stock | 28.6562 | 29.0312 | 28.625 | 28.6562 | 7601000.0 |
| 2001-02-21 13:00:00 | MSFT | Stock | 28.6562 | 28.7188 | 28.4375 | 28.5312 | 3219600.0 |
| 2001-02-21 14:00:00 | MSFT | Stock | 28.5625 | 28.7812 | 28.1562 | 28.5625 | 6610400.0 |
| 2001-02-21 15:00:00 | MSFT | Stock | 28.5625 | 28.7031 | 27.9688 | 28.125 | 13349200.0 |
| 2001-02-21 16:00:00 | MSFT | Stock | 28.125 | 28.375 | 28.0625 | 28.1875 | 1418800.0 |
| 2001-02-21 17:00:00 | MSFT | Stock | 28.1875 | 28.2969 | 28.0625 | 28.0625 | 253200.0 |
| 2001-02-21 18:00:00 | MSFT | Stock | 28.0312 | 28.0625 | 28.0312 | 28.0625 | 5800.0 |
| 2001-02-21 08:00:00 | NVDA | Stock | 0.223 | 0.223 | 0.2198 | 0.2211 | 1128000.0 |
| 2001-02-21 09:00:00 | NVDA | Stock | 0.2208 | 0.2365 | 0.2125 | 0.2302 | 112824000.0 |
| 2001-02-21 10:00:00 | NVDA | Stock | 0.2313 | 0.2365 | 0.225 | 0.2307 | 121944000.0 |
| 2001-02-21 11:00:00 | NVDA | Stock | 0.2307 | 0.2352 | 0.2271 | 0.2339 | 53664000.0 |
| 2001-02-21 12:00:00 | NVDA | Stock | 0.2336 | 0.2427 | 0.2336 | 0.2372 | 117480000.0 |
| 2001-02-21 13:00:00 | NVDA | Stock | 0.2375 | 0.2406 | 0.2354 | 0.2354 | 49368000.0 |
| 2001-02-21 14:00:00 | NVDA | Stock | 0.2354 | 0.2391 | 0.2302 | 0.2339 | 45264000.0 |
| 2001-02-21 15:00:00 | NVDA | Stock | 0.2328 | 0.2352 | 0.231 | 0.2332 | 97560000.0 |
| 2001-02-21 16:00:00 | NVDA | Stock | 0.2333 | 0.2352 | 0.2331 | 0.2333 | 3768000.0 |
| 2001-02-21 17:00:00 | NVDA | Stock | 0.2333 | 0.2352 | 0.2315 | 0.2352 | 360000.0 |
| 2001-02-21 08:00:00 | AMZN | Stock | 0.625 | 0.625 | 0.6219 | 0.6219 | 402000.0 |
| 2001-02-21 09:00:00 | AMZN | Stock | 0.6219 | 0.6219 | 0.5812 | 0.5812 | 27368000.0 |
| 2001-02-21 10:00:00 | AMZN | Stock | 0.5828 | 0.6125 | 0.5656 | 0.5969 | 42096000.0 |
| 2001-02-21 11:00:00 | AMZN | Stock | 0.5969 | 0.6188 | 0.5938 | 0.6094 | 15298000.0 |
| 2001-02-21 12:00:00 | AMZN | Stock | 0.6125 | 0.625 | 0.6094 | 0.6188 | 12678000.0 |
| 2001-02-21 13:00:00 | AMZN | Stock | 0.6156 | 0.6188 | 0.6 | 0.6 | 6584000.0 |
| 2001-02-21 14:00:00 | AMZN | Stock | 0.6031 | 0.6063 | 0.5969 | 0.6031 | 11902000.0 |
| 2001-02-21 15:00:00 | AMZN | Stock | 0.6 | 0.6031 | 0.5969 | 0.5969 | 21026000.0 |
| 2001-02-21 16:00:00 | AMZN | Stock | 0.5969 | 0.6016 | 0.5781 | 0.6 | 7810000.0 |
| 2001-02-21 17:00:00 | AMZN | Stock | 0.5969 | 0.5984 | 0.5969 | 0.5984 | 24000.0 |
| 2001-02-21 18:00:00 | AMZN | Stock | 0.5984 | 0.6 | 0.5969 | 0.5969 | 14000.0 |
| 2001-02-21 09:00:00 | CL | Stock | 29.9 | 30.0 | 29.77 | 29.775 | 427800.0 |
| 2001-02-21 10:00:00 | CL | Stock | 29.775 | 29.78 | 29.4 | 29.45 | 496800.0 |
| 2001-02-21 11:00:00 | CL | Stock | 29.455 | 29.7 | 29.45 | 29.7 | 576600.0 |
| 2001-02-21 12:00:00 | CL | Stock | 29.675 | 29.74 | 29.4 | 29.475 | 352600.0 |
| 2001-02-21 13:00:00 | CL | Stock | 29.455 | 29.47 | 29.25 | 29.375 | 317200.0 |
| 2001-02-21 14:00:00 | CL | Stock | 29.375 | 29.525 | 29.15 | 29.5 | 353200.0 |
| 2001-02-21 15:00:00 | CL | Stock | 29.515 | 29.825 | 29.425 | 29.595 | 747400.0 |
> showing 50 of 16,735 rows — these rows as CSV