PREVIEW / stock_1min / 2020-06-01
file: by_date/stock_1min/2020/2020-06-01.parquet size: 20.1 MB rows: 1,284,718 symbols: 2,013
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-06-01 04:00:00 | AAPL | Stock | 79.75 | 79.75 | 79.75 | 79.75 | 784.0 |
| 2020-06-01 04:07:00 | AAPL | Stock | 79.275 | 79.275 | 79.2625 | 79.2625 | 1040.0 |
| 2020-06-01 04:09:00 | AAPL | Stock | 79.1675 | 79.1675 | 79.1675 | 79.1675 | 1184.0 |
| 2020-06-01 04:11:00 | AAPL | Stock | 79.25 | 79.25 | 79.25 | 79.25 | 400.0 |
| 2020-06-01 04:12:00 | AAPL | Stock | 79.25 | 79.25 | 79.095 | 79.095 | 13212.0 |
| 2020-06-01 04:13:00 | AAPL | Stock | 78.7525 | 79.065 | 78.575 | 79.0625 | 4000.0 |
| 2020-06-01 04:14:00 | AAPL | Stock | 79.0625 | 79.0625 | 78.77 | 78.77 | 1400.0 |
| 2020-06-01 04:15:00 | AAPL | Stock | 78.955 | 78.9625 | 78.9025 | 78.9025 | 1800.0 |
| 2020-06-01 04:16:00 | AAPL | Stock | 78.9 | 79.005 | 78.9 | 79.005 | 14824.0 |
| 2020-06-01 04:17:00 | AAPL | Stock | 79.0 | 79.0 | 79.0 | 79.0 | 400.0 |
| 2020-06-01 04:22:00 | AAPL | Stock | 78.9275 | 78.9275 | 78.875 | 78.875 | 3356.0 |
| 2020-06-01 04:23:00 | AAPL | Stock | 78.875 | 78.875 | 78.8275 | 78.8275 | 6760.0 |
| 2020-06-01 04:25:00 | AAPL | Stock | 78.83 | 78.83 | 78.83 | 78.83 | 780.0 |
| 2020-06-01 04:29:00 | AAPL | Stock | 79.0 | 79.0 | 79.0 | 79.0 | 1120.0 |
| 2020-06-01 04:33:00 | AAPL | Stock | 78.9875 | 78.9875 | 78.9875 | 78.9875 | 400.0 |
| 2020-06-01 04:34:00 | AAPL | Stock | 78.9875 | 78.9875 | 78.9875 | 78.9875 | 400.0 |
| 2020-06-01 04:35:00 | AAPL | Stock | 78.9375 | 78.9375 | 78.9375 | 78.9375 | 1160.0 |
| 2020-06-01 04:40:00 | AAPL | Stock | 79.075 | 79.075 | 79.075 | 79.075 | 400.0 |
| 2020-06-01 04:48:00 | AAPL | Stock | 79.15 | 79.15 | 79.15 | 79.15 | 800.0 |
| 2020-06-01 04:50:00 | AAPL | Stock | 79.1475 | 79.1475 | 79.125 | 79.125 | 2860.0 |
| 2020-06-01 04:52:00 | AAPL | Stock | 79.125 | 79.125 | 79.125 | 79.125 | 2000.0 |
| 2020-06-01 05:00:00 | AAPL | Stock | 79.0875 | 79.0875 | 79.075 | 79.075 | 1996.0 |
| 2020-06-01 05:02:00 | AAPL | Stock | 79.075 | 79.075 | 79.075 | 79.075 | 1144.0 |
| 2020-06-01 05:08:00 | AAPL | Stock | 79.25 | 79.25 | 79.25 | 79.25 | 400.0 |
| 2020-06-01 05:12:00 | AAPL | Stock | 79.1 | 79.1 | 79.1 | 79.1 | 400.0 |
| 2020-06-01 05:26:00 | AAPL | Stock | 79.1875 | 79.1875 | 79.1875 | 79.1875 | 400.0 |
| 2020-06-01 05:44:00 | AAPL | Stock | 79.125 | 79.125 | 79.125 | 79.125 | 680.0 |
| 2020-06-01 05:47:00 | AAPL | Stock | 79.13 | 79.13 | 79.0075 | 79.0075 | 2740.0 |
| 2020-06-01 05:48:00 | AAPL | Stock | 79.0 | 79.0 | 78.95 | 78.95 | 5720.0 |
| 2020-06-01 05:49:00 | AAPL | Stock | 79.0 | 79.0 | 79.0 | 79.0 | 800.0 |
| 2020-06-01 06:02:00 | AAPL | Stock | 79.0 | 79.0 | 79.0 | 79.0 | 400.0 |
| 2020-06-01 06:03:00 | AAPL | Stock | 79.0 | 79.0 | 79.0 | 79.0 | 400.0 |
| 2020-06-01 06:09:00 | AAPL | Stock | 79.13 | 79.13 | 79.13 | 79.13 | 484.0 |
| 2020-06-01 06:12:00 | AAPL | Stock | 79.1375 | 79.1375 | 79.1375 | 79.1375 | 1200.0 |
| 2020-06-01 06:20:00 | AAPL | Stock | 79.245 | 79.245 | 79.245 | 79.245 | 636.0 |
| 2020-06-01 06:24:00 | AAPL | Stock | 79.2775 | 79.3 | 79.2775 | 79.3 | 800.0 |
| 2020-06-01 06:25:00 | AAPL | Stock | 79.3 | 79.3 | 79.3 | 79.3 | 412.0 |
| 2020-06-01 06:28:00 | AAPL | Stock | 79.2925 | 79.2925 | 79.2925 | 79.2925 | 400.0 |
| 2020-06-01 06:29:00 | AAPL | Stock | 79.25 | 79.25 | 79.25 | 79.25 | 400.0 |
| 2020-06-01 06:31:00 | AAPL | Stock | 79.25 | 79.25 | 79.25 | 79.25 | 1568.0 |
| 2020-06-01 06:32:00 | AAPL | Stock | 79.19 | 79.19 | 78.95 | 78.95 | 1600.0 |
| 2020-06-01 06:33:00 | AAPL | Stock | 79.1025 | 79.2375 | 79.085 | 79.085 | 1704.0 |
| 2020-06-01 06:41:00 | AAPL | Stock | 79.3425 | 79.3425 | 79.24 | 79.24 | 800.0 |
| 2020-06-01 06:53:00 | AAPL | Stock | 79.3325 | 79.3325 | 79.325 | 79.325 | 1200.0 |
| 2020-06-01 06:54:00 | AAPL | Stock | 79.345 | 79.3725 | 79.345 | 79.3725 | 1200.0 |
| 2020-06-01 06:58:00 | AAPL | Stock | 79.365 | 79.365 | 79.365 | 79.365 | 400.0 |
| 2020-06-01 06:59:00 | AAPL | Stock | 79.3 | 79.3 | 79.2775 | 79.2775 | 800.0 |
| 2020-06-01 07:00:00 | AAPL | Stock | 79.35 | 79.5 | 79.3025 | 79.5 | 29036.0 |
| 2020-06-01 07:01:00 | AAPL | Stock | 79.55 | 79.575 | 79.53 | 79.575 | 3400.0 |
| 2020-06-01 07:02:00 | AAPL | Stock | 79.5375 | 79.5625 | 79.5275 | 79.5625 | 3200.0 |
> showing 50 of 1,284,718 rows — these rows as CSV