PREVIEW / stock_1hour / 2004-10-05
file: by_date/stock_1hour/2004/2004-10-05.parquet size: 512 KB rows: 24,135 symbols: 1,839
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 |
|---|---|---|---|---|---|---|---|
| 2004-10-05 08:00:00 | AAPL | Stock | 0.6889 | 0.692 | 0.6859 | 0.6877 | 181440.0 |
| 2004-10-05 09:00:00 | AAPL | Stock | 0.6877 | 0.695 | 0.6857 | 0.6936 | 36656032.0 |
| 2004-10-05 10:00:00 | AAPL | Stock | 0.6934 | 0.6991 | 0.6914 | 0.6946 | 58223648.0 |
| 2004-10-05 11:00:00 | AAPL | Stock | 0.6945 | 0.6968 | 0.6923 | 0.6943 | 33562200.0 |
| 2004-10-05 12:00:00 | AAPL | Stock | 0.6943 | 0.6995 | 0.6941 | 0.698 | 28829416.0 |
| 2004-10-05 13:00:00 | AAPL | Stock | 0.698 | 0.7039 | 0.6971 | 0.7005 | 43354528.0 |
| 2004-10-05 14:00:00 | AAPL | Stock | 0.7005 | 0.7016 | 0.6971 | 0.6991 | 36391264.0 |
| 2004-10-05 15:00:00 | AAPL | Stock | 0.6989 | 0.7084 | 0.6979 | 0.7077 | 110194336.0 |
| 2004-10-05 16:00:00 | AAPL | Stock | 0.7077 | 0.7079 | 0.6994 | 0.7079 | 33656504.0 |
| 2004-10-05 17:00:00 | AAPL | Stock | 0.7023 | 0.7075 | 0.7018 | 0.703 | 235200.0 |
| 2004-10-05 18:00:00 | AAPL | Stock | 0.6982 | 0.6982 | 0.6982 | 0.6982 | 196280.0 |
| 2004-10-05 08:00:00 | MSFT | Stock | 28.12 | 28.15 | 28.09 | 28.11 | 31335.0 |
| 2004-10-05 09:00:00 | MSFT | Stock | 28.11 | 28.34 | 28.06 | 28.3 | 6718400.0 |
| 2004-10-05 10:00:00 | MSFT | Stock | 28.31 | 28.4 | 28.21 | 28.32 | 11808039.0 |
| 2004-10-05 11:00:00 | MSFT | Stock | 28.32 | 28.33 | 28.27 | 28.31 | 9140398.0 |
| 2004-10-05 12:00:00 | MSFT | Stock | 28.31 | 28.44 | 28.3 | 28.42 | 6221285.0 |
| 2004-10-05 13:00:00 | MSFT | Stock | 28.42 | 28.45 | 28.29 | 28.3 | 7509709.0 |
| 2004-10-05 14:00:00 | MSFT | Stock | 28.3 | 28.4 | 28.27 | 28.34 | 7401840.0 |
| 2004-10-05 15:00:00 | MSFT | Stock | 28.33 | 28.41 | 28.3 | 28.38 | 5350704.0 |
| 2004-10-05 16:00:00 | MSFT | Stock | 28.38 | 28.43 | 28.38 | 28.4 | 2213676.0 |
| 2004-10-05 17:00:00 | MSFT | Stock | 28.37 | 28.42 | 28.37 | 28.42 | 600.0 |
| 2004-10-05 18:00:00 | MSFT | Stock | 28.4 | 28.43 | 28.4 | 28.43 | 5800.0 |
| 2004-10-05 08:00:00 | NVDA | Stock | 0.1291 | 0.1295 | 0.1291 | 0.1291 | 132000.0 |
| 2004-10-05 09:00:00 | NVDA | Stock | 0.1287 | 0.1287 | 0.1263 | 0.1277 | 84526320.0 |
| 2004-10-05 10:00:00 | NVDA | Stock | 0.1277 | 0.1297 | 0.1265 | 0.1278 | 156874320.0 |
| 2004-10-05 11:00:00 | NVDA | Stock | 0.1279 | 0.1284 | 0.1267 | 0.1277 | 77077200.0 |
| 2004-10-05 12:00:00 | NVDA | Stock | 0.1276 | 0.1283 | 0.1272 | 0.1282 | 61668480.0 |
| 2004-10-05 13:00:00 | NVDA | Stock | 0.1281 | 0.1283 | 0.1274 | 0.1276 | 29716320.0 |
| 2004-10-05 14:00:00 | NVDA | Stock | 0.1276 | 0.1279 | 0.1258 | 0.1262 | 119904720.0 |
| 2004-10-05 15:00:00 | NVDA | Stock | 0.1262 | 0.1273 | 0.1255 | 0.1267 | 85578000.0 |
| 2004-10-05 16:00:00 | NVDA | Stock | 0.1267 | 0.1274 | 0.1264 | 0.1274 | 2157240.0 |
| 2004-10-05 17:00:00 | NVDA | Stock | 0.1273 | 0.1273 | 0.1271 | 0.1271 | 36000.0 |
| 2004-10-05 18:00:00 | NVDA | Stock | 0.128 | 0.128 | 0.128 | 0.128 | 60000.0 |
| 2004-10-05 08:00:00 | AMZN | Stock | 2.0505 | 2.0505 | 2.045 | 2.046 | 69000.0 |
| 2004-10-05 09:00:00 | AMZN | Stock | 2.0495 | 2.0575 | 2.0335 | 2.042 | 17221420.0 |
| 2004-10-05 10:00:00 | AMZN | Stock | 2.0415 | 2.048 | 2.0285 | 2.0375 | 24374020.0 |
| 2004-10-05 11:00:00 | AMZN | Stock | 2.0375 | 2.0515 | 2.0345 | 2.0485 | 9557960.0 |
| 2004-10-05 12:00:00 | AMZN | Stock | 2.0485 | 2.0625 | 2.046 | 2.0585 | 10494260.0 |
| 2004-10-05 13:00:00 | AMZN | Stock | 2.0585 | 2.062 | 2.049 | 2.049 | 7516580.0 |
| 2004-10-05 14:00:00 | AMZN | Stock | 2.0495 | 2.0545 | 2.038 | 2.0405 | 13864240.0 |
| 2004-10-05 15:00:00 | AMZN | Stock | 2.04 | 2.053 | 2.0355 | 2.0465 | 16568500.0 |
| 2004-10-05 16:00:00 | AMZN | Stock | 2.048 | 2.0525 | 2.0475 | 2.052 | 315400.0 |
| 2004-10-05 17:00:00 | AMZN | Stock | 2.052 | 2.055 | 2.0472 | 2.048 | 230360.0 |
| 2004-10-05 18:00:00 | AMZN | Stock | 2.0565 | 2.0565 | 2.0555 | 2.0555 | 14100.0 |
| 2004-10-05 08:00:00 | CL | Stock | 22.46 | 22.46 | 22.45 | 22.45 | 3000.0 |
| 2004-10-05 09:00:00 | CL | Stock | 22.35 | 22.35 | 22.22 | 22.254 | 1581000.0 |
| 2004-10-05 10:00:00 | CL | Stock | 22.25 | 22.385 | 22.19 | 22.275 | 2149600.0 |
| 2004-10-05 11:00:00 | CL | Stock | 22.275 | 22.35 | 22.175 | 22.315 | 2037400.0 |
| 2004-10-05 12:00:00 | CL | Stock | 22.31 | 22.355 | 22.285 | 22.33 | 1347200.0 |
| 2004-10-05 13:00:00 | CL | Stock | 22.34 | 22.35 | 22.255 | 22.26 | 813000.0 |
> showing 50 of 24,135 rows — these rows as CSV