PREVIEW / stock_5min / 2016-05-23
file: by_date/stock_5min/2016/2016-05-23.parquet size: 5.3 MB rows: 354,246 symbols: 3,290
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 |
|---|---|---|---|---|---|---|---|
| 2016-05-23 04:00:00 | AAPL | Stock | 23.875 | 23.925 | 23.875 | 23.925 | 7892.0 |
| 2016-05-23 04:10:00 | AAPL | Stock | 23.925 | 23.945 | 23.925 | 23.945 | 1996.0 |
| 2016-05-23 04:15:00 | AAPL | Stock | 23.9475 | 23.9475 | 23.9475 | 23.9475 | 960.0 |
| 2016-05-23 04:20:00 | AAPL | Stock | 23.9475 | 23.975 | 23.9475 | 23.975 | 15640.0 |
| 2016-05-23 04:30:00 | AAPL | Stock | 23.9525 | 23.9525 | 23.9425 | 23.9425 | 1900.0 |
| 2016-05-23 05:50:00 | AAPL | Stock | 23.9675 | 23.9675 | 23.915 | 23.915 | 8220.0 |
| 2016-05-23 06:00:00 | AAPL | Stock | 23.8875 | 23.8875 | 23.8875 | 23.8875 | 2680.0 |
| 2016-05-23 06:05:00 | AAPL | Stock | 23.8775 | 23.8775 | 23.855 | 23.8625 | 13376.0 |
| 2016-05-23 06:10:00 | AAPL | Stock | 23.8825 | 23.91 | 23.8825 | 23.91 | 1696.0 |
| 2016-05-23 06:15:00 | AAPL | Stock | 23.885 | 23.885 | 23.885 | 23.885 | 1840.0 |
| 2016-05-23 06:20:00 | AAPL | Stock | 23.9 | 23.9 | 23.8725 | 23.875 | 5476.0 |
| 2016-05-23 06:25:00 | AAPL | Stock | 23.8975 | 23.9125 | 23.8875 | 23.9125 | 12604.0 |
| 2016-05-23 06:30:00 | AAPL | Stock | 23.89 | 23.89 | 23.89 | 23.89 | 800.0 |
| 2016-05-23 06:35:00 | AAPL | Stock | 23.8875 | 23.9 | 23.875 | 23.875 | 2000.0 |
| 2016-05-23 06:40:00 | AAPL | Stock | 23.89 | 23.91 | 23.89 | 23.91 | 2000.0 |
| 2016-05-23 06:45:00 | AAPL | Stock | 23.9025 | 23.9025 | 23.8925 | 23.8925 | 3100.0 |
| 2016-05-23 06:50:00 | AAPL | Stock | 23.8925 | 23.8925 | 23.8925 | 23.8925 | 5600.0 |
| 2016-05-23 06:55:00 | AAPL | Stock | 23.8925 | 23.8925 | 23.89 | 23.8925 | 6364.0 |
| 2016-05-23 07:00:00 | AAPL | Stock | 23.88 | 23.97 | 23.8775 | 23.9375 | 44484.0 |
| 2016-05-23 07:05:00 | AAPL | Stock | 23.9625 | 23.9625 | 23.9075 | 23.9075 | 60160.0 |
| 2016-05-23 07:10:00 | AAPL | Stock | 23.9075 | 23.93 | 23.9075 | 23.925 | 4800.0 |
| 2016-05-23 07:20:00 | AAPL | Stock | 23.9225 | 23.95 | 23.9225 | 23.95 | 19560.0 |
| 2016-05-23 07:25:00 | AAPL | Stock | 23.95 | 23.98 | 23.95 | 23.975 | 22448.0 |
| 2016-05-23 07:30:00 | AAPL | Stock | 23.975 | 23.995 | 23.975 | 23.9775 | 13120.0 |
| 2016-05-23 07:35:00 | AAPL | Stock | 23.975 | 23.975 | 23.9625 | 23.9625 | 101204.0 |
| 2016-05-23 07:40:00 | AAPL | Stock | 23.9625 | 23.975 | 23.9575 | 23.975 | 18916.0 |
| 2016-05-23 07:45:00 | AAPL | Stock | 23.975 | 24.025 | 23.965 | 24.025 | 96184.0 |
| 2016-05-23 07:50:00 | AAPL | Stock | 24.025 | 24.0275 | 24.0 | 24.025 | 24448.0 |
| 2016-05-23 07:55:00 | AAPL | Stock | 24.025 | 24.0475 | 24.0175 | 24.0175 | 25240.0 |
| 2016-05-23 08:00:00 | AAPL | Stock | 24.0175 | 24.025 | 23.8875 | 23.9975 | 165456.0 |
| 2016-05-23 08:05:00 | AAPL | Stock | 23.9975 | 24.0 | 23.975 | 23.975 | 57004.0 |
| 2016-05-23 08:10:00 | AAPL | Stock | 23.9875 | 23.9875 | 23.9725 | 23.975 | 11952.0 |
| 2016-05-23 08:15:00 | AAPL | Stock | 23.975 | 23.985 | 23.95 | 23.97 | 38748.0 |
| 2016-05-23 08:20:00 | AAPL | Stock | 23.9625 | 23.985 | 23.9625 | 23.9625 | 28900.0 |
| 2016-05-23 08:25:00 | AAPL | Stock | 23.965 | 23.965 | 23.955 | 23.9625 | 25960.0 |
| 2016-05-23 08:30:00 | AAPL | Stock | 23.965 | 23.975 | 23.9625 | 23.975 | 26400.0 |
| 2016-05-23 08:35:00 | AAPL | Stock | 23.9675 | 23.975 | 23.9675 | 23.975 | 79764.0 |
| 2016-05-23 08:40:00 | AAPL | Stock | 23.975 | 23.975 | 23.9575 | 23.9575 | 21024.0 |
| 2016-05-23 08:45:00 | AAPL | Stock | 23.95 | 23.95 | 23.9425 | 23.95 | 35532.0 |
| 2016-05-23 08:50:00 | AAPL | Stock | 23.95 | 23.95 | 23.925 | 23.94 | 27100.0 |
| 2016-05-23 08:55:00 | AAPL | Stock | 23.9275 | 23.95 | 23.9275 | 23.95 | 56712.0 |
| 2016-05-23 09:00:00 | AAPL | Stock | 23.95 | 23.95 | 23.9375 | 23.9375 | 34400.0 |
| 2016-05-23 09:05:00 | AAPL | Stock | 23.94 | 23.9475 | 23.925 | 23.9375 | 31224.0 |
| 2016-05-23 09:10:00 | AAPL | Stock | 23.95 | 23.9625 | 23.9375 | 23.95 | 96820.0 |
| 2016-05-23 09:15:00 | AAPL | Stock | 23.95 | 23.9875 | 23.95 | 23.9875 | 108836.0 |
| 2016-05-23 09:20:00 | AAPL | Stock | 23.9875 | 24.0 | 23.98 | 23.985 | 118836.0 |
| 2016-05-23 09:25:00 | AAPL | Stock | 23.99 | 23.9975 | 23.95 | 23.975 | 105424.0 |
| 2016-05-23 09:30:00 | AAPL | Stock | 23.9675 | 24.0768 | 23.9175 | 24.031 | 8918208.0 |
| 2016-05-23 09:35:00 | AAPL | Stock | 24.03 | 24.1675 | 24.03 | 24.165 | 5548168.0 |
| 2016-05-23 09:40:00 | AAPL | Stock | 24.165 | 24.225 | 24.1475 | 24.1812 | 5180888.0 |
> showing 50 of 354,246 rows — these rows as CSV