PREVIEW / stock_1min / 2020-02-26
file: by_date/stock_1min/2020/2020-02-26.parquet size: 20.5 MB rows: 1,280,357 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-02-26 04:00:00 | AAPL | Stock | 71.325 | 71.325 | 71.25 | 71.25 | 2748.0 |
| 2020-02-26 04:01:00 | AAPL | Stock | 71.2625 | 71.2625 | 71.1475 | 71.15 | 17584.0 |
| 2020-02-26 04:02:00 | AAPL | Stock | 71.05 | 71.05 | 71.05 | 71.05 | 400.0 |
| 2020-02-26 04:03:00 | AAPL | Stock | 71.0525 | 71.0525 | 71.0525 | 71.0525 | 1280.0 |
| 2020-02-26 04:04:00 | AAPL | Stock | 71.05 | 71.05 | 71.0 | 71.0 | 3036.0 |
| 2020-02-26 04:05:00 | AAPL | Stock | 70.8 | 70.8 | 70.7875 | 70.7875 | 1200.0 |
| 2020-02-26 04:06:00 | AAPL | Stock | 70.7875 | 70.7925 | 70.7875 | 70.7925 | 1756.0 |
| 2020-02-26 04:07:00 | AAPL | Stock | 70.8025 | 70.875 | 70.775 | 70.875 | 3532.0 |
| 2020-02-26 04:10:00 | AAPL | Stock | 70.775 | 70.7875 | 70.75 | 70.7875 | 6084.0 |
| 2020-02-26 04:11:00 | AAPL | Stock | 70.565 | 70.565 | 70.5 | 70.5 | 1520.0 |
| 2020-02-26 04:12:00 | AAPL | Stock | 70.36 | 70.415 | 70.36 | 70.3925 | 5940.0 |
| 2020-02-26 04:13:00 | AAPL | Stock | 70.455 | 70.575 | 70.4025 | 70.4025 | 24252.0 |
| 2020-02-26 04:14:00 | AAPL | Stock | 70.65 | 70.7 | 70.65 | 70.7 | 4544.0 |
| 2020-02-26 04:15:00 | AAPL | Stock | 70.75 | 70.75 | 70.7375 | 70.75 | 13544.0 |
| 2020-02-26 04:16:00 | AAPL | Stock | 70.8 | 70.8 | 70.75 | 70.75 | 6400.0 |
| 2020-02-26 04:17:00 | AAPL | Stock | 70.855 | 70.8625 | 70.75 | 70.7775 | 13864.0 |
| 2020-02-26 04:18:00 | AAPL | Stock | 70.8725 | 70.875 | 70.8375 | 70.8375 | 14792.0 |
| 2020-02-26 04:19:00 | AAPL | Stock | 70.84 | 70.8775 | 70.8 | 70.8775 | 7276.0 |
| 2020-02-26 04:20:00 | AAPL | Stock | 70.8825 | 70.8875 | 70.75 | 70.75 | 5980.0 |
| 2020-02-26 04:21:00 | AAPL | Stock | 70.725 | 70.725 | 70.725 | 70.725 | 400.0 |
| 2020-02-26 04:22:00 | AAPL | Stock | 70.75 | 70.75 | 70.725 | 70.725 | 3892.0 |
| 2020-02-26 04:23:00 | AAPL | Stock | 70.725 | 70.9375 | 70.725 | 70.935 | 13884.0 |
| 2020-02-26 04:24:00 | AAPL | Stock | 70.9375 | 70.9975 | 70.88 | 70.8875 | 20312.0 |
| 2020-02-26 04:25:00 | AAPL | Stock | 70.9875 | 71.0 | 70.9875 | 70.9975 | 3960.0 |
| 2020-02-26 04:26:00 | AAPL | Stock | 71.0 | 71.0 | 71.0 | 71.0 | 3560.0 |
| 2020-02-26 04:27:00 | AAPL | Stock | 71.025 | 71.025 | 70.9975 | 70.9975 | 6064.0 |
| 2020-02-26 04:28:00 | AAPL | Stock | 71.0125 | 71.0125 | 70.935 | 70.935 | 820.0 |
| 2020-02-26 04:31:00 | AAPL | Stock | 71.1875 | 71.1875 | 71.0625 | 71.0625 | 1920.0 |
| 2020-02-26 04:33:00 | AAPL | Stock | 70.88 | 71.0225 | 70.88 | 71.0 | 3444.0 |
| 2020-02-26 04:34:00 | AAPL | Stock | 70.99 | 71.175 | 70.99 | 71.175 | 2200.0 |
| 2020-02-26 04:35:00 | AAPL | Stock | 71.0 | 71.0 | 71.0 | 71.0 | 5620.0 |
| 2020-02-26 04:38:00 | AAPL | Stock | 71.0 | 71.0 | 71.0 | 71.0 | 1600.0 |
| 2020-02-26 04:39:00 | AAPL | Stock | 71.1025 | 71.25 | 71.0425 | 71.1525 | 4600.0 |
| 2020-02-26 04:41:00 | AAPL | Stock | 71.28 | 71.295 | 71.25 | 71.25 | 3772.0 |
| 2020-02-26 04:42:00 | AAPL | Stock | 71.3 | 71.3075 | 71.3 | 71.3 | 5416.0 |
| 2020-02-26 04:43:00 | AAPL | Stock | 71.275 | 71.315 | 71.275 | 71.315 | 1584.0 |
| 2020-02-26 04:44:00 | AAPL | Stock | 71.25 | 71.25 | 71.25 | 71.25 | 1200.0 |
| 2020-02-26 04:45:00 | AAPL | Stock | 71.25 | 71.25 | 71.25 | 71.25 | 800.0 |
| 2020-02-26 04:46:00 | AAPL | Stock | 71.1525 | 71.1525 | 71.1525 | 71.1525 | 448.0 |
| 2020-02-26 04:48:00 | AAPL | Stock | 71.1375 | 71.1375 | 71.125 | 71.1375 | 4400.0 |
| 2020-02-26 04:49:00 | AAPL | Stock | 71.0625 | 71.0625 | 71.0625 | 71.0625 | 400.0 |
| 2020-02-26 04:51:00 | AAPL | Stock | 71.0 | 71.18 | 71.0 | 71.18 | 4840.0 |
| 2020-02-26 04:52:00 | AAPL | Stock | 71.155 | 71.1775 | 71.155 | 71.1775 | 1240.0 |
| 2020-02-26 04:53:00 | AAPL | Stock | 71.175 | 71.175 | 71.0 | 71.0 | 2568.0 |
| 2020-02-26 04:54:00 | AAPL | Stock | 70.9975 | 71.075 | 70.9975 | 71.065 | 4780.0 |
| 2020-02-26 04:55:00 | AAPL | Stock | 71.075 | 71.075 | 71.07 | 71.075 | 8644.0 |
| 2020-02-26 04:57:00 | AAPL | Stock | 71.0 | 71.0025 | 71.0 | 71.0 | 2400.0 |
| 2020-02-26 04:58:00 | AAPL | Stock | 71.0 | 71.0 | 71.0 | 71.0 | 476.0 |
| 2020-02-26 05:00:00 | AAPL | Stock | 71.075 | 71.075 | 71.075 | 71.075 | 1656.0 |
| 2020-02-26 05:03:00 | AAPL | Stock | 71.125 | 71.125 | 71.125 | 71.125 | 400.0 |
> showing 50 of 1,280,357 rows — these rows as CSV