PREVIEW / stock_1min / 2015-09-01
file: by_date/stock_1min/2015/2015-09-01.parquet size: 15.8 MB rows: 1,148,733 symbols: 2,837
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-01 04:00:00 | AAPL | Stock | 27.8625 | 27.8625 | 27.425 | 27.425 | 28256.0 |
| 2015-09-01 04:01:00 | AAPL | Stock | 27.4925 | 27.4925 | 27.4625 | 27.4625 | 800.0 |
| 2015-09-01 04:02:00 | AAPL | Stock | 27.495 | 27.495 | 27.495 | 27.495 | 5200.0 |
| 2015-09-01 04:03:00 | AAPL | Stock | 27.4825 | 27.4825 | 27.4825 | 27.4825 | 400.0 |
| 2015-09-01 04:04:00 | AAPL | Stock | 27.5 | 27.5 | 27.5 | 27.5 | 2000.0 |
| 2015-09-01 04:05:00 | AAPL | Stock | 27.5 | 27.5125 | 27.5 | 27.5025 | 2400.0 |
| 2015-09-01 04:06:00 | AAPL | Stock | 27.525 | 27.5725 | 27.5225 | 27.5225 | 2800.0 |
| 2015-09-01 04:07:00 | AAPL | Stock | 27.5275 | 27.5275 | 27.5 | 27.5 | 2880.0 |
| 2015-09-01 04:08:00 | AAPL | Stock | 27.57 | 27.57 | 27.57 | 27.57 | 400.0 |
| 2015-09-01 04:10:00 | AAPL | Stock | 27.5 | 27.5 | 27.5 | 27.5 | 2000.0 |
| 2015-09-01 04:12:00 | AAPL | Stock | 27.48 | 27.48 | 27.475 | 27.475 | 1600.0 |
| 2015-09-01 04:16:00 | AAPL | Stock | 27.4925 | 27.4925 | 27.4925 | 27.4925 | 400.0 |
| 2015-09-01 04:17:00 | AAPL | Stock | 27.4925 | 27.54 | 27.4925 | 27.54 | 10000.0 |
| 2015-09-01 04:18:00 | AAPL | Stock | 27.5375 | 27.5375 | 27.5375 | 27.5375 | 2000.0 |
| 2015-09-01 04:23:00 | AAPL | Stock | 27.5 | 27.5 | 27.5 | 27.5 | 400.0 |
| 2015-09-01 04:24:00 | AAPL | Stock | 27.5 | 27.5 | 27.5 | 27.5 | 400.0 |
| 2015-09-01 04:29:00 | AAPL | Stock | 27.52 | 27.52 | 27.52 | 27.52 | 400.0 |
| 2015-09-01 04:31:00 | AAPL | Stock | 27.45 | 27.45 | 27.45 | 27.45 | 4000.0 |
| 2015-09-01 04:32:00 | AAPL | Stock | 27.445 | 27.445 | 27.445 | 27.445 | 800.0 |
| 2015-09-01 04:38:00 | AAPL | Stock | 27.45 | 27.45 | 27.435 | 27.435 | 2980.0 |
| 2015-09-01 04:39:00 | AAPL | Stock | 27.425 | 27.4475 | 27.425 | 27.4475 | 2400.0 |
| 2015-09-01 04:41:00 | AAPL | Stock | 27.4 | 27.4 | 27.4 | 27.4 | 5200.0 |
| 2015-09-01 04:45:00 | AAPL | Stock | 27.425 | 27.425 | 27.425 | 27.425 | 5000.0 |
| 2015-09-01 04:46:00 | AAPL | Stock | 27.425 | 27.4375 | 27.425 | 27.4375 | 8800.0 |
| 2015-09-01 04:49:00 | AAPL | Stock | 27.445 | 27.445 | 27.445 | 27.445 | 800.0 |
| 2015-09-01 04:56:00 | AAPL | Stock | 27.445 | 27.445 | 27.445 | 27.445 | 400.0 |
| 2015-09-01 05:01:00 | AAPL | Stock | 27.445 | 27.445 | 27.445 | 27.445 | 992.0 |
| 2015-09-01 05:02:00 | AAPL | Stock | 27.485 | 27.5 | 27.485 | 27.5 | 4824.0 |
| 2015-09-01 05:03:00 | AAPL | Stock | 27.5 | 27.55 | 27.485 | 27.485 | 7200.0 |
| 2015-09-01 05:09:00 | AAPL | Stock | 27.5125 | 27.5125 | 27.5125 | 27.5125 | 2000.0 |
| 2015-09-01 05:10:00 | AAPL | Stock | 27.5725 | 27.575 | 27.5725 | 27.575 | 800.0 |
| 2015-09-01 05:11:00 | AAPL | Stock | 27.62 | 27.62 | 27.62 | 27.62 | 400.0 |
| 2015-09-01 05:12:00 | AAPL | Stock | 27.595 | 27.595 | 27.5875 | 27.5875 | 1200.0 |
| 2015-09-01 05:13:00 | AAPL | Stock | 27.5325 | 27.5325 | 27.5325 | 27.5325 | 400.0 |
| 2015-09-01 05:14:00 | AAPL | Stock | 27.53 | 27.53 | 27.53 | 27.53 | 1600.0 |
| 2015-09-01 05:24:00 | AAPL | Stock | 27.5325 | 27.5325 | 27.53 | 27.53 | 1212.0 |
| 2015-09-01 05:25:00 | AAPL | Stock | 27.53 | 27.53 | 27.53 | 27.53 | 4068.0 |
| 2015-09-01 05:26:00 | AAPL | Stock | 27.5 | 27.545 | 27.5 | 27.545 | 3184.0 |
| 2015-09-01 05:29:00 | AAPL | Stock | 27.545 | 27.545 | 27.545 | 27.545 | 2000.0 |
| 2015-09-01 05:31:00 | AAPL | Stock | 27.5425 | 27.5425 | 27.5425 | 27.5425 | 400.0 |
| 2015-09-01 05:32:00 | AAPL | Stock | 27.5 | 27.5 | 27.5 | 27.5 | 2800.0 |
| 2015-09-01 05:33:00 | AAPL | Stock | 27.5 | 27.5 | 27.5 | 27.5 | 2400.0 |
| 2015-09-01 05:34:00 | AAPL | Stock | 27.5 | 27.5025 | 27.5 | 27.5025 | 2560.0 |
| 2015-09-01 05:36:00 | AAPL | Stock | 27.5 | 27.5 | 27.5 | 27.5 | 2400.0 |
| 2015-09-01 05:41:00 | AAPL | Stock | 27.535 | 27.535 | 27.535 | 27.535 | 1600.0 |
| 2015-09-01 05:42:00 | AAPL | Stock | 27.4975 | 27.5475 | 27.4975 | 27.5475 | 5200.0 |
| 2015-09-01 05:44:00 | AAPL | Stock | 27.5 | 27.5 | 27.5 | 27.5 | 32000.0 |
| 2015-09-01 05:46:00 | AAPL | Stock | 27.5025 | 27.505 | 27.5 | 27.5 | 9800.0 |
| 2015-09-01 05:48:00 | AAPL | Stock | 27.505 | 27.575 | 27.5 | 27.575 | 3600.0 |
| 2015-09-01 05:49:00 | AAPL | Stock | 27.575 | 27.575 | 27.575 | 27.575 | 2400.0 |
> showing 50 of 1,148,733 rows — these rows as CSV