PREVIEW / stock_1min / 2017-10-13
file: by_date/stock_1min/2017/2017-10-13.parquet size: 13.9 MB rows: 998,100 symbols: 2,442
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-10-13 04:09:00 | AAPL | Stock | 39.05 | 39.05 | 39.05 | 39.05 | 400.0 |
| 2017-10-13 05:08:00 | AAPL | Stock | 39.035 | 39.035 | 39.035 | 39.035 | 800.0 |
| 2017-10-13 05:09:00 | AAPL | Stock | 39.0225 | 39.0225 | 39.0225 | 39.0225 | 400.0 |
| 2017-10-13 05:10:00 | AAPL | Stock | 39.0 | 39.0 | 39.0 | 39.0 | 700.0 |
| 2017-10-13 05:15:00 | AAPL | Stock | 39.0 | 39.0 | 39.0 | 39.0 | 800.0 |
| 2017-10-13 05:16:00 | AAPL | Stock | 39.0 | 39.0 | 39.0 | 39.0 | 400.0 |
| 2017-10-13 05:39:00 | AAPL | Stock | 39.035 | 39.035 | 39.035 | 39.035 | 1012.0 |
| 2017-10-13 06:11:00 | AAPL | Stock | 39.05 | 39.05 | 39.05 | 39.05 | 1600.0 |
| 2017-10-13 06:35:00 | AAPL | Stock | 39.05 | 39.05 | 39.05 | 39.05 | 1700.0 |
| 2017-10-13 06:59:00 | AAPL | Stock | 39.05 | 39.05 | 39.05 | 39.05 | 1800.0 |
| 2017-10-13 07:00:00 | AAPL | Stock | 39.0625 | 39.0625 | 39.0625 | 39.0625 | 800.0 |
| 2017-10-13 07:01:00 | AAPL | Stock | 39.0625 | 39.0625 | 39.05 | 39.05 | 1616.0 |
| 2017-10-13 07:02:00 | AAPL | Stock | 39.05 | 39.05 | 39.05 | 39.05 | 496.0 |
| 2017-10-13 07:03:00 | AAPL | Stock | 39.075 | 39.075 | 39.075 | 39.075 | 400.0 |
| 2017-10-13 07:06:00 | AAPL | Stock | 39.0325 | 39.0325 | 39.0325 | 39.0325 | 400.0 |
| 2017-10-13 07:08:00 | AAPL | Stock | 39.075 | 39.075 | 39.07 | 39.075 | 2400.0 |
| 2017-10-13 07:19:00 | AAPL | Stock | 39.09 | 39.09 | 39.09 | 39.09 | 400.0 |
| 2017-10-13 07:24:00 | AAPL | Stock | 39.09 | 39.09 | 39.09 | 39.09 | 2000.0 |
| 2017-10-13 07:28:00 | AAPL | Stock | 39.0925 | 39.0925 | 39.0925 | 39.0925 | 868.0 |
| 2017-10-13 07:30:00 | AAPL | Stock | 39.11 | 39.125 | 39.11 | 39.125 | 896.0 |
| 2017-10-13 07:39:00 | AAPL | Stock | 39.105 | 39.105 | 39.105 | 39.105 | 2400.0 |
| 2017-10-13 07:41:00 | AAPL | Stock | 39.105 | 39.105 | 39.105 | 39.105 | 3380.0 |
| 2017-10-13 07:42:00 | AAPL | Stock | 39.125 | 39.125 | 39.0875 | 39.0875 | 26272.0 |
| 2017-10-13 07:43:00 | AAPL | Stock | 39.0875 | 39.0925 | 39.0875 | 39.0925 | 2208.0 |
| 2017-10-13 07:45:00 | AAPL | Stock | 39.1 | 39.1 | 39.1 | 39.1 | 2000.0 |
| 2017-10-13 07:47:00 | AAPL | Stock | 39.0925 | 39.0925 | 39.0875 | 39.0875 | 4620.0 |
| 2017-10-13 07:50:00 | AAPL | Stock | 39.085 | 39.085 | 39.085 | 39.085 | 400.0 |
| 2017-10-13 07:51:00 | AAPL | Stock | 39.0875 | 39.0875 | 39.0875 | 39.0875 | 6000.0 |
| 2017-10-13 07:52:00 | AAPL | Stock | 39.0875 | 39.0875 | 39.0875 | 39.0875 | 11200.0 |
| 2017-10-13 07:53:00 | AAPL | Stock | 39.0875 | 39.0875 | 39.0875 | 39.0875 | 29200.0 |
| 2017-10-13 07:56:00 | AAPL | Stock | 39.0875 | 39.0875 | 39.0875 | 39.0875 | 600.0 |
| 2017-10-13 07:57:00 | AAPL | Stock | 39.1 | 39.1 | 39.0825 | 39.0825 | 7388.0 |
| 2017-10-13 07:58:00 | AAPL | Stock | 39.0925 | 39.0925 | 39.0925 | 39.0925 | 1200.0 |
| 2017-10-13 07:59:00 | AAPL | Stock | 39.0825 | 39.0825 | 39.075 | 39.075 | 3680.0 |
| 2017-10-13 08:00:00 | AAPL | Stock | 39.1 | 39.125 | 39.085 | 39.085 | 20432.0 |
| 2017-10-13 08:03:00 | AAPL | Stock | 39.0975 | 39.0975 | 39.0975 | 39.0975 | 400.0 |
| 2017-10-13 08:05:00 | AAPL | Stock | 39.0875 | 39.0875 | 39.0875 | 39.0875 | 8000.0 |
| 2017-10-13 08:08:00 | AAPL | Stock | 39.08 | 39.08 | 39.08 | 39.08 | 1200.0 |
| 2017-10-13 08:11:00 | AAPL | Stock | 39.08 | 39.08 | 39.08 | 39.08 | 1200.0 |
| 2017-10-13 08:12:00 | AAPL | Stock | 39.0875 | 39.0875 | 39.075 | 39.075 | 5100.0 |
| 2017-10-13 08:13:00 | AAPL | Stock | 39.0675 | 39.075 | 39.0675 | 39.075 | 7620.0 |
| 2017-10-13 08:15:00 | AAPL | Stock | 39.0875 | 39.0875 | 39.0875 | 39.0875 | 2400.0 |
| 2017-10-13 08:16:00 | AAPL | Stock | 39.085 | 39.085 | 39.085 | 39.085 | 636.0 |
| 2017-10-13 08:20:00 | AAPL | Stock | 39.0825 | 39.0825 | 39.08 | 39.08 | 5476.0 |
| 2017-10-13 08:21:00 | AAPL | Stock | 39.075 | 39.0825 | 39.075 | 39.0825 | 2724.0 |
| 2017-10-13 08:22:00 | AAPL | Stock | 39.085 | 39.0875 | 39.085 | 39.0875 | 1348.0 |
| 2017-10-13 08:23:00 | AAPL | Stock | 39.0875 | 39.0875 | 39.075 | 39.075 | 7132.0 |
| 2017-10-13 08:25:00 | AAPL | Stock | 39.08 | 39.08 | 39.08 | 39.08 | 4000.0 |
| 2017-10-13 08:26:00 | AAPL | Stock | 39.0875 | 39.0875 | 39.0875 | 39.0875 | 2000.0 |
| 2017-10-13 08:28:00 | AAPL | Stock | 39.0875 | 39.1025 | 39.0875 | 39.1025 | 5600.0 |
> showing 50 of 998,100 rows — these rows as CSV