PREVIEW / stock_5min / 2018-02-28
file: by_date/stock_5min/2018/2018-02-28.parquet size: 5.6 MB rows: 363,869 symbols: 2,880
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 |
|---|---|---|---|---|---|---|---|
| 2018-02-28 04:00:00 | AAPL | Stock | 44.6775 | 44.6775 | 44.665 | 44.665 | 9728.0 |
| 2018-02-28 04:05:00 | AAPL | Stock | 44.6775 | 44.6775 | 44.6625 | 44.6625 | 11752.0 |
| 2018-02-28 04:10:00 | AAPL | Stock | 44.74 | 44.745 | 44.74 | 44.745 | 5960.0 |
| 2018-02-28 04:20:00 | AAPL | Stock | 44.6975 | 44.6975 | 44.6975 | 44.6975 | 5800.0 |
| 2018-02-28 04:25:00 | AAPL | Stock | 44.71 | 44.71 | 44.71 | 44.71 | 13200.0 |
| 2018-02-28 04:40:00 | AAPL | Stock | 44.71 | 44.71 | 44.71 | 44.71 | 800.0 |
| 2018-02-28 04:50:00 | AAPL | Stock | 44.7375 | 44.7375 | 44.7375 | 44.7375 | 800.0 |
| 2018-02-28 05:00:00 | AAPL | Stock | 44.735 | 44.735 | 44.735 | 44.735 | 400.0 |
| 2018-02-28 05:05:00 | AAPL | Stock | 44.735 | 44.735 | 44.705 | 44.705 | 3424.0 |
| 2018-02-28 05:50:00 | AAPL | Stock | 44.6625 | 44.72 | 44.6625 | 44.72 | 1980.0 |
| 2018-02-28 05:55:00 | AAPL | Stock | 44.6425 | 44.6425 | 44.6375 | 44.6375 | 980.0 |
| 2018-02-28 06:05:00 | AAPL | Stock | 44.6275 | 44.6275 | 44.5925 | 44.5925 | 1928.0 |
| 2018-02-28 06:20:00 | AAPL | Stock | 44.695 | 44.695 | 44.695 | 44.695 | 400.0 |
| 2018-02-28 06:40:00 | AAPL | Stock | 44.635 | 44.635 | 44.635 | 44.635 | 1200.0 |
| 2018-02-28 06:45:00 | AAPL | Stock | 44.625 | 44.625 | 44.625 | 44.625 | 880.0 |
| 2018-02-28 07:00:00 | AAPL | Stock | 44.645 | 44.66 | 44.6425 | 44.6425 | 13832.0 |
| 2018-02-28 07:05:00 | AAPL | Stock | 44.65 | 44.665 | 44.6425 | 44.665 | 5600.0 |
| 2018-02-28 07:10:00 | AAPL | Stock | 44.665 | 44.67 | 44.665 | 44.665 | 6472.0 |
| 2018-02-28 07:15:00 | AAPL | Stock | 44.69 | 44.73 | 44.69 | 44.6975 | 16584.0 |
| 2018-02-28 07:20:00 | AAPL | Stock | 44.7 | 44.7 | 44.695 | 44.6975 | 8360.0 |
| 2018-02-28 07:25:00 | AAPL | Stock | 44.65 | 44.6725 | 44.6425 | 44.6425 | 23324.0 |
| 2018-02-28 07:30:00 | AAPL | Stock | 44.6375 | 44.6425 | 44.6375 | 44.6425 | 3768.0 |
| 2018-02-28 07:35:00 | AAPL | Stock | 44.65 | 44.675 | 44.65 | 44.675 | 2400.0 |
| 2018-02-28 07:40:00 | AAPL | Stock | 44.675 | 44.68 | 44.66 | 44.66 | 9196.0 |
| 2018-02-28 07:45:00 | AAPL | Stock | 44.6775 | 44.6875 | 44.6775 | 44.6875 | 6304.0 |
| 2018-02-28 07:50:00 | AAPL | Stock | 44.685 | 44.7 | 44.685 | 44.6875 | 13052.0 |
| 2018-02-28 07:55:00 | AAPL | Stock | 44.7 | 44.7 | 44.7 | 44.7 | 7600.0 |
| 2018-02-28 08:00:00 | AAPL | Stock | 44.7125 | 44.73 | 44.635 | 44.72 | 65260.0 |
| 2018-02-28 08:05:00 | AAPL | Stock | 44.725 | 44.73 | 44.7 | 44.73 | 29540.0 |
| 2018-02-28 08:10:00 | AAPL | Stock | 44.73 | 44.7375 | 44.73 | 44.7375 | 13520.0 |
| 2018-02-28 08:15:00 | AAPL | Stock | 44.7425 | 44.775 | 44.7425 | 44.7575 | 45312.0 |
| 2018-02-28 08:20:00 | AAPL | Stock | 44.76 | 44.7875 | 44.76 | 44.775 | 12304.0 |
| 2018-02-28 08:25:00 | AAPL | Stock | 44.765 | 44.775 | 44.7525 | 44.7675 | 52572.0 |
| 2018-02-28 08:30:00 | AAPL | Stock | 44.7675 | 44.8125 | 44.7675 | 44.8125 | 51716.0 |
| 2018-02-28 08:35:00 | AAPL | Stock | 44.815 | 44.8725 | 44.815 | 44.8375 | 87772.0 |
| 2018-02-28 08:40:00 | AAPL | Stock | 44.825 | 44.825 | 44.7975 | 44.7975 | 33164.0 |
| 2018-02-28 08:45:00 | AAPL | Stock | 44.8 | 44.825 | 44.79 | 44.815 | 24052.0 |
| 2018-02-28 08:50:00 | AAPL | Stock | 44.8125 | 44.825 | 44.805 | 44.8125 | 9396.0 |
| 2018-02-28 08:55:00 | AAPL | Stock | 44.805 | 44.81 | 44.79 | 44.8 | 36728.0 |
| 2018-02-28 09:00:00 | AAPL | Stock | 44.81 | 44.84 | 44.8025 | 44.84 | 36980.0 |
| 2018-02-28 09:05:00 | AAPL | Stock | 44.8375 | 44.845 | 44.835 | 44.8375 | 22680.0 |
| 2018-02-28 09:10:00 | AAPL | Stock | 44.8325 | 44.8625 | 44.83 | 44.8575 | 36600.0 |
| 2018-02-28 09:15:00 | AAPL | Stock | 44.8625 | 44.875 | 44.8375 | 44.845 | 62432.0 |
| 2018-02-28 09:20:00 | AAPL | Stock | 44.855 | 44.8625 | 44.8475 | 44.8475 | 26548.0 |
| 2018-02-28 09:25:00 | AAPL | Stock | 44.845 | 44.85 | 44.78 | 44.8125 | 125680.0 |
| 2018-02-28 09:30:00 | AAPL | Stock | 44.8325 | 44.885 | 44.77 | 44.8075 | 4109740.0 |
| 2018-02-28 09:35:00 | AAPL | Stock | 44.8058 | 44.895 | 44.785 | 44.89 | 2127824.0 |
| 2018-02-28 09:40:00 | AAPL | Stock | 44.8925 | 44.905 | 44.79 | 44.865 | 1659304.0 |
| 2018-02-28 09:45:00 | AAPL | Stock | 44.8625 | 44.935 | 44.82 | 44.9335 | 2147672.0 |
| 2018-02-28 09:50:00 | AAPL | Stock | 44.9325 | 44.95 | 44.8825 | 44.9448 | 1631716.0 |
> showing 50 of 363,869 rows — these rows as CSV