PREVIEW / stock_30min / 2015-02-12
file: by_date/stock_30min/2015/2015-02-12.parquet size: 1.6 MB rows: 82,436 symbols: 3,526
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-02-12 04:00:00 | AAPL | Stock | 31.375 | 31.6225 | 31.375 | 31.5475 | 115936.0 |
| 2015-02-12 04:30:00 | AAPL | Stock | 31.5475 | 31.575 | 31.4775 | 31.57 | 76116.0 |
| 2015-02-12 05:00:00 | AAPL | Stock | 31.57 | 31.595 | 31.5125 | 31.545 | 110476.0 |
| 2015-02-12 05:30:00 | AAPL | Stock | 31.545 | 31.575 | 31.545 | 31.575 | 53992.0 |
| 2015-02-12 06:00:00 | AAPL | Stock | 31.5725 | 31.5975 | 31.5 | 31.535 | 201976.0 |
| 2015-02-12 06:30:00 | AAPL | Stock | 31.505 | 31.5875 | 31.4975 | 31.5075 | 77760.0 |
| 2015-02-12 07:00:00 | AAPL | Stock | 31.5 | 31.5075 | 31.45 | 31.485 | 212552.0 |
| 2015-02-12 07:30:00 | AAPL | Stock | 31.48 | 31.52 | 31.4125 | 31.52 | 270280.0 |
| 2015-02-12 08:00:00 | AAPL | Stock | 31.51 | 31.575 | 31.2 | 31.5 | 1447336.0 |
| 2015-02-12 08:30:00 | AAPL | Stock | 31.505 | 31.535 | 31.46 | 31.46 | 941780.0 |
| 2015-02-12 09:00:00 | AAPL | Stock | 31.46 | 31.5375 | 31.425 | 31.5375 | 1691884.0 |
| 2015-02-12 09:30:00 | AAPL | Stock | 31.515 | 31.7975 | 31.46 | 31.785 | 62786000.0 |
| 2015-02-12 10:00:00 | AAPL | Stock | 31.7895 | 31.87 | 31.6875 | 31.7125 | 32803076.0 |
| 2015-02-12 10:30:00 | AAPL | Stock | 31.7125 | 31.785 | 31.675 | 31.7375 | 24342796.0 |
| 2015-02-12 11:00:00 | AAPL | Stock | 31.7375 | 31.7775 | 31.555 | 31.6 | 21121556.0 |
| 2015-02-12 11:30:00 | AAPL | Stock | 31.6 | 31.6225 | 31.3925 | 31.5408 | 26689700.0 |
| 2015-02-12 12:00:00 | AAPL | Stock | 31.542 | 31.665 | 31.5362 | 31.6502 | 13923864.0 |
| 2015-02-12 12:30:00 | AAPL | Stock | 31.65 | 31.6842 | 31.565 | 31.6025 | 10676256.0 |
| 2015-02-12 13:00:00 | AAPL | Stock | 31.6025 | 31.645 | 31.48 | 31.53 | 12821584.0 |
| 2015-02-12 13:30:00 | AAPL | Stock | 31.53 | 31.6425 | 31.53 | 31.6325 | 11271612.0 |
| 2015-02-12 14:00:00 | AAPL | Stock | 31.6325 | 31.6375 | 31.56 | 31.59 | 9409144.0 |
| 2015-02-12 14:30:00 | AAPL | Stock | 31.59 | 31.655 | 31.5425 | 31.6082 | 10193628.0 |
| 2015-02-12 15:00:00 | AAPL | Stock | 31.6125 | 31.63 | 31.555 | 31.5975 | 9337916.0 |
| 2015-02-12 15:30:00 | AAPL | Stock | 31.6 | 31.64 | 31.54 | 31.6075 | 17531048.0 |
| 2015-02-12 16:00:00 | AAPL | Stock | 31.615 | 31.6538 | 31.1325 | 31.61 | 8287084.0 |
| 2015-02-12 16:30:00 | AAPL | Stock | 31.6075 | 31.6182 | 31.59 | 31.5925 | 191376.0 |
| 2015-02-12 17:00:00 | AAPL | Stock | 31.5925 | 31.626 | 31.5675 | 31.5875 | 3632064.0 |
| 2015-02-12 17:30:00 | AAPL | Stock | 31.585 | 31.615 | 31.585 | 31.595 | 114240.0 |
| 2015-02-12 18:00:00 | AAPL | Stock | 31.595 | 31.615 | 31.22 | 31.595 | 104904.0 |
| 2015-02-12 18:30:00 | AAPL | Stock | 31.5825 | 31.5825 | 31.575 | 31.58 | 24664.0 |
| 2015-02-12 19:00:00 | AAPL | Stock | 31.5775 | 31.5875 | 31.5675 | 31.5675 | 44540.0 |
| 2015-02-12 19:30:00 | AAPL | Stock | 31.5775 | 31.5775 | 31.55 | 31.555 | 83828.0 |
| 2015-02-12 07:00:00 | MSFT | Stock | 42.51 | 42.6 | 42.51 | 42.59 | 5135.0 |
| 2015-02-12 07:30:00 | MSFT | Stock | 42.59 | 42.59 | 42.59 | 42.59 | 3050.0 |
| 2015-02-12 08:00:00 | MSFT | Stock | 42.58 | 42.59 | 42.52 | 42.52 | 209114.0 |
| 2015-02-12 08:30:00 | MSFT | Stock | 42.5 | 42.56 | 42.49 | 42.49 | 9720.0 |
| 2015-02-12 09:00:00 | MSFT | Stock | 42.53 | 42.66 | 42.5 | 42.65 | 70225.0 |
| 2015-02-12 09:30:00 | MSFT | Stock | 42.62 | 42.83 | 42.51 | 42.75 | 3668074.0 |
| 2015-02-12 10:00:00 | MSFT | Stock | 42.76 | 42.82 | 42.66 | 42.719 | 1902509.0 |
| 2015-02-12 10:30:00 | MSFT | Stock | 42.72 | 42.765 | 42.69 | 42.735 | 1603196.0 |
| 2015-02-12 11:00:00 | MSFT | Stock | 42.74 | 42.75 | 42.62 | 42.685 | 1806583.0 |
| 2015-02-12 11:30:00 | MSFT | Stock | 42.69 | 42.74 | 42.65 | 42.655 | 1415255.0 |
| 2015-02-12 12:00:00 | MSFT | Stock | 42.656 | 42.75 | 42.63 | 42.73 | 1112971.0 |
| 2015-02-12 12:30:00 | MSFT | Stock | 42.73 | 42.78 | 42.7 | 42.76 | 1566667.0 |
| 2015-02-12 13:00:00 | MSFT | Stock | 42.755 | 42.92 | 42.75 | 42.915 | 1644466.0 |
| 2015-02-12 13:30:00 | MSFT | Stock | 42.92 | 42.96 | 42.85 | 42.94 | 1382417.0 |
| 2015-02-12 14:00:00 | MSFT | Stock | 42.935 | 42.96 | 42.86 | 42.89 | 1242335.0 |
| 2015-02-12 14:30:00 | MSFT | Stock | 42.892 | 43.05 | 42.87 | 43.05 | 1808200.0 |
| 2015-02-12 15:00:00 | MSFT | Stock | 43.04 | 43.05 | 42.935 | 42.975 | 1876166.0 |
| 2015-02-12 15:30:00 | MSFT | Stock | 42.98 | 43.09 | 42.97 | 43.08 | 4311043.0 |
> showing 50 of 82,436 rows — these rows as CSV