PREVIEW / stock_1hour / 2001-10-03
file: by_date/stock_1hour/2001/2001-10-03.parquet size: 369 KB rows: 17,628 symbols: 1,342
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-10-03 08:00:00 | AAPL | Stock | 0.2679 | 0.2679 | 0.2643 | 0.2643 | 229600.0 |
| 2001-10-03 09:00:00 | AAPL | Stock | 0.2643 | 0.2695 | 0.2641 | 0.2654 | 34652800.0 |
| 2001-10-03 10:00:00 | AAPL | Stock | 0.2654 | 0.2693 | 0.2652 | 0.2675 | 57668800.0 |
| 2001-10-03 11:00:00 | AAPL | Stock | 0.2675 | 0.273 | 0.2663 | 0.2716 | 86564800.0 |
| 2001-10-03 12:00:00 | AAPL | Stock | 0.2707 | 0.2725 | 0.2679 | 0.2714 | 83843200.0 |
| 2001-10-03 13:00:00 | AAPL | Stock | 0.2721 | 0.2721 | 0.2673 | 0.2691 | 82975200.0 |
| 2001-10-03 14:00:00 | AAPL | Stock | 0.2689 | 0.2743 | 0.2678 | 0.2714 | 95418400.0 |
| 2001-10-03 15:00:00 | AAPL | Stock | 0.2716 | 0.2741 | 0.2668 | 0.2675 | 167888000.0 |
| 2001-10-03 16:00:00 | AAPL | Stock | 0.2673 | 0.2712 | 0.2652 | 0.2673 | 17852800.0 |
| 2001-10-03 17:00:00 | AAPL | Stock | 0.2675 | 0.2679 | 0.2675 | 0.2679 | 2413600.0 |
| 2001-10-03 18:00:00 | AAPL | Stock | 0.2691 | 0.2705 | 0.2689 | 0.2689 | 3561600.0 |
| 2001-10-03 08:00:00 | MSFT | Stock | 26.31 | 26.355 | 26.0915 | 26.19 | 52600.0 |
| 2001-10-03 09:00:00 | MSFT | Stock | 26.2 | 26.5235 | 26.175 | 26.38 | 8100800.0 |
| 2001-10-03 10:00:00 | MSFT | Stock | 26.38 | 27.25 | 26.325 | 27.2 | 19060000.0 |
| 2001-10-03 11:00:00 | MSFT | Stock | 27.202 | 27.61 | 27.145 | 27.515 | 13145400.0 |
| 2001-10-03 12:00:00 | MSFT | Stock | 27.51 | 27.9755 | 27.355 | 27.945 | 9621800.0 |
| 2001-10-03 13:00:00 | MSFT | Stock | 27.945 | 28.27 | 27.675 | 28.185 | 12177200.0 |
| 2001-10-03 14:00:00 | MSFT | Stock | 28.19 | 28.375 | 27.8195 | 28.31 | 11099400.0 |
| 2001-10-03 15:00:00 | MSFT | Stock | 28.315 | 28.465 | 27.8115 | 28.115 | 14556400.0 |
| 2001-10-03 16:00:00 | MSFT | Stock | 28.115 | 28.425 | 27.4724 | 28.15 | 4298800.0 |
| 2001-10-03 17:00:00 | MSFT | Stock | 28.15 | 28.15 | 28.09 | 28.09 | 374000.0 |
| 2001-10-03 18:00:00 | MSFT | Stock | 28.08 | 28.45 | 27.91 | 28.375 | 217000.0 |
| 2001-10-03 08:00:00 | NVDA | Stock | 0.1958 | 0.1986 | 0.1942 | 0.1975 | 744000.0 |
| 2001-10-03 09:00:00 | NVDA | Stock | 0.1979 | 0.2079 | 0.1967 | 0.205 | 172548000.0 |
| 2001-10-03 10:00:00 | NVDA | Stock | 0.205 | 0.2221 | 0.2032 | 0.2192 | 278748000.0 |
| 2001-10-03 11:00:00 | NVDA | Stock | 0.2193 | 0.2403 | 0.2152 | 0.2371 | 327264000.0 |
| 2001-10-03 12:00:00 | NVDA | Stock | 0.2372 | 0.2392 | 0.2285 | 0.2363 | 203352000.0 |
| 2001-10-03 13:00:00 | NVDA | Stock | 0.2363 | 0.2446 | 0.2325 | 0.2416 | 207336000.0 |
| 2001-10-03 14:00:00 | NVDA | Stock | 0.2416 | 0.2442 | 0.2372 | 0.2425 | 150276000.0 |
| 2001-10-03 15:00:00 | NVDA | Stock | 0.2425 | 0.2507 | 0.2378 | 0.2382 | 315384000.0 |
| 2001-10-03 16:00:00 | NVDA | Stock | 0.238 | 0.2436 | 0.228 | 0.2403 | 30360000.0 |
| 2001-10-03 17:00:00 | NVDA | Stock | 0.2403 | 0.2436 | 0.2382 | 0.2396 | 2040000.0 |
| 2001-10-03 18:00:00 | NVDA | Stock | 0.2401 | 0.2401 | 0.24 | 0.24 | 312000.0 |
| 2001-10-03 08:00:00 | AMZN | Stock | 0.3 | 0.3 | 0.3 | 0.3 | 2000.0 |
| 2001-10-03 09:00:00 | AMZN | Stock | 0.3 | 0.313 | 0.3 | 0.31 | 12924000.0 |
| 2001-10-03 10:00:00 | AMZN | Stock | 0.31 | 0.3275 | 0.304 | 0.3235 | 17452000.0 |
| 2001-10-03 11:00:00 | AMZN | Stock | 0.323 | 0.3465 | 0.3225 | 0.344 | 19140000.0 |
| 2001-10-03 12:00:00 | AMZN | Stock | 0.344 | 0.3495 | 0.3275 | 0.3495 | 9018000.0 |
| 2001-10-03 13:00:00 | AMZN | Stock | 0.3491 | 0.3605 | 0.345 | 0.3605 | 9462000.0 |
| 2001-10-03 14:00:00 | AMZN | Stock | 0.36 | 0.3605 | 0.3445 | 0.348 | 8298000.0 |
| 2001-10-03 15:00:00 | AMZN | Stock | 0.348 | 0.351 | 0.334 | 0.338 | 18358000.0 |
| 2001-10-03 16:00:00 | AMZN | Stock | 0.34 | 0.34 | 0.3355 | 0.338 | 2490000.0 |
| 2001-10-03 17:00:00 | AMZN | Stock | 0.338 | 0.338 | 0.338 | 0.338 | 476000.0 |
| 2001-10-03 09:00:00 | CL | Stock | 28.5 | 28.61 | 28.4 | 28.415 | 410400.0 |
| 2001-10-03 10:00:00 | CL | Stock | 28.415 | 28.44 | 28.14 | 28.14 | 443400.0 |
| 2001-10-03 11:00:00 | CL | Stock | 28.135 | 28.245 | 28.055 | 28.145 | 511200.0 |
| 2001-10-03 12:00:00 | CL | Stock | 28.135 | 28.175 | 28.04 | 28.05 | 846400.0 |
| 2001-10-03 13:00:00 | CL | Stock | 28.055 | 28.15 | 27.75 | 28.13 | 580000.0 |
| 2001-10-03 14:00:00 | CL | Stock | 28.13 | 28.225 | 28.05 | 28.11 | 416000.0 |
| 2001-10-03 15:00:00 | CL | Stock | 28.11 | 28.375 | 28.05 | 28.3 | 638800.0 |
> showing 50 of 17,628 rows — these rows as CSV