PREVIEW / stock_30min / 2009-12-31
file: by_date/stock_30min/2009/2009-12-31.parquet size: 1.3 MB rows: 71,557 symbols: 3,467
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-12-31 08:00:00 | AAPL | Stock | 7.5714 | 7.6054 | 7.5714 | 7.6014 | 1863008.0 |
| 2009-12-31 08:30:00 | AAPL | Stock | 7.6011 | 7.6111 | 7.5946 | 7.6043 | 1671656.0 |
| 2009-12-31 09:00:00 | AAPL | Stock | 7.6039 | 7.6268 | 7.6036 | 7.6125 | 2695560.0 |
| 2009-12-31 09:30:00 | AAPL | Stock | 7.6125 | 7.6196 | 7.5607 | 7.5686 | 71272208.0 |
| 2009-12-31 10:00:00 | AAPL | Stock | 7.5686 | 7.5832 | 7.5464 | 7.5725 | 39738356.0 |
| 2009-12-31 10:30:00 | AAPL | Stock | 7.5721 | 7.5807 | 7.5611 | 7.57 | 16469628.0 |
| 2009-12-31 11:00:00 | AAPL | Stock | 7.5707 | 7.5736 | 7.5429 | 7.5546 | 28634032.0 |
| 2009-12-31 11:30:00 | AAPL | Stock | 7.5543 | 7.5757 | 7.5518 | 7.5629 | 20620656.0 |
| 2009-12-31 12:00:00 | AAPL | Stock | 7.5629 | 7.5729 | 7.5579 | 7.5607 | 10895976.0 |
| 2009-12-31 12:30:00 | AAPL | Stock | 7.5607 | 7.5651 | 7.5536 | 7.5554 | 12481280.0 |
| 2009-12-31 13:00:00 | AAPL | Stock | 7.5552 | 7.5554 | 7.5396 | 7.5468 | 16088520.0 |
| 2009-12-31 13:30:00 | AAPL | Stock | 7.5471 | 7.5579 | 7.5443 | 7.5486 | 13104140.0 |
| 2009-12-31 14:00:00 | AAPL | Stock | 7.5486 | 7.5525 | 7.5421 | 7.5429 | 10672956.0 |
| 2009-12-31 14:30:00 | AAPL | Stock | 7.5432 | 7.5536 | 7.5404 | 7.5493 | 12181176.0 |
| 2009-12-31 15:00:00 | AAPL | Stock | 7.5496 | 7.5518 | 7.5432 | 7.5496 | 12462548.0 |
| 2009-12-31 15:30:00 | AAPL | Stock | 7.5493 | 7.5493 | 7.52 | 7.53 | 59245620.0 |
| 2009-12-31 16:00:00 | AAPL | Stock | 7.5304 | 7.5714 | 7.5214 | 7.5268 | 12305944.0 |
| 2009-12-31 16:30:00 | AAPL | Stock | 7.5284 | 7.5307 | 7.5218 | 7.525 | 762944.0 |
| 2009-12-31 17:00:00 | AAPL | Stock | 7.5282 | 7.5321 | 7.5246 | 7.5286 | 66836.0 |
| 2009-12-31 17:30:00 | AAPL | Stock | 7.5318 | 7.5321 | 7.525 | 7.5282 | 96208.0 |
| 2009-12-31 18:00:00 | AAPL | Stock | 7.5279 | 7.5339 | 7.5236 | 7.5339 | 270452.0 |
| 2009-12-31 18:30:00 | AAPL | Stock | 7.5346 | 7.5346 | 7.525 | 7.5257 | 110236.0 |
| 2009-12-31 19:00:00 | AAPL | Stock | 7.5268 | 7.5268 | 7.5232 | 7.525 | 72212.0 |
| 2009-12-31 19:30:00 | AAPL | Stock | 7.5218 | 7.5221 | 7.5096 | 7.51 | 201460.0 |
| 2009-12-31 08:00:00 | MSFT | Stock | 30.9 | 30.98 | 30.9 | 30.98 | 1700.0 |
| 2009-12-31 08:30:00 | MSFT | Stock | 30.98 | 31.04 | 30.98 | 31.04 | 1779.0 |
| 2009-12-31 09:00:00 | MSFT | Stock | 31.03 | 31.04 | 30.91 | 30.97 | 17732.0 |
| 2009-12-31 09:30:00 | MSFT | Stock | 30.98 | 30.99 | 30.87 | 30.91 | 2446655.0 |
| 2009-12-31 10:00:00 | MSFT | Stock | 30.912 | 30.92 | 30.84 | 30.84 | 1919952.0 |
| 2009-12-31 10:30:00 | MSFT | Stock | 30.84 | 30.87 | 30.84 | 30.858 | 1209885.0 |
| 2009-12-31 11:00:00 | MSFT | Stock | 30.859 | 30.86 | 30.72 | 30.785 | 1942512.0 |
| 2009-12-31 11:30:00 | MSFT | Stock | 30.78 | 30.84 | 30.77 | 30.79 | 1504956.0 |
| 2009-12-31 12:00:00 | MSFT | Stock | 30.78 | 30.83 | 30.75 | 30.77 | 1319065.0 |
| 2009-12-31 12:30:00 | MSFT | Stock | 30.765 | 30.8 | 30.76 | 30.77 | 899629.0 |
| 2009-12-31 13:00:00 | MSFT | Stock | 30.76 | 30.77 | 30.71 | 30.759 | 898529.0 |
| 2009-12-31 13:30:00 | MSFT | Stock | 30.76 | 30.83 | 30.75 | 30.79 | 1003982.0 |
| 2009-12-31 14:00:00 | MSFT | Stock | 30.8 | 30.8 | 30.75 | 30.75 | 849753.0 |
| 2009-12-31 14:30:00 | MSFT | Stock | 30.75 | 30.8 | 30.75 | 30.784 | 1442639.0 |
| 2009-12-31 15:00:00 | MSFT | Stock | 30.79 | 30.8 | 30.75 | 30.763 | 1379453.0 |
| 2009-12-31 15:30:00 | MSFT | Stock | 30.76 | 30.78 | 30.48 | 30.49 | 8970266.0 |
| 2009-12-31 16:00:00 | MSFT | Stock | 30.48 | 30.835 | 30.45 | 30.52 | 3504945.0 |
| 2009-12-31 16:30:00 | MSFT | Stock | 30.776 | 30.776 | 30.49 | 30.57 | 58789.0 |
| 2009-12-31 17:00:00 | MSFT | Stock | 30.55 | 30.56 | 30.55 | 30.56 | 2558.0 |
| 2009-12-31 17:30:00 | MSFT | Stock | 30.57 | 30.59 | 30.57 | 30.58 | 2270.0 |
| 2009-12-31 18:00:00 | MSFT | Stock | 30.58 | 30.58 | 30.48 | 30.55 | 10627.0 |
| 2009-12-31 18:30:00 | MSFT | Stock | 30.56 | 30.56 | 30.48 | 30.5 | 3129.0 |
| 2009-12-31 19:00:00 | MSFT | Stock | 30.48 | 30.5 | 30.48 | 30.5 | 1564.0 |
| 2009-12-31 19:30:00 | MSFT | Stock | 30.5 | 30.59 | 30.5 | 30.59 | 5178.0 |
| 2009-12-31 08:00:00 | NVDA | Stock | 0.47 | 0.47 | 0.4695 | 0.47 | 76600.0 |
| 2009-12-31 08:30:00 | NVDA | Stock | 0.47 | 0.4725 | 0.47 | 0.47 | 140000.0 |
> showing 50 of 71,557 rows — these rows as CSV