PREVIEW / stock_5min / 2015-11-20
file: by_date/stock_5min/2015/2015-11-20.parquet size: 5.4 MB rows: 356,456 symbols: 3,409
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 |
|---|---|---|---|---|---|---|---|
| 2015-11-20 04:15:00 | AAPL | Stock | 29.7 | 29.7 | 29.7 | 29.7 | 1444.0 |
| 2015-11-20 04:45:00 | AAPL | Stock | 29.7175 | 29.7175 | 29.7175 | 29.7175 | 628.0 |
| 2015-11-20 05:00:00 | AAPL | Stock | 29.7 | 29.7 | 29.6975 | 29.6975 | 800.0 |
| 2015-11-20 05:25:00 | AAPL | Stock | 29.7 | 29.7 | 29.7 | 29.7 | 2000.0 |
| 2015-11-20 06:00:00 | AAPL | Stock | 29.755 | 29.77 | 29.755 | 29.77 | 3720.0 |
| 2015-11-20 06:10:00 | AAPL | Stock | 29.7525 | 29.7525 | 29.7525 | 29.7525 | 2200.0 |
| 2015-11-20 06:50:00 | AAPL | Stock | 29.7525 | 29.7525 | 29.7525 | 29.7525 | 1200.0 |
| 2015-11-20 07:00:00 | AAPL | Stock | 29.725 | 29.725 | 29.725 | 29.725 | 2000.0 |
| 2015-11-20 07:15:00 | AAPL | Stock | 29.7 | 29.7 | 29.7 | 29.7 | 1200.0 |
| 2015-11-20 07:20:00 | AAPL | Stock | 29.705 | 29.725 | 29.705 | 29.7125 | 20160.0 |
| 2015-11-20 07:25:00 | AAPL | Stock | 29.7 | 29.7 | 29.6675 | 29.6675 | 3548.0 |
| 2015-11-20 07:30:00 | AAPL | Stock | 29.7 | 29.725 | 29.7 | 29.7225 | 16556.0 |
| 2015-11-20 07:35:00 | AAPL | Stock | 29.7275 | 29.73 | 29.7275 | 29.73 | 7640.0 |
| 2015-11-20 07:40:00 | AAPL | Stock | 29.725 | 29.725 | 29.725 | 29.725 | 2800.0 |
| 2015-11-20 07:45:00 | AAPL | Stock | 29.73 | 29.73 | 29.73 | 29.73 | 400.0 |
| 2015-11-20 07:55:00 | AAPL | Stock | 29.7125 | 29.725 | 29.7125 | 29.725 | 1200.0 |
| 2015-11-20 08:00:00 | AAPL | Stock | 29.725 | 29.73 | 29.6675 | 29.6675 | 77728.0 |
| 2015-11-20 08:05:00 | AAPL | Stock | 29.665 | 29.7125 | 29.665 | 29.7125 | 23544.0 |
| 2015-11-20 08:10:00 | AAPL | Stock | 29.7 | 29.7 | 29.6825 | 29.685 | 9200.0 |
| 2015-11-20 08:15:00 | AAPL | Stock | 29.6875 | 29.695 | 29.675 | 29.685 | 48360.0 |
| 2015-11-20 08:20:00 | AAPL | Stock | 29.685 | 29.71 | 29.6825 | 29.6825 | 20260.0 |
| 2015-11-20 08:25:00 | AAPL | Stock | 29.6925 | 29.705 | 29.6925 | 29.695 | 17616.0 |
| 2015-11-20 08:30:00 | AAPL | Stock | 29.695 | 29.72 | 29.695 | 29.7125 | 28304.0 |
| 2015-11-20 08:35:00 | AAPL | Stock | 29.7125 | 29.72 | 29.7125 | 29.72 | 14712.0 |
| 2015-11-20 08:40:00 | AAPL | Stock | 29.7175 | 29.755 | 29.715 | 29.7375 | 43284.0 |
| 2015-11-20 08:45:00 | AAPL | Stock | 29.7375 | 29.765 | 29.7375 | 29.765 | 20800.0 |
| 2015-11-20 08:50:00 | AAPL | Stock | 29.7675 | 29.78 | 29.765 | 29.775 | 18888.0 |
| 2015-11-20 08:55:00 | AAPL | Stock | 29.7825 | 29.7875 | 29.755 | 29.7675 | 43320.0 |
| 2015-11-20 09:00:00 | AAPL | Stock | 29.765 | 29.7675 | 29.7325 | 29.745 | 77396.0 |
| 2015-11-20 09:05:00 | AAPL | Stock | 29.74 | 29.7525 | 29.74 | 29.7525 | 10732.0 |
| 2015-11-20 09:10:00 | AAPL | Stock | 29.76 | 29.775 | 29.75 | 29.75 | 43044.0 |
| 2015-11-20 09:15:00 | AAPL | Stock | 29.76 | 29.76 | 29.74 | 29.7575 | 22852.0 |
| 2015-11-20 09:20:00 | AAPL | Stock | 29.75 | 29.7775 | 29.75 | 29.7675 | 26472.0 |
| 2015-11-20 09:25:00 | AAPL | Stock | 29.775 | 29.835 | 29.7175 | 29.835 | 1347768.0 |
| 2015-11-20 09:30:00 | AAPL | Stock | 29.8 | 29.835 | 29.7125 | 29.8128 | 11492336.0 |
| 2015-11-20 09:35:00 | AAPL | Stock | 29.8138 | 29.865 | 29.78 | 29.785 | 3251672.0 |
| 2015-11-20 09:40:00 | AAPL | Stock | 29.7875 | 29.8875 | 29.7475 | 29.88 | 3463588.0 |
| 2015-11-20 09:45:00 | AAPL | Stock | 29.8825 | 29.895 | 29.7925 | 29.8525 | 3485400.0 |
| 2015-11-20 09:50:00 | AAPL | Stock | 29.8552 | 29.92 | 29.855 | 29.8662 | 2567164.0 |
| 2015-11-20 09:55:00 | AAPL | Stock | 29.8662 | 29.91 | 29.84 | 29.905 | 1810584.0 |
| 2015-11-20 10:00:00 | AAPL | Stock | 29.9025 | 29.92 | 29.8875 | 29.9062 | 1895196.0 |
| 2015-11-20 10:05:00 | AAPL | Stock | 29.9075 | 29.9175 | 29.855 | 29.8938 | 2076060.0 |
| 2015-11-20 10:10:00 | AAPL | Stock | 29.895 | 29.9475 | 29.8775 | 29.9462 | 2198344.0 |
| 2015-11-20 10:15:00 | AAPL | Stock | 29.9475 | 29.9675 | 29.925 | 29.95 | 2323708.0 |
| 2015-11-20 10:20:00 | AAPL | Stock | 29.9525 | 29.975 | 29.9425 | 29.9475 | 1863988.0 |
| 2015-11-20 10:25:00 | AAPL | Stock | 29.9475 | 29.98 | 29.94 | 29.97 | 1684652.0 |
| 2015-11-20 10:30:00 | AAPL | Stock | 29.97 | 29.975 | 29.92 | 29.9215 | 1544780.0 |
| 2015-11-20 10:35:00 | AAPL | Stock | 29.9225 | 29.9275 | 29.875 | 29.9 | 1735900.0 |
| 2015-11-20 10:40:00 | AAPL | Stock | 29.8975 | 29.9 | 29.87 | 29.88 | 1529528.0 |
| 2015-11-20 10:45:00 | AAPL | Stock | 29.8815 | 29.9125 | 29.875 | 29.9025 | 1144160.0 |
> showing 50 of 356,456 rows — these rows as CSV