PREVIEW / stock_1min / 2019-07-02
file: by_date/stock_1min/2019/2019-07-02.parquet size: 15.4 MB rows: 1,098,078 symbols: 2,199
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-07-02 04:15:00 | AAPL | Stock | 50.3075 | 50.3075 | 50.3075 | 50.3075 | 800.0 |
| 2019-07-02 04:22:00 | AAPL | Stock | 50.3075 | 50.3075 | 50.3075 | 50.3075 | 400.0 |
| 2019-07-02 04:23:00 | AAPL | Stock | 50.3075 | 50.3075 | 50.3075 | 50.3075 | 400.0 |
| 2019-07-02 04:26:00 | AAPL | Stock | 50.3075 | 50.3075 | 50.3075 | 50.3075 | 756.0 |
| 2019-07-02 04:42:00 | AAPL | Stock | 50.2725 | 50.2725 | 50.26 | 50.26 | 1088.0 |
| 2019-07-02 04:45:00 | AAPL | Stock | 50.2275 | 50.2275 | 50.22 | 50.22 | 800.0 |
| 2019-07-02 04:53:00 | AAPL | Stock | 50.3 | 50.3 | 50.3 | 50.3 | 760.0 |
| 2019-07-02 04:55:00 | AAPL | Stock | 50.205 | 50.205 | 50.205 | 50.205 | 560.0 |
| 2019-07-02 05:14:00 | AAPL | Stock | 50.25 | 50.25 | 50.25 | 50.25 | 1400.0 |
| 2019-07-02 05:15:00 | AAPL | Stock | 50.25 | 50.25 | 50.25 | 50.25 | 400.0 |
| 2019-07-02 05:25:00 | AAPL | Stock | 50.25 | 50.25 | 50.25 | 50.25 | 1832.0 |
| 2019-07-02 05:36:00 | AAPL | Stock | 50.25 | 50.25 | 50.25 | 50.25 | 1200.0 |
| 2019-07-02 05:37:00 | AAPL | Stock | 50.25 | 50.25 | 50.25 | 50.25 | 1200.0 |
| 2019-07-02 05:40:00 | AAPL | Stock | 50.2475 | 50.25 | 50.2475 | 50.25 | 1000.0 |
| 2019-07-02 05:41:00 | AAPL | Stock | 50.25 | 50.25 | 50.25 | 50.25 | 600.0 |
| 2019-07-02 05:46:00 | AAPL | Stock | 50.25 | 50.25 | 50.25 | 50.25 | 1888.0 |
| 2019-07-02 05:48:00 | AAPL | Stock | 50.25 | 50.25 | 50.25 | 50.25 | 2736.0 |
| 2019-07-02 05:49:00 | AAPL | Stock | 50.2425 | 50.2425 | 50.2425 | 50.2425 | 400.0 |
| 2019-07-02 05:53:00 | AAPL | Stock | 50.2175 | 50.2175 | 50.2175 | 50.2175 | 1360.0 |
| 2019-07-02 06:02:00 | AAPL | Stock | 50.19 | 50.19 | 50.125 | 50.125 | 2200.0 |
| 2019-07-02 06:31:00 | AAPL | Stock | 50.1825 | 50.1825 | 50.1825 | 50.1825 | 400.0 |
| 2019-07-02 06:46:00 | AAPL | Stock | 50.2 | 50.2 | 50.2 | 50.2 | 1200.0 |
| 2019-07-02 06:47:00 | AAPL | Stock | 50.2 | 50.2 | 50.2 | 50.2 | 400.0 |
| 2019-07-02 07:00:00 | AAPL | Stock | 50.245 | 50.295 | 50.245 | 50.295 | 5860.0 |
| 2019-07-02 07:01:00 | AAPL | Stock | 50.3 | 50.3 | 50.3 | 50.3 | 400.0 |
| 2019-07-02 07:05:00 | AAPL | Stock | 50.26 | 50.26 | 50.26 | 50.26 | 1600.0 |
| 2019-07-02 07:07:00 | AAPL | Stock | 50.2875 | 50.2925 | 50.25 | 50.25 | 18780.0 |
| 2019-07-02 07:08:00 | AAPL | Stock | 50.25 | 50.25 | 50.25 | 50.25 | 400.0 |
| 2019-07-02 07:10:00 | AAPL | Stock | 50.275 | 50.275 | 50.25 | 50.25 | 4400.0 |
| 2019-07-02 07:14:00 | AAPL | Stock | 50.25 | 50.25 | 50.25 | 50.25 | 2000.0 |
| 2019-07-02 07:17:00 | AAPL | Stock | 50.25 | 50.25 | 50.25 | 50.25 | 1600.0 |
| 2019-07-02 07:19:00 | AAPL | Stock | 50.25 | 50.25 | 50.2475 | 50.2475 | 14552.0 |
| 2019-07-02 07:20:00 | AAPL | Stock | 50.23 | 50.2325 | 50.23 | 50.2325 | 800.0 |
| 2019-07-02 07:23:00 | AAPL | Stock | 50.2075 | 50.2075 | 50.205 | 50.205 | 1996.0 |
| 2019-07-02 07:24:00 | AAPL | Stock | 50.2175 | 50.2175 | 50.2175 | 50.2175 | 400.0 |
| 2019-07-02 07:28:00 | AAPL | Stock | 50.205 | 50.205 | 50.2025 | 50.2025 | 1892.0 |
| 2019-07-02 07:34:00 | AAPL | Stock | 50.2025 | 50.2025 | 50.2025 | 50.2025 | 800.0 |
| 2019-07-02 07:35:00 | AAPL | Stock | 50.2225 | 50.2225 | 50.2225 | 50.2225 | 400.0 |
| 2019-07-02 07:41:00 | AAPL | Stock | 50.215 | 50.215 | 50.2025 | 50.2025 | 10800.0 |
| 2019-07-02 07:45:00 | AAPL | Stock | 50.225 | 50.225 | 50.225 | 50.225 | 1216.0 |
| 2019-07-02 07:48:00 | AAPL | Stock | 50.21 | 50.21 | 50.21 | 50.21 | 400.0 |
| 2019-07-02 07:50:00 | AAPL | Stock | 50.225 | 50.2325 | 50.225 | 50.2325 | 888.0 |
| 2019-07-02 07:59:00 | AAPL | Stock | 50.2475 | 50.25 | 50.2475 | 50.25 | 1840.0 |
| 2019-07-02 08:00:00 | AAPL | Stock | 50.25 | 50.31 | 50.2 | 50.2875 | 21580.0 |
| 2019-07-02 08:01:00 | AAPL | Stock | 50.245 | 50.245 | 50.245 | 50.245 | 400.0 |
| 2019-07-02 08:05:00 | AAPL | Stock | 50.2125 | 50.2125 | 50.2125 | 50.2125 | 400.0 |
| 2019-07-02 08:09:00 | AAPL | Stock | 50.2128 | 50.2488 | 50.2128 | 50.2488 | 4400.0 |
| 2019-07-02 08:11:00 | AAPL | Stock | 50.245 | 50.25 | 50.245 | 50.25 | 1360.0 |
| 2019-07-02 08:13:00 | AAPL | Stock | 50.2138 | 50.2138 | 50.2138 | 50.2138 | 800.0 |
| 2019-07-02 08:15:00 | AAPL | Stock | 50.2275 | 50.2275 | 50.2275 | 50.2275 | 780.0 |
> showing 50 of 1,098,078 rows — these rows as CSV