PREVIEW / stock_1hour / 2001-08-03
file: by_date/stock_1hour/2001/2001-08-03.parquet size: 358 KB rows: 16,869 symbols: 1,321
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-08-03 08:00:00 | AAPL | Stock | 0.3543 | 0.3545 | 0.3482 | 0.3538 | 268800.0 |
| 2001-08-03 09:00:00 | AAPL | Stock | 0.3538 | 0.3554 | 0.3446 | 0.3459 | 29383200.0 |
| 2001-08-03 10:00:00 | AAPL | Stock | 0.3459 | 0.3461 | 0.3393 | 0.3455 | 53737600.0 |
| 2001-08-03 11:00:00 | AAPL | Stock | 0.3454 | 0.348 | 0.3438 | 0.345 | 18110400.0 |
| 2001-08-03 12:00:00 | AAPL | Stock | 0.3448 | 0.3461 | 0.3439 | 0.3461 | 7358400.0 |
| 2001-08-03 13:00:00 | AAPL | Stock | 0.3461 | 0.3482 | 0.3443 | 0.348 | 13507200.0 |
| 2001-08-03 14:00:00 | AAPL | Stock | 0.348 | 0.3495 | 0.3452 | 0.3455 | 15052800.0 |
| 2001-08-03 15:00:00 | AAPL | Stock | 0.3461 | 0.3516 | 0.3457 | 0.3484 | 38108000.0 |
| 2001-08-03 16:00:00 | AAPL | Stock | 0.3484 | 0.3486 | 0.3464 | 0.3482 | 4306400.0 |
| 2001-08-03 17:00:00 | AAPL | Stock | 0.3464 | 0.3464 | 0.3464 | 0.3464 | 5600.0 |
| 2001-08-03 18:00:00 | AAPL | Stock | 0.3473 | 0.3473 | 0.3473 | 0.3473 | 16800.0 |
| 2001-08-03 08:00:00 | MSFT | Stock | 33.7 | 33.725 | 33.5 | 33.61 | 47200.0 |
| 2001-08-03 09:00:00 | MSFT | Stock | 33.625 | 33.68 | 33.305 | 33.495 | 5523400.0 |
| 2001-08-03 10:00:00 | MSFT | Stock | 33.5 | 33.525 | 33.25 | 33.33 | 6704400.0 |
| 2001-08-03 11:00:00 | MSFT | Stock | 33.32 | 33.365 | 33.24 | 33.25 | 4569800.0 |
| 2001-08-03 12:00:00 | MSFT | Stock | 33.25 | 33.28 | 33.015 | 33.11 | 4645400.0 |
| 2001-08-03 13:00:00 | MSFT | Stock | 33.115 | 33.19 | 33.0 | 33.05 | 4449600.0 |
| 2001-08-03 14:00:00 | MSFT | Stock | 33.045 | 33.25 | 33.025 | 33.2 | 3666200.0 |
| 2001-08-03 15:00:00 | MSFT | Stock | 33.2 | 33.465 | 33.065 | 33.46 | 9649000.0 |
| 2001-08-03 16:00:00 | MSFT | Stock | 33.46 | 33.525 | 33.125 | 33.445 | 1100400.0 |
| 2001-08-03 17:00:00 | MSFT | Stock | 33.445 | 33.5 | 33.405 | 33.5 | 8400.0 |
| 2001-08-03 18:00:00 | MSFT | Stock | 33.5 | 33.5 | 33.5 | 33.5 | 200.0 |
| 2001-08-03 08:00:00 | NVDA | Stock | 0.3625 | 0.3668 | 0.3625 | 0.3639 | 624000.0 |
| 2001-08-03 09:00:00 | NVDA | Stock | 0.363 | 0.3638 | 0.3567 | 0.3603 | 110952000.0 |
| 2001-08-03 10:00:00 | NVDA | Stock | 0.3603 | 0.3608 | 0.3557 | 0.3575 | 146976000.0 |
| 2001-08-03 11:00:00 | NVDA | Stock | 0.3575 | 0.3608 | 0.3564 | 0.3594 | 69960000.0 |
| 2001-08-03 12:00:00 | NVDA | Stock | 0.3595 | 0.3625 | 0.3591 | 0.3615 | 65160000.0 |
| 2001-08-03 13:00:00 | NVDA | Stock | 0.3616 | 0.3635 | 0.3604 | 0.3615 | 99888000.0 |
| 2001-08-03 14:00:00 | NVDA | Stock | 0.3613 | 0.3689 | 0.3609 | 0.3657 | 105072000.0 |
| 2001-08-03 15:00:00 | NVDA | Stock | 0.3654 | 0.3666 | 0.3623 | 0.3645 | 178080000.0 |
| 2001-08-03 16:00:00 | NVDA | Stock | 0.3644 | 0.3679 | 0.3631 | 0.3646 | 16152000.0 |
| 2001-08-03 17:00:00 | NVDA | Stock | 0.3646 | 0.3656 | 0.3646 | 0.3656 | 120000.0 |
| 2001-08-03 08:00:00 | AMZN | Stock | 0.611 | 0.6125 | 0.611 | 0.6125 | 18000.0 |
| 2001-08-03 09:00:00 | AMZN | Stock | 0.568 | 0.615 | 0.568 | 0.6095 | 9080000.0 |
| 2001-08-03 10:00:00 | AMZN | Stock | 0.6095 | 0.6195 | 0.6055 | 0.6125 | 15442000.0 |
| 2001-08-03 11:00:00 | AMZN | Stock | 0.6105 | 0.6145 | 0.61 | 0.612 | 8662000.0 |
| 2001-08-03 12:00:00 | AMZN | Stock | 0.612 | 0.615 | 0.61 | 0.6125 | 3388000.0 |
| 2001-08-03 13:00:00 | AMZN | Stock | 0.612 | 0.614 | 0.6085 | 0.6115 | 4630000.0 |
| 2001-08-03 14:00:00 | AMZN | Stock | 0.6115 | 0.614 | 0.6105 | 0.6125 | 4902000.0 |
| 2001-08-03 15:00:00 | AMZN | Stock | 0.6125 | 0.615 | 0.6075 | 0.6075 | 9314000.0 |
| 2001-08-03 16:00:00 | AMZN | Stock | 0.6075 | 0.613 | 0.6075 | 0.6075 | 4226000.0 |
| 2001-08-03 17:00:00 | AMZN | Stock | 0.6075 | 0.6075 | 0.6075 | 0.6075 | 8000.0 |
| 2001-08-03 09:00:00 | CL | Stock | 26.595 | 26.74 | 26.5 | 26.5 | 310000.0 |
| 2001-08-03 10:00:00 | CL | Stock | 26.485 | 26.64 | 26.375 | 26.635 | 337200.0 |
| 2001-08-03 11:00:00 | CL | Stock | 26.625 | 26.725 | 26.55 | 26.55 | 272000.0 |
| 2001-08-03 12:00:00 | CL | Stock | 26.555 | 26.75 | 26.555 | 26.635 | 219600.0 |
| 2001-08-03 13:00:00 | CL | Stock | 26.635 | 26.695 | 26.625 | 26.665 | 220400.0 |
| 2001-08-03 14:00:00 | CL | Stock | 26.665 | 26.7 | 26.6 | 26.66 | 414400.0 |
| 2001-08-03 15:00:00 | CL | Stock | 26.655 | 26.8 | 26.64 | 26.75 | 461800.0 |
| 2001-08-03 16:00:00 | CL | Stock | 26.715 | 26.965 | 26.64 | 26.7 | 125400.0 |
> showing 50 of 16,869 rows — these rows as CSV