PREVIEW / stock_1min / 2020-03-24
file: by_date/stock_1min/2020/2020-03-24.parquet size: 21.1 MB rows: 1,393,857 symbols: 2,070
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 |
|---|---|---|---|---|---|---|---|
| 2020-03-24 04:00:00 | AAPL | Stock | 58.255 | 58.75 | 58.255 | 58.625 | 17232.0 |
| 2020-03-24 04:01:00 | AAPL | Stock | 58.5 | 58.5 | 58.0 | 58.375 | 9104.0 |
| 2020-03-24 04:02:00 | AAPL | Stock | 58.4725 | 58.63 | 58.0775 | 58.625 | 23356.0 |
| 2020-03-24 04:03:00 | AAPL | Stock | 58.4 | 58.4 | 58.4 | 58.4 | 400.0 |
| 2020-03-24 04:04:00 | AAPL | Stock | 58.55 | 58.7375 | 58.55 | 58.7375 | 4328.0 |
| 2020-03-24 04:05:00 | AAPL | Stock | 58.7 | 58.7 | 58.5525 | 58.675 | 4704.0 |
| 2020-03-24 04:06:00 | AAPL | Stock | 58.715 | 58.715 | 58.695 | 58.695 | 1760.0 |
| 2020-03-24 04:07:00 | AAPL | Stock | 58.72 | 58.8375 | 58.7 | 58.8375 | 9140.0 |
| 2020-03-24 04:08:00 | AAPL | Stock | 58.7 | 58.7 | 58.7 | 58.7 | 400.0 |
| 2020-03-24 04:09:00 | AAPL | Stock | 58.7225 | 58.7225 | 58.7225 | 58.7225 | 400.0 |
| 2020-03-24 04:10:00 | AAPL | Stock | 58.55 | 58.625 | 58.55 | 58.625 | 2364.0 |
| 2020-03-24 04:11:00 | AAPL | Stock | 58.665 | 58.675 | 58.5 | 58.55 | 2396.0 |
| 2020-03-24 04:12:00 | AAPL | Stock | 58.7075 | 58.7075 | 58.55 | 58.55 | 3448.0 |
| 2020-03-24 04:13:00 | AAPL | Stock | 58.5 | 58.5 | 58.5 | 58.5 | 400.0 |
| 2020-03-24 04:14:00 | AAPL | Stock | 58.5 | 58.5225 | 58.25 | 58.4475 | 8984.0 |
| 2020-03-24 04:15:00 | AAPL | Stock | 58.3925 | 58.4825 | 58.3925 | 58.45 | 1600.0 |
| 2020-03-24 04:16:00 | AAPL | Stock | 58.5 | 58.525 | 58.5 | 58.5075 | 3240.0 |
| 2020-03-24 04:17:00 | AAPL | Stock | 58.5 | 58.5 | 58.5 | 58.5 | 400.0 |
| 2020-03-24 04:18:00 | AAPL | Stock | 58.5 | 58.5 | 58.5 | 58.5 | 5060.0 |
| 2020-03-24 04:19:00 | AAPL | Stock | 58.5 | 58.5 | 58.4375 | 58.4375 | 2120.0 |
| 2020-03-24 04:20:00 | AAPL | Stock | 58.425 | 58.425 | 58.3 | 58.3 | 5048.0 |
| 2020-03-24 04:21:00 | AAPL | Stock | 58.3575 | 58.4225 | 58.3575 | 58.4225 | 1600.0 |
| 2020-03-24 04:22:00 | AAPL | Stock | 58.3575 | 58.3575 | 58.275 | 58.275 | 1200.0 |
| 2020-03-24 04:23:00 | AAPL | Stock | 58.125 | 58.125 | 58.125 | 58.125 | 860.0 |
| 2020-03-24 04:24:00 | AAPL | Stock | 58.065 | 58.065 | 58.065 | 58.065 | 400.0 |
| 2020-03-24 04:25:00 | AAPL | Stock | 58.1075 | 58.1075 | 58.065 | 58.065 | 1580.0 |
| 2020-03-24 04:26:00 | AAPL | Stock | 58.025 | 58.125 | 58.025 | 58.075 | 7648.0 |
| 2020-03-24 04:27:00 | AAPL | Stock | 58.2125 | 58.2125 | 58.2125 | 58.2125 | 408.0 |
| 2020-03-24 04:29:00 | AAPL | Stock | 58.125 | 58.125 | 58.075 | 58.075 | 1200.0 |
| 2020-03-24 04:30:00 | AAPL | Stock | 58.0625 | 58.0625 | 58.0 | 58.0 | 948.0 |
| 2020-03-24 04:31:00 | AAPL | Stock | 58.0 | 58.0725 | 57.975 | 58.0725 | 4584.0 |
| 2020-03-24 04:33:00 | AAPL | Stock | 57.925 | 57.925 | 57.925 | 57.925 | 400.0 |
| 2020-03-24 04:34:00 | AAPL | Stock | 57.945 | 58.075 | 57.945 | 58.0725 | 2380.0 |
| 2020-03-24 04:35:00 | AAPL | Stock | 58.0725 | 58.0725 | 58.0 | 58.055 | 2400.0 |
| 2020-03-24 04:36:00 | AAPL | Stock | 58.05 | 58.16 | 58.05 | 58.16 | 2520.0 |
| 2020-03-24 04:37:00 | AAPL | Stock | 58.2375 | 58.2375 | 58.2375 | 58.2375 | 956.0 |
| 2020-03-24 04:38:00 | AAPL | Stock | 58.25 | 58.25 | 58.25 | 58.25 | 800.0 |
| 2020-03-24 04:40:00 | AAPL | Stock | 58.375 | 58.4 | 58.375 | 58.4 | 1300.0 |
| 2020-03-24 04:41:00 | AAPL | Stock | 58.375 | 58.375 | 58.375 | 58.375 | 1200.0 |
| 2020-03-24 04:45:00 | AAPL | Stock | 58.38 | 58.38 | 58.38 | 58.38 | 400.0 |
| 2020-03-24 04:47:00 | AAPL | Stock | 58.375 | 58.375 | 58.375 | 58.375 | 1408.0 |
| 2020-03-24 04:48:00 | AAPL | Stock | 58.3975 | 58.4 | 58.3975 | 58.4 | 2384.0 |
| 2020-03-24 04:49:00 | AAPL | Stock | 58.4225 | 58.5 | 58.375 | 58.49 | 6340.0 |
| 2020-03-24 04:53:00 | AAPL | Stock | 58.495 | 58.495 | 58.4475 | 58.4475 | 800.0 |
| 2020-03-24 04:54:00 | AAPL | Stock | 58.3125 | 58.3825 | 58.3125 | 58.3825 | 800.0 |
| 2020-03-24 05:00:00 | AAPL | Stock | 58.495 | 58.6 | 58.495 | 58.6 | 5580.0 |
| 2020-03-24 05:01:00 | AAPL | Stock | 58.525 | 58.6 | 58.525 | 58.5525 | 3520.0 |
| 2020-03-24 05:02:00 | AAPL | Stock | 58.5375 | 58.595 | 58.5 | 58.5 | 3480.0 |
| 2020-03-24 05:03:00 | AAPL | Stock | 58.5 | 58.5 | 58.5 | 58.5 | 580.0 |
| 2020-03-24 05:07:00 | AAPL | Stock | 58.4975 | 58.4975 | 58.4975 | 58.4975 | 820.0 |
> showing 50 of 1,393,857 rows — these rows as CSV