PREVIEW / stock_1hour / 2000-10-03
file: by_date/stock_1hour/2000/2000-10-03.parquet size: 312 KB rows: 15,817 symbols: 1,238
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-10-03 08:00:00 | AAPL | Stock | 0.4453 | 0.4464 | 0.4342 | 0.442 | 3959200.0 |
| 2000-10-03 09:00:00 | AAPL | Stock | 0.4386 | 0.4475 | 0.4185 | 0.4196 | 238173600.0 |
| 2000-10-03 10:00:00 | AAPL | Stock | 0.4185 | 0.4208 | 0.4063 | 0.4085 | 525963200.0 |
| 2000-10-03 11:00:00 | AAPL | Stock | 0.4085 | 0.4152 | 0.4018 | 0.4141 | 282469600.0 |
| 2000-10-03 12:00:00 | AAPL | Stock | 0.4141 | 0.4174 | 0.4107 | 0.4129 | 181708800.0 |
| 2000-10-03 13:00:00 | AAPL | Stock | 0.4141 | 0.4196 | 0.4129 | 0.4185 | 112000000.0 |
| 2000-10-03 14:00:00 | AAPL | Stock | 0.4185 | 0.4208 | 0.4063 | 0.4096 | 228384800.0 |
| 2000-10-03 15:00:00 | AAPL | Stock | 0.4096 | 0.4107 | 0.3962 | 0.3973 | 349417600.0 |
| 2000-10-03 16:00:00 | AAPL | Stock | 0.3973 | 0.4442 | 0.3951 | 0.4007 | 37805600.0 |
| 2000-10-03 17:00:00 | AAPL | Stock | 0.3996 | 0.4063 | 0.3973 | 0.4018 | 392000.0 |
| 2000-10-03 18:00:00 | AAPL | Stock | 0.4018 | 0.404 | 0.3996 | 0.404 | 649600.0 |
| 2000-10-03 08:00:00 | MSFT | Stock | 29.5469 | 30.0 | 29.5 | 29.8438 | 50600.0 |
| 2000-10-03 09:00:00 | MSFT | Stock | 29.8125 | 29.9062 | 29.5 | 29.5 | 8751400.0 |
| 2000-10-03 10:00:00 | MSFT | Stock | 29.5 | 29.5625 | 29.2188 | 29.25 | 11274400.0 |
| 2000-10-03 11:00:00 | MSFT | Stock | 29.2188 | 29.5 | 29.0312 | 29.4688 | 9200000.0 |
| 2000-10-03 12:00:00 | MSFT | Stock | 29.4375 | 29.5312 | 29.2188 | 29.3125 | 6009400.0 |
| 2000-10-03 13:00:00 | MSFT | Stock | 29.2812 | 29.3438 | 29.1562 | 29.2812 | 6345800.0 |
| 2000-10-03 14:00:00 | MSFT | Stock | 29.25 | 29.2969 | 28.875 | 28.8906 | 11423600.0 |
| 2000-10-03 15:00:00 | MSFT | Stock | 28.875 | 28.9688 | 28.25 | 28.2812 | 20721000.0 |
| 2000-10-03 16:00:00 | MSFT | Stock | 28.3125 | 29.0938 | 28.0 | 28.25 | 8745600.0 |
| 2000-10-03 17:00:00 | MSFT | Stock | 28.25 | 28.4219 | 28.1875 | 28.4219 | 56200.0 |
| 2000-10-03 18:00:00 | MSFT | Stock | 28.4688 | 28.5 | 28.3438 | 28.4688 | 9600.0 |
| 2000-10-03 08:00:00 | NVDA | Stock | 0.3324 | 0.3375 | 0.3324 | 0.3365 | 6672000.0 |
| 2000-10-03 09:00:00 | NVDA | Stock | 0.3375 | 0.3385 | 0.3292 | 0.3302 | 21792000.0 |
| 2000-10-03 10:00:00 | NVDA | Stock | 0.3307 | 0.3331 | 0.3219 | 0.3219 | 44208000.0 |
| 2000-10-03 11:00:00 | NVDA | Stock | 0.3219 | 0.3219 | 0.3125 | 0.3214 | 51600000.0 |
| 2000-10-03 12:00:00 | NVDA | Stock | 0.3208 | 0.3276 | 0.3208 | 0.3271 | 18072000.0 |
| 2000-10-03 13:00:00 | NVDA | Stock | 0.3273 | 0.3349 | 0.3255 | 0.3318 | 34680000.0 |
| 2000-10-03 14:00:00 | NVDA | Stock | 0.3328 | 0.3333 | 0.325 | 0.3292 | 25560000.0 |
| 2000-10-03 15:00:00 | NVDA | Stock | 0.3271 | 0.3297 | 0.3154 | 0.3154 | 79248000.0 |
| 2000-10-03 16:00:00 | NVDA | Stock | 0.3156 | 0.3341 | 0.3146 | 0.3156 | 6000000.0 |
| 2000-10-03 08:00:00 | AMZN | Stock | 1.8469 | 1.85 | 1.825 | 1.825 | 90000.0 |
| 2000-10-03 09:00:00 | AMZN | Stock | 1.825 | 1.85 | 1.8062 | 1.8391 | 7436000.0 |
| 2000-10-03 10:00:00 | AMZN | Stock | 1.8344 | 1.8375 | 1.8 | 1.8031 | 13810000.0 |
| 2000-10-03 11:00:00 | AMZN | Stock | 1.8031 | 1.8625 | 1.7969 | 1.8469 | 28236000.0 |
| 2000-10-03 12:00:00 | AMZN | Stock | 1.85 | 1.8625 | 1.8281 | 1.8312 | 8036000.0 |
| 2000-10-03 13:00:00 | AMZN | Stock | 1.8312 | 1.85 | 1.8281 | 1.85 | 3954000.0 |
| 2000-10-03 14:00:00 | AMZN | Stock | 1.8469 | 1.8531 | 1.8156 | 1.8344 | 13910000.0 |
| 2000-10-03 15:00:00 | AMZN | Stock | 1.8312 | 1.8375 | 1.75 | 1.7562 | 25154000.0 |
| 2000-10-03 16:00:00 | AMZN | Stock | 1.7562 | 1.7562 | 1.7406 | 1.75 | 2700000.0 |
| 2000-10-03 17:00:00 | AMZN | Stock | 1.75 | 1.8 | 1.75 | 1.7516 | 102000.0 |
| 2000-10-03 18:00:00 | AMZN | Stock | 1.75 | 1.75 | 1.75 | 1.75 | 10000.0 |
| 2000-10-03 09:00:00 | CL | Stock | 23.9 | 23.9 | 23.75 | 23.805 | 423000.0 |
| 2000-10-03 10:00:00 | CL | Stock | 23.78 | 23.78 | 23.63 | 23.705 | 321800.0 |
| 2000-10-03 11:00:00 | CL | Stock | 23.705 | 23.705 | 23.375 | 23.405 | 408600.0 |
| 2000-10-03 12:00:00 | CL | Stock | 23.41 | 23.575 | 23.35 | 23.4 | 459800.0 |
| 2000-10-03 13:00:00 | CL | Stock | 23.385 | 23.525 | 23.385 | 23.5 | 119800.0 |
| 2000-10-03 14:00:00 | CL | Stock | 23.505 | 23.51 | 23.3 | 23.5 | 307200.0 |
| 2000-10-03 15:00:00 | CL | Stock | 23.51 | 23.55 | 23.1 | 23.125 | 561000.0 |
| 2000-10-03 16:00:00 | CL | Stock | 23.125 | 23.25 | 23.125 | 23.25 | 52400.0 |
> showing 50 of 15,817 rows — these rows as CSV