PREVIEW / stock_1min / 2022-01-12
file: by_date/stock_1min/2022/2022-01-12.parquet size: 23.4 MB rows: 1,364,826 symbols: 2,247
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-12 04:00:00 | AAPL | Stock | 174.65 | 174.8 | 174.65 | 174.8 | 972.0 |
| 2022-01-12 04:01:00 | AAPL | Stock | 174.93 | 174.93 | 174.93 | 174.93 | 698.0 |
| 2022-01-12 04:02:00 | AAPL | Stock | 175.05 | 175.05 | 174.91 | 174.91 | 683.0 |
| 2022-01-12 04:03:00 | AAPL | Stock | 174.82 | 174.88 | 174.82 | 174.82 | 1636.0 |
| 2022-01-12 04:04:00 | AAPL | Stock | 174.85 | 174.86 | 174.84 | 174.86 | 1360.0 |
| 2022-01-12 04:05:00 | AAPL | Stock | 174.89 | 174.9 | 174.89 | 174.9 | 266.0 |
| 2022-01-12 04:06:00 | AAPL | Stock | 174.9 | 174.9 | 174.9 | 174.9 | 100.0 |
| 2022-01-12 04:07:00 | AAPL | Stock | 174.88 | 174.9 | 174.88 | 174.9 | 847.0 |
| 2022-01-12 04:09:00 | AAPL | Stock | 174.9 | 174.9 | 174.82 | 174.82 | 400.0 |
| 2022-01-12 04:10:00 | AAPL | Stock | 174.81 | 174.81 | 174.81 | 174.81 | 300.0 |
| 2022-01-12 04:11:00 | AAPL | Stock | 174.8 | 174.8 | 174.77 | 174.8 | 894.0 |
| 2022-01-12 04:12:00 | AAPL | Stock | 174.86 | 174.86 | 174.85 | 174.85 | 552.0 |
| 2022-01-12 04:13:00 | AAPL | Stock | 174.8 | 174.81 | 174.8 | 174.8 | 1555.0 |
| 2022-01-12 04:14:00 | AAPL | Stock | 174.75 | 174.75 | 174.7 | 174.7 | 815.0 |
| 2022-01-12 04:15:00 | AAPL | Stock | 174.65 | 174.71 | 174.65 | 174.71 | 673.0 |
| 2022-01-12 04:17:00 | AAPL | Stock | 174.72 | 174.75 | 174.72 | 174.75 | 508.0 |
| 2022-01-12 04:18:00 | AAPL | Stock | 174.75 | 174.77 | 174.75 | 174.77 | 327.0 |
| 2022-01-12 04:19:00 | AAPL | Stock | 174.84 | 174.84 | 174.84 | 174.84 | 400.0 |
| 2022-01-12 04:20:00 | AAPL | Stock | 174.94 | 174.94 | 174.94 | 174.94 | 250.0 |
| 2022-01-12 04:21:00 | AAPL | Stock | 174.95 | 174.95 | 174.95 | 174.95 | 100.0 |
| 2022-01-12 04:22:00 | AAPL | Stock | 175.0 | 175.0 | 175.0 | 175.0 | 200.0 |
| 2022-01-12 04:23:00 | AAPL | Stock | 174.99 | 175.02 | 174.99 | 175.02 | 300.0 |
| 2022-01-12 04:26:00 | AAPL | Stock | 175.18 | 175.18 | 175.16 | 175.16 | 662.0 |
| 2022-01-12 04:30:00 | AAPL | Stock | 175.24 | 175.29 | 175.24 | 175.26 | 946.0 |
| 2022-01-12 04:31:00 | AAPL | Stock | 175.26 | 175.26 | 175.24 | 175.24 | 665.0 |
| 2022-01-12 04:32:00 | AAPL | Stock | 175.22 | 175.24 | 175.21 | 175.22 | 750.0 |
| 2022-01-12 04:36:00 | AAPL | Stock | 175.29 | 175.4 | 175.29 | 175.4 | 438.0 |
| 2022-01-12 04:37:00 | AAPL | Stock | 175.39 | 175.41 | 175.39 | 175.39 | 438.0 |
| 2022-01-12 04:38:00 | AAPL | Stock | 175.47 | 175.47 | 175.31 | 175.31 | 1133.0 |
| 2022-01-12 04:39:00 | AAPL | Stock | 175.29 | 175.29 | 175.24 | 175.27 | 408.0 |
| 2022-01-12 04:42:00 | AAPL | Stock | 175.35 | 175.35 | 175.35 | 175.35 | 248.0 |
| 2022-01-12 04:44:00 | AAPL | Stock | 175.43 | 175.44 | 175.43 | 175.44 | 400.0 |
| 2022-01-12 04:45:00 | AAPL | Stock | 175.45 | 175.45 | 175.44 | 175.44 | 585.0 |
| 2022-01-12 04:46:00 | AAPL | Stock | 175.44 | 175.59 | 175.44 | 175.59 | 925.0 |
| 2022-01-12 04:47:00 | AAPL | Stock | 175.59 | 175.6 | 175.59 | 175.6 | 755.0 |
| 2022-01-12 04:48:00 | AAPL | Stock | 175.64 | 175.64 | 175.64 | 175.64 | 200.0 |
| 2022-01-12 04:50:00 | AAPL | Stock | 175.65 | 175.65 | 175.65 | 175.65 | 100.0 |
| 2022-01-12 04:54:00 | AAPL | Stock | 175.75 | 175.79 | 175.75 | 175.79 | 539.0 |
| 2022-01-12 04:55:00 | AAPL | Stock | 175.76 | 175.83 | 175.71 | 175.83 | 1695.0 |
| 2022-01-12 04:56:00 | AAPL | Stock | 175.84 | 175.84 | 175.84 | 175.84 | 219.0 |
| 2022-01-12 04:57:00 | AAPL | Stock | 175.82 | 175.82 | 175.82 | 175.82 | 175.0 |
| 2022-01-12 04:58:00 | AAPL | Stock | 175.88 | 175.89 | 175.88 | 175.89 | 830.0 |
| 2022-01-12 04:59:00 | AAPL | Stock | 175.87 | 175.87 | 175.82 | 175.82 | 483.0 |
| 2022-01-12 05:00:00 | AAPL | Stock | 175.86 | 175.87 | 175.86 | 175.87 | 960.0 |
| 2022-01-12 05:01:00 | AAPL | Stock | 175.87 | 175.87 | 175.87 | 175.87 | 745.0 |
| 2022-01-12 05:02:00 | AAPL | Stock | 175.83 | 175.83 | 175.83 | 175.83 | 150.0 |
| 2022-01-12 05:03:00 | AAPL | Stock | 175.82 | 175.82 | 175.8 | 175.8 | 413.0 |
| 2022-01-12 05:04:00 | AAPL | Stock | 175.78 | 175.78 | 175.78 | 175.78 | 194.0 |
| 2022-01-12 05:06:00 | AAPL | Stock | 175.74 | 175.74 | 175.74 | 175.74 | 113.0 |
| 2022-01-12 05:07:00 | AAPL | Stock | 175.73 | 175.73 | 175.73 | 175.73 | 100.0 |
> showing 50 of 1,364,826 rows — these rows as CSV