PREVIEW / stock_30min / 2015-04-16
file: by_date/stock_30min/2015/2015-04-16.parquet size: 1.6 MB rows: 82,029 symbols: 3,515
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 |
|---|---|---|---|---|---|---|---|
| 2015-04-16 04:00:00 | AAPL | Stock | 31.65 | 31.685 | 31.625 | 31.625 | 12020.0 |
| 2015-04-16 05:00:00 | AAPL | Stock | 31.67 | 31.6725 | 31.67 | 31.6725 | 1084.0 |
| 2015-04-16 05:30:00 | AAPL | Stock | 31.6625 | 31.6625 | 31.6375 | 31.6375 | 3944.0 |
| 2015-04-16 06:00:00 | AAPL | Stock | 31.6 | 31.6025 | 31.575 | 31.5975 | 14400.0 |
| 2015-04-16 06:30:00 | AAPL | Stock | 31.5875 | 31.625 | 31.585 | 31.605 | 12256.0 |
| 2015-04-16 07:00:00 | AAPL | Stock | 31.6 | 31.61 | 31.5775 | 31.58 | 53292.0 |
| 2015-04-16 07:30:00 | AAPL | Stock | 31.585 | 31.6125 | 31.585 | 31.6125 | 46156.0 |
| 2015-04-16 08:00:00 | AAPL | Stock | 31.6125 | 31.67 | 31.5775 | 31.6525 | 218156.0 |
| 2015-04-16 08:30:00 | AAPL | Stock | 31.65 | 31.6525 | 31.585 | 31.595 | 205476.0 |
| 2015-04-16 09:00:00 | AAPL | Stock | 31.6025 | 31.6675 | 31.5625 | 31.6075 | 321496.0 |
| 2015-04-16 09:30:00 | AAPL | Stock | 31.605 | 31.775 | 31.5425 | 31.6525 | 16864636.0 |
| 2015-04-16 10:00:00 | AAPL | Stock | 31.655 | 31.7 | 31.6118 | 31.625 | 8857100.0 |
| 2015-04-16 10:30:00 | AAPL | Stock | 31.625 | 31.6725 | 31.605 | 31.6215 | 7243132.0 |
| 2015-04-16 11:00:00 | AAPL | Stock | 31.6175 | 31.6475 | 31.5825 | 31.62 | 5370624.0 |
| 2015-04-16 11:30:00 | AAPL | Stock | 31.62 | 31.6625 | 31.6075 | 31.66 | 5647192.0 |
| 2015-04-16 12:00:00 | AAPL | Stock | 31.6612 | 31.67 | 31.6 | 31.62 | 3963752.0 |
| 2015-04-16 12:30:00 | AAPL | Stock | 31.6225 | 31.63 | 31.5825 | 31.6125 | 3837036.0 |
| 2015-04-16 13:00:00 | AAPL | Stock | 31.6125 | 31.63 | 31.5875 | 31.615 | 4054484.0 |
| 2015-04-16 13:30:00 | AAPL | Stock | 31.615 | 31.73 | 31.595 | 31.7225 | 6572012.0 |
| 2015-04-16 14:00:00 | AAPL | Stock | 31.723 | 31.7325 | 31.64 | 31.6588 | 5470644.0 |
| 2015-04-16 14:30:00 | AAPL | Stock | 31.66 | 31.665 | 31.5725 | 31.5775 | 6469600.0 |
| 2015-04-16 15:00:00 | AAPL | Stock | 31.58 | 31.64 | 31.5525 | 31.5838 | 8970172.0 |
| 2015-04-16 15:30:00 | AAPL | Stock | 31.5825 | 31.6225 | 31.5275 | 31.545 | 11745088.0 |
| 2015-04-16 16:00:00 | AAPL | Stock | 31.5425 | 31.6672 | 31.5325 | 31.55 | 4129540.0 |
| 2015-04-16 16:30:00 | AAPL | Stock | 31.5475 | 31.55 | 31.5425 | 31.5475 | 35472.0 |
| 2015-04-16 17:00:00 | AAPL | Stock | 31.55 | 31.62 | 31.55 | 31.6125 | 383604.0 |
| 2015-04-16 17:30:00 | AAPL | Stock | 31.6075 | 31.6775 | 31.575 | 31.6702 | 429392.0 |
| 2015-04-16 18:00:00 | AAPL | Stock | 31.67 | 31.675 | 31.6525 | 31.6525 | 35944.0 |
| 2015-04-16 18:30:00 | AAPL | Stock | 31.655 | 31.655 | 31.6375 | 31.64 | 37820.0 |
| 2015-04-16 19:00:00 | AAPL | Stock | 31.6375 | 31.64 | 31.625 | 31.64 | 31264.0 |
| 2015-04-16 19:30:00 | AAPL | Stock | 31.6402 | 31.6625 | 31.63 | 31.66 | 114584.0 |
| 2015-04-16 06:00:00 | MSFT | Stock | 42.32 | 42.32 | 42.32 | 42.32 | 760.0 |
| 2015-04-16 07:30:00 | MSFT | Stock | 42.11 | 42.11 | 42.08 | 42.08 | 3562.0 |
| 2015-04-16 08:00:00 | MSFT | Stock | 42.09 | 42.1 | 42.06 | 42.1 | 5575.0 |
| 2015-04-16 08:30:00 | MSFT | Stock | 42.1 | 42.11 | 42.08 | 42.08 | 6487.0 |
| 2015-04-16 09:00:00 | MSFT | Stock | 42.08 | 42.08 | 41.9 | 41.97 | 24422.0 |
| 2015-04-16 09:30:00 | MSFT | Stock | 41.95 | 42.19 | 41.82 | 42.055 | 2773269.0 |
| 2015-04-16 10:00:00 | MSFT | Stock | 42.06 | 42.14 | 41.88 | 41.89 | 1669755.0 |
| 2015-04-16 10:30:00 | MSFT | Stock | 41.89 | 42.04 | 41.83 | 42.0 | 1924042.0 |
| 2015-04-16 11:00:00 | MSFT | Stock | 42.0 | 42.14 | 42.0 | 42.13 | 1061895.0 |
| 2015-04-16 11:30:00 | MSFT | Stock | 42.131 | 42.15 | 42.0 | 42.05 | 1317228.0 |
| 2015-04-16 12:00:00 | MSFT | Stock | 42.05 | 42.13 | 42.04 | 42.106 | 606268.0 |
| 2015-04-16 12:30:00 | MSFT | Stock | 42.11 | 42.14 | 42.08 | 42.084 | 596214.0 |
| 2015-04-16 13:00:00 | MSFT | Stock | 42.08 | 42.15 | 42.05 | 42.13 | 648382.0 |
| 2015-04-16 13:30:00 | MSFT | Stock | 42.13 | 42.32 | 42.11 | 42.305 | 820541.0 |
| 2015-04-16 14:00:00 | MSFT | Stock | 42.31 | 42.34 | 42.28 | 42.316 | 855017.0 |
| 2015-04-16 14:30:00 | MSFT | Stock | 42.31 | 42.33 | 42.25 | 42.28 | 934090.0 |
| 2015-04-16 15:00:00 | MSFT | Stock | 42.285 | 42.29 | 42.14 | 42.17 | 1655675.0 |
| 2015-04-16 15:30:00 | MSFT | Stock | 42.17 | 42.24 | 42.13 | 42.17 | 2948869.0 |
| 2015-04-16 16:00:00 | MSFT | Stock | 42.16 | 42.18 | 42.15 | 42.18 | 3662688.0 |
> showing 50 of 82,029 rows — these rows as CSV