PREVIEW / stock_1min / 2019-12-16
file: by_date/stock_1min/2019/2019-12-16.parquet size: 18.3 MB rows: 1,186,503 symbols: 2,135
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-16 04:00:00 | AAPL | Stock | 68.94 | 69.075 | 68.94 | 69.075 | 7288.0 |
| 2019-12-16 04:01:00 | AAPL | Stock | 69.0775 | 69.0775 | 69.075 | 69.075 | 4164.0 |
| 2019-12-16 04:05:00 | AAPL | Stock | 69.0925 | 69.0925 | 69.0925 | 69.0925 | 436.0 |
| 2019-12-16 04:11:00 | AAPL | Stock | 69.05 | 69.05 | 69.05 | 69.05 | 2872.0 |
| 2019-12-16 04:14:00 | AAPL | Stock | 69.05 | 69.0975 | 69.05 | 69.0975 | 4400.0 |
| 2019-12-16 04:20:00 | AAPL | Stock | 69.0975 | 69.0975 | 69.0975 | 69.0975 | 400.0 |
| 2019-12-16 04:21:00 | AAPL | Stock | 69.1125 | 69.1175 | 69.1125 | 69.1175 | 1636.0 |
| 2019-12-16 04:25:00 | AAPL | Stock | 69.13 | 69.1375 | 69.13 | 69.1375 | 3320.0 |
| 2019-12-16 04:27:00 | AAPL | Stock | 69.1475 | 69.1475 | 69.1475 | 69.1475 | 400.0 |
| 2019-12-16 04:34:00 | AAPL | Stock | 69.125 | 69.125 | 69.125 | 69.125 | 1100.0 |
| 2019-12-16 04:43:00 | AAPL | Stock | 69.165 | 69.165 | 69.165 | 69.165 | 776.0 |
| 2019-12-16 04:52:00 | AAPL | Stock | 69.15 | 69.15 | 69.15 | 69.15 | 1724.0 |
| 2019-12-16 04:53:00 | AAPL | Stock | 69.1875 | 69.1875 | 69.1875 | 69.1875 | 400.0 |
| 2019-12-16 04:56:00 | AAPL | Stock | 69.1625 | 69.1625 | 69.1625 | 69.1625 | 400.0 |
| 2019-12-16 04:59:00 | AAPL | Stock | 69.205 | 69.205 | 69.205 | 69.205 | 3960.0 |
| 2019-12-16 05:03:00 | AAPL | Stock | 69.1775 | 69.1775 | 69.1775 | 69.1775 | 1200.0 |
| 2019-12-16 05:15:00 | AAPL | Stock | 69.1375 | 69.1375 | 69.1375 | 69.1375 | 7400.0 |
| 2019-12-16 05:20:00 | AAPL | Stock | 69.115 | 69.115 | 69.115 | 69.115 | 400.0 |
| 2019-12-16 05:30:00 | AAPL | Stock | 69.115 | 69.115 | 69.115 | 69.115 | 8760.0 |
| 2019-12-16 05:31:00 | AAPL | Stock | 69.1 | 69.1 | 69.0875 | 69.0875 | 1200.0 |
| 2019-12-16 05:33:00 | AAPL | Stock | 69.1 | 69.1 | 69.1 | 69.1 | 6000.0 |
| 2019-12-16 05:42:00 | AAPL | Stock | 69.1 | 69.1 | 69.1 | 69.1 | 544.0 |
| 2019-12-16 05:44:00 | AAPL | Stock | 69.0875 | 69.0875 | 69.0875 | 69.0875 | 800.0 |
| 2019-12-16 05:52:00 | AAPL | Stock | 69.05 | 69.08 | 69.05 | 69.08 | 6400.0 |
| 2019-12-16 05:53:00 | AAPL | Stock | 69.08 | 69.0825 | 69.08 | 69.0825 | 1600.0 |
| 2019-12-16 05:58:00 | AAPL | Stock | 69.11 | 69.125 | 69.11 | 69.1125 | 3260.0 |
| 2019-12-16 06:02:00 | AAPL | Stock | 69.1325 | 69.1325 | 69.1325 | 69.1325 | 400.0 |
| 2019-12-16 06:06:00 | AAPL | Stock | 69.1625 | 69.1625 | 69.1625 | 69.1625 | 400.0 |
| 2019-12-16 06:07:00 | AAPL | Stock | 69.19 | 69.19 | 69.19 | 69.19 | 400.0 |
| 2019-12-16 06:13:00 | AAPL | Stock | 69.1375 | 69.1375 | 69.1125 | 69.1125 | 2400.0 |
| 2019-12-16 06:14:00 | AAPL | Stock | 69.1875 | 69.19 | 69.1875 | 69.19 | 1200.0 |
| 2019-12-16 06:17:00 | AAPL | Stock | 69.1675 | 69.17 | 69.1675 | 69.17 | 1212.0 |
| 2019-12-16 06:29:00 | AAPL | Stock | 69.2 | 69.2 | 69.2 | 69.2 | 1676.0 |
| 2019-12-16 06:46:00 | AAPL | Stock | 69.1625 | 69.1625 | 69.1625 | 69.1625 | 1200.0 |
| 2019-12-16 07:00:00 | AAPL | Stock | 69.125 | 69.175 | 69.1 | 69.125 | 24008.0 |
| 2019-12-16 07:01:00 | AAPL | Stock | 69.1275 | 69.15 | 69.1275 | 69.15 | 1600.0 |
| 2019-12-16 07:02:00 | AAPL | Stock | 69.1275 | 69.1275 | 69.125 | 69.125 | 11580.0 |
| 2019-12-16 07:03:00 | AAPL | Stock | 69.125 | 69.125 | 69.125 | 69.125 | 2904.0 |
| 2019-12-16 07:04:00 | AAPL | Stock | 69.125 | 69.125 | 69.1175 | 69.1175 | 9124.0 |
| 2019-12-16 07:05:00 | AAPL | Stock | 69.1125 | 69.1125 | 69.1 | 69.1125 | 10996.0 |
| 2019-12-16 07:06:00 | AAPL | Stock | 69.09 | 69.125 | 69.085 | 69.125 | 12944.0 |
| 2019-12-16 07:07:00 | AAPL | Stock | 69.1125 | 69.1125 | 69.1125 | 69.1125 | 624.0 |
| 2019-12-16 07:08:00 | AAPL | Stock | 69.1125 | 69.1125 | 69.1125 | 69.1125 | 1336.0 |
| 2019-12-16 07:10:00 | AAPL | Stock | 69.12 | 69.12 | 69.1125 | 69.1125 | 15032.0 |
| 2019-12-16 07:11:00 | AAPL | Stock | 69.1125 | 69.1125 | 69.1125 | 69.1125 | 1460.0 |
| 2019-12-16 07:12:00 | AAPL | Stock | 69.13 | 69.13 | 69.13 | 69.13 | 400.0 |
| 2019-12-16 07:14:00 | AAPL | Stock | 69.1425 | 69.1475 | 69.1425 | 69.1475 | 3500.0 |
| 2019-12-16 07:15:00 | AAPL | Stock | 69.15 | 69.15 | 69.15 | 69.15 | 3780.0 |
| 2019-12-16 07:16:00 | AAPL | Stock | 69.1625 | 69.18 | 69.1625 | 69.1625 | 4400.0 |
| 2019-12-16 07:17:00 | AAPL | Stock | 69.185 | 69.185 | 69.1725 | 69.175 | 3200.0 |
> showing 50 of 1,186,503 rows — these rows as CSV