PREVIEW / stock_1hour / 2002-12-04
file: by_date/stock_1hour/2002/2002-12-04.parquet size: 426 KB rows: 19,727 symbols: 1,512
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-04 08:00:00 | AAPL | Stock | 0.2713 | 0.2754 | 0.2679 | 0.2679 | 1075200.0 |
| 2002-12-04 09:00:00 | AAPL | Stock | 0.2679 | 0.2713 | 0.2627 | 0.2659 | 51190160.0 |
| 2002-12-04 10:00:00 | AAPL | Stock | 0.2661 | 0.2682 | 0.2614 | 0.2627 | 59562776.0 |
| 2002-12-04 11:00:00 | AAPL | Stock | 0.2625 | 0.2634 | 0.2589 | 0.263 | 39457152.0 |
| 2002-12-04 12:00:00 | AAPL | Stock | 0.2627 | 0.2663 | 0.2627 | 0.2659 | 19835032.0 |
| 2002-12-04 13:00:00 | AAPL | Stock | 0.2659 | 0.2664 | 0.2614 | 0.2616 | 15671936.0 |
| 2002-12-04 14:00:00 | AAPL | Stock | 0.262 | 0.2711 | 0.2616 | 0.27 | 40327896.0 |
| 2002-12-04 15:00:00 | AAPL | Stock | 0.2696 | 0.2709 | 0.2663 | 0.2675 | 35495544.0 |
| 2002-12-04 16:00:00 | AAPL | Stock | 0.2671 | 0.2698 | 0.2648 | 0.2671 | 32075792.0 |
| 2002-12-04 17:00:00 | AAPL | Stock | 0.2671 | 0.2673 | 0.2652 | 0.2673 | 1008000.0 |
| 2002-12-04 08:00:00 | MSFT | Stock | 28.2005 | 28.225 | 28.106 | 28.115 | 159890.0 |
| 2002-12-04 09:00:00 | MSFT | Stock | 28.106 | 28.335 | 27.97 | 28.075 | 8981210.0 |
| 2002-12-04 10:00:00 | MSFT | Stock | 28.075 | 28.415 | 28.025 | 28.17 | 14453432.0 |
| 2002-12-04 11:00:00 | MSFT | Stock | 28.165 | 28.17 | 27.975 | 28.115 | 10289372.0 |
| 2002-12-04 12:00:00 | MSFT | Stock | 28.115 | 28.21 | 28.075 | 28.185 | 4744754.0 |
| 2002-12-04 13:00:00 | MSFT | Stock | 28.185 | 28.25 | 27.94 | 27.9405 | 5400270.0 |
| 2002-12-04 14:00:00 | MSFT | Stock | 27.941 | 28.535 | 27.91 | 28.485 | 13229320.0 |
| 2002-12-04 15:00:00 | MSFT | Stock | 28.485 | 28.72 | 28.255 | 28.28 | 17575452.0 |
| 2002-12-04 16:00:00 | MSFT | Stock | 28.3 | 28.35 | 28.09 | 28.325 | 1394356.0 |
| 2002-12-04 17:00:00 | MSFT | Stock | 28.325 | 28.35 | 28.27 | 28.28 | 32200.0 |
| 2002-12-04 18:00:00 | MSFT | Stock | 28.295 | 28.295 | 28.295 | 28.295 | 600.0 |
| 2002-12-04 08:00:00 | NVDA | Stock | 0.1282 | 0.1282 | 0.1268 | 0.1268 | 2296200.0 |
| 2002-12-04 09:00:00 | NVDA | Stock | 0.1273 | 0.1323 | 0.1161 | 0.1186 | 431354400.0 |
| 2002-12-04 10:00:00 | NVDA | Stock | 0.1186 | 0.1201 | 0.1167 | 0.118 | 427622040.0 |
| 2002-12-04 11:00:00 | NVDA | Stock | 0.118 | 0.1193 | 0.1172 | 0.119 | 172215240.0 |
| 2002-12-04 12:00:00 | NVDA | Stock | 0.1189 | 0.1208 | 0.1175 | 0.1182 | 170517600.0 |
| 2002-12-04 13:00:00 | NVDA | Stock | 0.1182 | 0.1197 | 0.1168 | 0.1173 | 137160120.0 |
| 2002-12-04 14:00:00 | NVDA | Stock | 0.1173 | 0.1194 | 0.1162 | 0.1184 | 268000440.0 |
| 2002-12-04 15:00:00 | NVDA | Stock | 0.1185 | 0.1202 | 0.1162 | 0.1163 | 346870320.0 |
| 2002-12-04 16:00:00 | NVDA | Stock | 0.1166 | 0.1174 | 0.1125 | 0.116 | 18570480.0 |
| 2002-12-04 17:00:00 | NVDA | Stock | 0.1158 | 0.1167 | 0.1158 | 0.116 | 2746800.0 |
| 2002-12-04 18:00:00 | NVDA | Stock | 0.116 | 0.116 | 0.1151 | 0.1158 | 2629920.0 |
| 2002-12-04 08:00:00 | AMZN | Stock | 1.171 | 1.175 | 1.163 | 1.168 | 214400.0 |
| 2002-12-04 09:00:00 | AMZN | Stock | 1.1675 | 1.187 | 1.1555 | 1.16 | 17677200.0 |
| 2002-12-04 10:00:00 | AMZN | Stock | 1.16 | 1.163 | 1.148 | 1.1575 | 26351800.0 |
| 2002-12-04 11:00:00 | AMZN | Stock | 1.157 | 1.1575 | 1.148 | 1.1545 | 12246040.0 |
| 2002-12-04 12:00:00 | AMZN | Stock | 1.1545 | 1.1615 | 1.154 | 1.16 | 11882040.0 |
| 2002-12-04 13:00:00 | AMZN | Stock | 1.16 | 1.175 | 1.16 | 1.1665 | 22111360.0 |
| 2002-12-04 14:00:00 | AMZN | Stock | 1.1665 | 1.187 | 1.1635 | 1.1825 | 21798360.0 |
| 2002-12-04 15:00:00 | AMZN | Stock | 1.182 | 1.19 | 1.1645 | 1.1695 | 22258680.0 |
| 2002-12-04 16:00:00 | AMZN | Stock | 1.1695 | 1.174 | 1.1645 | 1.1725 | 7090180.0 |
| 2002-12-04 17:00:00 | AMZN | Stock | 1.1725 | 1.1725 | 1.1695 | 1.1695 | 1344000.0 |
| 2002-12-04 09:00:00 | CL | Stock | 25.925 | 26.5 | 25.925 | 26.4 | 599200.0 |
| 2002-12-04 10:00:00 | CL | Stock | 26.385 | 26.58 | 26.25 | 26.575 | 613200.0 |
| 2002-12-04 11:00:00 | CL | Stock | 26.575 | 26.6 | 26.475 | 26.545 | 651400.0 |
| 2002-12-04 12:00:00 | CL | Stock | 26.545 | 26.695 | 26.535 | 26.695 | 519200.0 |
| 2002-12-04 13:00:00 | CL | Stock | 26.695 | 26.695 | 26.505 | 26.535 | 276800.0 |
| 2002-12-04 14:00:00 | CL | Stock | 26.535 | 26.645 | 26.46 | 26.59 | 402200.0 |
| 2002-12-04 15:00:00 | CL | Stock | 26.58 | 26.65 | 26.5 | 26.55 | 643800.0 |
| 2002-12-04 16:00:00 | CL | Stock | 26.555 | 26.555 | 26.555 | 26.555 | 291200.0 |
> showing 50 of 19,727 rows — these rows as CSV