PREVIEW / stock_30min / 2011-12-06
file: by_date/stock_30min/2011/2011-12-06.parquet size: 1.4 MB rows: 73,137 symbols: 3,526
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 |
|---|---|---|---|---|---|---|---|
| 2011-12-06 04:00:00 | AAPL | Stock | 14.0107 | 14.0429 | 14.0107 | 14.0357 | 33600.0 |
| 2011-12-06 04:30:00 | AAPL | Stock | 14.0179 | 14.0179 | 14.0179 | 14.0179 | 14000.0 |
| 2011-12-06 05:00:00 | AAPL | Stock | 14.0179 | 14.0179 | 14.0179 | 14.0179 | 28000.0 |
| 2011-12-06 05:30:00 | AAPL | Stock | 14.0286 | 14.0429 | 14.0232 | 14.0429 | 50708.0 |
| 2011-12-06 06:00:00 | AAPL | Stock | 14.0446 | 14.0446 | 14.0446 | 14.0446 | 2800.0 |
| 2011-12-06 06:30:00 | AAPL | Stock | 14.0143 | 14.0143 | 14.0143 | 14.0143 | 5600.0 |
| 2011-12-06 07:00:00 | AAPL | Stock | 14.0536 | 14.0536 | 14.0286 | 14.0393 | 16800.0 |
| 2011-12-06 07:30:00 | AAPL | Stock | 14.0464 | 14.05 | 14.0271 | 14.0271 | 50400.0 |
| 2011-12-06 08:00:00 | AAPL | Stock | 14.0357 | 14.0411 | 13.9732 | 13.9754 | 367304.0 |
| 2011-12-06 08:30:00 | AAPL | Stock | 13.9736 | 14.0107 | 13.9689 | 14.0107 | 261436.0 |
| 2011-12-06 09:00:00 | AAPL | Stock | 14.0107 | 14.0196 | 13.9993 | 14.0196 | 669872.0 |
| 2011-12-06 09:30:00 | AAPL | Stock | 14.0196 | 14.0939 | 14.0086 | 14.0532 | 43052744.0 |
| 2011-12-06 10:00:00 | AAPL | Stock | 14.0518 | 14.0657 | 13.95 | 14.0045 | 35571144.0 |
| 2011-12-06 10:30:00 | AAPL | Stock | 14.0029 | 14.0336 | 13.9757 | 13.9832 | 19497492.0 |
| 2011-12-06 11:00:00 | AAPL | Stock | 13.9857 | 14.0036 | 13.9643 | 13.9668 | 15279572.0 |
| 2011-12-06 11:30:00 | AAPL | Stock | 13.9696 | 13.9725 | 13.9121 | 13.9468 | 24159912.0 |
| 2011-12-06 12:00:00 | AAPL | Stock | 13.9464 | 13.9582 | 13.92 | 13.9296 | 10944864.0 |
| 2011-12-06 12:30:00 | AAPL | Stock | 13.9307 | 13.9414 | 13.9064 | 13.9361 | 9131220.0 |
| 2011-12-06 13:00:00 | AAPL | Stock | 13.9382 | 13.9721 | 13.9079 | 13.9664 | 12501888.0 |
| 2011-12-06 13:30:00 | AAPL | Stock | 13.9704 | 13.9739 | 13.9382 | 13.9539 | 10762472.0 |
| 2011-12-06 14:00:00 | AAPL | Stock | 13.9536 | 13.9786 | 13.9397 | 13.97 | 11954572.0 |
| 2011-12-06 14:30:00 | AAPL | Stock | 13.9686 | 14.0293 | 13.9654 | 14.0171 | 23204412.0 |
| 2011-12-06 15:00:00 | AAPL | Stock | 14.0175 | 14.0393 | 13.98 | 13.9893 | 23239776.0 |
| 2011-12-06 15:30:00 | AAPL | Stock | 13.9889 | 14.0064 | 13.9493 | 13.9643 | 33423236.0 |
| 2011-12-06 16:00:00 | AAPL | Stock | 13.9643 | 14.0334 | 13.9554 | 13.9625 | 8315832.0 |
| 2011-12-06 16:30:00 | AAPL | Stock | 13.9657 | 13.9934 | 13.9643 | 13.9757 | 167860.0 |
| 2011-12-06 17:00:00 | AAPL | Stock | 13.9721 | 13.9732 | 13.9607 | 13.9629 | 49336.0 |
| 2011-12-06 17:30:00 | AAPL | Stock | 13.9643 | 13.9818 | 13.9643 | 13.975 | 67004.0 |
| 2011-12-06 18:00:00 | AAPL | Stock | 13.9721 | 13.9721 | 13.9675 | 13.9679 | 148204.0 |
| 2011-12-06 18:30:00 | AAPL | Stock | 13.9732 | 13.9732 | 13.9646 | 13.9714 | 25200.0 |
| 2011-12-06 19:00:00 | AAPL | Stock | 13.9721 | 13.9746 | 13.9707 | 13.9746 | 12936.0 |
| 2011-12-06 19:30:00 | AAPL | Stock | 13.9743 | 13.9954 | 13.9736 | 13.9954 | 161616.0 |
| 2011-12-06 05:00:00 | MSFT | Stock | 25.77 | 25.77 | 25.77 | 25.77 | 2000.0 |
| 2011-12-06 07:00:00 | MSFT | Stock | 25.8 | 25.8 | 25.76 | 25.76 | 1100.0 |
| 2011-12-06 07:30:00 | MSFT | Stock | 25.79 | 25.8 | 25.77 | 25.77 | 3600.0 |
| 2011-12-06 08:00:00 | MSFT | Stock | 25.77 | 25.8 | 25.7 | 25.75 | 13868.0 |
| 2011-12-06 08:30:00 | MSFT | Stock | 25.71 | 25.72 | 25.7 | 25.7 | 5552.0 |
| 2011-12-06 09:00:00 | MSFT | Stock | 25.7 | 25.85 | 25.7 | 25.82 | 50916.0 |
| 2011-12-06 09:30:00 | MSFT | Stock | 25.83 | 25.87 | 25.74 | 25.74 | 4842077.0 |
| 2011-12-06 10:00:00 | MSFT | Stock | 25.74 | 25.79 | 25.61 | 25.691 | 6026476.0 |
| 2011-12-06 10:30:00 | MSFT | Stock | 25.69 | 25.79 | 25.68 | 25.72 | 3863514.0 |
| 2011-12-06 11:00:00 | MSFT | Stock | 25.72 | 25.79 | 25.65 | 25.68 | 3727053.0 |
| 2011-12-06 11:30:00 | MSFT | Stock | 25.68 | 25.76 | 25.64 | 25.73 | 2621791.0 |
| 2011-12-06 12:00:00 | MSFT | Stock | 25.737 | 25.74 | 25.67 | 25.67 | 1422559.0 |
| 2011-12-06 12:30:00 | MSFT | Stock | 25.67 | 25.72 | 25.65 | 25.715 | 1634959.0 |
| 2011-12-06 13:00:00 | MSFT | Stock | 25.71 | 25.744 | 25.68 | 25.74 | 2107132.0 |
| 2011-12-06 13:30:00 | MSFT | Stock | 25.74 | 25.75 | 25.72 | 25.73 | 1491496.0 |
| 2011-12-06 14:00:00 | MSFT | Stock | 25.73 | 25.75 | 25.7 | 25.7 | 2119700.0 |
| 2011-12-06 14:30:00 | MSFT | Stock | 25.71 | 25.81 | 25.7 | 25.775 | 4954603.0 |
| 2011-12-06 15:00:00 | MSFT | Stock | 25.77 | 25.79 | 25.69 | 25.69 | 3702532.0 |
> showing 50 of 73,137 rows — these rows as CSV