PREVIEW / stock_1hour / 2000-02-15
file: by_date/stock_1hour/2000/2000-02-15.parquet size: 283 KB rows: 14,400 symbols: 1,143
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 |
|---|---|---|---|---|---|---|---|
| 2000-02-15 09:00:00 | AAPL | Stock | 1.029 | 1.0614 | 1.029 | 1.0536 | 77604800.0 |
| 2000-02-15 10:00:00 | AAPL | Stock | 1.0536 | 1.0547 | 1.0402 | 1.0469 | 113993600.0 |
| 2000-02-15 11:00:00 | AAPL | Stock | 1.0474 | 1.0558 | 1.0329 | 1.0379 | 58800000.0 |
| 2000-02-15 12:00:00 | AAPL | Stock | 1.0391 | 1.0446 | 1.0363 | 1.0396 | 25300800.0 |
| 2000-02-15 13:00:00 | AAPL | Stock | 1.0402 | 1.0446 | 1.0335 | 1.0346 | 23811200.0 |
| 2000-02-15 14:00:00 | AAPL | Stock | 1.0352 | 1.0536 | 1.0346 | 1.0485 | 59225600.0 |
| 2000-02-15 15:00:00 | AAPL | Stock | 1.0485 | 1.0709 | 1.0452 | 1.0625 | 107900800.0 |
| 2000-02-15 16:00:00 | AAPL | Stock | 1.0622 | 1.0625 | 1.0619 | 1.0625 | 1344000.0 |
| 2000-02-15 09:00:00 | MSFT | Stock | 49.875 | 50.0 | 49.1875 | 49.2812 | 6488000.0 |
| 2000-02-15 10:00:00 | MSFT | Stock | 49.25 | 49.3438 | 48.5 | 48.625 | 12732400.0 |
| 2000-02-15 11:00:00 | MSFT | Stock | 48.625 | 48.9688 | 48.1875 | 48.6875 | 10043000.0 |
| 2000-02-15 12:00:00 | MSFT | Stock | 48.6562 | 49.125 | 48.5 | 49.0312 | 6126800.0 |
| 2000-02-15 13:00:00 | MSFT | Stock | 49.0469 | 49.25 | 48.75 | 49.125 | 5054600.0 |
| 2000-02-15 14:00:00 | MSFT | Stock | 49.0938 | 49.625 | 49.0625 | 49.2812 | 10610200.0 |
| 2000-02-15 15:00:00 | MSFT | Stock | 49.3125 | 49.5938 | 49.0625 | 49.25 | 15558200.0 |
| 2000-02-15 16:00:00 | MSFT | Stock | 49.25 | 49.2812 | 49.25 | 49.2812 | 213400.0 |
| 2000-02-15 09:00:00 | NVDA | Stock | 0.1211 | 0.1211 | 0.1125 | 0.1139 | 86208000.0 |
| 2000-02-15 10:00:00 | NVDA | Stock | 0.1138 | 0.1151 | 0.1112 | 0.1148 | 106800000.0 |
| 2000-02-15 11:00:00 | NVDA | Stock | 0.1148 | 0.1151 | 0.1134 | 0.1146 | 53088000.0 |
| 2000-02-15 12:00:00 | NVDA | Stock | 0.1143 | 0.1148 | 0.1141 | 0.1146 | 25104000.0 |
| 2000-02-15 13:00:00 | NVDA | Stock | 0.1146 | 0.1172 | 0.1146 | 0.1167 | 47712000.0 |
| 2000-02-15 14:00:00 | NVDA | Stock | 0.1166 | 0.1187 | 0.1161 | 0.1182 | 32016000.0 |
| 2000-02-15 15:00:00 | NVDA | Stock | 0.1177 | 0.1193 | 0.1151 | 0.1159 | 80544000.0 |
| 2000-02-15 16:00:00 | NVDA | Stock | 0.1161 | 0.1161 | 0.1161 | 0.1161 | 4800000.0 |
| 2000-02-15 09:00:00 | AMZN | Stock | 3.6719 | 3.725 | 3.6312 | 3.6562 | 15176000.0 |
| 2000-02-15 10:00:00 | AMZN | Stock | 3.6578 | 3.6656 | 3.5312 | 3.5594 | 33570000.0 |
| 2000-02-15 11:00:00 | AMZN | Stock | 3.5594 | 3.6062 | 3.5469 | 3.6031 | 16980000.0 |
| 2000-02-15 12:00:00 | AMZN | Stock | 3.6031 | 3.65 | 3.5938 | 3.6188 | 6640000.0 |
| 2000-02-15 13:00:00 | AMZN | Stock | 3.6188 | 3.6312 | 3.5969 | 3.6 | 9074000.0 |
| 2000-02-15 14:00:00 | AMZN | Stock | 3.6 | 3.7125 | 3.5781 | 3.6969 | 14226000.0 |
| 2000-02-15 15:00:00 | AMZN | Stock | 3.7 | 3.8094 | 3.6812 | 3.6875 | 27734000.0 |
| 2000-02-15 16:00:00 | AMZN | Stock | 3.6906 | 3.6906 | 3.6875 | 3.6906 | 212000.0 |
| 2000-02-15 09:00:00 | CL | Stock | 27.375 | 27.5625 | 27.1875 | 27.375 | 375600.0 |
| 2000-02-15 10:00:00 | CL | Stock | 27.3438 | 27.3438 | 26.9062 | 27.0 | 739200.0 |
| 2000-02-15 11:00:00 | CL | Stock | 27.0312 | 27.1875 | 26.9062 | 27.0938 | 767800.0 |
| 2000-02-15 12:00:00 | CL | Stock | 27.0625 | 27.2812 | 27.0625 | 27.2188 | 278400.0 |
| 2000-02-15 13:00:00 | CL | Stock | 27.1875 | 27.8125 | 27.125 | 27.7188 | 480800.0 |
| 2000-02-15 14:00:00 | CL | Stock | 27.7188 | 27.8125 | 27.5625 | 27.7188 | 428800.0 |
| 2000-02-15 15:00:00 | CL | Stock | 27.7188 | 27.9062 | 27.5625 | 27.9062 | 656000.0 |
| 2000-02-15 16:00:00 | CL | Stock | 27.8438 | 27.8438 | 27.8438 | 27.8438 | 513800.0 |
> showing 40 of 14,400 rows — these rows as CSV