PREVIEW / stock_5min / 2017-12-28
file: by_date/stock_5min/2017/2017-12-28.parquet size: 5.5 MB rows: 358,314 symbols: 2,921
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-28 04:00:00 | AAPL | Stock | 42.69 | 42.69 | 42.63 | 42.63 | 1468.0 |
| 2017-12-28 04:15:00 | AAPL | Stock | 42.7125 | 42.7125 | 42.7125 | 42.7125 | 800.0 |
| 2017-12-28 04:20:00 | AAPL | Stock | 42.675 | 42.675 | 42.675 | 42.675 | 800.0 |
| 2017-12-28 04:25:00 | AAPL | Stock | 42.675 | 42.675 | 42.675 | 42.675 | 1600.0 |
| 2017-12-28 04:30:00 | AAPL | Stock | 42.6375 | 42.6375 | 42.6375 | 42.6375 | 400.0 |
| 2017-12-28 05:05:00 | AAPL | Stock | 42.6575 | 42.6625 | 42.6575 | 42.6625 | 1912.0 |
| 2017-12-28 05:15:00 | AAPL | Stock | 42.675 | 42.675 | 42.675 | 42.675 | 2344.0 |
| 2017-12-28 05:25:00 | AAPL | Stock | 42.625 | 42.63 | 42.625 | 42.625 | 7600.0 |
| 2017-12-28 05:35:00 | AAPL | Stock | 42.6975 | 42.6975 | 42.6325 | 42.6325 | 1192.0 |
| 2017-12-28 06:05:00 | AAPL | Stock | 42.675 | 42.69 | 42.675 | 42.69 | 2100.0 |
| 2017-12-28 06:30:00 | AAPL | Stock | 42.7125 | 42.7125 | 42.7125 | 42.7125 | 680.0 |
| 2017-12-28 06:55:00 | AAPL | Stock | 42.725 | 42.725 | 42.725 | 42.725 | 3600.0 |
| 2017-12-28 07:00:00 | AAPL | Stock | 42.7225 | 42.74 | 42.7125 | 42.7125 | 11364.0 |
| 2017-12-28 07:05:00 | AAPL | Stock | 42.735 | 42.735 | 42.6825 | 42.725 | 16972.0 |
| 2017-12-28 07:15:00 | AAPL | Stock | 42.725 | 42.745 | 42.725 | 42.725 | 24168.0 |
| 2017-12-28 07:20:00 | AAPL | Stock | 42.7375 | 42.7925 | 42.7375 | 42.7625 | 25732.0 |
| 2017-12-28 07:25:00 | AAPL | Stock | 42.7625 | 42.77 | 42.75 | 42.77 | 13928.0 |
| 2017-12-28 07:35:00 | AAPL | Stock | 42.7725 | 42.7875 | 42.7725 | 42.7875 | 11240.0 |
| 2017-12-28 07:40:00 | AAPL | Stock | 42.775 | 42.775 | 42.775 | 42.775 | 5584.0 |
| 2017-12-28 07:45:00 | AAPL | Stock | 42.7575 | 42.7575 | 42.7575 | 42.7575 | 544.0 |
| 2017-12-28 07:50:00 | AAPL | Stock | 42.7575 | 42.7575 | 42.75 | 42.75 | 2416.0 |
| 2017-12-28 07:55:00 | AAPL | Stock | 42.7525 | 42.7675 | 42.75 | 42.75 | 10832.0 |
| 2017-12-28 08:00:00 | AAPL | Stock | 42.745 | 42.7875 | 42.725 | 42.735 | 43964.0 |
| 2017-12-28 08:05:00 | AAPL | Stock | 42.73 | 42.75 | 42.725 | 42.73 | 6032.0 |
| 2017-12-28 08:10:00 | AAPL | Stock | 42.74 | 42.75 | 42.725 | 42.75 | 13232.0 |
| 2017-12-28 08:15:00 | AAPL | Stock | 42.725 | 42.75 | 42.725 | 42.75 | 6560.0 |
| 2017-12-28 08:20:00 | AAPL | Stock | 42.75 | 42.7525 | 42.7375 | 42.7375 | 4000.0 |
| 2017-12-28 08:30:00 | AAPL | Stock | 42.7375 | 42.7475 | 42.7275 | 42.7275 | 7044.0 |
| 2017-12-28 08:35:00 | AAPL | Stock | 42.745 | 42.745 | 42.725 | 42.725 | 21984.0 |
| 2017-12-28 08:40:00 | AAPL | Stock | 42.72 | 42.7375 | 42.7 | 42.7375 | 42064.0 |
| 2017-12-28 08:45:00 | AAPL | Stock | 42.72 | 42.7275 | 42.7075 | 42.725 | 25740.0 |
| 2017-12-28 08:50:00 | AAPL | Stock | 42.725 | 42.7325 | 42.7125 | 42.7325 | 23800.0 |
| 2017-12-28 08:55:00 | AAPL | Stock | 42.7325 | 42.7375 | 42.7325 | 42.7375 | 11020.0 |
| 2017-12-28 09:00:00 | AAPL | Stock | 42.7375 | 42.755 | 42.7125 | 42.725 | 68424.0 |
| 2017-12-28 09:05:00 | AAPL | Stock | 42.725 | 42.725 | 42.715 | 42.715 | 2400.0 |
| 2017-12-28 09:10:00 | AAPL | Stock | 42.725 | 42.73 | 42.7 | 42.705 | 33644.0 |
| 2017-12-28 09:15:00 | AAPL | Stock | 42.715 | 42.725 | 42.705 | 42.7075 | 37912.0 |
| 2017-12-28 09:20:00 | AAPL | Stock | 42.705 | 42.7175 | 42.705 | 42.7075 | 6104.0 |
| 2017-12-28 09:25:00 | AAPL | Stock | 42.705 | 42.7725 | 42.7025 | 42.74 | 57464.0 |
| 2017-12-28 09:30:00 | AAPL | Stock | 42.75 | 42.9325 | 42.725 | 42.91 | 5157684.0 |
| 2017-12-28 09:35:00 | AAPL | Stock | 42.909 | 42.925 | 42.84 | 42.88 | 1647688.0 |
| 2017-12-28 09:40:00 | AAPL | Stock | 42.882 | 42.9 | 42.8375 | 42.8375 | 1477556.0 |
| 2017-12-28 09:45:00 | AAPL | Stock | 42.8375 | 42.905 | 42.8325 | 42.8683 | 1653156.0 |
| 2017-12-28 09:50:00 | AAPL | Stock | 42.8688 | 42.88 | 42.8375 | 42.87 | 1081376.0 |
| 2017-12-28 09:55:00 | AAPL | Stock | 42.8725 | 42.91 | 42.8675 | 42.8875 | 1007224.0 |
| 2017-12-28 10:00:00 | AAPL | Stock | 42.8875 | 42.9625 | 42.885 | 42.95 | 1752064.0 |
| 2017-12-28 10:05:00 | AAPL | Stock | 42.9475 | 42.95 | 42.905 | 42.94 | 985196.0 |
| 2017-12-28 10:10:00 | AAPL | Stock | 42.9375 | 42.9625 | 42.9175 | 42.93 | 980724.0 |
| 2017-12-28 10:15:00 | AAPL | Stock | 42.9288 | 42.95 | 42.8875 | 42.9075 | 823600.0 |
| 2017-12-28 10:20:00 | AAPL | Stock | 42.9025 | 42.925 | 42.8775 | 42.88 | 783196.0 |
> showing 50 of 358,314 rows — these rows as CSV