PREVIEW / stock_1hour / 2000-12-21
file: by_date/stock_1hour/2000/2000-12-21.parquet size: 326 KB rows: 16,804 symbols: 1,271
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-12-21 08:00:00 | AAPL | Stock | 0.2556 | 0.2578 | 0.2556 | 0.2578 | 1276800.0 |
| 2000-12-21 09:00:00 | AAPL | Stock | 0.2556 | 0.2667 | 0.2511 | 0.2623 | 68174400.0 |
| 2000-12-21 10:00:00 | AAPL | Stock | 0.2628 | 0.2634 | 0.2567 | 0.2589 | 50232000.0 |
| 2000-12-21 11:00:00 | AAPL | Stock | 0.2589 | 0.2679 | 0.2567 | 0.2667 | 58021600.0 |
| 2000-12-21 12:00:00 | AAPL | Stock | 0.2667 | 0.2667 | 0.26 | 0.2623 | 25155200.0 |
| 2000-12-21 13:00:00 | AAPL | Stock | 0.2634 | 0.2634 | 0.2589 | 0.2589 | 21610400.0 |
| 2000-12-21 14:00:00 | AAPL | Stock | 0.26 | 0.26 | 0.2511 | 0.2522 | 44038400.0 |
| 2000-12-21 15:00:00 | AAPL | Stock | 0.2522 | 0.2567 | 0.2478 | 0.2511 | 45740800.0 |
| 2000-12-21 16:00:00 | AAPL | Stock | 0.2522 | 0.264 | 0.25 | 0.2522 | 18496800.0 |
| 2000-12-21 17:00:00 | AAPL | Stock | 0.2511 | 0.2522 | 0.2478 | 0.2522 | 100800.0 |
| 2000-12-21 18:00:00 | AAPL | Stock | 0.2522 | 0.2522 | 0.2522 | 0.2522 | 5600.0 |
| 2000-12-21 08:00:00 | MSFT | Stock | 21.0 | 21.25 | 20.625 | 20.8125 | 249000.0 |
| 2000-12-21 09:00:00 | MSFT | Stock | 20.9375 | 21.2812 | 20.3125 | 20.625 | 19443800.0 |
| 2000-12-21 10:00:00 | MSFT | Stock | 20.5938 | 20.875 | 20.125 | 20.6875 | 23795000.0 |
| 2000-12-21 11:00:00 | MSFT | Stock | 20.6875 | 21.9062 | 20.3125 | 21.9062 | 25527000.0 |
| 2000-12-21 12:00:00 | MSFT | Stock | 21.9062 | 21.9844 | 21.5312 | 21.75 | 15035600.0 |
| 2000-12-21 13:00:00 | MSFT | Stock | 21.7812 | 22.2812 | 21.625 | 21.9375 | 18317200.0 |
| 2000-12-21 14:00:00 | MSFT | Stock | 21.9688 | 22.0 | 21.4375 | 21.5625 | 19266200.0 |
| 2000-12-21 15:00:00 | MSFT | Stock | 21.5625 | 22.5625 | 21.5312 | 21.6875 | 24634800.0 |
| 2000-12-21 16:00:00 | MSFT | Stock | 21.6875 | 22.1875 | 21.1875 | 22.0 | 4956200.0 |
| 2000-12-21 17:00:00 | MSFT | Stock | 22.0 | 22.25 | 22.0 | 22.1562 | 16400.0 |
| 2000-12-21 18:00:00 | MSFT | Stock | 22.1562 | 22.2188 | 22.1562 | 22.2188 | 8000.0 |
| 2000-12-21 09:00:00 | NVDA | Stock | 0.1331 | 0.1375 | 0.1242 | 0.1302 | 68520000.0 |
| 2000-12-21 10:00:00 | NVDA | Stock | 0.1294 | 0.1302 | 0.119 | 0.1273 | 118344000.0 |
| 2000-12-21 11:00:00 | NVDA | Stock | 0.1271 | 0.1479 | 0.1266 | 0.1479 | 110640000.0 |
| 2000-12-21 12:00:00 | NVDA | Stock | 0.1484 | 0.149 | 0.1396 | 0.1417 | 67728000.0 |
| 2000-12-21 13:00:00 | NVDA | Stock | 0.1417 | 0.1417 | 0.1318 | 0.1318 | 41544000.0 |
| 2000-12-21 14:00:00 | NVDA | Stock | 0.1318 | 0.1328 | 0.1201 | 0.1214 | 118800000.0 |
| 2000-12-21 15:00:00 | NVDA | Stock | 0.1214 | 0.1234 | 0.1146 | 0.1159 | 225480000.0 |
| 2000-12-21 16:00:00 | NVDA | Stock | 0.1159 | 0.1167 | 0.1156 | 0.1156 | 13008000.0 |
| 2000-12-21 17:00:00 | NVDA | Stock | 0.1188 | 0.1188 | 0.1167 | 0.1177 | 672000.0 |
| 2000-12-21 18:00:00 | NVDA | Stock | 0.1177 | 0.1177 | 0.1176 | 0.1177 | 768000.0 |
| 2000-12-21 08:00:00 | AMZN | Stock | 0.8 | 0.8562 | 0.8 | 0.8562 | 364000.0 |
| 2000-12-21 09:00:00 | AMZN | Stock | 0.85 | 0.8688 | 0.8125 | 0.8188 | 14878000.0 |
| 2000-12-21 10:00:00 | AMZN | Stock | 0.8188 | 0.8188 | 0.7688 | 0.7938 | 30492000.0 |
| 2000-12-21 11:00:00 | AMZN | Stock | 0.7938 | 0.8625 | 0.7906 | 0.8531 | 29282000.0 |
| 2000-12-21 12:00:00 | AMZN | Stock | 0.85 | 0.8531 | 0.7969 | 0.8 | 15332000.0 |
| 2000-12-21 13:00:00 | AMZN | Stock | 0.8031 | 0.8062 | 0.7688 | 0.7719 | 11276000.0 |
| 2000-12-21 14:00:00 | AMZN | Stock | 0.7688 | 0.7719 | 0.7438 | 0.75 | 24372000.0 |
| 2000-12-21 15:00:00 | AMZN | Stock | 0.7516 | 0.7688 | 0.7438 | 0.7625 | 32556000.0 |
| 2000-12-21 16:00:00 | AMZN | Stock | 0.75 | 0.7922 | 0.75 | 0.7563 | 1698000.0 |
| 2000-12-21 17:00:00 | AMZN | Stock | 0.7563 | 0.7875 | 0.75 | 0.7688 | 150000.0 |
| 2000-12-21 18:00:00 | AMZN | Stock | 0.7688 | 0.775 | 0.7688 | 0.775 | 60000.0 |
| 2000-12-21 09:00:00 | CL | Stock | 29.655 | 29.9 | 29.65 | 29.8 | 290600.0 |
| 2000-12-21 10:00:00 | CL | Stock | 29.84 | 29.935 | 29.7 | 29.745 | 1016200.0 |
| 2000-12-21 11:00:00 | CL | Stock | 29.745 | 29.965 | 29.63 | 29.87 | 357800.0 |
| 2000-12-21 12:00:00 | CL | Stock | 29.875 | 30.1 | 29.725 | 30.075 | 505800.0 |
| 2000-12-21 13:00:00 | CL | Stock | 30.075 | 30.4 | 29.995 | 30.375 | 452600.0 |
| 2000-12-21 14:00:00 | CL | Stock | 30.34 | 30.38 | 30.105 | 30.135 | 403600.0 |
| 2000-12-21 15:00:00 | CL | Stock | 30.13 | 30.29 | 30.125 | 30.255 | 665200.0 |
> showing 50 of 16,804 rows — these rows as CSV