PREVIEW / stock_1hour / 2009-07-24
file: by_date/stock_1hour/2009/2009-07-24.parquet size: 841 KB rows: 40,876 symbols: 3,348
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 |
|---|---|---|---|---|---|---|---|
| 2009-07-24 04:00:00 | AAPL | Stock | 5.5971 | 5.5971 | 5.5971 | 5.5971 | 2800.0 |
| 2009-07-24 05:00:00 | AAPL | Stock | 5.5714 | 5.5714 | 5.5714 | 5.5714 | 5600.0 |
| 2009-07-24 06:00:00 | AAPL | Stock | 5.6429 | 5.6429 | 5.6429 | 5.6429 | 2800.0 |
| 2009-07-24 07:00:00 | AAPL | Stock | 5.58 | 5.6054 | 5.58 | 5.5893 | 65324.0 |
| 2009-07-24 08:00:00 | AAPL | Stock | 5.6007 | 5.6318 | 5.5893 | 5.6061 | 1342964.0 |
| 2009-07-24 09:00:00 | AAPL | Stock | 5.6036 | 5.695 | 5.5893 | 5.6371 | 110811428.0 |
| 2009-07-24 10:00:00 | AAPL | Stock | 5.6386 | 5.6821 | 5.6275 | 5.6471 | 66495856.0 |
| 2009-07-24 11:00:00 | AAPL | Stock | 5.6464 | 5.6857 | 5.6421 | 5.6836 | 47441660.0 |
| 2009-07-24 12:00:00 | AAPL | Stock | 5.6814 | 5.6946 | 5.6779 | 5.6871 | 38487456.0 |
| 2009-07-24 13:00:00 | AAPL | Stock | 5.6871 | 5.7139 | 5.6814 | 5.7004 | 49967540.0 |
| 2009-07-24 14:00:00 | AAPL | Stock | 5.7011 | 5.7125 | 5.6871 | 5.6993 | 47981388.0 |
| 2009-07-24 15:00:00 | AAPL | Stock | 5.6989 | 5.7143 | 5.6875 | 5.7143 | 62481916.0 |
| 2009-07-24 16:00:00 | AAPL | Stock | 5.7139 | 5.7143 | 5.6672 | 5.7114 | 10010196.0 |
| 2009-07-24 17:00:00 | AAPL | Stock | 5.7139 | 5.7143 | 5.7075 | 5.7096 | 391328.0 |
| 2009-07-24 18:00:00 | AAPL | Stock | 5.7096 | 5.7136 | 5.7071 | 5.7075 | 295960.0 |
| 2009-07-24 19:00:00 | AAPL | Stock | 5.7075 | 5.7179 | 5.7075 | 5.7154 | 396536.0 |
| 2009-07-24 04:00:00 | MSFT | Stock | 23.53 | 23.71 | 23.48 | 23.7 | 2690.0 |
| 2009-07-24 05:00:00 | MSFT | Stock | 23.7 | 23.79 | 23.6 | 23.65 | 2600.0 |
| 2009-07-24 06:00:00 | MSFT | Stock | 23.69 | 23.79 | 23.69 | 23.75 | 26385.0 |
| 2009-07-24 07:00:00 | MSFT | Stock | 23.68 | 24.04 | 23.65 | 23.95 | 366186.0 |
| 2009-07-24 08:00:00 | MSFT | Stock | 23.95 | 23.97 | 23.53 | 23.56 | 2502467.0 |
| 2009-07-24 09:00:00 | MSFT | Stock | 23.57 | 23.89 | 22.96 | 22.97 | 50938644.0 |
| 2009-07-24 10:00:00 | MSFT | Stock | 22.97 | 23.26 | 22.81 | 23.1 | 54516657.0 |
| 2009-07-24 11:00:00 | MSFT | Stock | 23.11 | 23.45 | 23.055 | 23.43 | 24283007.0 |
| 2009-07-24 12:00:00 | MSFT | Stock | 23.44 | 23.46 | 23.22 | 23.27 | 15094576.0 |
| 2009-07-24 13:00:00 | MSFT | Stock | 23.269 | 23.36 | 23.2 | 23.3 | 16117608.0 |
| 2009-07-24 14:00:00 | MSFT | Stock | 23.307 | 23.41 | 23.25 | 23.33 | 14105100.0 |
| 2009-07-24 15:00:00 | MSFT | Stock | 23.33 | 23.46 | 23.15 | 23.45 | 30532571.0 |
| 2009-07-24 16:00:00 | MSFT | Stock | 23.45 | 23.67 | 23.291 | 23.51 | 3349321.0 |
| 2009-07-24 17:00:00 | MSFT | Stock | 23.51 | 23.53 | 23.45 | 23.49 | 82867.0 |
| 2009-07-24 18:00:00 | MSFT | Stock | 23.48 | 23.49 | 23.43 | 23.46 | 173635.0 |
| 2009-07-24 19:00:00 | MSFT | Stock | 23.49 | 23.54 | 23.45 | 23.53 | 33787.0 |
| 2009-07-24 08:00:00 | NVDA | Stock | 0.3163 | 0.3163 | 0.3125 | 0.3138 | 282400.0 |
| 2009-07-24 09:00:00 | NVDA | Stock | 0.315 | 0.32 | 0.313 | 0.3155 | 154410600.0 |
| 2009-07-24 10:00:00 | NVDA | Stock | 0.3158 | 0.3178 | 0.3148 | 0.316 | 119564360.0 |
| 2009-07-24 11:00:00 | NVDA | Stock | 0.316 | 0.3213 | 0.3158 | 0.321 | 104750920.0 |
| 2009-07-24 12:00:00 | NVDA | Stock | 0.321 | 0.3215 | 0.318 | 0.319 | 92191640.0 |
| 2009-07-24 13:00:00 | NVDA | Stock | 0.3188 | 0.3246 | 0.318 | 0.3243 | 42906560.0 |
| 2009-07-24 14:00:00 | NVDA | Stock | 0.3243 | 0.325 | 0.3228 | 0.3233 | 42591840.0 |
| 2009-07-24 15:00:00 | NVDA | Stock | 0.3233 | 0.3248 | 0.3223 | 0.3245 | 79512280.0 |
| 2009-07-24 16:00:00 | NVDA | Stock | 0.324 | 0.3248 | 0.319 | 0.319 | 12588320.0 |
| 2009-07-24 17:00:00 | NVDA | Stock | 0.3245 | 0.3248 | 0.321 | 0.3213 | 212000.0 |
| 2009-07-24 18:00:00 | NVDA | Stock | 0.321 | 0.321 | 0.321 | 0.321 | 20000.0 |
| 2009-07-24 19:00:00 | NVDA | Stock | 0.3238 | 0.3238 | 0.3238 | 0.3238 | 40000.0 |
| 2009-07-24 04:00:00 | AMZN | Stock | 4.377 | 4.377 | 4.377 | 4.377 | 4000.0 |
| 2009-07-24 06:00:00 | AMZN | Stock | 4.3945 | 4.3945 | 4.394 | 4.394 | 10000.0 |
| 2009-07-24 07:00:00 | AMZN | Stock | 4.388 | 4.4145 | 4.375 | 4.4025 | 321480.0 |
| 2009-07-24 08:00:00 | AMZN | Stock | 4.403 | 4.4585 | 4.4025 | 4.406 | 5331400.0 |
| 2009-07-24 09:00:00 | AMZN | Stock | 4.409 | 4.445 | 4.2945 | 4.3075 | 94293540.0 |
| 2009-07-24 10:00:00 | AMZN | Stock | 4.3075 | 4.351 | 4.293 | 4.3171 | 83950140.0 |
> showing 50 of 40,876 rows — these rows as CSV