PREVIEW / stock_1min / 2023-07-19
file: by_date/stock_1min/2023/2023-07-19.parquet size: 21.5 MB rows: 1,288,810 symbols: 1,482
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 |
|---|---|---|---|---|---|---|---|
| 2023-07-19 04:01:00 | AAPL | Stock | 193.64 | 193.64 | 193.64 | 193.64 | 100.0 |
| 2023-07-19 04:02:00 | AAPL | Stock | 193.64 | 193.64 | 193.64 | 193.64 | 1349.0 |
| 2023-07-19 04:03:00 | AAPL | Stock | 193.58 | 193.58 | 193.58 | 193.58 | 772.0 |
| 2023-07-19 04:04:00 | AAPL | Stock | 193.58 | 193.58 | 193.58 | 193.58 | 240.0 |
| 2023-07-19 04:06:00 | AAPL | Stock | 193.58 | 193.58 | 193.58 | 193.58 | 200.0 |
| 2023-07-19 04:07:00 | AAPL | Stock | 193.58 | 193.58 | 193.58 | 193.58 | 300.0 |
| 2023-07-19 04:16:00 | AAPL | Stock | 193.5 | 193.5 | 193.5 | 193.5 | 112.0 |
| 2023-07-19 04:19:00 | AAPL | Stock | 193.52 | 193.56 | 193.51 | 193.51 | 844.0 |
| 2023-07-19 04:20:00 | AAPL | Stock | 193.51 | 193.51 | 193.51 | 193.51 | 100.0 |
| 2023-07-19 04:22:00 | AAPL | Stock | 193.54 | 193.54 | 193.54 | 193.54 | 100.0 |
| 2023-07-19 04:26:00 | AAPL | Stock | 193.63 | 193.63 | 193.63 | 193.63 | 100.0 |
| 2023-07-19 04:30:00 | AAPL | Stock | 193.63 | 193.63 | 193.63 | 193.63 | 379.0 |
| 2023-07-19 04:38:00 | AAPL | Stock | 193.65 | 193.65 | 193.65 | 193.65 | 948.0 |
| 2023-07-19 04:44:00 | AAPL | Stock | 193.65 | 193.65 | 193.65 | 193.65 | 199.0 |
| 2023-07-19 04:45:00 | AAPL | Stock | 193.66 | 193.66 | 193.66 | 193.66 | 100.0 |
| 2023-07-19 04:46:00 | AAPL | Stock | 193.65 | 193.65 | 193.65 | 193.65 | 100.0 |
| 2023-07-19 04:47:00 | AAPL | Stock | 193.65 | 193.65 | 193.65 | 193.65 | 111.0 |
| 2023-07-19 04:51:00 | AAPL | Stock | 193.65 | 193.65 | 193.65 | 193.65 | 452.0 |
| 2023-07-19 04:52:00 | AAPL | Stock | 193.6 | 193.6 | 193.6 | 193.6 | 100.0 |
| 2023-07-19 04:53:00 | AAPL | Stock | 193.45 | 193.45 | 193.45 | 193.45 | 199.0 |
| 2023-07-19 04:59:00 | AAPL | Stock | 193.6 | 193.6 | 193.6 | 193.6 | 284.0 |
| 2023-07-19 05:02:00 | AAPL | Stock | 193.55 | 193.55 | 193.55 | 193.55 | 100.0 |
| 2023-07-19 05:17:00 | AAPL | Stock | 193.5 | 193.5 | 193.5 | 193.5 | 209.0 |
| 2023-07-19 05:27:00 | AAPL | Stock | 193.48 | 193.48 | 193.39 | 193.39 | 411.0 |
| 2023-07-19 05:29:00 | AAPL | Stock | 193.39 | 193.41 | 193.39 | 193.41 | 859.0 |
| 2023-07-19 05:36:00 | AAPL | Stock | 193.57 | 193.57 | 193.57 | 193.57 | 169.0 |
| 2023-07-19 05:41:00 | AAPL | Stock | 193.57 | 193.57 | 193.57 | 193.57 | 200.0 |
| 2023-07-19 05:42:00 | AAPL | Stock | 193.57 | 193.6 | 193.57 | 193.6 | 603.0 |
| 2023-07-19 05:43:00 | AAPL | Stock | 193.64 | 193.64 | 193.64 | 193.64 | 300.0 |
| 2023-07-19 05:48:00 | AAPL | Stock | 193.65 | 193.66 | 193.65 | 193.66 | 389.0 |
| 2023-07-19 05:56:00 | AAPL | Stock | 193.64 | 193.64 | 193.64 | 193.64 | 125.0 |
| 2023-07-19 05:59:00 | AAPL | Stock | 193.59 | 193.59 | 193.59 | 193.59 | 200.0 |
| 2023-07-19 06:00:00 | AAPL | Stock | 193.53 | 193.53 | 193.5 | 193.5 | 648.0 |
| 2023-07-19 06:01:00 | AAPL | Stock | 193.47 | 193.47 | 193.47 | 193.47 | 655.0 |
| 2023-07-19 06:03:00 | AAPL | Stock | 193.48 | 193.48 | 193.47 | 193.47 | 967.0 |
| 2023-07-19 06:04:00 | AAPL | Stock | 193.54 | 193.54 | 193.54 | 193.54 | 149.0 |
| 2023-07-19 06:05:00 | AAPL | Stock | 193.45 | 193.45 | 193.42 | 193.42 | 719.0 |
| 2023-07-19 06:07:00 | AAPL | Stock | 193.43 | 193.43 | 193.43 | 193.43 | 110.0 |
| 2023-07-19 06:08:00 | AAPL | Stock | 193.43 | 193.43 | 193.31 | 193.37 | 3254.0 |
| 2023-07-19 06:09:00 | AAPL | Stock | 193.33 | 193.33 | 193.33 | 193.33 | 100.0 |
| 2023-07-19 06:10:00 | AAPL | Stock | 193.44 | 193.44 | 193.44 | 193.44 | 252.0 |
| 2023-07-19 06:15:00 | AAPL | Stock | 193.4 | 193.4 | 193.4 | 193.4 | 212.0 |
| 2023-07-19 06:20:00 | AAPL | Stock | 193.34 | 193.34 | 193.3 | 193.3 | 600.0 |
| 2023-07-19 06:26:00 | AAPL | Stock | 193.37 | 193.37 | 193.37 | 193.37 | 156.0 |
| 2023-07-19 06:27:00 | AAPL | Stock | 193.35 | 193.35 | 193.3 | 193.3 | 295.0 |
| 2023-07-19 06:28:00 | AAPL | Stock | 193.3 | 193.3 | 193.3 | 193.3 | 400.0 |
| 2023-07-19 06:29:00 | AAPL | Stock | 193.3 | 193.3 | 193.29 | 193.29 | 543.0 |
| 2023-07-19 06:33:00 | AAPL | Stock | 193.27 | 193.28 | 193.27 | 193.28 | 389.0 |
| 2023-07-19 06:37:00 | AAPL | Stock | 193.27 | 193.27 | 193.25 | 193.25 | 677.0 |
| 2023-07-19 06:38:00 | AAPL | Stock | 193.23 | 193.23 | 193.11 | 193.11 | 1981.0 |
> showing 50 of 1,288,810 rows — these rows as CSV