PREVIEW / stock_1hour / 2001-03-13
file: by_date/stock_1hour/2001/2001-03-13.parquet size: 362 KB rows: 16,924 symbols: 1,276
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 |
|---|---|---|---|---|---|---|---|
| 2001-03-13 08:00:00 | AAPL | Stock | 0.3348 | 0.3348 | 0.3337 | 0.3348 | 162400.0 |
| 2001-03-13 09:00:00 | AAPL | Stock | 0.3376 | 0.3404 | 0.3315 | 0.3326 | 84980000.0 |
| 2001-03-13 10:00:00 | AAPL | Stock | 0.3315 | 0.3371 | 0.3248 | 0.3281 | 86240000.0 |
| 2001-03-13 11:00:00 | AAPL | Stock | 0.327 | 0.3426 | 0.327 | 0.3415 | 69244000.0 |
| 2001-03-13 12:00:00 | AAPL | Stock | 0.3415 | 0.3471 | 0.3371 | 0.3393 | 38158400.0 |
| 2001-03-13 13:00:00 | AAPL | Stock | 0.3393 | 0.3471 | 0.3337 | 0.3371 | 33118400.0 |
| 2001-03-13 14:00:00 | AAPL | Stock | 0.3371 | 0.3415 | 0.3326 | 0.3415 | 55826400.0 |
| 2001-03-13 15:00:00 | AAPL | Stock | 0.3404 | 0.3493 | 0.3382 | 0.3482 | 58822400.0 |
| 2001-03-13 16:00:00 | AAPL | Stock | 0.3493 | 0.3493 | 0.3382 | 0.3493 | 6871200.0 |
| 2001-03-13 17:00:00 | AAPL | Stock | 0.3482 | 0.3499 | 0.3482 | 0.3493 | 89600.0 |
| 2001-03-13 18:00:00 | AAPL | Stock | 0.3443 | 0.351 | 0.3438 | 0.351 | 84000.0 |
| 2001-03-13 08:00:00 | MSFT | Stock | 25.8125 | 26.1562 | 25.8125 | 26.1562 | 271600.0 |
| 2001-03-13 09:00:00 | MSFT | Stock | 26.1562 | 26.8125 | 25.9375 | 26.4375 | 14717600.0 |
| 2001-03-13 10:00:00 | MSFT | Stock | 26.4531 | 27.0938 | 26.4062 | 26.8438 | 16412600.0 |
| 2001-03-13 11:00:00 | MSFT | Stock | 26.8438 | 26.9688 | 26.375 | 26.5 | 8787600.0 |
| 2001-03-13 12:00:00 | MSFT | Stock | 26.5 | 27.0156 | 26.4688 | 26.875 | 8978000.0 |
| 2001-03-13 13:00:00 | MSFT | Stock | 26.875 | 27.375 | 26.8438 | 27.1562 | 10417400.0 |
| 2001-03-13 14:00:00 | MSFT | Stock | 27.1562 | 27.3125 | 26.75 | 27.1875 | 9834400.0 |
| 2001-03-13 15:00:00 | MSFT | Stock | 27.1562 | 27.375 | 26.9062 | 27.125 | 16957000.0 |
| 2001-03-13 16:00:00 | MSFT | Stock | 27.0938 | 27.2188 | 26.7188 | 27.125 | 1730000.0 |
| 2001-03-13 17:00:00 | MSFT | Stock | 27.125 | 27.375 | 27.0938 | 27.1875 | 56800.0 |
| 2001-03-13 18:00:00 | MSFT | Stock | 27.3438 | 27.375 | 27.25 | 27.3438 | 2200.0 |
| 2001-03-13 08:00:00 | NVDA | Stock | 0.2031 | 0.2031 | 0.2016 | 0.2031 | 192000.0 |
| 2001-03-13 09:00:00 | NVDA | Stock | 0.2042 | 0.2078 | 0.2021 | 0.2057 | 130464000.0 |
| 2001-03-13 10:00:00 | NVDA | Stock | 0.206 | 0.2159 | 0.2049 | 0.2115 | 195216000.0 |
| 2001-03-13 11:00:00 | NVDA | Stock | 0.2115 | 0.2122 | 0.2026 | 0.2031 | 101208000.0 |
| 2001-03-13 12:00:00 | NVDA | Stock | 0.2034 | 0.2081 | 0.2026 | 0.2081 | 47136000.0 |
| 2001-03-13 13:00:00 | NVDA | Stock | 0.2081 | 0.2103 | 0.2063 | 0.2083 | 62520000.0 |
| 2001-03-13 14:00:00 | NVDA | Stock | 0.2083 | 0.2188 | 0.2078 | 0.2185 | 129552000.0 |
| 2001-03-13 15:00:00 | NVDA | Stock | 0.2188 | 0.2281 | 0.2177 | 0.2249 | 322056000.0 |
| 2001-03-13 16:00:00 | NVDA | Stock | 0.225 | 0.2263 | 0.2214 | 0.225 | 43416000.0 |
| 2001-03-13 17:00:00 | NVDA | Stock | 0.225 | 0.225 | 0.2229 | 0.2229 | 144000.0 |
| 2001-03-13 08:00:00 | AMZN | Stock | 0.525 | 0.5594 | 0.525 | 0.5406 | 136000.0 |
| 2001-03-13 09:00:00 | AMZN | Stock | 0.5406 | 0.55 | 0.5375 | 0.5406 | 12048000.0 |
| 2001-03-13 10:00:00 | AMZN | Stock | 0.5406 | 0.5469 | 0.5375 | 0.5406 | 9770000.0 |
| 2001-03-13 11:00:00 | AMZN | Stock | 0.5438 | 0.5438 | 0.5281 | 0.5312 | 7586000.0 |
| 2001-03-13 12:00:00 | AMZN | Stock | 0.5281 | 0.5312 | 0.525 | 0.525 | 6384000.0 |
| 2001-03-13 13:00:00 | AMZN | Stock | 0.525 | 0.5344 | 0.525 | 0.5312 | 6050000.0 |
| 2001-03-13 14:00:00 | AMZN | Stock | 0.5312 | 0.5375 | 0.525 | 0.5344 | 5224000.0 |
| 2001-03-13 15:00:00 | AMZN | Stock | 0.5344 | 0.5531 | 0.5312 | 0.5469 | 14676000.0 |
| 2001-03-13 16:00:00 | AMZN | Stock | 0.5469 | 0.55 | 0.5375 | 0.5438 | 2184000.0 |
| 2001-03-13 17:00:00 | AMZN | Stock | 0.5484 | 0.5562 | 0.5484 | 0.5562 | 108000.0 |
| 2001-03-13 18:00:00 | AMZN | Stock | 0.55 | 0.55 | 0.55 | 0.55 | 24000.0 |
| 2001-03-13 09:00:00 | CL | Stock | 28.45 | 28.45 | 28.1 | 28.1 | 455200.0 |
| 2001-03-13 10:00:00 | CL | Stock | 28.125 | 28.25 | 27.625 | 27.8 | 581800.0 |
| 2001-03-13 11:00:00 | CL | Stock | 27.8 | 28.025 | 27.79 | 27.83 | 316600.0 |
| 2001-03-13 12:00:00 | CL | Stock | 27.83 | 28.01 | 27.825 | 28.0 | 258400.0 |
| 2001-03-13 13:00:00 | CL | Stock | 28.0 | 28.325 | 28.0 | 28.15 | 378800.0 |
| 2001-03-13 14:00:00 | CL | Stock | 28.225 | 28.275 | 28.0 | 28.065 | 296800.0 |
| 2001-03-13 15:00:00 | CL | Stock | 28.06 | 28.2 | 28.05 | 28.2 | 426200.0 |
> showing 50 of 16,924 rows — these rows as CSV