PREVIEW / stock_30min / 2013-02-08
file: by_date/stock_30min/2013/2013-02-08.parquet size: 1.4 MB rows: 74,136 symbols: 3,464
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 |
|---|---|---|---|---|---|---|---|
| 2013-02-08 04:00:00 | AAPL | Stock | 16.7221 | 16.7221 | 16.6729 | 16.6729 | 13860.0 |
| 2013-02-08 04:30:00 | AAPL | Stock | 16.7107 | 16.7107 | 16.7046 | 16.7107 | 16800.0 |
| 2013-02-08 05:00:00 | AAPL | Stock | 16.7107 | 16.7143 | 16.7107 | 16.7143 | 15932.0 |
| 2013-02-08 05:30:00 | AAPL | Stock | 16.7143 | 16.7214 | 16.7089 | 16.7214 | 28000.0 |
| 2013-02-08 06:00:00 | AAPL | Stock | 16.7214 | 16.7214 | 16.6964 | 16.7107 | 12600.0 |
| 2013-02-08 06:30:00 | AAPL | Stock | 16.6964 | 16.6964 | 16.675 | 16.675 | 99064.0 |
| 2013-02-08 07:00:00 | AAPL | Stock | 16.675 | 16.775 | 16.6607 | 16.7718 | 541408.0 |
| 2013-02-08 07:30:00 | AAPL | Stock | 16.7714 | 16.8732 | 16.7707 | 16.8729 | 3427928.0 |
| 2013-02-08 08:00:00 | AAPL | Stock | 16.8664 | 16.8714 | 16.7857 | 16.8046 | 5184732.0 |
| 2013-02-08 08:30:00 | AAPL | Stock | 16.7993 | 16.8743 | 16.7993 | 16.8343 | 5572952.0 |
| 2013-02-08 09:00:00 | AAPL | Stock | 16.8343 | 16.9321 | 16.8325 | 16.9314 | 6394304.0 |
| 2013-02-08 09:30:00 | AAPL | Stock | 16.9318 | 16.9643 | 16.7946 | 16.9307 | 141108800.0 |
| 2013-02-08 10:00:00 | AAPL | Stock | 16.9289 | 16.9365 | 16.8486 | 16.8914 | 42876736.0 |
| 2013-02-08 10:30:00 | AAPL | Stock | 16.8936 | 17.0071 | 16.88 | 17.0021 | 51020984.0 |
| 2013-02-08 11:00:00 | AAPL | Stock | 17.0016 | 17.0554 | 16.9821 | 17.0248 | 51690100.0 |
| 2013-02-08 11:30:00 | AAPL | Stock | 17.0211 | 17.03 | 16.9814 | 17.0204 | 26738908.0 |
| 2013-02-08 12:00:00 | AAPL | Stock | 17.0239 | 17.0264 | 16.9868 | 16.9907 | 16842616.0 |
| 2013-02-08 12:30:00 | AAPL | Stock | 16.9911 | 16.9943 | 16.9168 | 16.9826 | 34747412.0 |
| 2013-02-08 13:00:00 | AAPL | Stock | 16.9867 | 17.0075 | 16.9479 | 16.9593 | 17306436.0 |
| 2013-02-08 13:30:00 | AAPL | Stock | 16.9606 | 17.0229 | 16.9554 | 16.9996 | 18981312.0 |
| 2013-02-08 14:00:00 | AAPL | Stock | 16.9996 | 17.0932 | 16.9921 | 17.088 | 40184088.0 |
| 2013-02-08 14:30:00 | AAPL | Stock | 17.0883 | 17.1004 | 17.0325 | 17.055 | 35575932.0 |
| 2013-02-08 15:00:00 | AAPL | Stock | 17.0589 | 17.0857 | 16.9912 | 17.0239 | 40674564.0 |
| 2013-02-08 15:30:00 | AAPL | Stock | 17.0218 | 17.0264 | 16.94 | 16.9632 | 60615212.0 |
| 2013-02-08 16:00:00 | AAPL | Stock | 16.9636 | 16.9861 | 16.8719 | 16.9679 | 12141108.0 |
| 2013-02-08 16:30:00 | AAPL | Stock | 16.9679 | 17.0197 | 16.9643 | 16.9679 | 432124.0 |
| 2013-02-08 17:00:00 | AAPL | Stock | 16.9664 | 16.9671 | 16.9639 | 16.9661 | 82712.0 |
| 2013-02-08 17:30:00 | AAPL | Stock | 16.9643 | 16.9661 | 16.9629 | 16.9661 | 100156.0 |
| 2013-02-08 18:00:00 | AAPL | Stock | 16.9646 | 16.9675 | 16.9646 | 16.9664 | 46760.0 |
| 2013-02-08 18:30:00 | AAPL | Stock | 16.9679 | 16.98 | 16.9671 | 16.9746 | 87388.0 |
| 2013-02-08 19:00:00 | AAPL | Stock | 16.9786 | 16.9811 | 16.9768 | 16.9782 | 62944.0 |
| 2013-02-08 19:30:00 | AAPL | Stock | 16.9786 | 16.9921 | 16.9768 | 16.9875 | 285180.0 |
| 2013-02-08 07:00:00 | MSFT | Stock | 27.4 | 27.4 | 27.39 | 27.39 | 500.0 |
| 2013-02-08 07:30:00 | MSFT | Stock | 27.35 | 27.35 | 27.35 | 27.35 | 500.0 |
| 2013-02-08 08:00:00 | MSFT | Stock | 27.38 | 27.39 | 27.33 | 27.35 | 22942.0 |
| 2013-02-08 08:30:00 | MSFT | Stock | 27.28 | 27.28 | 27.28 | 27.28 | 40437.0 |
| 2013-02-08 09:00:00 | MSFT | Stock | 27.34 | 27.37 | 27.34 | 27.36 | 10840.0 |
| 2013-02-08 09:30:00 | MSFT | Stock | 27.36 | 27.71 | 27.31 | 27.64 | 6799954.0 |
| 2013-02-08 10:00:00 | MSFT | Stock | 27.645 | 27.67 | 27.55 | 27.635 | 4682864.0 |
| 2013-02-08 10:30:00 | MSFT | Stock | 27.636 | 27.65 | 27.59 | 27.6 | 1987072.0 |
| 2013-02-08 11:00:00 | MSFT | Stock | 27.6 | 27.64 | 27.52 | 27.6 | 2191892.0 |
| 2013-02-08 11:30:00 | MSFT | Stock | 27.6 | 27.61 | 27.54 | 27.59 | 1923355.0 |
| 2013-02-08 12:00:00 | MSFT | Stock | 27.6 | 27.63 | 27.58 | 27.602 | 1111373.0 |
| 2013-02-08 12:30:00 | MSFT | Stock | 27.61 | 27.62 | 27.575 | 27.586 | 1241421.0 |
| 2013-02-08 13:00:00 | MSFT | Stock | 27.59 | 27.64 | 27.58 | 27.61 | 1055602.0 |
| 2013-02-08 13:30:00 | MSFT | Stock | 27.61 | 27.645 | 27.59 | 27.61 | 1198517.0 |
| 2013-02-08 14:00:00 | MSFT | Stock | 27.61 | 27.63 | 27.52 | 27.585 | 1621516.0 |
| 2013-02-08 14:30:00 | MSFT | Stock | 27.59 | 27.59 | 27.5 | 27.507 | 949300.0 |
| 2013-02-08 15:00:00 | MSFT | Stock | 27.51 | 27.53 | 27.48 | 27.5 | 1199806.0 |
| 2013-02-08 15:30:00 | MSFT | Stock | 27.51 | 27.55 | 27.47 | 27.55 | 4613463.0 |
> showing 50 of 74,136 rows — these rows as CSV