PREVIEW / stock_1min / 2019-12-24
file: by_date/stock_1min/2019/2019-12-24.parquet size: 8.8 MB rows: 592,032 symbols: 2,040
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-12-24 04:00:00 | AAPL | Stock | 71.14 | 71.14 | 71.14 | 71.14 | 400.0 |
| 2019-12-24 04:15:00 | AAPL | Stock | 71.1625 | 71.1625 | 71.1625 | 71.1625 | 400.0 |
| 2019-12-24 04:47:00 | AAPL | Stock | 71.225 | 71.25 | 71.2175 | 71.2175 | 7740.0 |
| 2019-12-24 04:49:00 | AAPL | Stock | 71.3 | 71.3 | 71.3 | 71.3 | 1604.0 |
| 2019-12-24 04:50:00 | AAPL | Stock | 71.3 | 71.3 | 71.3 | 71.3 | 3200.0 |
| 2019-12-24 04:53:00 | AAPL | Stock | 71.3 | 71.3 | 71.3 | 71.3 | 1600.0 |
| 2019-12-24 05:01:00 | AAPL | Stock | 71.3 | 71.3 | 71.3 | 71.3 | 400.0 |
| 2019-12-24 05:30:00 | AAPL | Stock | 71.32 | 71.32 | 71.32 | 71.32 | 800.0 |
| 2019-12-24 05:49:00 | AAPL | Stock | 71.25 | 71.25 | 71.25 | 71.25 | 800.0 |
| 2019-12-24 06:29:00 | AAPL | Stock | 71.32 | 71.32 | 71.32 | 71.32 | 600.0 |
| 2019-12-24 06:44:00 | AAPL | Stock | 71.3 | 71.3 | 71.3 | 71.3 | 400.0 |
| 2019-12-24 06:55:00 | AAPL | Stock | 71.3 | 71.3 | 71.2975 | 71.2975 | 2772.0 |
| 2019-12-24 06:57:00 | AAPL | Stock | 71.2625 | 71.2625 | 71.2625 | 71.2625 | 7788.0 |
| 2019-12-24 07:00:00 | AAPL | Stock | 71.2825 | 71.2925 | 71.2 | 71.2475 | 21860.0 |
| 2019-12-24 07:01:00 | AAPL | Stock | 71.2475 | 71.2475 | 71.225 | 71.225 | 1600.0 |
| 2019-12-24 07:02:00 | AAPL | Stock | 71.225 | 71.225 | 71.2125 | 71.2125 | 3200.0 |
| 2019-12-24 07:04:00 | AAPL | Stock | 71.1825 | 71.1825 | 71.18 | 71.18 | 1040.0 |
| 2019-12-24 07:05:00 | AAPL | Stock | 71.18 | 71.2 | 71.18 | 71.2 | 3256.0 |
| 2019-12-24 07:07:00 | AAPL | Stock | 71.2125 | 71.2125 | 71.2 | 71.2 | 6800.0 |
| 2019-12-24 07:09:00 | AAPL | Stock | 71.1975 | 71.1975 | 71.1975 | 71.1975 | 1600.0 |
| 2019-12-24 07:11:00 | AAPL | Stock | 71.2 | 71.2 | 71.2 | 71.2 | 3600.0 |
| 2019-12-24 07:12:00 | AAPL | Stock | 71.2025 | 71.2025 | 71.2025 | 71.2025 | 1600.0 |
| 2019-12-24 07:13:00 | AAPL | Stock | 71.2025 | 71.2025 | 71.2 | 71.2025 | 4160.0 |
| 2019-12-24 07:14:00 | AAPL | Stock | 71.1875 | 71.1875 | 71.1875 | 71.1875 | 3200.0 |
| 2019-12-24 07:15:00 | AAPL | Stock | 71.1825 | 71.1825 | 71.1825 | 71.1825 | 400.0 |
| 2019-12-24 07:17:00 | AAPL | Stock | 71.175 | 71.175 | 71.1625 | 71.1625 | 13000.0 |
| 2019-12-24 07:18:00 | AAPL | Stock | 71.185 | 71.185 | 71.1625 | 71.185 | 1408.0 |
| 2019-12-24 07:20:00 | AAPL | Stock | 71.165 | 71.165 | 71.15 | 71.15 | 6188.0 |
| 2019-12-24 07:21:00 | AAPL | Stock | 71.16 | 71.1625 | 71.16 | 71.1625 | 8320.0 |
| 2019-12-24 07:23:00 | AAPL | Stock | 71.15 | 71.15 | 71.15 | 71.15 | 400.0 |
| 2019-12-24 07:27:00 | AAPL | Stock | 71.1625 | 71.1625 | 71.1625 | 71.1625 | 11052.0 |
| 2019-12-24 07:28:00 | AAPL | Stock | 71.1625 | 71.1625 | 71.1575 | 71.1575 | 4600.0 |
| 2019-12-24 07:29:00 | AAPL | Stock | 71.17 | 71.17 | 71.17 | 71.17 | 1200.0 |
| 2019-12-24 07:31:00 | AAPL | Stock | 71.18 | 71.18 | 71.18 | 71.18 | 400.0 |
| 2019-12-24 07:33:00 | AAPL | Stock | 71.175 | 71.175 | 71.1625 | 71.1625 | 2652.0 |
| 2019-12-24 07:35:00 | AAPL | Stock | 71.1425 | 71.1425 | 71.1375 | 71.1375 | 5428.0 |
| 2019-12-24 07:36:00 | AAPL | Stock | 71.1425 | 71.1425 | 71.1425 | 71.1425 | 800.0 |
| 2019-12-24 07:42:00 | AAPL | Stock | 71.1625 | 71.175 | 71.1625 | 71.1625 | 8200.0 |
| 2019-12-24 07:43:00 | AAPL | Stock | 71.1625 | 71.1625 | 71.1625 | 71.1625 | 1100.0 |
| 2019-12-24 07:44:00 | AAPL | Stock | 71.1625 | 71.175 | 71.1625 | 71.175 | 1200.0 |
| 2019-12-24 07:48:00 | AAPL | Stock | 71.17 | 71.17 | 71.17 | 71.17 | 1200.0 |
| 2019-12-24 07:49:00 | AAPL | Stock | 71.17 | 71.17 | 71.1625 | 71.1625 | 3804.0 |
| 2019-12-24 07:50:00 | AAPL | Stock | 71.17 | 71.1775 | 71.17 | 71.1775 | 3064.0 |
| 2019-12-24 07:52:00 | AAPL | Stock | 71.18 | 71.18 | 71.18 | 71.18 | 1600.0 |
| 2019-12-24 07:53:00 | AAPL | Stock | 71.18 | 71.18 | 71.18 | 71.18 | 3364.0 |
| 2019-12-24 07:54:00 | AAPL | Stock | 71.1775 | 71.18 | 71.1725 | 71.1725 | 4900.0 |
| 2019-12-24 07:55:00 | AAPL | Stock | 71.1725 | 71.1725 | 71.1725 | 71.1725 | 476.0 |
| 2019-12-24 07:56:00 | AAPL | Stock | 71.175 | 71.175 | 71.175 | 71.175 | 1320.0 |
| 2019-12-24 07:57:00 | AAPL | Stock | 71.1775 | 71.1825 | 71.1775 | 71.1825 | 4552.0 |
| 2019-12-24 07:59:00 | AAPL | Stock | 71.175 | 71.175 | 71.175 | 71.175 | 400.0 |
> showing 50 of 592,032 rows — these rows as CSV