PREVIEW / stock_30min / 2017-03-03
file: by_date/stock_30min/2017/2017-03-03.parquet size: 1.6 MB rows: 80,291 symbols: 3,065
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 |
|---|---|---|---|---|---|---|---|
| 2017-03-03 05:30:00 | AAPL | Stock | 34.72 | 34.72 | 34.72 | 34.72 | 604.0 |
| 2017-03-03 06:00:00 | AAPL | Stock | 34.7175 | 34.745 | 34.7175 | 34.745 | 4000.0 |
| 2017-03-03 06:30:00 | AAPL | Stock | 34.7225 | 34.7225 | 34.7125 | 34.7125 | 2184.0 |
| 2017-03-03 07:00:00 | AAPL | Stock | 34.7125 | 34.725 | 34.7 | 34.7125 | 10800.0 |
| 2017-03-03 07:30:00 | AAPL | Stock | 34.705 | 34.705 | 34.6375 | 34.6575 | 43832.0 |
| 2017-03-03 08:00:00 | AAPL | Stock | 34.725 | 34.7375 | 34.65 | 34.67 | 82228.0 |
| 2017-03-03 08:30:00 | AAPL | Stock | 34.665 | 34.6725 | 34.645 | 34.6575 | 81496.0 |
| 2017-03-03 09:00:00 | AAPL | Stock | 34.6575 | 34.6975 | 34.6475 | 34.6925 | 93408.0 |
| 2017-03-03 09:30:00 | AAPL | Stock | 34.69 | 34.835 | 34.6475 | 34.783 | 11310500.0 |
| 2017-03-03 10:00:00 | AAPL | Stock | 34.785 | 34.8375 | 34.73 | 34.7725 | 5634376.0 |
| 2017-03-03 10:30:00 | AAPL | Stock | 34.775 | 34.7775 | 34.715 | 34.7525 | 4045976.0 |
| 2017-03-03 11:00:00 | AAPL | Stock | 34.7525 | 34.8075 | 34.7225 | 34.7788 | 3315792.0 |
| 2017-03-03 11:30:00 | AAPL | Stock | 34.775 | 34.805 | 34.7425 | 34.7925 | 3212456.0 |
| 2017-03-03 12:00:00 | AAPL | Stock | 34.7925 | 34.8335 | 34.7738 | 34.8275 | 2935140.0 |
| 2017-03-03 12:30:00 | AAPL | Stock | 34.8275 | 34.8825 | 34.825 | 34.8675 | 4002308.0 |
| 2017-03-03 13:00:00 | AAPL | Stock | 34.865 | 34.9575 | 34.825 | 34.8975 | 5813048.0 |
| 2017-03-03 13:30:00 | AAPL | Stock | 34.8975 | 34.925 | 34.8625 | 34.92 | 2654124.0 |
| 2017-03-03 14:00:00 | AAPL | Stock | 34.9175 | 34.9575 | 34.865 | 34.8675 | 4019824.0 |
| 2017-03-03 14:30:00 | AAPL | Stock | 34.8695 | 34.915 | 34.8675 | 34.9038 | 2374056.0 |
| 2017-03-03 15:00:00 | AAPL | Stock | 34.905 | 34.94 | 34.89 | 34.9225 | 3512688.0 |
| 2017-03-03 15:30:00 | AAPL | Stock | 34.9195 | 34.945 | 34.8925 | 34.9425 | 10147944.0 |
| 2017-03-03 16:00:00 | AAPL | Stock | 34.9475 | 34.9475 | 34.855 | 34.8625 | 10616776.0 |
| 2017-03-03 16:30:00 | AAPL | Stock | 34.8625 | 34.8925 | 34.8175 | 34.8775 | 462952.0 |
| 2017-03-03 17:00:00 | AAPL | Stock | 34.8775 | 34.9 | 34.8775 | 34.9 | 11476.0 |
| 2017-03-03 17:30:00 | AAPL | Stock | 34.8925 | 34.92 | 34.8925 | 34.91 | 3804.0 |
| 2017-03-03 18:00:00 | AAPL | Stock | 34.895 | 34.895 | 34.8925 | 34.8925 | 9576.0 |
| 2017-03-03 18:30:00 | AAPL | Stock | 34.92 | 34.9225 | 34.91 | 34.9225 | 9620.0 |
| 2017-03-03 19:00:00 | AAPL | Stock | 34.91 | 34.91 | 34.91 | 34.91 | 640.0 |
| 2017-03-03 19:30:00 | AAPL | Stock | 34.92 | 34.9225 | 34.91 | 34.92 | 35688.0 |
| 2017-03-03 07:30:00 | MSFT | Stock | 64.0 | 64.0 | 63.9 | 63.9 | 200.0 |
| 2017-03-03 08:00:00 | MSFT | Stock | 63.88 | 64.0 | 63.88 | 64.0 | 248.0 |
| 2017-03-03 08:30:00 | MSFT | Stock | 63.99 | 63.99 | 63.9 | 63.9 | 255.0 |
| 2017-03-03 09:00:00 | MSFT | Stock | 63.9 | 63.9 | 63.9 | 63.9 | 300.0 |
| 2017-03-03 09:30:00 | MSFT | Stock | 63.99 | 64.15 | 63.87 | 63.955 | 2048317.0 |
| 2017-03-03 10:00:00 | MSFT | Stock | 63.96 | 63.99 | 63.62 | 63.75 | 1692617.0 |
| 2017-03-03 10:30:00 | MSFT | Stock | 63.76 | 63.895 | 63.71 | 63.835 | 1120215.0 |
| 2017-03-03 11:00:00 | MSFT | Stock | 63.83 | 63.91 | 63.75 | 63.8 | 964779.0 |
| 2017-03-03 11:30:00 | MSFT | Stock | 63.8 | 63.93 | 63.79 | 63.92 | 686844.0 |
| 2017-03-03 12:00:00 | MSFT | Stock | 63.915 | 64.0 | 63.9 | 63.995 | 583331.0 |
| 2017-03-03 12:30:00 | MSFT | Stock | 63.99 | 64.08 | 63.99 | 64.04 | 737670.0 |
| 2017-03-03 13:00:00 | MSFT | Stock | 64.03 | 64.12 | 63.93 | 64.005 | 775034.0 |
| 2017-03-03 13:30:00 | MSFT | Stock | 64.0 | 64.1 | 63.98 | 64.09 | 546925.0 |
| 2017-03-03 14:00:00 | MSFT | Stock | 64.085 | 64.18 | 64.08 | 64.115 | 836285.0 |
| 2017-03-03 14:30:00 | MSFT | Stock | 64.11 | 64.25 | 64.11 | 64.227 | 730992.0 |
| 2017-03-03 15:00:00 | MSFT | Stock | 64.23 | 64.265 | 64.15 | 64.26 | 889703.0 |
| 2017-03-03 15:30:00 | MSFT | Stock | 64.26 | 64.28 | 64.11 | 64.23 | 3242508.0 |
| 2017-03-03 16:00:00 | MSFT | Stock | 64.22 | 64.25 | 64.16 | 64.25 | 2277528.0 |
| 2017-03-03 16:30:00 | MSFT | Stock | 64.26 | 64.26 | 64.26 | 64.26 | 1900.0 |
| 2017-03-03 17:00:00 | MSFT | Stock | 64.16 | 64.16 | 64.16 | 64.16 | 193.0 |
| 2017-03-03 18:30:00 | MSFT | Stock | 64.17 | 64.17 | 64.17 | 64.17 | 115.0 |
> showing 50 of 80,291 rows — these rows as CSV