PREVIEW / stock_1min / 2020-09-22
file: by_date/stock_1min/2020/2020-09-22.parquet size: 19.4 MB rows: 1,241,877 symbols: 2,109
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-09-22 04:00:00 | AAPL | Stock | 111.0 | 111.0 | 110.0 | 110.29 | 4393.0 |
| 2020-09-22 04:01:00 | AAPL | Stock | 110.2 | 110.5 | 110.2 | 110.5 | 2617.0 |
| 2020-09-22 04:02:00 | AAPL | Stock | 110.5 | 110.51 | 110.48 | 110.48 | 906.0 |
| 2020-09-22 04:03:00 | AAPL | Stock | 110.5 | 110.59 | 110.4 | 110.59 | 4253.0 |
| 2020-09-22 04:04:00 | AAPL | Stock | 110.59 | 110.59 | 110.54 | 110.55 | 728.0 |
| 2020-09-22 04:05:00 | AAPL | Stock | 110.59 | 110.59 | 110.54 | 110.54 | 745.0 |
| 2020-09-22 04:06:00 | AAPL | Stock | 110.56 | 110.56 | 110.08 | 110.08 | 4155.0 |
| 2020-09-22 04:07:00 | AAPL | Stock | 110.36 | 110.5 | 110.36 | 110.5 | 1054.0 |
| 2020-09-22 04:08:00 | AAPL | Stock | 110.54 | 110.59 | 110.54 | 110.59 | 1376.0 |
| 2020-09-22 04:09:00 | AAPL | Stock | 110.59 | 110.59 | 110.34 | 110.34 | 985.0 |
| 2020-09-22 04:10:00 | AAPL | Stock | 110.54 | 110.54 | 110.34 | 110.5 | 2370.0 |
| 2020-09-22 04:11:00 | AAPL | Stock | 110.51 | 110.53 | 110.51 | 110.53 | 400.0 |
| 2020-09-22 04:12:00 | AAPL | Stock | 110.54 | 110.54 | 110.54 | 110.54 | 190.0 |
| 2020-09-22 04:13:00 | AAPL | Stock | 110.49 | 110.69 | 110.49 | 110.64 | 2115.0 |
| 2020-09-22 04:14:00 | AAPL | Stock | 110.64 | 110.79 | 110.55 | 110.56 | 1303.0 |
| 2020-09-22 04:15:00 | AAPL | Stock | 110.65 | 110.7 | 110.65 | 110.7 | 1548.0 |
| 2020-09-22 04:16:00 | AAPL | Stock | 110.75 | 110.84 | 110.75 | 110.84 | 1494.0 |
| 2020-09-22 04:17:00 | AAPL | Stock | 110.84 | 110.9 | 110.81 | 110.9 | 1854.0 |
| 2020-09-22 04:18:00 | AAPL | Stock | 110.9 | 110.91 | 110.89 | 110.9 | 1333.0 |
| 2020-09-22 04:19:00 | AAPL | Stock | 110.88 | 110.9 | 110.8 | 110.8 | 1108.0 |
| 2020-09-22 04:20:00 | AAPL | Stock | 110.71 | 110.71 | 110.71 | 110.71 | 200.0 |
| 2020-09-22 04:22:00 | AAPL | Stock | 110.76 | 110.77 | 110.56 | 110.77 | 2576.0 |
| 2020-09-22 04:23:00 | AAPL | Stock | 110.58 | 110.6 | 110.58 | 110.6 | 200.0 |
| 2020-09-22 04:24:00 | AAPL | Stock | 110.56 | 110.58 | 110.56 | 110.56 | 700.0 |
| 2020-09-22 04:25:00 | AAPL | Stock | 110.52 | 110.52 | 110.49 | 110.5 | 1499.0 |
| 2020-09-22 04:26:00 | AAPL | Stock | 110.5 | 110.57 | 110.45 | 110.57 | 1301.0 |
| 2020-09-22 04:27:00 | AAPL | Stock | 110.48 | 110.49 | 110.37 | 110.37 | 400.0 |
| 2020-09-22 04:28:00 | AAPL | Stock | 110.4 | 110.49 | 110.4 | 110.45 | 2273.0 |
| 2020-09-22 04:29:00 | AAPL | Stock | 110.49 | 110.59 | 110.49 | 110.59 | 824.0 |
| 2020-09-22 04:30:00 | AAPL | Stock | 110.59 | 110.59 | 110.59 | 110.59 | 422.0 |
| 2020-09-22 04:31:00 | AAPL | Stock | 110.64 | 110.64 | 110.64 | 110.64 | 100.0 |
| 2020-09-22 04:32:00 | AAPL | Stock | 110.64 | 110.73 | 110.64 | 110.73 | 1383.0 |
| 2020-09-22 04:33:00 | AAPL | Stock | 110.7 | 110.78 | 110.7 | 110.78 | 1227.0 |
| 2020-09-22 04:34:00 | AAPL | Stock | 110.81 | 110.86 | 110.8 | 110.85 | 1153.0 |
| 2020-09-22 04:35:00 | AAPL | Stock | 110.85 | 110.86 | 110.85 | 110.86 | 1187.0 |
| 2020-09-22 04:36:00 | AAPL | Stock | 110.86 | 110.88 | 110.86 | 110.88 | 1098.0 |
| 2020-09-22 04:37:00 | AAPL | Stock | 110.81 | 110.81 | 110.8 | 110.8 | 810.0 |
| 2020-09-22 04:38:00 | AAPL | Stock | 110.8 | 110.8 | 110.8 | 110.8 | 500.0 |
| 2020-09-22 04:39:00 | AAPL | Stock | 110.8 | 110.84 | 110.8 | 110.8 | 2630.0 |
| 2020-09-22 04:41:00 | AAPL | Stock | 110.72 | 110.72 | 110.64 | 110.65 | 1490.0 |
| 2020-09-22 04:42:00 | AAPL | Stock | 110.64 | 110.65 | 110.64 | 110.65 | 838.0 |
| 2020-09-22 04:45:00 | AAPL | Stock | 110.7 | 110.75 | 110.7 | 110.75 | 1540.0 |
| 2020-09-22 04:47:00 | AAPL | Stock | 110.75 | 110.78 | 110.75 | 110.78 | 555.0 |
| 2020-09-22 04:48:00 | AAPL | Stock | 110.78 | 110.78 | 110.43 | 110.43 | 1159.0 |
| 2020-09-22 04:49:00 | AAPL | Stock | 110.65 | 110.65 | 110.6 | 110.6 | 320.0 |
| 2020-09-22 04:50:00 | AAPL | Stock | 110.59 | 110.65 | 110.58 | 110.65 | 2023.0 |
| 2020-09-22 04:51:00 | AAPL | Stock | 110.63 | 110.63 | 110.63 | 110.63 | 200.0 |
| 2020-09-22 04:52:00 | AAPL | Stock | 110.52 | 110.52 | 110.5 | 110.5 | 2632.0 |
| 2020-09-22 04:53:00 | AAPL | Stock | 110.41 | 110.47 | 110.41 | 110.47 | 599.0 |
| 2020-09-22 04:54:00 | AAPL | Stock | 110.6 | 110.6 | 110.6 | 110.6 | 400.0 |
> showing 50 of 1,241,877 rows — these rows as CSV