PREVIEW / stock_1min / 2022-07-20
file: by_date/stock_1min/2022/2022-07-20.parquet size: 21.6 MB rows: 1,333,834 symbols: 2,040
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 |
|---|---|---|---|---|---|---|---|
| 2022-07-20 04:00:00 | AAPL | Stock | 151.6 | 151.6 | 151.45 | 151.48 | 1428.0 |
| 2022-07-20 04:01:00 | AAPL | Stock | 151.31 | 151.45 | 151.31 | 151.45 | 522.0 |
| 2022-07-20 04:02:00 | AAPL | Stock | 151.34 | 151.4 | 151.34 | 151.4 | 1452.0 |
| 2022-07-20 04:03:00 | AAPL | Stock | 151.45 | 151.45 | 151.45 | 151.45 | 905.0 |
| 2022-07-20 04:04:00 | AAPL | Stock | 151.48 | 151.48 | 151.48 | 151.48 | 200.0 |
| 2022-07-20 04:05:00 | AAPL | Stock | 151.48 | 151.48 | 151.48 | 151.48 | 100.0 |
| 2022-07-20 04:06:00 | AAPL | Stock | 151.42 | 151.45 | 151.42 | 151.42 | 650.0 |
| 2022-07-20 04:08:00 | AAPL | Stock | 151.49 | 151.5 | 151.49 | 151.5 | 1987.0 |
| 2022-07-20 04:09:00 | AAPL | Stock | 151.5 | 151.5 | 151.48 | 151.48 | 347.0 |
| 2022-07-20 04:10:00 | AAPL | Stock | 151.53 | 151.53 | 151.53 | 151.53 | 127.0 |
| 2022-07-20 04:11:00 | AAPL | Stock | 151.55 | 151.6 | 151.55 | 151.6 | 853.0 |
| 2022-07-20 04:15:00 | AAPL | Stock | 151.56 | 151.56 | 151.52 | 151.52 | 600.0 |
| 2022-07-20 04:16:00 | AAPL | Stock | 151.5 | 151.51 | 151.5 | 151.5 | 1347.0 |
| 2022-07-20 04:17:00 | AAPL | Stock | 151.56 | 151.58 | 151.55 | 151.55 | 497.0 |
| 2022-07-20 04:18:00 | AAPL | Stock | 151.5 | 151.5 | 151.5 | 151.5 | 148.0 |
| 2022-07-20 04:21:00 | AAPL | Stock | 151.33 | 151.33 | 151.3 | 151.3 | 500.0 |
| 2022-07-20 04:22:00 | AAPL | Stock | 151.36 | 151.36 | 151.34 | 151.34 | 409.0 |
| 2022-07-20 04:23:00 | AAPL | Stock | 151.33 | 151.34 | 151.25 | 151.25 | 4290.0 |
| 2022-07-20 04:24:00 | AAPL | Stock | 151.26 | 151.26 | 151.24 | 151.25 | 1545.0 |
| 2022-07-20 04:25:00 | AAPL | Stock | 151.19 | 151.19 | 151.19 | 151.19 | 800.0 |
| 2022-07-20 04:26:00 | AAPL | Stock | 151.24 | 151.24 | 151.19 | 151.19 | 645.0 |
| 2022-07-20 04:27:00 | AAPL | Stock | 151.17 | 151.18 | 151.16 | 151.17 | 1890.0 |
| 2022-07-20 04:28:00 | AAPL | Stock | 151.2 | 151.2 | 151.16 | 151.16 | 850.0 |
| 2022-07-20 04:29:00 | AAPL | Stock | 151.28 | 151.28 | 151.28 | 151.28 | 126.0 |
| 2022-07-20 04:31:00 | AAPL | Stock | 151.28 | 151.28 | 151.28 | 151.28 | 1995.0 |
| 2022-07-20 04:39:00 | AAPL | Stock | 151.25 | 151.25 | 151.24 | 151.24 | 422.0 |
| 2022-07-20 04:41:00 | AAPL | Stock | 151.24 | 151.24 | 151.24 | 151.24 | 187.0 |
| 2022-07-20 04:44:00 | AAPL | Stock | 151.3 | 151.3 | 151.3 | 151.3 | 314.0 |
| 2022-07-20 04:46:00 | AAPL | Stock | 151.12 | 151.12 | 151.12 | 151.12 | 110.0 |
| 2022-07-20 04:47:00 | AAPL | Stock | 151.2 | 151.2 | 151.2 | 151.2 | 131.0 |
| 2022-07-20 04:48:00 | AAPL | Stock | 151.19 | 151.19 | 151.19 | 151.19 | 866.0 |
| 2022-07-20 04:49:00 | AAPL | Stock | 151.26 | 151.32 | 151.26 | 151.32 | 1576.0 |
| 2022-07-20 04:51:00 | AAPL | Stock | 151.32 | 151.32 | 151.32 | 151.32 | 167.0 |
| 2022-07-20 04:54:00 | AAPL | Stock | 151.32 | 151.32 | 151.31 | 151.32 | 735.0 |
| 2022-07-20 04:55:00 | AAPL | Stock | 151.35 | 151.35 | 151.35 | 151.35 | 200.0 |
| 2022-07-20 04:57:00 | AAPL | Stock | 151.42 | 151.42 | 151.35 | 151.35 | 750.0 |
| 2022-07-20 04:59:00 | AAPL | Stock | 151.4 | 151.4 | 151.4 | 151.4 | 265.0 |
| 2022-07-20 05:03:00 | AAPL | Stock | 151.41 | 151.41 | 151.41 | 151.41 | 100.0 |
| 2022-07-20 05:05:00 | AAPL | Stock | 151.4 | 151.4 | 151.4 | 151.4 | 465.0 |
| 2022-07-20 05:15:00 | AAPL | Stock | 151.43 | 151.45 | 151.43 | 151.45 | 1516.0 |
| 2022-07-20 05:16:00 | AAPL | Stock | 151.45 | 151.45 | 151.45 | 151.45 | 273.0 |
| 2022-07-20 05:17:00 | AAPL | Stock | 151.38 | 151.38 | 151.38 | 151.38 | 289.0 |
| 2022-07-20 05:23:00 | AAPL | Stock | 151.31 | 151.31 | 151.31 | 151.31 | 100.0 |
| 2022-07-20 05:29:00 | AAPL | Stock | 151.27 | 151.27 | 151.27 | 151.27 | 200.0 |
| 2022-07-20 05:30:00 | AAPL | Stock | 151.26 | 151.26 | 151.26 | 151.26 | 245.0 |
| 2022-07-20 05:40:00 | AAPL | Stock | 151.47 | 151.5 | 151.47 | 151.5 | 5928.0 |
| 2022-07-20 05:48:00 | AAPL | Stock | 151.49 | 151.5 | 151.49 | 151.5 | 1750.0 |
| 2022-07-20 05:50:00 | AAPL | Stock | 151.53 | 151.53 | 151.53 | 151.53 | 211.0 |
| 2022-07-20 05:51:00 | AAPL | Stock | 151.55 | 151.55 | 151.55 | 151.55 | 200.0 |
| 2022-07-20 05:52:00 | AAPL | Stock | 151.55 | 151.6 | 151.55 | 151.6 | 300.0 |
> showing 50 of 1,333,834 rows — these rows as CSV