PREVIEW / stock_1hour / 2006-11-24
file: by_date/stock_1hour/2006/2006-11-24.parquet size: 412 KB rows: 17,510 symbols: 2,368
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-11-24 05:00:00 | AAPL | Stock | 3.2143 | 3.2143 | 3.2143 | 3.2143 | 84000.0 |
| 2006-11-24 06:00:00 | AAPL | Stock | 3.2111 | 3.2111 | 3.2111 | 3.2111 | 5600.0 |
| 2006-11-24 07:00:00 | AAPL | Stock | 3.2032 | 3.2032 | 3.1961 | 3.1964 | 86800.0 |
| 2006-11-24 08:00:00 | AAPL | Stock | 3.2 | 3.2182 | 3.1946 | 3.21 | 4065992.0 |
| 2006-11-24 09:00:00 | AAPL | Stock | 3.2114 | 3.2554 | 3.1964 | 3.2414 | 87943268.0 |
| 2006-11-24 10:00:00 | AAPL | Stock | 3.2407 | 3.2754 | 3.2343 | 3.2729 | 114931404.0 |
| 2006-11-24 11:00:00 | AAPL | Stock | 3.2729 | 3.3079 | 3.27 | 3.3071 | 133525728.0 |
| 2006-11-24 12:00:00 | AAPL | Stock | 3.3075 | 3.3243 | 3.2721 | 3.2736 | 172508028.0 |
| 2006-11-24 13:00:00 | AAPL | Stock | 3.2736 | 3.2743 | 3.2725 | 3.2725 | 1018724.0 |
| 2006-11-24 16:00:00 | AAPL | Stock | 3.2625 | 3.2625 | 3.2607 | 3.2607 | 74200.0 |
| 2006-11-24 06:00:00 | MSFT | Stock | 29.75 | 29.75 | 29.72 | 29.72 | 980.0 |
| 2006-11-24 07:00:00 | MSFT | Stock | 29.88 | 29.88 | 29.88 | 29.88 | 300.0 |
| 2006-11-24 08:00:00 | MSFT | Stock | 29.76 | 29.76 | 29.68 | 29.68 | 13186.0 |
| 2006-11-24 09:00:00 | MSFT | Stock | 29.7 | 29.76 | 29.64 | 29.68 | 5277790.0 |
| 2006-11-24 10:00:00 | MSFT | Stock | 29.68 | 29.8 | 29.68 | 29.77 | 4114154.0 |
| 2006-11-24 11:00:00 | MSFT | Stock | 29.762 | 29.84 | 29.72 | 29.74 | 3189452.0 |
| 2006-11-24 12:00:00 | MSFT | Stock | 29.74 | 29.83 | 29.73 | 29.77 | 4224690.0 |
| 2006-11-24 13:00:00 | MSFT | Stock | 29.76 | 29.76 | 29.76 | 29.76 | 649611.0 |
| 2006-11-24 16:00:00 | MSFT | Stock | 29.75 | 29.75 | 29.75 | 29.75 | 200.0 |
| 2006-11-24 08:00:00 | NVDA | Stock | 0.6117 | 0.6117 | 0.607 | 0.609 | 678000.0 |
| 2006-11-24 09:00:00 | NVDA | Stock | 0.609 | 0.6093 | 0.6033 | 0.6082 | 24576600.0 |
| 2006-11-24 10:00:00 | NVDA | Stock | 0.6082 | 0.6132 | 0.6082 | 0.6125 | 28902000.0 |
| 2006-11-24 11:00:00 | NVDA | Stock | 0.6123 | 0.6175 | 0.6118 | 0.6133 | 42148440.0 |
| 2006-11-24 12:00:00 | NVDA | Stock | 0.6133 | 0.6177 | 0.6123 | 0.6167 | 45430260.0 |
| 2006-11-24 13:00:00 | NVDA | Stock | 0.6163 | 0.6163 | 0.6163 | 0.6163 | 1142100.0 |
| 2006-11-24 08:00:00 | AMZN | Stock | 2.1465 | 2.1465 | 2.125 | 2.125 | 97900.0 |
| 2006-11-24 09:00:00 | AMZN | Stock | 2.13 | 2.14 | 2.123 | 2.1375 | 8098660.0 |
| 2006-11-24 10:00:00 | AMZN | Stock | 2.1375 | 2.147 | 2.1335 | 2.143 | 9128440.0 |
| 2006-11-24 11:00:00 | AMZN | Stock | 2.1425 | 2.144 | 2.124 | 2.1255 | 11898660.0 |
| 2006-11-24 12:00:00 | AMZN | Stock | 2.126 | 2.1285 | 2.1155 | 2.1175 | 12873440.0 |
| 2006-11-24 13:00:00 | AMZN | Stock | 2.1205 | 2.1205 | 2.1205 | 2.1205 | 551260.0 |
| 2006-11-24 16:00:00 | AMZN | Stock | 2.1225 | 2.1225 | 2.1225 | 2.1225 | 12000.0 |
| 2006-11-24 09:00:00 | CL | Stock | 33.15 | 33.26 | 32.75 | 32.94 | 727200.0 |
| 2006-11-24 10:00:00 | CL | Stock | 32.94 | 33.025 | 32.875 | 32.995 | 459400.0 |
| 2006-11-24 11:00:00 | CL | Stock | 32.995 | 33.0485 | 32.95 | 32.965 | 304800.0 |
| 2006-11-24 12:00:00 | CL | Stock | 32.97 | 33.065 | 32.965 | 32.985 | 374400.0 |
| 2006-11-24 13:00:00 | CL | Stock | 32.995 | 32.995 | 32.985 | 32.985 | 89600.0 |
> showing 37 of 17,510 rows — these rows as CSV