PREVIEW / stock_1min / 2021-10-28
file: by_date/stock_1min/2021/2021-10-28.parquet size: 24.3 MB rows: 1,395,363 symbols: 2,307
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 |
|---|---|---|---|---|---|---|---|
| 2021-10-28 04:00:00 | AAPL | Stock | 149.2 | 149.39 | 149.2 | 149.39 | 260.0 |
| 2021-10-28 04:01:00 | AAPL | Stock | 149.47 | 149.48 | 149.39 | 149.39 | 1295.0 |
| 2021-10-28 04:02:00 | AAPL | Stock | 149.29 | 149.29 | 149.21 | 149.21 | 1216.0 |
| 2021-10-28 04:04:00 | AAPL | Stock | 149.27 | 149.27 | 149.27 | 149.27 | 269.0 |
| 2021-10-28 04:08:00 | AAPL | Stock | 149.23 | 149.23 | 149.23 | 149.23 | 131.0 |
| 2021-10-28 04:09:00 | AAPL | Stock | 149.27 | 149.27 | 149.27 | 149.27 | 135.0 |
| 2021-10-28 04:10:00 | AAPL | Stock | 149.2 | 149.2 | 149.2 | 149.2 | 1187.0 |
| 2021-10-28 04:12:00 | AAPL | Stock | 149.2 | 149.2 | 149.2 | 149.2 | 314.0 |
| 2021-10-28 04:13:00 | AAPL | Stock | 149.22 | 149.27 | 149.22 | 149.25 | 500.0 |
| 2021-10-28 04:15:00 | AAPL | Stock | 149.27 | 149.27 | 149.25 | 149.25 | 364.0 |
| 2021-10-28 04:20:00 | AAPL | Stock | 149.28 | 149.28 | 149.27 | 149.27 | 249.0 |
| 2021-10-28 04:23:00 | AAPL | Stock | 149.29 | 149.3 | 149.29 | 149.3 | 307.0 |
| 2021-10-28 04:25:00 | AAPL | Stock | 149.31 | 149.31 | 149.31 | 149.31 | 292.0 |
| 2021-10-28 04:27:00 | AAPL | Stock | 149.32 | 149.32 | 149.31 | 149.31 | 570.0 |
| 2021-10-28 04:32:00 | AAPL | Stock | 149.34 | 149.34 | 149.3 | 149.3 | 976.0 |
| 2021-10-28 04:33:00 | AAPL | Stock | 149.28 | 149.28 | 149.28 | 149.28 | 101.0 |
| 2021-10-28 04:35:00 | AAPL | Stock | 149.31 | 149.31 | 149.31 | 149.31 | 200.0 |
| 2021-10-28 04:38:00 | AAPL | Stock | 149.35 | 149.36 | 149.35 | 149.36 | 289.0 |
| 2021-10-28 04:42:00 | AAPL | Stock | 149.39 | 149.46 | 149.39 | 149.46 | 792.0 |
| 2021-10-28 04:45:00 | AAPL | Stock | 149.45 | 149.45 | 149.45 | 149.45 | 427.0 |
| 2021-10-28 04:48:00 | AAPL | Stock | 149.46 | 149.47 | 149.46 | 149.47 | 784.0 |
| 2021-10-28 04:49:00 | AAPL | Stock | 149.5 | 149.6 | 149.5 | 149.59 | 1557.0 |
| 2021-10-28 04:52:00 | AAPL | Stock | 149.48 | 149.48 | 149.48 | 149.48 | 500.0 |
| 2021-10-28 04:55:00 | AAPL | Stock | 149.41 | 149.41 | 149.41 | 149.41 | 300.0 |
| 2021-10-28 04:56:00 | AAPL | Stock | 149.41 | 149.41 | 149.41 | 149.41 | 100.0 |
| 2021-10-28 04:58:00 | AAPL | Stock | 149.4 | 149.4 | 149.38 | 149.38 | 621.0 |
| 2021-10-28 05:00:00 | AAPL | Stock | 149.4 | 149.4 | 149.4 | 149.4 | 238.0 |
| 2021-10-28 05:07:00 | AAPL | Stock | 149.41 | 149.41 | 149.41 | 149.41 | 1601.0 |
| 2021-10-28 05:09:00 | AAPL | Stock | 149.39 | 149.41 | 149.39 | 149.41 | 204.0 |
| 2021-10-28 05:10:00 | AAPL | Stock | 149.43 | 149.43 | 149.43 | 149.43 | 134.0 |
| 2021-10-28 05:12:00 | AAPL | Stock | 149.44 | 149.44 | 149.44 | 149.44 | 149.0 |
| 2021-10-28 05:13:00 | AAPL | Stock | 149.46 | 149.46 | 149.4 | 149.44 | 1288.0 |
| 2021-10-28 05:14:00 | AAPL | Stock | 149.45 | 149.45 | 149.45 | 149.45 | 298.0 |
| 2021-10-28 05:15:00 | AAPL | Stock | 149.41 | 149.44 | 149.41 | 149.44 | 1098.0 |
| 2021-10-28 05:16:00 | AAPL | Stock | 149.43 | 149.43 | 149.42 | 149.43 | 354.0 |
| 2021-10-28 05:17:00 | AAPL | Stock | 149.4 | 149.4 | 149.4 | 149.4 | 1504.0 |
| 2021-10-28 05:18:00 | AAPL | Stock | 149.4 | 149.4 | 149.4 | 149.4 | 430.0 |
| 2021-10-28 05:21:00 | AAPL | Stock | 149.38 | 149.38 | 149.38 | 149.38 | 134.0 |
| 2021-10-28 05:25:00 | AAPL | Stock | 149.38 | 149.38 | 149.38 | 149.38 | 100.0 |
| 2021-10-28 05:27:00 | AAPL | Stock | 149.39 | 149.39 | 149.39 | 149.39 | 306.0 |
| 2021-10-28 05:28:00 | AAPL | Stock | 149.37 | 149.37 | 149.37 | 149.37 | 100.0 |
| 2021-10-28 05:34:00 | AAPL | Stock | 149.34 | 149.34 | 149.34 | 149.34 | 151.0 |
| 2021-10-28 05:36:00 | AAPL | Stock | 149.37 | 149.37 | 149.37 | 149.37 | 916.0 |
| 2021-10-28 05:39:00 | AAPL | Stock | 149.42 | 149.42 | 149.42 | 149.42 | 200.0 |
| 2021-10-28 05:42:00 | AAPL | Stock | 149.42 | 149.42 | 149.4 | 149.4 | 1694.0 |
| 2021-10-28 05:43:00 | AAPL | Stock | 149.4 | 149.4 | 149.4 | 149.4 | 239.0 |
| 2021-10-28 05:44:00 | AAPL | Stock | 149.4 | 149.4 | 149.4 | 149.4 | 100.0 |
| 2021-10-28 05:45:00 | AAPL | Stock | 149.41 | 149.44 | 149.41 | 149.44 | 902.0 |
| 2021-10-28 05:46:00 | AAPL | Stock | 149.4 | 149.4 | 149.4 | 149.4 | 500.0 |
| 2021-10-28 05:49:00 | AAPL | Stock | 149.35 | 149.35 | 149.35 | 149.35 | 149.0 |
> showing 50 of 1,395,363 rows — these rows as CSV