PREVIEW / stock_5min / 2014-11-13
file: by_date/stock_5min/2014/2014-11-13.parquet size: 5.5 MB rows: 361,150 symbols: 3,538
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-11-13 04:00:00 | AAPL | Stock | 27.875 | 27.9 | 27.875 | 27.9 | 4800.0 |
| 2014-11-13 04:05:00 | AAPL | Stock | 27.9125 | 27.9125 | 27.9075 | 27.9125 | 8400.0 |
| 2014-11-13 04:10:00 | AAPL | Stock | 27.9125 | 27.9125 | 27.9125 | 27.9125 | 2800.0 |
| 2014-11-13 04:20:00 | AAPL | Stock | 27.9125 | 27.9125 | 27.9125 | 27.9125 | 3836.0 |
| 2014-11-13 04:30:00 | AAPL | Stock | 27.9125 | 27.9125 | 27.9125 | 27.9125 | 1200.0 |
| 2014-11-13 04:35:00 | AAPL | Stock | 27.91 | 27.925 | 27.91 | 27.925 | 2236.0 |
| 2014-11-13 05:05:00 | AAPL | Stock | 27.9525 | 27.9525 | 27.9525 | 27.9525 | 400.0 |
| 2014-11-13 05:10:00 | AAPL | Stock | 27.95 | 27.95 | 27.95 | 27.95 | 400.0 |
| 2014-11-13 05:20:00 | AAPL | Stock | 27.9325 | 27.9325 | 27.9325 | 27.9325 | 1200.0 |
| 2014-11-13 05:30:00 | AAPL | Stock | 27.95 | 27.95 | 27.95 | 27.95 | 800.0 |
| 2014-11-13 05:35:00 | AAPL | Stock | 27.945 | 27.945 | 27.945 | 27.945 | 400.0 |
| 2014-11-13 05:40:00 | AAPL | Stock | 27.925 | 27.925 | 27.9125 | 27.9125 | 4032.0 |
| 2014-11-13 05:45:00 | AAPL | Stock | 27.925 | 27.925 | 27.925 | 27.925 | 9160.0 |
| 2014-11-13 05:55:00 | AAPL | Stock | 27.925 | 27.925 | 27.925 | 27.925 | 2400.0 |
| 2014-11-13 06:00:00 | AAPL | Stock | 27.95 | 27.955 | 27.95 | 27.955 | 5000.0 |
| 2014-11-13 06:10:00 | AAPL | Stock | 27.9525 | 27.9825 | 27.9525 | 27.98 | 14440.0 |
| 2014-11-13 06:15:00 | AAPL | Stock | 27.975 | 27.975 | 27.9625 | 27.975 | 7600.0 |
| 2014-11-13 06:20:00 | AAPL | Stock | 27.9425 | 27.95 | 27.9275 | 27.95 | 1600.0 |
| 2014-11-13 06:25:00 | AAPL | Stock | 27.95 | 27.95 | 27.9475 | 27.9475 | 4632.0 |
| 2014-11-13 06:30:00 | AAPL | Stock | 27.945 | 27.945 | 27.9125 | 27.925 | 7056.0 |
| 2014-11-13 06:35:00 | AAPL | Stock | 27.925 | 27.925 | 27.9125 | 27.9125 | 21200.0 |
| 2014-11-13 06:40:00 | AAPL | Stock | 27.9225 | 27.9225 | 27.9225 | 27.9225 | 400.0 |
| 2014-11-13 06:45:00 | AAPL | Stock | 27.925 | 27.925 | 27.925 | 27.925 | 640.0 |
| 2014-11-13 06:50:00 | AAPL | Stock | 27.9075 | 27.9075 | 27.9075 | 27.9075 | 800.0 |
| 2014-11-13 07:00:00 | AAPL | Stock | 27.925 | 27.935 | 27.9225 | 27.9225 | 35104.0 |
| 2014-11-13 07:05:00 | AAPL | Stock | 27.92 | 27.925 | 27.9075 | 27.9075 | 35688.0 |
| 2014-11-13 07:10:00 | AAPL | Stock | 27.925 | 27.9375 | 27.925 | 27.935 | 27648.0 |
| 2014-11-13 07:15:00 | AAPL | Stock | 27.935 | 27.9425 | 27.9225 | 27.9225 | 27600.0 |
| 2014-11-13 07:20:00 | AAPL | Stock | 27.9225 | 27.925 | 27.9175 | 27.9175 | 3628.0 |
| 2014-11-13 07:25:00 | AAPL | Stock | 27.9075 | 27.9175 | 27.9075 | 27.91 | 11752.0 |
| 2014-11-13 07:30:00 | AAPL | Stock | 27.9075 | 27.92 | 27.9075 | 27.92 | 17908.0 |
| 2014-11-13 07:35:00 | AAPL | Stock | 27.9275 | 27.93 | 27.9275 | 27.93 | 7604.0 |
| 2014-11-13 07:40:00 | AAPL | Stock | 27.93 | 27.93 | 27.93 | 27.93 | 1600.0 |
| 2014-11-13 07:45:00 | AAPL | Stock | 27.9275 | 27.9275 | 27.92 | 27.9225 | 9788.0 |
| 2014-11-13 07:50:00 | AAPL | Stock | 27.925 | 27.925 | 27.9175 | 27.9175 | 2200.0 |
| 2014-11-13 07:55:00 | AAPL | Stock | 27.9175 | 27.9225 | 27.9075 | 27.9125 | 36000.0 |
| 2014-11-13 08:00:00 | AAPL | Stock | 27.9075 | 27.9375 | 27.62 | 27.8925 | 284264.0 |
| 2014-11-13 08:05:00 | AAPL | Stock | 27.8925 | 27.8975 | 27.8625 | 27.875 | 64316.0 |
| 2014-11-13 08:10:00 | AAPL | Stock | 27.8725 | 27.875 | 27.865 | 27.8725 | 23640.0 |
| 2014-11-13 08:15:00 | AAPL | Stock | 27.8675 | 27.8725 | 27.8625 | 27.87 | 12480.0 |
| 2014-11-13 08:20:00 | AAPL | Stock | 27.8725 | 27.8775 | 27.865 | 27.8775 | 13632.0 |
| 2014-11-13 08:25:00 | AAPL | Stock | 27.87 | 27.875 | 27.85 | 27.85 | 46960.0 |
| 2014-11-13 08:30:00 | AAPL | Stock | 27.8525 | 27.8625 | 27.8425 | 27.8625 | 40136.0 |
| 2014-11-13 08:35:00 | AAPL | Stock | 27.8625 | 27.8625 | 27.8375 | 27.8475 | 32476.0 |
| 2014-11-13 08:40:00 | AAPL | Stock | 27.8475 | 27.865 | 27.8475 | 27.865 | 24008.0 |
| 2014-11-13 08:45:00 | AAPL | Stock | 27.8675 | 27.8775 | 27.865 | 27.8775 | 30924.0 |
| 2014-11-13 08:50:00 | AAPL | Stock | 27.8775 | 27.89 | 27.8775 | 27.8875 | 46748.0 |
| 2014-11-13 08:55:00 | AAPL | Stock | 27.89 | 27.9075 | 27.8875 | 27.9025 | 112296.0 |
| 2014-11-13 09:00:00 | AAPL | Stock | 27.905 | 27.905 | 27.88 | 27.89 | 122044.0 |
| 2014-11-13 09:05:00 | AAPL | Stock | 27.89 | 27.895 | 27.8875 | 27.8925 | 52116.0 |
> showing 50 of 361,150 rows — these rows as CSV