PREVIEW / stock_30min / 2014-09-22
file: by_date/stock_30min/2014/2014-09-22.parquet size: 1.6 MB rows: 83,643 symbols: 3,592
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-09-22 04:00:00 | AAPL | Stock | 25.27 | 25.27 | 25.1275 | 25.1275 | 18000.0 |
| 2014-09-22 04:30:00 | AAPL | Stock | 25.1875 | 25.1875 | 25.1775 | 25.1775 | 4312.0 |
| 2014-09-22 05:00:00 | AAPL | Stock | 25.18 | 25.18 | 25.16 | 25.1625 | 12688.0 |
| 2014-09-22 05:30:00 | AAPL | Stock | 25.1825 | 25.1825 | 25.14 | 25.14 | 1200.0 |
| 2014-09-22 06:00:00 | AAPL | Stock | 25.1575 | 25.2725 | 25.145 | 25.225 | 14800.0 |
| 2014-09-22 06:30:00 | AAPL | Stock | 25.2975 | 25.2975 | 25.2675 | 25.275 | 24480.0 |
| 2014-09-22 07:00:00 | AAPL | Stock | 25.27 | 25.285 | 25.25 | 25.2525 | 80564.0 |
| 2014-09-22 07:30:00 | AAPL | Stock | 25.2525 | 25.3375 | 25.2475 | 25.3125 | 129400.0 |
| 2014-09-22 08:00:00 | AAPL | Stock | 25.3125 | 25.4125 | 25.245 | 25.3475 | 844260.0 |
| 2014-09-22 08:30:00 | AAPL | Stock | 25.3625 | 25.5625 | 25.125 | 25.4325 | 4138676.0 |
| 2014-09-22 09:00:00 | AAPL | Stock | 25.4275 | 25.4975 | 25.4225 | 25.445 | 1064136.0 |
| 2014-09-22 09:30:00 | AAPL | Stock | 25.45 | 25.535 | 25.33 | 25.404 | 34194140.0 |
| 2014-09-22 10:00:00 | AAPL | Stock | 25.4 | 25.41 | 25.2425 | 25.2825 | 19239040.0 |
| 2014-09-22 10:30:00 | AAPL | Stock | 25.2825 | 25.2913 | 25.1925 | 25.245 | 18168892.0 |
| 2014-09-22 11:00:00 | AAPL | Stock | 25.245 | 25.3325 | 25.2125 | 25.3038 | 12852124.0 |
| 2014-09-22 11:30:00 | AAPL | Stock | 25.305 | 25.345 | 25.2575 | 25.2692 | 9287288.0 |
| 2014-09-22 12:00:00 | AAPL | Stock | 25.27 | 25.2975 | 25.2125 | 25.265 | 8915692.0 |
| 2014-09-22 12:30:00 | AAPL | Stock | 25.2625 | 25.2675 | 25.24 | 25.2575 | 6632472.0 |
| 2014-09-22 13:00:00 | AAPL | Stock | 25.255 | 25.2575 | 25.145 | 25.2 | 10273316.0 |
| 2014-09-22 13:30:00 | AAPL | Stock | 25.2025 | 25.25 | 25.1725 | 25.1828 | 8213388.0 |
| 2014-09-22 14:00:00 | AAPL | Stock | 25.185 | 25.2375 | 25.1725 | 25.1825 | 9422052.0 |
| 2014-09-22 14:30:00 | AAPL | Stock | 25.1825 | 25.2725 | 25.17 | 25.2575 | 9180412.0 |
| 2014-09-22 15:00:00 | AAPL | Stock | 25.2558 | 25.2835 | 25.205 | 25.2495 | 9332688.0 |
| 2014-09-22 15:30:00 | AAPL | Stock | 25.2498 | 25.3325 | 25.2275 | 25.2675 | 20737404.0 |
| 2014-09-22 16:00:00 | AAPL | Stock | 25.265 | 25.291 | 25.2125 | 25.265 | 10277596.0 |
| 2014-09-22 16:30:00 | AAPL | Stock | 25.225 | 25.2415 | 25.21 | 25.2225 | 114952.0 |
| 2014-09-22 17:00:00 | AAPL | Stock | 25.22 | 25.2225 | 25.18 | 25.18 | 82660.0 |
| 2014-09-22 17:30:00 | AAPL | Stock | 25.185 | 25.265 | 25.18 | 25.19 | 1158192.0 |
| 2014-09-22 18:00:00 | AAPL | Stock | 25.1925 | 25.1975 | 25.1875 | 25.1875 | 49948.0 |
| 2014-09-22 18:30:00 | AAPL | Stock | 25.1875 | 25.2025 | 25.1875 | 25.1925 | 50556.0 |
| 2014-09-22 19:00:00 | AAPL | Stock | 25.1875 | 25.265 | 25.165 | 25.18 | 108572.0 |
| 2014-09-22 19:30:00 | AAPL | Stock | 25.1775 | 25.18 | 25.17 | 25.1775 | 82244.0 |
| 2014-09-22 04:00:00 | MSFT | Stock | 47.31 | 47.31 | 47.31 | 47.31 | 300.0 |
| 2014-09-22 04:30:00 | MSFT | Stock | 47.25 | 47.25 | 47.25 | 47.25 | 200.0 |
| 2014-09-22 06:30:00 | MSFT | Stock | 47.31 | 47.31 | 47.3 | 47.3 | 500.0 |
| 2014-09-22 07:00:00 | MSFT | Stock | 47.25 | 47.27 | 47.22 | 47.27 | 1015.0 |
| 2014-09-22 07:30:00 | MSFT | Stock | 47.22 | 47.25 | 47.12 | 47.25 | 20733.0 |
| 2014-09-22 08:00:00 | MSFT | Stock | 47.25 | 47.3 | 47.22 | 47.25 | 68604.0 |
| 2014-09-22 08:30:00 | MSFT | Stock | 47.28 | 47.3 | 47.25 | 47.26 | 50961.0 |
| 2014-09-22 09:00:00 | MSFT | Stock | 47.26 | 47.3 | 47.2 | 47.23 | 195061.0 |
| 2014-09-22 09:30:00 | MSFT | Stock | 47.3 | 47.36 | 47.05 | 47.32 | 6322613.0 |
| 2014-09-22 10:00:00 | MSFT | Stock | 47.32 | 47.38 | 47.13 | 47.15 | 3636897.0 |
| 2014-09-22 10:30:00 | MSFT | Stock | 47.16 | 47.17 | 47.01 | 47.09 | 3581430.0 |
| 2014-09-22 11:00:00 | MSFT | Stock | 47.085 | 47.18 | 47.05 | 47.09 | 2215702.0 |
| 2014-09-22 11:30:00 | MSFT | Stock | 47.09 | 47.135 | 47.05 | 47.095 | 1659299.0 |
| 2014-09-22 12:00:00 | MSFT | Stock | 47.09 | 47.19 | 47.06 | 47.134 | 1276689.0 |
| 2014-09-22 12:30:00 | MSFT | Stock | 47.13 | 47.21 | 47.09 | 47.185 | 1292735.0 |
| 2014-09-22 13:00:00 | MSFT | Stock | 47.19 | 47.21 | 47.1 | 47.19 | 1059655.0 |
| 2014-09-22 13:30:00 | MSFT | Stock | 47.2 | 47.21 | 47.045 | 47.05 | 1855573.0 |
| 2014-09-22 14:00:00 | MSFT | Stock | 47.05 | 47.12 | 47.01 | 47.01 | 1460877.0 |
> showing 50 of 83,643 rows — these rows as CSV