PREVIEW / stock_1hour / 2004-10-21
file: by_date/stock_1hour/2004/2004-10-21.parquet size: 530 KB rows: 25,576 symbols: 1,846
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-10-21 08:00:00 | AAPL | Stock | 0.8443 | 0.8518 | 0.842 | 0.8482 | 182560.0 |
| 2004-10-21 09:00:00 | AAPL | Stock | 0.8488 | 0.8595 | 0.842 | 0.8564 | 93707152.0 |
| 2004-10-21 10:00:00 | AAPL | Stock | 0.8568 | 0.8588 | 0.8495 | 0.8554 | 76249656.0 |
| 2004-10-21 11:00:00 | AAPL | Stock | 0.8554 | 0.8561 | 0.8525 | 0.8555 | 45712576.0 |
| 2004-10-21 12:00:00 | AAPL | Stock | 0.8555 | 0.8579 | 0.8514 | 0.8536 | 69209560.0 |
| 2004-10-21 13:00:00 | AAPL | Stock | 0.8536 | 0.855 | 0.8521 | 0.8527 | 34912584.0 |
| 2004-10-21 14:00:00 | AAPL | Stock | 0.8529 | 0.8563 | 0.8523 | 0.8559 | 51125928.0 |
| 2004-10-21 15:00:00 | AAPL | Stock | 0.8554 | 0.857 | 0.8525 | 0.8554 | 219228296.0 |
| 2004-10-21 16:00:00 | AAPL | Stock | 0.8554 | 0.8607 | 0.8509 | 0.8529 | 33298048.0 |
| 2004-10-21 17:00:00 | AAPL | Stock | 0.8561 | 0.8561 | 0.8509 | 0.8509 | 1189384.0 |
| 2004-10-21 18:00:00 | AAPL | Stock | 0.8527 | 0.8561 | 0.8527 | 0.8545 | 259504.0 |
| 2004-10-21 08:00:00 | MSFT | Stock | 28.83 | 28.98 | 28.7 | 28.86 | 62538.0 |
| 2004-10-21 09:00:00 | MSFT | Stock | 28.87 | 28.94 | 28.55 | 28.76 | 8677218.0 |
| 2004-10-21 10:00:00 | MSFT | Stock | 28.77 | 28.86 | 28.68 | 28.72 | 10738975.0 |
| 2004-10-21 11:00:00 | MSFT | Stock | 28.729 | 28.78 | 28.61 | 28.71 | 7873248.0 |
| 2004-10-21 12:00:00 | MSFT | Stock | 28.71 | 28.78 | 28.5799 | 28.59 | 7247497.0 |
| 2004-10-21 13:00:00 | MSFT | Stock | 28.59 | 28.64 | 28.48 | 28.52 | 6872569.0 |
| 2004-10-21 14:00:00 | MSFT | Stock | 28.52 | 28.88 | 28.51 | 28.87 | 11361123.0 |
| 2004-10-21 15:00:00 | MSFT | Stock | 28.87 | 28.89 | 28.47 | 28.55 | 30309160.0 |
| 2004-10-21 16:00:00 | MSFT | Stock | 28.56 | 28.67 | 25.5 | 27.95 | 8886540.0 |
| 2004-10-21 17:00:00 | MSFT | Stock | 27.97 | 28.58 | 27.75 | 27.95 | 978715.0 |
| 2004-10-21 18:00:00 | MSFT | Stock | 27.95 | 28.57 | 27.94 | 28.1 | 391079.0 |
| 2004-10-21 08:00:00 | NVDA | Stock | 0.1142 | 0.1166 | 0.1142 | 0.1166 | 60000.0 |
| 2004-10-21 09:00:00 | NVDA | Stock | 0.1148 | 0.1166 | 0.1142 | 0.1159 | 114840240.0 |
| 2004-10-21 10:00:00 | NVDA | Stock | 0.1158 | 0.1161 | 0.1147 | 0.1158 | 116974920.0 |
| 2004-10-21 11:00:00 | NVDA | Stock | 0.1159 | 0.1162 | 0.1152 | 0.1157 | 127691160.0 |
| 2004-10-21 12:00:00 | NVDA | Stock | 0.1159 | 0.1162 | 0.1154 | 0.1162 | 120465240.0 |
| 2004-10-21 13:00:00 | NVDA | Stock | 0.116 | 0.1162 | 0.1157 | 0.116 | 56963520.0 |
| 2004-10-21 14:00:00 | NVDA | Stock | 0.116 | 0.1177 | 0.1159 | 0.1174 | 171082560.0 |
| 2004-10-21 15:00:00 | NVDA | Stock | 0.1174 | 0.1185 | 0.1168 | 0.1171 | 252494160.0 |
| 2004-10-21 16:00:00 | NVDA | Stock | 0.1169 | 0.1171 | 0.1162 | 0.1165 | 19247040.0 |
| 2004-10-21 17:00:00 | NVDA | Stock | 0.1162 | 0.1169 | 0.1162 | 0.1169 | 149880.0 |
| 2004-10-21 18:00:00 | NVDA | Stock | 0.1169 | 0.117 | 0.1162 | 0.1162 | 278880.0 |
| 2004-10-21 08:00:00 | AMZN | Stock | 1.95 | 1.9725 | 1.95 | 1.97 | 1475840.0 |
| 2004-10-21 09:00:00 | AMZN | Stock | 1.97 | 1.974 | 1.928 | 1.94 | 39785340.0 |
| 2004-10-21 10:00:00 | AMZN | Stock | 1.9395 | 1.9595 | 1.925 | 1.957 | 57264880.0 |
| 2004-10-21 11:00:00 | AMZN | Stock | 1.957 | 1.96 | 1.943 | 1.9455 | 25578440.0 |
| 2004-10-21 12:00:00 | AMZN | Stock | 1.9455 | 1.9585 | 1.9425 | 1.958 | 16754360.0 |
| 2004-10-21 13:00:00 | AMZN | Stock | 1.9585 | 1.9675 | 1.9535 | 1.9615 | 26411160.0 |
| 2004-10-21 14:00:00 | AMZN | Stock | 1.962 | 2.0095 | 1.9615 | 2.006 | 54482900.0 |
| 2004-10-21 15:00:00 | AMZN | Stock | 2.006 | 2.009 | 1.972 | 1.976 | 74349240.0 |
| 2004-10-21 16:00:00 | AMZN | Stock | 1.976 | 2.087 | 1.795 | 1.813 | 74291440.0 |
| 2004-10-21 17:00:00 | AMZN | Stock | 1.8125 | 1.9768 | 1.79 | 1.8125 | 9188080.0 |
| 2004-10-21 18:00:00 | AMZN | Stock | 1.8125 | 1.9735 | 1.797 | 1.797 | 2554360.0 |
| 2004-10-21 08:00:00 | CL | Stock | 22.805 | 23.0 | 22.805 | 22.885 | 9800.0 |
| 2004-10-21 09:00:00 | CL | Stock | 22.83 | 23.09 | 22.8 | 22.91 | 2984800.0 |
| 2004-10-21 10:00:00 | CL | Stock | 22.91 | 23.02 | 22.815 | 22.905 | 3094600.0 |
| 2004-10-21 11:00:00 | CL | Stock | 22.91 | 22.955 | 22.87 | 22.875 | 1294800.0 |
| 2004-10-21 12:00:00 | CL | Stock | 22.875 | 22.93 | 22.8 | 22.815 | 1440200.0 |
| 2004-10-21 13:00:00 | CL | Stock | 22.815 | 22.89 | 22.8 | 22.815 | 673200.0 |
> showing 50 of 25,576 rows — these rows as CSV