PREVIEW / stock_1hour / 2001-07-10
file: by_date/stock_1hour/2001/2001-07-10.parquet size: 363 KB rows: 17,365 symbols: 1,309
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-07-10 08:00:00 | AAPL | Stock | 0.4079 | 0.4107 | 0.4052 | 0.4096 | 548800.0 |
| 2001-07-10 09:00:00 | AAPL | Stock | 0.4109 | 0.4125 | 0.4063 | 0.4064 | 40527200.0 |
| 2001-07-10 10:00:00 | AAPL | Stock | 0.4063 | 0.4089 | 0.4021 | 0.4021 | 43400000.0 |
| 2001-07-10 11:00:00 | AAPL | Stock | 0.4021 | 0.4048 | 0.3973 | 0.3996 | 21700000.0 |
| 2001-07-10 12:00:00 | AAPL | Stock | 0.3996 | 0.4009 | 0.392 | 0.392 | 25060000.0 |
| 2001-07-10 13:00:00 | AAPL | Stock | 0.3921 | 0.3961 | 0.3866 | 0.3875 | 36461600.0 |
| 2001-07-10 14:00:00 | AAPL | Stock | 0.3866 | 0.387 | 0.3732 | 0.3771 | 63739200.0 |
| 2001-07-10 15:00:00 | AAPL | Stock | 0.377 | 0.3805 | 0.3721 | 0.378 | 94774400.0 |
| 2001-07-10 16:00:00 | AAPL | Stock | 0.3773 | 0.4104 | 0.3705 | 0.3786 | 29814400.0 |
| 2001-07-10 17:00:00 | AAPL | Stock | 0.3786 | 0.3795 | 0.3786 | 0.3786 | 184800.0 |
| 2001-07-10 18:00:00 | AAPL | Stock | 0.3786 | 0.3786 | 0.3786 | 0.3786 | 5600.0 |
| 2001-07-10 08:00:00 | MSFT | Stock | 33.0 | 33.18 | 32.845 | 33.05 | 122000.0 |
| 2001-07-10 09:00:00 | MSFT | Stock | 33.05 | 33.12 | 32.635 | 32.96 | 8880200.0 |
| 2001-07-10 10:00:00 | MSFT | Stock | 32.96 | 33.11 | 32.71 | 33.0 | 11778600.0 |
| 2001-07-10 11:00:00 | MSFT | Stock | 33.005 | 33.12 | 32.845 | 33.015 | 6283800.0 |
| 2001-07-10 12:00:00 | MSFT | Stock | 33.015 | 33.125 | 32.92 | 32.98 | 3957200.0 |
| 2001-07-10 13:00:00 | MSFT | Stock | 32.975 | 33.025 | 32.53 | 32.585 | 5259600.0 |
| 2001-07-10 14:00:00 | MSFT | Stock | 32.565 | 32.8 | 32.5 | 32.6 | 8672600.0 |
| 2001-07-10 15:00:00 | MSFT | Stock | 32.6 | 32.635 | 32.175 | 32.24 | 15049200.0 |
| 2001-07-10 16:00:00 | MSFT | Stock | 32.245 | 32.77 | 32.045 | 32.24 | 3155600.0 |
| 2001-07-10 17:00:00 | MSFT | Stock | 32.24 | 32.725 | 32.2 | 32.24 | 30600.0 |
| 2001-07-10 18:00:00 | MSFT | Stock | 32.25 | 32.25 | 32.24 | 32.24 | 4600.0 |
| 2001-07-10 08:00:00 | NVDA | Stock | 0.3258 | 0.3294 | 0.3258 | 0.3294 | 6264000.0 |
| 2001-07-10 09:00:00 | NVDA | Stock | 0.3298 | 0.3323 | 0.3271 | 0.3288 | 136344000.0 |
| 2001-07-10 10:00:00 | NVDA | Stock | 0.3289 | 0.3335 | 0.3257 | 0.3306 | 235632000.0 |
| 2001-07-10 11:00:00 | NVDA | Stock | 0.3306 | 0.3313 | 0.3271 | 0.3296 | 99504000.0 |
| 2001-07-10 12:00:00 | NVDA | Stock | 0.3296 | 0.334 | 0.3294 | 0.3319 | 133392000.0 |
| 2001-07-10 13:00:00 | NVDA | Stock | 0.3319 | 0.3332 | 0.3277 | 0.3287 | 96336000.0 |
| 2001-07-10 14:00:00 | NVDA | Stock | 0.3287 | 0.3296 | 0.324 | 0.3277 | 197088000.0 |
| 2001-07-10 15:00:00 | NVDA | Stock | 0.3278 | 0.3299 | 0.3242 | 0.328 | 183048000.0 |
| 2001-07-10 16:00:00 | NVDA | Stock | 0.328 | 0.3295 | 0.3242 | 0.3288 | 16032000.0 |
| 2001-07-10 17:00:00 | NVDA | Stock | 0.3271 | 0.3289 | 0.3267 | 0.3279 | 792000.0 |
| 2001-07-10 18:00:00 | NVDA | Stock | 0.3275 | 0.3275 | 0.3267 | 0.3267 | 312000.0 |
| 2001-07-10 08:00:00 | AMZN | Stock | 0.79 | 0.7995 | 0.79 | 0.795 | 52000.0 |
| 2001-07-10 09:00:00 | AMZN | Stock | 0.794 | 0.805 | 0.794 | 0.7975 | 20722000.0 |
| 2001-07-10 10:00:00 | AMZN | Stock | 0.7975 | 0.8025 | 0.741 | 0.795 | 24102000.0 |
| 2001-07-10 11:00:00 | AMZN | Stock | 0.795 | 0.8 | 0.79 | 0.7955 | 17214000.0 |
| 2001-07-10 12:00:00 | AMZN | Stock | 0.7955 | 0.8025 | 0.7925 | 0.8005 | 9268000.0 |
| 2001-07-10 13:00:00 | AMZN | Stock | 0.8 | 0.8025 | 0.789 | 0.7925 | 22454000.0 |
| 2001-07-10 14:00:00 | AMZN | Stock | 0.7925 | 0.8025 | 0.783 | 0.8005 | 31014000.0 |
| 2001-07-10 15:00:00 | AMZN | Stock | 0.8005 | 0.804 | 0.78 | 0.7805 | 31452000.0 |
| 2001-07-10 16:00:00 | AMZN | Stock | 0.7805 | 0.802 | 0.778 | 0.7805 | 6260000.0 |
| 2001-07-10 17:00:00 | AMZN | Stock | 0.788 | 0.788 | 0.7805 | 0.7805 | 34000.0 |
| 2001-07-10 18:00:00 | AMZN | Stock | 0.7825 | 0.7825 | 0.7825 | 0.7825 | 20000.0 |
| 2001-07-10 09:00:00 | CL | Stock | 29.275 | 29.275 | 28.925 | 28.98 | 451200.0 |
| 2001-07-10 10:00:00 | CL | Stock | 28.955 | 28.99 | 28.83 | 28.855 | 637200.0 |
| 2001-07-10 11:00:00 | CL | Stock | 28.855 | 28.865 | 28.675 | 28.725 | 562600.0 |
| 2001-07-10 12:00:00 | CL | Stock | 28.725 | 28.775 | 28.625 | 28.745 | 576400.0 |
| 2001-07-10 13:00:00 | CL | Stock | 28.745 | 28.82 | 28.725 | 28.735 | 346000.0 |
| 2001-07-10 14:00:00 | CL | Stock | 28.735 | 28.83 | 28.5 | 28.775 | 768400.0 |
> showing 50 of 17,365 rows — these rows as CSV