PREVIEW / stock_1min / 2022-10-24
file: by_date/stock_1min/2022/2022-10-24.parquet size: 20.7 MB rows: 1,296,215 symbols: 1,927
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-10-24 04:00:00 | AAPL | Stock | 147.9 | 147.9 | 146.81 | 147.15 | 4442.0 |
| 2022-10-24 04:01:00 | AAPL | Stock | 146.96 | 147.0 | 146.9 | 146.9 | 5559.0 |
| 2022-10-24 04:02:00 | AAPL | Stock | 146.9 | 146.9 | 146.47 | 146.47 | 3537.0 |
| 2022-10-24 04:03:00 | AAPL | Stock | 146.45 | 146.55 | 146.01 | 146.01 | 2780.0 |
| 2022-10-24 04:04:00 | AAPL | Stock | 146.5 | 146.51 | 146.13 | 146.51 | 1389.0 |
| 2022-10-24 04:05:00 | AAPL | Stock | 146.26 | 146.26 | 146.19 | 146.24 | 6274.0 |
| 2022-10-24 04:06:00 | AAPL | Stock | 146.25 | 146.25 | 146.0 | 146.19 | 10717.0 |
| 2022-10-24 04:07:00 | AAPL | Stock | 146.01 | 146.27 | 146.0 | 146.27 | 5022.0 |
| 2022-10-24 04:08:00 | AAPL | Stock | 146.21 | 146.3 | 146.21 | 146.3 | 570.0 |
| 2022-10-24 04:09:00 | AAPL | Stock | 146.29 | 146.3 | 146.29 | 146.3 | 378.0 |
| 2022-10-24 04:10:00 | AAPL | Stock | 146.29 | 146.29 | 146.29 | 146.29 | 150.0 |
| 2022-10-24 04:11:00 | AAPL | Stock | 146.21 | 146.21 | 146.2 | 146.2 | 400.0 |
| 2022-10-24 04:12:00 | AAPL | Stock | 146.2 | 146.27 | 146.15 | 146.27 | 1206.0 |
| 2022-10-24 04:13:00 | AAPL | Stock | 146.31 | 146.31 | 146.16 | 146.16 | 300.0 |
| 2022-10-24 04:15:00 | AAPL | Stock | 146.31 | 146.4 | 146.31 | 146.35 | 669.0 |
| 2022-10-24 04:16:00 | AAPL | Stock | 146.37 | 146.4 | 146.37 | 146.4 | 475.0 |
| 2022-10-24 04:17:00 | AAPL | Stock | 146.21 | 146.21 | 146.21 | 146.21 | 300.0 |
| 2022-10-24 04:18:00 | AAPL | Stock | 146.16 | 146.16 | 146.13 | 146.14 | 1100.0 |
| 2022-10-24 04:19:00 | AAPL | Stock | 146.1 | 146.1 | 145.9 | 145.91 | 2970.0 |
| 2022-10-24 04:20:00 | AAPL | Stock | 145.93 | 145.93 | 145.92 | 145.92 | 360.0 |
| 2022-10-24 04:21:00 | AAPL | Stock | 145.9 | 145.9 | 145.86 | 145.9 | 3495.0 |
| 2022-10-24 04:22:00 | AAPL | Stock | 145.82 | 145.82 | 145.8 | 145.8 | 1948.0 |
| 2022-10-24 04:23:00 | AAPL | Stock | 145.81 | 145.9 | 145.75 | 145.9 | 3160.0 |
| 2022-10-24 04:24:00 | AAPL | Stock | 145.9 | 145.9 | 145.83 | 145.83 | 500.0 |
| 2022-10-24 04:25:00 | AAPL | Stock | 145.74 | 145.74 | 145.74 | 145.74 | 107.0 |
| 2022-10-24 04:27:00 | AAPL | Stock | 145.83 | 145.83 | 145.83 | 145.83 | 167.0 |
| 2022-10-24 04:28:00 | AAPL | Stock | 145.9 | 145.91 | 145.81 | 145.85 | 1736.0 |
| 2022-10-24 04:30:00 | AAPL | Stock | 145.77 | 145.77 | 145.64 | 145.64 | 2484.0 |
| 2022-10-24 04:32:00 | AAPL | Stock | 145.7 | 145.95 | 145.7 | 145.95 | 4545.0 |
| 2022-10-24 04:34:00 | AAPL | Stock | 145.81 | 145.81 | 145.81 | 145.81 | 200.0 |
| 2022-10-24 04:35:00 | AAPL | Stock | 145.85 | 145.85 | 145.85 | 145.85 | 100.0 |
| 2022-10-24 04:36:00 | AAPL | Stock | 145.75 | 145.75 | 145.75 | 145.75 | 100.0 |
| 2022-10-24 04:37:00 | AAPL | Stock | 145.8 | 145.98 | 145.8 | 145.9 | 1475.0 |
| 2022-10-24 04:38:00 | AAPL | Stock | 145.94 | 145.94 | 145.94 | 145.94 | 564.0 |
| 2022-10-24 04:39:00 | AAPL | Stock | 145.98 | 145.98 | 145.98 | 145.98 | 135.0 |
| 2022-10-24 04:41:00 | AAPL | Stock | 145.83 | 145.83 | 145.82 | 145.82 | 310.0 |
| 2022-10-24 04:42:00 | AAPL | Stock | 145.8 | 145.8 | 145.8 | 145.8 | 100.0 |
| 2022-10-24 04:43:00 | AAPL | Stock | 145.71 | 145.71 | 145.7 | 145.7 | 980.0 |
| 2022-10-24 04:44:00 | AAPL | Stock | 145.72 | 145.72 | 145.72 | 145.72 | 240.0 |
| 2022-10-24 04:45:00 | AAPL | Stock | 145.88 | 145.88 | 145.84 | 145.84 | 338.0 |
| 2022-10-24 04:46:00 | AAPL | Stock | 145.87 | 145.87 | 145.87 | 145.87 | 225.0 |
| 2022-10-24 04:47:00 | AAPL | Stock | 145.91 | 145.98 | 145.89 | 145.98 | 533.0 |
| 2022-10-24 04:50:00 | AAPL | Stock | 145.95 | 145.99 | 145.95 | 145.99 | 457.0 |
| 2022-10-24 04:51:00 | AAPL | Stock | 145.91 | 145.99 | 145.91 | 145.99 | 776.0 |
| 2022-10-24 04:54:00 | AAPL | Stock | 146.07 | 146.1 | 146.07 | 146.1 | 596.0 |
| 2022-10-24 04:55:00 | AAPL | Stock | 146.22 | 146.25 | 146.16 | 146.22 | 2599.0 |
| 2022-10-24 04:56:00 | AAPL | Stock | 146.22 | 146.26 | 146.22 | 146.22 | 700.0 |
| 2022-10-24 04:57:00 | AAPL | Stock | 146.18 | 146.21 | 146.18 | 146.2 | 1603.0 |
| 2022-10-24 04:58:00 | AAPL | Stock | 146.06 | 146.06 | 146.06 | 146.06 | 370.0 |
| 2022-10-24 05:01:00 | AAPL | Stock | 146.11 | 146.11 | 146.11 | 146.11 | 100.0 |
> showing 50 of 1,296,215 rows — these rows as CSV