PREVIEW / stock_1min / 2020-08-17
file: by_date/stock_1min/2020/2020-08-17.parquet size: 19.9 MB rows: 1,238,982 symbols: 2,067
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 |
|---|---|---|---|---|---|---|---|
| 2020-08-17 04:03:00 | AAPL | Stock | 115.6 | 115.6 | 115.6 | 115.6 | 828.0 |
| 2020-08-17 04:04:00 | AAPL | Stock | 115.575 | 115.575 | 115.5 | 115.5 | 3508.0 |
| 2020-08-17 04:05:00 | AAPL | Stock | 115.45 | 115.45 | 115.45 | 115.45 | 800.0 |
| 2020-08-17 04:06:00 | AAPL | Stock | 115.59 | 115.59 | 115.59 | 115.59 | 400.0 |
| 2020-08-17 04:07:00 | AAPL | Stock | 115.5375 | 115.5375 | 115.5375 | 115.5375 | 3800.0 |
| 2020-08-17 04:08:00 | AAPL | Stock | 115.5375 | 115.5375 | 115.5375 | 115.5375 | 400.0 |
| 2020-08-17 04:15:00 | AAPL | Stock | 115.5 | 115.5 | 115.5 | 115.5 | 400.0 |
| 2020-08-17 04:26:00 | AAPL | Stock | 115.5025 | 115.5025 | 115.5025 | 115.5025 | 400.0 |
| 2020-08-17 04:33:00 | AAPL | Stock | 115.4825 | 115.4825 | 115.45 | 115.45 | 1292.0 |
| 2020-08-17 04:34:00 | AAPL | Stock | 115.535 | 115.535 | 115.535 | 115.535 | 400.0 |
| 2020-08-17 04:37:00 | AAPL | Stock | 115.5225 | 115.5225 | 115.5225 | 115.5225 | 400.0 |
| 2020-08-17 04:43:00 | AAPL | Stock | 115.55 | 115.55 | 115.5025 | 115.5025 | 996.0 |
| 2020-08-17 04:46:00 | AAPL | Stock | 115.605 | 115.605 | 115.605 | 115.605 | 400.0 |
| 2020-08-17 04:47:00 | AAPL | Stock | 115.5925 | 115.5925 | 115.5925 | 115.5925 | 400.0 |
| 2020-08-17 04:52:00 | AAPL | Stock | 115.62 | 115.62 | 115.62 | 115.62 | 400.0 |
| 2020-08-17 04:53:00 | AAPL | Stock | 115.6225 | 115.6225 | 115.6 | 115.6 | 800.0 |
| 2020-08-17 05:05:00 | AAPL | Stock | 115.56 | 115.56 | 115.56 | 115.56 | 1540.0 |
| 2020-08-17 05:06:00 | AAPL | Stock | 115.56 | 115.56 | 115.56 | 115.56 | 400.0 |
| 2020-08-17 05:17:00 | AAPL | Stock | 115.575 | 115.5875 | 115.575 | 115.5875 | 2512.0 |
| 2020-08-17 05:20:00 | AAPL | Stock | 115.5525 | 115.5575 | 115.5525 | 115.5575 | 800.0 |
| 2020-08-17 05:21:00 | AAPL | Stock | 115.575 | 115.575 | 115.575 | 115.575 | 524.0 |
| 2020-08-17 05:32:00 | AAPL | Stock | 115.5625 | 115.58 | 115.5625 | 115.58 | 2000.0 |
| 2020-08-17 05:37:00 | AAPL | Stock | 115.5975 | 115.5975 | 115.5975 | 115.5975 | 400.0 |
| 2020-08-17 05:39:00 | AAPL | Stock | 115.565 | 115.565 | 115.565 | 115.565 | 400.0 |
| 2020-08-17 05:43:00 | AAPL | Stock | 115.5625 | 115.5625 | 115.5625 | 115.5625 | 1200.0 |
| 2020-08-17 05:46:00 | AAPL | Stock | 115.5625 | 115.5625 | 115.5625 | 115.5625 | 400.0 |
| 2020-08-17 05:52:00 | AAPL | Stock | 115.5925 | 115.6 | 115.5925 | 115.5925 | 1600.0 |
| 2020-08-17 06:05:00 | AAPL | Stock | 115.6125 | 115.6125 | 115.6125 | 115.6125 | 1748.0 |
| 2020-08-17 06:08:00 | AAPL | Stock | 115.6325 | 115.6325 | 115.6325 | 115.6325 | 400.0 |
| 2020-08-17 06:09:00 | AAPL | Stock | 115.6325 | 115.6325 | 115.6325 | 115.6325 | 1060.0 |
| 2020-08-17 06:14:00 | AAPL | Stock | 115.6325 | 115.6325 | 115.6325 | 115.6325 | 800.0 |
| 2020-08-17 06:15:00 | AAPL | Stock | 115.6375 | 115.6375 | 115.6375 | 115.6375 | 584.0 |
| 2020-08-17 06:16:00 | AAPL | Stock | 115.6375 | 115.6375 | 115.6375 | 115.6375 | 808.0 |
| 2020-08-17 06:21:00 | AAPL | Stock | 115.65 | 115.65 | 115.65 | 115.65 | 400.0 |
| 2020-08-17 06:30:00 | AAPL | Stock | 115.6125 | 115.6125 | 115.6125 | 115.6125 | 1600.0 |
| 2020-08-17 06:34:00 | AAPL | Stock | 115.625 | 115.625 | 115.625 | 115.625 | 812.0 |
| 2020-08-17 06:45:00 | AAPL | Stock | 115.6275 | 115.6275 | 115.6275 | 115.6275 | 1364.0 |
| 2020-08-17 06:46:00 | AAPL | Stock | 115.615 | 115.615 | 115.6125 | 115.6125 | 3640.0 |
| 2020-08-17 06:52:00 | AAPL | Stock | 115.5825 | 115.5825 | 115.5775 | 115.5775 | 1568.0 |
| 2020-08-17 07:00:00 | AAPL | Stock | 115.6025 | 115.6125 | 115.53 | 115.5325 | 24828.0 |
| 2020-08-17 07:01:00 | AAPL | Stock | 115.535 | 115.5475 | 115.495 | 115.51 | 22064.0 |
| 2020-08-17 07:02:00 | AAPL | Stock | 115.515 | 115.5775 | 115.515 | 115.55 | 6160.0 |
| 2020-08-17 07:03:00 | AAPL | Stock | 115.5775 | 115.5775 | 115.5025 | 115.5475 | 4764.0 |
| 2020-08-17 07:04:00 | AAPL | Stock | 115.575 | 115.6075 | 115.575 | 115.6 | 3300.0 |
| 2020-08-17 07:05:00 | AAPL | Stock | 115.5575 | 115.5975 | 115.5475 | 115.5975 | 10428.0 |
| 2020-08-17 07:06:00 | AAPL | Stock | 115.5925 | 115.6125 | 115.5925 | 115.6125 | 27704.0 |
| 2020-08-17 07:07:00 | AAPL | Stock | 115.615 | 115.6325 | 115.615 | 115.615 | 16364.0 |
| 2020-08-17 07:08:00 | AAPL | Stock | 115.6225 | 115.6625 | 115.6225 | 115.6625 | 13252.0 |
| 2020-08-17 07:09:00 | AAPL | Stock | 115.645 | 115.645 | 115.645 | 115.645 | 400.0 |
| 2020-08-17 07:10:00 | AAPL | Stock | 115.6475 | 115.65 | 115.6375 | 115.6375 | 6100.0 |
> showing 50 of 1,238,982 rows — these rows as CSV