PREVIEW / stock_1hour / 2004-10-26
file: by_date/stock_1hour/2004/2004-10-26.parquet size: 530 KB rows: 24,524 symbols: 1,849
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-26 08:00:00 | AAPL | Stock | 0.8491 | 0.8527 | 0.8491 | 0.85 | 61600.0 |
| 2004-10-26 09:00:00 | AAPL | Stock | 0.8495 | 0.8557 | 0.8455 | 0.8455 | 44435720.0 |
| 2004-10-26 10:00:00 | AAPL | Stock | 0.8461 | 0.8525 | 0.8436 | 0.8455 | 67485544.0 |
| 2004-10-26 11:00:00 | AAPL | Stock | 0.8452 | 0.8466 | 0.8388 | 0.8454 | 45341800.0 |
| 2004-10-26 12:00:00 | AAPL | Stock | 0.8455 | 0.8513 | 0.8436 | 0.8488 | 57129464.0 |
| 2004-10-26 13:00:00 | AAPL | Stock | 0.8484 | 0.8545 | 0.8471 | 0.8493 | 101188080.0 |
| 2004-10-26 14:00:00 | AAPL | Stock | 0.8493 | 0.8514 | 0.848 | 0.8498 | 98727944.0 |
| 2004-10-26 15:00:00 | AAPL | Stock | 0.8498 | 0.858 | 0.8479 | 0.8555 | 129040016.0 |
| 2004-10-26 16:00:00 | AAPL | Stock | 0.8555 | 0.8691 | 0.8492 | 0.8596 | 22139544.0 |
| 2004-10-26 17:00:00 | AAPL | Stock | 0.8596 | 0.8661 | 0.8566 | 0.8566 | 319536.0 |
| 2004-10-26 18:00:00 | AAPL | Stock | 0.86 | 0.86 | 0.86 | 0.86 | 110600.0 |
| 2004-10-26 08:00:00 | MSFT | Stock | 27.62 | 27.73 | 27.62 | 27.7 | 50121.0 |
| 2004-10-26 09:00:00 | MSFT | Stock | 27.71 | 27.84 | 27.63 | 27.66 | 9386252.0 |
| 2004-10-26 10:00:00 | MSFT | Stock | 27.66 | 27.77 | 27.65 | 27.68 | 15745014.0 |
| 2004-10-26 11:00:00 | MSFT | Stock | 27.68 | 27.75 | 27.629 | 27.74 | 8147230.0 |
| 2004-10-26 12:00:00 | MSFT | Stock | 27.74 | 27.83 | 27.7 | 27.75 | 7296838.0 |
| 2004-10-26 13:00:00 | MSFT | Stock | 27.74 | 27.82 | 27.71 | 27.74 | 8210618.0 |
| 2004-10-26 14:00:00 | MSFT | Stock | 27.75 | 27.8 | 27.72 | 27.78 | 6616701.0 |
| 2004-10-26 15:00:00 | MSFT | Stock | 27.77 | 27.9 | 27.71 | 27.9 | 12286894.0 |
| 2004-10-26 16:00:00 | MSFT | Stock | 27.89 | 27.9 | 27.74 | 27.9 | 6075474.0 |
| 2004-10-26 17:00:00 | MSFT | Stock | 27.88 | 27.9 | 27.7622 | 27.9 | 115874.0 |
| 2004-10-26 18:00:00 | MSFT | Stock | 27.85 | 27.89 | 27.85 | 27.89 | 13264.0 |
| 2004-10-26 08:00:00 | NVDA | Stock | 0.1244 | 0.1254 | 0.1185 | 0.1217 | 36454680.0 |
| 2004-10-26 09:00:00 | NVDA | Stock | 0.1217 | 0.125 | 0.1119 | 0.1189 | 427001040.0 |
| 2004-10-26 10:00:00 | NVDA | Stock | 0.1189 | 0.1246 | 0.1181 | 0.124 | 550140960.0 |
| 2004-10-26 11:00:00 | NVDA | Stock | 0.124 | 0.1266 | 0.1237 | 0.1253 | 390261840.0 |
| 2004-10-26 12:00:00 | NVDA | Stock | 0.1253 | 0.1257 | 0.1243 | 0.1252 | 175216680.0 |
| 2004-10-26 13:00:00 | NVDA | Stock | 0.1252 | 0.1255 | 0.1221 | 0.1222 | 245577960.0 |
| 2004-10-26 14:00:00 | NVDA | Stock | 0.1221 | 0.1228 | 0.1208 | 0.1215 | 177825360.0 |
| 2004-10-26 15:00:00 | NVDA | Stock | 0.1216 | 0.1221 | 0.1205 | 0.1205 | 356356080.0 |
| 2004-10-26 16:00:00 | NVDA | Stock | 0.1207 | 0.1216 | 0.1204 | 0.1207 | 28443480.0 |
| 2004-10-26 17:00:00 | NVDA | Stock | 0.121 | 0.1212 | 0.1207 | 0.1207 | 1244400.0 |
| 2004-10-26 18:00:00 | NVDA | Stock | 0.1208 | 0.1208 | 0.1208 | 0.1208 | 108000.0 |
| 2004-10-26 08:00:00 | AMZN | Stock | 1.7025 | 1.713 | 1.7015 | 1.705 | 69300.0 |
| 2004-10-26 09:00:00 | AMZN | Stock | 1.712 | 1.72 | 1.676 | 1.6785 | 24619980.0 |
| 2004-10-26 10:00:00 | AMZN | Stock | 1.6785 | 1.7 | 1.6755 | 1.6915 | 31133100.0 |
| 2004-10-26 11:00:00 | AMZN | Stock | 1.691 | 1.713 | 1.6875 | 1.697 | 21437440.0 |
| 2004-10-26 12:00:00 | AMZN | Stock | 1.697 | 1.705 | 1.6945 | 1.699 | 15859680.0 |
| 2004-10-26 13:00:00 | AMZN | Stock | 1.699 | 1.7065 | 1.6985 | 1.7015 | 23290320.0 |
| 2004-10-26 14:00:00 | AMZN | Stock | 1.7015 | 1.704 | 1.694 | 1.6985 | 23626800.0 |
| 2004-10-26 15:00:00 | AMZN | Stock | 1.698 | 1.7025 | 1.6855 | 1.692 | 30032740.0 |
| 2004-10-26 16:00:00 | AMZN | Stock | 1.692 | 1.6975 | 1.689 | 1.6911 | 2990940.0 |
| 2004-10-26 17:00:00 | AMZN | Stock | 1.6892 | 1.6915 | 1.689 | 1.6915 | 161400.0 |
| 2004-10-26 18:00:00 | AMZN | Stock | 1.689 | 1.69 | 1.689 | 1.69 | 31840.0 |
| 2004-10-26 09:00:00 | CL | Stock | 22.5 | 22.53 | 22.385 | 22.4 | 367400.0 |
| 2004-10-26 10:00:00 | CL | Stock | 22.4 | 22.595 | 22.375 | 22.535 | 701400.0 |
| 2004-10-26 11:00:00 | CL | Stock | 22.535 | 22.56 | 22.5 | 22.55 | 601600.0 |
| 2004-10-26 12:00:00 | CL | Stock | 22.55 | 22.65 | 22.53 | 22.555 | 573400.0 |
| 2004-10-26 13:00:00 | CL | Stock | 22.55 | 22.66 | 22.55 | 22.63 | 656400.0 |
| 2004-10-26 14:00:00 | CL | Stock | 22.63 | 22.695 | 22.555 | 22.67 | 834000.0 |
> showing 50 of 24,524 rows — these rows as CSV