PREVIEW / stock_1hour / 2001-09-26
file: by_date/stock_1hour/2001/2001-09-26.parquet size: 363 KB rows: 17,424 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-09-26 08:00:00 | AAPL | Stock | 0.2779 | 0.2784 | 0.2779 | 0.2784 | 95200.0 |
| 2001-09-26 09:00:00 | AAPL | Stock | 0.2943 | 0.2943 | 0.2746 | 0.2762 | 68997600.0 |
| 2001-09-26 10:00:00 | AAPL | Stock | 0.2761 | 0.2764 | 0.2709 | 0.2723 | 51469600.0 |
| 2001-09-26 11:00:00 | AAPL | Stock | 0.2721 | 0.2729 | 0.2684 | 0.2695 | 78148000.0 |
| 2001-09-26 12:00:00 | AAPL | Stock | 0.2695 | 0.2702 | 0.2666 | 0.2688 | 77901600.0 |
| 2001-09-26 13:00:00 | AAPL | Stock | 0.2686 | 0.2705 | 0.2675 | 0.2691 | 34669600.0 |
| 2001-09-26 14:00:00 | AAPL | Stock | 0.2695 | 0.2714 | 0.2679 | 0.2698 | 34921600.0 |
| 2001-09-26 15:00:00 | AAPL | Stock | 0.27 | 0.2711 | 0.2688 | 0.2705 | 69238400.0 |
| 2001-09-26 16:00:00 | AAPL | Stock | 0.2705 | 0.2723 | 0.2641 | 0.272 | 14991200.0 |
| 2001-09-26 18:00:00 | AAPL | Stock | 0.2639 | 0.2639 | 0.2639 | 0.2639 | 16800.0 |
| 2001-09-26 08:00:00 | MSFT | Stock | 25.655 | 25.875 | 25.6 | 25.76 | 150000.0 |
| 2001-09-26 09:00:00 | MSFT | Stock | 25.65 | 25.905 | 25.42 | 25.625 | 9825400.0 |
| 2001-09-26 10:00:00 | MSFT | Stock | 25.63 | 25.89 | 25.35 | 25.53 | 11874800.0 |
| 2001-09-26 11:00:00 | MSFT | Stock | 25.5349 | 25.625 | 25.21 | 25.265 | 5261000.0 |
| 2001-09-26 12:00:00 | MSFT | Stock | 25.2705 | 25.375 | 25.2 | 25.3 | 3842200.0 |
| 2001-09-26 13:00:00 | MSFT | Stock | 25.3 | 25.3 | 24.94 | 25.06 | 5238800.0 |
| 2001-09-26 14:00:00 | MSFT | Stock | 25.06 | 25.15 | 24.775 | 24.855 | 6022200.0 |
| 2001-09-26 15:00:00 | MSFT | Stock | 24.87 | 25.15 | 24.775 | 25.13 | 9929200.0 |
| 2001-09-26 16:00:00 | MSFT | Stock | 25.135 | 25.465 | 24.9647 | 25.225 | 2628400.0 |
| 2001-09-26 17:00:00 | MSFT | Stock | 25.215 | 25.215 | 25.2 | 25.2 | 2400.0 |
| 2001-09-26 18:00:00 | MSFT | Stock | 25.175 | 25.225 | 25.15 | 25.175 | 6800.0 |
| 2001-09-26 08:00:00 | NVDA | Stock | 0.2417 | 0.2467 | 0.2417 | 0.2467 | 276000.0 |
| 2001-09-26 09:00:00 | NVDA | Stock | 0.2458 | 0.2458 | 0.2377 | 0.2393 | 69156000.0 |
| 2001-09-26 10:00:00 | NVDA | Stock | 0.2392 | 0.2412 | 0.2347 | 0.2395 | 91224000.0 |
| 2001-09-26 11:00:00 | NVDA | Stock | 0.2397 | 0.2402 | 0.2367 | 0.2377 | 59616000.0 |
| 2001-09-26 12:00:00 | NVDA | Stock | 0.2377 | 0.2392 | 0.2346 | 0.2372 | 39936000.0 |
| 2001-09-26 13:00:00 | NVDA | Stock | 0.2367 | 0.2371 | 0.2307 | 0.2327 | 45660000.0 |
| 2001-09-26 14:00:00 | NVDA | Stock | 0.2322 | 0.2341 | 0.2297 | 0.2306 | 40680000.0 |
| 2001-09-26 15:00:00 | NVDA | Stock | 0.2308 | 0.2342 | 0.2292 | 0.2306 | 58392000.0 |
| 2001-09-26 16:00:00 | NVDA | Stock | 0.2316 | 0.2419 | 0.2302 | 0.2312 | 7644000.0 |
| 2001-09-26 17:00:00 | NVDA | Stock | 0.2321 | 0.2323 | 0.23 | 0.2308 | 216000.0 |
| 2001-09-26 08:00:00 | AMZN | Stock | 0.3545 | 0.356 | 0.3545 | 0.355 | 42000.0 |
| 2001-09-26 09:00:00 | AMZN | Stock | 0.3555 | 0.3615 | 0.3375 | 0.3425 | 9660000.0 |
| 2001-09-26 10:00:00 | AMZN | Stock | 0.3425 | 0.349 | 0.3375 | 0.345 | 10500000.0 |
| 2001-09-26 11:00:00 | AMZN | Stock | 0.346 | 0.3465 | 0.3255 | 0.3285 | 15466000.0 |
| 2001-09-26 12:00:00 | AMZN | Stock | 0.3285 | 0.3325 | 0.327 | 0.3315 | 7798000.0 |
| 2001-09-26 13:00:00 | AMZN | Stock | 0.3315 | 0.3335 | 0.3075 | 0.3075 | 26564000.0 |
| 2001-09-26 14:00:00 | AMZN | Stock | 0.3085 | 0.3105 | 0.3 | 0.3005 | 26354000.0 |
| 2001-09-26 15:00:00 | AMZN | Stock | 0.3005 | 0.3185 | 0.3 | 0.3175 | 27302000.0 |
| 2001-09-26 16:00:00 | AMZN | Stock | 0.3175 | 0.325 | 0.3081 | 0.318 | 11584000.0 |
| 2001-09-26 17:00:00 | AMZN | Stock | 0.3165 | 0.318 | 0.315 | 0.315 | 40000.0 |
| 2001-09-26 18:00:00 | AMZN | Stock | 0.315 | 0.3155 | 0.315 | 0.315 | 14000.0 |
| 2001-09-26 09:00:00 | CL | Stock | 28.175 | 28.45 | 28.14 | 28.22 | 644000.0 |
| 2001-09-26 10:00:00 | CL | Stock | 28.22 | 28.22 | 27.85 | 28.05 | 620200.0 |
| 2001-09-26 11:00:00 | CL | Stock | 28.1 | 28.45 | 28.025 | 28.035 | 703800.0 |
| 2001-09-26 12:00:00 | CL | Stock | 28.05 | 28.1 | 28.015 | 28.05 | 346000.0 |
| 2001-09-26 13:00:00 | CL | Stock | 28.05 | 28.11 | 28.03 | 28.07 | 504400.0 |
| 2001-09-26 14:00:00 | CL | Stock | 28.07 | 28.125 | 28.025 | 28.06 | 570200.0 |
| 2001-09-26 15:00:00 | CL | Stock | 28.055 | 28.25 | 28.05 | 28.25 | 902400.0 |
| 2001-09-26 16:00:00 | CL | Stock | 28.25 | 28.35 | 28.13 | 28.15 | 405400.0 |
> showing 50 of 17,424 rows — these rows as CSV