PREVIEW / stock_1min / 2019-09-19
file: by_date/stock_1min/2019/2019-09-19.parquet size: 15.7 MB rows: 1,111,625 symbols: 2,152
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 |
|---|---|---|---|---|---|---|---|
| 2019-09-19 04:00:00 | AAPL | Stock | 55.54 | 55.54 | 55.54 | 55.54 | 600.0 |
| 2019-09-19 04:02:00 | AAPL | Stock | 55.5875 | 55.5875 | 55.5875 | 55.5875 | 400.0 |
| 2019-09-19 04:10:00 | AAPL | Stock | 55.5025 | 55.5025 | 55.5025 | 55.5025 | 400.0 |
| 2019-09-19 04:15:00 | AAPL | Stock | 55.5275 | 55.5275 | 55.5275 | 55.5275 | 1236.0 |
| 2019-09-19 04:18:00 | AAPL | Stock | 55.5 | 55.5 | 55.5 | 55.5 | 2788.0 |
| 2019-09-19 04:19:00 | AAPL | Stock | 55.5 | 55.5 | 55.5 | 55.5 | 400.0 |
| 2019-09-19 04:21:00 | AAPL | Stock | 55.5275 | 55.5275 | 55.5275 | 55.5275 | 400.0 |
| 2019-09-19 04:24:00 | AAPL | Stock | 55.5425 | 55.5425 | 55.5425 | 55.5425 | 2000.0 |
| 2019-09-19 04:25:00 | AAPL | Stock | 55.5475 | 55.55 | 55.5475 | 55.55 | 6464.0 |
| 2019-09-19 04:26:00 | AAPL | Stock | 55.55 | 55.55 | 55.55 | 55.55 | 2000.0 |
| 2019-09-19 04:37:00 | AAPL | Stock | 55.5475 | 55.55 | 55.5475 | 55.55 | 1600.0 |
| 2019-09-19 04:38:00 | AAPL | Stock | 55.55 | 55.55 | 55.55 | 55.55 | 400.0 |
| 2019-09-19 04:43:00 | AAPL | Stock | 55.55 | 55.55 | 55.55 | 55.55 | 1200.0 |
| 2019-09-19 04:44:00 | AAPL | Stock | 55.5975 | 55.5975 | 55.5975 | 55.5975 | 400.0 |
| 2019-09-19 04:51:00 | AAPL | Stock | 55.595 | 55.6075 | 55.595 | 55.6075 | 2440.0 |
| 2019-09-19 04:52:00 | AAPL | Stock | 55.5625 | 55.565 | 55.5625 | 55.565 | 800.0 |
| 2019-09-19 04:53:00 | AAPL | Stock | 55.5275 | 55.5275 | 55.5275 | 55.5275 | 876.0 |
| 2019-09-19 05:41:00 | AAPL | Stock | 55.55 | 55.55 | 55.55 | 55.55 | 756.0 |
| 2019-09-19 06:07:00 | AAPL | Stock | 55.525 | 55.525 | 55.525 | 55.525 | 1200.0 |
| 2019-09-19 06:09:00 | AAPL | Stock | 55.525 | 55.525 | 55.525 | 55.525 | 800.0 |
| 2019-09-19 06:14:00 | AAPL | Stock | 55.48 | 55.48 | 55.48 | 55.48 | 400.0 |
| 2019-09-19 06:19:00 | AAPL | Stock | 55.48 | 55.48 | 55.48 | 55.48 | 2800.0 |
| 2019-09-19 06:21:00 | AAPL | Stock | 55.5225 | 55.5225 | 55.5225 | 55.5225 | 400.0 |
| 2019-09-19 06:35:00 | AAPL | Stock | 55.4375 | 55.4375 | 55.435 | 55.435 | 800.0 |
| 2019-09-19 06:48:00 | AAPL | Stock | 55.4625 | 55.4625 | 55.4625 | 55.4625 | 12000.0 |
| 2019-09-19 06:57:00 | AAPL | Stock | 55.465 | 55.465 | 55.465 | 55.465 | 2000.0 |
| 2019-09-19 07:00:00 | AAPL | Stock | 55.4825 | 55.495 | 55.45 | 55.45 | 10492.0 |
| 2019-09-19 07:01:00 | AAPL | Stock | 55.4525 | 55.485 | 55.45 | 55.485 | 5640.0 |
| 2019-09-19 07:02:00 | AAPL | Stock | 55.45 | 55.45 | 55.4475 | 55.4475 | 4736.0 |
| 2019-09-19 07:03:00 | AAPL | Stock | 55.45 | 55.45 | 55.45 | 55.45 | 1504.0 |
| 2019-09-19 07:04:00 | AAPL | Stock | 55.4625 | 55.4625 | 55.45 | 55.45 | 2940.0 |
| 2019-09-19 07:07:00 | AAPL | Stock | 55.4625 | 55.4625 | 55.46 | 55.46 | 10600.0 |
| 2019-09-19 07:08:00 | AAPL | Stock | 55.46 | 55.46 | 55.46 | 55.46 | 400.0 |
| 2019-09-19 07:09:00 | AAPL | Stock | 55.46 | 55.5025 | 55.46 | 55.5 | 34216.0 |
| 2019-09-19 07:10:00 | AAPL | Stock | 55.5 | 55.5 | 55.5 | 55.5 | 3600.0 |
| 2019-09-19 07:11:00 | AAPL | Stock | 55.5 | 55.505 | 55.5 | 55.505 | 11088.0 |
| 2019-09-19 07:13:00 | AAPL | Stock | 55.5025 | 55.5025 | 55.5 | 55.5 | 7860.0 |
| 2019-09-19 07:14:00 | AAPL | Stock | 55.5 | 55.5 | 55.5 | 55.5 | 7080.0 |
| 2019-09-19 07:15:00 | AAPL | Stock | 55.525 | 55.525 | 55.525 | 55.525 | 400.0 |
| 2019-09-19 07:16:00 | AAPL | Stock | 55.505 | 55.505 | 55.505 | 55.505 | 400.0 |
| 2019-09-19 07:17:00 | AAPL | Stock | 55.505 | 55.505 | 55.5 | 55.5 | 15328.0 |
| 2019-09-19 07:18:00 | AAPL | Stock | 55.5375 | 55.5375 | 55.5375 | 55.5375 | 400.0 |
| 2019-09-19 07:19:00 | AAPL | Stock | 55.5375 | 55.5375 | 55.5375 | 55.5375 | 972.0 |
| 2019-09-19 07:22:00 | AAPL | Stock | 55.55 | 55.55 | 55.55 | 55.55 | 1444.0 |
| 2019-09-19 07:24:00 | AAPL | Stock | 55.5125 | 55.5125 | 55.5125 | 55.5125 | 1164.0 |
| 2019-09-19 07:27:00 | AAPL | Stock | 55.55 | 55.5625 | 55.55 | 55.5625 | 4704.0 |
| 2019-09-19 07:29:00 | AAPL | Stock | 55.565 | 55.5725 | 55.565 | 55.5725 | 1200.0 |
| 2019-09-19 07:30:00 | AAPL | Stock | 55.5725 | 55.5725 | 55.57 | 55.57 | 1160.0 |
| 2019-09-19 07:31:00 | AAPL | Stock | 55.5725 | 55.5725 | 55.57 | 55.57 | 800.0 |
| 2019-09-19 07:32:00 | AAPL | Stock | 55.5625 | 55.5625 | 55.5625 | 55.5625 | 528.0 |
> showing 50 of 1,111,625 rows — these rows as CSV