PREVIEW / stock_1hour / 2000-09-26
file: by_date/stock_1hour/2000/2000-09-26.parquet size: 310 KB rows: 15,595 symbols: 1,230
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 |
|---|---|---|---|---|---|---|---|
| 2000-09-26 08:00:00 | AAPL | Stock | 0.9554 | 0.9554 | 0.9554 | 0.9554 | 414400.0 |
| 2000-09-26 09:00:00 | AAPL | Stock | 0.9565 | 0.9565 | 0.9375 | 0.9542 | 33588800.0 |
| 2000-09-26 10:00:00 | AAPL | Stock | 0.9542 | 0.9777 | 0.9397 | 0.9509 | 57825600.0 |
| 2000-09-26 11:00:00 | AAPL | Stock | 0.952 | 0.952 | 0.9397 | 0.9498 | 55160000.0 |
| 2000-09-26 12:00:00 | AAPL | Stock | 0.9487 | 0.9498 | 0.9364 | 0.9375 | 15355200.0 |
| 2000-09-26 13:00:00 | AAPL | Stock | 0.9375 | 0.9621 | 0.9364 | 0.9453 | 26185600.0 |
| 2000-09-26 14:00:00 | AAPL | Stock | 0.9448 | 0.9576 | 0.9342 | 0.9364 | 19236000.0 |
| 2000-09-26 15:00:00 | AAPL | Stock | 0.9375 | 0.9386 | 0.9174 | 0.918 | 61779200.0 |
| 2000-09-26 16:00:00 | AAPL | Stock | 0.9185 | 0.9241 | 0.9129 | 0.9241 | 3550400.0 |
| 2000-09-26 17:00:00 | AAPL | Stock | 0.9169 | 0.9169 | 0.9169 | 0.9169 | 5600.0 |
| 2000-09-26 08:00:00 | MSFT | Stock | 30.625 | 30.625 | 30.4688 | 30.5938 | 97800.0 |
| 2000-09-26 09:00:00 | MSFT | Stock | 30.5625 | 30.6875 | 30.2188 | 30.4375 | 7570600.0 |
| 2000-09-26 10:00:00 | MSFT | Stock | 30.4375 | 32.9375 | 30.4062 | 32.125 | 58690800.0 |
| 2000-09-26 11:00:00 | MSFT | Stock | 32.0938 | 32.125 | 31.5 | 31.7812 | 17432200.0 |
| 2000-09-26 12:00:00 | MSFT | Stock | 31.75 | 32.125 | 31.625 | 32.0 | 8834600.0 |
| 2000-09-26 13:00:00 | MSFT | Stock | 32.0 | 32.25 | 31.4375 | 31.75 | 9393800.0 |
| 2000-09-26 14:00:00 | MSFT | Stock | 31.7188 | 31.7812 | 30.6875 | 30.9062 | 20474200.0 |
| 2000-09-26 15:00:00 | MSFT | Stock | 30.9375 | 31.4375 | 30.9062 | 31.3125 | 20488000.0 |
| 2000-09-26 16:00:00 | MSFT | Stock | 31.3438 | 32.375 | 30.9062 | 31.3125 | 6909000.0 |
| 2000-09-26 17:00:00 | MSFT | Stock | 31.3125 | 31.4062 | 31.25 | 31.4062 | 34200.0 |
| 2000-09-26 18:00:00 | MSFT | Stock | 31.4688 | 31.5 | 31.4062 | 31.4219 | 8400.0 |
| 2000-09-26 09:00:00 | NVDA | Stock | 0.3177 | 0.3214 | 0.3042 | 0.3107 | 28824000.0 |
| 2000-09-26 10:00:00 | NVDA | Stock | 0.3122 | 0.3266 | 0.3108 | 0.3193 | 81408000.0 |
| 2000-09-26 11:00:00 | NVDA | Stock | 0.3195 | 0.3219 | 0.3167 | 0.3208 | 41544000.0 |
| 2000-09-26 12:00:00 | NVDA | Stock | 0.3208 | 0.3208 | 0.3167 | 0.3185 | 28872000.0 |
| 2000-09-26 13:00:00 | NVDA | Stock | 0.3185 | 0.3208 | 0.3172 | 0.3177 | 21624000.0 |
| 2000-09-26 14:00:00 | NVDA | Stock | 0.3177 | 0.3198 | 0.3167 | 0.3188 | 20904000.0 |
| 2000-09-26 15:00:00 | NVDA | Stock | 0.319 | 0.324 | 0.3188 | 0.3229 | 93552000.0 |
| 2000-09-26 16:00:00 | NVDA | Stock | 0.3229 | 0.3229 | 0.3167 | 0.3199 | 10920000.0 |
| 2000-09-26 08:00:00 | AMZN | Stock | 2.0 | 2.0219 | 2.0 | 2.0219 | 62000.0 |
| 2000-09-26 09:00:00 | AMZN | Stock | 2.025 | 2.0406 | 1.9969 | 2.025 | 6636000.0 |
| 2000-09-26 10:00:00 | AMZN | Stock | 2.025 | 2.0562 | 2.0156 | 2.0281 | 10656000.0 |
| 2000-09-26 11:00:00 | AMZN | Stock | 2.0281 | 2.0344 | 2.0 | 2.0125 | 7468000.0 |
| 2000-09-26 12:00:00 | AMZN | Stock | 2.0062 | 2.0125 | 1.9812 | 1.9938 | 16722000.0 |
| 2000-09-26 13:00:00 | AMZN | Stock | 1.9875 | 2.0125 | 1.9812 | 2.0062 | 13340000.0 |
| 2000-09-26 14:00:00 | AMZN | Stock | 2.0078 | 2.0125 | 1.9812 | 1.9906 | 13204000.0 |
| 2000-09-26 15:00:00 | AMZN | Stock | 1.9906 | 2.0 | 1.9781 | 1.9906 | 13610000.0 |
| 2000-09-26 16:00:00 | AMZN | Stock | 1.9906 | 2.0 | 1.975 | 1.9875 | 1942000.0 |
| 2000-09-26 17:00:00 | AMZN | Stock | 1.9875 | 1.9875 | 1.9875 | 1.9875 | 4000.0 |
| 2000-09-26 09:00:00 | CL | Stock | 22.875 | 22.875 | 22.465 | 22.58 | 588200.0 |
| 2000-09-26 10:00:00 | CL | Stock | 22.58 | 22.65 | 22.44 | 22.62 | 410200.0 |
| 2000-09-26 11:00:00 | CL | Stock | 22.625 | 22.75 | 22.6 | 22.725 | 490600.0 |
| 2000-09-26 12:00:00 | CL | Stock | 22.72 | 22.8 | 22.645 | 22.67 | 359000.0 |
| 2000-09-26 13:00:00 | CL | Stock | 22.67 | 22.76 | 22.65 | 22.7 | 398000.0 |
| 2000-09-26 14:00:00 | CL | Stock | 22.7 | 22.725 | 22.5 | 22.525 | 450200.0 |
| 2000-09-26 15:00:00 | CL | Stock | 22.515 | 22.675 | 22.51 | 22.595 | 747800.0 |
| 2000-09-26 16:00:00 | CL | Stock | 22.595 | 22.595 | 22.595 | 22.595 | 84000.0 |
> showing 47 of 15,595 rows — these rows as CSV