PREVIEW / stock_30min / 2015-10-26
file: by_date/stock_30min/2015/2015-10-26.parquet size: 1.6 MB rows: 81,100 symbols: 3,445
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 |
|---|---|---|---|---|---|---|---|
| 2015-10-26 04:00:00 | AAPL | Stock | 29.755 | 29.755 | 29.6075 | 29.655 | 34828.0 |
| 2015-10-26 04:30:00 | AAPL | Stock | 29.7 | 29.7175 | 29.7 | 29.7125 | 37108.0 |
| 2015-10-26 05:00:00 | AAPL | Stock | 29.715 | 29.715 | 29.67 | 29.675 | 127592.0 |
| 2015-10-26 05:30:00 | AAPL | Stock | 29.63 | 29.6375 | 29.5625 | 29.575 | 81328.0 |
| 2015-10-26 06:00:00 | AAPL | Stock | 29.575 | 29.66 | 29.575 | 29.65 | 67044.0 |
| 2015-10-26 06:30:00 | AAPL | Stock | 29.6075 | 29.655 | 29.53 | 29.575 | 135144.0 |
| 2015-10-26 07:00:00 | AAPL | Stock | 29.575 | 29.575 | 29.465 | 29.5 | 243364.0 |
| 2015-10-26 07:30:00 | AAPL | Stock | 29.4875 | 29.4975 | 29.3725 | 29.4975 | 381804.0 |
| 2015-10-26 08:00:00 | AAPL | Stock | 29.4975 | 29.625 | 29.38 | 29.525 | 1940548.0 |
| 2015-10-26 08:30:00 | AAPL | Stock | 29.525 | 29.5475 | 29.465 | 29.5 | 686380.0 |
| 2015-10-26 09:00:00 | AAPL | Stock | 29.5025 | 29.5275 | 29.4375 | 29.485 | 1144696.0 |
| 2015-10-26 09:30:00 | AAPL | Stock | 29.52 | 29.5325 | 28.9 | 28.9825 | 55523388.0 |
| 2015-10-26 10:00:00 | AAPL | Stock | 28.985 | 29.0725 | 28.83 | 28.9225 | 31168000.0 |
| 2015-10-26 10:30:00 | AAPL | Stock | 28.92 | 29.05 | 28.905 | 29.015 | 17265324.0 |
| 2015-10-26 11:00:00 | AAPL | Stock | 29.015 | 29.0275 | 28.82 | 28.835 | 15478676.0 |
| 2015-10-26 11:30:00 | AAPL | Stock | 28.8375 | 28.9038 | 28.775 | 28.795 | 15970792.0 |
| 2015-10-26 12:00:00 | AAPL | Stock | 28.7975 | 28.925 | 28.7775 | 28.9025 | 10829404.0 |
| 2015-10-26 12:30:00 | AAPL | Stock | 28.9025 | 28.9775 | 28.865 | 28.865 | 9693408.0 |
| 2015-10-26 13:00:00 | AAPL | Stock | 28.865 | 28.9275 | 28.8375 | 28.8825 | 8938196.0 |
| 2015-10-26 13:30:00 | AAPL | Stock | 28.885 | 28.902 | 28.73 | 28.78 | 13653260.0 |
| 2015-10-26 14:00:00 | AAPL | Stock | 28.7825 | 28.8175 | 28.7525 | 28.7775 | 7453156.0 |
| 2015-10-26 14:30:00 | AAPL | Stock | 28.775 | 28.8362 | 28.7575 | 28.8328 | 8365132.0 |
| 2015-10-26 15:00:00 | AAPL | Stock | 28.8338 | 28.935 | 28.79 | 28.905 | 14488712.0 |
| 2015-10-26 15:30:00 | AAPL | Stock | 28.9025 | 28.9725 | 28.76 | 28.8175 | 25319084.0 |
| 2015-10-26 16:00:00 | AAPL | Stock | 28.8162 | 28.9442 | 28.775 | 28.7925 | 9114012.0 |
| 2015-10-26 16:30:00 | AAPL | Stock | 28.8 | 28.825 | 28.8 | 28.8125 | 91464.0 |
| 2015-10-26 17:00:00 | AAPL | Stock | 28.8125 | 28.82 | 28.79 | 28.81 | 118296.0 |
| 2015-10-26 17:30:00 | AAPL | Stock | 28.8125 | 28.815 | 28.8 | 28.81 | 113576.0 |
| 2015-10-26 18:00:00 | AAPL | Stock | 28.815 | 28.82 | 28.7975 | 28.8 | 91272.0 |
| 2015-10-26 18:30:00 | AAPL | Stock | 28.7925 | 28.8125 | 28.7875 | 28.795 | 91924.0 |
| 2015-10-26 19:00:00 | AAPL | Stock | 28.795 | 28.8125 | 28.785 | 28.7925 | 169896.0 |
| 2015-10-26 19:30:00 | AAPL | Stock | 28.7925 | 28.8125 | 28.79 | 28.8 | 76232.0 |
| 2015-10-26 04:00:00 | MSFT | Stock | 52.86 | 52.86 | 52.53 | 52.53 | 1596.0 |
| 2015-10-26 05:00:00 | MSFT | Stock | 52.52 | 52.6 | 52.5 | 52.56 | 3249.0 |
| 2015-10-26 05:30:00 | MSFT | Stock | 52.56 | 52.6 | 52.56 | 52.6 | 3300.0 |
| 2015-10-26 06:00:00 | MSFT | Stock | 52.6 | 52.75 | 52.6 | 52.7 | 3152.0 |
| 2015-10-26 06:30:00 | MSFT | Stock | 52.63 | 52.63 | 52.6 | 52.6 | 1700.0 |
| 2015-10-26 07:00:00 | MSFT | Stock | 52.61 | 52.65 | 52.61 | 52.65 | 1920.0 |
| 2015-10-26 07:30:00 | MSFT | Stock | 52.6 | 52.65 | 52.5 | 52.5 | 5724.0 |
| 2015-10-26 08:00:00 | MSFT | Stock | 52.57 | 52.74 | 52.5 | 52.66 | 49433.0 |
| 2015-10-26 08:30:00 | MSFT | Stock | 52.66 | 52.84 | 52.66 | 52.76 | 33997.0 |
| 2015-10-26 09:00:00 | MSFT | Stock | 52.8 | 52.8 | 52.58 | 52.59 | 141649.0 |
| 2015-10-26 09:30:00 | MSFT | Stock | 52.75 | 53.33 | 52.5 | 53.131 | 7542822.0 |
| 2015-10-26 10:00:00 | MSFT | Stock | 53.14 | 53.305 | 52.95 | 53.16 | 4165762.0 |
| 2015-10-26 10:30:00 | MSFT | Stock | 53.155 | 53.61 | 53.12 | 53.55 | 5332119.0 |
| 2015-10-26 11:00:00 | MSFT | Stock | 53.56 | 53.73 | 53.4 | 53.729 | 4090081.0 |
| 2015-10-26 11:30:00 | MSFT | Stock | 53.73 | 53.79 | 53.42 | 53.505 | 3771504.0 |
| 2015-10-26 12:00:00 | MSFT | Stock | 53.51 | 53.65 | 53.28 | 53.6 | 2674541.0 |
| 2015-10-26 12:30:00 | MSFT | Stock | 53.6 | 53.98 | 53.49 | 53.9 | 3791890.0 |
| 2015-10-26 13:00:00 | MSFT | Stock | 53.905 | 53.94 | 53.77 | 53.885 | 2717788.0 |
> showing 50 of 81,100 rows — these rows as CSV