PREVIEW / stock_1hour / 2003-10-22
file: by_date/stock_1hour/2003/2003-10-22.parquet size: 489 KB rows: 22,841 symbols: 1,649
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 |
|---|---|---|---|---|---|---|---|
| 2003-10-22 08:00:00 | AAPL | Stock | 0.4107 | 0.4116 | 0.4089 | 0.4116 | 28000.0 |
| 2003-10-22 09:00:00 | AAPL | Stock | 0.4111 | 0.4143 | 0.4071 | 0.4086 | 19078584.0 |
| 2003-10-22 10:00:00 | AAPL | Stock | 0.4088 | 0.4116 | 0.405 | 0.4057 | 28595560.0 |
| 2003-10-22 11:00:00 | AAPL | Stock | 0.4057 | 0.408 | 0.4055 | 0.4077 | 20581624.0 |
| 2003-10-22 12:00:00 | AAPL | Stock | 0.4079 | 0.4091 | 0.4068 | 0.4077 | 13027000.0 |
| 2003-10-22 13:00:00 | AAPL | Stock | 0.4073 | 0.4075 | 0.4052 | 0.4068 | 13317920.0 |
| 2003-10-22 14:00:00 | AAPL | Stock | 0.407 | 0.4091 | 0.4066 | 0.408 | 13858768.0 |
| 2003-10-22 15:00:00 | AAPL | Stock | 0.408 | 0.4084 | 0.4055 | 0.4064 | 24171672.0 |
| 2003-10-22 16:00:00 | AAPL | Stock | 0.4077 | 0.4086 | 0.4064 | 0.4064 | 16002056.0 |
| 2003-10-22 17:00:00 | AAPL | Stock | 0.4067 | 0.4067 | 0.4064 | 0.4064 | 291200.0 |
| 2003-10-22 18:00:00 | AAPL | Stock | 0.4064 | 0.4064 | 0.4057 | 0.4057 | 106400.0 |
| 2003-10-22 08:00:00 | MSFT | Stock | 29.28 | 29.34 | 29.05 | 29.12 | 128500.0 |
| 2003-10-22 09:00:00 | MSFT | Stock | 29.13 | 29.33 | 28.95 | 29.149 | 12518428.0 |
| 2003-10-22 10:00:00 | MSFT | Stock | 29.15 | 29.19 | 28.87 | 29.003 | 7346358.0 |
| 2003-10-22 11:00:00 | MSFT | Stock | 29.001 | 29.03 | 28.92 | 28.98 | 3728865.0 |
| 2003-10-22 12:00:00 | MSFT | Stock | 28.99 | 28.99 | 28.9 | 28.94 | 2626812.0 |
| 2003-10-22 13:00:00 | MSFT | Stock | 28.94 | 28.96 | 28.848 | 28.91 | 4281403.0 |
| 2003-10-22 14:00:00 | MSFT | Stock | 28.9 | 29.0 | 28.85 | 29.0 | 4794289.0 |
| 2003-10-22 15:00:00 | MSFT | Stock | 28.991 | 29.01 | 28.8 | 28.88 | 7880470.0 |
| 2003-10-22 16:00:00 | MSFT | Stock | 28.89 | 29.0 | 28.86 | 28.87 | 1239694.0 |
| 2003-10-22 17:00:00 | MSFT | Stock | 28.87 | 29.1465 | 28.7 | 28.79 | 345970.0 |
| 2003-10-22 18:00:00 | MSFT | Stock | 28.76 | 28.97 | 28.75 | 28.8 | 24300.0 |
| 2003-10-22 08:00:00 | NVDA | Stock | 0.1444 | 0.1444 | 0.1442 | 0.1444 | 60000.0 |
| 2003-10-22 09:00:00 | NVDA | Stock | 0.1448 | 0.1458 | 0.143 | 0.1437 | 81072960.0 |
| 2003-10-22 10:00:00 | NVDA | Stock | 0.1437 | 0.1473 | 0.1437 | 0.1455 | 142616880.0 |
| 2003-10-22 11:00:00 | NVDA | Stock | 0.1455 | 0.146 | 0.1447 | 0.1453 | 57972240.0 |
| 2003-10-22 12:00:00 | NVDA | Stock | 0.1452 | 0.1464 | 0.145 | 0.1457 | 63137880.0 |
| 2003-10-22 13:00:00 | NVDA | Stock | 0.1457 | 0.1458 | 0.145 | 0.1453 | 75903000.0 |
| 2003-10-22 14:00:00 | NVDA | Stock | 0.1452 | 0.1462 | 0.145 | 0.1457 | 48898080.0 |
| 2003-10-22 15:00:00 | NVDA | Stock | 0.1456 | 0.1457 | 0.1437 | 0.1437 | 99555240.0 |
| 2003-10-22 16:00:00 | NVDA | Stock | 0.1437 | 0.1443 | 0.1417 | 0.1434 | 5979240.0 |
| 2003-10-22 17:00:00 | NVDA | Stock | 0.144 | 0.144 | 0.1421 | 0.1425 | 2058000.0 |
| 2003-10-22 18:00:00 | NVDA | Stock | 0.1428 | 0.1428 | 0.1426 | 0.1426 | 60000.0 |
| 2003-10-22 08:00:00 | AMZN | Stock | 2.84 | 2.925 | 2.8145 | 2.8175 | 21502960.0 |
| 2003-10-22 09:00:00 | AMZN | Stock | 2.819 | 2.966 | 2.7375 | 2.7635 | 168370380.0 |
| 2003-10-22 10:00:00 | AMZN | Stock | 2.7635 | 2.7965 | 2.761 | 2.787 | 96876780.0 |
| 2003-10-22 11:00:00 | AMZN | Stock | 2.787 | 2.796 | 2.7728 | 2.7785 | 64102040.0 |
| 2003-10-22 12:00:00 | AMZN | Stock | 2.778 | 2.781 | 2.7485 | 2.756 | 43649440.0 |
| 2003-10-22 13:00:00 | AMZN | Stock | 2.7555 | 2.756 | 2.7285 | 2.7345 | 59225380.0 |
| 2003-10-22 14:00:00 | AMZN | Stock | 2.7345 | 2.758 | 2.727 | 2.74 | 51647640.0 |
| 2003-10-22 15:00:00 | AMZN | Stock | 2.74 | 2.7465 | 2.6865 | 2.7015 | 93889260.0 |
| 2003-10-22 16:00:00 | AMZN | Stock | 2.6985 | 2.725 | 2.694 | 2.695 | 6238980.0 |
| 2003-10-22 17:00:00 | AMZN | Stock | 2.6955 | 2.7833 | 2.68 | 2.68 | 755280.0 |
| 2003-10-22 18:00:00 | AMZN | Stock | 2.6825 | 2.6825 | 2.675 | 2.68 | 252000.0 |
| 2003-10-22 09:00:00 | CL | Stock | 28.65 | 28.805 | 28.625 | 28.695 | 224200.0 |
| 2003-10-22 10:00:00 | CL | Stock | 28.7 | 28.7 | 28.43 | 28.575 | 634600.0 |
| 2003-10-22 11:00:00 | CL | Stock | 28.575 | 28.7 | 28.55 | 28.69 | 341000.0 |
| 2003-10-22 12:00:00 | CL | Stock | 28.685 | 28.805 | 28.65 | 28.775 | 335000.0 |
| 2003-10-22 13:00:00 | CL | Stock | 28.775 | 28.795 | 28.75 | 28.77 | 389400.0 |
| 2003-10-22 14:00:00 | CL | Stock | 28.765 | 28.805 | 28.675 | 28.805 | 509600.0 |
> showing 50 of 22,841 rows — these rows as CSV