PREVIEW / stock_1min / 2020-08-05
file: by_date/stock_1min/2020/2020-08-05.parquet size: 20.9 MB rows: 1,311,134 symbols: 2,064
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-08-05 04:00:00 | AAPL | Stock | 110.205 | 110.25 | 110.205 | 110.25 | 10156.0 |
| 2020-08-05 04:01:00 | AAPL | Stock | 110.37 | 110.37 | 110.37 | 110.37 | 680.0 |
| 2020-08-05 04:05:00 | AAPL | Stock | 110.405 | 110.4075 | 110.405 | 110.4075 | 1200.0 |
| 2020-08-05 04:08:00 | AAPL | Stock | 110.4075 | 110.4075 | 110.4075 | 110.4075 | 600.0 |
| 2020-08-05 04:09:00 | AAPL | Stock | 110.41 | 110.41 | 110.41 | 110.41 | 800.0 |
| 2020-08-05 04:14:00 | AAPL | Stock | 110.3025 | 110.3025 | 110.3025 | 110.3025 | 1592.0 |
| 2020-08-05 04:18:00 | AAPL | Stock | 110.255 | 110.255 | 110.255 | 110.255 | 880.0 |
| 2020-08-05 04:24:00 | AAPL | Stock | 110.1525 | 110.1525 | 110.1525 | 110.1525 | 1384.0 |
| 2020-08-05 04:27:00 | AAPL | Stock | 110.2325 | 110.245 | 110.2325 | 110.245 | 928.0 |
| 2020-08-05 04:30:00 | AAPL | Stock | 110.1675 | 110.1675 | 110.0825 | 110.0825 | 1600.0 |
| 2020-08-05 04:33:00 | AAPL | Stock | 110.1925 | 110.1925 | 110.04 | 110.04 | 3376.0 |
| 2020-08-05 04:41:00 | AAPL | Stock | 110.2 | 110.2 | 110.2 | 110.2 | 800.0 |
| 2020-08-05 04:49:00 | AAPL | Stock | 110.235 | 110.235 | 110.1875 | 110.1875 | 1648.0 |
| 2020-08-05 04:53:00 | AAPL | Stock | 110.235 | 110.325 | 110.235 | 110.325 | 4152.0 |
| 2020-08-05 05:05:00 | AAPL | Stock | 110.325 | 110.325 | 110.325 | 110.325 | 400.0 |
| 2020-08-05 05:09:00 | AAPL | Stock | 110.325 | 110.325 | 110.325 | 110.325 | 1964.0 |
| 2020-08-05 05:10:00 | AAPL | Stock | 110.325 | 110.325 | 110.325 | 110.325 | 1560.0 |
| 2020-08-05 05:16:00 | AAPL | Stock | 110.325 | 110.325 | 110.3225 | 110.3225 | 800.0 |
| 2020-08-05 05:22:00 | AAPL | Stock | 110.3 | 110.3 | 110.3 | 110.3 | 400.0 |
| 2020-08-05 05:26:00 | AAPL | Stock | 110.325 | 110.3975 | 110.325 | 110.3975 | 4064.0 |
| 2020-08-05 05:29:00 | AAPL | Stock | 110.4275 | 110.4275 | 110.4275 | 110.4275 | 1244.0 |
| 2020-08-05 05:30:00 | AAPL | Stock | 110.3925 | 110.3925 | 110.3925 | 110.3925 | 400.0 |
| 2020-08-05 05:32:00 | AAPL | Stock | 110.3475 | 110.3475 | 110.3475 | 110.3475 | 804.0 |
| 2020-08-05 05:33:00 | AAPL | Stock | 110.415 | 110.415 | 110.415 | 110.415 | 400.0 |
| 2020-08-05 05:35:00 | AAPL | Stock | 110.3125 | 110.3125 | 110.25 | 110.285 | 3000.0 |
| 2020-08-05 05:36:00 | AAPL | Stock | 110.285 | 110.285 | 110.285 | 110.285 | 1544.0 |
| 2020-08-05 05:41:00 | AAPL | Stock | 110.395 | 110.395 | 110.395 | 110.395 | 400.0 |
| 2020-08-05 05:43:00 | AAPL | Stock | 110.39 | 110.425 | 110.39 | 110.425 | 1936.0 |
| 2020-08-05 05:44:00 | AAPL | Stock | 110.425 | 110.4275 | 110.425 | 110.4275 | 800.0 |
| 2020-08-05 05:46:00 | AAPL | Stock | 110.5 | 110.5 | 110.4875 | 110.5 | 7260.0 |
| 2020-08-05 05:48:00 | AAPL | Stock | 110.5 | 110.5 | 110.5 | 110.5 | 404.0 |
| 2020-08-05 05:49:00 | AAPL | Stock | 110.615 | 110.625 | 110.615 | 110.625 | 1000.0 |
| 2020-08-05 05:50:00 | AAPL | Stock | 110.6875 | 110.6875 | 110.6875 | 110.6875 | 800.0 |
| 2020-08-05 05:51:00 | AAPL | Stock | 110.7175 | 110.7175 | 110.7125 | 110.7125 | 1356.0 |
| 2020-08-05 05:52:00 | AAPL | Stock | 110.72 | 110.72 | 110.72 | 110.72 | 416.0 |
| 2020-08-05 05:53:00 | AAPL | Stock | 110.7425 | 110.7425 | 110.7425 | 110.7425 | 400.0 |
| 2020-08-05 05:54:00 | AAPL | Stock | 110.745 | 110.745 | 110.745 | 110.745 | 400.0 |
| 2020-08-05 05:55:00 | AAPL | Stock | 110.71 | 110.71 | 110.655 | 110.655 | 2280.0 |
| 2020-08-05 05:56:00 | AAPL | Stock | 110.605 | 110.605 | 110.605 | 110.605 | 400.0 |
| 2020-08-05 05:57:00 | AAPL | Stock | 110.625 | 110.625 | 110.625 | 110.625 | 400.0 |
| 2020-08-05 05:58:00 | AAPL | Stock | 110.71 | 110.71 | 110.71 | 110.71 | 600.0 |
| 2020-08-05 05:59:00 | AAPL | Stock | 110.705 | 110.705 | 110.705 | 110.705 | 400.0 |
| 2020-08-05 06:01:00 | AAPL | Stock | 110.6325 | 110.6325 | 109.6075 | 110.0075 | 44752.0 |
| 2020-08-05 06:02:00 | AAPL | Stock | 110.025 | 110.255 | 110.025 | 110.25 | 19980.0 |
| 2020-08-05 06:03:00 | AAPL | Stock | 110.075 | 110.075 | 109.5 | 109.9275 | 37924.0 |
| 2020-08-05 06:04:00 | AAPL | Stock | 109.75 | 109.9725 | 109.575 | 109.5825 | 13152.0 |
| 2020-08-05 06:05:00 | AAPL | Stock | 109.6 | 109.65 | 109.575 | 109.6 | 14392.0 |
| 2020-08-05 06:06:00 | AAPL | Stock | 109.56 | 109.6 | 109.255 | 109.375 | 14744.0 |
| 2020-08-05 06:07:00 | AAPL | Stock | 109.4875 | 109.5 | 109.375 | 109.375 | 9408.0 |
| 2020-08-05 06:08:00 | AAPL | Stock | 109.49 | 109.6825 | 109.375 | 109.6825 | 10776.0 |
> showing 50 of 1,311,134 rows — these rows as CSV