PREVIEW / stock_5min / 2015-07-22
file: by_date/stock_5min/2015/2015-07-22.parquet size: 5.4 MB rows: 355,067 symbols: 3,482
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 |
|---|---|---|---|---|---|---|---|
| 2015-07-22 04:00:00 | AAPL | Stock | 30.425 | 31.0775 | 30.425 | 30.815 | 290244.0 |
| 2015-07-22 04:05:00 | AAPL | Stock | 30.825 | 30.825 | 30.75 | 30.755 | 54912.0 |
| 2015-07-22 04:10:00 | AAPL | Stock | 30.755 | 30.8125 | 30.755 | 30.8125 | 86520.0 |
| 2015-07-22 04:15:00 | AAPL | Stock | 30.8175 | 31.025 | 30.8175 | 30.9875 | 57032.0 |
| 2015-07-22 04:20:00 | AAPL | Stock | 30.9675 | 31.025 | 30.9625 | 30.9925 | 21988.0 |
| 2015-07-22 04:25:00 | AAPL | Stock | 30.95 | 31.0 | 30.95 | 30.9925 | 9108.0 |
| 2015-07-22 04:30:00 | AAPL | Stock | 31.0025 | 31.23 | 31.0025 | 31.06 | 168212.0 |
| 2015-07-22 04:35:00 | AAPL | Stock | 31.0625 | 31.15 | 31.06 | 31.125 | 43084.0 |
| 2015-07-22 04:40:00 | AAPL | Stock | 31.125 | 31.1275 | 31.0 | 31.07 | 30768.0 |
| 2015-07-22 04:45:00 | AAPL | Stock | 31.02 | 31.02 | 31.0025 | 31.02 | 13560.0 |
| 2015-07-22 04:50:00 | AAPL | Stock | 31.0025 | 31.0375 | 30.95 | 30.975 | 70400.0 |
| 2015-07-22 04:55:00 | AAPL | Stock | 30.9575 | 30.9575 | 30.86 | 30.9375 | 44168.0 |
| 2015-07-22 05:00:00 | AAPL | Stock | 30.9375 | 30.9375 | 30.87 | 30.875 | 16648.0 |
| 2015-07-22 05:05:00 | AAPL | Stock | 30.925 | 30.9375 | 30.9 | 30.9375 | 7952.0 |
| 2015-07-22 05:10:00 | AAPL | Stock | 30.93 | 30.9375 | 30.9275 | 30.9275 | 5200.0 |
| 2015-07-22 05:15:00 | AAPL | Stock | 30.95 | 30.975 | 30.9475 | 30.975 | 10764.0 |
| 2015-07-22 05:20:00 | AAPL | Stock | 30.9875 | 30.9975 | 30.9625 | 30.995 | 17260.0 |
| 2015-07-22 05:25:00 | AAPL | Stock | 30.97 | 30.9975 | 30.96 | 30.96 | 10936.0 |
| 2015-07-22 05:30:00 | AAPL | Stock | 30.96 | 30.9975 | 30.925 | 30.9875 | 75436.0 |
| 2015-07-22 05:35:00 | AAPL | Stock | 30.9875 | 30.9925 | 30.98 | 30.98 | 10004.0 |
| 2015-07-22 05:40:00 | AAPL | Stock | 30.9925 | 31.085 | 30.98 | 31.0275 | 67328.0 |
| 2015-07-22 05:45:00 | AAPL | Stock | 31.0975 | 31.1075 | 31.005 | 31.0425 | 24956.0 |
| 2015-07-22 05:50:00 | AAPL | Stock | 31.0025 | 31.025 | 30.9 | 30.9 | 63444.0 |
| 2015-07-22 05:55:00 | AAPL | Stock | 30.9975 | 31.0 | 30.8775 | 30.8775 | 19996.0 |
| 2015-07-22 06:00:00 | AAPL | Stock | 30.8825 | 30.9175 | 30.8825 | 30.9 | 35812.0 |
| 2015-07-22 06:05:00 | AAPL | Stock | 30.9 | 30.9 | 30.8 | 30.8175 | 60396.0 |
| 2015-07-22 06:10:00 | AAPL | Stock | 30.8425 | 30.9225 | 30.74 | 30.8175 | 183672.0 |
| 2015-07-22 06:15:00 | AAPL | Stock | 30.7625 | 30.8425 | 30.7625 | 30.8 | 171900.0 |
| 2015-07-22 06:20:00 | AAPL | Stock | 30.7775 | 30.8475 | 30.7625 | 30.8475 | 82128.0 |
| 2015-07-22 06:25:00 | AAPL | Stock | 30.8575 | 30.87 | 30.8175 | 30.8325 | 35768.0 |
| 2015-07-22 06:30:00 | AAPL | Stock | 30.8425 | 30.92 | 30.8275 | 30.92 | 156844.0 |
| 2015-07-22 06:35:00 | AAPL | Stock | 30.8875 | 30.9 | 30.8375 | 30.8375 | 122664.0 |
| 2015-07-22 06:40:00 | AAPL | Stock | 30.8425 | 30.8475 | 30.7925 | 30.8 | 54860.0 |
| 2015-07-22 06:45:00 | AAPL | Stock | 30.8 | 30.8375 | 30.795 | 30.795 | 33148.0 |
| 2015-07-22 06:50:00 | AAPL | Stock | 30.8 | 30.8 | 30.72 | 30.75 | 124064.0 |
| 2015-07-22 06:55:00 | AAPL | Stock | 30.75 | 30.75 | 30.6425 | 30.6575 | 139140.0 |
| 2015-07-22 07:00:00 | AAPL | Stock | 30.6525 | 30.75 | 30.64 | 30.7075 | 128192.0 |
| 2015-07-22 07:05:00 | AAPL | Stock | 30.72 | 30.7375 | 30.675 | 30.7225 | 132352.0 |
| 2015-07-22 07:10:00 | AAPL | Stock | 30.7125 | 30.7225 | 30.665 | 30.6875 | 40336.0 |
| 2015-07-22 07:15:00 | AAPL | Stock | 30.685 | 30.7125 | 30.63 | 30.6375 | 99816.0 |
| 2015-07-22 07:20:00 | AAPL | Stock | 30.635 | 30.6875 | 30.6275 | 30.6775 | 106648.0 |
| 2015-07-22 07:25:00 | AAPL | Stock | 30.68 | 30.6875 | 30.625 | 30.655 | 114980.0 |
| 2015-07-22 07:30:00 | AAPL | Stock | 30.65 | 30.715 | 30.6425 | 30.65 | 198648.0 |
| 2015-07-22 07:35:00 | AAPL | Stock | 30.65 | 30.65 | 30.525 | 30.5625 | 426760.0 |
| 2015-07-22 07:40:00 | AAPL | Stock | 30.5525 | 30.6 | 30.5 | 30.525 | 443256.0 |
| 2015-07-22 07:45:00 | AAPL | Stock | 30.5125 | 30.5925 | 30.4775 | 30.5775 | 207136.0 |
| 2015-07-22 07:50:00 | AAPL | Stock | 30.5625 | 30.61 | 30.5625 | 30.59 | 295008.0 |
| 2015-07-22 07:55:00 | AAPL | Stock | 30.59 | 30.6575 | 30.5775 | 30.61 | 207032.0 |
| 2015-07-22 08:00:00 | AAPL | Stock | 30.61 | 30.9175 | 30.465 | 30.4975 | 2132752.0 |
| 2015-07-22 08:05:00 | AAPL | Stock | 30.495 | 30.6625 | 30.4375 | 30.4408 | 747852.0 |
> showing 50 of 355,067 rows — these rows as CSV