PREVIEW / stock_1hour / 2001-05-30
file: by_date/stock_1hour/2001/2001-05-30.parquet size: 365 KB rows: 17,206 symbols: 1,302
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-30 08:00:00 | AAPL | Stock | 0.3746 | 0.3832 | 0.3727 | 0.3729 | 588000.0 |
| 2001-05-30 09:00:00 | AAPL | Stock | 0.3725 | 0.3741 | 0.3591 | 0.3607 | 95765600.0 |
| 2001-05-30 10:00:00 | AAPL | Stock | 0.3607 | 0.3623 | 0.3554 | 0.3573 | 122656800.0 |
| 2001-05-30 11:00:00 | AAPL | Stock | 0.357 | 0.3584 | 0.3539 | 0.3575 | 111652800.0 |
| 2001-05-30 12:00:00 | AAPL | Stock | 0.3577 | 0.3586 | 0.3518 | 0.3536 | 64450400.0 |
| 2001-05-30 13:00:00 | AAPL | Stock | 0.3545 | 0.3554 | 0.3446 | 0.3505 | 94819200.0 |
| 2001-05-30 14:00:00 | AAPL | Stock | 0.3498 | 0.3539 | 0.3491 | 0.3511 | 63179200.0 |
| 2001-05-30 15:00:00 | AAPL | Stock | 0.3514 | 0.3538 | 0.3464 | 0.3529 | 145611200.0 |
| 2001-05-30 16:00:00 | AAPL | Stock | 0.3534 | 0.3591 | 0.3473 | 0.3518 | 39166400.0 |
| 2001-05-30 17:00:00 | AAPL | Stock | 0.3532 | 0.3532 | 0.3482 | 0.3514 | 8024800.0 |
| 2001-05-30 18:00:00 | AAPL | Stock | 0.3514 | 0.3514 | 0.3514 | 0.3514 | 22400.0 |
| 2001-05-30 08:00:00 | MSFT | Stock | 34.58 | 35.17 | 34.5 | 34.8 | 2255800.0 |
| 2001-05-30 09:00:00 | MSFT | Stock | 34.75 | 35.075 | 34.7 | 35.01 | 15112400.0 |
| 2001-05-30 10:00:00 | MSFT | Stock | 35.02 | 35.29 | 34.98 | 35.08 | 18830600.0 |
| 2001-05-30 11:00:00 | MSFT | Stock | 35.08 | 35.185 | 34.87 | 35.065 | 7321800.0 |
| 2001-05-30 12:00:00 | MSFT | Stock | 35.065 | 35.16 | 34.805 | 34.9 | 4286000.0 |
| 2001-05-30 13:00:00 | MSFT | Stock | 34.9 | 34.93 | 34.4 | 34.6 | 8121000.0 |
| 2001-05-30 14:00:00 | MSFT | Stock | 34.595 | 34.75 | 34.44 | 34.67 | 8744600.0 |
| 2001-05-30 15:00:00 | MSFT | Stock | 34.67 | 34.805 | 34.325 | 34.595 | 12489800.0 |
| 2001-05-30 16:00:00 | MSFT | Stock | 34.59 | 34.88 | 34.465 | 34.6 | 2803200.0 |
| 2001-05-30 17:00:00 | MSFT | Stock | 34.605 | 34.625 | 34.595 | 34.595 | 1112600.0 |
| 2001-05-30 18:00:00 | MSFT | Stock | 34.645 | 34.675 | 34.6 | 34.625 | 6200.0 |
| 2001-05-30 08:00:00 | NVDA | Stock | 0.3625 | 0.3625 | 0.355 | 0.3604 | 1320000.0 |
| 2001-05-30 09:00:00 | NVDA | Stock | 0.3604 | 0.3665 | 0.356 | 0.3629 | 215376000.0 |
| 2001-05-30 10:00:00 | NVDA | Stock | 0.3629 | 0.368 | 0.3568 | 0.3638 | 197088000.0 |
| 2001-05-30 11:00:00 | NVDA | Stock | 0.3638 | 0.3694 | 0.3594 | 0.3678 | 134376000.0 |
| 2001-05-30 12:00:00 | NVDA | Stock | 0.3674 | 0.3708 | 0.3668 | 0.3683 | 92424000.0 |
| 2001-05-30 13:00:00 | NVDA | Stock | 0.3679 | 0.3679 | 0.3628 | 0.3642 | 118680000.0 |
| 2001-05-30 14:00:00 | NVDA | Stock | 0.3642 | 0.376 | 0.3633 | 0.3743 | 332232000.0 |
| 2001-05-30 15:00:00 | NVDA | Stock | 0.3742 | 0.3758 | 0.3577 | 0.3596 | 1158216000.0 |
| 2001-05-30 16:00:00 | NVDA | Stock | 0.3595 | 0.3646 | 0.3573 | 0.3621 | 639336000.0 |
| 2001-05-30 17:00:00 | NVDA | Stock | 0.3625 | 0.3638 | 0.3595 | 0.3625 | 357936000.0 |
| 2001-05-30 18:00:00 | NVDA | Stock | 0.3624 | 0.3624 | 0.3624 | 0.3624 | 24000.0 |
| 2001-05-30 08:00:00 | AMZN | Stock | 0.85 | 0.855 | 0.825 | 0.825 | 504000.0 |
| 2001-05-30 09:00:00 | AMZN | Stock | 0.8225 | 0.85 | 0.8225 | 0.8345 | 17160000.0 |
| 2001-05-30 10:00:00 | AMZN | Stock | 0.8345 | 0.85 | 0.8145 | 0.818 | 25654000.0 |
| 2001-05-30 11:00:00 | AMZN | Stock | 0.82 | 0.822 | 0.7935 | 0.8075 | 29700000.0 |
| 2001-05-30 12:00:00 | AMZN | Stock | 0.8085 | 0.815 | 0.8035 | 0.805 | 14712000.0 |
| 2001-05-30 13:00:00 | AMZN | Stock | 0.8045 | 0.807 | 0.795 | 0.796 | 14446000.0 |
| 2001-05-30 14:00:00 | AMZN | Stock | 0.7955 | 0.8035 | 0.7935 | 0.8 | 20714000.0 |
| 2001-05-30 15:00:00 | AMZN | Stock | 0.8015 | 0.8115 | 0.781 | 0.788 | 37978000.0 |
| 2001-05-30 16:00:00 | AMZN | Stock | 0.797 | 0.835 | 0.781 | 0.7865 | 9406000.0 |
| 2001-05-30 17:00:00 | AMZN | Stock | 0.7865 | 0.7865 | 0.7765 | 0.7775 | 1476000.0 |
| 2001-05-30 09:00:00 | CL | Stock | 28.95 | 29.045 | 28.86 | 28.975 | 344600.0 |
| 2001-05-30 10:00:00 | CL | Stock | 28.975 | 29.0 | 28.785 | 28.85 | 311400.0 |
| 2001-05-30 11:00:00 | CL | Stock | 28.855 | 28.895 | 28.7 | 28.745 | 385200.0 |
| 2001-05-30 12:00:00 | CL | Stock | 28.74 | 28.745 | 28.59 | 28.69 | 171600.0 |
| 2001-05-30 13:00:00 | CL | Stock | 28.69 | 28.695 | 28.46 | 28.6 | 268800.0 |
| 2001-05-30 14:00:00 | CL | Stock | 28.62 | 28.8 | 28.575 | 28.745 | 184000.0 |
| 2001-05-30 15:00:00 | CL | Stock | 28.745 | 28.925 | 28.745 | 28.75 | 491200.0 |
> showing 50 of 17,206 rows — these rows as CSV