PREVIEW / stock_30min / 2014-10-21
file: by_date/stock_30min/2014/2014-10-21.parquet size: 1.6 MB rows: 83,127 symbols: 3,553
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 |
|---|---|---|---|---|---|---|---|
| 2014-10-21 04:00:00 | AAPL | Stock | 25.525 | 25.525 | 25.4225 | 25.4275 | 86300.0 |
| 2014-10-21 04:30:00 | AAPL | Stock | 25.4275 | 25.4675 | 25.4275 | 25.4625 | 76000.0 |
| 2014-10-21 05:00:00 | AAPL | Stock | 25.4625 | 25.4625 | 25.42 | 25.42 | 66148.0 |
| 2014-10-21 05:30:00 | AAPL | Stock | 25.415 | 25.4625 | 25.4075 | 25.4625 | 77904.0 |
| 2014-10-21 06:00:00 | AAPL | Stock | 25.47 | 25.475 | 25.4475 | 25.4575 | 169908.0 |
| 2014-10-21 06:30:00 | AAPL | Stock | 25.4575 | 25.5 | 25.4 | 25.5 | 204036.0 |
| 2014-10-21 07:00:00 | AAPL | Stock | 25.5 | 25.5225 | 25.375 | 25.3875 | 677080.0 |
| 2014-10-21 07:30:00 | AAPL | Stock | 25.3875 | 25.5 | 25.3625 | 25.475 | 1004140.0 |
| 2014-10-21 08:00:00 | AAPL | Stock | 25.5 | 25.5725 | 25.2 | 25.5625 | 3092724.0 |
| 2014-10-21 08:30:00 | AAPL | Stock | 25.5575 | 25.725 | 25.555 | 25.7075 | 4593840.0 |
| 2014-10-21 09:00:00 | AAPL | Stock | 25.705 | 25.7875 | 25.5375 | 25.7525 | 7724132.0 |
| 2014-10-21 09:30:00 | AAPL | Stock | 25.7525 | 25.755 | 25.3825 | 25.51 | 88783728.0 |
| 2014-10-21 10:00:00 | AAPL | Stock | 25.515 | 25.5225 | 25.3175 | 25.4875 | 39046352.0 |
| 2014-10-21 10:30:00 | AAPL | Stock | 25.4875 | 25.53 | 25.4225 | 25.519 | 26804364.0 |
| 2014-10-21 11:00:00 | AAPL | Stock | 25.5175 | 25.6025 | 25.48 | 25.5375 | 24264960.0 |
| 2014-10-21 11:30:00 | AAPL | Stock | 25.5375 | 25.5475 | 25.44 | 25.4942 | 17152624.0 |
| 2014-10-21 12:00:00 | AAPL | Stock | 25.4925 | 25.5288 | 25.48 | 25.4985 | 13503780.0 |
| 2014-10-21 12:30:00 | AAPL | Stock | 25.5 | 25.5125 | 25.4575 | 25.504 | 9433224.0 |
| 2014-10-21 13:00:00 | AAPL | Stock | 25.5038 | 25.555 | 25.4975 | 25.535 | 10968340.0 |
| 2014-10-21 13:30:00 | AAPL | Stock | 25.535 | 25.61 | 25.5312 | 25.56 | 17976724.0 |
| 2014-10-21 14:00:00 | AAPL | Stock | 25.5588 | 25.58 | 25.5075 | 25.5238 | 10756912.0 |
| 2014-10-21 14:30:00 | AAPL | Stock | 25.5248 | 25.6075 | 25.5225 | 25.6038 | 14872660.0 |
| 2014-10-21 15:00:00 | AAPL | Stock | 25.6012 | 25.6225 | 25.5735 | 25.6075 | 14349812.0 |
| 2014-10-21 15:30:00 | AAPL | Stock | 25.6062 | 25.62 | 25.53 | 25.6175 | 29816616.0 |
| 2014-10-21 16:00:00 | AAPL | Stock | 25.6175 | 25.65 | 24.9145 | 25.6275 | 9667248.0 |
| 2014-10-21 16:30:00 | AAPL | Stock | 25.6175 | 25.65 | 25.6175 | 25.645 | 191512.0 |
| 2014-10-21 17:00:00 | AAPL | Stock | 25.6425 | 25.655 | 25.6175 | 25.6375 | 731672.0 |
| 2014-10-21 17:30:00 | AAPL | Stock | 25.6375 | 25.6375 | 25.6125 | 25.635 | 2641880.0 |
| 2014-10-21 18:00:00 | AAPL | Stock | 25.6275 | 25.635 | 25.6225 | 25.6325 | 170476.0 |
| 2014-10-21 18:30:00 | AAPL | Stock | 25.6325 | 25.6325 | 25.6075 | 25.6075 | 222336.0 |
| 2014-10-21 19:00:00 | AAPL | Stock | 25.6075 | 25.6175 | 25.605 | 25.605 | 65564.0 |
| 2014-10-21 19:30:00 | AAPL | Stock | 25.605 | 25.605 | 25.5625 | 25.5625 | 148720.0 |
| 2014-10-21 06:00:00 | MSFT | Stock | 44.28 | 44.28 | 44.28 | 44.28 | 100.0 |
| 2014-10-21 06:30:00 | MSFT | Stock | 44.39 | 44.39 | 44.39 | 44.39 | 200.0 |
| 2014-10-21 07:00:00 | MSFT | Stock | 44.3 | 44.3 | 44.3 | 44.3 | 300.0 |
| 2014-10-21 08:00:00 | MSFT | Stock | 44.57 | 44.57 | 44.2 | 44.27 | 9321.0 |
| 2014-10-21 08:30:00 | MSFT | Stock | 44.37 | 44.38 | 44.26 | 44.34 | 2650.0 |
| 2014-10-21 09:00:00 | MSFT | Stock | 44.33 | 44.42 | 44.3 | 44.36 | 84551.0 |
| 2014-10-21 09:30:00 | MSFT | Stock | 44.36 | 44.66 | 44.19 | 44.49 | 4374019.0 |
| 2014-10-21 10:00:00 | MSFT | Stock | 44.5 | 44.645 | 44.39 | 44.6 | 2721911.0 |
| 2014-10-21 10:30:00 | MSFT | Stock | 44.61 | 44.695 | 44.59 | 44.62 | 1521414.0 |
| 2014-10-21 11:00:00 | MSFT | Stock | 44.62 | 44.67 | 44.57 | 44.65 | 1390737.0 |
| 2014-10-21 11:30:00 | MSFT | Stock | 44.65 | 44.74 | 44.61 | 44.72 | 1634950.0 |
| 2014-10-21 12:00:00 | MSFT | Stock | 44.72 | 44.84 | 44.71 | 44.82 | 1371551.0 |
| 2014-10-21 12:30:00 | MSFT | Stock | 44.82 | 44.83 | 44.78 | 44.785 | 1367549.0 |
| 2014-10-21 13:00:00 | MSFT | Stock | 44.785 | 44.87 | 44.76 | 44.85 | 1775469.0 |
| 2014-10-21 13:30:00 | MSFT | Stock | 44.845 | 44.975 | 44.83 | 44.92 | 1705609.0 |
| 2014-10-21 14:00:00 | MSFT | Stock | 44.92 | 44.965 | 44.8 | 44.845 | 1603531.0 |
| 2014-10-21 14:30:00 | MSFT | Stock | 44.84 | 44.89 | 44.78 | 44.822 | 1606667.0 |
| 2014-10-21 15:00:00 | MSFT | Stock | 44.82 | 44.88 | 44.78 | 44.855 | 2326200.0 |
> showing 50 of 83,127 rows — these rows as CSV