PREVIEW / stock_1min / 2019-12-19
file: by_date/stock_1min/2019/2019-12-19.parquet size: 17.0 MB rows: 1,138,360 symbols: 2,116
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-19 04:17:00 | AAPL | Stock | 69.9 | 69.9 | 69.9 | 69.9 | 400.0 |
| 2019-12-19 04:24:00 | AAPL | Stock | 69.875 | 69.875 | 69.875 | 69.875 | 400.0 |
| 2019-12-19 04:25:00 | AAPL | Stock | 69.845 | 69.845 | 69.845 | 69.845 | 484.0 |
| 2019-12-19 04:42:00 | AAPL | Stock | 69.875 | 69.875 | 69.875 | 69.875 | 2000.0 |
| 2019-12-19 05:33:00 | AAPL | Stock | 69.895 | 69.895 | 69.895 | 69.895 | 400.0 |
| 2019-12-19 06:19:00 | AAPL | Stock | 69.9175 | 69.9175 | 69.9125 | 69.9125 | 1916.0 |
| 2019-12-19 06:20:00 | AAPL | Stock | 69.9125 | 69.9125 | 69.875 | 69.875 | 2256.0 |
| 2019-12-19 06:24:00 | AAPL | Stock | 69.84 | 69.8525 | 69.84 | 69.845 | 8336.0 |
| 2019-12-19 06:25:00 | AAPL | Stock | 69.8375 | 69.8375 | 69.8175 | 69.8175 | 16428.0 |
| 2019-12-19 06:27:00 | AAPL | Stock | 69.775 | 69.775 | 69.75 | 69.75 | 2684.0 |
| 2019-12-19 06:28:00 | AAPL | Stock | 69.75 | 69.75 | 69.75 | 69.75 | 1352.0 |
| 2019-12-19 06:30:00 | AAPL | Stock | 69.7725 | 69.7725 | 69.7725 | 69.7725 | 3244.0 |
| 2019-12-19 06:32:00 | AAPL | Stock | 69.78 | 69.78 | 69.78 | 69.78 | 400.0 |
| 2019-12-19 06:35:00 | AAPL | Stock | 69.7775 | 69.7775 | 69.7775 | 69.7775 | 400.0 |
| 2019-12-19 06:36:00 | AAPL | Stock | 69.805 | 69.8125 | 69.77 | 69.77 | 3200.0 |
| 2019-12-19 06:38:00 | AAPL | Stock | 69.775 | 69.775 | 69.7375 | 69.7375 | 3996.0 |
| 2019-12-19 06:39:00 | AAPL | Stock | 69.77 | 69.77 | 69.77 | 69.77 | 400.0 |
| 2019-12-19 06:43:00 | AAPL | Stock | 69.75 | 69.75 | 69.7475 | 69.75 | 2000.0 |
| 2019-12-19 06:59:00 | AAPL | Stock | 69.82 | 69.82 | 69.8075 | 69.8075 | 936.0 |
| 2019-12-19 07:00:00 | AAPL | Stock | 69.79 | 69.8875 | 69.7875 | 69.8625 | 5400.0 |
| 2019-12-19 07:01:00 | AAPL | Stock | 69.8525 | 69.8625 | 69.845 | 69.845 | 14520.0 |
| 2019-12-19 07:03:00 | AAPL | Stock | 69.8425 | 69.845 | 69.8425 | 69.845 | 1520.0 |
| 2019-12-19 07:05:00 | AAPL | Stock | 69.85 | 69.8675 | 69.85 | 69.8675 | 1152.0 |
| 2019-12-19 07:06:00 | AAPL | Stock | 69.87 | 69.87 | 69.85 | 69.85 | 3000.0 |
| 2019-12-19 07:08:00 | AAPL | Stock | 69.85 | 69.8625 | 69.85 | 69.8625 | 800.0 |
| 2019-12-19 07:09:00 | AAPL | Stock | 69.8625 | 69.8625 | 69.8625 | 69.8625 | 400.0 |
| 2019-12-19 07:10:00 | AAPL | Stock | 69.87 | 69.8875 | 69.87 | 69.8875 | 6464.0 |
| 2019-12-19 07:11:00 | AAPL | Stock | 69.8775 | 69.8775 | 69.8775 | 69.8775 | 2756.0 |
| 2019-12-19 07:12:00 | AAPL | Stock | 69.885 | 69.885 | 69.8375 | 69.8375 | 2780.0 |
| 2019-12-19 07:14:00 | AAPL | Stock | 69.86 | 69.86 | 69.86 | 69.86 | 400.0 |
| 2019-12-19 07:17:00 | AAPL | Stock | 69.86 | 69.86 | 69.85 | 69.85 | 3840.0 |
| 2019-12-19 07:19:00 | AAPL | Stock | 69.8625 | 69.8625 | 69.8625 | 69.8625 | 3200.0 |
| 2019-12-19 07:20:00 | AAPL | Stock | 69.8625 | 69.8625 | 69.8525 | 69.8525 | 960.0 |
| 2019-12-19 07:23:00 | AAPL | Stock | 69.855 | 69.855 | 69.855 | 69.855 | 960.0 |
| 2019-12-19 07:24:00 | AAPL | Stock | 69.8725 | 69.875 | 69.8725 | 69.875 | 8944.0 |
| 2019-12-19 07:25:00 | AAPL | Stock | 69.875 | 69.8825 | 69.875 | 69.8825 | 800.0 |
| 2019-12-19 07:27:00 | AAPL | Stock | 69.87 | 69.87 | 69.87 | 69.87 | 2000.0 |
| 2019-12-19 07:28:00 | AAPL | Stock | 69.8725 | 69.8725 | 69.85 | 69.8525 | 12096.0 |
| 2019-12-19 07:29:00 | AAPL | Stock | 69.8625 | 69.8625 | 69.8375 | 69.8375 | 1256.0 |
| 2019-12-19 07:30:00 | AAPL | Stock | 69.8575 | 69.8575 | 69.8575 | 69.8575 | 1000.0 |
| 2019-12-19 07:33:00 | AAPL | Stock | 69.84 | 69.84 | 69.84 | 69.84 | 800.0 |
| 2019-12-19 07:34:00 | AAPL | Stock | 69.8625 | 69.8625 | 69.8625 | 69.8625 | 800.0 |
| 2019-12-19 07:35:00 | AAPL | Stock | 69.84 | 69.85 | 69.825 | 69.85 | 8216.0 |
| 2019-12-19 07:36:00 | AAPL | Stock | 69.8275 | 69.8275 | 69.825 | 69.825 | 800.0 |
| 2019-12-19 07:37:00 | AAPL | Stock | 69.845 | 69.845 | 69.825 | 69.825 | 6568.0 |
| 2019-12-19 07:38:00 | AAPL | Stock | 69.825 | 69.825 | 69.775 | 69.775 | 4872.0 |
| 2019-12-19 07:39:00 | AAPL | Stock | 69.775 | 69.7775 | 69.7625 | 69.7625 | 3128.0 |
| 2019-12-19 07:40:00 | AAPL | Stock | 69.8125 | 69.8125 | 69.8125 | 69.8125 | 400.0 |
| 2019-12-19 07:41:00 | AAPL | Stock | 69.82 | 69.82 | 69.82 | 69.82 | 800.0 |
| 2019-12-19 07:42:00 | AAPL | Stock | 69.8225 | 69.8225 | 69.8225 | 69.8225 | 400.0 |
> showing 50 of 1,138,360 rows — these rows as CSV