PREVIEW / stock_5min / 2017-12-19
file: by_date/stock_5min/2017/2017-12-19.parquet size: 5.7 MB rows: 370,309 symbols: 2,950
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 |
|---|---|---|---|---|---|---|---|
| 2017-12-19 04:00:00 | AAPL | Stock | 43.845 | 43.845 | 43.625 | 43.665 | 21168.0 |
| 2017-12-19 04:05:00 | AAPL | Stock | 43.6525 | 43.675 | 43.625 | 43.625 | 5096.0 |
| 2017-12-19 04:10:00 | AAPL | Stock | 43.59 | 43.7125 | 43.59 | 43.7125 | 3596.0 |
| 2017-12-19 04:15:00 | AAPL | Stock | 43.7075 | 43.7075 | 43.7075 | 43.7075 | 400.0 |
| 2017-12-19 05:00:00 | AAPL | Stock | 43.6975 | 43.7075 | 43.6975 | 43.7075 | 1468.0 |
| 2017-12-19 05:05:00 | AAPL | Stock | 43.7125 | 43.7125 | 43.7125 | 43.7125 | 1376.0 |
| 2017-12-19 05:10:00 | AAPL | Stock | 43.7125 | 43.7125 | 43.7125 | 43.7125 | 3200.0 |
| 2017-12-19 05:15:00 | AAPL | Stock | 43.7125 | 43.7125 | 43.7125 | 43.7125 | 20000.0 |
| 2017-12-19 05:45:00 | AAPL | Stock | 43.675 | 43.675 | 43.6625 | 43.6625 | 4000.0 |
| 2017-12-19 06:00:00 | AAPL | Stock | 43.69 | 43.74 | 43.69 | 43.6975 | 10588.0 |
| 2017-12-19 06:05:00 | AAPL | Stock | 43.7425 | 43.7475 | 43.665 | 43.665 | 16520.0 |
| 2017-12-19 06:10:00 | AAPL | Stock | 43.6875 | 43.6875 | 43.675 | 43.6875 | 1600.0 |
| 2017-12-19 06:15:00 | AAPL | Stock | 43.6875 | 43.695 | 43.655 | 43.695 | 10000.0 |
| 2017-12-19 06:20:00 | AAPL | Stock | 43.6825 | 43.6825 | 43.6825 | 43.6825 | 1400.0 |
| 2017-12-19 06:25:00 | AAPL | Stock | 43.6725 | 43.6725 | 43.645 | 43.645 | 5200.0 |
| 2017-12-19 06:30:00 | AAPL | Stock | 43.625 | 43.625 | 43.5775 | 43.6 | 22892.0 |
| 2017-12-19 06:35:00 | AAPL | Stock | 43.5725 | 43.6 | 43.57 | 43.6 | 17360.0 |
| 2017-12-19 06:45:00 | AAPL | Stock | 43.63 | 43.6475 | 43.63 | 43.6475 | 9540.0 |
| 2017-12-19 06:50:00 | AAPL | Stock | 43.645 | 43.645 | 43.645 | 43.645 | 1200.0 |
| 2017-12-19 06:55:00 | AAPL | Stock | 43.645 | 43.66 | 43.64 | 43.66 | 14000.0 |
| 2017-12-19 07:00:00 | AAPL | Stock | 43.66 | 43.7775 | 43.65 | 43.675 | 140256.0 |
| 2017-12-19 07:05:00 | AAPL | Stock | 43.6775 | 43.745 | 43.6775 | 43.745 | 17148.0 |
| 2017-12-19 07:10:00 | AAPL | Stock | 43.7475 | 43.7475 | 43.7175 | 43.7375 | 25100.0 |
| 2017-12-19 07:15:00 | AAPL | Stock | 43.7475 | 43.7825 | 43.73 | 43.75 | 51212.0 |
| 2017-12-19 07:20:00 | AAPL | Stock | 43.73 | 43.75 | 43.73 | 43.7375 | 7812.0 |
| 2017-12-19 07:25:00 | AAPL | Stock | 43.7275 | 43.75 | 43.7225 | 43.75 | 8220.0 |
| 2017-12-19 07:30:00 | AAPL | Stock | 43.7625 | 43.775 | 43.75 | 43.7625 | 6800.0 |
| 2017-12-19 07:35:00 | AAPL | Stock | 43.7625 | 43.775 | 43.7175 | 43.7175 | 39084.0 |
| 2017-12-19 07:40:00 | AAPL | Stock | 43.7175 | 43.735 | 43.7 | 43.725 | 15212.0 |
| 2017-12-19 07:45:00 | AAPL | Stock | 43.73 | 43.775 | 43.725 | 43.775 | 26568.0 |
| 2017-12-19 07:50:00 | AAPL | Stock | 43.7725 | 43.785 | 43.7275 | 43.75 | 17260.0 |
| 2017-12-19 07:55:00 | AAPL | Stock | 43.75 | 43.75 | 43.7275 | 43.745 | 16564.0 |
| 2017-12-19 08:00:00 | AAPL | Stock | 43.745 | 43.7875 | 43.65 | 43.7125 | 145840.0 |
| 2017-12-19 08:05:00 | AAPL | Stock | 43.7225 | 43.77 | 43.7125 | 43.7625 | 23248.0 |
| 2017-12-19 08:10:00 | AAPL | Stock | 43.76 | 43.7625 | 43.7375 | 43.7575 | 16736.0 |
| 2017-12-19 08:15:00 | AAPL | Stock | 43.7425 | 43.795 | 43.7425 | 43.78 | 77756.0 |
| 2017-12-19 08:20:00 | AAPL | Stock | 43.7525 | 43.765 | 43.7275 | 43.7325 | 55120.0 |
| 2017-12-19 08:25:00 | AAPL | Stock | 43.725 | 43.73 | 43.705 | 43.725 | 87492.0 |
| 2017-12-19 08:30:00 | AAPL | Stock | 43.7375 | 43.7475 | 43.72 | 43.7225 | 28296.0 |
| 2017-12-19 08:35:00 | AAPL | Stock | 43.7175 | 43.735 | 43.6875 | 43.6875 | 94532.0 |
| 2017-12-19 08:40:00 | AAPL | Stock | 43.6875 | 43.715 | 43.675 | 43.7075 | 41316.0 |
| 2017-12-19 08:45:00 | AAPL | Stock | 43.715 | 43.735 | 43.715 | 43.735 | 20200.0 |
| 2017-12-19 08:50:00 | AAPL | Stock | 43.7375 | 43.75 | 43.7 | 43.7325 | 91400.0 |
| 2017-12-19 08:55:00 | AAPL | Stock | 43.715 | 43.7375 | 43.7 | 43.7 | 98380.0 |
| 2017-12-19 09:00:00 | AAPL | Stock | 43.69 | 43.7175 | 43.6875 | 43.69 | 98236.0 |
| 2017-12-19 09:05:00 | AAPL | Stock | 43.69 | 43.695 | 43.665 | 43.665 | 62188.0 |
| 2017-12-19 09:10:00 | AAPL | Stock | 43.6675 | 43.6875 | 43.615 | 43.6625 | 116044.0 |
| 2017-12-19 09:15:00 | AAPL | Stock | 43.6725 | 43.6875 | 43.65 | 43.65 | 107608.0 |
| 2017-12-19 09:20:00 | AAPL | Stock | 43.65 | 43.6525 | 43.625 | 43.65 | 101988.0 |
| 2017-12-19 09:25:00 | AAPL | Stock | 43.63 | 43.685 | 43.5875 | 43.6625 | 172240.0 |
> showing 50 of 370,309 rows — these rows as CSV