PREVIEW / stock_1min / 2014-06-11
file: by_date/stock_1min/2014/2014-06-11.parquet size: 13.7 MB rows: 1,012,517 symbols: 2,866
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 |
|---|---|---|---|---|---|---|---|
| 2014-06-11 04:05:00 | AAPL | Stock | 23.54 | 23.54 | 23.54 | 23.54 | 400.0 |
| 2014-06-11 04:29:00 | AAPL | Stock | 23.54 | 23.54 | 23.54 | 23.54 | 800.0 |
| 2014-06-11 04:40:00 | AAPL | Stock | 23.555 | 23.555 | 23.555 | 23.555 | 800.0 |
| 2014-06-11 04:41:00 | AAPL | Stock | 23.5375 | 23.5375 | 23.5375 | 23.5375 | 2764.0 |
| 2014-06-11 04:51:00 | AAPL | Stock | 23.525 | 23.525 | 23.525 | 23.525 | 404.0 |
| 2014-06-11 04:59:00 | AAPL | Stock | 23.515 | 23.515 | 23.515 | 23.515 | 2000.0 |
| 2014-06-11 05:06:00 | AAPL | Stock | 23.515 | 23.515 | 23.515 | 23.515 | 1600.0 |
| 2014-06-11 05:26:00 | AAPL | Stock | 23.5025 | 23.5025 | 23.5025 | 23.5025 | 400.0 |
| 2014-06-11 05:47:00 | AAPL | Stock | 23.465 | 23.465 | 23.405 | 23.405 | 8388.0 |
| 2014-06-11 05:53:00 | AAPL | Stock | 23.4375 | 23.4375 | 23.4375 | 23.4375 | 400.0 |
| 2014-06-11 06:16:00 | AAPL | Stock | 23.435 | 23.435 | 23.435 | 23.435 | 1400.0 |
| 2014-06-11 06:17:00 | AAPL | Stock | 23.4325 | 23.4325 | 23.4325 | 23.4325 | 756.0 |
| 2014-06-11 06:18:00 | AAPL | Stock | 23.4025 | 23.4025 | 23.4025 | 23.4025 | 1492.0 |
| 2014-06-11 06:24:00 | AAPL | Stock | 23.4375 | 23.4475 | 23.4375 | 23.4475 | 1600.0 |
| 2014-06-11 06:25:00 | AAPL | Stock | 23.4375 | 23.4475 | 23.4375 | 23.4475 | 3100.0 |
| 2014-06-11 06:26:00 | AAPL | Stock | 23.4075 | 23.4075 | 23.4075 | 23.4075 | 400.0 |
| 2014-06-11 06:34:00 | AAPL | Stock | 23.4275 | 23.4275 | 23.4275 | 23.4275 | 400.0 |
| 2014-06-11 06:35:00 | AAPL | Stock | 23.4275 | 23.4275 | 23.4275 | 23.4275 | 800.0 |
| 2014-06-11 06:36:00 | AAPL | Stock | 23.4275 | 23.4275 | 23.4275 | 23.4275 | 400.0 |
| 2014-06-11 06:37:00 | AAPL | Stock | 23.4275 | 23.4275 | 23.4275 | 23.4275 | 492.0 |
| 2014-06-11 06:42:00 | AAPL | Stock | 23.4275 | 23.4275 | 23.425 | 23.425 | 2000.0 |
| 2014-06-11 06:43:00 | AAPL | Stock | 23.425 | 23.425 | 23.425 | 23.425 | 1200.0 |
| 2014-06-11 06:44:00 | AAPL | Stock | 23.4275 | 23.43 | 23.4275 | 23.43 | 1200.0 |
| 2014-06-11 06:46:00 | AAPL | Stock | 23.4275 | 23.4275 | 23.425 | 23.425 | 5984.0 |
| 2014-06-11 06:47:00 | AAPL | Stock | 23.4375 | 23.4375 | 23.4375 | 23.4375 | 1820.0 |
| 2014-06-11 06:53:00 | AAPL | Stock | 23.425 | 23.425 | 23.425 | 23.425 | 400.0 |
| 2014-06-11 06:55:00 | AAPL | Stock | 23.415 | 23.415 | 23.415 | 23.415 | 400.0 |
| 2014-06-11 06:56:00 | AAPL | Stock | 23.415 | 23.415 | 23.4125 | 23.4125 | 1492.0 |
| 2014-06-11 07:02:00 | AAPL | Stock | 23.435 | 23.435 | 23.435 | 23.435 | 4320.0 |
| 2014-06-11 07:04:00 | AAPL | Stock | 23.4325 | 23.4325 | 23.4325 | 23.4325 | 1600.0 |
| 2014-06-11 07:05:00 | AAPL | Stock | 23.43 | 23.4325 | 23.43 | 23.4325 | 5704.0 |
| 2014-06-11 07:06:00 | AAPL | Stock | 23.4325 | 23.45 | 23.43 | 23.45 | 7800.0 |
| 2014-06-11 07:07:00 | AAPL | Stock | 23.45 | 23.45 | 23.45 | 23.45 | 7200.0 |
| 2014-06-11 07:10:00 | AAPL | Stock | 23.44 | 23.44 | 23.4375 | 23.4375 | 16180.0 |
| 2014-06-11 07:11:00 | AAPL | Stock | 23.4375 | 23.4375 | 23.4375 | 23.4375 | 3864.0 |
| 2014-06-11 07:12:00 | AAPL | Stock | 23.4225 | 23.4225 | 23.415 | 23.415 | 7108.0 |
| 2014-06-11 07:13:00 | AAPL | Stock | 23.415 | 23.415 | 23.3875 | 23.3875 | 33336.0 |
| 2014-06-11 07:14:00 | AAPL | Stock | 23.39 | 23.395 | 23.375 | 23.395 | 17900.0 |
| 2014-06-11 07:15:00 | AAPL | Stock | 23.3775 | 23.3775 | 23.375 | 23.375 | 7520.0 |
| 2014-06-11 07:16:00 | AAPL | Stock | 23.37 | 23.37 | 23.3625 | 23.3625 | 15000.0 |
| 2014-06-11 07:17:00 | AAPL | Stock | 23.3625 | 23.39 | 23.36 | 23.39 | 18928.0 |
| 2014-06-11 07:18:00 | AAPL | Stock | 23.39 | 23.39 | 23.3875 | 23.3875 | 848.0 |
| 2014-06-11 07:19:00 | AAPL | Stock | 23.3875 | 23.3875 | 23.3875 | 23.3875 | 6800.0 |
| 2014-06-11 07:21:00 | AAPL | Stock | 23.385 | 23.3925 | 23.385 | 23.3875 | 14000.0 |
| 2014-06-11 07:26:00 | AAPL | Stock | 23.385 | 23.385 | 23.375 | 23.375 | 16232.0 |
| 2014-06-11 07:27:00 | AAPL | Stock | 23.365 | 23.3725 | 23.365 | 23.3725 | 3600.0 |
| 2014-06-11 07:28:00 | AAPL | Stock | 23.3675 | 23.3725 | 23.3675 | 23.3725 | 2000.0 |
| 2014-06-11 07:29:00 | AAPL | Stock | 23.37 | 23.375 | 23.37 | 23.375 | 5660.0 |
| 2014-06-11 07:30:00 | AAPL | Stock | 23.37 | 23.37 | 23.355 | 23.355 | 27472.0 |
| 2014-06-11 07:32:00 | AAPL | Stock | 23.3725 | 23.3725 | 23.3725 | 23.3725 | 400.0 |
> showing 50 of 1,012,517 rows — these rows as CSV