PREVIEW / stock_30min / 2012-12-10
file: by_date/stock_30min/2012/2012-12-10.parquet size: 1.4 MB rows: 74,710 symbols: 3,504
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 |
|---|---|---|---|---|---|---|---|
| 2012-12-10 04:00:00 | AAPL | Stock | 19.1071 | 19.1071 | 19.075 | 19.075 | 28784.0 |
| 2012-12-10 04:30:00 | AAPL | Stock | 19.0696 | 19.0696 | 19.0607 | 19.0607 | 8400.0 |
| 2012-12-10 05:00:00 | AAPL | Stock | 19.0193 | 19.0314 | 19.0004 | 19.0004 | 8400.0 |
| 2012-12-10 05:30:00 | AAPL | Stock | 18.9775 | 19.0 | 18.9696 | 18.9696 | 35000.0 |
| 2012-12-10 06:00:00 | AAPL | Stock | 18.9696 | 18.9821 | 18.9375 | 18.9464 | 70000.0 |
| 2012-12-10 06:30:00 | AAPL | Stock | 18.9764 | 18.9764 | 18.9475 | 18.9643 | 19600.0 |
| 2012-12-10 07:00:00 | AAPL | Stock | 18.9571 | 18.9571 | 18.875 | 18.9207 | 483336.0 |
| 2012-12-10 07:30:00 | AAPL | Stock | 18.9286 | 18.9943 | 18.9286 | 18.9554 | 356720.0 |
| 2012-12-10 08:00:00 | AAPL | Stock | 18.9643 | 18.9964 | 18.7907 | 18.8429 | 2331560.0 |
| 2012-12-10 08:30:00 | AAPL | Stock | 18.84 | 18.8507 | 18.7607 | 18.8161 | 3204404.0 |
| 2012-12-10 09:00:00 | AAPL | Stock | 18.8282 | 18.8711 | 18.7357 | 18.7386 | 3734136.0 |
| 2012-12-10 09:30:00 | AAPL | Stock | 18.7439 | 19.0486 | 18.6279 | 18.8979 | 135858100.0 |
| 2012-12-10 10:00:00 | AAPL | Stock | 18.9029 | 18.96 | 18.7975 | 18.9086 | 53514804.0 |
| 2012-12-10 10:30:00 | AAPL | Stock | 18.9139 | 19.1914 | 18.8754 | 19.1818 | 61924212.0 |
| 2012-12-10 11:00:00 | AAPL | Stock | 19.1736 | 19.2325 | 19.0982 | 19.1293 | 46858392.0 |
| 2012-12-10 11:30:00 | AAPL | Stock | 19.1382 | 19.1464 | 18.9825 | 19.0107 | 34190492.0 |
| 2012-12-10 12:00:00 | AAPL | Stock | 19.0095 | 19.0954 | 18.9486 | 18.9875 | 30335004.0 |
| 2012-12-10 12:30:00 | AAPL | Stock | 18.9839 | 19.0257 | 18.8679 | 18.9143 | 27322736.0 |
| 2012-12-10 13:00:00 | AAPL | Stock | 18.9157 | 18.9157 | 18.8071 | 18.8836 | 26867036.0 |
| 2012-12-10 13:30:00 | AAPL | Stock | 18.8814 | 18.9643 | 18.8271 | 18.88 | 21757092.0 |
| 2012-12-10 14:00:00 | AAPL | Stock | 18.88 | 18.96 | 18.8661 | 18.9123 | 21216524.0 |
| 2012-12-10 14:30:00 | AAPL | Stock | 18.9193 | 19.0889 | 18.84 | 19.0654 | 41830768.0 |
| 2012-12-10 15:00:00 | AAPL | Stock | 19.0661 | 19.0714 | 18.8971 | 19.0093 | 32783100.0 |
| 2012-12-10 15:30:00 | AAPL | Stock | 19.0125 | 19.0132 | 18.8957 | 18.9196 | 40881960.0 |
| 2012-12-10 16:00:00 | AAPL | Stock | 18.9211 | 19.0894 | 18.8986 | 18.9675 | 28722848.0 |
| 2012-12-10 16:30:00 | AAPL | Stock | 18.9554 | 18.9814 | 18.9364 | 18.9464 | 354788.0 |
| 2012-12-10 17:00:00 | AAPL | Stock | 18.9464 | 18.9504 | 18.9221 | 18.9411 | 250992.0 |
| 2012-12-10 17:30:00 | AAPL | Stock | 18.9496 | 18.9643 | 18.9454 | 18.9643 | 115220.0 |
| 2012-12-10 18:00:00 | AAPL | Stock | 18.9539 | 18.9604 | 18.9504 | 18.9604 | 33964.0 |
| 2012-12-10 18:30:00 | AAPL | Stock | 18.9639 | 18.9661 | 18.9575 | 18.9661 | 31304.0 |
| 2012-12-10 19:00:00 | AAPL | Stock | 18.965 | 18.9657 | 18.9561 | 18.9575 | 20104.0 |
| 2012-12-10 19:30:00 | AAPL | Stock | 18.9639 | 18.9643 | 18.9464 | 18.9632 | 226072.0 |
| 2012-12-10 04:00:00 | MSFT | Stock | 26.36 | 26.36 | 26.36 | 26.36 | 200.0 |
| 2012-12-10 04:30:00 | MSFT | Stock | 26.4 | 26.4 | 26.4 | 26.4 | 1000.0 |
| 2012-12-10 07:00:00 | MSFT | Stock | 26.4 | 26.4 | 26.4 | 26.4 | 1000.0 |
| 2012-12-10 07:30:00 | MSFT | Stock | 26.4 | 26.4 | 26.4 | 26.4 | 1500.0 |
| 2012-12-10 08:00:00 | MSFT | Stock | 26.41 | 26.44 | 26.32 | 26.41 | 13900.0 |
| 2012-12-10 08:30:00 | MSFT | Stock | 26.44 | 26.48 | 26.42 | 26.48 | 5850.0 |
| 2012-12-10 09:00:00 | MSFT | Stock | 26.45 | 26.57 | 26.45 | 26.55 | 32065.0 |
| 2012-12-10 09:30:00 | MSFT | Stock | 26.53 | 26.81 | 26.52 | 26.805 | 5902397.0 |
| 2012-12-10 10:00:00 | MSFT | Stock | 26.81 | 26.89 | 26.785 | 26.83 | 4467277.0 |
| 2012-12-10 10:30:00 | MSFT | Stock | 26.83 | 26.95 | 26.81 | 26.94 | 4795929.0 |
| 2012-12-10 11:00:00 | MSFT | Stock | 26.95 | 26.97 | 26.88 | 26.905 | 3536723.0 |
| 2012-12-10 11:30:00 | MSFT | Stock | 26.91 | 26.95 | 26.9 | 26.92 | 2060225.0 |
| 2012-12-10 12:00:00 | MSFT | Stock | 26.915 | 26.92 | 26.87 | 26.888 | 1596011.0 |
| 2012-12-10 12:30:00 | MSFT | Stock | 26.885 | 26.91 | 26.87 | 26.91 | 1548244.0 |
| 2012-12-10 13:00:00 | MSFT | Stock | 26.91 | 26.92 | 26.75 | 26.79 | 2454109.0 |
| 2012-12-10 13:30:00 | MSFT | Stock | 26.795 | 26.87 | 26.79 | 26.86 | 1511863.0 |
| 2012-12-10 14:00:00 | MSFT | Stock | 26.865 | 26.9 | 26.8 | 26.83 | 2258859.0 |
| 2012-12-10 14:30:00 | MSFT | Stock | 26.84 | 26.84 | 26.75 | 26.815 | 2085407.0 |
> showing 50 of 74,710 rows — these rows as CSV