PREVIEW / stock_1hour / 2001-06-08
file: by_date/stock_1hour/2001/2001-06-08.parquet size: 329 KB rows: 15,252 symbols: 1,293
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-06-08 08:00:00 | AAPL | Stock | 0.3871 | 0.3873 | 0.3821 | 0.3821 | 369600.0 |
| 2001-06-08 09:00:00 | AAPL | Stock | 0.3866 | 0.3875 | 0.3705 | 0.3743 | 50176000.0 |
| 2001-06-08 10:00:00 | AAPL | Stock | 0.3748 | 0.3786 | 0.37 | 0.378 | 43607200.0 |
| 2001-06-08 11:00:00 | AAPL | Stock | 0.378 | 0.3791 | 0.373 | 0.3734 | 22780800.0 |
| 2001-06-08 12:00:00 | AAPL | Stock | 0.3734 | 0.3786 | 0.3698 | 0.3746 | 43416800.0 |
| 2001-06-08 13:00:00 | AAPL | Stock | 0.3745 | 0.3764 | 0.3727 | 0.3759 | 24567200.0 |
| 2001-06-08 14:00:00 | AAPL | Stock | 0.3757 | 0.3821 | 0.375 | 0.38 | 41703200.0 |
| 2001-06-08 15:00:00 | AAPL | Stock | 0.38 | 0.3823 | 0.3761 | 0.3807 | 69120800.0 |
| 2001-06-08 16:00:00 | AAPL | Stock | 0.3807 | 0.383 | 0.3788 | 0.3807 | 18569600.0 |
| 2001-06-08 17:00:00 | AAPL | Stock | 0.3834 | 0.3891 | 0.3807 | 0.3884 | 722400.0 |
| 2001-06-08 08:00:00 | MSFT | Stock | 36.8 | 37.28 | 36.65 | 36.86 | 337200.0 |
| 2001-06-08 09:00:00 | MSFT | Stock | 36.9 | 36.95 | 36.525 | 36.75 | 7674600.0 |
| 2001-06-08 10:00:00 | MSFT | Stock | 36.745 | 36.8 | 36.35 | 36.64 | 9286800.0 |
| 2001-06-08 11:00:00 | MSFT | Stock | 36.65 | 36.7 | 36.225 | 36.245 | 6823000.0 |
| 2001-06-08 12:00:00 | MSFT | Stock | 36.245 | 36.295 | 36.025 | 36.235 | 6592400.0 |
| 2001-06-08 13:00:00 | MSFT | Stock | 36.235 | 36.605 | 36.23 | 36.605 | 6099800.0 |
| 2001-06-08 14:00:00 | MSFT | Stock | 36.595 | 36.665 | 36.48 | 36.575 | 4134400.0 |
| 2001-06-08 15:00:00 | MSFT | Stock | 36.58 | 36.72 | 36.45 | 36.6 | 6455200.0 |
| 2001-06-08 16:00:00 | MSFT | Stock | 36.595 | 36.85 | 36.435 | 36.595 | 1471400.0 |
| 2001-06-08 17:00:00 | MSFT | Stock | 36.595 | 36.595 | 36.5 | 36.5 | 69200.0 |
| 2001-06-08 18:00:00 | MSFT | Stock | 36.56 | 36.56 | 36.55 | 36.55 | 400.0 |
| 2001-06-08 08:00:00 | NVDA | Stock | 0.4123 | 0.4167 | 0.4098 | 0.4121 | 3360000.0 |
| 2001-06-08 09:00:00 | NVDA | Stock | 0.4146 | 0.4146 | 0.401 | 0.405 | 185472000.0 |
| 2001-06-08 10:00:00 | NVDA | Stock | 0.4053 | 0.4092 | 0.401 | 0.4092 | 124584000.0 |
| 2001-06-08 11:00:00 | NVDA | Stock | 0.4092 | 0.4093 | 0.4033 | 0.404 | 99720000.0 |
| 2001-06-08 12:00:00 | NVDA | Stock | 0.404 | 0.4044 | 0.4008 | 0.4025 | 87408000.0 |
| 2001-06-08 13:00:00 | NVDA | Stock | 0.4024 | 0.405 | 0.3988 | 0.4016 | 41976000.0 |
| 2001-06-08 14:00:00 | NVDA | Stock | 0.4016 | 0.4073 | 0.4014 | 0.4035 | 50784000.0 |
| 2001-06-08 15:00:00 | NVDA | Stock | 0.4035 | 0.4043 | 0.3991 | 0.4034 | 66144000.0 |
| 2001-06-08 16:00:00 | NVDA | Stock | 0.4034 | 0.4037 | 0.4021 | 0.4031 | 7392000.0 |
| 2001-06-08 17:00:00 | NVDA | Stock | 0.4031 | 0.4037 | 0.4031 | 0.4037 | 528000.0 |
| 2001-06-08 18:00:00 | NVDA | Stock | 0.4037 | 0.4037 | 0.4037 | 0.4037 | 24000.0 |
| 2001-06-08 08:00:00 | AMZN | Stock | 0.7975 | 0.8275 | 0.7975 | 0.8125 | 256000.0 |
| 2001-06-08 09:00:00 | AMZN | Stock | 0.815 | 0.82 | 0.8 | 0.811 | 5790000.0 |
| 2001-06-08 10:00:00 | AMZN | Stock | 0.811 | 0.8165 | 0.7925 | 0.8135 | 6790000.0 |
| 2001-06-08 11:00:00 | AMZN | Stock | 0.8105 | 0.813 | 0.806 | 0.8075 | 3402000.0 |
| 2001-06-08 12:00:00 | AMZN | Stock | 0.808 | 0.8085 | 0.795 | 0.7955 | 9232000.0 |
| 2001-06-08 13:00:00 | AMZN | Stock | 0.7955 | 0.798 | 0.7825 | 0.7875 | 5772000.0 |
| 2001-06-08 14:00:00 | AMZN | Stock | 0.7875 | 0.7995 | 0.7855 | 0.7965 | 4652000.0 |
| 2001-06-08 15:00:00 | AMZN | Stock | 0.797 | 0.8015 | 0.785 | 0.7855 | 8118000.0 |
| 2001-06-08 16:00:00 | AMZN | Stock | 0.785 | 0.805 | 0.78 | 0.785 | 2844000.0 |
| 2001-06-08 17:00:00 | AMZN | Stock | 0.785 | 0.785 | 0.785 | 0.785 | 120000.0 |
| 2001-06-08 09:00:00 | CL | Stock | 29.35 | 29.4 | 29.2 | 29.3 | 112000.0 |
| 2001-06-08 10:00:00 | CL | Stock | 29.295 | 29.3 | 29.25 | 29.255 | 94600.0 |
| 2001-06-08 11:00:00 | CL | Stock | 29.255 | 29.29 | 29.1 | 29.11 | 258600.0 |
| 2001-06-08 12:00:00 | CL | Stock | 29.1 | 29.375 | 29.05 | 29.295 | 497000.0 |
| 2001-06-08 13:00:00 | CL | Stock | 29.305 | 29.375 | 29.3 | 29.345 | 226600.0 |
| 2001-06-08 14:00:00 | CL | Stock | 29.36 | 29.475 | 29.325 | 29.37 | 286600.0 |
| 2001-06-08 15:00:00 | CL | Stock | 29.37 | 29.48 | 29.36 | 29.435 | 636800.0 |
| 2001-06-08 16:00:00 | CL | Stock | 29.435 | 29.435 | 29.335 | 29.435 | 51600.0 |
> showing 50 of 15,252 rows — these rows as CSV