PREVIEW / stock_1min / 2020-11-27
file: by_date/stock_1min/2020/2020-11-27.parquet size: 12.2 MB rows: 796,375 symbols: 2,183
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-27 04:00:00 | AAPL | Stock | 116.8 | 116.8 | 116.51 | 116.73 | 3714.0 |
| 2020-11-27 04:01:00 | AAPL | Stock | 116.88 | 116.88 | 116.74 | 116.74 | 700.0 |
| 2020-11-27 04:02:00 | AAPL | Stock | 116.8 | 116.8 | 116.76 | 116.76 | 400.0 |
| 2020-11-27 04:04:00 | AAPL | Stock | 116.8 | 116.8 | 116.8 | 116.8 | 1331.0 |
| 2020-11-27 04:05:00 | AAPL | Stock | 116.8 | 116.8 | 116.8 | 116.8 | 117.0 |
| 2020-11-27 04:06:00 | AAPL | Stock | 116.8 | 116.8 | 116.8 | 116.8 | 107.0 |
| 2020-11-27 04:07:00 | AAPL | Stock | 116.62 | 116.62 | 116.62 | 116.62 | 100.0 |
| 2020-11-27 04:08:00 | AAPL | Stock | 116.62 | 116.65 | 116.62 | 116.65 | 293.0 |
| 2020-11-27 04:12:00 | AAPL | Stock | 116.65 | 116.65 | 116.65 | 116.65 | 200.0 |
| 2020-11-27 04:14:00 | AAPL | Stock | 116.7 | 116.7 | 116.7 | 116.7 | 100.0 |
| 2020-11-27 04:16:00 | AAPL | Stock | 116.7 | 116.7 | 116.7 | 116.7 | 255.0 |
| 2020-11-27 04:18:00 | AAPL | Stock | 116.75 | 116.79 | 116.75 | 116.79 | 780.0 |
| 2020-11-27 04:21:00 | AAPL | Stock | 116.84 | 116.88 | 116.84 | 116.88 | 485.0 |
| 2020-11-27 04:23:00 | AAPL | Stock | 116.95 | 116.95 | 116.95 | 116.95 | 399.0 |
| 2020-11-27 04:24:00 | AAPL | Stock | 116.95 | 116.95 | 116.95 | 116.95 | 1135.0 |
| 2020-11-27 04:25:00 | AAPL | Stock | 116.95 | 116.95 | 116.95 | 116.95 | 100.0 |
| 2020-11-27 04:27:00 | AAPL | Stock | 116.89 | 116.89 | 116.89 | 116.89 | 224.0 |
| 2020-11-27 04:28:00 | AAPL | Stock | 116.89 | 116.89 | 116.89 | 116.89 | 100.0 |
| 2020-11-27 04:30:00 | AAPL | Stock | 116.92 | 116.92 | 116.9 | 116.9 | 400.0 |
| 2020-11-27 04:32:00 | AAPL | Stock | 116.81 | 116.81 | 116.81 | 116.81 | 211.0 |
| 2020-11-27 04:36:00 | AAPL | Stock | 116.84 | 116.85 | 116.84 | 116.85 | 1000.0 |
| 2020-11-27 04:37:00 | AAPL | Stock | 116.85 | 116.85 | 116.84 | 116.85 | 2095.0 |
| 2020-11-27 04:40:00 | AAPL | Stock | 116.92 | 116.92 | 116.92 | 116.92 | 550.0 |
| 2020-11-27 04:41:00 | AAPL | Stock | 116.95 | 116.95 | 116.95 | 116.95 | 250.0 |
| 2020-11-27 04:43:00 | AAPL | Stock | 116.92 | 116.92 | 116.92 | 116.92 | 500.0 |
| 2020-11-27 04:46:00 | AAPL | Stock | 116.95 | 116.95 | 116.91 | 116.91 | 400.0 |
| 2020-11-27 04:49:00 | AAPL | Stock | 116.98 | 116.98 | 116.98 | 116.98 | 608.0 |
| 2020-11-27 04:54:00 | AAPL | Stock | 116.9 | 116.9 | 116.9 | 116.9 | 631.0 |
| 2020-11-27 04:55:00 | AAPL | Stock | 116.9 | 116.9 | 116.9 | 116.9 | 100.0 |
| 2020-11-27 04:59:00 | AAPL | Stock | 116.9 | 116.9 | 116.86 | 116.86 | 535.0 |
| 2020-11-27 05:02:00 | AAPL | Stock | 116.8 | 116.8 | 116.8 | 116.8 | 115.0 |
| 2020-11-27 05:03:00 | AAPL | Stock | 116.8 | 116.8 | 116.8 | 116.8 | 111.0 |
| 2020-11-27 05:04:00 | AAPL | Stock | 116.83 | 116.83 | 116.83 | 116.83 | 205.0 |
| 2020-11-27 05:06:00 | AAPL | Stock | 116.81 | 116.81 | 116.81 | 116.81 | 635.0 |
| 2020-11-27 05:09:00 | AAPL | Stock | 116.78 | 116.78 | 116.77 | 116.77 | 428.0 |
| 2020-11-27 05:13:00 | AAPL | Stock | 116.83 | 116.83 | 116.83 | 116.83 | 350.0 |
| 2020-11-27 05:14:00 | AAPL | Stock | 116.83 | 116.83 | 116.83 | 116.83 | 104.0 |
| 2020-11-27 05:16:00 | AAPL | Stock | 116.8 | 116.8 | 116.8 | 116.8 | 150.0 |
| 2020-11-27 05:22:00 | AAPL | Stock | 116.77 | 116.77 | 116.77 | 116.77 | 177.0 |
| 2020-11-27 05:31:00 | AAPL | Stock | 116.74 | 116.74 | 116.74 | 116.74 | 259.0 |
| 2020-11-27 05:32:00 | AAPL | Stock | 116.77 | 116.77 | 116.77 | 116.77 | 177.0 |
| 2020-11-27 05:36:00 | AAPL | Stock | 116.84 | 116.84 | 116.84 | 116.84 | 128.0 |
| 2020-11-27 05:41:00 | AAPL | Stock | 116.83 | 116.83 | 116.83 | 116.83 | 535.0 |
| 2020-11-27 05:43:00 | AAPL | Stock | 116.74 | 116.74 | 116.74 | 116.74 | 100.0 |
| 2020-11-27 05:47:00 | AAPL | Stock | 116.79 | 116.79 | 116.79 | 116.79 | 157.0 |
| 2020-11-27 05:50:00 | AAPL | Stock | 116.76 | 116.76 | 116.76 | 116.76 | 100.0 |
| 2020-11-27 05:55:00 | AAPL | Stock | 116.84 | 116.84 | 116.84 | 116.84 | 150.0 |
| 2020-11-27 05:56:00 | AAPL | Stock | 116.84 | 116.87 | 116.84 | 116.87 | 500.0 |
| 2020-11-27 06:03:00 | AAPL | Stock | 116.9 | 116.9 | 116.9 | 116.9 | 124.0 |
| 2020-11-27 06:05:00 | AAPL | Stock | 116.9 | 116.9 | 116.9 | 116.9 | 180.0 |
> showing 50 of 796,375 rows — these rows as CSV