PREVIEW / stock_1min / 2018-11-16
file: by_date/stock_1min/2018/2018-11-16.parquet size: 15.6 MB rows: 1,106,615 symbols: 2,300
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-11-16 04:00:00 | AAPL | Stock | 47.645 | 47.645 | 47.645 | 47.645 | 400.0 |
| 2018-11-16 04:11:00 | AAPL | Stock | 47.525 | 47.525 | 47.4775 | 47.505 | 3212.0 |
| 2018-11-16 04:12:00 | AAPL | Stock | 47.5 | 47.5 | 47.5 | 47.5 | 400.0 |
| 2018-11-16 04:15:00 | AAPL | Stock | 47.4925 | 47.505 | 47.4925 | 47.505 | 1392.0 |
| 2018-11-16 04:16:00 | AAPL | Stock | 47.505 | 47.505 | 47.505 | 47.505 | 800.0 |
| 2018-11-16 04:17:00 | AAPL | Stock | 47.5 | 47.525 | 47.5 | 47.525 | 6788.0 |
| 2018-11-16 04:20:00 | AAPL | Stock | 47.505 | 47.505 | 47.505 | 47.505 | 4264.0 |
| 2018-11-16 04:24:00 | AAPL | Stock | 47.5375 | 47.5375 | 47.5375 | 47.5375 | 1160.0 |
| 2018-11-16 04:28:00 | AAPL | Stock | 47.505 | 47.505 | 47.505 | 47.505 | 480.0 |
| 2018-11-16 04:31:00 | AAPL | Stock | 47.5725 | 47.5725 | 47.5725 | 47.5725 | 404.0 |
| 2018-11-16 04:34:00 | AAPL | Stock | 47.595 | 47.625 | 47.595 | 47.5975 | 8800.0 |
| 2018-11-16 05:01:00 | AAPL | Stock | 47.5325 | 47.5325 | 47.5325 | 47.5325 | 400.0 |
| 2018-11-16 05:03:00 | AAPL | Stock | 47.55 | 47.55 | 47.55 | 47.55 | 400.0 |
| 2018-11-16 05:28:00 | AAPL | Stock | 47.495 | 47.5 | 47.495 | 47.4975 | 6132.0 |
| 2018-11-16 05:29:00 | AAPL | Stock | 47.4975 | 47.4975 | 47.45 | 47.455 | 3796.0 |
| 2018-11-16 05:37:00 | AAPL | Stock | 47.475 | 47.475 | 47.475 | 47.475 | 2000.0 |
| 2018-11-16 05:45:00 | AAPL | Stock | 47.475 | 47.475 | 47.475 | 47.475 | 2000.0 |
| 2018-11-16 05:50:00 | AAPL | Stock | 47.475 | 47.475 | 47.45 | 47.45 | 2400.0 |
| 2018-11-16 05:51:00 | AAPL | Stock | 47.45 | 47.45 | 47.45 | 47.45 | 800.0 |
| 2018-11-16 05:57:00 | AAPL | Stock | 47.475 | 47.475 | 47.475 | 47.475 | 400.0 |
| 2018-11-16 06:06:00 | AAPL | Stock | 47.45 | 47.45 | 47.45 | 47.45 | 400.0 |
| 2018-11-16 06:07:00 | AAPL | Stock | 47.4375 | 47.4375 | 47.4375 | 47.4375 | 400.0 |
| 2018-11-16 06:09:00 | AAPL | Stock | 47.45 | 47.45 | 47.45 | 47.45 | 1204.0 |
| 2018-11-16 06:12:00 | AAPL | Stock | 47.475 | 47.475 | 47.475 | 47.475 | 1000.0 |
| 2018-11-16 06:13:00 | AAPL | Stock | 47.45 | 47.45 | 47.45 | 47.45 | 804.0 |
| 2018-11-16 06:19:00 | AAPL | Stock | 47.4375 | 47.4375 | 47.425 | 47.425 | 4600.0 |
| 2018-11-16 06:20:00 | AAPL | Stock | 47.41 | 47.41 | 47.41 | 47.41 | 800.0 |
| 2018-11-16 06:22:00 | AAPL | Stock | 47.4275 | 47.4375 | 47.4275 | 47.4375 | 800.0 |
| 2018-11-16 06:27:00 | AAPL | Stock | 47.4375 | 47.4375 | 47.4375 | 47.4375 | 1200.0 |
| 2018-11-16 06:44:00 | AAPL | Stock | 47.495 | 47.495 | 47.44 | 47.44 | 824.0 |
| 2018-11-16 06:46:00 | AAPL | Stock | 47.495 | 47.495 | 47.495 | 47.495 | 400.0 |
| 2018-11-16 06:47:00 | AAPL | Stock | 47.475 | 47.475 | 47.475 | 47.475 | 800.0 |
| 2018-11-16 06:48:00 | AAPL | Stock | 47.5 | 47.5 | 47.4375 | 47.4375 | 4800.0 |
| 2018-11-16 06:51:00 | AAPL | Stock | 47.5925 | 47.5925 | 47.495 | 47.5 | 6236.0 |
| 2018-11-16 07:00:00 | AAPL | Stock | 47.5 | 47.5 | 47.435 | 47.5 | 5328.0 |
| 2018-11-16 07:01:00 | AAPL | Stock | 47.485 | 47.485 | 47.485 | 47.485 | 800.0 |
| 2018-11-16 07:02:00 | AAPL | Stock | 47.4625 | 47.4625 | 47.4625 | 47.4625 | 400.0 |
| 2018-11-16 07:05:00 | AAPL | Stock | 47.4475 | 47.465 | 47.4475 | 47.465 | 1200.0 |
| 2018-11-16 07:06:00 | AAPL | Stock | 47.4475 | 47.4475 | 47.425 | 47.4275 | 11072.0 |
| 2018-11-16 07:07:00 | AAPL | Stock | 47.425 | 47.4375 | 47.42 | 47.42 | 2400.0 |
| 2018-11-16 07:08:00 | AAPL | Stock | 47.42 | 47.42 | 47.4075 | 47.4075 | 2000.0 |
| 2018-11-16 07:09:00 | AAPL | Stock | 47.4375 | 47.45 | 47.4375 | 47.45 | 1360.0 |
| 2018-11-16 07:10:00 | AAPL | Stock | 47.45 | 47.46 | 47.45 | 47.46 | 1200.0 |
| 2018-11-16 07:11:00 | AAPL | Stock | 47.475 | 47.5 | 47.475 | 47.5 | 1704.0 |
| 2018-11-16 07:12:00 | AAPL | Stock | 47.5 | 47.5625 | 47.5 | 47.5625 | 4000.0 |
| 2018-11-16 07:13:00 | AAPL | Stock | 47.505 | 47.505 | 47.505 | 47.505 | 3724.0 |
| 2018-11-16 07:15:00 | AAPL | Stock | 47.55 | 47.55 | 47.525 | 47.525 | 2400.0 |
| 2018-11-16 07:16:00 | AAPL | Stock | 47.505 | 47.54 | 47.5 | 47.5 | 4400.0 |
| 2018-11-16 07:17:00 | AAPL | Stock | 47.5075 | 47.5075 | 47.5025 | 47.5025 | 3164.0 |
| 2018-11-16 07:18:00 | AAPL | Stock | 47.4875 | 47.4925 | 47.4875 | 47.4925 | 8400.0 |
> showing 50 of 1,106,615 rows — these rows as CSV