PREVIEW / stock_1hour / 2002-11-15
file: by_date/stock_1hour/2002/2002-11-15.parquet size: 414 KB rows: 19,306 symbols: 1,507
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-11-15 08:00:00 | AAPL | Stock | 0.2876 | 0.2911 | 0.2859 | 0.2866 | 386400.0 |
| 2002-11-15 09:00:00 | AAPL | Stock | 0.2858 | 0.2907 | 0.285 | 0.2882 | 21895440.0 |
| 2002-11-15 10:00:00 | AAPL | Stock | 0.2882 | 0.2889 | 0.2843 | 0.285 | 20724032.0 |
| 2002-11-15 11:00:00 | AAPL | Stock | 0.285 | 0.2861 | 0.2823 | 0.2838 | 9625392.0 |
| 2002-11-15 12:00:00 | AAPL | Stock | 0.2837 | 0.2839 | 0.2814 | 0.2825 | 25294696.0 |
| 2002-11-15 13:00:00 | AAPL | Stock | 0.2825 | 0.2885 | 0.2821 | 0.2834 | 14759864.0 |
| 2002-11-15 14:00:00 | AAPL | Stock | 0.2834 | 0.2855 | 0.2823 | 0.2838 | 24195864.0 |
| 2002-11-15 15:00:00 | AAPL | Stock | 0.2839 | 0.2854 | 0.2825 | 0.2848 | 31768520.0 |
| 2002-11-15 16:00:00 | AAPL | Stock | 0.2839 | 0.2852 | 0.2827 | 0.2827 | 1913464.0 |
| 2002-11-15 17:00:00 | AAPL | Stock | 0.2844 | 0.2844 | 0.2844 | 0.2844 | 425600.0 |
| 2002-11-15 18:00:00 | AAPL | Stock | 0.2848 | 0.2848 | 0.2827 | 0.2848 | 1321600.0 |
| 2002-11-15 08:00:00 | MSFT | Stock | 28.485 | 28.63 | 28.245 | 28.25 | 88770.0 |
| 2002-11-15 09:00:00 | MSFT | Stock | 28.25 | 28.495 | 27.96 | 28.105 | 19548944.0 |
| 2002-11-15 10:00:00 | MSFT | Stock | 28.11 | 28.126 | 27.855 | 27.96 | 12190806.0 |
| 2002-11-15 11:00:00 | MSFT | Stock | 27.955 | 28.0 | 27.855 | 27.9695 | 6195946.0 |
| 2002-11-15 12:00:00 | MSFT | Stock | 27.965 | 28.01 | 27.875 | 27.945 | 4597000.0 |
| 2002-11-15 13:00:00 | MSFT | Stock | 27.94 | 28.19 | 27.925 | 28.1 | 7342476.0 |
| 2002-11-15 14:00:00 | MSFT | Stock | 28.095 | 28.315 | 28.055 | 28.26 | 9171292.0 |
| 2002-11-15 15:00:00 | MSFT | Stock | 28.255 | 28.46 | 28.175 | 28.325 | 12391362.0 |
| 2002-11-15 16:00:00 | MSFT | Stock | 28.33 | 28.4455 | 28.3 | 28.325 | 2599236.0 |
| 2002-11-15 17:00:00 | MSFT | Stock | 28.325 | 28.335 | 28.1062 | 28.335 | 650500.0 |
| 2002-11-15 18:00:00 | MSFT | Stock | 28.35 | 28.36 | 28.345 | 28.345 | 176600.0 |
| 2002-11-15 08:00:00 | NVDA | Stock | 0.11 | 0.1124 | 0.1068 | 0.1117 | 30612000.0 |
| 2002-11-15 09:00:00 | NVDA | Stock | 0.112 | 0.1146 | 0.1064 | 0.1142 | 481718280.0 |
| 2002-11-15 10:00:00 | NVDA | Stock | 0.1142 | 0.1159 | 0.1125 | 0.1139 | 424834200.0 |
| 2002-11-15 11:00:00 | NVDA | Stock | 0.1138 | 0.1139 | 0.1117 | 0.1126 | 198434040.0 |
| 2002-11-15 12:00:00 | NVDA | Stock | 0.1126 | 0.1131 | 0.1121 | 0.1122 | 102606600.0 |
| 2002-11-15 13:00:00 | NVDA | Stock | 0.1121 | 0.1136 | 0.1116 | 0.1132 | 158745960.0 |
| 2002-11-15 14:00:00 | NVDA | Stock | 0.1133 | 0.1156 | 0.1129 | 0.115 | 231805440.0 |
| 2002-11-15 15:00:00 | NVDA | Stock | 0.115 | 0.1157 | 0.1122 | 0.1122 | 294610440.0 |
| 2002-11-15 16:00:00 | NVDA | Stock | 0.1123 | 0.113 | 0.1112 | 0.1126 | 36653520.0 |
| 2002-11-15 17:00:00 | NVDA | Stock | 0.1127 | 0.1137 | 0.1126 | 0.1126 | 1635600.0 |
| 2002-11-15 18:00:00 | NVDA | Stock | 0.1126 | 0.1131 | 0.1118 | 0.1131 | 3720000.0 |
| 2002-11-15 08:00:00 | AMZN | Stock | 1.05 | 1.065 | 1.05 | 1.055 | 381340.0 |
| 2002-11-15 09:00:00 | AMZN | Stock | 1.051 | 1.087 | 1.051 | 1.0825 | 34909700.0 |
| 2002-11-15 10:00:00 | AMZN | Stock | 1.083 | 1.0875 | 1.0725 | 1.085 | 33779900.0 |
| 2002-11-15 11:00:00 | AMZN | Stock | 1.085 | 1.091 | 1.083 | 1.0905 | 25162860.0 |
| 2002-11-15 12:00:00 | AMZN | Stock | 1.0905 | 1.109 | 1.0875 | 1.101 | 28999680.0 |
| 2002-11-15 13:00:00 | AMZN | Stock | 1.1005 | 1.1085 | 1.096 | 1.106 | 27006220.0 |
| 2002-11-15 14:00:00 | AMZN | Stock | 1.106 | 1.1175 | 1.103 | 1.1075 | 35406360.0 |
| 2002-11-15 15:00:00 | AMZN | Stock | 1.1085 | 1.115 | 1.0975 | 1.11 | 40318600.0 |
| 2002-11-15 16:00:00 | AMZN | Stock | 1.1105 | 1.157 | 1.1075 | 1.1075 | 4359560.0 |
| 2002-11-15 17:00:00 | AMZN | Stock | 1.1085 | 1.11 | 1.1075 | 1.11 | 90000.0 |
| 2002-11-15 18:00:00 | AMZN | Stock | 1.1105 | 1.112 | 1.1105 | 1.112 | 1051100.0 |
| 2002-11-15 09:00:00 | CL | Stock | 26.47 | 26.47 | 26.1 | 26.2 | 769400.0 |
| 2002-11-15 10:00:00 | CL | Stock | 26.195 | 26.32 | 26.075 | 26.185 | 1177800.0 |
| 2002-11-15 11:00:00 | CL | Stock | 26.185 | 26.345 | 26.095 | 26.225 | 490200.0 |
| 2002-11-15 12:00:00 | CL | Stock | 26.215 | 26.27 | 26.19 | 26.225 | 485600.0 |
| 2002-11-15 13:00:00 | CL | Stock | 26.22 | 26.35 | 26.22 | 26.325 | 415200.0 |
| 2002-11-15 14:00:00 | CL | Stock | 26.32 | 26.365 | 26.28 | 26.35 | 409200.0 |
> showing 50 of 19,306 rows — these rows as CSV