PREVIEW / stock_30min / 2008-12-09
file: by_date/stock_30min/2008/2008-12-09.parquet size: 1.2 MB rows: 68,932 symbols: 3,344
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 |
|---|---|---|---|---|---|---|---|
| 2008-12-09 07:00:00 | AAPL | Stock | 3.55 | 3.55 | 3.55 | 3.55 | 5600.0 |
| 2008-12-09 07:30:00 | AAPL | Stock | 3.5536 | 3.5536 | 3.5393 | 3.5393 | 16576.0 |
| 2008-12-09 08:00:00 | AAPL | Stock | 3.5357 | 3.5357 | 3.5268 | 3.53 | 319032.0 |
| 2008-12-09 08:30:00 | AAPL | Stock | 3.5314 | 3.5357 | 3.5089 | 3.5107 | 492660.0 |
| 2008-12-09 09:00:00 | AAPL | Stock | 3.5114 | 3.5207 | 3.5 | 3.5061 | 871864.0 |
| 2008-12-09 09:30:00 | AAPL | Stock | 3.5043 | 3.5421 | 3.4718 | 3.5261 | 117548788.0 |
| 2008-12-09 10:00:00 | AAPL | Stock | 3.5198 | 3.6464 | 3.5154 | 3.6289 | 141393224.0 |
| 2008-12-09 10:30:00 | AAPL | Stock | 3.6286 | 3.7 | 3.6236 | 3.6821 | 128436084.0 |
| 2008-12-09 11:00:00 | AAPL | Stock | 3.6825 | 3.6893 | 3.6379 | 3.6379 | 91431536.0 |
| 2008-12-09 11:30:00 | AAPL | Stock | 3.6379 | 3.6489 | 3.6182 | 3.6343 | 72448208.0 |
| 2008-12-09 12:00:00 | AAPL | Stock | 3.6349 | 3.6607 | 3.6236 | 3.6307 | 46766972.0 |
| 2008-12-09 12:30:00 | AAPL | Stock | 3.6307 | 3.6689 | 3.6304 | 3.6493 | 47356092.0 |
| 2008-12-09 13:00:00 | AAPL | Stock | 3.6496 | 3.6568 | 3.5943 | 3.6012 | 57314964.0 |
| 2008-12-09 13:30:00 | AAPL | Stock | 3.6004 | 3.6204 | 3.5786 | 3.6061 | 73409784.0 |
| 2008-12-09 14:00:00 | AAPL | Stock | 3.6061 | 3.6121 | 3.5589 | 3.5679 | 72465680.0 |
| 2008-12-09 14:30:00 | AAPL | Stock | 3.5686 | 3.5993 | 3.5436 | 3.5946 | 84001988.0 |
| 2008-12-09 15:00:00 | AAPL | Stock | 3.5946 | 3.6196 | 3.5714 | 3.5714 | 85516984.0 |
| 2008-12-09 15:30:00 | AAPL | Stock | 3.5717 | 3.5886 | 3.5536 | 3.5732 | 119255920.0 |
| 2008-12-09 16:00:00 | AAPL | Stock | 3.5732 | 3.6039 | 3.565 | 3.5736 | 59748360.0 |
| 2008-12-09 16:30:00 | AAPL | Stock | 3.5664 | 3.5736 | 3.565 | 3.5671 | 346668.0 |
| 2008-12-09 17:00:00 | AAPL | Stock | 3.5686 | 3.5732 | 3.5679 | 3.5711 | 495992.0 |
| 2008-12-09 17:30:00 | AAPL | Stock | 3.5732 | 3.575 | 3.57 | 3.5721 | 131908.0 |
| 2008-12-09 18:00:00 | AAPL | Stock | 3.5721 | 3.5736 | 3.5679 | 3.5679 | 152264.0 |
| 2008-12-09 18:30:00 | AAPL | Stock | 3.5707 | 3.5714 | 3.5689 | 3.5711 | 72884.0 |
| 2008-12-09 19:00:00 | AAPL | Stock | 3.5714 | 3.5714 | 3.5689 | 3.5693 | 176960.0 |
| 2008-12-09 19:30:00 | AAPL | Stock | 3.57 | 3.5775 | 3.5693 | 3.5775 | 256872.0 |
| 2008-12-09 08:00:00 | MSFT | Stock | 20.9 | 20.9 | 20.66 | 20.87 | 5100.0 |
| 2008-12-09 08:30:00 | MSFT | Stock | 20.8 | 20.83 | 20.72 | 20.75 | 15129.0 |
| 2008-12-09 09:00:00 | MSFT | Stock | 20.75 | 20.8 | 20.6 | 20.62 | 50588.0 |
| 2008-12-09 09:30:00 | MSFT | Stock | 20.61 | 20.9 | 20.57 | 20.7 | 5254123.0 |
| 2008-12-09 10:00:00 | MSFT | Stock | 20.72 | 21.115 | 20.69 | 20.92 | 5978186.0 |
| 2008-12-09 10:30:00 | MSFT | Stock | 20.91 | 21.25 | 20.91 | 21.18 | 5378603.0 |
| 2008-12-09 11:00:00 | MSFT | Stock | 21.19 | 21.25 | 21.15 | 21.181 | 5070735.0 |
| 2008-12-09 11:30:00 | MSFT | Stock | 21.19 | 21.22 | 21.055 | 21.07 | 3973662.0 |
| 2008-12-09 12:00:00 | MSFT | Stock | 21.07 | 21.179 | 20.94 | 21.024 | 4354636.0 |
| 2008-12-09 12:30:00 | MSFT | Stock | 21.03 | 21.23 | 20.982 | 21.083 | 3442621.0 |
| 2008-12-09 13:00:00 | MSFT | Stock | 21.09 | 21.15 | 20.83 | 20.83 | 3110605.0 |
| 2008-12-09 13:30:00 | MSFT | Stock | 20.84 | 20.94 | 20.75 | 20.81 | 3362173.0 |
| 2008-12-09 14:00:00 | MSFT | Stock | 20.81 | 20.83 | 20.47 | 20.55 | 4763331.0 |
| 2008-12-09 14:30:00 | MSFT | Stock | 20.56 | 20.84 | 20.47 | 20.76 | 4939183.0 |
| 2008-12-09 15:00:00 | MSFT | Stock | 20.76 | 20.93 | 20.6 | 20.635 | 7238555.0 |
| 2008-12-09 15:30:00 | MSFT | Stock | 20.63 | 20.77 | 20.46 | 20.64 | 11466669.0 |
| 2008-12-09 16:00:00 | MSFT | Stock | 20.64 | 20.888 | 20.58 | 20.6 | 7256663.0 |
| 2008-12-09 16:30:00 | MSFT | Stock | 20.62 | 20.63 | 20.58 | 20.6 | 28042.0 |
| 2008-12-09 17:00:00 | MSFT | Stock | 20.59 | 20.63 | 20.58 | 20.63 | 300.0 |
| 2008-12-09 17:30:00 | MSFT | Stock | 20.62 | 20.63 | 20.62 | 20.62 | 1301.0 |
| 2008-12-09 18:00:00 | MSFT | Stock | 20.63 | 20.63 | 20.6 | 20.6 | 15433.0 |
| 2008-12-09 19:00:00 | MSFT | Stock | 20.64 | 20.64 | 20.64 | 20.64 | 500.0 |
| 2008-12-09 19:30:00 | MSFT | Stock | 20.62 | 20.62 | 20.62 | 20.62 | 450.0 |
| 2008-12-09 08:00:00 | NVDA | Stock | 0.1765 | 0.1773 | 0.1765 | 0.1773 | 93000.0 |
> showing 50 of 68,932 rows — these rows as CSV