PREVIEW / stock_1hour / 2003-10-30
file: by_date/stock_1hour/2003/2003-10-30.parquet size: 483 KB rows: 22,932 symbols: 1,654
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-30 08:00:00 | AAPL | Stock | 0.4227 | 0.4286 | 0.4227 | 0.425 | 1078000.0 |
| 2003-10-30 09:00:00 | AAPL | Stock | 0.425 | 0.4286 | 0.4196 | 0.4218 | 29888432.0 |
| 2003-10-30 10:00:00 | AAPL | Stock | 0.4218 | 0.4227 | 0.4166 | 0.417 | 24099432.0 |
| 2003-10-30 11:00:00 | AAPL | Stock | 0.417 | 0.4171 | 0.4146 | 0.4147 | 28977032.0 |
| 2003-10-30 12:00:00 | AAPL | Stock | 0.4146 | 0.4175 | 0.4138 | 0.4175 | 20278160.0 |
| 2003-10-30 13:00:00 | AAPL | Stock | 0.4171 | 0.418 | 0.4143 | 0.4157 | 12366200.0 |
| 2003-10-30 14:00:00 | AAPL | Stock | 0.4157 | 0.4168 | 0.4138 | 0.4161 | 43090768.0 |
| 2003-10-30 15:00:00 | AAPL | Stock | 0.4161 | 0.4161 | 0.4084 | 0.4121 | 61850264.0 |
| 2003-10-30 16:00:00 | AAPL | Stock | 0.4127 | 0.4166 | 0.4111 | 0.4157 | 3018400.0 |
| 2003-10-30 17:00:00 | AAPL | Stock | 0.4125 | 0.4162 | 0.4125 | 0.4162 | 912800.0 |
| 2003-10-30 08:00:00 | MSFT | Stock | 26.96 | 26.99 | 26.751 | 26.98 | 593384.0 |
| 2003-10-30 09:00:00 | MSFT | Stock | 26.98 | 27.04 | 26.55 | 26.6 | 14716402.0 |
| 2003-10-30 10:00:00 | MSFT | Stock | 26.61 | 26.63 | 26.44 | 26.47 | 16447153.0 |
| 2003-10-30 11:00:00 | MSFT | Stock | 26.47 | 26.49 | 26.38 | 26.39 | 9633626.0 |
| 2003-10-30 12:00:00 | MSFT | Stock | 26.39 | 26.41 | 26.26 | 26.369 | 10286548.0 |
| 2003-10-30 13:00:00 | MSFT | Stock | 26.369 | 26.4 | 26.25 | 26.25 | 7895295.0 |
| 2003-10-30 14:00:00 | MSFT | Stock | 26.26 | 26.34 | 26.19 | 26.21 | 11999367.0 |
| 2003-10-30 15:00:00 | MSFT | Stock | 26.21 | 26.24 | 26.05 | 26.12 | 19124791.0 |
| 2003-10-30 16:00:00 | MSFT | Stock | 26.12 | 26.3877 | 26.1 | 26.31 | 1001600.0 |
| 2003-10-30 17:00:00 | MSFT | Stock | 26.26 | 26.4 | 26.11 | 26.38 | 541463.0 |
| 2003-10-30 18:00:00 | MSFT | Stock | 26.36 | 26.36 | 26.3 | 26.3 | 25379.0 |
| 2003-10-30 08:00:00 | NVDA | Stock | 0.1543 | 0.1562 | 0.1543 | 0.1562 | 2135400.0 |
| 2003-10-30 09:00:00 | NVDA | Stock | 0.1562 | 0.1563 | 0.1537 | 0.1548 | 95108280.0 |
| 2003-10-30 10:00:00 | NVDA | Stock | 0.1548 | 0.1552 | 0.1524 | 0.1528 | 91471200.0 |
| 2003-10-30 11:00:00 | NVDA | Stock | 0.1527 | 0.1537 | 0.1524 | 0.1531 | 68595720.0 |
| 2003-10-30 12:00:00 | NVDA | Stock | 0.153 | 0.1546 | 0.1527 | 0.1542 | 39212400.0 |
| 2003-10-30 13:00:00 | NVDA | Stock | 0.1543 | 0.1544 | 0.1519 | 0.152 | 52473960.0 |
| 2003-10-30 14:00:00 | NVDA | Stock | 0.1519 | 0.1522 | 0.1505 | 0.1513 | 89120880.0 |
| 2003-10-30 15:00:00 | NVDA | Stock | 0.1514 | 0.1514 | 0.1492 | 0.1495 | 92622360.0 |
| 2003-10-30 16:00:00 | NVDA | Stock | 0.1493 | 0.1527 | 0.1479 | 0.1527 | 3726120.0 |
| 2003-10-30 17:00:00 | NVDA | Stock | 0.1503 | 0.1529 | 0.1492 | 0.1495 | 4877640.0 |
| 2003-10-30 18:00:00 | NVDA | Stock | 0.1496 | 0.1496 | 0.1495 | 0.1495 | 144000.0 |
| 2003-10-30 08:00:00 | AMZN | Stock | 2.8345 | 2.8775 | 2.83 | 2.873 | 2330860.0 |
| 2003-10-30 09:00:00 | AMZN | Stock | 2.873 | 2.8775 | 2.8405 | 2.8475 | 27402460.0 |
| 2003-10-30 10:00:00 | AMZN | Stock | 2.8485 | 2.8735 | 2.8345 | 2.868 | 37725700.0 |
| 2003-10-30 11:00:00 | AMZN | Stock | 2.8675 | 2.8695 | 2.826 | 2.827 | 26261040.0 |
| 2003-10-30 12:00:00 | AMZN | Stock | 2.827 | 2.845 | 2.8215 | 2.839 | 23836600.0 |
| 2003-10-30 13:00:00 | AMZN | Stock | 2.8395 | 2.8435 | 2.8225 | 2.823 | 12744860.0 |
| 2003-10-30 14:00:00 | AMZN | Stock | 2.824 | 2.836 | 2.8195 | 2.8273 | 14428380.0 |
| 2003-10-30 15:00:00 | AMZN | Stock | 2.8275 | 2.8285 | 2.7785 | 2.7945 | 33431860.0 |
| 2003-10-30 16:00:00 | AMZN | Stock | 2.788 | 2.8345 | 2.7865 | 2.8308 | 2487300.0 |
| 2003-10-30 17:00:00 | AMZN | Stock | 2.7925 | 2.8055 | 2.7925 | 2.8055 | 118000.0 |
| 2003-10-30 18:00:00 | AMZN | Stock | 2.8 | 2.805 | 2.8 | 2.805 | 20000.0 |
| 2003-10-30 09:00:00 | CL | Stock | 26.15 | 26.5 | 26.0 | 26.005 | 825800.0 |
| 2003-10-30 10:00:00 | CL | Stock | 26.005 | 26.005 | 25.82 | 25.845 | 1072600.0 |
| 2003-10-30 11:00:00 | CL | Stock | 25.84 | 25.875 | 25.73 | 25.76 | 950600.0 |
| 2003-10-30 12:00:00 | CL | Stock | 25.77 | 25.88 | 25.75 | 25.87 | 777600.0 |
| 2003-10-30 13:00:00 | CL | Stock | 25.87 | 25.875 | 25.785 | 25.83 | 372000.0 |
| 2003-10-30 14:00:00 | CL | Stock | 25.81 | 25.855 | 25.735 | 25.825 | 724200.0 |
| 2003-10-30 15:00:00 | CL | Stock | 25.825 | 25.845 | 25.7 | 25.805 | 1388000.0 |
> showing 50 of 22,932 rows — these rows as CSV