PREVIEW / stock_1hour / 2003-10-16
file: by_date/stock_1hour/2003/2003-10-16.parquet size: 467 KB rows: 22,331 symbols: 1,647
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-16 08:00:00 | AAPL | Stock | 0.4321 | 0.4427 | 0.425 | 0.4262 | 2535400.0 |
| 2003-10-16 09:00:00 | AAPL | Stock | 0.4263 | 0.4277 | 0.4077 | 0.4095 | 153242600.0 |
| 2003-10-16 10:00:00 | AAPL | Stock | 0.4093 | 0.4096 | 0.4038 | 0.4059 | 224801696.0 |
| 2003-10-16 11:00:00 | AAPL | Stock | 0.4059 | 0.4064 | 0.4002 | 0.403 | 82305328.0 |
| 2003-10-16 12:00:00 | AAPL | Stock | 0.403 | 0.4116 | 0.4027 | 0.4107 | 113450064.0 |
| 2003-10-16 13:00:00 | AAPL | Stock | 0.4107 | 0.4134 | 0.4079 | 0.4113 | 73932152.0 |
| 2003-10-16 14:00:00 | AAPL | Stock | 0.4109 | 0.4191 | 0.4107 | 0.4166 | 130872952.0 |
| 2003-10-16 15:00:00 | AAPL | Stock | 0.4166 | 0.4171 | 0.4139 | 0.4141 | 94963904.0 |
| 2003-10-16 16:00:00 | AAPL | Stock | 0.4155 | 0.4163 | 0.4139 | 0.4152 | 9355024.0 |
| 2003-10-16 17:00:00 | AAPL | Stock | 0.4148 | 0.4155 | 0.4148 | 0.4148 | 910000.0 |
| 2003-10-16 18:00:00 | AAPL | Stock | 0.4148 | 0.4161 | 0.4134 | 0.4134 | 358848.0 |
| 2003-10-16 08:00:00 | MSFT | Stock | 29.0 | 29.25 | 28.96 | 29.0 | 12200.0 |
| 2003-10-16 09:00:00 | MSFT | Stock | 29.03 | 29.03 | 28.8 | 28.95 | 3994984.0 |
| 2003-10-16 10:00:00 | MSFT | Stock | 28.96 | 29.2 | 28.94 | 29.08 | 5777162.0 |
| 2003-10-16 11:00:00 | MSFT | Stock | 29.08 | 29.12 | 29.01 | 29.09 | 3588843.0 |
| 2003-10-16 12:00:00 | MSFT | Stock | 29.09 | 29.25 | 29.07 | 29.24 | 4756598.0 |
| 2003-10-16 13:00:00 | MSFT | Stock | 29.24 | 29.26 | 29.079 | 29.16 | 2596784.0 |
| 2003-10-16 14:00:00 | MSFT | Stock | 29.15 | 29.19 | 29.048 | 29.14 | 6005552.0 |
| 2003-10-16 15:00:00 | MSFT | Stock | 29.16 | 29.31 | 29.04 | 29.28 | 9151236.0 |
| 2003-10-16 16:00:00 | MSFT | Stock | 29.28 | 29.31 | 29.1 | 29.22 | 1637434.0 |
| 2003-10-16 17:00:00 | MSFT | Stock | 29.22 | 29.31 | 29.21 | 29.22 | 144500.0 |
| 2003-10-16 18:00:00 | MSFT | Stock | 29.22 | 29.22 | 29.22 | 29.22 | 700.0 |
| 2003-10-16 08:00:00 | NVDA | Stock | 0.1412 | 0.1418 | 0.1412 | 0.1418 | 240000.0 |
| 2003-10-16 09:00:00 | NVDA | Stock | 0.1419 | 0.1429 | 0.1396 | 0.1425 | 67638240.0 |
| 2003-10-16 10:00:00 | NVDA | Stock | 0.1424 | 0.1425 | 0.1406 | 0.1418 | 57661440.0 |
| 2003-10-16 11:00:00 | NVDA | Stock | 0.1418 | 0.1422 | 0.1413 | 0.1415 | 51616320.0 |
| 2003-10-16 12:00:00 | NVDA | Stock | 0.1414 | 0.1437 | 0.1414 | 0.1436 | 64230240.0 |
| 2003-10-16 13:00:00 | NVDA | Stock | 0.1437 | 0.1437 | 0.1429 | 0.143 | 38729280.0 |
| 2003-10-16 14:00:00 | NVDA | Stock | 0.1431 | 0.1438 | 0.1426 | 0.1432 | 32436000.0 |
| 2003-10-16 15:00:00 | NVDA | Stock | 0.1432 | 0.1437 | 0.1422 | 0.1433 | 61957680.0 |
| 2003-10-16 16:00:00 | NVDA | Stock | 0.1433 | 0.1433 | 0.1416 | 0.1433 | 38304000.0 |
| 2003-10-16 17:00:00 | NVDA | Stock | 0.1433 | 0.1434 | 0.1429 | 0.1434 | 984000.0 |
| 2003-10-16 18:00:00 | NVDA | Stock | 0.1429 | 0.1433 | 0.1429 | 0.1433 | 240000.0 |
| 2003-10-16 08:00:00 | AMZN | Stock | 2.9285 | 2.9375 | 2.9225 | 2.9245 | 339500.0 |
| 2003-10-16 09:00:00 | AMZN | Stock | 2.925 | 2.9525 | 2.9045 | 2.949 | 30685240.0 |
| 2003-10-16 10:00:00 | AMZN | Stock | 2.948 | 2.98 | 2.938 | 2.9535 | 41321520.0 |
| 2003-10-16 11:00:00 | AMZN | Stock | 2.954 | 2.9575 | 2.939 | 2.9555 | 13177260.0 |
| 2003-10-16 12:00:00 | AMZN | Stock | 2.9555 | 2.9815 | 2.952 | 2.981 | 19081480.0 |
| 2003-10-16 13:00:00 | AMZN | Stock | 2.981 | 2.985 | 2.9691 | 2.979 | 17656940.0 |
| 2003-10-16 14:00:00 | AMZN | Stock | 2.9795 | 2.99 | 2.962 | 2.97 | 18803520.0 |
| 2003-10-16 15:00:00 | AMZN | Stock | 2.97 | 2.9945 | 2.9575 | 2.9924 | 28330640.0 |
| 2003-10-16 16:00:00 | AMZN | Stock | 2.9945 | 3.01 | 2.742 | 2.915 | 19673700.0 |
| 2003-10-16 17:00:00 | AMZN | Stock | 2.915 | 2.992 | 2.915 | 2.936 | 3030740.0 |
| 2003-10-16 18:00:00 | AMZN | Stock | 2.9365 | 2.992 | 2.935 | 2.947 | 580000.0 |
| 2003-10-16 09:00:00 | CL | Stock | 29.2 | 29.235 | 29.11 | 29.17 | 295000.0 |
| 2003-10-16 10:00:00 | CL | Stock | 29.175 | 29.185 | 28.9 | 29.005 | 728200.0 |
| 2003-10-16 11:00:00 | CL | Stock | 29.015 | 29.02 | 28.875 | 28.98 | 660600.0 |
| 2003-10-16 12:00:00 | CL | Stock | 28.985 | 29.035 | 28.965 | 29.015 | 591400.0 |
| 2003-10-16 13:00:00 | CL | Stock | 29.01 | 29.04 | 28.94 | 28.945 | 347000.0 |
| 2003-10-16 14:00:00 | CL | Stock | 28.96 | 29.0 | 28.895 | 28.92 | 531600.0 |
> showing 50 of 22,331 rows — these rows as CSV