PREVIEW / stock_1min / 2018-06-22
file: by_date/stock_1min/2018/2018-06-22.parquet size: 15.7 MB rows: 1,120,303 symbols: 2,346
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 |
|---|---|---|---|---|---|---|---|
| 2018-06-22 04:23:00 | AAPL | Stock | 46.45 | 46.45 | 46.45 | 46.45 | 800.0 |
| 2018-06-22 04:36:00 | AAPL | Stock | 46.45 | 46.4725 | 46.45 | 46.4725 | 1600.0 |
| 2018-06-22 05:10:00 | AAPL | Stock | 46.5125 | 46.5125 | 46.5125 | 46.5125 | 400.0 |
| 2018-06-22 05:13:00 | AAPL | Stock | 46.5125 | 46.5125 | 46.5125 | 46.5125 | 800.0 |
| 2018-06-22 06:04:00 | AAPL | Stock | 46.5175 | 46.5175 | 46.5175 | 46.5175 | 516.0 |
| 2018-06-22 06:33:00 | AAPL | Stock | 46.55 | 46.55 | 46.55 | 46.55 | 2000.0 |
| 2018-06-22 07:00:00 | AAPL | Stock | 46.625 | 46.625 | 46.625 | 46.625 | 444.0 |
| 2018-06-22 07:02:00 | AAPL | Stock | 46.5375 | 46.5375 | 46.5325 | 46.5325 | 3600.0 |
| 2018-06-22 07:06:00 | AAPL | Stock | 46.55 | 46.5625 | 46.55 | 46.5625 | 1520.0 |
| 2018-06-22 07:09:00 | AAPL | Stock | 46.5725 | 46.5725 | 46.5725 | 46.5725 | 1388.0 |
| 2018-06-22 07:10:00 | AAPL | Stock | 46.5925 | 46.5925 | 46.5925 | 46.5925 | 672.0 |
| 2018-06-22 07:12:00 | AAPL | Stock | 46.5375 | 46.5375 | 46.5375 | 46.5375 | 400.0 |
| 2018-06-22 07:13:00 | AAPL | Stock | 46.525 | 46.525 | 46.5175 | 46.5175 | 2132.0 |
| 2018-06-22 07:14:00 | AAPL | Stock | 46.5525 | 46.5575 | 46.5525 | 46.5575 | 12000.0 |
| 2018-06-22 07:21:00 | AAPL | Stock | 46.525 | 46.525 | 46.5125 | 46.5125 | 9664.0 |
| 2018-06-22 07:22:00 | AAPL | Stock | 46.5 | 46.525 | 46.5 | 46.525 | 3604.0 |
| 2018-06-22 07:23:00 | AAPL | Stock | 46.5575 | 46.5575 | 46.515 | 46.515 | 10400.0 |
| 2018-06-22 07:32:00 | AAPL | Stock | 46.525 | 46.525 | 46.525 | 46.525 | 400.0 |
| 2018-06-22 07:35:00 | AAPL | Stock | 46.5175 | 46.525 | 46.5175 | 46.525 | 3428.0 |
| 2018-06-22 07:38:00 | AAPL | Stock | 46.5075 | 46.5075 | 46.5075 | 46.5075 | 400.0 |
| 2018-06-22 07:40:00 | AAPL | Stock | 46.53 | 46.53 | 46.53 | 46.53 | 400.0 |
| 2018-06-22 07:42:00 | AAPL | Stock | 46.5075 | 46.515 | 46.5075 | 46.5075 | 2964.0 |
| 2018-06-22 07:46:00 | AAPL | Stock | 46.5 | 46.5 | 46.5 | 46.5 | 800.0 |
| 2018-06-22 07:49:00 | AAPL | Stock | 46.515 | 46.515 | 46.515 | 46.515 | 1720.0 |
| 2018-06-22 07:50:00 | AAPL | Stock | 46.515 | 46.5375 | 46.515 | 46.5375 | 4640.0 |
| 2018-06-22 07:51:00 | AAPL | Stock | 46.5375 | 46.5375 | 46.5375 | 46.5375 | 1600.0 |
| 2018-06-22 07:52:00 | AAPL | Stock | 46.5175 | 46.5175 | 46.5175 | 46.5175 | 400.0 |
| 2018-06-22 07:53:00 | AAPL | Stock | 46.525 | 46.525 | 46.525 | 46.525 | 4000.0 |
| 2018-06-22 07:54:00 | AAPL | Stock | 46.5375 | 46.5425 | 46.5375 | 46.5425 | 800.0 |
| 2018-06-22 08:00:00 | AAPL | Stock | 46.55 | 46.655 | 46.4825 | 46.5375 | 49660.0 |
| 2018-06-22 08:01:00 | AAPL | Stock | 46.5275 | 46.5275 | 46.505 | 46.505 | 3468.0 |
| 2018-06-22 08:02:00 | AAPL | Stock | 46.5275 | 46.555 | 46.5275 | 46.555 | 2664.0 |
| 2018-06-22 08:08:00 | AAPL | Stock | 46.5375 | 46.5375 | 46.5375 | 46.5375 | 660.0 |
| 2018-06-22 08:09:00 | AAPL | Stock | 46.525 | 46.525 | 46.525 | 46.525 | 520.0 |
| 2018-06-22 08:11:00 | AAPL | Stock | 46.5275 | 46.5275 | 46.52 | 46.5275 | 2200.0 |
| 2018-06-22 08:12:00 | AAPL | Stock | 46.515 | 46.52 | 46.515 | 46.52 | 5116.0 |
| 2018-06-22 08:13:00 | AAPL | Stock | 46.52 | 46.5275 | 46.515 | 46.515 | 4268.0 |
| 2018-06-22 08:14:00 | AAPL | Stock | 46.5175 | 46.5175 | 46.5175 | 46.5175 | 400.0 |
| 2018-06-22 08:15:00 | AAPL | Stock | 46.525 | 46.55 | 46.525 | 46.5475 | 15540.0 |
| 2018-06-22 08:17:00 | AAPL | Stock | 46.5325 | 46.55 | 46.53 | 46.535 | 7824.0 |
| 2018-06-22 08:18:00 | AAPL | Stock | 46.5475 | 46.55 | 46.5475 | 46.55 | 1864.0 |
| 2018-06-22 08:19:00 | AAPL | Stock | 46.55 | 46.55 | 46.55 | 46.55 | 3200.0 |
| 2018-06-22 08:20:00 | AAPL | Stock | 46.55 | 46.56 | 46.55 | 46.56 | 1600.0 |
| 2018-06-22 08:23:00 | AAPL | Stock | 46.565 | 46.57 | 46.565 | 46.57 | 856.0 |
| 2018-06-22 08:24:00 | AAPL | Stock | 46.575 | 46.6 | 46.575 | 46.6 | 4800.0 |
| 2018-06-22 08:25:00 | AAPL | Stock | 46.585 | 46.585 | 46.585 | 46.585 | 800.0 |
| 2018-06-22 08:26:00 | AAPL | Stock | 46.5775 | 46.58 | 46.5775 | 46.58 | 1200.0 |
| 2018-06-22 08:27:00 | AAPL | Stock | 46.575 | 46.5875 | 46.575 | 46.5875 | 4148.0 |
| 2018-06-22 08:28:00 | AAPL | Stock | 46.5775 | 46.5775 | 46.575 | 46.575 | 1200.0 |
| 2018-06-22 08:30:00 | AAPL | Stock | 46.5625 | 46.5625 | 46.5625 | 46.5625 | 400.0 |
> showing 50 of 1,120,303 rows — these rows as CSV