PREVIEW / stock_1min / 2019-05-13
file: by_date/stock_1min/2019/2019-05-13.parquet size: 16.7 MB rows: 1,143,067 symbols: 2,203
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-05-13 04:00:00 | AAPL | Stock | 48.25 | 48.3 | 48.14 | 48.3 | 1988.0 |
| 2019-05-13 04:02:00 | AAPL | Stock | 48.2 | 48.2 | 48.2 | 48.2 | 1804.0 |
| 2019-05-13 04:05:00 | AAPL | Stock | 48.1275 | 48.2 | 48.1275 | 48.2 | 820.0 |
| 2019-05-13 04:06:00 | AAPL | Stock | 48.1075 | 48.1975 | 48.1075 | 48.1975 | 1200.0 |
| 2019-05-13 04:11:00 | AAPL | Stock | 48.18 | 48.18 | 48.18 | 48.18 | 400.0 |
| 2019-05-13 04:18:00 | AAPL | Stock | 48.2 | 48.2 | 48.2 | 48.2 | 1184.0 |
| 2019-05-13 04:19:00 | AAPL | Stock | 48.245 | 48.245 | 48.2 | 48.2 | 1200.0 |
| 2019-05-13 04:22:00 | AAPL | Stock | 48.25 | 48.27 | 48.25 | 48.27 | 13964.0 |
| 2019-05-13 04:23:00 | AAPL | Stock | 48.275 | 48.3175 | 48.25 | 48.3175 | 2400.0 |
| 2019-05-13 04:24:00 | AAPL | Stock | 48.25 | 48.25 | 48.25 | 48.25 | 800.0 |
| 2019-05-13 04:25:00 | AAPL | Stock | 48.2775 | 48.2775 | 48.2525 | 48.2525 | 1500.0 |
| 2019-05-13 04:29:00 | AAPL | Stock | 48.2525 | 48.2525 | 48.25 | 48.25 | 3884.0 |
| 2019-05-13 04:30:00 | AAPL | Stock | 48.25 | 48.25 | 48.25 | 48.25 | 516.0 |
| 2019-05-13 04:31:00 | AAPL | Stock | 48.2775 | 48.2775 | 48.2775 | 48.2775 | 1600.0 |
| 2019-05-13 04:32:00 | AAPL | Stock | 48.2775 | 48.2775 | 48.2775 | 48.2775 | 1200.0 |
| 2019-05-13 04:40:00 | AAPL | Stock | 48.3275 | 48.3275 | 48.3275 | 48.3275 | 400.0 |
| 2019-05-13 04:41:00 | AAPL | Stock | 48.325 | 48.325 | 48.325 | 48.325 | 400.0 |
| 2019-05-13 04:45:00 | AAPL | Stock | 48.3375 | 48.3375 | 48.3375 | 48.3375 | 800.0 |
| 2019-05-13 04:50:00 | AAPL | Stock | 48.2725 | 48.2725 | 48.25 | 48.25 | 2116.0 |
| 2019-05-13 04:57:00 | AAPL | Stock | 48.2425 | 48.2425 | 48.2 | 48.2 | 2420.0 |
| 2019-05-13 05:04:00 | AAPL | Stock | 48.3325 | 48.3375 | 48.3325 | 48.3375 | 1064.0 |
| 2019-05-13 05:05:00 | AAPL | Stock | 48.335 | 48.335 | 48.335 | 48.335 | 400.0 |
| 2019-05-13 05:08:00 | AAPL | Stock | 48.29 | 48.29 | 48.2875 | 48.2875 | 1200.0 |
| 2019-05-13 05:10:00 | AAPL | Stock | 48.2625 | 48.2625 | 48.25 | 48.25 | 800.0 |
| 2019-05-13 05:17:00 | AAPL | Stock | 48.25 | 48.25 | 48.25 | 48.25 | 400.0 |
| 2019-05-13 05:26:00 | AAPL | Stock | 48.21 | 48.21 | 48.205 | 48.205 | 1136.0 |
| 2019-05-13 05:27:00 | AAPL | Stock | 48.21 | 48.21 | 48.21 | 48.21 | 436.0 |
| 2019-05-13 05:28:00 | AAPL | Stock | 48.2475 | 48.2475 | 48.2475 | 48.2475 | 1404.0 |
| 2019-05-13 05:46:00 | AAPL | Stock | 48.25 | 48.255 | 48.25 | 48.255 | 23040.0 |
| 2019-05-13 05:48:00 | AAPL | Stock | 48.275 | 48.275 | 48.275 | 48.275 | 400.0 |
| 2019-05-13 05:50:00 | AAPL | Stock | 48.2675 | 48.2675 | 48.2675 | 48.2675 | 936.0 |
| 2019-05-13 06:04:00 | AAPL | Stock | 48.2875 | 48.2875 | 48.2875 | 48.2875 | 400.0 |
| 2019-05-13 06:11:00 | AAPL | Stock | 48.3125 | 48.3125 | 48.3125 | 48.3125 | 400.0 |
| 2019-05-13 06:18:00 | AAPL | Stock | 48.3 | 48.3 | 48.245 | 48.245 | 13120.0 |
| 2019-05-13 06:19:00 | AAPL | Stock | 48.225 | 48.225 | 48.2 | 48.2 | 2248.0 |
| 2019-05-13 06:26:00 | AAPL | Stock | 48.1625 | 48.1625 | 48.1625 | 48.1625 | 688.0 |
| 2019-05-13 06:27:00 | AAPL | Stock | 48.1625 | 48.1625 | 48.15 | 48.155 | 5000.0 |
| 2019-05-13 06:29:00 | AAPL | Stock | 48.16 | 48.16 | 48.1525 | 48.16 | 1588.0 |
| 2019-05-13 06:31:00 | AAPL | Stock | 48.2125 | 48.2125 | 48.2125 | 48.2125 | 400.0 |
| 2019-05-13 06:33:00 | AAPL | Stock | 48.165 | 48.165 | 48.15 | 48.15 | 4380.0 |
| 2019-05-13 06:34:00 | AAPL | Stock | 48.17 | 48.17 | 48.1625 | 48.1625 | 4156.0 |
| 2019-05-13 06:39:00 | AAPL | Stock | 48.21 | 48.21 | 48.21 | 48.21 | 400.0 |
| 2019-05-13 06:40:00 | AAPL | Stock | 48.1875 | 48.1875 | 48.12 | 48.12 | 10412.0 |
| 2019-05-13 06:41:00 | AAPL | Stock | 48.155 | 48.245 | 48.155 | 48.245 | 5240.0 |
| 2019-05-13 06:43:00 | AAPL | Stock | 48.1775 | 48.2025 | 48.1775 | 48.2025 | 1200.0 |
| 2019-05-13 06:45:00 | AAPL | Stock | 48.115 | 48.115 | 48.115 | 48.115 | 800.0 |
| 2019-05-13 06:48:00 | AAPL | Stock | 48.1775 | 48.185 | 48.1775 | 48.185 | 1604.0 |
| 2019-05-13 06:50:00 | AAPL | Stock | 48.1525 | 48.1975 | 48.1525 | 48.1975 | 4340.0 |
| 2019-05-13 06:52:00 | AAPL | Stock | 48.2125 | 48.2125 | 48.2125 | 48.2125 | 452.0 |
| 2019-05-13 06:56:00 | AAPL | Stock | 48.21 | 48.2125 | 48.21 | 48.2125 | 800.0 |
> showing 50 of 1,143,067 rows — these rows as CSV