PREVIEW / stock_5min / 2014-10-02
file: by_date/stock_5min/2014/2014-10-02.parquet size: 5.6 MB rows: 364,682 symbols: 3,578
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 |
|---|---|---|---|---|---|---|---|
| 2014-10-02 04:00:00 | AAPL | Stock | 24.825 | 24.825 | 24.7 | 24.7 | 1900.0 |
| 2014-10-02 04:05:00 | AAPL | Stock | 24.7225 | 24.7225 | 24.7225 | 24.7225 | 400.0 |
| 2014-10-02 04:15:00 | AAPL | Stock | 24.7225 | 24.7225 | 24.7225 | 24.7225 | 1204.0 |
| 2014-10-02 04:30:00 | AAPL | Stock | 24.7275 | 24.7275 | 24.7275 | 24.7275 | 3800.0 |
| 2014-10-02 05:00:00 | AAPL | Stock | 24.7375 | 24.7375 | 24.7375 | 24.7375 | 408.0 |
| 2014-10-02 05:20:00 | AAPL | Stock | 24.75 | 24.7625 | 24.75 | 24.7625 | 1200.0 |
| 2014-10-02 05:35:00 | AAPL | Stock | 24.795 | 24.795 | 24.795 | 24.795 | 2680.0 |
| 2014-10-02 05:50:00 | AAPL | Stock | 24.795 | 24.795 | 24.795 | 24.795 | 4000.0 |
| 2014-10-02 05:55:00 | AAPL | Stock | 24.795 | 24.795 | 24.795 | 24.795 | 3800.0 |
| 2014-10-02 06:15:00 | AAPL | Stock | 24.7925 | 24.7925 | 24.7925 | 24.7925 | 1800.0 |
| 2014-10-02 06:25:00 | AAPL | Stock | 24.7925 | 24.8175 | 24.7925 | 24.8125 | 7600.0 |
| 2014-10-02 06:30:00 | AAPL | Stock | 24.85 | 24.8775 | 24.85 | 24.8775 | 7512.0 |
| 2014-10-02 06:35:00 | AAPL | Stock | 24.8625 | 24.8625 | 24.8625 | 24.8625 | 400.0 |
| 2014-10-02 06:45:00 | AAPL | Stock | 24.8675 | 24.8675 | 24.8675 | 24.8675 | 700.0 |
| 2014-10-02 06:50:00 | AAPL | Stock | 24.85 | 24.85 | 24.85 | 24.85 | 1600.0 |
| 2014-10-02 06:55:00 | AAPL | Stock | 24.8625 | 24.8625 | 24.8625 | 24.8625 | 400.0 |
| 2014-10-02 07:00:00 | AAPL | Stock | 24.85 | 24.85 | 24.845 | 24.845 | 7200.0 |
| 2014-10-02 07:05:00 | AAPL | Stock | 24.845 | 24.845 | 24.845 | 24.845 | 12400.0 |
| 2014-10-02 07:10:00 | AAPL | Stock | 24.84 | 24.8775 | 24.84 | 24.8775 | 15904.0 |
| 2014-10-02 07:15:00 | AAPL | Stock | 24.88 | 24.8875 | 24.8775 | 24.8875 | 19804.0 |
| 2014-10-02 07:20:00 | AAPL | Stock | 24.8825 | 24.925 | 24.8825 | 24.9125 | 26000.0 |
| 2014-10-02 07:25:00 | AAPL | Stock | 24.9175 | 24.92 | 24.9 | 24.9025 | 12520.0 |
| 2014-10-02 07:30:00 | AAPL | Stock | 24.915 | 24.92 | 24.915 | 24.92 | 13200.0 |
| 2014-10-02 07:35:00 | AAPL | Stock | 24.92 | 24.925 | 24.92 | 24.925 | 4700.0 |
| 2014-10-02 07:40:00 | AAPL | Stock | 24.925 | 24.925 | 24.8925 | 24.8925 | 54084.0 |
| 2014-10-02 07:45:00 | AAPL | Stock | 24.9 | 24.91 | 24.9 | 24.9025 | 7244.0 |
| 2014-10-02 07:50:00 | AAPL | Stock | 24.9 | 24.9025 | 24.9 | 24.9025 | 2400.0 |
| 2014-10-02 07:55:00 | AAPL | Stock | 24.9025 | 24.9075 | 24.9 | 24.9 | 8800.0 |
| 2014-10-02 08:00:00 | AAPL | Stock | 24.8975 | 24.925 | 24.8425 | 24.9225 | 170828.0 |
| 2014-10-02 08:05:00 | AAPL | Stock | 24.925 | 24.9425 | 24.92 | 24.9275 | 192156.0 |
| 2014-10-02 08:10:00 | AAPL | Stock | 24.925 | 24.9325 | 24.89 | 24.89 | 54016.0 |
| 2014-10-02 08:15:00 | AAPL | Stock | 24.9025 | 24.92 | 24.9025 | 24.92 | 29428.0 |
| 2014-10-02 08:20:00 | AAPL | Stock | 24.92 | 24.9225 | 24.9075 | 24.9075 | 25196.0 |
| 2014-10-02 08:25:00 | AAPL | Stock | 24.9125 | 24.93 | 24.9125 | 24.93 | 34336.0 |
| 2014-10-02 08:30:00 | AAPL | Stock | 24.925 | 24.9275 | 24.9225 | 24.925 | 6928.0 |
| 2014-10-02 08:35:00 | AAPL | Stock | 24.9125 | 24.93 | 24.9125 | 24.9225 | 21004.0 |
| 2014-10-02 08:40:00 | AAPL | Stock | 24.9225 | 24.9375 | 24.88 | 24.8875 | 124972.0 |
| 2014-10-02 08:45:00 | AAPL | Stock | 24.8875 | 24.91 | 24.875 | 24.9 | 113032.0 |
| 2014-10-02 08:50:00 | AAPL | Stock | 24.9 | 24.9 | 24.8875 | 24.89 | 17008.0 |
| 2014-10-02 08:55:00 | AAPL | Stock | 24.8825 | 24.9 | 24.875 | 24.8975 | 61492.0 |
| 2014-10-02 09:00:00 | AAPL | Stock | 24.89 | 24.905 | 24.8875 | 24.8875 | 40160.0 |
| 2014-10-02 09:05:00 | AAPL | Stock | 24.8875 | 24.8875 | 24.87 | 24.8725 | 45316.0 |
| 2014-10-02 09:10:00 | AAPL | Stock | 24.875 | 24.875 | 24.83 | 24.8375 | 126284.0 |
| 2014-10-02 09:15:00 | AAPL | Stock | 24.8375 | 24.865 | 24.8375 | 24.865 | 52148.0 |
| 2014-10-02 09:20:00 | AAPL | Stock | 24.86 | 24.8625 | 24.85 | 24.855 | 19604.0 |
| 2014-10-02 09:25:00 | AAPL | Stock | 24.8625 | 24.865 | 24.82 | 24.82 | 54840.0 |
| 2014-10-02 09:30:00 | AAPL | Stock | 24.8175 | 24.94 | 24.81 | 24.895 | 5873172.0 |
| 2014-10-02 09:35:00 | AAPL | Stock | 24.895 | 24.925 | 24.8025 | 24.8025 | 4555032.0 |
| 2014-10-02 09:40:00 | AAPL | Stock | 24.8052 | 24.92 | 24.805 | 24.8812 | 3004132.0 |
| 2014-10-02 09:45:00 | AAPL | Stock | 24.8825 | 24.8915 | 24.7725 | 24.8475 | 3952680.0 |
> showing 50 of 364,682 rows — these rows as CSV