PREVIEW / stock_1min / 2018-09-19
file: by_date/stock_1min/2018/2018-09-19.parquet size: 15.0 MB rows: 1,072,600 symbols: 2,323
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-09-19 04:00:00 | AAPL | Stock | 54.625 | 54.625 | 54.625 | 54.625 | 2000.0 |
| 2018-09-19 04:01:00 | AAPL | Stock | 54.625 | 54.625 | 54.625 | 54.625 | 400.0 |
| 2018-09-19 04:09:00 | AAPL | Stock | 54.6825 | 54.6825 | 54.6825 | 54.6825 | 480.0 |
| 2018-09-19 04:13:00 | AAPL | Stock | 54.6825 | 54.6825 | 54.6825 | 54.6825 | 7024.0 |
| 2018-09-19 04:58:00 | AAPL | Stock | 54.6625 | 54.6625 | 54.6625 | 54.6625 | 400.0 |
| 2018-09-19 05:40:00 | AAPL | Stock | 54.6475 | 54.6475 | 54.6475 | 54.6475 | 400.0 |
| 2018-09-19 05:43:00 | AAPL | Stock | 54.6475 | 54.6475 | 54.6475 | 54.6475 | 800.0 |
| 2018-09-19 06:00:00 | AAPL | Stock | 54.65 | 54.65 | 54.6475 | 54.6475 | 1200.0 |
| 2018-09-19 06:01:00 | AAPL | Stock | 54.6475 | 54.6475 | 54.6475 | 54.6475 | 6412.0 |
| 2018-09-19 06:06:00 | AAPL | Stock | 54.66 | 54.66 | 54.66 | 54.66 | 400.0 |
| 2018-09-19 06:07:00 | AAPL | Stock | 54.6475 | 54.6625 | 54.6475 | 54.6625 | 2984.0 |
| 2018-09-19 06:09:00 | AAPL | Stock | 54.6575 | 54.6575 | 54.6575 | 54.6575 | 400.0 |
| 2018-09-19 06:10:00 | AAPL | Stock | 54.6725 | 54.6725 | 54.6725 | 54.6725 | 400.0 |
| 2018-09-19 06:15:00 | AAPL | Stock | 54.675 | 54.675 | 54.675 | 54.675 | 800.0 |
| 2018-09-19 06:16:00 | AAPL | Stock | 54.7 | 54.71 | 54.64 | 54.64 | 4548.0 |
| 2018-09-19 06:49:00 | AAPL | Stock | 54.6725 | 54.6725 | 54.6725 | 54.6725 | 464.0 |
| 2018-09-19 07:00:00 | AAPL | Stock | 54.685 | 54.71 | 54.675 | 54.675 | 8660.0 |
| 2018-09-19 07:01:00 | AAPL | Stock | 54.675 | 54.6875 | 54.6725 | 54.6725 | 4840.0 |
| 2018-09-19 07:02:00 | AAPL | Stock | 54.675 | 54.675 | 54.6625 | 54.6625 | 4800.0 |
| 2018-09-19 07:03:00 | AAPL | Stock | 54.6625 | 54.6625 | 54.65 | 54.65 | 800.0 |
| 2018-09-19 07:04:00 | AAPL | Stock | 54.65 | 54.6625 | 54.65 | 54.6625 | 5588.0 |
| 2018-09-19 07:05:00 | AAPL | Stock | 54.645 | 54.69 | 54.63 | 54.6875 | 15280.0 |
| 2018-09-19 07:06:00 | AAPL | Stock | 54.635 | 54.635 | 54.6325 | 54.635 | 6836.0 |
| 2018-09-19 07:07:00 | AAPL | Stock | 54.6325 | 54.6325 | 54.6 | 54.6 | 8216.0 |
| 2018-09-19 07:08:00 | AAPL | Stock | 54.6 | 54.6625 | 54.6 | 54.6625 | 2400.0 |
| 2018-09-19 07:09:00 | AAPL | Stock | 54.6075 | 54.6075 | 54.6025 | 54.6025 | 3600.0 |
| 2018-09-19 07:10:00 | AAPL | Stock | 54.6425 | 54.65 | 54.6425 | 54.65 | 3504.0 |
| 2018-09-19 07:11:00 | AAPL | Stock | 54.65 | 54.65 | 54.65 | 54.65 | 400.0 |
| 2018-09-19 07:13:00 | AAPL | Stock | 54.6325 | 54.6325 | 54.6125 | 54.6125 | 3200.0 |
| 2018-09-19 07:14:00 | AAPL | Stock | 54.6125 | 54.6125 | 54.6 | 54.6 | 2520.0 |
| 2018-09-19 07:15:00 | AAPL | Stock | 54.5925 | 54.6175 | 54.5925 | 54.6175 | 5156.0 |
| 2018-09-19 07:21:00 | AAPL | Stock | 54.6225 | 54.625 | 54.6225 | 54.625 | 936.0 |
| 2018-09-19 07:24:00 | AAPL | Stock | 54.65 | 54.65 | 54.65 | 54.65 | 400.0 |
| 2018-09-19 07:26:00 | AAPL | Stock | 54.65 | 54.65 | 54.625 | 54.625 | 1600.0 |
| 2018-09-19 07:28:00 | AAPL | Stock | 54.6 | 54.6 | 54.6 | 54.6 | 800.0 |
| 2018-09-19 07:33:00 | AAPL | Stock | 54.6 | 54.6 | 54.6 | 54.6 | 544.0 |
| 2018-09-19 07:34:00 | AAPL | Stock | 54.59 | 54.59 | 54.575 | 54.575 | 1600.0 |
| 2018-09-19 07:36:00 | AAPL | Stock | 54.57 | 54.575 | 54.57 | 54.575 | 1200.0 |
| 2018-09-19 07:37:00 | AAPL | Stock | 54.5725 | 54.5725 | 54.53 | 54.53 | 5584.0 |
| 2018-09-19 07:38:00 | AAPL | Stock | 54.5275 | 54.5275 | 54.5275 | 54.5275 | 552.0 |
| 2018-09-19 07:39:00 | AAPL | Stock | 54.5375 | 54.5375 | 54.5375 | 54.5375 | 400.0 |
| 2018-09-19 07:40:00 | AAPL | Stock | 54.54 | 54.54 | 54.54 | 54.54 | 1192.0 |
| 2018-09-19 07:41:00 | AAPL | Stock | 54.5425 | 54.5425 | 54.5425 | 54.5425 | 400.0 |
| 2018-09-19 07:43:00 | AAPL | Stock | 54.55 | 54.55 | 54.55 | 54.55 | 800.0 |
| 2018-09-19 07:51:00 | AAPL | Stock | 54.5525 | 54.5525 | 54.55 | 54.5525 | 1200.0 |
| 2018-09-19 07:52:00 | AAPL | Stock | 54.54 | 54.55 | 54.54 | 54.55 | 1408.0 |
| 2018-09-19 07:53:00 | AAPL | Stock | 54.5275 | 54.5275 | 54.5275 | 54.5275 | 400.0 |
| 2018-09-19 07:55:00 | AAPL | Stock | 54.525 | 54.525 | 54.525 | 54.525 | 400.0 |
| 2018-09-19 07:58:00 | AAPL | Stock | 54.5275 | 54.5275 | 54.5275 | 54.5275 | 400.0 |
| 2018-09-19 07:59:00 | AAPL | Stock | 54.525 | 54.525 | 54.525 | 54.525 | 400.0 |
> showing 50 of 1,072,600 rows — these rows as CSV