PREVIEW / stock_1hour / 2001-11-13
file: by_date/stock_1hour/2001/2001-11-13.parquet size: 378 KB rows: 18,079 symbols: 1,351
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-11-13 08:00:00 | AAPL | Stock | 0.34 | 0.3409 | 0.34 | 0.3409 | 84000.0 |
| 2001-11-13 09:00:00 | AAPL | Stock | 0.3409 | 0.3432 | 0.3355 | 0.3355 | 32032000.0 |
| 2001-11-13 10:00:00 | AAPL | Stock | 0.3355 | 0.3413 | 0.3341 | 0.34 | 27070400.0 |
| 2001-11-13 11:00:00 | AAPL | Stock | 0.3398 | 0.3427 | 0.338 | 0.3398 | 20036800.0 |
| 2001-11-13 12:00:00 | AAPL | Stock | 0.3395 | 0.3423 | 0.3384 | 0.3421 | 18396000.0 |
| 2001-11-13 13:00:00 | AAPL | Stock | 0.342 | 0.3446 | 0.3404 | 0.3425 | 20372800.0 |
| 2001-11-13 14:00:00 | AAPL | Stock | 0.3425 | 0.345 | 0.3401 | 0.3409 | 26331200.0 |
| 2001-11-13 15:00:00 | AAPL | Stock | 0.3409 | 0.3463 | 0.3402 | 0.3457 | 25239200.0 |
| 2001-11-13 16:00:00 | AAPL | Stock | 0.3454 | 0.3459 | 0.3424 | 0.345 | 6092800.0 |
| 2001-11-13 17:00:00 | AAPL | Stock | 0.3459 | 0.3459 | 0.345 | 0.345 | 32496800.0 |
| 2001-11-13 18:00:00 | AAPL | Stock | 0.3459 | 0.3459 | 0.3459 | 0.3459 | 78400.0 |
| 2001-11-13 08:00:00 | MSFT | Stock | 33.35 | 33.485 | 33.05 | 33.4 | 157000.0 |
| 2001-11-13 09:00:00 | MSFT | Stock | 33.4 | 33.535 | 32.965 | 33.35 | 10830000.0 |
| 2001-11-13 10:00:00 | MSFT | Stock | 33.35 | 33.65 | 33.335 | 33.56 | 10181200.0 |
| 2001-11-13 11:00:00 | MSFT | Stock | 33.56 | 33.701 | 33.55 | 33.65 | 5616800.0 |
| 2001-11-13 12:00:00 | MSFT | Stock | 33.67 | 33.7505 | 33.535 | 33.705 | 4790000.0 |
| 2001-11-13 13:00:00 | MSFT | Stock | 33.71 | 33.8745 | 33.635 | 33.72 | 6003800.0 |
| 2001-11-13 14:00:00 | MSFT | Stock | 33.72 | 33.75 | 33.45 | 33.5545 | 8955400.0 |
| 2001-11-13 15:00:00 | MSFT | Stock | 33.5545 | 33.975 | 33.53 | 33.95 | 10670600.0 |
| 2001-11-13 16:00:00 | MSFT | Stock | 33.95 | 34.0 | 33.6164 | 33.95 | 1787600.0 |
| 2001-11-13 17:00:00 | MSFT | Stock | 33.95 | 34.0 | 33.6 | 33.915 | 116800.0 |
| 2001-11-13 18:00:00 | MSFT | Stock | 33.955 | 33.955 | 33.95 | 33.95 | 11200.0 |
| 2001-11-13 08:00:00 | NVDA | Stock | 0.4604 | 0.4666 | 0.4583 | 0.4642 | 6408000.0 |
| 2001-11-13 09:00:00 | NVDA | Stock | 0.4642 | 0.4646 | 0.445 | 0.4493 | 378012000.0 |
| 2001-11-13 10:00:00 | NVDA | Stock | 0.4492 | 0.4546 | 0.4482 | 0.45 | 272148000.0 |
| 2001-11-13 11:00:00 | NVDA | Stock | 0.4502 | 0.4521 | 0.4479 | 0.4494 | 146160000.0 |
| 2001-11-13 12:00:00 | NVDA | Stock | 0.4492 | 0.4517 | 0.4479 | 0.4499 | 99504000.0 |
| 2001-11-13 13:00:00 | NVDA | Stock | 0.4499 | 0.4515 | 0.4492 | 0.4492 | 108492000.0 |
| 2001-11-13 14:00:00 | NVDA | Stock | 0.4492 | 0.4542 | 0.4462 | 0.4489 | 226884000.0 |
| 2001-11-13 15:00:00 | NVDA | Stock | 0.449 | 0.4528 | 0.4484 | 0.4511 | 171528000.0 |
| 2001-11-13 16:00:00 | NVDA | Stock | 0.4514 | 0.4533 | 0.4508 | 0.4517 | 12564000.0 |
| 2001-11-13 17:00:00 | NVDA | Stock | 0.4521 | 0.4534 | 0.4515 | 0.4526 | 1476000.0 |
| 2001-11-13 18:00:00 | NVDA | Stock | 0.4517 | 0.4529 | 0.4515 | 0.4515 | 84000.0 |
| 2001-11-13 08:00:00 | AMZN | Stock | 0.357 | 0.3735 | 0.357 | 0.37 | 620000.0 |
| 2001-11-13 09:00:00 | AMZN | Stock | 0.37 | 0.375 | 0.365 | 0.3655 | 19350000.0 |
| 2001-11-13 10:00:00 | AMZN | Stock | 0.366 | 0.367 | 0.36 | 0.3665 | 20150000.0 |
| 2001-11-13 11:00:00 | AMZN | Stock | 0.366 | 0.3675 | 0.362 | 0.365 | 10704000.0 |
| 2001-11-13 12:00:00 | AMZN | Stock | 0.365 | 0.3705 | 0.3646 | 0.3695 | 9662000.0 |
| 2001-11-13 13:00:00 | AMZN | Stock | 0.37 | 0.37 | 0.3635 | 0.3675 | 10142000.0 |
| 2001-11-13 14:00:00 | AMZN | Stock | 0.368 | 0.368 | 0.361 | 0.365 | 31158000.0 |
| 2001-11-13 15:00:00 | AMZN | Stock | 0.3645 | 0.368 | 0.3635 | 0.365 | 11612000.0 |
| 2001-11-13 16:00:00 | AMZN | Stock | 0.367 | 0.3675 | 0.3645 | 0.3675 | 2570000.0 |
| 2001-11-13 17:00:00 | AMZN | Stock | 0.3675 | 0.3675 | 0.3645 | 0.367 | 276000.0 |
| 2001-11-13 18:00:00 | AMZN | Stock | 0.3665 | 0.3665 | 0.3645 | 0.3645 | 40000.0 |
| 2001-11-13 09:00:00 | CL | Stock | 28.675 | 28.7 | 28.55 | 28.605 | 484000.0 |
| 2001-11-13 10:00:00 | CL | Stock | 28.605 | 28.77 | 28.6 | 28.695 | 382400.0 |
| 2001-11-13 11:00:00 | CL | Stock | 28.71 | 28.74 | 28.655 | 28.73 | 278000.0 |
| 2001-11-13 12:00:00 | CL | Stock | 28.735 | 28.79 | 28.675 | 28.765 | 139000.0 |
| 2001-11-13 13:00:00 | CL | Stock | 28.775 | 28.835 | 28.625 | 28.68 | 343800.0 |
| 2001-11-13 14:00:00 | CL | Stock | 28.69 | 28.875 | 28.68 | 28.865 | 350800.0 |
> showing 50 of 18,079 rows — these rows as CSV