PREVIEW / stock_1min / 2015-08-04
file: by_date/stock_1min/2015/2015-08-04.parquet size: 14.5 MB rows: 1,068,435 symbols: 2,825
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-08-04 04:00:00 | AAPL | Stock | 29.375 | 29.5375 | 29.375 | 29.5375 | 4400.0 |
| 2015-08-04 04:02:00 | AAPL | Stock | 29.485 | 29.485 | 29.485 | 29.485 | 2000.0 |
| 2015-08-04 04:03:00 | AAPL | Stock | 29.465 | 29.465 | 29.45 | 29.4525 | 27296.0 |
| 2015-08-04 04:04:00 | AAPL | Stock | 29.435 | 29.435 | 29.385 | 29.385 | 10780.0 |
| 2015-08-04 04:05:00 | AAPL | Stock | 29.36 | 29.375 | 29.35 | 29.375 | 10800.0 |
| 2015-08-04 04:06:00 | AAPL | Stock | 29.3775 | 29.3775 | 29.3775 | 29.3775 | 1256.0 |
| 2015-08-04 04:07:00 | AAPL | Stock | 29.3725 | 29.3725 | 29.355 | 29.36 | 58392.0 |
| 2015-08-04 04:08:00 | AAPL | Stock | 29.36 | 29.36 | 29.36 | 29.36 | 2400.0 |
| 2015-08-04 04:09:00 | AAPL | Stock | 29.365 | 29.37 | 29.365 | 29.37 | 3408.0 |
| 2015-08-04 04:10:00 | AAPL | Stock | 29.37 | 29.37 | 29.37 | 29.37 | 992.0 |
| 2015-08-04 04:13:00 | AAPL | Stock | 29.3925 | 29.3925 | 29.3925 | 29.3925 | 2016.0 |
| 2015-08-04 04:15:00 | AAPL | Stock | 29.445 | 29.445 | 29.445 | 29.445 | 14320.0 |
| 2015-08-04 04:17:00 | AAPL | Stock | 29.445 | 29.5 | 29.445 | 29.5 | 4456.0 |
| 2015-08-04 04:19:00 | AAPL | Stock | 29.5 | 29.5 | 29.5 | 29.5 | 1200.0 |
| 2015-08-04 04:20:00 | AAPL | Stock | 29.5 | 29.5 | 29.5 | 29.5 | 4760.0 |
| 2015-08-04 04:23:00 | AAPL | Stock | 29.5 | 29.5 | 29.5 | 29.5 | 4400.0 |
| 2015-08-04 04:24:00 | AAPL | Stock | 29.5 | 29.5 | 29.5 | 29.5 | 7200.0 |
| 2015-08-04 04:26:00 | AAPL | Stock | 29.5075 | 29.5075 | 29.5075 | 29.5075 | 2592.0 |
| 2015-08-04 04:28:00 | AAPL | Stock | 29.4975 | 29.5 | 29.4975 | 29.5 | 28800.0 |
| 2015-08-04 04:29:00 | AAPL | Stock | 29.5 | 29.5 | 29.5 | 29.5 | 3012.0 |
| 2015-08-04 04:31:00 | AAPL | Stock | 29.535 | 29.535 | 29.535 | 29.535 | 8600.0 |
| 2015-08-04 04:32:00 | AAPL | Stock | 29.5375 | 29.5375 | 29.5375 | 29.5375 | 9512.0 |
| 2015-08-04 04:33:00 | AAPL | Stock | 29.5175 | 29.5175 | 29.5175 | 29.5175 | 400.0 |
| 2015-08-04 04:45:00 | AAPL | Stock | 29.525 | 29.525 | 29.525 | 29.525 | 980.0 |
| 2015-08-04 04:49:00 | AAPL | Stock | 29.5 | 29.5 | 29.4875 | 29.4875 | 1484.0 |
| 2015-08-04 05:03:00 | AAPL | Stock | 29.5 | 29.5 | 29.5 | 29.5 | 36276.0 |
| 2015-08-04 05:28:00 | AAPL | Stock | 29.5 | 29.5 | 29.5 | 29.5 | 2400.0 |
| 2015-08-04 05:29:00 | AAPL | Stock | 29.5 | 29.5 | 29.5 | 29.5 | 1240.0 |
| 2015-08-04 05:30:00 | AAPL | Stock | 29.5 | 29.5 | 29.5 | 29.5 | 2560.0 |
| 2015-08-04 05:31:00 | AAPL | Stock | 29.5 | 29.5 | 29.5 | 29.5 | 16800.0 |
| 2015-08-04 05:33:00 | AAPL | Stock | 29.5 | 29.5 | 29.5 | 29.5 | 1848.0 |
| 2015-08-04 05:35:00 | AAPL | Stock | 29.5 | 29.5 | 29.5 | 29.5 | 800.0 |
| 2015-08-04 05:39:00 | AAPL | Stock | 29.5125 | 29.5125 | 29.5125 | 29.5125 | 1600.0 |
| 2015-08-04 05:58:00 | AAPL | Stock | 29.5375 | 29.5375 | 29.5375 | 29.5375 | 1364.0 |
| 2015-08-04 06:00:00 | AAPL | Stock | 29.525 | 29.525 | 29.525 | 29.525 | 952.0 |
| 2015-08-04 06:03:00 | AAPL | Stock | 29.5125 | 29.5125 | 29.5125 | 29.5125 | 3852.0 |
| 2015-08-04 06:06:00 | AAPL | Stock | 29.5225 | 29.5325 | 29.5225 | 29.5325 | 3988.0 |
| 2015-08-04 06:07:00 | AAPL | Stock | 29.515 | 29.515 | 29.515 | 29.515 | 1432.0 |
| 2015-08-04 06:09:00 | AAPL | Stock | 29.5225 | 29.5225 | 29.5225 | 29.5225 | 4000.0 |
| 2015-08-04 06:11:00 | AAPL | Stock | 29.5225 | 29.5225 | 29.5225 | 29.5225 | 2000.0 |
| 2015-08-04 06:14:00 | AAPL | Stock | 29.51 | 29.51 | 29.51 | 29.51 | 2000.0 |
| 2015-08-04 06:15:00 | AAPL | Stock | 29.5 | 29.5 | 29.495 | 29.495 | 5600.0 |
| 2015-08-04 06:17:00 | AAPL | Stock | 29.4825 | 29.4825 | 29.4675 | 29.4675 | 22800.0 |
| 2015-08-04 06:18:00 | AAPL | Stock | 29.4425 | 29.4425 | 29.4425 | 29.4425 | 400.0 |
| 2015-08-04 06:20:00 | AAPL | Stock | 29.4375 | 29.475 | 29.425 | 29.475 | 39372.0 |
| 2015-08-04 06:25:00 | AAPL | Stock | 29.425 | 29.425 | 29.425 | 29.425 | 2872.0 |
| 2015-08-04 06:31:00 | AAPL | Stock | 29.4625 | 29.4625 | 29.4625 | 29.4625 | 11768.0 |
| 2015-08-04 06:36:00 | AAPL | Stock | 29.44 | 29.44 | 29.4375 | 29.4375 | 1644.0 |
| 2015-08-04 06:40:00 | AAPL | Stock | 29.4375 | 29.4375 | 29.4375 | 29.4375 | 11600.0 |
| 2015-08-04 06:49:00 | AAPL | Stock | 29.4525 | 29.4525 | 29.4525 | 29.4525 | 444.0 |
> showing 50 of 1,068,435 rows — these rows as CSV