PREVIEW / stock_1min / 2020-10-26
file: by_date/stock_1min/2020/2020-10-26.parquet size: 20.6 MB rows: 1,233,359 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 |
|---|---|---|---|---|---|---|---|
| 2020-10-26 04:00:00 | AAPL | Stock | 113.7 | 113.78 | 113.5 | 113.5 | 10854.0 |
| 2020-10-26 04:01:00 | AAPL | Stock | 113.5 | 113.72 | 113.5 | 113.72 | 1364.0 |
| 2020-10-26 04:02:00 | AAPL | Stock | 113.69 | 113.79 | 113.65 | 113.74 | 1844.0 |
| 2020-10-26 04:03:00 | AAPL | Stock | 113.65 | 113.65 | 113.59 | 113.6 | 941.0 |
| 2020-10-26 04:04:00 | AAPL | Stock | 113.55 | 113.59 | 113.4 | 113.54 | 2118.0 |
| 2020-10-26 04:05:00 | AAPL | Stock | 113.5 | 113.68 | 113.5 | 113.68 | 500.0 |
| 2020-10-26 04:06:00 | AAPL | Stock | 113.71 | 113.71 | 113.6 | 113.6 | 2023.0 |
| 2020-10-26 04:07:00 | AAPL | Stock | 113.68 | 113.68 | 113.67 | 113.68 | 2209.0 |
| 2020-10-26 04:08:00 | AAPL | Stock | 113.7 | 113.7 | 113.65 | 113.68 | 990.0 |
| 2020-10-26 04:09:00 | AAPL | Stock | 113.67 | 113.7 | 113.65 | 113.7 | 1136.0 |
| 2020-10-26 04:10:00 | AAPL | Stock | 113.7 | 113.7 | 113.58 | 113.58 | 1100.0 |
| 2020-10-26 04:12:00 | AAPL | Stock | 113.71 | 113.71 | 113.7 | 113.7 | 299.0 |
| 2020-10-26 04:13:00 | AAPL | Stock | 113.7 | 113.73 | 113.7 | 113.73 | 659.0 |
| 2020-10-26 04:14:00 | AAPL | Stock | 113.73 | 113.73 | 113.63 | 113.69 | 1291.0 |
| 2020-10-26 04:17:00 | AAPL | Stock | 113.65 | 113.69 | 113.65 | 113.69 | 684.0 |
| 2020-10-26 04:18:00 | AAPL | Stock | 113.69 | 113.69 | 113.69 | 113.69 | 100.0 |
| 2020-10-26 04:19:00 | AAPL | Stock | 113.69 | 113.69 | 113.69 | 113.69 | 100.0 |
| 2020-10-26 04:20:00 | AAPL | Stock | 113.7 | 113.7 | 113.69 | 113.69 | 1474.0 |
| 2020-10-26 04:21:00 | AAPL | Stock | 113.69 | 113.69 | 113.69 | 113.69 | 300.0 |
| 2020-10-26 04:22:00 | AAPL | Stock | 113.68 | 113.68 | 113.66 | 113.67 | 599.0 |
| 2020-10-26 04:23:00 | AAPL | Stock | 113.66 | 113.67 | 113.52 | 113.52 | 3023.0 |
| 2020-10-26 04:25:00 | AAPL | Stock | 113.55 | 113.6 | 113.55 | 113.6 | 950.0 |
| 2020-10-26 04:26:00 | AAPL | Stock | 113.56 | 113.56 | 113.55 | 113.55 | 703.0 |
| 2020-10-26 04:28:00 | AAPL | Stock | 113.53 | 113.53 | 113.52 | 113.52 | 473.0 |
| 2020-10-26 04:29:00 | AAPL | Stock | 113.55 | 113.55 | 113.5 | 113.5 | 855.0 |
| 2020-10-26 04:30:00 | AAPL | Stock | 113.5 | 113.5 | 113.45 | 113.49 | 505.0 |
| 2020-10-26 04:31:00 | AAPL | Stock | 113.49 | 113.49 | 113.49 | 113.49 | 1044.0 |
| 2020-10-26 04:32:00 | AAPL | Stock | 113.48 | 113.49 | 113.48 | 113.48 | 1385.0 |
| 2020-10-26 04:33:00 | AAPL | Stock | 113.47 | 113.47 | 113.43 | 113.43 | 300.0 |
| 2020-10-26 04:34:00 | AAPL | Stock | 113.42 | 113.45 | 113.4 | 113.45 | 1304.0 |
| 2020-10-26 04:35:00 | AAPL | Stock | 113.45 | 113.45 | 113.35 | 113.35 | 18157.0 |
| 2020-10-26 04:36:00 | AAPL | Stock | 113.31 | 113.44 | 113.31 | 113.44 | 855.0 |
| 2020-10-26 04:37:00 | AAPL | Stock | 113.45 | 113.5 | 113.45 | 113.5 | 618.0 |
| 2020-10-26 04:38:00 | AAPL | Stock | 113.55 | 113.55 | 113.55 | 113.55 | 100.0 |
| 2020-10-26 04:39:00 | AAPL | Stock | 113.5 | 113.5 | 113.5 | 113.5 | 417.0 |
| 2020-10-26 04:40:00 | AAPL | Stock | 113.49 | 113.49 | 113.49 | 113.49 | 158.0 |
| 2020-10-26 04:41:00 | AAPL | Stock | 113.52 | 113.52 | 113.5 | 113.5 | 200.0 |
| 2020-10-26 04:42:00 | AAPL | Stock | 113.49 | 113.49 | 113.45 | 113.45 | 3268.0 |
| 2020-10-26 04:43:00 | AAPL | Stock | 113.46 | 113.54 | 113.46 | 113.54 | 1082.0 |
| 2020-10-26 04:45:00 | AAPL | Stock | 113.59 | 113.6 | 113.59 | 113.6 | 4486.0 |
| 2020-10-26 04:46:00 | AAPL | Stock | 113.54 | 113.54 | 113.54 | 113.54 | 300.0 |
| 2020-10-26 04:47:00 | AAPL | Stock | 113.6 | 113.6 | 113.59 | 113.6 | 477.0 |
| 2020-10-26 04:49:00 | AAPL | Stock | 113.67 | 113.72 | 113.67 | 113.72 | 442.0 |
| 2020-10-26 04:52:00 | AAPL | Stock | 113.68 | 113.68 | 113.68 | 113.68 | 100.0 |
| 2020-10-26 04:53:00 | AAPL | Stock | 113.62 | 113.62 | 113.62 | 113.62 | 126.0 |
| 2020-10-26 04:54:00 | AAPL | Stock | 113.68 | 113.68 | 113.68 | 113.68 | 500.0 |
| 2020-10-26 04:55:00 | AAPL | Stock | 113.68 | 113.68 | 113.68 | 113.68 | 187.0 |
| 2020-10-26 04:56:00 | AAPL | Stock | 113.7 | 113.74 | 113.7 | 113.74 | 1157.0 |
| 2020-10-26 04:57:00 | AAPL | Stock | 113.74 | 113.74 | 113.71 | 113.71 | 300.0 |
| 2020-10-26 04:58:00 | AAPL | Stock | 113.74 | 113.74 | 113.62 | 113.62 | 995.0 |
> showing 50 of 1,233,359 rows — these rows as CSV