PREVIEW / stock_1hour / 2006-07-11
file: by_date/stock_1hour/2006/2006-07-11.parquet size: 617 KB rows: 29,595 symbols: 2,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 |
|---|---|---|---|---|---|---|---|
| 2006-07-11 06:00:00 | AAPL | Stock | 1.9643 | 1.9714 | 1.9643 | 1.9714 | 14000.0 |
| 2006-07-11 07:00:00 | AAPL | Stock | 1.9732 | 1.9732 | 1.9643 | 1.9718 | 50400.0 |
| 2006-07-11 08:00:00 | AAPL | Stock | 1.9643 | 1.975 | 1.9614 | 1.9707 | 2174088.0 |
| 2006-07-11 09:00:00 | AAPL | Stock | 1.9714 | 1.9875 | 1.9489 | 1.9757 | 101001404.0 |
| 2006-07-11 10:00:00 | AAPL | Stock | 1.9757 | 1.9775 | 1.9543 | 1.9618 | 130619356.0 |
| 2006-07-11 11:00:00 | AAPL | Stock | 1.9614 | 1.9707 | 1.9575 | 1.9643 | 82413240.0 |
| 2006-07-11 12:00:00 | AAPL | Stock | 1.9643 | 1.9682 | 1.9546 | 1.9546 | 66165456.0 |
| 2006-07-11 13:00:00 | AAPL | Stock | 1.9547 | 1.9782 | 1.9475 | 1.9714 | 95257876.0 |
| 2006-07-11 14:00:00 | AAPL | Stock | 1.9714 | 1.9911 | 1.9607 | 1.9643 | 160483288.0 |
| 2006-07-11 15:00:00 | AAPL | Stock | 1.9643 | 1.9996 | 1.9596 | 1.9868 | 170193856.0 |
| 2006-07-11 16:00:00 | AAPL | Stock | 1.9857 | 1.9875 | 1.9705 | 1.9821 | 2036972.0 |
| 2006-07-11 17:00:00 | AAPL | Stock | 1.9821 | 1.9857 | 1.9821 | 1.9857 | 342160.0 |
| 2006-07-11 18:00:00 | AAPL | Stock | 1.9857 | 1.9868 | 1.9821 | 1.9832 | 218372.0 |
| 2006-07-11 07:00:00 | MSFT | Stock | 23.38 | 23.49 | 23.38 | 23.49 | 1100.0 |
| 2006-07-11 08:00:00 | MSFT | Stock | 23.48 | 23.5 | 23.42 | 23.45 | 569900.0 |
| 2006-07-11 09:00:00 | MSFT | Stock | 23.48 | 23.49 | 23.16 | 23.16 | 8855949.0 |
| 2006-07-11 10:00:00 | MSFT | Stock | 23.17 | 23.365 | 23.04 | 23.12 | 13747095.0 |
| 2006-07-11 11:00:00 | MSFT | Stock | 23.11 | 23.16 | 23.1 | 23.12 | 5318416.0 |
| 2006-07-11 12:00:00 | MSFT | Stock | 23.123 | 23.35 | 22.96 | 22.97 | 7955768.0 |
| 2006-07-11 13:00:00 | MSFT | Stock | 22.97 | 22.99 | 22.74 | 22.94 | 16158168.0 |
| 2006-07-11 14:00:00 | MSFT | Stock | 22.94 | 23.07 | 22.89 | 23.0 | 10905861.0 |
| 2006-07-11 15:00:00 | MSFT | Stock | 23.01 | 23.15 | 23.0 | 23.09 | 15684560.0 |
| 2006-07-11 16:00:00 | MSFT | Stock | 23.09 | 23.11 | 22.94 | 23.11 | 338332.0 |
| 2006-07-11 17:00:00 | MSFT | Stock | 23.11 | 23.12 | 23.1 | 23.12 | 5500.0 |
| 2006-07-11 18:00:00 | MSFT | Stock | 23.1 | 23.1 | 23.1 | 23.1 | 329.0 |
| 2006-07-11 08:00:00 | NVDA | Stock | 0.3083 | 0.3083 | 0.3083 | 0.3083 | 22620.0 |
| 2006-07-11 09:00:00 | NVDA | Stock | 0.3078 | 0.3138 | 0.3033 | 0.31 | 65381940.0 |
| 2006-07-11 10:00:00 | NVDA | Stock | 0.31 | 0.3113 | 0.3057 | 0.3077 | 80414820.0 |
| 2006-07-11 11:00:00 | NVDA | Stock | 0.3078 | 0.3088 | 0.3053 | 0.3053 | 81345240.0 |
| 2006-07-11 12:00:00 | NVDA | Stock | 0.3055 | 0.3068 | 0.3038 | 0.3042 | 53472300.0 |
| 2006-07-11 13:00:00 | NVDA | Stock | 0.3042 | 0.3123 | 0.3033 | 0.3113 | 64199340.0 |
| 2006-07-11 14:00:00 | NVDA | Stock | 0.3113 | 0.3153 | 0.31 | 0.3147 | 96559980.0 |
| 2006-07-11 15:00:00 | NVDA | Stock | 0.3147 | 0.3203 | 0.3128 | 0.3195 | 119396760.0 |
| 2006-07-11 16:00:00 | NVDA | Stock | 0.3195 | 0.32 | 0.3185 | 0.3197 | 842160.0 |
| 2006-07-11 17:00:00 | NVDA | Stock | 0.3197 | 0.32 | 0.3197 | 0.32 | 354000.0 |
| 2006-07-11 09:00:00 | AMZN | Stock | 1.789 | 1.796 | 1.776 | 1.78 | 5212860.0 |
| 2006-07-11 10:00:00 | AMZN | Stock | 1.7805 | 1.7805 | 1.755 | 1.758 | 19314620.0 |
| 2006-07-11 11:00:00 | AMZN | Stock | 1.7576 | 1.761 | 1.7505 | 1.7515 | 28326040.0 |
| 2006-07-11 12:00:00 | AMZN | Stock | 1.7515 | 1.7575 | 1.751 | 1.755 | 11449980.0 |
| 2006-07-11 13:00:00 | AMZN | Stock | 1.7545 | 1.775 | 1.7525 | 1.7715 | 12494760.0 |
| 2006-07-11 14:00:00 | AMZN | Stock | 1.7715 | 1.786 | 1.764 | 1.7715 | 15559620.0 |
| 2006-07-11 15:00:00 | AMZN | Stock | 1.7715 | 1.7845 | 1.768 | 1.783 | 19676080.0 |
| 2006-07-11 16:00:00 | AMZN | Stock | 1.783 | 1.788 | 1.78 | 1.78 | 352680.0 |
| 2006-07-11 09:00:00 | CL | Stock | 30.75 | 30.755 | 30.6175 | 30.73 | 213200.0 |
| 2006-07-11 10:00:00 | CL | Stock | 30.73 | 30.775 | 30.625 | 30.64 | 303400.0 |
| 2006-07-11 11:00:00 | CL | Stock | 30.63 | 30.735 | 30.605 | 30.725 | 212000.0 |
| 2006-07-11 12:00:00 | CL | Stock | 30.72 | 30.75 | 30.675 | 30.735 | 129000.0 |
| 2006-07-11 13:00:00 | CL | Stock | 30.74 | 30.78 | 30.68 | 30.78 | 172200.0 |
| 2006-07-11 14:00:00 | CL | Stock | 30.78 | 30.82 | 30.75 | 30.785 | 323600.0 |
| 2006-07-11 15:00:00 | CL | Stock | 30.78 | 30.88 | 30.73 | 30.825 | 478800.0 |
> showing 50 of 29,595 rows — these rows as CSV