PREVIEW / stock_1hour / 2008-09-10
file: by_date/stock_1hour/2008/2008-09-10.parquet size: 830 KB rows: 40,597 symbols: 3,314
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 |
|---|---|---|---|---|---|---|---|
| 2008-09-10 04:00:00 | AAPL | Stock | 5.4357 | 5.4943 | 5.4357 | 5.4943 | 6244.0 |
| 2008-09-10 05:00:00 | AAPL | Stock | 5.4736 | 5.4736 | 5.4732 | 5.4732 | 8400.0 |
| 2008-09-10 07:00:00 | AAPL | Stock | 5.4554 | 5.4925 | 5.4429 | 5.4475 | 636888.0 |
| 2008-09-10 08:00:00 | AAPL | Stock | 5.4529 | 5.4543 | 5.4054 | 5.4496 | 2449776.0 |
| 2008-09-10 09:00:00 | AAPL | Stock | 5.4532 | 5.4539 | 5.3143 | 5.3686 | 133336784.0 |
| 2008-09-10 10:00:00 | AAPL | Stock | 5.3686 | 5.4596 | 5.3561 | 5.3836 | 162023344.0 |
| 2008-09-10 11:00:00 | AAPL | Stock | 5.3839 | 5.4918 | 5.3671 | 5.4539 | 108284120.0 |
| 2008-09-10 12:00:00 | AAPL | Stock | 5.4543 | 5.5354 | 5.4536 | 5.4936 | 102734688.0 |
| 2008-09-10 13:00:00 | AAPL | Stock | 5.4939 | 5.5046 | 5.3514 | 5.3696 | 119559244.0 |
| 2008-09-10 14:00:00 | AAPL | Stock | 5.37 | 5.4764 | 5.3618 | 5.4314 | 155581300.0 |
| 2008-09-10 15:00:00 | AAPL | Stock | 5.4314 | 5.4836 | 5.4061 | 5.4129 | 160163080.0 |
| 2008-09-10 16:00:00 | AAPL | Stock | 5.4117 | 5.4289 | 5.4018 | 5.4232 | 20302576.0 |
| 2008-09-10 17:00:00 | AAPL | Stock | 5.4186 | 5.4343 | 5.4186 | 5.4304 | 175756.0 |
| 2008-09-10 18:00:00 | AAPL | Stock | 5.4286 | 5.4314 | 5.4146 | 5.4161 | 184828.0 |
| 2008-09-10 19:00:00 | AAPL | Stock | 5.4154 | 5.4196 | 5.4146 | 5.4146 | 54880.0 |
| 2008-09-10 07:00:00 | MSFT | Stock | 26.24 | 26.24 | 26.24 | 26.24 | 300.0 |
| 2008-09-10 08:00:00 | MSFT | Stock | 26.24 | 26.25 | 26.16 | 26.25 | 2000.0 |
| 2008-09-10 09:00:00 | MSFT | Stock | 26.35 | 26.56 | 26.262 | 26.43 | 6901225.0 |
| 2008-09-10 10:00:00 | MSFT | Stock | 26.43 | 26.45 | 26.25 | 26.33 | 8936423.0 |
| 2008-09-10 11:00:00 | MSFT | Stock | 26.32 | 26.53 | 26.27 | 26.45 | 8696612.0 |
| 2008-09-10 12:00:00 | MSFT | Stock | 26.45 | 26.6 | 26.43 | 26.49 | 6780516.0 |
| 2008-09-10 13:00:00 | MSFT | Stock | 26.49 | 26.72 | 26.45 | 26.55 | 9925693.0 |
| 2008-09-10 14:00:00 | MSFT | Stock | 26.55 | 26.86 | 26.55 | 26.72 | 10991228.0 |
| 2008-09-10 15:00:00 | MSFT | Stock | 26.72 | 26.83 | 26.39 | 26.46 | 15900845.0 |
| 2008-09-10 16:00:00 | MSFT | Stock | 26.44 | 26.549 | 26.43 | 26.44 | 3881118.0 |
| 2008-09-10 18:00:00 | MSFT | Stock | 26.47 | 26.53 | 26.44 | 26.45 | 22670.0 |
| 2008-09-10 19:00:00 | MSFT | Stock | 26.45 | 26.45 | 26.45 | 26.45 | 200.0 |
| 2008-09-10 08:00:00 | NVDA | Stock | 0.2738 | 0.2738 | 0.2725 | 0.2725 | 40000.0 |
| 2008-09-10 09:00:00 | NVDA | Stock | 0.2735 | 0.2765 | 0.2725 | 0.275 | 54747720.0 |
| 2008-09-10 10:00:00 | NVDA | Stock | 0.2748 | 0.279 | 0.2735 | 0.2738 | 98819560.0 |
| 2008-09-10 11:00:00 | NVDA | Stock | 0.2738 | 0.2745 | 0.2695 | 0.2732 | 110971400.0 |
| 2008-09-10 12:00:00 | NVDA | Stock | 0.2732 | 0.275 | 0.2715 | 0.2743 | 67512720.0 |
| 2008-09-10 13:00:00 | NVDA | Stock | 0.2743 | 0.2748 | 0.2715 | 0.272 | 69174560.0 |
| 2008-09-10 14:00:00 | NVDA | Stock | 0.272 | 0.2745 | 0.2712 | 0.2718 | 78800200.0 |
| 2008-09-10 15:00:00 | NVDA | Stock | 0.2718 | 0.2738 | 0.2688 | 0.27 | 137979280.0 |
| 2008-09-10 16:00:00 | NVDA | Stock | 0.27 | 0.2734 | 0.2597 | 0.2708 | 8028920.0 |
| 2008-09-10 17:00:00 | NVDA | Stock | 0.2708 | 0.2708 | 0.2708 | 0.2708 | 69560.0 |
| 2008-09-10 18:00:00 | NVDA | Stock | 0.2708 | 0.2708 | 0.2705 | 0.2705 | 168040.0 |
| 2008-09-10 19:00:00 | NVDA | Stock | 0.272 | 0.272 | 0.2705 | 0.2705 | 84000.0 |
| 2008-09-10 08:00:00 | AMZN | Stock | 3.953 | 3.9645 | 3.9305 | 3.9645 | 78000.0 |
| 2008-09-10 09:00:00 | AMZN | Stock | 3.9645 | 4.011 | 3.895 | 3.8975 | 22789300.0 |
| 2008-09-10 10:00:00 | AMZN | Stock | 3.8965 | 3.919 | 3.853 | 3.8665 | 33663180.0 |
| 2008-09-10 11:00:00 | AMZN | Stock | 3.867 | 3.8995 | 3.8495 | 3.875 | 32392140.0 |
| 2008-09-10 12:00:00 | AMZN | Stock | 3.875 | 3.92 | 3.868 | 3.8735 | 23760980.0 |
| 2008-09-10 13:00:00 | AMZN | Stock | 3.8765 | 3.8895 | 3.829 | 3.8325 | 16158420.0 |
| 2008-09-10 14:00:00 | AMZN | Stock | 3.832 | 3.8875 | 3.8075 | 3.865 | 29194860.0 |
| 2008-09-10 15:00:00 | AMZN | Stock | 3.865 | 3.886 | 3.828 | 3.837 | 22470440.0 |
| 2008-09-10 16:00:00 | AMZN | Stock | 3.831 | 3.8733 | 3.828 | 3.8335 | 4885720.0 |
| 2008-09-10 17:00:00 | AMZN | Stock | 3.847 | 3.847 | 3.847 | 3.847 | 2000.0 |
| 2008-09-10 08:00:00 | TLT | Stock | 96.08 | 96.32 | 96.0 | 96.0 | 1400.0 |
> showing 50 of 40,597 rows — these rows as CSV