PREVIEW / stock_1min / 2019-11-13
file: by_date/stock_1min/2019/2019-11-13.parquet size: 16.1 MB rows: 1,106,383 symbols: 2,130
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-11-13 04:00:00 | AAPL | Stock | 65.3675 | 65.3775 | 65.365 | 65.3775 | 2392.0 |
| 2019-11-13 04:01:00 | AAPL | Stock | 65.3 | 65.3 | 65.3 | 65.3 | 2124.0 |
| 2019-11-13 04:04:00 | AAPL | Stock | 65.3 | 65.3 | 65.155 | 65.155 | 1432.0 |
| 2019-11-13 04:05:00 | AAPL | Stock | 65.215 | 65.215 | 65.2 | 65.2 | 4396.0 |
| 2019-11-13 04:06:00 | AAPL | Stock | 65.2525 | 65.2875 | 65.2525 | 65.2525 | 1880.0 |
| 2019-11-13 04:08:00 | AAPL | Stock | 65.25 | 65.25 | 65.25 | 65.25 | 1200.0 |
| 2019-11-13 04:10:00 | AAPL | Stock | 65.2325 | 65.235 | 65.21 | 65.21 | 4400.0 |
| 2019-11-13 04:11:00 | AAPL | Stock | 65.235 | 65.235 | 65.235 | 65.235 | 2000.0 |
| 2019-11-13 04:13:00 | AAPL | Stock | 65.235 | 65.235 | 65.235 | 65.235 | 1092.0 |
| 2019-11-13 04:20:00 | AAPL | Stock | 65.2375 | 65.2375 | 65.2375 | 65.2375 | 4400.0 |
| 2019-11-13 04:27:00 | AAPL | Stock | 65.2 | 65.2 | 65.2 | 65.2 | 400.0 |
| 2019-11-13 04:34:00 | AAPL | Stock | 65.195 | 65.2 | 65.195 | 65.2 | 800.0 |
| 2019-11-13 04:36:00 | AAPL | Stock | 65.1525 | 65.1525 | 65.1525 | 65.1525 | 400.0 |
| 2019-11-13 04:40:00 | AAPL | Stock | 65.1 | 65.1 | 65.1 | 65.1 | 400.0 |
| 2019-11-13 04:42:00 | AAPL | Stock | 65.05 | 65.05 | 65.05 | 65.05 | 3688.0 |
| 2019-11-13 04:47:00 | AAPL | Stock | 65.055 | 65.055 | 65.0475 | 65.0475 | 26920.0 |
| 2019-11-13 04:48:00 | AAPL | Stock | 65.0475 | 65.0475 | 65.0475 | 65.0475 | 468.0 |
| 2019-11-13 04:50:00 | AAPL | Stock | 65.01 | 65.01 | 65.0075 | 65.0075 | 1500.0 |
| 2019-11-13 04:52:00 | AAPL | Stock | 65.0 | 65.0 | 65.0 | 65.0 | 848.0 |
| 2019-11-13 04:55:00 | AAPL | Stock | 65.0075 | 65.0375 | 65.0075 | 65.0375 | 1836.0 |
| 2019-11-13 04:59:00 | AAPL | Stock | 65.0375 | 65.0375 | 65.0375 | 65.0375 | 6884.0 |
| 2019-11-13 05:01:00 | AAPL | Stock | 65.085 | 65.085 | 65.085 | 65.085 | 1936.0 |
| 2019-11-13 05:02:00 | AAPL | Stock | 65.085 | 65.085 | 65.085 | 65.085 | 400.0 |
| 2019-11-13 05:03:00 | AAPL | Stock | 65.085 | 65.085 | 65.085 | 65.085 | 800.0 |
| 2019-11-13 05:06:00 | AAPL | Stock | 65.075 | 65.075 | 65.075 | 65.075 | 2000.0 |
| 2019-11-13 05:07:00 | AAPL | Stock | 65.1075 | 65.1075 | 65.105 | 65.1075 | 7328.0 |
| 2019-11-13 05:28:00 | AAPL | Stock | 65.145 | 65.145 | 65.145 | 65.145 | 1200.0 |
| 2019-11-13 05:30:00 | AAPL | Stock | 65.145 | 65.15 | 65.145 | 65.145 | 2616.0 |
| 2019-11-13 05:34:00 | AAPL | Stock | 65.125 | 65.125 | 65.125 | 65.125 | 1528.0 |
| 2019-11-13 05:41:00 | AAPL | Stock | 65.1 | 65.1 | 65.095 | 65.095 | 800.0 |
| 2019-11-13 05:58:00 | AAPL | Stock | 65.1275 | 65.1275 | 65.055 | 65.095 | 19840.0 |
| 2019-11-13 06:00:00 | AAPL | Stock | 65.1 | 65.1 | 65.075 | 65.075 | 19880.0 |
| 2019-11-13 06:08:00 | AAPL | Stock | 65.135 | 65.135 | 65.135 | 65.135 | 400.0 |
| 2019-11-13 06:10:00 | AAPL | Stock | 65.1125 | 65.1125 | 65.1125 | 65.1125 | 3576.0 |
| 2019-11-13 06:15:00 | AAPL | Stock | 65.1175 | 65.1175 | 65.1175 | 65.1175 | 1200.0 |
| 2019-11-13 06:21:00 | AAPL | Stock | 65.1125 | 65.1175 | 65.0325 | 65.1175 | 7872.0 |
| 2019-11-13 06:29:00 | AAPL | Stock | 65.135 | 65.135 | 65.135 | 65.135 | 1200.0 |
| 2019-11-13 06:36:00 | AAPL | Stock | 65.1325 | 65.1325 | 65.1325 | 65.1325 | 800.0 |
| 2019-11-13 06:38:00 | AAPL | Stock | 65.13 | 65.1325 | 65.13 | 65.1325 | 1464.0 |
| 2019-11-13 06:48:00 | AAPL | Stock | 65.135 | 65.135 | 65.135 | 65.135 | 400.0 |
| 2019-11-13 06:52:00 | AAPL | Stock | 65.1025 | 65.1025 | 65.1025 | 65.1025 | 3048.0 |
| 2019-11-13 07:00:00 | AAPL | Stock | 65.185 | 65.19 | 65.185 | 65.19 | 1284.0 |
| 2019-11-13 07:01:00 | AAPL | Stock | 65.1875 | 65.2025 | 65.1875 | 65.2025 | 4400.0 |
| 2019-11-13 07:02:00 | AAPL | Stock | 65.21 | 65.22 | 65.2075 | 65.22 | 21832.0 |
| 2019-11-13 07:03:00 | AAPL | Stock | 65.2475 | 65.25 | 65.2475 | 65.25 | 8244.0 |
| 2019-11-13 07:04:00 | AAPL | Stock | 65.225 | 65.225 | 65.1925 | 65.1925 | 5600.0 |
| 2019-11-13 07:05:00 | AAPL | Stock | 65.2425 | 65.2475 | 65.2225 | 65.2475 | 4400.0 |
| 2019-11-13 07:07:00 | AAPL | Stock | 65.2175 | 65.2175 | 65.19 | 65.19 | 5880.0 |
| 2019-11-13 07:12:00 | AAPL | Stock | 65.2375 | 65.2375 | 65.225 | 65.225 | 2524.0 |
| 2019-11-13 07:15:00 | AAPL | Stock | 65.2375 | 65.25 | 65.2375 | 65.25 | 9448.0 |
> showing 50 of 1,106,383 rows — these rows as CSV