PREVIEW / stock_1hour / 2002-12-09
file: by_date/stock_1hour/2002/2002-12-09.parquet size: 417 KB rows: 19,950 symbols: 1,531
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-09 09:00:00 | AAPL | Stock | 0.2668 | 0.267 | 0.2645 | 0.267 | 17048864.0 |
| 2002-12-09 10:00:00 | AAPL | Stock | 0.267 | 0.267 | 0.2627 | 0.2627 | 32347224.0 |
| 2002-12-09 11:00:00 | AAPL | Stock | 0.2627 | 0.2643 | 0.2621 | 0.2625 | 30127272.0 |
| 2002-12-09 12:00:00 | AAPL | Stock | 0.2625 | 0.2652 | 0.262 | 0.2645 | 25119024.0 |
| 2002-12-09 13:00:00 | AAPL | Stock | 0.2645 | 0.2646 | 0.2621 | 0.2627 | 12097568.0 |
| 2002-12-09 14:00:00 | AAPL | Stock | 0.2627 | 0.2652 | 0.262 | 0.2636 | 23661456.0 |
| 2002-12-09 15:00:00 | AAPL | Stock | 0.2634 | 0.2652 | 0.263 | 0.2634 | 61917688.0 |
| 2002-12-09 16:00:00 | AAPL | Stock | 0.2634 | 0.265 | 0.2611 | 0.2634 | 9303000.0 |
| 2002-12-09 17:00:00 | AAPL | Stock | 0.2634 | 0.2634 | 0.2634 | 0.2634 | 487200.0 |
| 2002-12-09 08:00:00 | MSFT | Stock | 27.66 | 27.73 | 27.5 | 27.545 | 27064.0 |
| 2002-12-09 09:00:00 | MSFT | Stock | 27.54 | 27.73 | 27.275 | 27.58 | 8003444.0 |
| 2002-12-09 10:00:00 | MSFT | Stock | 27.577 | 27.61 | 27.125 | 27.16 | 11025442.0 |
| 2002-12-09 11:00:00 | MSFT | Stock | 27.16 | 27.26 | 27.06 | 27.125 | 9779628.0 |
| 2002-12-09 12:00:00 | MSFT | Stock | 27.125 | 27.245 | 27.055 | 27.235 | 4491598.0 |
| 2002-12-09 13:00:00 | MSFT | Stock | 27.2395 | 27.25 | 27.04 | 27.065 | 3494852.0 |
| 2002-12-09 14:00:00 | MSFT | Stock | 27.06 | 27.305 | 27.06 | 27.085 | 6536218.0 |
| 2002-12-09 15:00:00 | MSFT | Stock | 27.1 | 27.2 | 26.755 | 26.765 | 11764432.0 |
| 2002-12-09 16:00:00 | MSFT | Stock | 26.755 | 26.835 | 26.6 | 26.66 | 2494478.0 |
| 2002-12-09 17:00:00 | MSFT | Stock | 26.66 | 26.765 | 26.655 | 26.66 | 322140.0 |
| 2002-12-09 18:00:00 | MSFT | Stock | 26.675 | 26.7 | 26.65 | 26.65 | 23200.0 |
| 2002-12-09 08:00:00 | NVDA | Stock | 0.1157 | 0.1158 | 0.1139 | 0.1149 | 2293320.0 |
| 2002-12-09 09:00:00 | NVDA | Stock | 0.1142 | 0.1174 | 0.1133 | 0.1152 | 138833040.0 |
| 2002-12-09 10:00:00 | NVDA | Stock | 0.1152 | 0.1152 | 0.1126 | 0.1127 | 147522240.0 |
| 2002-12-09 11:00:00 | NVDA | Stock | 0.1126 | 0.1127 | 0.1094 | 0.1104 | 147731160.0 |
| 2002-12-09 12:00:00 | NVDA | Stock | 0.1104 | 0.111 | 0.1097 | 0.1106 | 100555440.0 |
| 2002-12-09 13:00:00 | NVDA | Stock | 0.1106 | 0.111 | 0.1092 | 0.1093 | 87003480.0 |
| 2002-12-09 14:00:00 | NVDA | Stock | 0.1093 | 0.1111 | 0.1089 | 0.1101 | 93435480.0 |
| 2002-12-09 15:00:00 | NVDA | Stock | 0.1101 | 0.1101 | 0.1074 | 0.1082 | 161595000.0 |
| 2002-12-09 16:00:00 | NVDA | Stock | 0.1081 | 0.1084 | 0.1077 | 0.1078 | 17058000.0 |
| 2002-12-09 17:00:00 | NVDA | Stock | 0.1083 | 0.1086 | 0.1078 | 0.1086 | 2098560.0 |
| 2002-12-09 18:00:00 | NVDA | Stock | 0.1084 | 0.1095 | 0.1084 | 0.1091 | 472200.0 |
| 2002-12-09 08:00:00 | AMZN | Stock | 1.1225 | 1.1225 | 1.1165 | 1.1165 | 30000.0 |
| 2002-12-09 09:00:00 | AMZN | Stock | 1.1155 | 1.1275 | 1.1005 | 1.1055 | 11828020.0 |
| 2002-12-09 10:00:00 | AMZN | Stock | 1.1055 | 1.1055 | 1.086 | 1.0889 | 28918460.0 |
| 2002-12-09 11:00:00 | AMZN | Stock | 1.088 | 1.0915 | 1.083 | 1.0865 | 15461220.0 |
| 2002-12-09 12:00:00 | AMZN | Stock | 1.0865 | 1.0925 | 1.085 | 1.0915 | 11815620.0 |
| 2002-12-09 13:00:00 | AMZN | Stock | 1.0915 | 1.0955 | 1.0892 | 1.0915 | 10737560.0 |
| 2002-12-09 14:00:00 | AMZN | Stock | 1.091 | 1.093 | 1.0875 | 1.089 | 21001760.0 |
| 2002-12-09 15:00:00 | AMZN | Stock | 1.089 | 1.0895 | 1.08 | 1.086 | 25686720.0 |
| 2002-12-09 16:00:00 | AMZN | Stock | 1.084 | 1.0895 | 1.083 | 1.0865 | 1577380.0 |
| 2002-12-09 17:00:00 | AMZN | Stock | 1.084 | 1.088 | 1.0815 | 1.085 | 441400.0 |
| 2002-12-09 18:00:00 | AMZN | Stock | 1.085 | 1.088 | 1.085 | 1.088 | 36000.0 |
| 2002-12-09 09:00:00 | CL | Stock | 26.78 | 26.875 | 26.535 | 26.725 | 304600.0 |
| 2002-12-09 10:00:00 | CL | Stock | 26.73 | 26.75 | 26.65 | 26.65 | 486600.0 |
| 2002-12-09 11:00:00 | CL | Stock | 26.64 | 26.725 | 26.595 | 26.625 | 243000.0 |
| 2002-12-09 12:00:00 | CL | Stock | 26.635 | 26.7 | 26.525 | 26.68 | 289400.0 |
| 2002-12-09 13:00:00 | CL | Stock | 26.68 | 26.745 | 26.655 | 26.68 | 348200.0 |
| 2002-12-09 14:00:00 | CL | Stock | 26.685 | 26.875 | 26.685 | 26.83 | 427800.0 |
| 2002-12-09 15:00:00 | CL | Stock | 26.82 | 26.9 | 26.75 | 26.8 | 812600.0 |
| 2002-12-09 16:00:00 | CL | Stock | 26.825 | 26.825 | 26.815 | 26.825 | 209000.0 |
> showing 50 of 19,950 rows — these rows as CSV