PREVIEW / stock_1hour / 2003-12-29
file: by_date/stock_1hour/2003/2003-12-29.parquet size: 494 KB rows: 23,456 symbols: 1,716
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 |
|---|---|---|---|---|---|---|---|
| 2003-12-29 08:00:00 | AAPL | Stock | 0.372 | 0.372 | 0.372 | 0.372 | 11200.0 |
| 2003-12-29 09:00:00 | AAPL | Stock | 0.3723 | 0.3768 | 0.3716 | 0.3755 | 36854216.0 |
| 2003-12-29 10:00:00 | AAPL | Stock | 0.3755 | 0.3777 | 0.375 | 0.3754 | 41028232.0 |
| 2003-12-29 11:00:00 | AAPL | Stock | 0.3754 | 0.3764 | 0.3741 | 0.3763 | 29494360.0 |
| 2003-12-29 12:00:00 | AAPL | Stock | 0.3763 | 0.3766 | 0.375 | 0.3752 | 17623088.0 |
| 2003-12-29 13:00:00 | AAPL | Stock | 0.3752 | 0.3754 | 0.3732 | 0.3734 | 18363576.0 |
| 2003-12-29 14:00:00 | AAPL | Stock | 0.3732 | 0.375 | 0.3725 | 0.373 | 23668008.0 |
| 2003-12-29 15:00:00 | AAPL | Stock | 0.373 | 0.3768 | 0.3727 | 0.3754 | 44639784.0 |
| 2003-12-29 16:00:00 | AAPL | Stock | 0.3757 | 0.3779 | 0.3736 | 0.3761 | 6687352.0 |
| 2003-12-29 17:00:00 | AAPL | Stock | 0.3777 | 0.3777 | 0.376 | 0.376 | 337344.0 |
| 2003-12-29 08:00:00 | MSFT | Stock | 27.21 | 27.41 | 27.21 | 27.3 | 39941.0 |
| 2003-12-29 09:00:00 | MSFT | Stock | 27.3 | 27.42 | 27.16 | 27.39 | 5239339.0 |
| 2003-12-29 10:00:00 | MSFT | Stock | 27.39 | 27.49 | 27.38 | 27.421 | 6363288.0 |
| 2003-12-29 11:00:00 | MSFT | Stock | 27.42 | 27.48 | 27.37 | 27.43 | 3205429.0 |
| 2003-12-29 12:00:00 | MSFT | Stock | 27.44 | 27.45 | 27.38 | 27.39 | 2976628.0 |
| 2003-12-29 13:00:00 | MSFT | Stock | 27.4 | 27.47 | 27.39 | 27.46 | 3803531.0 |
| 2003-12-29 14:00:00 | MSFT | Stock | 27.46 | 27.49 | 27.39 | 27.39 | 4668365.0 |
| 2003-12-29 15:00:00 | MSFT | Stock | 27.39 | 27.5 | 27.39 | 27.48 | 9146651.0 |
| 2003-12-29 16:00:00 | MSFT | Stock | 27.49 | 27.53 | 27.4 | 27.49 | 2000374.0 |
| 2003-12-29 17:00:00 | MSFT | Stock | 27.5 | 27.5 | 27.339 | 27.46 | 66343.0 |
| 2003-12-29 18:00:00 | MSFT | Stock | 27.46 | 27.46 | 27.46 | 27.46 | 1237.0 |
| 2003-12-29 08:00:00 | NVDA | Stock | 0.1912 | 0.2004 | 0.1912 | 0.1933 | 3309000.0 |
| 2003-12-29 09:00:00 | NVDA | Stock | 0.1933 | 0.1972 | 0.1917 | 0.1947 | 212039640.0 |
| 2003-12-29 10:00:00 | NVDA | Stock | 0.1948 | 0.1954 | 0.1929 | 0.1936 | 119570160.0 |
| 2003-12-29 11:00:00 | NVDA | Stock | 0.1934 | 0.1957 | 0.1932 | 0.1956 | 68790720.0 |
| 2003-12-29 12:00:00 | NVDA | Stock | 0.1956 | 0.1963 | 0.195 | 0.1961 | 58251720.0 |
| 2003-12-29 13:00:00 | NVDA | Stock | 0.1959 | 0.197 | 0.1959 | 0.1964 | 47737080.0 |
| 2003-12-29 14:00:00 | NVDA | Stock | 0.1965 | 0.1974 | 0.1955 | 0.1958 | 83061360.0 |
| 2003-12-29 15:00:00 | NVDA | Stock | 0.1958 | 0.1982 | 0.1952 | 0.1974 | 133975680.0 |
| 2003-12-29 16:00:00 | NVDA | Stock | 0.1974 | 0.1983 | 0.197 | 0.1976 | 5827320.0 |
| 2003-12-29 17:00:00 | NVDA | Stock | 0.1977 | 0.1978 | 0.1975 | 0.1975 | 444600.0 |
| 2003-12-29 18:00:00 | NVDA | Stock | 0.1975 | 0.1975 | 0.1975 | 0.1975 | 72000.0 |
| 2003-12-29 08:00:00 | AMZN | Stock | 2.7 | 2.7 | 2.675 | 2.693 | 244000.0 |
| 2003-12-29 09:00:00 | AMZN | Stock | 2.693 | 2.693 | 2.6065 | 2.6335 | 43452840.0 |
| 2003-12-29 10:00:00 | AMZN | Stock | 2.6334 | 2.673 | 2.6235 | 2.6695 | 33781100.0 |
| 2003-12-29 11:00:00 | AMZN | Stock | 2.6695 | 2.671 | 2.642 | 2.646 | 19613080.0 |
| 2003-12-29 12:00:00 | AMZN | Stock | 2.646 | 2.653 | 2.6385 | 2.6405 | 12492400.0 |
| 2003-12-29 13:00:00 | AMZN | Stock | 2.6408 | 2.6595 | 2.64 | 2.6585 | 10711880.0 |
| 2003-12-29 14:00:00 | AMZN | Stock | 2.6585 | 2.6725 | 2.6578 | 2.6625 | 11797160.0 |
| 2003-12-29 15:00:00 | AMZN | Stock | 2.662 | 2.6735 | 2.6595 | 2.6735 | 22007220.0 |
| 2003-12-29 16:00:00 | AMZN | Stock | 2.6735 | 2.679 | 2.6675 | 2.6735 | 1336820.0 |
| 2003-12-29 17:00:00 | AMZN | Stock | 2.675 | 2.675 | 2.6705 | 2.6705 | 324320.0 |
| 2003-12-29 18:00:00 | AMZN | Stock | 2.6705 | 2.671 | 2.6665 | 2.667 | 34000.0 |
| 2003-12-29 09:00:00 | CL | Stock | 24.575 | 24.805 | 24.575 | 24.795 | 666000.0 |
| 2003-12-29 10:00:00 | CL | Stock | 24.8 | 24.905 | 24.78 | 24.84 | 864000.0 |
| 2003-12-29 11:00:00 | CL | Stock | 24.845 | 24.85 | 24.8 | 24.83 | 433600.0 |
| 2003-12-29 12:00:00 | CL | Stock | 24.825 | 24.835 | 24.77 | 24.81 | 467600.0 |
| 2003-12-29 13:00:00 | CL | Stock | 24.815 | 24.885 | 24.795 | 24.865 | 480400.0 |
| 2003-12-29 14:00:00 | CL | Stock | 24.865 | 24.92 | 24.83 | 24.86 | 468200.0 |
| 2003-12-29 15:00:00 | CL | Stock | 24.85 | 24.985 | 24.85 | 24.98 | 909200.0 |
> showing 50 of 23,456 rows — these rows as CSV