PREVIEW / stock_30min / 2015-11-24
file: by_date/stock_30min/2015/2015-11-24.parquet size: 1.6 MB rows: 82,506 symbols: 3,423
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-11-24 04:00:00 | AAPL | Stock | 29.325 | 29.325 | 29.185 | 29.2975 | 21868.0 |
| 2015-11-24 04:30:00 | AAPL | Stock | 29.2825 | 29.2825 | 29.2825 | 29.2825 | 516.0 |
| 2015-11-24 05:00:00 | AAPL | Stock | 29.3025 | 29.3225 | 29.2875 | 29.2875 | 1816.0 |
| 2015-11-24 06:00:00 | AAPL | Stock | 29.275 | 29.3025 | 29.275 | 29.3025 | 5120.0 |
| 2015-11-24 06:30:00 | AAPL | Stock | 29.3 | 29.3 | 29.28 | 29.28 | 800.0 |
| 2015-11-24 07:00:00 | AAPL | Stock | 29.32 | 29.345 | 29.2875 | 29.295 | 64616.0 |
| 2015-11-24 07:30:00 | AAPL | Stock | 29.295 | 29.3225 | 29.2475 | 29.27 | 60884.0 |
| 2015-11-24 08:00:00 | AAPL | Stock | 29.2625 | 29.345 | 29.24 | 29.2675 | 374732.0 |
| 2015-11-24 08:30:00 | AAPL | Stock | 29.2675 | 29.3375 | 29.24 | 29.2925 | 254808.0 |
| 2015-11-24 09:00:00 | AAPL | Stock | 29.28 | 29.3225 | 29.2525 | 29.32 | 325708.0 |
| 2015-11-24 09:30:00 | AAPL | Stock | 29.3325 | 29.79 | 29.28 | 29.75 | 26103576.0 |
| 2015-11-24 10:00:00 | AAPL | Stock | 29.7475 | 29.8075 | 29.5325 | 29.5825 | 15383224.0 |
| 2015-11-24 10:30:00 | AAPL | Stock | 29.5825 | 29.59 | 29.36 | 29.48 | 16461660.0 |
| 2015-11-24 11:00:00 | AAPL | Stock | 29.48 | 29.6675 | 29.4575 | 29.6575 | 9568452.0 |
| 2015-11-24 11:30:00 | AAPL | Stock | 29.66 | 29.8375 | 29.6275 | 29.7575 | 13091064.0 |
| 2015-11-24 12:00:00 | AAPL | Stock | 29.76 | 29.79 | 29.6425 | 29.7 | 6960456.0 |
| 2015-11-24 12:30:00 | AAPL | Stock | 29.705 | 29.7275 | 29.6675 | 29.675 | 4037716.0 |
| 2015-11-24 13:00:00 | AAPL | Stock | 29.675 | 29.73 | 29.6575 | 29.7075 | 5132972.0 |
| 2015-11-24 13:30:00 | AAPL | Stock | 29.705 | 29.74 | 29.6925 | 29.6925 | 4464464.0 |
| 2015-11-24 14:00:00 | AAPL | Stock | 29.6925 | 29.7775 | 29.5902 | 29.655 | 8004712.0 |
| 2015-11-24 14:30:00 | AAPL | Stock | 29.6525 | 29.7675 | 29.595 | 29.7545 | 5798060.0 |
| 2015-11-24 15:00:00 | AAPL | Stock | 29.7525 | 29.7875 | 29.7 | 29.715 | 7265828.0 |
| 2015-11-24 15:30:00 | AAPL | Stock | 29.7162 | 29.7325 | 29.6425 | 29.7275 | 11214868.0 |
| 2015-11-24 16:00:00 | AAPL | Stock | 29.72 | 29.72 | 29.679 | 29.7 | 25844872.0 |
| 2015-11-24 16:30:00 | AAPL | Stock | 29.6875 | 29.6975 | 29.685 | 29.685 | 23736.0 |
| 2015-11-24 17:00:00 | AAPL | Stock | 29.6875 | 29.6975 | 29.6875 | 29.69 | 9720.0 |
| 2015-11-24 17:30:00 | AAPL | Stock | 29.69 | 29.69 | 29.68 | 29.685 | 27800.0 |
| 2015-11-24 18:00:00 | AAPL | Stock | 29.685 | 29.6875 | 29.675 | 29.6875 | 22360.0 |
| 2015-11-24 18:30:00 | AAPL | Stock | 29.6975 | 29.7125 | 29.6975 | 29.7125 | 23684.0 |
| 2015-11-24 19:00:00 | AAPL | Stock | 29.7125 | 29.7125 | 29.705 | 29.705 | 39160.0 |
| 2015-11-24 19:30:00 | AAPL | Stock | 29.7 | 29.7 | 29.6625 | 29.6625 | 28128.0 |
| 2015-11-24 05:30:00 | MSFT | Stock | 54.0 | 54.0 | 53.99 | 53.99 | 737.0 |
| 2015-11-24 06:00:00 | MSFT | Stock | 53.89 | 53.89 | 53.89 | 53.89 | 200.0 |
| 2015-11-24 07:30:00 | MSFT | Stock | 53.77 | 53.82 | 53.74 | 53.82 | 12000.0 |
| 2015-11-24 08:00:00 | MSFT | Stock | 53.72 | 53.82 | 53.69 | 53.76 | 6216.0 |
| 2015-11-24 08:30:00 | MSFT | Stock | 53.81 | 53.82 | 53.8 | 53.82 | 10750.0 |
| 2015-11-24 09:00:00 | MSFT | Stock | 53.8 | 53.95 | 53.8 | 53.93 | 12571.0 |
| 2015-11-24 09:30:00 | MSFT | Stock | 53.92 | 54.16 | 53.83 | 54.07 | 2649669.0 |
| 2015-11-24 10:00:00 | MSFT | Stock | 54.07 | 54.07 | 53.84 | 53.894 | 1847136.0 |
| 2015-11-24 10:30:00 | MSFT | Stock | 53.89 | 53.89 | 53.58 | 53.82 | 1857700.0 |
| 2015-11-24 11:00:00 | MSFT | Stock | 53.82 | 54.12 | 53.67 | 54.05 | 1590763.0 |
| 2015-11-24 11:30:00 | MSFT | Stock | 54.06 | 54.25 | 54.06 | 54.085 | 1649875.0 |
| 2015-11-24 12:00:00 | MSFT | Stock | 54.09 | 54.24 | 53.99 | 54.07 | 1302461.0 |
| 2015-11-24 12:30:00 | MSFT | Stock | 54.08 | 54.14 | 54.025 | 54.036 | 677172.0 |
| 2015-11-24 13:00:00 | MSFT | Stock | 54.04 | 54.21 | 54.025 | 54.19 | 1341073.0 |
| 2015-11-24 13:30:00 | MSFT | Stock | 54.19 | 54.25 | 54.15 | 54.18 | 1089199.0 |
| 2015-11-24 14:00:00 | MSFT | Stock | 54.185 | 54.44 | 54.11 | 54.15 | 1907772.0 |
| 2015-11-24 14:30:00 | MSFT | Stock | 54.14 | 54.31 | 54.1 | 54.29 | 969221.0 |
| 2015-11-24 15:00:00 | MSFT | Stock | 54.29 | 54.43 | 54.23 | 54.275 | 1538122.0 |
| 2015-11-24 15:30:00 | MSFT | Stock | 54.275 | 54.355 | 54.15 | 54.26 | 2828721.0 |
> showing 50 of 82,506 rows — these rows as CSV