PREVIEW / stock_1hour / 2009-08-03
file: by_date/stock_1hour/2009/2009-08-03.parquet size: 889 KB rows: 43,059 symbols: 3,367
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-08-03 05:00:00 | AAPL | Stock | 5.8857 | 5.8857 | 5.8857 | 5.8857 | 5600.0 |
| 2009-08-03 07:00:00 | AAPL | Stock | 5.9 | 5.9143 | 5.8907 | 5.9143 | 160720.0 |
| 2009-08-03 08:00:00 | AAPL | Stock | 5.9071 | 5.9268 | 5.8354 | 5.9068 | 2660756.0 |
| 2009-08-03 09:00:00 | AAPL | Stock | 5.9036 | 5.9464 | 5.8929 | 5.9264 | 77722876.0 |
| 2009-08-03 10:00:00 | AAPL | Stock | 5.9264 | 5.9514 | 5.9054 | 5.9096 | 88752608.0 |
| 2009-08-03 11:00:00 | AAPL | Stock | 5.9086 | 5.9196 | 5.8882 | 5.9171 | 52963008.0 |
| 2009-08-03 12:00:00 | AAPL | Stock | 5.9161 | 5.9321 | 5.9146 | 5.9171 | 35535612.0 |
| 2009-08-03 13:00:00 | AAPL | Stock | 5.9179 | 5.9293 | 5.9179 | 5.9247 | 23692984.0 |
| 2009-08-03 14:00:00 | AAPL | Stock | 5.925 | 5.9414 | 5.9225 | 5.9261 | 37358720.0 |
| 2009-08-03 15:00:00 | AAPL | Stock | 5.9261 | 5.9446 | 5.9229 | 5.9436 | 59774568.0 |
| 2009-08-03 16:00:00 | AAPL | Stock | 5.9436 | 5.9493 | 5.9246 | 5.9446 | 10354148.0 |
| 2009-08-03 17:00:00 | AAPL | Stock | 5.9195 | 5.9464 | 5.9195 | 5.9443 | 413896.0 |
| 2009-08-03 18:00:00 | AAPL | Stock | 5.9439 | 5.9496 | 5.9411 | 5.9454 | 560280.0 |
| 2009-08-03 19:00:00 | AAPL | Stock | 5.9436 | 5.9496 | 5.9436 | 5.9482 | 237188.0 |
| 2009-08-03 20:00:00 | AAPL | Stock | 5.8986 | 5.8986 | 5.8986 | 5.8986 | 70000.0 |
| 2009-08-03 06:00:00 | MSFT | Stock | 23.9 | 23.9 | 23.83 | 23.9 | 5900.0 |
| 2009-08-03 07:00:00 | MSFT | Stock | 23.89 | 23.9 | 23.8 | 23.86 | 13107.0 |
| 2009-08-03 08:00:00 | MSFT | Stock | 23.84 | 23.89 | 23.52 | 23.81 | 74744.0 |
| 2009-08-03 09:00:00 | MSFT | Stock | 23.82 | 23.88 | 23.5 | 23.62 | 7202199.0 |
| 2009-08-03 10:00:00 | MSFT | Stock | 23.62 | 23.86 | 23.61 | 23.82 | 8897312.0 |
| 2009-08-03 11:00:00 | MSFT | Stock | 23.82 | 23.838 | 23.71 | 23.764 | 4950854.0 |
| 2009-08-03 12:00:00 | MSFT | Stock | 23.77 | 23.802 | 23.7 | 23.75 | 3848457.0 |
| 2009-08-03 13:00:00 | MSFT | Stock | 23.742 | 23.83 | 23.74 | 23.77 | 3715777.0 |
| 2009-08-03 14:00:00 | MSFT | Stock | 23.762 | 23.815 | 23.74 | 23.78 | 4065564.0 |
| 2009-08-03 15:00:00 | MSFT | Stock | 23.78 | 23.82 | 23.72 | 23.82 | 10121464.0 |
| 2009-08-03 16:00:00 | MSFT | Stock | 23.82 | 23.84 | 23.757 | 23.83 | 2621526.0 |
| 2009-08-03 17:00:00 | MSFT | Stock | 23.83 | 23.83 | 23.738 | 23.8 | 15312.0 |
| 2009-08-03 18:00:00 | MSFT | Stock | 23.83 | 23.83 | 23.76 | 23.79 | 2102.0 |
| 2009-08-03 19:00:00 | MSFT | Stock | 23.8 | 23.8 | 23.78 | 23.8 | 2448.0 |
| 2009-08-03 20:00:00 | MSFT | Stock | 23.76 | 23.76 | 23.76 | 23.76 | 8800.0 |
| 2009-08-03 08:00:00 | NVDA | Stock | 0.325 | 0.332 | 0.325 | 0.3308 | 310800.0 |
| 2009-08-03 09:00:00 | NVDA | Stock | 0.3322 | 0.3358 | 0.3248 | 0.3255 | 137425400.0 |
| 2009-08-03 10:00:00 | NVDA | Stock | 0.3255 | 0.3305 | 0.325 | 0.328 | 92669200.0 |
| 2009-08-03 11:00:00 | NVDA | Stock | 0.328 | 0.3295 | 0.3265 | 0.3294 | 42650640.0 |
| 2009-08-03 12:00:00 | NVDA | Stock | 0.3293 | 0.3308 | 0.3288 | 0.3307 | 42613000.0 |
| 2009-08-03 13:00:00 | NVDA | Stock | 0.3308 | 0.332 | 0.3305 | 0.3308 | 30438240.0 |
| 2009-08-03 14:00:00 | NVDA | Stock | 0.331 | 0.3318 | 0.3303 | 0.3308 | 35904160.0 |
| 2009-08-03 15:00:00 | NVDA | Stock | 0.3308 | 0.332 | 0.3293 | 0.332 | 68145960.0 |
| 2009-08-03 16:00:00 | NVDA | Stock | 0.332 | 0.3345 | 0.3233 | 0.332 | 17694840.0 |
| 2009-08-03 17:00:00 | NVDA | Stock | 0.329 | 0.332 | 0.329 | 0.332 | 431280.0 |
| 2009-08-03 18:00:00 | NVDA | Stock | 0.3313 | 0.3313 | 0.3313 | 0.3313 | 6000.0 |
| 2009-08-03 19:00:00 | NVDA | Stock | 0.3325 | 0.3325 | 0.3315 | 0.3315 | 85960.0 |
| 2009-08-03 07:00:00 | AMZN | Stock | 4.337 | 4.337 | 4.337 | 4.337 | 2000.0 |
| 2009-08-03 08:00:00 | AMZN | Stock | 4.325 | 4.349 | 4.288 | 4.341 | 149140.0 |
| 2009-08-03 09:00:00 | AMZN | Stock | 4.334 | 4.404 | 4.328 | 4.384 | 24620720.0 |
| 2009-08-03 10:00:00 | AMZN | Stock | 4.3835 | 4.41 | 4.3629 | 4.37 | 31056440.0 |
| 2009-08-03 11:00:00 | AMZN | Stock | 4.369 | 4.3975 | 4.368 | 4.3955 | 13955580.0 |
| 2009-08-03 12:00:00 | AMZN | Stock | 4.396 | 4.4 | 4.3765 | 4.38 | 8998200.0 |
| 2009-08-03 13:00:00 | AMZN | Stock | 4.3805 | 4.392 | 4.3765 | 4.386 | 9259480.0 |
| 2009-08-03 14:00:00 | AMZN | Stock | 4.386 | 4.399 | 4.375 | 4.3752 | 12682620.0 |
> showing 50 of 43,059 rows — these rows as CSV