PREVIEW / stock_1min / 2019-09-16
file: by_date/stock_1min/2019/2019-09-16.parquet size: 16.2 MB rows: 1,142,282 symbols: 2,158
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-16 04:00:00 | AAPL | Stock | 54.3725 | 54.3725 | 54.0775 | 54.0775 | 14296.0 |
| 2019-09-16 04:08:00 | AAPL | Stock | 54.2 | 54.2 | 54.2 | 54.2 | 800.0 |
| 2019-09-16 04:09:00 | AAPL | Stock | 54.1775 | 54.1775 | 54.175 | 54.175 | 2000.0 |
| 2019-09-16 04:11:00 | AAPL | Stock | 54.175 | 54.175 | 54.175 | 54.175 | 2800.0 |
| 2019-09-16 04:15:00 | AAPL | Stock | 54.185 | 54.1875 | 54.185 | 54.1875 | 11984.0 |
| 2019-09-16 04:16:00 | AAPL | Stock | 54.215 | 54.215 | 54.215 | 54.215 | 400.0 |
| 2019-09-16 04:24:00 | AAPL | Stock | 54.1625 | 54.1625 | 54.1625 | 54.1625 | 2000.0 |
| 2019-09-16 04:25:00 | AAPL | Stock | 54.1375 | 54.1375 | 54.1375 | 54.1375 | 2392.0 |
| 2019-09-16 04:27:00 | AAPL | Stock | 54.115 | 54.115 | 54.1125 | 54.1125 | 14720.0 |
| 2019-09-16 04:33:00 | AAPL | Stock | 54.1375 | 54.1375 | 54.1375 | 54.1375 | 800.0 |
| 2019-09-16 04:36:00 | AAPL | Stock | 54.0975 | 54.0975 | 54.0975 | 54.0975 | 800.0 |
| 2019-09-16 04:37:00 | AAPL | Stock | 54.0925 | 54.0925 | 54.0925 | 54.0925 | 2240.0 |
| 2019-09-16 04:40:00 | AAPL | Stock | 54.0975 | 54.0975 | 54.0975 | 54.0975 | 4408.0 |
| 2019-09-16 04:42:00 | AAPL | Stock | 54.075 | 54.075 | 54.075 | 54.075 | 400.0 |
| 2019-09-16 04:46:00 | AAPL | Stock | 54.0975 | 54.0975 | 54.0975 | 54.0975 | 6800.0 |
| 2019-09-16 04:51:00 | AAPL | Stock | 54.1125 | 54.125 | 54.1125 | 54.125 | 8400.0 |
| 2019-09-16 04:52:00 | AAPL | Stock | 54.1275 | 54.1625 | 54.125 | 54.125 | 2800.0 |
| 2019-09-16 05:01:00 | AAPL | Stock | 54.1275 | 54.1275 | 54.1275 | 54.1275 | 400.0 |
| 2019-09-16 05:02:00 | AAPL | Stock | 54.15 | 54.15 | 54.15 | 54.15 | 17712.0 |
| 2019-09-16 05:03:00 | AAPL | Stock | 54.1525 | 54.1525 | 54.15 | 54.15 | 10640.0 |
| 2019-09-16 05:04:00 | AAPL | Stock | 54.1625 | 54.1625 | 54.1625 | 54.1625 | 2400.0 |
| 2019-09-16 05:07:00 | AAPL | Stock | 54.175 | 54.175 | 54.175 | 54.175 | 4000.0 |
| 2019-09-16 05:08:00 | AAPL | Stock | 54.21 | 54.21 | 54.21 | 54.21 | 400.0 |
| 2019-09-16 05:11:00 | AAPL | Stock | 54.18 | 54.18 | 54.1625 | 54.1625 | 23116.0 |
| 2019-09-16 05:12:00 | AAPL | Stock | 54.15 | 54.15 | 54.15 | 54.15 | 1124.0 |
| 2019-09-16 05:15:00 | AAPL | Stock | 54.1 | 54.1 | 54.1 | 54.1 | 2000.0 |
| 2019-09-16 05:26:00 | AAPL | Stock | 54.15 | 54.15 | 54.15 | 54.15 | 400.0 |
| 2019-09-16 05:27:00 | AAPL | Stock | 54.15 | 54.15 | 54.15 | 54.15 | 20000.0 |
| 2019-09-16 05:36:00 | AAPL | Stock | 54.1275 | 54.1275 | 54.0925 | 54.0925 | 2000.0 |
| 2019-09-16 05:40:00 | AAPL | Stock | 54.15 | 54.15 | 54.15 | 54.15 | 4000.0 |
| 2019-09-16 05:41:00 | AAPL | Stock | 54.1525 | 54.1525 | 54.15 | 54.15 | 9600.0 |
| 2019-09-16 05:45:00 | AAPL | Stock | 54.15 | 54.15 | 54.15 | 54.15 | 800.0 |
| 2019-09-16 06:02:00 | AAPL | Stock | 54.175 | 54.175 | 54.175 | 54.175 | 400.0 |
| 2019-09-16 06:03:00 | AAPL | Stock | 54.1625 | 54.1625 | 54.1625 | 54.1625 | 400.0 |
| 2019-09-16 06:04:00 | AAPL | Stock | 54.1875 | 54.2 | 54.1875 | 54.2 | 800.0 |
| 2019-09-16 06:05:00 | AAPL | Stock | 54.2 | 54.2 | 54.2 | 54.2 | 400.0 |
| 2019-09-16 06:06:00 | AAPL | Stock | 54.2 | 54.2 | 54.2 | 54.2 | 1600.0 |
| 2019-09-16 06:07:00 | AAPL | Stock | 54.2 | 54.2 | 54.2 | 54.2 | 400.0 |
| 2019-09-16 06:12:00 | AAPL | Stock | 54.1925 | 54.1925 | 54.1925 | 54.1925 | 400.0 |
| 2019-09-16 06:14:00 | AAPL | Stock | 54.225 | 54.265 | 54.225 | 54.265 | 6820.0 |
| 2019-09-16 06:15:00 | AAPL | Stock | 54.25 | 54.25 | 54.25 | 54.25 | 800.0 |
| 2019-09-16 06:22:00 | AAPL | Stock | 54.235 | 54.235 | 54.235 | 54.235 | 400.0 |
| 2019-09-16 06:23:00 | AAPL | Stock | 54.25 | 54.3075 | 54.25 | 54.255 | 2800.0 |
| 2019-09-16 06:25:00 | AAPL | Stock | 54.265 | 54.2875 | 54.25 | 54.2875 | 5200.0 |
| 2019-09-16 06:26:00 | AAPL | Stock | 54.31 | 54.31 | 54.31 | 54.31 | 400.0 |
| 2019-09-16 06:32:00 | AAPL | Stock | 54.295 | 54.295 | 54.2125 | 54.2125 | 3860.0 |
| 2019-09-16 06:33:00 | AAPL | Stock | 54.2675 | 54.2675 | 54.2675 | 54.2675 | 2000.0 |
| 2019-09-16 06:34:00 | AAPL | Stock | 54.25 | 54.25 | 54.25 | 54.25 | 400.0 |
| 2019-09-16 06:35:00 | AAPL | Stock | 54.28 | 54.28 | 54.28 | 54.28 | 400.0 |
| 2019-09-16 06:38:00 | AAPL | Stock | 54.215 | 54.2175 | 54.215 | 54.2175 | 1456.0 |
> showing 50 of 1,142,282 rows — these rows as CSV