PREVIEW / stock_5min / 2017-08-11
file: by_date/stock_5min/2017/2017-08-11.parquet size: 5.4 MB rows: 360,767 symbols: 2,971
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-08-11 04:10:00 | AAPL | Stock | 38.7375 | 38.75 | 38.7375 | 38.75 | 13500.0 |
| 2017-08-11 04:20:00 | AAPL | Stock | 38.6175 | 38.6175 | 38.6175 | 38.6175 | 404.0 |
| 2017-08-11 04:30:00 | AAPL | Stock | 38.575 | 38.575 | 38.5525 | 38.5525 | 4296.0 |
| 2017-08-11 04:35:00 | AAPL | Stock | 38.6125 | 38.6125 | 38.5825 | 38.5825 | 8628.0 |
| 2017-08-11 04:45:00 | AAPL | Stock | 38.5775 | 38.5775 | 38.5775 | 38.5775 | 500.0 |
| 2017-08-11 04:50:00 | AAPL | Stock | 38.62 | 38.62 | 38.5775 | 38.5775 | 4360.0 |
| 2017-08-11 04:55:00 | AAPL | Stock | 38.5775 | 38.5775 | 38.5775 | 38.5775 | 3760.0 |
| 2017-08-11 05:00:00 | AAPL | Stock | 38.5875 | 38.5875 | 38.5875 | 38.5875 | 2400.0 |
| 2017-08-11 05:10:00 | AAPL | Stock | 38.6175 | 38.6175 | 38.6175 | 38.6175 | 476.0 |
| 2017-08-11 05:20:00 | AAPL | Stock | 38.585 | 38.585 | 38.585 | 38.585 | 1600.0 |
| 2017-08-11 05:25:00 | AAPL | Stock | 38.5775 | 38.5775 | 38.5625 | 38.5625 | 4504.0 |
| 2017-08-11 05:40:00 | AAPL | Stock | 38.6625 | 38.7475 | 38.6525 | 38.7475 | 4904.0 |
| 2017-08-11 05:45:00 | AAPL | Stock | 38.6775 | 38.6775 | 38.6775 | 38.6775 | 1600.0 |
| 2017-08-11 05:50:00 | AAPL | Stock | 38.735 | 38.745 | 38.735 | 38.745 | 7244.0 |
| 2017-08-11 05:55:00 | AAPL | Stock | 38.6875 | 38.6875 | 38.5875 | 38.5875 | 47740.0 |
| 2017-08-11 06:00:00 | AAPL | Stock | 38.6075 | 38.6175 | 38.565 | 38.6175 | 11208.0 |
| 2017-08-11 06:20:00 | AAPL | Stock | 38.65 | 38.675 | 38.65 | 38.675 | 4800.0 |
| 2017-08-11 06:25:00 | AAPL | Stock | 38.73 | 38.7325 | 38.65 | 38.65 | 14684.0 |
| 2017-08-11 06:30:00 | AAPL | Stock | 38.65 | 38.65 | 38.625 | 38.625 | 1784.0 |
| 2017-08-11 06:35:00 | AAPL | Stock | 38.675 | 38.675 | 38.675 | 38.675 | 400.0 |
| 2017-08-11 06:40:00 | AAPL | Stock | 38.6875 | 38.6875 | 38.6875 | 38.6875 | 2000.0 |
| 2017-08-11 06:45:00 | AAPL | Stock | 38.6975 | 38.6975 | 38.6975 | 38.6975 | 400.0 |
| 2017-08-11 06:50:00 | AAPL | Stock | 38.6975 | 38.6975 | 38.675 | 38.675 | 5600.0 |
| 2017-08-11 06:55:00 | AAPL | Stock | 38.685 | 38.685 | 38.685 | 38.685 | 2000.0 |
| 2017-08-11 07:00:00 | AAPL | Stock | 38.675 | 38.675 | 38.6725 | 38.6725 | 4800.0 |
| 2017-08-11 07:05:00 | AAPL | Stock | 38.6725 | 38.6725 | 38.65 | 38.655 | 11200.0 |
| 2017-08-11 07:10:00 | AAPL | Stock | 38.6575 | 38.6625 | 38.635 | 38.6625 | 4068.0 |
| 2017-08-11 07:15:00 | AAPL | Stock | 38.6625 | 38.68 | 38.6625 | 38.68 | 28808.0 |
| 2017-08-11 07:20:00 | AAPL | Stock | 38.68 | 38.6975 | 38.68 | 38.6975 | 1892.0 |
| 2017-08-11 07:25:00 | AAPL | Stock | 38.71 | 38.71 | 38.6875 | 38.6875 | 5600.0 |
| 2017-08-11 07:30:00 | AAPL | Stock | 38.705 | 38.7125 | 38.7025 | 38.7025 | 39784.0 |
| 2017-08-11 07:35:00 | AAPL | Stock | 38.7225 | 38.7225 | 38.7025 | 38.7025 | 6944.0 |
| 2017-08-11 07:40:00 | AAPL | Stock | 38.6975 | 38.6975 | 38.6975 | 38.6975 | 3200.0 |
| 2017-08-11 07:45:00 | AAPL | Stock | 38.6325 | 38.6375 | 38.6325 | 38.6325 | 3400.0 |
| 2017-08-11 07:50:00 | AAPL | Stock | 38.6325 | 38.7125 | 38.625 | 38.7125 | 11684.0 |
| 2017-08-11 07:55:00 | AAPL | Stock | 38.675 | 38.695 | 38.675 | 38.675 | 3600.0 |
| 2017-08-11 08:00:00 | AAPL | Stock | 38.6875 | 38.75 | 38.6375 | 38.7125 | 46644.0 |
| 2017-08-11 08:05:00 | AAPL | Stock | 38.7 | 38.775 | 38.7 | 38.775 | 37072.0 |
| 2017-08-11 08:10:00 | AAPL | Stock | 38.7725 | 38.7725 | 38.725 | 38.76 | 21180.0 |
| 2017-08-11 08:15:00 | AAPL | Stock | 38.755 | 38.775 | 38.7275 | 38.7575 | 38040.0 |
| 2017-08-11 08:20:00 | AAPL | Stock | 38.78 | 38.8675 | 38.7575 | 38.85 | 44084.0 |
| 2017-08-11 08:25:00 | AAPL | Stock | 38.8725 | 38.9 | 38.8575 | 38.9 | 28832.0 |
| 2017-08-11 08:30:00 | AAPL | Stock | 38.87 | 38.97 | 38.8575 | 38.97 | 94740.0 |
| 2017-08-11 08:35:00 | AAPL | Stock | 38.9675 | 39.0375 | 38.95 | 39.0375 | 87800.0 |
| 2017-08-11 08:40:00 | AAPL | Stock | 39.0025 | 39.015 | 38.935 | 38.95 | 87000.0 |
| 2017-08-11 08:45:00 | AAPL | Stock | 38.95 | 39.0125 | 38.95 | 38.9975 | 44392.0 |
| 2017-08-11 08:50:00 | AAPL | Stock | 38.95 | 39.025 | 38.9475 | 39.0 | 16484.0 |
| 2017-08-11 08:55:00 | AAPL | Stock | 39.0 | 39.035 | 39.0 | 39.0225 | 49260.0 |
| 2017-08-11 09:00:00 | AAPL | Stock | 39.02 | 39.1475 | 39.02 | 39.1225 | 94952.0 |
| 2017-08-11 09:05:00 | AAPL | Stock | 39.125 | 39.15 | 39.1 | 39.15 | 96296.0 |
> showing 50 of 360,767 rows — these rows as CSV