PREVIEW / stock_1min / 2019-11-21
file: by_date/stock_1min/2019/2019-11-21.parquet size: 15.8 MB rows: 1,100,456 symbols: 2,107
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-21 04:00:00 | AAPL | Stock | 65.8375 | 65.8375 | 65.825 | 65.825 | 1200.0 |
| 2019-11-21 04:50:00 | AAPL | Stock | 66.005 | 66.005 | 65.93 | 65.93 | 1668.0 |
| 2019-11-21 04:59:00 | AAPL | Stock | 65.9125 | 65.9125 | 65.9125 | 65.9125 | 2240.0 |
| 2019-11-21 05:19:00 | AAPL | Stock | 66.075 | 66.075 | 66.075 | 66.075 | 400.0 |
| 2019-11-21 05:30:00 | AAPL | Stock | 66.09 | 66.1275 | 66.09 | 66.125 | 8744.0 |
| 2019-11-21 05:31:00 | AAPL | Stock | 66.095 | 66.095 | 66.095 | 66.095 | 400.0 |
| 2019-11-21 05:32:00 | AAPL | Stock | 66.1225 | 66.1225 | 66.1225 | 66.1225 | 4000.0 |
| 2019-11-21 05:33:00 | AAPL | Stock | 66.12 | 66.12 | 66.12 | 66.12 | 712.0 |
| 2019-11-21 05:34:00 | AAPL | Stock | 66.0775 | 66.0775 | 66.0775 | 66.0775 | 2000.0 |
| 2019-11-21 05:37:00 | AAPL | Stock | 66.0075 | 66.0075 | 66.0075 | 66.0075 | 1200.0 |
| 2019-11-21 05:38:00 | AAPL | Stock | 66.075 | 66.0825 | 66.075 | 66.0825 | 1984.0 |
| 2019-11-21 05:51:00 | AAPL | Stock | 66.0125 | 66.0125 | 65.9625 | 65.9625 | 1880.0 |
| 2019-11-21 05:57:00 | AAPL | Stock | 66.0725 | 66.0725 | 66.0725 | 66.0725 | 496.0 |
| 2019-11-21 06:12:00 | AAPL | Stock | 66.05 | 66.05 | 66.05 | 66.05 | 2000.0 |
| 2019-11-21 06:18:00 | AAPL | Stock | 66.07 | 66.07 | 66.07 | 66.07 | 400.0 |
| 2019-11-21 06:24:00 | AAPL | Stock | 66.07 | 66.07 | 66.07 | 66.07 | 400.0 |
| 2019-11-21 06:35:00 | AAPL | Stock | 66.07 | 66.0775 | 66.07 | 66.0775 | 920.0 |
| 2019-11-21 06:36:00 | AAPL | Stock | 66.0775 | 66.0775 | 66.0775 | 66.0775 | 1244.0 |
| 2019-11-21 06:47:00 | AAPL | Stock | 66.125 | 66.125 | 66.125 | 66.125 | 880.0 |
| 2019-11-21 06:49:00 | AAPL | Stock | 66.125 | 66.125 | 66.125 | 66.125 | 800.0 |
| 2019-11-21 06:50:00 | AAPL | Stock | 66.1375 | 66.1375 | 66.125 | 66.125 | 1000.0 |
| 2019-11-21 07:00:00 | AAPL | Stock | 66.1 | 66.15 | 66.1 | 66.1 | 10432.0 |
| 2019-11-21 07:01:00 | AAPL | Stock | 66.145 | 66.145 | 66.145 | 66.145 | 1200.0 |
| 2019-11-21 07:02:00 | AAPL | Stock | 66.15 | 66.25 | 66.15 | 66.2 | 24796.0 |
| 2019-11-21 07:03:00 | AAPL | Stock | 66.2225 | 66.2225 | 66.175 | 66.175 | 3260.0 |
| 2019-11-21 07:04:00 | AAPL | Stock | 66.175 | 66.175 | 66.175 | 66.175 | 1108.0 |
| 2019-11-21 07:07:00 | AAPL | Stock | 66.175 | 66.175 | 66.1625 | 66.1625 | 808.0 |
| 2019-11-21 07:09:00 | AAPL | Stock | 66.1725 | 66.1725 | 66.1725 | 66.1725 | 1200.0 |
| 2019-11-21 07:10:00 | AAPL | Stock | 66.15 | 66.15 | 66.15 | 66.15 | 1600.0 |
| 2019-11-21 07:14:00 | AAPL | Stock | 66.125 | 66.125 | 66.1125 | 66.1125 | 5260.0 |
| 2019-11-21 07:16:00 | AAPL | Stock | 66.145 | 66.15 | 66.1275 | 66.1275 | 2000.0 |
| 2019-11-21 07:17:00 | AAPL | Stock | 66.13 | 66.13 | 66.13 | 66.13 | 400.0 |
| 2019-11-21 07:20:00 | AAPL | Stock | 66.125 | 66.125 | 66.125 | 66.125 | 1996.0 |
| 2019-11-21 07:21:00 | AAPL | Stock | 66.1425 | 66.1425 | 66.1425 | 66.1425 | 400.0 |
| 2019-11-21 07:22:00 | AAPL | Stock | 66.125 | 66.1275 | 66.125 | 66.1275 | 2208.0 |
| 2019-11-21 07:23:00 | AAPL | Stock | 66.125 | 66.125 | 66.125 | 66.125 | 400.0 |
| 2019-11-21 07:24:00 | AAPL | Stock | 66.1225 | 66.1225 | 66.1 | 66.1 | 800.0 |
| 2019-11-21 07:28:00 | AAPL | Stock | 66.08 | 66.08 | 66.0775 | 66.0775 | 800.0 |
| 2019-11-21 07:29:00 | AAPL | Stock | 66.075 | 66.075 | 66.075 | 66.075 | 400.0 |
| 2019-11-21 07:31:00 | AAPL | Stock | 66.0725 | 66.0725 | 66.0725 | 66.0725 | 2000.0 |
| 2019-11-21 07:32:00 | AAPL | Stock | 66.0425 | 66.0425 | 66.0425 | 66.0425 | 1600.0 |
| 2019-11-21 07:33:00 | AAPL | Stock | 66.05 | 66.05 | 66.05 | 66.05 | 2000.0 |
| 2019-11-21 07:34:00 | AAPL | Stock | 66.0375 | 66.0375 | 66.035 | 66.035 | 3792.0 |
| 2019-11-21 07:35:00 | AAPL | Stock | 66.0375 | 66.0375 | 66.035 | 66.035 | 5280.0 |
| 2019-11-21 07:36:00 | AAPL | Stock | 66.035 | 66.035 | 66.035 | 66.035 | 800.0 |
| 2019-11-21 07:39:00 | AAPL | Stock | 66.0475 | 66.0475 | 66.0475 | 66.0475 | 400.0 |
| 2019-11-21 07:40:00 | AAPL | Stock | 66.05 | 66.0625 | 66.05 | 66.0625 | 1600.0 |
| 2019-11-21 07:46:00 | AAPL | Stock | 66.075 | 66.075 | 66.075 | 66.075 | 2000.0 |
| 2019-11-21 07:48:00 | AAPL | Stock | 66.0825 | 66.0875 | 66.0825 | 66.0875 | 10792.0 |
| 2019-11-21 07:51:00 | AAPL | Stock | 66.0875 | 66.0875 | 66.075 | 66.075 | 1200.0 |
> showing 50 of 1,100,456 rows — these rows as CSV