PREVIEW / stock_5min / 2017-11-10
file: by_date/stock_5min/2017/2017-11-10.parquet size: 5.5 MB rows: 352,948 symbols: 2,942
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-11-10 04:10:00 | AAPL | Stock | 43.855 | 43.855 | 43.825 | 43.825 | 2788.0 |
| 2017-11-10 04:15:00 | AAPL | Stock | 43.825 | 43.855 | 43.825 | 43.855 | 2400.0 |
| 2017-11-10 04:20:00 | AAPL | Stock | 43.7875 | 43.7975 | 43.75 | 43.75 | 13980.0 |
| 2017-11-10 04:25:00 | AAPL | Stock | 43.75 | 43.75 | 43.66 | 43.66 | 13884.0 |
| 2017-11-10 04:30:00 | AAPL | Stock | 43.68 | 43.6825 | 43.67 | 43.6825 | 9824.0 |
| 2017-11-10 04:35:00 | AAPL | Stock | 43.65 | 43.65 | 43.65 | 43.65 | 3716.0 |
| 2017-11-10 04:55:00 | AAPL | Stock | 43.65 | 43.65 | 43.65 | 43.65 | 3976.0 |
| 2017-11-10 05:05:00 | AAPL | Stock | 43.625 | 43.625 | 43.6125 | 43.6125 | 5200.0 |
| 2017-11-10 05:15:00 | AAPL | Stock | 43.6125 | 43.6125 | 43.6125 | 43.6125 | 1600.0 |
| 2017-11-10 05:20:00 | AAPL | Stock | 43.6125 | 43.6125 | 43.6 | 43.6 | 7952.0 |
| 2017-11-10 05:30:00 | AAPL | Stock | 43.6075 | 43.6075 | 43.575 | 43.575 | 11520.0 |
| 2017-11-10 05:45:00 | AAPL | Stock | 43.67 | 43.76 | 43.67 | 43.76 | 13796.0 |
| 2017-11-10 05:50:00 | AAPL | Stock | 43.705 | 43.755 | 43.705 | 43.755 | 7600.0 |
| 2017-11-10 05:55:00 | AAPL | Stock | 43.7475 | 43.7475 | 43.66 | 43.66 | 2020.0 |
| 2017-11-10 06:00:00 | AAPL | Stock | 43.6625 | 43.745 | 43.6625 | 43.745 | 4200.0 |
| 2017-11-10 06:05:00 | AAPL | Stock | 43.72 | 43.72 | 43.72 | 43.72 | 4000.0 |
| 2017-11-10 06:10:00 | AAPL | Stock | 43.7375 | 43.7375 | 43.7375 | 43.7375 | 768.0 |
| 2017-11-10 06:15:00 | AAPL | Stock | 43.7425 | 43.745 | 43.7425 | 43.745 | 3252.0 |
| 2017-11-10 06:20:00 | AAPL | Stock | 43.7125 | 43.7125 | 43.7125 | 43.7125 | 400.0 |
| 2017-11-10 06:25:00 | AAPL | Stock | 43.7125 | 43.7125 | 43.7 | 43.7 | 1200.0 |
| 2017-11-10 06:30:00 | AAPL | Stock | 43.6975 | 43.6975 | 43.6975 | 43.6975 | 400.0 |
| 2017-11-10 06:45:00 | AAPL | Stock | 43.71 | 43.71 | 43.71 | 43.71 | 1200.0 |
| 2017-11-10 06:50:00 | AAPL | Stock | 43.6925 | 43.6925 | 43.6925 | 43.6925 | 800.0 |
| 2017-11-10 07:00:00 | AAPL | Stock | 43.71 | 43.76 | 43.71 | 43.75 | 13712.0 |
| 2017-11-10 07:05:00 | AAPL | Stock | 43.75 | 43.77 | 43.75 | 43.76 | 12024.0 |
| 2017-11-10 07:10:00 | AAPL | Stock | 43.7725 | 43.7725 | 43.7475 | 43.7475 | 24836.0 |
| 2017-11-10 07:15:00 | AAPL | Stock | 43.745 | 43.745 | 43.7425 | 43.7425 | 1228.0 |
| 2017-11-10 07:20:00 | AAPL | Stock | 43.7375 | 43.7375 | 43.7275 | 43.7275 | 4240.0 |
| 2017-11-10 07:25:00 | AAPL | Stock | 43.74 | 43.74 | 43.74 | 43.74 | 400.0 |
| 2017-11-10 07:30:00 | AAPL | Stock | 43.73 | 43.73 | 43.725 | 43.725 | 4400.0 |
| 2017-11-10 07:35:00 | AAPL | Stock | 43.7375 | 43.75 | 43.725 | 43.725 | 38048.0 |
| 2017-11-10 07:40:00 | AAPL | Stock | 43.7375 | 43.775 | 43.7375 | 43.775 | 7600.0 |
| 2017-11-10 07:45:00 | AAPL | Stock | 43.75 | 43.75 | 43.75 | 43.75 | 5600.0 |
| 2017-11-10 07:50:00 | AAPL | Stock | 43.77 | 43.785 | 43.7625 | 43.77 | 10576.0 |
| 2017-11-10 07:55:00 | AAPL | Stock | 43.785 | 43.825 | 43.7775 | 43.8125 | 15144.0 |
| 2017-11-10 08:00:00 | AAPL | Stock | 43.8125 | 43.8225 | 43.7125 | 43.8 | 73924.0 |
| 2017-11-10 08:05:00 | AAPL | Stock | 43.8175 | 43.85 | 43.8125 | 43.8375 | 33648.0 |
| 2017-11-10 08:10:00 | AAPL | Stock | 43.8375 | 43.8575 | 43.815 | 43.8475 | 42552.0 |
| 2017-11-10 08:15:00 | AAPL | Stock | 43.8525 | 43.87 | 43.8375 | 43.85 | 96092.0 |
| 2017-11-10 08:20:00 | AAPL | Stock | 43.8275 | 43.8375 | 43.8125 | 43.825 | 29736.0 |
| 2017-11-10 08:25:00 | AAPL | Stock | 43.8375 | 43.8375 | 43.8225 | 43.8225 | 10000.0 |
| 2017-11-10 08:30:00 | AAPL | Stock | 43.8375 | 43.8375 | 43.8125 | 43.825 | 25052.0 |
| 2017-11-10 08:35:00 | AAPL | Stock | 43.815 | 43.8375 | 43.815 | 43.8175 | 25072.0 |
| 2017-11-10 08:40:00 | AAPL | Stock | 43.82 | 43.8375 | 43.8175 | 43.8175 | 47424.0 |
| 2017-11-10 08:45:00 | AAPL | Stock | 43.815 | 43.825 | 43.805 | 43.825 | 24244.0 |
| 2017-11-10 08:50:00 | AAPL | Stock | 43.835 | 43.8375 | 43.8125 | 43.83 | 24228.0 |
| 2017-11-10 08:55:00 | AAPL | Stock | 43.83 | 43.83 | 43.825 | 43.825 | 20192.0 |
| 2017-11-10 09:00:00 | AAPL | Stock | 43.815 | 43.8625 | 43.815 | 43.8625 | 44040.0 |
| 2017-11-10 09:05:00 | AAPL | Stock | 43.845 | 43.85 | 43.83 | 43.83 | 39076.0 |
| 2017-11-10 09:10:00 | AAPL | Stock | 43.8475 | 43.8475 | 43.8175 | 43.825 | 16648.0 |
> showing 50 of 352,948 rows — these rows as CSV