PREVIEW / stock_1hour / 2002-12-31
file: by_date/stock_1hour/2002/2002-12-31.parquet size: 445 KB rows: 21,602 symbols: 1,545
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 |
|---|---|---|---|---|---|---|---|
| 2002-12-31 09:00:00 | AAPL | Stock | 0.2509 | 0.2536 | 0.25 | 0.252 | 14449568.0 |
| 2002-12-31 10:00:00 | AAPL | Stock | 0.2518 | 0.2518 | 0.2491 | 0.25 | 20096944.0 |
| 2002-12-31 11:00:00 | AAPL | Stock | 0.25 | 0.2523 | 0.2491 | 0.2523 | 16946832.0 |
| 2002-12-31 12:00:00 | AAPL | Stock | 0.2521 | 0.2523 | 0.2502 | 0.2514 | 10907736.0 |
| 2002-12-31 13:00:00 | AAPL | Stock | 0.2514 | 0.2539 | 0.2511 | 0.2539 | 20796440.0 |
| 2002-12-31 14:00:00 | AAPL | Stock | 0.2539 | 0.2564 | 0.2539 | 0.2559 | 38591504.0 |
| 2002-12-31 15:00:00 | AAPL | Stock | 0.2559 | 0.2564 | 0.2546 | 0.2561 | 49036344.0 |
| 2002-12-31 16:00:00 | AAPL | Stock | 0.2561 | 0.2588 | 0.2543 | 0.2559 | 9463440.0 |
| 2002-12-31 17:00:00 | AAPL | Stock | 0.2546 | 0.2559 | 0.2545 | 0.2545 | 285600.0 |
| 2002-12-31 18:00:00 | AAPL | Stock | 0.2568 | 0.2568 | 0.2568 | 0.2568 | 5600.0 |
| 2002-12-31 08:00:00 | MSFT | Stock | 26.39 | 26.715 | 26.375 | 26.4005 | 38726.0 |
| 2002-12-31 09:00:00 | MSFT | Stock | 26.4 | 26.495 | 26.255 | 26.32 | 4485624.0 |
| 2002-12-31 10:00:00 | MSFT | Stock | 26.32 | 26.32 | 25.955 | 26.005 | 9502020.0 |
| 2002-12-31 11:00:00 | MSFT | Stock | 26.015 | 26.09 | 25.875 | 26.025 | 6955910.0 |
| 2002-12-31 12:00:00 | MSFT | Stock | 26.03 | 26.095 | 25.96 | 25.976 | 4350932.0 |
| 2002-12-31 13:00:00 | MSFT | Stock | 25.9845 | 26.075 | 25.803 | 25.845 | 5462228.0 |
| 2002-12-31 14:00:00 | MSFT | Stock | 25.845 | 25.93 | 25.755 | 25.89 | 5325184.0 |
| 2002-12-31 15:00:00 | MSFT | Stock | 25.89 | 25.925 | 25.63 | 25.855 | 11565642.0 |
| 2002-12-31 16:00:00 | MSFT | Stock | 25.88 | 25.89 | 25.7465 | 25.835 | 3519060.0 |
| 2002-12-31 17:00:00 | MSFT | Stock | 25.85 | 25.85 | 25.8 | 25.815 | 226600.0 |
| 2002-12-31 18:00:00 | MSFT | Stock | 25.825 | 25.835 | 25.825 | 25.825 | 2300.0 |
| 2002-12-31 08:00:00 | NVDA | Stock | 0.0958 | 0.0963 | 0.0958 | 0.0963 | 1819200.0 |
| 2002-12-31 09:00:00 | NVDA | Stock | 0.0963 | 0.0979 | 0.0942 | 0.0958 | 115204800.0 |
| 2002-12-31 10:00:00 | NVDA | Stock | 0.0958 | 0.0967 | 0.0932 | 0.0946 | 122913600.0 |
| 2002-12-31 11:00:00 | NVDA | Stock | 0.0946 | 0.0958 | 0.0942 | 0.0957 | 57622920.0 |
| 2002-12-31 12:00:00 | NVDA | Stock | 0.0957 | 0.0976 | 0.0953 | 0.0972 | 99200280.0 |
| 2002-12-31 13:00:00 | NVDA | Stock | 0.0971 | 0.0983 | 0.0962 | 0.0965 | 112455600.0 |
| 2002-12-31 14:00:00 | NVDA | Stock | 0.0964 | 0.0975 | 0.0961 | 0.0968 | 105782160.0 |
| 2002-12-31 15:00:00 | NVDA | Stock | 0.0968 | 0.0973 | 0.0954 | 0.0959 | 113973600.0 |
| 2002-12-31 16:00:00 | NVDA | Stock | 0.0958 | 0.0966 | 0.0955 | 0.0959 | 22921560.0 |
| 2002-12-31 17:00:00 | NVDA | Stock | 0.0961 | 0.0962 | 0.0959 | 0.0962 | 1314960.0 |
| 2002-12-31 18:00:00 | NVDA | Stock | 0.0962 | 0.0962 | 0.0962 | 0.0962 | 84000.0 |
| 2002-12-31 08:00:00 | AMZN | Stock | 0.9626 | 0.9626 | 0.9626 | 0.9626 | 4000.0 |
| 2002-12-31 09:00:00 | AMZN | Stock | 0.964 | 0.978 | 0.9605 | 0.975 | 13924120.0 |
| 2002-12-31 10:00:00 | AMZN | Stock | 0.975 | 0.9775 | 0.9415 | 0.9505 | 25811680.0 |
| 2002-12-31 11:00:00 | AMZN | Stock | 0.9505 | 0.957 | 0.944 | 0.955 | 11363260.0 |
| 2002-12-31 12:00:00 | AMZN | Stock | 0.9545 | 0.958 | 0.9515 | 0.958 | 8660480.0 |
| 2002-12-31 13:00:00 | AMZN | Stock | 0.9575 | 0.9615 | 0.9555 | 0.956 | 7899900.0 |
| 2002-12-31 14:00:00 | AMZN | Stock | 0.9565 | 0.9635 | 0.956 | 0.96 | 5189580.0 |
| 2002-12-31 15:00:00 | AMZN | Stock | 0.9595 | 0.9645 | 0.9435 | 0.9455 | 24164740.0 |
| 2002-12-31 16:00:00 | AMZN | Stock | 0.9445 | 0.9464 | 0.94 | 0.9425 | 3322060.0 |
| 2002-12-31 17:00:00 | AMZN | Stock | 0.9425 | 0.9425 | 0.9425 | 0.9425 | 90000.0 |
| 2002-12-31 18:00:00 | AMZN | Stock | 0.9406 | 0.9435 | 0.9405 | 0.9435 | 52000.0 |
| 2002-12-31 09:00:00 | CL | Stock | 26.04 | 26.1 | 25.975 | 26.0 | 178600.0 |
| 2002-12-31 10:00:00 | CL | Stock | 26.015 | 26.015 | 25.795 | 25.935 | 310400.0 |
| 2002-12-31 11:00:00 | CL | Stock | 25.935 | 26.065 | 25.885 | 26.025 | 249400.0 |
| 2002-12-31 12:00:00 | CL | Stock | 26.015 | 26.165 | 26.005 | 26.105 | 204200.0 |
| 2002-12-31 13:00:00 | CL | Stock | 26.12 | 26.23 | 26.1 | 26.22 | 202600.0 |
| 2002-12-31 14:00:00 | CL | Stock | 26.225 | 26.27 | 26.21 | 26.255 | 187200.0 |
| 2002-12-31 15:00:00 | CL | Stock | 26.265 | 26.295 | 26.165 | 26.19 | 281400.0 |
> showing 50 of 21,602 rows — these rows as CSV