PREVIEW / stock_1min / 2022-01-05
file: by_date/stock_1min/2022/2022-01-05.parquet size: 24.8 MB rows: 1,431,175 symbols: 2,274
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-01-05 04:00:00 | AAPL | Stock | 179.52 | 179.52 | 179.32 | 179.32 | 591.0 |
| 2022-01-05 04:03:00 | AAPL | Stock | 179.38 | 179.44 | 179.37 | 179.44 | 638.0 |
| 2022-01-05 04:04:00 | AAPL | Stock | 179.37 | 179.42 | 179.37 | 179.42 | 336.0 |
| 2022-01-05 04:05:00 | AAPL | Stock | 179.44 | 179.5 | 179.44 | 179.5 | 1759.0 |
| 2022-01-05 04:06:00 | AAPL | Stock | 179.52 | 179.52 | 179.5 | 179.5 | 300.0 |
| 2022-01-05 04:09:00 | AAPL | Stock | 179.5 | 179.5 | 179.5 | 179.5 | 489.0 |
| 2022-01-05 04:11:00 | AAPL | Stock | 179.55 | 179.55 | 179.5 | 179.5 | 588.0 |
| 2022-01-05 04:12:00 | AAPL | Stock | 179.5 | 179.5 | 179.47 | 179.47 | 1010.0 |
| 2022-01-05 04:13:00 | AAPL | Stock | 179.45 | 179.45 | 179.45 | 179.45 | 250.0 |
| 2022-01-05 04:14:00 | AAPL | Stock | 179.5 | 179.54 | 179.5 | 179.54 | 200.0 |
| 2022-01-05 04:15:00 | AAPL | Stock | 179.58 | 179.58 | 179.58 | 179.58 | 384.0 |
| 2022-01-05 04:17:00 | AAPL | Stock | 179.65 | 179.7 | 179.65 | 179.7 | 1112.0 |
| 2022-01-05 04:18:00 | AAPL | Stock | 179.69 | 179.69 | 179.69 | 179.69 | 100.0 |
| 2022-01-05 04:19:00 | AAPL | Stock | 179.79 | 179.79 | 179.75 | 179.79 | 1410.0 |
| 2022-01-05 04:20:00 | AAPL | Stock | 179.79 | 179.8 | 179.79 | 179.8 | 900.0 |
| 2022-01-05 04:23:00 | AAPL | Stock | 179.68 | 179.68 | 179.68 | 179.68 | 419.0 |
| 2022-01-05 04:25:00 | AAPL | Stock | 179.68 | 179.68 | 179.68 | 179.68 | 100.0 |
| 2022-01-05 04:26:00 | AAPL | Stock | 179.71 | 179.76 | 179.71 | 179.76 | 500.0 |
| 2022-01-05 04:27:00 | AAPL | Stock | 179.71 | 179.71 | 179.71 | 179.71 | 200.0 |
| 2022-01-05 04:31:00 | AAPL | Stock | 179.74 | 179.74 | 179.74 | 179.74 | 100.0 |
| 2022-01-05 04:32:00 | AAPL | Stock | 179.72 | 179.72 | 179.68 | 179.68 | 632.0 |
| 2022-01-05 04:34:00 | AAPL | Stock | 179.7 | 179.7 | 179.7 | 179.7 | 197.0 |
| 2022-01-05 04:36:00 | AAPL | Stock | 179.65 | 179.65 | 179.65 | 179.65 | 929.0 |
| 2022-01-05 04:37:00 | AAPL | Stock | 179.68 | 179.69 | 179.68 | 179.69 | 200.0 |
| 2022-01-05 04:42:00 | AAPL | Stock | 179.65 | 179.65 | 179.65 | 179.65 | 147.0 |
| 2022-01-05 04:43:00 | AAPL | Stock | 179.62 | 179.62 | 179.62 | 179.62 | 100.0 |
| 2022-01-05 04:45:00 | AAPL | Stock | 179.66 | 179.66 | 179.66 | 179.66 | 398.0 |
| 2022-01-05 04:47:00 | AAPL | Stock | 179.66 | 179.66 | 179.6 | 179.6 | 1160.0 |
| 2022-01-05 04:48:00 | AAPL | Stock | 179.59 | 179.59 | 179.59 | 179.59 | 299.0 |
| 2022-01-05 04:51:00 | AAPL | Stock | 179.57 | 179.57 | 179.57 | 179.57 | 350.0 |
| 2022-01-05 04:55:00 | AAPL | Stock | 179.64 | 179.64 | 179.6 | 179.6 | 200.0 |
| 2022-01-05 04:57:00 | AAPL | Stock | 179.64 | 179.64 | 179.64 | 179.64 | 600.0 |
| 2022-01-05 05:02:00 | AAPL | Stock | 179.76 | 179.97 | 179.76 | 179.97 | 665.0 |
| 2022-01-05 05:03:00 | AAPL | Stock | 179.76 | 179.82 | 179.76 | 179.82 | 235.0 |
| 2022-01-05 05:04:00 | AAPL | Stock | 179.81 | 179.85 | 179.8 | 179.85 | 1020.0 |
| 2022-01-05 05:07:00 | AAPL | Stock | 179.82 | 179.82 | 179.81 | 179.81 | 299.0 |
| 2022-01-05 05:08:00 | AAPL | Stock | 179.84 | 179.84 | 179.84 | 179.84 | 300.0 |
| 2022-01-05 05:11:00 | AAPL | Stock | 179.92 | 179.92 | 179.92 | 179.92 | 289.0 |
| 2022-01-05 05:12:00 | AAPL | Stock | 179.92 | 179.92 | 179.85 | 179.85 | 604.0 |
| 2022-01-05 05:14:00 | AAPL | Stock | 179.78 | 179.78 | 179.78 | 179.78 | 600.0 |
| 2022-01-05 05:20:00 | AAPL | Stock | 179.82 | 179.82 | 179.82 | 179.82 | 100.0 |
| 2022-01-05 05:21:00 | AAPL | Stock | 179.84 | 179.84 | 179.84 | 179.84 | 400.0 |
| 2022-01-05 05:23:00 | AAPL | Stock | 179.84 | 179.84 | 179.84 | 179.84 | 316.0 |
| 2022-01-05 05:26:00 | AAPL | Stock | 179.85 | 179.85 | 179.85 | 179.85 | 176.0 |
| 2022-01-05 05:30:00 | AAPL | Stock | 180.0 | 180.0 | 180.0 | 180.0 | 741.0 |
| 2022-01-05 05:31:00 | AAPL | Stock | 180.23 | 180.24 | 180.23 | 180.24 | 359.0 |
| 2022-01-05 05:32:00 | AAPL | Stock | 180.15 | 180.15 | 180.05 | 180.05 | 891.0 |
| 2022-01-05 05:34:00 | AAPL | Stock | 179.9 | 179.9 | 179.9 | 179.9 | 219.0 |
| 2022-01-05 05:37:00 | AAPL | Stock | 179.91 | 179.91 | 179.91 | 179.91 | 100.0 |
| 2022-01-05 05:38:00 | AAPL | Stock | 179.81 | 179.81 | 179.81 | 179.81 | 400.0 |
> showing 50 of 1,431,175 rows — these rows as CSV