PREVIEW / stock_30min / 2016-02-11
file: by_date/stock_30min/2016/2016-02-11.parquet size: 1.6 MB rows: 83,779 symbols: 3,362
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 |
|---|---|---|---|---|---|---|---|
| 2016-02-11 04:00:00 | AAPL | Stock | 23.45 | 23.45 | 23.045 | 23.08 | 41644.0 |
| 2016-02-11 04:30:00 | AAPL | Stock | 23.1175 | 23.1175 | 23.005 | 23.055 | 70176.0 |
| 2016-02-11 05:00:00 | AAPL | Stock | 23.0375 | 23.0375 | 23.0375 | 23.0375 | 400.0 |
| 2016-02-11 05:30:00 | AAPL | Stock | 23.1125 | 23.1625 | 23.1125 | 23.15 | 8000.0 |
| 2016-02-11 06:00:00 | AAPL | Stock | 23.17 | 23.18 | 23.115 | 23.115 | 19088.0 |
| 2016-02-11 06:30:00 | AAPL | Stock | 23.1625 | 23.1875 | 23.05 | 23.115 | 20580.0 |
| 2016-02-11 07:00:00 | AAPL | Stock | 23.055 | 23.24 | 23.04 | 23.24 | 187220.0 |
| 2016-02-11 07:30:00 | AAPL | Stock | 23.215 | 23.29 | 23.1975 | 23.1975 | 129484.0 |
| 2016-02-11 08:00:00 | AAPL | Stock | 23.2125 | 23.3475 | 23.0625 | 23.325 | 313484.0 |
| 2016-02-11 08:30:00 | AAPL | Stock | 23.3275 | 23.375 | 23.3125 | 23.315 | 278360.0 |
| 2016-02-11 09:00:00 | AAPL | Stock | 23.325 | 23.4375 | 23.32 | 23.425 | 359576.0 |
| 2016-02-11 09:30:00 | AAPL | Stock | 23.4375 | 23.68 | 23.39 | 23.55 | 23772536.0 |
| 2016-02-11 10:00:00 | AAPL | Stock | 23.5525 | 23.635 | 23.3475 | 23.3625 | 18351496.0 |
| 2016-02-11 10:30:00 | AAPL | Stock | 23.3625 | 23.3875 | 23.2375 | 23.275 | 15738464.0 |
| 2016-02-11 11:00:00 | AAPL | Stock | 23.275 | 23.325 | 23.1752 | 23.1975 | 12550116.0 |
| 2016-02-11 11:30:00 | AAPL | Stock | 23.1975 | 23.325 | 23.1475 | 23.3 | 11123260.0 |
| 2016-02-11 12:00:00 | AAPL | Stock | 23.295 | 23.35 | 23.23 | 23.2475 | 7840908.0 |
| 2016-02-11 12:30:00 | AAPL | Stock | 23.2475 | 23.3825 | 23.221 | 23.361 | 7866396.0 |
| 2016-02-11 13:00:00 | AAPL | Stock | 23.3625 | 23.4175 | 23.3125 | 23.3425 | 7694444.0 |
| 2016-02-11 13:30:00 | AAPL | Stock | 23.3425 | 23.4075 | 23.2675 | 23.2962 | 7367644.0 |
| 2016-02-11 14:00:00 | AAPL | Stock | 23.295 | 23.3562 | 23.2475 | 23.26 | 7296228.0 |
| 2016-02-11 14:30:00 | AAPL | Stock | 23.26 | 23.5525 | 23.2025 | 23.465 | 18568948.0 |
| 2016-02-11 15:00:00 | AAPL | Stock | 23.4638 | 23.52 | 23.385 | 23.49 | 13600252.0 |
| 2016-02-11 15:30:00 | AAPL | Stock | 23.4875 | 23.5575 | 23.3825 | 23.415 | 19202712.0 |
| 2016-02-11 16:00:00 | AAPL | Stock | 23.4125 | 23.4932 | 23.2943 | 23.42 | 10969220.0 |
| 2016-02-11 16:30:00 | AAPL | Stock | 23.42 | 23.4375 | 23.3775 | 23.425 | 573260.0 |
| 2016-02-11 17:00:00 | AAPL | Stock | 23.425 | 23.43 | 23.4025 | 23.425 | 46384.0 |
| 2016-02-11 17:30:00 | AAPL | Stock | 23.425 | 23.425 | 23.35 | 23.3875 | 81280.0 |
| 2016-02-11 18:00:00 | AAPL | Stock | 23.3875 | 23.4225 | 23.3875 | 23.4125 | 107056.0 |
| 2016-02-11 18:30:00 | AAPL | Stock | 23.4 | 23.4075 | 23.3875 | 23.4075 | 19720.0 |
| 2016-02-11 19:00:00 | AAPL | Stock | 23.4025 | 23.425 | 23.3975 | 23.425 | 24844.0 |
| 2016-02-11 19:30:00 | AAPL | Stock | 23.4025 | 23.42 | 23.3875 | 23.4 | 37220.0 |
| 2016-02-11 04:30:00 | MSFT | Stock | 48.45 | 48.45 | 48.45 | 48.45 | 100.0 |
| 2016-02-11 05:00:00 | MSFT | Stock | 48.75 | 48.75 | 48.75 | 48.75 | 1500.0 |
| 2016-02-11 06:00:00 | MSFT | Stock | 48.56 | 48.56 | 48.56 | 48.56 | 200.0 |
| 2016-02-11 06:30:00 | MSFT | Stock | 48.6 | 48.6 | 48.56 | 48.56 | 10450.0 |
| 2016-02-11 07:00:00 | MSFT | Stock | 48.46 | 48.78 | 48.28 | 48.78 | 4560.0 |
| 2016-02-11 07:30:00 | MSFT | Stock | 48.8 | 48.89 | 48.6 | 48.6 | 12027.0 |
| 2016-02-11 08:00:00 | MSFT | Stock | 48.69 | 48.8 | 48.28 | 48.67 | 11702.0 |
| 2016-02-11 08:30:00 | MSFT | Stock | 48.67 | 48.88 | 48.67 | 48.8 | 4237.0 |
| 2016-02-11 09:00:00 | MSFT | Stock | 48.75 | 48.94 | 48.62 | 48.68 | 65520.0 |
| 2016-02-11 09:30:00 | MSFT | Stock | 48.67 | 49.49 | 48.51 | 49.37 | 4645226.0 |
| 2016-02-11 10:00:00 | MSFT | Stock | 49.35 | 49.42 | 49.07 | 49.195 | 3514352.0 |
| 2016-02-11 10:30:00 | MSFT | Stock | 49.19 | 49.36 | 49.05 | 49.085 | 2577730.0 |
| 2016-02-11 11:00:00 | MSFT | Stock | 49.09 | 49.19 | 48.83 | 48.906 | 3044549.0 |
| 2016-02-11 11:30:00 | MSFT | Stock | 48.905 | 49.3 | 48.84 | 49.216 | 1940097.0 |
| 2016-02-11 12:00:00 | MSFT | Stock | 49.215 | 49.39 | 48.945 | 49.1 | 2245878.0 |
| 2016-02-11 12:30:00 | MSFT | Stock | 49.1 | 49.28 | 48.9 | 49.27 | 2350561.0 |
| 2016-02-11 13:00:00 | MSFT | Stock | 49.29 | 49.41 | 49.13 | 49.13 | 2441572.0 |
| 2016-02-11 13:30:00 | MSFT | Stock | 49.13 | 49.25 | 48.93 | 49.005 | 2183244.0 |
> showing 50 of 83,779 rows — these rows as CSV