PREVIEW / stock_1min / 2018-11-27
file: by_date/stock_1min/2018/2018-11-27.parquet size: 14.9 MB rows: 1,066,832 symbols: 2,290
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 |
|---|---|---|---|---|---|---|---|
| 2018-11-27 04:00:00 | AAPL | Stock | 42.9375 | 42.9375 | 42.9375 | 42.9375 | 400.0 |
| 2018-11-27 04:01:00 | AAPL | Stock | 42.995 | 42.9975 | 42.995 | 42.9975 | 1596.0 |
| 2018-11-27 04:04:00 | AAPL | Stock | 42.985 | 42.985 | 42.985 | 42.985 | 600.0 |
| 2018-11-27 04:06:00 | AAPL | Stock | 42.985 | 42.985 | 42.985 | 42.985 | 400.0 |
| 2018-11-27 04:12:00 | AAPL | Stock | 43.07 | 43.105 | 43.07 | 43.105 | 6588.0 |
| 2018-11-27 04:15:00 | AAPL | Stock | 43.0925 | 43.0925 | 43.0925 | 43.0925 | 1104.0 |
| 2018-11-27 04:19:00 | AAPL | Stock | 43.09 | 43.09 | 43.09 | 43.09 | 400.0 |
| 2018-11-27 04:22:00 | AAPL | Stock | 43.0975 | 43.0975 | 43.0975 | 43.0975 | 1436.0 |
| 2018-11-27 04:23:00 | AAPL | Stock | 43.0975 | 43.12 | 43.0975 | 43.12 | 4176.0 |
| 2018-11-27 04:24:00 | AAPL | Stock | 43.12 | 43.1225 | 43.12 | 43.1225 | 1288.0 |
| 2018-11-27 04:25:00 | AAPL | Stock | 43.1225 | 43.1225 | 43.1225 | 43.1225 | 400.0 |
| 2018-11-27 04:26:00 | AAPL | Stock | 43.1125 | 43.1225 | 43.1125 | 43.1225 | 1600.0 |
| 2018-11-27 04:28:00 | AAPL | Stock | 43.1225 | 43.1225 | 43.1225 | 43.1225 | 800.0 |
| 2018-11-27 04:31:00 | AAPL | Stock | 43.21 | 43.21 | 43.21 | 43.21 | 1128.0 |
| 2018-11-27 04:32:00 | AAPL | Stock | 43.175 | 43.175 | 43.175 | 43.175 | 400.0 |
| 2018-11-27 04:33:00 | AAPL | Stock | 43.2075 | 43.2075 | 43.175 | 43.175 | 6800.0 |
| 2018-11-27 04:44:00 | AAPL | Stock | 43.0925 | 43.0925 | 43.075 | 43.075 | 1200.0 |
| 2018-11-27 04:49:00 | AAPL | Stock | 43.0375 | 43.0375 | 43.0375 | 43.0375 | 5600.0 |
| 2018-11-27 04:55:00 | AAPL | Stock | 43.0375 | 43.0375 | 43.0375 | 43.0375 | 600.0 |
| 2018-11-27 05:00:00 | AAPL | Stock | 42.975 | 42.975 | 42.975 | 42.975 | 6536.0 |
| 2018-11-27 05:01:00 | AAPL | Stock | 42.975 | 42.975 | 42.975 | 42.975 | 800.0 |
| 2018-11-27 05:20:00 | AAPL | Stock | 42.975 | 42.975 | 42.975 | 42.975 | 1732.0 |
| 2018-11-27 05:26:00 | AAPL | Stock | 42.9025 | 42.9025 | 42.9025 | 42.9025 | 3764.0 |
| 2018-11-27 05:29:00 | AAPL | Stock | 42.97 | 42.97 | 42.97 | 42.97 | 2800.0 |
| 2018-11-27 05:33:00 | AAPL | Stock | 42.97 | 42.97 | 42.925 | 42.925 | 4512.0 |
| 2018-11-27 05:39:00 | AAPL | Stock | 42.9475 | 42.9475 | 42.9475 | 42.9475 | 400.0 |
| 2018-11-27 05:41:00 | AAPL | Stock | 42.9475 | 42.9475 | 42.9475 | 42.9475 | 400.0 |
| 2018-11-27 05:44:00 | AAPL | Stock | 42.9475 | 42.9475 | 42.9475 | 42.9475 | 400.0 |
| 2018-11-27 06:02:00 | AAPL | Stock | 42.9 | 42.9 | 42.875 | 42.875 | 6816.0 |
| 2018-11-27 06:04:00 | AAPL | Stock | 42.875 | 42.875 | 42.875 | 42.875 | 3576.0 |
| 2018-11-27 06:06:00 | AAPL | Stock | 42.875 | 42.875 | 42.875 | 42.875 | 1676.0 |
| 2018-11-27 06:08:00 | AAPL | Stock | 42.9 | 42.9 | 42.9 | 42.9 | 800.0 |
| 2018-11-27 06:10:00 | AAPL | Stock | 42.9 | 42.9 | 42.875 | 42.875 | 2400.0 |
| 2018-11-27 06:12:00 | AAPL | Stock | 42.9 | 42.9 | 42.875 | 42.9 | 7580.0 |
| 2018-11-27 06:14:00 | AAPL | Stock | 42.875 | 42.875 | 42.875 | 42.875 | 1996.0 |
| 2018-11-27 06:18:00 | AAPL | Stock | 42.9 | 42.9 | 42.875 | 42.875 | 1328.0 |
| 2018-11-27 06:20:00 | AAPL | Stock | 42.875 | 42.875 | 42.875 | 42.875 | 3880.0 |
| 2018-11-27 06:21:00 | AAPL | Stock | 42.875 | 42.875 | 42.875 | 42.875 | 1600.0 |
| 2018-11-27 06:22:00 | AAPL | Stock | 42.85 | 42.85 | 42.85 | 42.85 | 1080.0 |
| 2018-11-27 06:23:00 | AAPL | Stock | 42.85 | 42.85 | 42.85 | 42.85 | 400.0 |
| 2018-11-27 06:26:00 | AAPL | Stock | 42.875 | 42.875 | 42.875 | 42.875 | 1600.0 |
| 2018-11-27 06:31:00 | AAPL | Stock | 42.9 | 42.9 | 42.8875 | 42.8875 | 3592.0 |
| 2018-11-27 06:34:00 | AAPL | Stock | 42.9025 | 42.92 | 42.9025 | 42.92 | 4400.0 |
| 2018-11-27 06:41:00 | AAPL | Stock | 42.9025 | 42.9025 | 42.8375 | 42.8375 | 5920.0 |
| 2018-11-27 06:44:00 | AAPL | Stock | 42.9 | 42.9 | 42.875 | 42.875 | 4236.0 |
| 2018-11-27 06:51:00 | AAPL | Stock | 42.9225 | 42.9225 | 42.9225 | 42.9225 | 568.0 |
| 2018-11-27 06:52:00 | AAPL | Stock | 42.9 | 42.9025 | 42.9 | 42.9 | 4000.0 |
| 2018-11-27 06:54:00 | AAPL | Stock | 42.99 | 42.99 | 42.99 | 42.99 | 400.0 |
| 2018-11-27 06:59:00 | AAPL | Stock | 43.0 | 43.0 | 43.0 | 43.0 | 3992.0 |
| 2018-11-27 07:00:00 | AAPL | Stock | 42.9575 | 42.9775 | 42.7325 | 42.8125 | 52008.0 |
> showing 50 of 1,066,832 rows — these rows as CSV