PREVIEW / stock_1hour / 2004-11-22
file: by_date/stock_1hour/2004/2004-11-22.parquet size: 524 KB rows: 24,990 symbols: 1,877
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 |
|---|---|---|---|---|---|---|---|
| 2004-11-22 08:00:00 | AAPL | Stock | 1.027 | 1.0446 | 0.9839 | 1.0384 | 28730856.0 |
| 2004-11-22 09:00:00 | AAPL | Stock | 1.0375 | 1.0945 | 0.9884 | 1.0929 | 555652384.0 |
| 2004-11-22 10:00:00 | AAPL | Stock | 1.093 | 1.1295 | 1.0923 | 1.1038 | 720264496.0 |
| 2004-11-22 11:00:00 | AAPL | Stock | 1.1039 | 1.1039 | 1.0861 | 1.094 | 270797968.0 |
| 2004-11-22 12:00:00 | AAPL | Stock | 1.0934 | 1.0946 | 1.0748 | 1.0889 | 206639384.0 |
| 2004-11-22 13:00:00 | AAPL | Stock | 1.0891 | 1.0988 | 1.088 | 1.0916 | 169704192.0 |
| 2004-11-22 14:00:00 | AAPL | Stock | 1.0918 | 1.1034 | 1.0879 | 1.0979 | 182258104.0 |
| 2004-11-22 15:00:00 | AAPL | Stock | 1.0982 | 1.102 | 1.0868 | 1.0966 | 362512808.0 |
| 2004-11-22 16:00:00 | AAPL | Stock | 1.0957 | 1.0982 | 1.0895 | 1.0963 | 19629624.0 |
| 2004-11-22 17:00:00 | AAPL | Stock | 1.0959 | 1.098 | 1.0957 | 1.0973 | 1481312.0 |
| 2004-11-22 18:00:00 | AAPL | Stock | 1.097 | 1.0979 | 1.0959 | 1.0971 | 1305416.0 |
| 2004-11-22 08:00:00 | MSFT | Stock | 26.87 | 26.87 | 26.75 | 26.79 | 117476.0 |
| 2004-11-22 09:00:00 | MSFT | Stock | 26.79 | 26.85 | 26.7 | 26.78 | 8315595.0 |
| 2004-11-22 10:00:00 | MSFT | Stock | 26.77 | 26.78 | 26.38 | 26.45 | 23223799.0 |
| 2004-11-22 11:00:00 | MSFT | Stock | 26.46 | 26.48 | 24.87 | 26.34 | 14406376.0 |
| 2004-11-22 12:00:00 | MSFT | Stock | 26.34 | 26.5 | 26.26 | 26.48 | 10403919.0 |
| 2004-11-22 13:00:00 | MSFT | Stock | 26.48 | 26.6 | 26.47 | 26.6 | 10098725.0 |
| 2004-11-22 14:00:00 | MSFT | Stock | 26.6 | 26.68 | 26.53 | 26.56 | 10722816.0 |
| 2004-11-22 15:00:00 | MSFT | Stock | 26.56 | 26.65 | 26.52 | 26.64 | 9425000.0 |
| 2004-11-22 16:00:00 | MSFT | Stock | 26.64 | 26.68 | 26.32 | 26.62 | 1718649.0 |
| 2004-11-22 17:00:00 | MSFT | Stock | 26.63 | 26.65 | 26.58 | 26.6 | 79880.0 |
| 2004-11-22 18:00:00 | MSFT | Stock | 26.6 | 26.61 | 26.58 | 26.61 | 8572.0 |
| 2004-11-22 08:00:00 | NVDA | Stock | 0.1584 | 0.1604 | 0.1583 | 0.1592 | 3645600.0 |
| 2004-11-22 09:00:00 | NVDA | Stock | 0.1592 | 0.1608 | 0.1571 | 0.1598 | 160073760.0 |
| 2004-11-22 10:00:00 | NVDA | Stock | 0.16 | 0.1602 | 0.1587 | 0.1593 | 141550920.0 |
| 2004-11-22 11:00:00 | NVDA | Stock | 0.1594 | 0.1597 | 0.1588 | 0.1595 | 43088040.0 |
| 2004-11-22 12:00:00 | NVDA | Stock | 0.1595 | 0.1596 | 0.1589 | 0.1592 | 25948920.0 |
| 2004-11-22 13:00:00 | NVDA | Stock | 0.1592 | 0.16 | 0.1588 | 0.1588 | 41779680.0 |
| 2004-11-22 14:00:00 | NVDA | Stock | 0.1589 | 0.1595 | 0.1583 | 0.1587 | 65082360.0 |
| 2004-11-22 15:00:00 | NVDA | Stock | 0.1587 | 0.1625 | 0.1584 | 0.1622 | 216749880.0 |
| 2004-11-22 16:00:00 | NVDA | Stock | 0.1622 | 0.1625 | 0.1609 | 0.1622 | 17071800.0 |
| 2004-11-22 17:00:00 | NVDA | Stock | 0.162 | 0.1627 | 0.1613 | 0.1622 | 3640800.0 |
| 2004-11-22 18:00:00 | NVDA | Stock | 0.162 | 0.162 | 0.162 | 0.162 | 12000.0 |
| 2004-11-22 08:00:00 | AMZN | Stock | 1.9145 | 1.9175 | 1.9025 | 1.905 | 287000.0 |
| 2004-11-22 09:00:00 | AMZN | Stock | 1.9075 | 1.9215 | 1.9035 | 1.912 | 14823320.0 |
| 2004-11-22 10:00:00 | AMZN | Stock | 1.9115 | 1.92 | 1.905 | 1.919 | 17339300.0 |
| 2004-11-22 11:00:00 | AMZN | Stock | 1.919 | 1.9265 | 1.8955 | 1.8975 | 16664700.0 |
| 2004-11-22 12:00:00 | AMZN | Stock | 1.897 | 1.9005 | 1.879 | 1.89 | 27214840.0 |
| 2004-11-22 13:00:00 | AMZN | Stock | 1.89 | 1.9185 | 1.889 | 1.918 | 31540300.0 |
| 2004-11-22 14:00:00 | AMZN | Stock | 1.918 | 1.924 | 1.905 | 1.9095 | 26158020.0 |
| 2004-11-22 15:00:00 | AMZN | Stock | 1.91 | 1.9155 | 1.8995 | 1.904 | 29137980.0 |
| 2004-11-22 16:00:00 | AMZN | Stock | 1.9035 | 1.9045 | 1.894 | 1.9025 | 5464680.0 |
| 2004-11-22 17:00:00 | AMZN | Stock | 1.9045 | 1.9095 | 1.8925 | 1.9038 | 150400.0 |
| 2004-11-22 18:00:00 | AMZN | Stock | 1.8975 | 1.8975 | 1.8975 | 1.8975 | 2000.0 |
| 2004-11-22 09:00:00 | CL | Stock | 23.15 | 23.175 | 23.08 | 23.08 | 439000.0 |
| 2004-11-22 10:00:00 | CL | Stock | 23.08 | 23.1 | 23.0 | 23.075 | 713400.0 |
| 2004-11-22 11:00:00 | CL | Stock | 23.075 | 23.1 | 22.985 | 22.985 | 603000.0 |
| 2004-11-22 12:00:00 | CL | Stock | 22.985 | 22.99 | 22.875 | 22.98 | 723400.0 |
| 2004-11-22 13:00:00 | CL | Stock | 22.98 | 22.98 | 22.9315 | 22.98 | 752400.0 |
| 2004-11-22 14:00:00 | CL | Stock | 22.985 | 23.075 | 22.97 | 23.025 | 605200.0 |
> showing 50 of 24,990 rows — these rows as CSV