PREVIEW / stock_1min / 2015-09-18
file: by_date/stock_1min/2015/2015-09-18.parquet size: 15.2 MB rows: 1,105,688 symbols: 2,824
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-09-18 04:00:00 | AAPL | Stock | 28.525 | 28.525 | 28.4975 | 28.4975 | 3220.0 |
| 2015-09-18 04:07:00 | AAPL | Stock | 28.5575 | 28.5575 | 28.5575 | 28.5575 | 400.0 |
| 2015-09-18 04:27:00 | AAPL | Stock | 28.575 | 28.575 | 28.54 | 28.54 | 1600.0 |
| 2015-09-18 04:37:00 | AAPL | Stock | 28.5425 | 28.5425 | 28.5425 | 28.5425 | 4000.0 |
| 2015-09-18 04:48:00 | AAPL | Stock | 28.5275 | 28.5275 | 28.5 | 28.5 | 7040.0 |
| 2015-09-18 05:08:00 | AAPL | Stock | 28.5 | 28.5 | 28.5 | 28.5 | 800.0 |
| 2015-09-18 05:09:00 | AAPL | Stock | 28.5 | 28.5 | 28.5 | 28.5 | 9600.0 |
| 2015-09-18 05:10:00 | AAPL | Stock | 28.4775 | 28.4775 | 28.475 | 28.475 | 7200.0 |
| 2015-09-18 05:12:00 | AAPL | Stock | 28.4875 | 28.4875 | 28.4875 | 28.4875 | 3600.0 |
| 2015-09-18 05:18:00 | AAPL | Stock | 28.5 | 28.5 | 28.5 | 28.5 | 3936.0 |
| 2015-09-18 05:19:00 | AAPL | Stock | 28.485 | 28.5 | 28.485 | 28.5 | 11664.0 |
| 2015-09-18 05:33:00 | AAPL | Stock | 28.5475 | 28.5475 | 28.5475 | 28.5475 | 1180.0 |
| 2015-09-18 05:39:00 | AAPL | Stock | 28.5475 | 28.5475 | 28.5475 | 28.5475 | 1600.0 |
| 2015-09-18 05:52:00 | AAPL | Stock | 28.5 | 28.5125 | 28.5 | 28.5125 | 4280.0 |
| 2015-09-18 05:54:00 | AAPL | Stock | 28.475 | 28.475 | 28.475 | 28.475 | 2000.0 |
| 2015-09-18 05:56:00 | AAPL | Stock | 28.47 | 28.47 | 28.47 | 28.47 | 400.0 |
| 2015-09-18 05:57:00 | AAPL | Stock | 28.455 | 28.455 | 28.45 | 28.45 | 2000.0 |
| 2015-09-18 06:03:00 | AAPL | Stock | 28.455 | 28.455 | 28.455 | 28.455 | 800.0 |
| 2015-09-18 06:04:00 | AAPL | Stock | 28.4425 | 28.4425 | 28.4025 | 28.4025 | 8520.0 |
| 2015-09-18 06:05:00 | AAPL | Stock | 28.425 | 28.425 | 28.425 | 28.425 | 920.0 |
| 2015-09-18 06:08:00 | AAPL | Stock | 28.41 | 28.41 | 28.4075 | 28.4075 | 2000.0 |
| 2015-09-18 06:11:00 | AAPL | Stock | 28.4075 | 28.4075 | 28.4075 | 28.4075 | 400.0 |
| 2015-09-18 06:12:00 | AAPL | Stock | 28.425 | 28.4375 | 28.425 | 28.4375 | 800.0 |
| 2015-09-18 06:13:00 | AAPL | Stock | 28.4375 | 28.4375 | 28.4375 | 28.4375 | 3388.0 |
| 2015-09-18 06:15:00 | AAPL | Stock | 28.4375 | 28.4375 | 28.4375 | 28.4375 | 400.0 |
| 2015-09-18 06:17:00 | AAPL | Stock | 28.4375 | 28.4375 | 28.4375 | 28.4375 | 400.0 |
| 2015-09-18 06:18:00 | AAPL | Stock | 28.47 | 28.47 | 28.47 | 28.47 | 1600.0 |
| 2015-09-18 06:21:00 | AAPL | Stock | 28.4375 | 28.4375 | 28.4375 | 28.4375 | 2400.0 |
| 2015-09-18 06:22:00 | AAPL | Stock | 28.4375 | 28.4375 | 28.4375 | 28.4375 | 2400.0 |
| 2015-09-18 06:24:00 | AAPL | Stock | 28.4375 | 28.4375 | 28.41 | 28.41 | 2012.0 |
| 2015-09-18 06:27:00 | AAPL | Stock | 28.4075 | 28.4075 | 28.4025 | 28.4025 | 5840.0 |
| 2015-09-18 06:28:00 | AAPL | Stock | 28.385 | 28.385 | 28.38 | 28.38 | 800.0 |
| 2015-09-18 06:29:00 | AAPL | Stock | 28.375 | 28.375 | 28.375 | 28.375 | 4000.0 |
| 2015-09-18 06:33:00 | AAPL | Stock | 28.3825 | 28.3825 | 28.3825 | 28.3825 | 1264.0 |
| 2015-09-18 06:34:00 | AAPL | Stock | 28.385 | 28.39 | 28.385 | 28.39 | 2000.0 |
| 2015-09-18 06:36:00 | AAPL | Stock | 28.3975 | 28.4 | 28.3975 | 28.4 | 800.0 |
| 2015-09-18 06:38:00 | AAPL | Stock | 28.3875 | 28.3875 | 28.3625 | 28.3625 | 9060.0 |
| 2015-09-18 06:39:00 | AAPL | Stock | 28.3575 | 28.3575 | 28.35 | 28.35 | 9040.0 |
| 2015-09-18 06:40:00 | AAPL | Stock | 28.3225 | 28.325 | 28.3 | 28.3 | 4648.0 |
| 2015-09-18 06:41:00 | AAPL | Stock | 28.3 | 28.3 | 28.275 | 28.3 | 14164.0 |
| 2015-09-18 06:42:00 | AAPL | Stock | 28.31 | 28.325 | 28.31 | 28.325 | 2000.0 |
| 2015-09-18 06:43:00 | AAPL | Stock | 28.325 | 28.325 | 28.2925 | 28.2925 | 5700.0 |
| 2015-09-18 06:45:00 | AAPL | Stock | 28.2975 | 28.3 | 28.2975 | 28.3 | 808.0 |
| 2015-09-18 06:55:00 | AAPL | Stock | 28.31 | 28.31 | 28.31 | 28.31 | 800.0 |
| 2015-09-18 07:00:00 | AAPL | Stock | 28.31 | 28.31 | 28.31 | 28.31 | 592.0 |
| 2015-09-18 07:01:00 | AAPL | Stock | 28.3125 | 28.3125 | 28.3125 | 28.3125 | 1600.0 |
| 2015-09-18 07:03:00 | AAPL | Stock | 28.3175 | 28.3175 | 28.31 | 28.31 | 4400.0 |
| 2015-09-18 07:04:00 | AAPL | Stock | 28.31 | 28.31 | 28.31 | 28.31 | 5200.0 |
| 2015-09-18 07:05:00 | AAPL | Stock | 28.3025 | 28.3125 | 28.3025 | 28.3125 | 4040.0 |
| 2015-09-18 07:06:00 | AAPL | Stock | 28.3025 | 28.3025 | 28.285 | 28.285 | 4376.0 |
> showing 50 of 1,105,688 rows — these rows as CSV