PREVIEW / stock_5min / 2014-08-05
file: by_date/stock_5min/2014/2014-08-05.parquet size: 5.4 MB rows: 364,425 symbols: 3,586
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-08-05 05:10:00 | AAPL | Stock | 23.9325 | 23.9325 | 23.9325 | 23.9325 | 2000.0 |
| 2014-08-05 05:20:00 | AAPL | Stock | 23.9275 | 23.9275 | 23.9275 | 23.9275 | 1000.0 |
| 2014-08-05 05:30:00 | AAPL | Stock | 23.925 | 23.925 | 23.925 | 23.925 | 2000.0 |
| 2014-08-05 06:00:00 | AAPL | Stock | 23.9175 | 23.9175 | 23.9175 | 23.9175 | 800.0 |
| 2014-08-05 06:15:00 | AAPL | Stock | 23.9225 | 23.9225 | 23.9175 | 23.9175 | 6056.0 |
| 2014-08-05 06:55:00 | AAPL | Stock | 23.875 | 23.875 | 23.875 | 23.875 | 1920.0 |
| 2014-08-05 07:00:00 | AAPL | Stock | 23.9175 | 23.9175 | 23.9175 | 23.9175 | 2000.0 |
| 2014-08-05 07:05:00 | AAPL | Stock | 23.9175 | 23.9175 | 23.9 | 23.9 | 2784.0 |
| 2014-08-05 07:10:00 | AAPL | Stock | 23.9 | 23.9 | 23.875 | 23.9 | 12896.0 |
| 2014-08-05 07:15:00 | AAPL | Stock | 23.875 | 23.875 | 23.865 | 23.865 | 5776.0 |
| 2014-08-05 07:20:00 | AAPL | Stock | 23.875 | 23.8925 | 23.875 | 23.8925 | 4224.0 |
| 2014-08-05 07:25:00 | AAPL | Stock | 23.8925 | 23.9 | 23.8925 | 23.9 | 11560.0 |
| 2014-08-05 07:30:00 | AAPL | Stock | 23.895 | 23.895 | 23.875 | 23.875 | 16896.0 |
| 2014-08-05 07:35:00 | AAPL | Stock | 23.8775 | 23.8925 | 23.8775 | 23.8925 | 8000.0 |
| 2014-08-05 07:50:00 | AAPL | Stock | 23.885 | 23.885 | 23.885 | 23.885 | 400.0 |
| 2014-08-05 07:55:00 | AAPL | Stock | 23.8775 | 23.8775 | 23.8775 | 23.8775 | 400.0 |
| 2014-08-05 08:00:00 | AAPL | Stock | 23.8825 | 23.9325 | 23.85 | 23.86 | 169084.0 |
| 2014-08-05 08:05:00 | AAPL | Stock | 23.86 | 23.8725 | 23.86 | 23.8725 | 50284.0 |
| 2014-08-05 08:10:00 | AAPL | Stock | 23.875 | 23.875 | 23.8525 | 23.855 | 27000.0 |
| 2014-08-05 08:15:00 | AAPL | Stock | 23.855 | 23.8625 | 23.85 | 23.8525 | 27600.0 |
| 2014-08-05 08:20:00 | AAPL | Stock | 23.85 | 23.87 | 23.8325 | 23.87 | 79708.0 |
| 2014-08-05 08:25:00 | AAPL | Stock | 23.86 | 23.8775 | 23.85 | 23.8775 | 23500.0 |
| 2014-08-05 08:30:00 | AAPL | Stock | 23.875 | 23.8825 | 23.8525 | 23.875 | 41248.0 |
| 2014-08-05 08:35:00 | AAPL | Stock | 23.875 | 23.875 | 23.8525 | 23.8625 | 23920.0 |
| 2014-08-05 08:40:00 | AAPL | Stock | 23.865 | 23.8825 | 23.865 | 23.8825 | 1096.0 |
| 2014-08-05 08:45:00 | AAPL | Stock | 23.875 | 23.8875 | 23.8625 | 23.865 | 46600.0 |
| 2014-08-05 08:50:00 | AAPL | Stock | 23.865 | 23.88 | 23.865 | 23.8675 | 38848.0 |
| 2014-08-05 08:55:00 | AAPL | Stock | 23.8675 | 23.8725 | 23.8675 | 23.8675 | 28208.0 |
| 2014-08-05 09:00:00 | AAPL | Stock | 23.8775 | 23.8825 | 23.875 | 23.8825 | 13400.0 |
| 2014-08-05 09:05:00 | AAPL | Stock | 23.8825 | 23.8825 | 23.875 | 23.875 | 7176.0 |
| 2014-08-05 09:10:00 | AAPL | Stock | 23.8825 | 23.8875 | 23.875 | 23.8775 | 27060.0 |
| 2014-08-05 09:15:00 | AAPL | Stock | 23.8775 | 23.8825 | 23.875 | 23.8825 | 13880.0 |
| 2014-08-05 09:20:00 | AAPL | Stock | 23.885 | 23.8975 | 23.8775 | 23.885 | 45200.0 |
| 2014-08-05 09:25:00 | AAPL | Stock | 23.885 | 23.89 | 23.83 | 23.8475 | 156588.0 |
| 2014-08-05 09:30:00 | AAPL | Stock | 23.845 | 23.8625 | 23.72 | 23.8075 | 7630424.0 |
| 2014-08-05 09:35:00 | AAPL | Stock | 23.8075 | 23.845 | 23.7675 | 23.8225 | 3252592.0 |
| 2014-08-05 09:40:00 | AAPL | Stock | 23.825 | 23.835 | 23.76 | 23.7875 | 3032260.0 |
| 2014-08-05 09:45:00 | AAPL | Stock | 23.785 | 23.79 | 23.715 | 23.7275 | 3152000.0 |
| 2014-08-05 09:50:00 | AAPL | Stock | 23.7275 | 23.7275 | 23.59 | 23.5972 | 7468328.0 |
| 2014-08-05 09:55:00 | AAPL | Stock | 23.595 | 23.6625 | 23.59 | 23.6225 | 4298908.0 |
| 2014-08-05 10:00:00 | AAPL | Stock | 23.6225 | 23.6625 | 23.6025 | 23.6288 | 3721180.0 |
| 2014-08-05 10:05:00 | AAPL | Stock | 23.6288 | 23.6648 | 23.6025 | 23.6475 | 3159072.0 |
| 2014-08-05 10:10:00 | AAPL | Stock | 23.6475 | 23.7125 | 23.63 | 23.6722 | 3183608.0 |
| 2014-08-05 10:15:00 | AAPL | Stock | 23.6725 | 23.7075 | 23.651 | 23.675 | 2003452.0 |
| 2014-08-05 10:20:00 | AAPL | Stock | 23.6775 | 23.7475 | 23.6725 | 23.745 | 2477584.0 |
| 2014-08-05 10:25:00 | AAPL | Stock | 23.745 | 23.745 | 23.6875 | 23.7175 | 1595560.0 |
| 2014-08-05 10:30:00 | AAPL | Stock | 23.7175 | 23.77 | 23.7112 | 23.7675 | 2303220.0 |
| 2014-08-05 10:35:00 | AAPL | Stock | 23.765 | 23.7725 | 23.725 | 23.745 | 2441476.0 |
| 2014-08-05 10:40:00 | AAPL | Stock | 23.7475 | 23.755 | 23.7125 | 23.715 | 1467028.0 |
| 2014-08-05 10:45:00 | AAPL | Stock | 23.715 | 23.7975 | 23.7125 | 23.7875 | 1682648.0 |
> showing 50 of 364,425 rows — these rows as CSV