PREVIEW / stock_1min / 2015-02-09
file: by_date/stock_1min/2015/2015-02-09.parquet size: 14.4 MB rows: 1,054,486 symbols: 2,875
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-02-09 04:00:00 | AAPL | Stock | 29.6875 | 29.6875 | 29.625 | 29.625 | 800.0 |
| 2015-02-09 04:01:00 | AAPL | Stock | 29.6 | 29.6 | 29.6 | 29.6 | 800.0 |
| 2015-02-09 04:05:00 | AAPL | Stock | 29.6125 | 29.6175 | 29.6125 | 29.6175 | 800.0 |
| 2015-02-09 04:09:00 | AAPL | Stock | 29.6 | 29.6 | 29.6 | 29.6 | 2000.0 |
| 2015-02-09 04:10:00 | AAPL | Stock | 29.6 | 29.6 | 29.6 | 29.6 | 2000.0 |
| 2015-02-09 04:12:00 | AAPL | Stock | 29.6025 | 29.6075 | 29.6025 | 29.6075 | 6912.0 |
| 2015-02-09 04:13:00 | AAPL | Stock | 29.6075 | 29.6075 | 29.605 | 29.6075 | 4000.0 |
| 2015-02-09 04:14:00 | AAPL | Stock | 29.6075 | 29.6075 | 29.6075 | 29.6075 | 1200.0 |
| 2015-02-09 04:18:00 | AAPL | Stock | 29.625 | 29.625 | 29.62 | 29.62 | 2400.0 |
| 2015-02-09 04:38:00 | AAPL | Stock | 29.5925 | 29.5925 | 29.5925 | 29.5925 | 2000.0 |
| 2015-02-09 04:44:00 | AAPL | Stock | 29.5475 | 29.5475 | 29.5475 | 29.5475 | 2312.0 |
| 2015-02-09 04:57:00 | AAPL | Stock | 29.5575 | 29.5575 | 29.5575 | 29.5575 | 800.0 |
| 2015-02-09 05:14:00 | AAPL | Stock | 29.5375 | 29.5375 | 29.5375 | 29.5375 | 400.0 |
| 2015-02-09 05:16:00 | AAPL | Stock | 29.545 | 29.545 | 29.545 | 29.545 | 5000.0 |
| 2015-02-09 05:21:00 | AAPL | Stock | 29.545 | 29.55 | 29.545 | 29.55 | 7600.0 |
| 2015-02-09 05:23:00 | AAPL | Stock | 29.55 | 29.5575 | 29.55 | 29.5575 | 4000.0 |
| 2015-02-09 05:25:00 | AAPL | Stock | 29.5575 | 29.5575 | 29.5575 | 29.5575 | 3200.0 |
| 2015-02-09 05:27:00 | AAPL | Stock | 29.5375 | 29.5375 | 29.5375 | 29.5375 | 2000.0 |
| 2015-02-09 05:28:00 | AAPL | Stock | 29.5375 | 29.5375 | 29.5375 | 29.5375 | 7200.0 |
| 2015-02-09 05:32:00 | AAPL | Stock | 29.545 | 29.5575 | 29.545 | 29.5575 | 2184.0 |
| 2015-02-09 05:33:00 | AAPL | Stock | 29.5575 | 29.5575 | 29.5575 | 29.5575 | 5604.0 |
| 2015-02-09 05:43:00 | AAPL | Stock | 29.5675 | 29.58 | 29.5675 | 29.58 | 1064.0 |
| 2015-02-09 05:46:00 | AAPL | Stock | 29.58 | 29.58 | 29.58 | 29.58 | 400.0 |
| 2015-02-09 05:48:00 | AAPL | Stock | 29.555 | 29.555 | 29.555 | 29.555 | 400.0 |
| 2015-02-09 05:52:00 | AAPL | Stock | 29.5375 | 29.5375 | 29.5375 | 29.5375 | 4000.0 |
| 2015-02-09 05:56:00 | AAPL | Stock | 29.5375 | 29.5375 | 29.525 | 29.525 | 3200.0 |
| 2015-02-09 05:57:00 | AAPL | Stock | 29.5025 | 29.5025 | 29.5 | 29.5 | 7720.0 |
| 2015-02-09 06:09:00 | AAPL | Stock | 29.525 | 29.5475 | 29.525 | 29.5475 | 7940.0 |
| 2015-02-09 06:10:00 | AAPL | Stock | 29.56 | 29.56 | 29.5475 | 29.5475 | 3904.0 |
| 2015-02-09 06:11:00 | AAPL | Stock | 29.55 | 29.55 | 29.55 | 29.55 | 2000.0 |
| 2015-02-09 06:12:00 | AAPL | Stock | 29.56 | 29.56 | 29.525 | 29.525 | 3384.0 |
| 2015-02-09 06:16:00 | AAPL | Stock | 29.54 | 29.54 | 29.54 | 29.54 | 800.0 |
| 2015-02-09 06:18:00 | AAPL | Stock | 29.5275 | 29.5275 | 29.5275 | 29.5275 | 1200.0 |
| 2015-02-09 06:20:00 | AAPL | Stock | 29.525 | 29.525 | 29.525 | 29.525 | 400.0 |
| 2015-02-09 06:21:00 | AAPL | Stock | 29.5375 | 29.5375 | 29.5375 | 29.5375 | 2000.0 |
| 2015-02-09 06:26:00 | AAPL | Stock | 29.515 | 29.515 | 29.5125 | 29.5125 | 800.0 |
| 2015-02-09 06:32:00 | AAPL | Stock | 29.5125 | 29.5125 | 29.5125 | 29.5125 | 800.0 |
| 2015-02-09 06:33:00 | AAPL | Stock | 29.52 | 29.52 | 29.52 | 29.52 | 400.0 |
| 2015-02-09 06:42:00 | AAPL | Stock | 29.5025 | 29.5025 | 29.5 | 29.5 | 5368.0 |
| 2015-02-09 06:43:00 | AAPL | Stock | 29.5025 | 29.5025 | 29.5025 | 29.5025 | 800.0 |
| 2015-02-09 06:45:00 | AAPL | Stock | 29.5225 | 29.525 | 29.5225 | 29.525 | 800.0 |
| 2015-02-09 06:46:00 | AAPL | Stock | 29.54 | 29.5425 | 29.54 | 29.5425 | 2800.0 |
| 2015-02-09 06:47:00 | AAPL | Stock | 29.5325 | 29.5325 | 29.5325 | 29.5325 | 400.0 |
| 2015-02-09 06:50:00 | AAPL | Stock | 29.5325 | 29.5325 | 29.5325 | 29.5325 | 400.0 |
| 2015-02-09 06:56:00 | AAPL | Stock | 29.5175 | 29.55 | 29.5175 | 29.55 | 2000.0 |
| 2015-02-09 07:02:00 | AAPL | Stock | 29.5375 | 29.575 | 29.5375 | 29.575 | 11172.0 |
| 2015-02-09 07:05:00 | AAPL | Stock | 29.55 | 29.5625 | 29.55 | 29.5625 | 2400.0 |
| 2015-02-09 07:09:00 | AAPL | Stock | 29.5625 | 29.5625 | 29.5625 | 29.5625 | 800.0 |
| 2015-02-09 07:12:00 | AAPL | Stock | 29.5725 | 29.5725 | 29.5725 | 29.5725 | 1200.0 |
| 2015-02-09 07:13:00 | AAPL | Stock | 29.5625 | 29.5625 | 29.5625 | 29.5625 | 400.0 |
> showing 50 of 1,054,486 rows — these rows as CSV