PREVIEW / stock_1hour / 2002-12-17
file: by_date/stock_1hour/2002/2002-12-17.parquet size: 422 KB rows: 19,938 symbols: 1,543
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-17 09:00:00 | AAPL | Stock | 0.265 | 0.2704 | 0.2618 | 0.2702 | 28952672.0 |
| 2002-12-17 10:00:00 | AAPL | Stock | 0.2698 | 0.2713 | 0.2654 | 0.2659 | 34436528.0 |
| 2002-12-17 11:00:00 | AAPL | Stock | 0.2657 | 0.267 | 0.265 | 0.2657 | 20573560.0 |
| 2002-12-17 12:00:00 | AAPL | Stock | 0.2657 | 0.2661 | 0.2643 | 0.2655 | 23061304.0 |
| 2002-12-17 13:00:00 | AAPL | Stock | 0.2655 | 0.2677 | 0.2654 | 0.2666 | 26707520.0 |
| 2002-12-17 14:00:00 | AAPL | Stock | 0.2663 | 0.2682 | 0.2658 | 0.2673 | 23694440.0 |
| 2002-12-17 15:00:00 | AAPL | Stock | 0.2673 | 0.2695 | 0.2661 | 0.2694 | 35022400.0 |
| 2002-12-17 16:00:00 | AAPL | Stock | 0.2682 | 0.2702 | 0.2679 | 0.2693 | 5542768.0 |
| 2002-12-17 17:00:00 | AAPL | Stock | 0.2691 | 0.2693 | 0.2676 | 0.2693 | 834400.0 |
| 2002-12-17 08:00:00 | MSFT | Stock | 27.185 | 27.325 | 27.17 | 27.21 | 123530.0 |
| 2002-12-17 09:00:00 | MSFT | Stock | 27.215 | 27.385 | 27.1345 | 27.375 | 7591848.0 |
| 2002-12-17 10:00:00 | MSFT | Stock | 27.365 | 27.495 | 27.14 | 27.16 | 10297004.0 |
| 2002-12-17 11:00:00 | MSFT | Stock | 27.165 | 27.29 | 27.15 | 27.28 | 5148408.0 |
| 2002-12-17 12:00:00 | MSFT | Stock | 27.2845 | 27.315 | 27.2 | 27.26 | 3119884.0 |
| 2002-12-17 13:00:00 | MSFT | Stock | 27.27 | 27.295 | 27.11 | 27.12 | 3358384.0 |
| 2002-12-17 14:00:00 | MSFT | Stock | 27.12 | 27.2 | 27.03 | 27.095 | 4282962.0 |
| 2002-12-17 15:00:00 | MSFT | Stock | 27.095 | 27.23 | 26.9 | 27.21 | 7834566.0 |
| 2002-12-17 16:00:00 | MSFT | Stock | 27.19 | 27.265 | 27.1265 | 27.195 | 1406560.0 |
| 2002-12-17 17:00:00 | MSFT | Stock | 27.1765 | 27.18 | 27.025 | 27.06 | 188238.0 |
| 2002-12-17 18:00:00 | MSFT | Stock | 27.06 | 27.075 | 27.06 | 27.075 | 1600.0 |
| 2002-12-17 08:00:00 | NVDA | Stock | 0.1169 | 0.1212 | 0.1169 | 0.1192 | 7532760.0 |
| 2002-12-17 09:00:00 | NVDA | Stock | 0.1192 | 0.1229 | 0.1183 | 0.1223 | 243348000.0 |
| 2002-12-17 10:00:00 | NVDA | Stock | 0.1224 | 0.1227 | 0.1187 | 0.1188 | 219027960.0 |
| 2002-12-17 11:00:00 | NVDA | Stock | 0.1189 | 0.1212 | 0.1187 | 0.121 | 110205120.0 |
| 2002-12-17 12:00:00 | NVDA | Stock | 0.121 | 0.1212 | 0.1196 | 0.1204 | 64323720.0 |
| 2002-12-17 13:00:00 | NVDA | Stock | 0.1204 | 0.1208 | 0.1189 | 0.119 | 67444080.0 |
| 2002-12-17 14:00:00 | NVDA | Stock | 0.1189 | 0.1193 | 0.1176 | 0.1181 | 73116240.0 |
| 2002-12-17 15:00:00 | NVDA | Stock | 0.1181 | 0.1184 | 0.1157 | 0.1167 | 126405360.0 |
| 2002-12-17 16:00:00 | NVDA | Stock | 0.1167 | 0.1195 | 0.1151 | 0.1155 | 54585000.0 |
| 2002-12-17 17:00:00 | NVDA | Stock | 0.1155 | 0.1169 | 0.1146 | 0.1153 | 5895000.0 |
| 2002-12-17 18:00:00 | NVDA | Stock | 0.1153 | 0.1153 | 0.1151 | 0.1151 | 228000.0 |
| 2002-12-17 08:00:00 | AMZN | Stock | 1.125 | 1.125 | 1.124 | 1.124 | 28000.0 |
| 2002-12-17 09:00:00 | AMZN | Stock | 1.128 | 1.128 | 1.116 | 1.122 | 9236920.0 |
| 2002-12-17 10:00:00 | AMZN | Stock | 1.1225 | 1.1255 | 1.117 | 1.12 | 7926620.0 |
| 2002-12-17 11:00:00 | AMZN | Stock | 1.12 | 1.1275 | 1.1165 | 1.124 | 7078360.0 |
| 2002-12-17 12:00:00 | AMZN | Stock | 1.125 | 1.1255 | 1.1195 | 1.1245 | 4725340.0 |
| 2002-12-17 13:00:00 | AMZN | Stock | 1.1245 | 1.1252 | 1.1195 | 1.12 | 5918820.0 |
| 2002-12-17 14:00:00 | AMZN | Stock | 1.12 | 1.1225 | 1.1185 | 1.119 | 5505140.0 |
| 2002-12-17 15:00:00 | AMZN | Stock | 1.1195 | 1.1245 | 1.118 | 1.123 | 11492400.0 |
| 2002-12-17 16:00:00 | AMZN | Stock | 1.121 | 1.125 | 1.121 | 1.125 | 462000.0 |
| 2002-12-17 17:00:00 | AMZN | Stock | 1.1205 | 1.123 | 1.1175 | 1.123 | 878000.0 |
| 2002-12-17 18:00:00 | AMZN | Stock | 1.123 | 1.123 | 1.1225 | 1.1225 | 14000.0 |
| 2002-12-17 09:00:00 | CL | Stock | 26.2 | 26.25 | 26.125 | 26.125 | 283400.0 |
| 2002-12-17 10:00:00 | CL | Stock | 26.125 | 26.25 | 26.03 | 26.155 | 575000.0 |
| 2002-12-17 11:00:00 | CL | Stock | 26.155 | 26.29 | 26.155 | 26.235 | 424600.0 |
| 2002-12-17 12:00:00 | CL | Stock | 26.24 | 26.39 | 26.23 | 26.34 | 388800.0 |
| 2002-12-17 13:00:00 | CL | Stock | 26.345 | 26.355 | 26.235 | 26.285 | 410400.0 |
| 2002-12-17 14:00:00 | CL | Stock | 26.285 | 26.325 | 26.21 | 26.23 | 812800.0 |
| 2002-12-17 15:00:00 | CL | Stock | 26.225 | 26.275 | 26.175 | 26.2 | 970200.0 |
| 2002-12-17 16:00:00 | CL | Stock | 26.205 | 26.21 | 26.205 | 26.21 | 99000.0 |
> showing 50 of 19,938 rows — these rows as CSV