PREVIEW / stock_1min / 2022-07-21
file: by_date/stock_1min/2022/2022-07-21.parquet size: 19.6 MB rows: 1,266,950 symbols: 2,020
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-07-21 04:00:00 | AAPL | Stock | 152.46 | 152.9 | 152.46 | 152.75 | 3263.0 |
| 2022-07-21 04:01:00 | AAPL | Stock | 152.76 | 152.76 | 152.76 | 152.76 | 395.0 |
| 2022-07-21 04:02:00 | AAPL | Stock | 152.76 | 153.01 | 152.76 | 152.91 | 4803.0 |
| 2022-07-21 04:04:00 | AAPL | Stock | 152.84 | 152.99 | 152.78 | 152.78 | 2654.0 |
| 2022-07-21 04:05:00 | AAPL | Stock | 152.77 | 152.77 | 152.77 | 152.77 | 398.0 |
| 2022-07-21 04:06:00 | AAPL | Stock | 152.79 | 152.79 | 152.76 | 152.76 | 550.0 |
| 2022-07-21 04:08:00 | AAPL | Stock | 152.81 | 152.81 | 152.81 | 152.81 | 400.0 |
| 2022-07-21 04:16:00 | AAPL | Stock | 152.8 | 152.8 | 152.79 | 152.79 | 1303.0 |
| 2022-07-21 04:17:00 | AAPL | Stock | 152.8 | 152.8 | 152.8 | 152.8 | 100.0 |
| 2022-07-21 04:18:00 | AAPL | Stock | 152.79 | 152.79 | 152.74 | 152.74 | 625.0 |
| 2022-07-21 04:19:00 | AAPL | Stock | 152.74 | 152.74 | 152.7 | 152.7 | 2661.0 |
| 2022-07-21 04:20:00 | AAPL | Stock | 152.7 | 152.7 | 152.7 | 152.7 | 200.0 |
| 2022-07-21 04:23:00 | AAPL | Stock | 152.71 | 152.71 | 152.7 | 152.7 | 1642.0 |
| 2022-07-21 04:25:00 | AAPL | Stock | 152.62 | 152.62 | 152.6 | 152.6 | 2001.0 |
| 2022-07-21 04:26:00 | AAPL | Stock | 152.63 | 152.66 | 152.63 | 152.66 | 221.0 |
| 2022-07-21 04:30:00 | AAPL | Stock | 152.63 | 152.63 | 152.63 | 152.63 | 150.0 |
| 2022-07-21 04:32:00 | AAPL | Stock | 152.61 | 152.61 | 152.61 | 152.61 | 830.0 |
| 2022-07-21 04:33:00 | AAPL | Stock | 152.71 | 152.71 | 152.71 | 152.71 | 401.0 |
| 2022-07-21 04:36:00 | AAPL | Stock | 152.78 | 152.8 | 152.78 | 152.8 | 337.0 |
| 2022-07-21 04:37:00 | AAPL | Stock | 152.88 | 152.89 | 152.88 | 152.89 | 273.0 |
| 2022-07-21 04:41:00 | AAPL | Stock | 152.85 | 152.85 | 152.85 | 152.85 | 150.0 |
| 2022-07-21 04:43:00 | AAPL | Stock | 152.8 | 152.8 | 152.8 | 152.8 | 100.0 |
| 2022-07-21 04:44:00 | AAPL | Stock | 152.74 | 152.74 | 152.74 | 152.74 | 105.0 |
| 2022-07-21 04:48:00 | AAPL | Stock | 152.76 | 152.76 | 152.76 | 152.76 | 122.0 |
| 2022-07-21 04:53:00 | AAPL | Stock | 152.76 | 152.76 | 152.76 | 152.76 | 250.0 |
| 2022-07-21 04:54:00 | AAPL | Stock | 152.77 | 152.77 | 152.77 | 152.77 | 200.0 |
| 2022-07-21 04:55:00 | AAPL | Stock | 152.82 | 152.83 | 152.82 | 152.83 | 838.0 |
| 2022-07-21 04:56:00 | AAPL | Stock | 152.84 | 152.84 | 152.84 | 152.84 | 200.0 |
| 2022-07-21 04:59:00 | AAPL | Stock | 152.97 | 153.0 | 152.91 | 152.99 | 2079.0 |
| 2022-07-21 05:00:00 | AAPL | Stock | 152.93 | 152.93 | 152.91 | 152.91 | 659.0 |
| 2022-07-21 05:01:00 | AAPL | Stock | 153.02 | 153.02 | 152.98 | 152.98 | 1380.0 |
| 2022-07-21 05:02:00 | AAPL | Stock | 152.92 | 152.92 | 152.92 | 152.92 | 483.0 |
| 2022-07-21 05:03:00 | AAPL | Stock | 152.89 | 152.89 | 152.89 | 152.89 | 100.0 |
| 2022-07-21 05:06:00 | AAPL | Stock | 152.98 | 153.0 | 152.98 | 153.0 | 1335.0 |
| 2022-07-21 05:11:00 | AAPL | Stock | 153.04 | 153.04 | 153.04 | 153.04 | 100.0 |
| 2022-07-21 05:12:00 | AAPL | Stock | 153.11 | 153.11 | 153.11 | 153.11 | 342.0 |
| 2022-07-21 05:14:00 | AAPL | Stock | 153.09 | 153.09 | 153.09 | 153.09 | 448.0 |
| 2022-07-21 05:20:00 | AAPL | Stock | 153.01 | 153.01 | 153.01 | 153.01 | 412.0 |
| 2022-07-21 05:23:00 | AAPL | Stock | 153.09 | 153.09 | 153.09 | 153.09 | 135.0 |
| 2022-07-21 05:24:00 | AAPL | Stock | 153.1 | 153.1 | 153.1 | 153.1 | 100.0 |
| 2022-07-21 05:25:00 | AAPL | Stock | 153.15 | 153.15 | 153.15 | 153.15 | 524.0 |
| 2022-07-21 05:27:00 | AAPL | Stock | 153.12 | 153.12 | 153.12 | 153.12 | 100.0 |
| 2022-07-21 05:33:00 | AAPL | Stock | 153.07 | 153.07 | 153.07 | 153.07 | 912.0 |
| 2022-07-21 05:37:00 | AAPL | Stock | 153.0 | 153.0 | 153.0 | 153.0 | 200.0 |
| 2022-07-21 05:41:00 | AAPL | Stock | 153.1 | 153.1 | 153.05 | 153.05 | 500.0 |
| 2022-07-21 05:42:00 | AAPL | Stock | 153.05 | 153.05 | 153.05 | 153.05 | 900.0 |
| 2022-07-21 05:51:00 | AAPL | Stock | 153.16 | 153.17 | 153.16 | 153.17 | 916.0 |
| 2022-07-21 05:53:00 | AAPL | Stock | 153.17 | 153.18 | 153.17 | 153.18 | 525.0 |
| 2022-07-21 05:56:00 | AAPL | Stock | 153.27 | 153.27 | 153.26 | 153.26 | 4845.0 |
| 2022-07-21 06:00:00 | AAPL | Stock | 153.33 | 153.4 | 153.32 | 153.4 | 2247.0 |
> showing 50 of 1,266,950 rows — these rows as CSV