PREVIEW / stock_5min / 2016-07-22
file: by_date/stock_5min/2016/2016-07-22.parquet size: 5.2 MB rows: 341,105 symbols: 3,265
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-07-22 04:15:00 | AAPL | Stock | 24.8125 | 24.8125 | 24.8125 | 24.8125 | 5600.0 |
| 2016-07-22 04:25:00 | AAPL | Stock | 24.8125 | 24.8125 | 24.8125 | 24.8125 | 400.0 |
| 2016-07-22 05:30:00 | AAPL | Stock | 24.8575 | 24.86 | 24.8575 | 24.86 | 9740.0 |
| 2016-07-22 06:45:00 | AAPL | Stock | 24.82 | 24.82 | 24.82 | 24.82 | 1200.0 |
| 2016-07-22 06:50:00 | AAPL | Stock | 24.79 | 24.79 | 24.79 | 24.79 | 2716.0 |
| 2016-07-22 07:00:00 | AAPL | Stock | 24.7925 | 24.7925 | 24.7525 | 24.7525 | 9012.0 |
| 2016-07-22 07:05:00 | AAPL | Stock | 24.7925 | 24.795 | 24.7925 | 24.7925 | 3704.0 |
| 2016-07-22 07:15:00 | AAPL | Stock | 24.775 | 24.7925 | 24.7725 | 24.7925 | 5600.0 |
| 2016-07-22 07:20:00 | AAPL | Stock | 24.7925 | 24.7925 | 24.7675 | 24.775 | 8400.0 |
| 2016-07-22 07:25:00 | AAPL | Stock | 24.765 | 24.765 | 24.7475 | 24.7475 | 17556.0 |
| 2016-07-22 07:30:00 | AAPL | Stock | 24.7625 | 24.7625 | 24.75 | 24.75 | 4400.0 |
| 2016-07-22 07:35:00 | AAPL | Stock | 24.7475 | 24.75 | 24.7475 | 24.75 | 3536.0 |
| 2016-07-22 07:45:00 | AAPL | Stock | 24.7525 | 24.7525 | 24.7475 | 24.7475 | 880.0 |
| 2016-07-22 07:50:00 | AAPL | Stock | 24.755 | 24.755 | 24.755 | 24.755 | 2400.0 |
| 2016-07-22 07:55:00 | AAPL | Stock | 24.755 | 24.76 | 24.755 | 24.76 | 3600.0 |
| 2016-07-22 08:00:00 | AAPL | Stock | 24.7725 | 24.7725 | 24.7375 | 24.75 | 110620.0 |
| 2016-07-22 08:05:00 | AAPL | Stock | 24.75 | 24.7675 | 24.75 | 24.755 | 67412.0 |
| 2016-07-22 08:15:00 | AAPL | Stock | 24.755 | 24.7625 | 24.755 | 24.7625 | 8400.0 |
| 2016-07-22 08:20:00 | AAPL | Stock | 24.7625 | 24.7625 | 24.76 | 24.76 | 3000.0 |
| 2016-07-22 08:25:00 | AAPL | Stock | 24.77 | 24.77 | 24.77 | 24.77 | 760.0 |
| 2016-07-22 08:35:00 | AAPL | Stock | 24.76 | 24.765 | 24.76 | 24.7625 | 13260.0 |
| 2016-07-22 08:40:00 | AAPL | Stock | 24.7625 | 24.77 | 24.7625 | 24.77 | 16000.0 |
| 2016-07-22 08:45:00 | AAPL | Stock | 24.7625 | 24.7625 | 24.7575 | 24.7625 | 10580.0 |
| 2016-07-22 08:50:00 | AAPL | Stock | 24.76 | 24.76 | 24.7475 | 24.75 | 25776.0 |
| 2016-07-22 08:55:00 | AAPL | Stock | 24.75 | 24.7625 | 24.75 | 24.76 | 14860.0 |
| 2016-07-22 09:00:00 | AAPL | Stock | 24.76 | 24.7625 | 24.75 | 24.7625 | 17744.0 |
| 2016-07-22 09:05:00 | AAPL | Stock | 24.7625 | 24.7825 | 24.75 | 24.76 | 80556.0 |
| 2016-07-22 09:10:00 | AAPL | Stock | 24.76 | 24.77 | 24.76 | 24.7675 | 14400.0 |
| 2016-07-22 09:15:00 | AAPL | Stock | 24.7675 | 24.77 | 24.7675 | 24.7675 | 17880.0 |
| 2016-07-22 09:20:00 | AAPL | Stock | 24.7675 | 24.77 | 24.7675 | 24.77 | 5140.0 |
| 2016-07-22 09:25:00 | AAPL | Stock | 24.77 | 24.81 | 24.7625 | 24.81 | 39940.0 |
| 2016-07-22 09:30:00 | AAPL | Stock | 24.815 | 24.825 | 24.645 | 24.6775 | 7426420.0 |
| 2016-07-22 09:35:00 | AAPL | Stock | 24.675 | 24.6875 | 24.595 | 24.5975 | 5834476.0 |
| 2016-07-22 09:40:00 | AAPL | Stock | 24.595 | 24.6225 | 24.5775 | 24.5888 | 3182468.0 |
| 2016-07-22 09:45:00 | AAPL | Stock | 24.59 | 24.6525 | 24.59 | 24.635 | 3993612.0 |
| 2016-07-22 09:50:00 | AAPL | Stock | 24.635 | 24.6688 | 24.6325 | 24.6432 | 1825168.0 |
| 2016-07-22 09:55:00 | AAPL | Stock | 24.6425 | 24.6675 | 24.6288 | 24.665 | 1414596.0 |
| 2016-07-22 10:00:00 | AAPL | Stock | 24.665 | 24.7087 | 24.6477 | 24.675 | 2430892.0 |
| 2016-07-22 10:05:00 | AAPL | Stock | 24.6748 | 24.7125 | 24.6675 | 24.7125 | 1359136.0 |
| 2016-07-22 10:10:00 | AAPL | Stock | 24.7112 | 24.72 | 24.7025 | 24.7075 | 1194488.0 |
| 2016-07-22 10:15:00 | AAPL | Stock | 24.7075 | 24.7225 | 24.7025 | 24.7225 | 1104944.0 |
| 2016-07-22 10:20:00 | AAPL | Stock | 24.7212 | 24.7475 | 24.72 | 24.7432 | 1176348.0 |
| 2016-07-22 10:25:00 | AAPL | Stock | 24.7475 | 24.75 | 24.705 | 24.7075 | 1197520.0 |
| 2016-07-22 10:30:00 | AAPL | Stock | 24.7075 | 24.7225 | 24.7025 | 24.7225 | 1212548.0 |
| 2016-07-22 10:35:00 | AAPL | Stock | 24.721 | 24.74 | 24.71 | 24.7125 | 1002264.0 |
| 2016-07-22 10:40:00 | AAPL | Stock | 24.7125 | 24.7275 | 24.7075 | 24.7238 | 880240.0 |
| 2016-07-22 10:45:00 | AAPL | Stock | 24.7225 | 24.7275 | 24.6725 | 24.6762 | 1409836.0 |
| 2016-07-22 10:50:00 | AAPL | Stock | 24.6762 | 24.69 | 24.66 | 24.6825 | 1156172.0 |
| 2016-07-22 10:55:00 | AAPL | Stock | 24.6832 | 24.6925 | 24.655 | 24.662 | 922752.0 |
| 2016-07-22 11:00:00 | AAPL | Stock | 24.6625 | 24.672 | 24.6475 | 24.6525 | 1208748.0 |
> showing 50 of 341,105 rows — these rows as CSV