PREVIEW / stock_1min / 2020-11-18
file: by_date/stock_1min/2020/2020-11-18.parquet size: 21.8 MB rows: 1,299,755 symbols: 2,165
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-11-18 04:00:00 | AAPL | Stock | 119.4 | 119.4 | 119.4 | 119.4 | 231.0 |
| 2020-11-18 04:03:00 | AAPL | Stock | 119.4 | 119.43 | 119.4 | 119.43 | 230.0 |
| 2020-11-18 04:05:00 | AAPL | Stock | 119.5 | 119.5 | 119.5 | 119.5 | 150.0 |
| 2020-11-18 04:06:00 | AAPL | Stock | 119.5 | 119.5 | 119.49 | 119.49 | 1533.0 |
| 2020-11-18 04:07:00 | AAPL | Stock | 119.56 | 119.56 | 119.56 | 119.56 | 312.0 |
| 2020-11-18 04:08:00 | AAPL | Stock | 119.56 | 119.56 | 119.56 | 119.56 | 124.0 |
| 2020-11-18 04:09:00 | AAPL | Stock | 119.51 | 119.51 | 119.51 | 119.51 | 200.0 |
| 2020-11-18 04:11:00 | AAPL | Stock | 119.51 | 119.51 | 119.51 | 119.51 | 276.0 |
| 2020-11-18 04:12:00 | AAPL | Stock | 119.56 | 119.56 | 119.56 | 119.56 | 387.0 |
| 2020-11-18 04:14:00 | AAPL | Stock | 119.5 | 119.56 | 119.5 | 119.56 | 1348.0 |
| 2020-11-18 04:22:00 | AAPL | Stock | 119.5 | 119.5 | 119.5 | 119.5 | 245.0 |
| 2020-11-18 04:23:00 | AAPL | Stock | 119.46 | 119.46 | 119.46 | 119.46 | 297.0 |
| 2020-11-18 04:25:00 | AAPL | Stock | 119.56 | 119.56 | 119.51 | 119.51 | 262.0 |
| 2020-11-18 04:26:00 | AAPL | Stock | 119.51 | 119.51 | 119.51 | 119.51 | 2878.0 |
| 2020-11-18 04:27:00 | AAPL | Stock | 119.52 | 119.52 | 119.52 | 119.52 | 212.0 |
| 2020-11-18 04:35:00 | AAPL | Stock | 119.41 | 119.41 | 119.41 | 119.41 | 176.0 |
| 2020-11-18 04:44:00 | AAPL | Stock | 119.4 | 119.4 | 119.4 | 119.4 | 560.0 |
| 2020-11-18 04:49:00 | AAPL | Stock | 119.48 | 119.49 | 119.47 | 119.47 | 741.0 |
| 2020-11-18 04:51:00 | AAPL | Stock | 119.41 | 119.41 | 119.41 | 119.41 | 363.0 |
| 2020-11-18 04:57:00 | AAPL | Stock | 119.4 | 119.46 | 119.4 | 119.46 | 307.0 |
| 2020-11-18 05:02:00 | AAPL | Stock | 119.42 | 119.42 | 119.42 | 119.42 | 100.0 |
| 2020-11-18 05:05:00 | AAPL | Stock | 119.5 | 119.5 | 119.5 | 119.5 | 266.0 |
| 2020-11-18 05:07:00 | AAPL | Stock | 119.53 | 119.53 | 119.5 | 119.5 | 1040.0 |
| 2020-11-18 05:08:00 | AAPL | Stock | 119.55 | 119.55 | 119.55 | 119.55 | 1100.0 |
| 2020-11-18 05:09:00 | AAPL | Stock | 119.56 | 119.56 | 119.5 | 119.5 | 1500.0 |
| 2020-11-18 05:10:00 | AAPL | Stock | 119.52 | 119.57 | 119.5 | 119.57 | 5150.0 |
| 2020-11-18 05:11:00 | AAPL | Stock | 119.57 | 119.61 | 119.57 | 119.61 | 950.0 |
| 2020-11-18 05:13:00 | AAPL | Stock | 119.63 | 119.63 | 119.63 | 119.63 | 400.0 |
| 2020-11-18 05:14:00 | AAPL | Stock | 119.57 | 119.57 | 119.57 | 119.57 | 200.0 |
| 2020-11-18 05:15:00 | AAPL | Stock | 119.61 | 119.61 | 119.54 | 119.54 | 450.0 |
| 2020-11-18 05:22:00 | AAPL | Stock | 119.57 | 119.57 | 119.57 | 119.57 | 100.0 |
| 2020-11-18 05:25:00 | AAPL | Stock | 119.65 | 119.65 | 119.65 | 119.65 | 143.0 |
| 2020-11-18 05:26:00 | AAPL | Stock | 119.52 | 119.52 | 119.52 | 119.52 | 199.0 |
| 2020-11-18 05:28:00 | AAPL | Stock | 119.53 | 119.53 | 119.51 | 119.53 | 854.0 |
| 2020-11-18 05:31:00 | AAPL | Stock | 119.62 | 119.62 | 119.62 | 119.62 | 101.0 |
| 2020-11-18 05:34:00 | AAPL | Stock | 119.58 | 119.59 | 119.58 | 119.59 | 353.0 |
| 2020-11-18 05:38:00 | AAPL | Stock | 119.6 | 119.6 | 119.59 | 119.59 | 1450.0 |
| 2020-11-18 05:41:00 | AAPL | Stock | 119.67 | 119.67 | 119.67 | 119.67 | 364.0 |
| 2020-11-18 05:42:00 | AAPL | Stock | 119.66 | 119.67 | 119.66 | 119.67 | 520.0 |
| 2020-11-18 05:44:00 | AAPL | Stock | 119.74 | 119.74 | 119.74 | 119.74 | 400.0 |
| 2020-11-18 05:45:00 | AAPL | Stock | 119.74 | 119.74 | 119.74 | 119.74 | 142.0 |
| 2020-11-18 05:46:00 | AAPL | Stock | 119.77 | 119.77 | 119.77 | 119.77 | 100.0 |
| 2020-11-18 05:50:00 | AAPL | Stock | 119.8 | 119.8 | 119.8 | 119.8 | 300.0 |
| 2020-11-18 05:51:00 | AAPL | Stock | 119.74 | 119.74 | 119.74 | 119.74 | 258.0 |
| 2020-11-18 05:52:00 | AAPL | Stock | 119.7 | 119.7 | 119.7 | 119.7 | 908.0 |
| 2020-11-18 05:53:00 | AAPL | Stock | 119.73 | 119.73 | 119.73 | 119.73 | 200.0 |
| 2020-11-18 05:56:00 | AAPL | Stock | 119.76 | 119.76 | 119.76 | 119.76 | 100.0 |
| 2020-11-18 05:57:00 | AAPL | Stock | 119.84 | 119.86 | 119.84 | 119.86 | 396.0 |
| 2020-11-18 05:58:00 | AAPL | Stock | 119.86 | 119.86 | 119.86 | 119.86 | 14496.0 |
| 2020-11-18 06:00:00 | AAPL | Stock | 119.75 | 119.88 | 119.3 | 119.55 | 7950.0 |
> showing 50 of 1,299,755 rows — these rows as CSV