PREVIEW / stock_1hour / 2006-12-05
file: by_date/stock_1hour/2006/2006-12-05.parquet size: 646 KB rows: 30,706 symbols: 2,470
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-12-05 07:00:00 | AAPL | Stock | 3.2521 | 3.2657 | 3.2521 | 3.2657 | 103600.0 |
| 2006-12-05 08:00:00 | AAPL | Stock | 3.2657 | 3.275 | 3.2561 | 3.2696 | 3688636.0 |
| 2006-12-05 09:00:00 | AAPL | Stock | 3.2686 | 3.2771 | 3.25 | 3.265 | 72970044.0 |
| 2006-12-05 10:00:00 | AAPL | Stock | 3.2646 | 3.2975 | 3.2639 | 3.2889 | 174936412.0 |
| 2006-12-05 11:00:00 | AAPL | Stock | 3.2886 | 3.2929 | 3.2714 | 3.2768 | 74049808.0 |
| 2006-12-05 12:00:00 | AAPL | Stock | 3.2764 | 3.2779 | 3.2454 | 3.2564 | 108364312.0 |
| 2006-12-05 13:00:00 | AAPL | Stock | 3.2564 | 3.2725 | 3.2529 | 3.2714 | 59042508.0 |
| 2006-12-05 14:00:00 | AAPL | Stock | 3.2714 | 3.2807 | 3.2675 | 3.2718 | 62676600.0 |
| 2006-12-05 15:00:00 | AAPL | Stock | 3.2721 | 3.275 | 3.2536 | 3.2592 | 97097392.0 |
| 2006-12-05 16:00:00 | AAPL | Stock | 3.2586 | 3.2604 | 3.255 | 3.2596 | 2306108.0 |
| 2006-12-05 17:00:00 | AAPL | Stock | 3.2604 | 3.2607 | 3.2568 | 3.2568 | 343196.0 |
| 2006-12-05 18:00:00 | AAPL | Stock | 3.2589 | 3.2604 | 3.2561 | 3.2575 | 237356.0 |
| 2006-12-05 19:00:00 | AAPL | Stock | 3.2604 | 3.2604 | 3.2571 | 3.2596 | 94976.0 |
| 2006-12-05 08:00:00 | MSFT | Stock | 29.35 | 29.49 | 29.34 | 29.43 | 22055.0 |
| 2006-12-05 09:00:00 | MSFT | Stock | 29.41 | 29.44 | 29.2 | 29.21 | 4266886.0 |
| 2006-12-05 10:00:00 | MSFT | Stock | 29.21 | 29.31 | 29.03 | 29.13 | 11894717.0 |
| 2006-12-05 11:00:00 | MSFT | Stock | 29.13 | 29.14 | 29.05 | 29.05 | 4225128.0 |
| 2006-12-05 12:00:00 | MSFT | Stock | 29.05 | 29.16 | 29.05 | 29.1 | 3498775.0 |
| 2006-12-05 13:00:00 | MSFT | Stock | 29.11 | 29.16 | 29.03 | 29.07 | 7890824.0 |
| 2006-12-05 14:00:00 | MSFT | Stock | 29.06 | 29.13 | 29.03 | 29.06 | 3424945.0 |
| 2006-12-05 15:00:00 | MSFT | Stock | 29.06 | 29.15 | 29.03 | 29.14 | 8734676.0 |
| 2006-12-05 16:00:00 | MSFT | Stock | 29.13 | 29.14 | 29.06 | 29.13 | 87709.0 |
| 2006-12-05 17:00:00 | MSFT | Stock | 29.13 | 29.14 | 29.123 | 29.14 | 22458.0 |
| 2006-12-05 18:00:00 | MSFT | Stock | 29.12 | 29.12 | 29.11 | 29.11 | 3500.0 |
| 2006-12-05 19:00:00 | MSFT | Stock | 29.1 | 29.14 | 29.1 | 29.14 | 3180.0 |
| 2006-12-05 08:00:00 | NVDA | Stock | 0.6167 | 0.6183 | 0.615 | 0.6168 | 848400.0 |
| 2006-12-05 09:00:00 | NVDA | Stock | 0.6183 | 0.6215 | 0.6038 | 0.609 | 171125040.0 |
| 2006-12-05 10:00:00 | NVDA | Stock | 0.6085 | 0.6135 | 0.6075 | 0.6082 | 99032460.0 |
| 2006-12-05 11:00:00 | NVDA | Stock | 0.6082 | 0.6088 | 0.604 | 0.6055 | 100227960.0 |
| 2006-12-05 12:00:00 | NVDA | Stock | 0.6057 | 0.607 | 0.6032 | 0.6065 | 62061120.0 |
| 2006-12-05 13:00:00 | NVDA | Stock | 0.6064 | 0.607 | 0.6043 | 0.6065 | 43821180.0 |
| 2006-12-05 14:00:00 | NVDA | Stock | 0.6063 | 0.6095 | 0.6058 | 0.6075 | 57921780.0 |
| 2006-12-05 15:00:00 | NVDA | Stock | 0.6077 | 0.611 | 0.6065 | 0.6103 | 102358980.0 |
| 2006-12-05 16:00:00 | NVDA | Stock | 0.61 | 0.6112 | 0.6092 | 0.61 | 4294020.0 |
| 2006-12-05 17:00:00 | NVDA | Stock | 0.61 | 0.61 | 0.61 | 0.61 | 12000.0 |
| 2006-12-05 18:00:00 | NVDA | Stock | 0.61 | 0.61 | 0.6078 | 0.61 | 212460.0 |
| 2006-12-05 19:00:00 | NVDA | Stock | 0.6107 | 0.6117 | 0.6107 | 0.6117 | 174000.0 |
| 2006-12-05 07:00:00 | AMZN | Stock | 1.955 | 1.955 | 1.955 | 1.955 | 10000.0 |
| 2006-12-05 09:00:00 | AMZN | Stock | 1.957 | 1.957 | 1.936 | 1.9505 | 13125240.0 |
| 2006-12-05 10:00:00 | AMZN | Stock | 1.951 | 1.9575 | 1.9395 | 1.947 | 23041980.0 |
| 2006-12-05 11:00:00 | AMZN | Stock | 1.947 | 1.9555 | 1.942 | 1.9485 | 20038360.0 |
| 2006-12-05 12:00:00 | AMZN | Stock | 1.9485 | 1.9535 | 1.941 | 1.947 | 8467240.0 |
| 2006-12-05 13:00:00 | AMZN | Stock | 1.947 | 1.9545 | 1.943 | 1.9506 | 7628920.0 |
| 2006-12-05 14:00:00 | AMZN | Stock | 1.951 | 1.965 | 1.947 | 1.9525 | 14613400.0 |
| 2006-12-05 15:00:00 | AMZN | Stock | 1.953 | 1.954 | 1.947 | 1.949 | 17439880.0 |
| 2006-12-05 16:00:00 | AMZN | Stock | 1.9505 | 1.9525 | 1.9455 | 1.949 | 2853880.0 |
| 2006-12-05 19:00:00 | AMZN | Stock | 1.945 | 1.945 | 1.945 | 1.945 | 20000.0 |
| 2006-12-05 09:00:00 | CL | Stock | 33.14 | 33.19 | 33.025 | 33.13 | 164600.0 |
| 2006-12-05 10:00:00 | CL | Stock | 33.135 | 33.24 | 33.095 | 33.1 | 470200.0 |
| 2006-12-05 11:00:00 | CL | Stock | 33.1 | 33.1235 | 32.955 | 32.97 | 344400.0 |
> showing 50 of 30,706 rows — these rows as CSV