PREVIEW / stock_1hour / 2008-08-04
file: by_date/stock_1hour/2008/2008-08-04.parquet size: 828 KB rows: 40,162 symbols: 3,299
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-08-04 04:00:00 | AAPL | Stock | 5.6096 | 5.6096 | 5.6096 | 5.6096 | 8400.0 |
| 2008-08-04 07:00:00 | AAPL | Stock | 5.5893 | 5.5893 | 5.5564 | 5.5564 | 8400.0 |
| 2008-08-04 08:00:00 | AAPL | Stock | 5.5714 | 5.5832 | 5.5661 | 5.5725 | 660520.0 |
| 2008-08-04 09:00:00 | AAPL | Stock | 5.575 | 5.6393 | 5.5539 | 5.6111 | 76695976.0 |
| 2008-08-04 10:00:00 | AAPL | Stock | 5.6111 | 5.6261 | 5.5625 | 5.58 | 91094472.0 |
| 2008-08-04 11:00:00 | AAPL | Stock | 5.5789 | 5.6268 | 5.5682 | 5.6104 | 76520920.0 |
| 2008-08-04 12:00:00 | AAPL | Stock | 5.6086 | 5.6268 | 5.5964 | 5.6046 | 42274820.0 |
| 2008-08-04 13:00:00 | AAPL | Stock | 5.6043 | 5.6186 | 5.575 | 5.5904 | 46818744.0 |
| 2008-08-04 14:00:00 | AAPL | Stock | 5.59 | 5.5939 | 5.5196 | 5.5239 | 79573452.0 |
| 2008-08-04 15:00:00 | AAPL | Stock | 5.5239 | 5.535 | 5.4611 | 5.4746 | 158693724.0 |
| 2008-08-04 16:00:00 | AAPL | Stock | 5.4743 | 5.5651 | 5.4725 | 5.4746 | 9974384.0 |
| 2008-08-04 17:00:00 | AAPL | Stock | 5.4764 | 5.4821 | 5.4725 | 5.4725 | 1827112.0 |
| 2008-08-04 18:00:00 | AAPL | Stock | 5.4786 | 5.4786 | 5.4746 | 5.4746 | 69888.0 |
| 2008-08-04 19:00:00 | AAPL | Stock | 5.4768 | 5.4946 | 5.4768 | 5.4893 | 169120.0 |
| 2008-08-04 08:00:00 | MSFT | Stock | 25.5 | 25.5 | 25.43 | 25.43 | 3845.0 |
| 2008-08-04 09:00:00 | MSFT | Stock | 25.43 | 25.5 | 25.12 | 25.16 | 6172751.0 |
| 2008-08-04 10:00:00 | MSFT | Stock | 25.16 | 25.28 | 25.11 | 25.25 | 10925634.0 |
| 2008-08-04 11:00:00 | MSFT | Stock | 25.24 | 25.545 | 25.21 | 25.33 | 7934204.0 |
| 2008-08-04 12:00:00 | MSFT | Stock | 25.33 | 25.36 | 25.21 | 25.249 | 5892727.0 |
| 2008-08-04 13:00:00 | MSFT | Stock | 25.242 | 25.38 | 25.22 | 25.3 | 5395748.0 |
| 2008-08-04 14:00:00 | MSFT | Stock | 25.3 | 25.47 | 25.26 | 25.399 | 5779953.0 |
| 2008-08-04 15:00:00 | MSFT | Stock | 25.39 | 25.44 | 25.2 | 25.24 | 12271275.0 |
| 2008-08-04 16:00:00 | MSFT | Stock | 25.25 | 25.31 | 25.2 | 25.22 | 5473578.0 |
| 2008-08-04 17:00:00 | MSFT | Stock | 25.22 | 25.3 | 25.22 | 25.28 | 182182.0 |
| 2008-08-04 18:00:00 | MSFT | Stock | 25.3 | 25.3 | 25.28 | 25.28 | 850.0 |
| 2008-08-04 19:00:00 | MSFT | Stock | 25.28 | 25.3 | 25.28 | 25.3 | 4225.0 |
| 2008-08-04 08:00:00 | NVDA | Stock | 0.27 | 0.2712 | 0.2683 | 0.2698 | 532960.0 |
| 2008-08-04 09:00:00 | NVDA | Stock | 0.27 | 0.2725 | 0.2675 | 0.269 | 65807360.0 |
| 2008-08-04 10:00:00 | NVDA | Stock | 0.269 | 0.27 | 0.264 | 0.2685 | 98766320.0 |
| 2008-08-04 11:00:00 | NVDA | Stock | 0.2683 | 0.2712 | 0.266 | 0.269 | 78800160.0 |
| 2008-08-04 12:00:00 | NVDA | Stock | 0.269 | 0.2703 | 0.2672 | 0.2672 | 40150320.0 |
| 2008-08-04 13:00:00 | NVDA | Stock | 0.2672 | 0.268 | 0.265 | 0.265 | 47273880.0 |
| 2008-08-04 14:00:00 | NVDA | Stock | 0.2652 | 0.269 | 0.265 | 0.269 | 50476640.0 |
| 2008-08-04 15:00:00 | NVDA | Stock | 0.2688 | 0.269 | 0.2638 | 0.2645 | 124944960.0 |
| 2008-08-04 16:00:00 | NVDA | Stock | 0.2645 | 0.2673 | 0.2645 | 0.2645 | 6700280.0 |
| 2008-08-04 17:00:00 | NVDA | Stock | 0.2658 | 0.2658 | 0.2645 | 0.2645 | 1071120.0 |
| 2008-08-04 18:00:00 | NVDA | Stock | 0.265 | 0.2658 | 0.265 | 0.2658 | 32000.0 |
| 2008-08-04 19:00:00 | NVDA | Stock | 0.266 | 0.266 | 0.266 | 0.266 | 28360.0 |
| 2008-08-04 08:00:00 | AMZN | Stock | 3.8025 | 3.8025 | 3.8025 | 3.8025 | 2000.0 |
| 2008-08-04 09:00:00 | AMZN | Stock | 3.7785 | 3.8465 | 3.7505 | 3.813 | 7645480.0 |
| 2008-08-04 10:00:00 | AMZN | Stock | 3.814 | 3.8415 | 3.7945 | 3.816 | 14032560.0 |
| 2008-08-04 11:00:00 | AMZN | Stock | 3.816 | 3.863 | 3.781 | 3.8618 | 14417020.0 |
| 2008-08-04 12:00:00 | AMZN | Stock | 3.862 | 3.865 | 3.822 | 3.826 | 9917660.0 |
| 2008-08-04 13:00:00 | AMZN | Stock | 3.824 | 3.8485 | 3.8 | 3.8125 | 10955980.0 |
| 2008-08-04 14:00:00 | AMZN | Stock | 3.8115 | 3.8415 | 3.807 | 3.8235 | 9330860.0 |
| 2008-08-04 15:00:00 | AMZN | Stock | 3.8235 | 3.826 | 3.7715 | 3.7845 | 17248880.0 |
| 2008-08-04 16:00:00 | AMZN | Stock | 3.7875 | 3.8181 | 3.7715 | 3.7825 | 1790060.0 |
| 2008-08-04 17:00:00 | AMZN | Stock | 3.7825 | 3.7855 | 3.7825 | 3.7855 | 291460.0 |
| 2008-08-04 18:00:00 | AMZN | Stock | 3.79 | 3.79 | 3.79 | 3.79 | 4000.0 |
| 2008-08-04 19:00:00 | AMZN | Stock | 3.8045 | 3.8075 | 3.8045 | 3.8075 | 12000.0 |
> showing 50 of 40,162 rows — these rows as CSV