PREVIEW / stock_1min / 2023-09-27
file: by_date/stock_1min/2023/2023-09-27.parquet size: 19.9 MB rows: 1,233,023 symbols: 1,360
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-09-27 04:00:00 | AAPL | Stock | 172.71 | 173.32 | 172.5 | 173.23 | 3766.0 |
| 2023-09-27 04:01:00 | AAPL | Stock | 173.05 | 173.05 | 173.05 | 173.05 | 1529.0 |
| 2023-09-27 04:02:00 | AAPL | Stock | 172.9 | 172.9 | 172.9 | 172.9 | 1050.0 |
| 2023-09-27 04:03:00 | AAPL | Stock | 172.9 | 173.0 | 172.9 | 173.0 | 1300.0 |
| 2023-09-27 04:04:00 | AAPL | Stock | 172.97 | 172.99 | 172.95 | 172.99 | 1040.0 |
| 2023-09-27 04:05:00 | AAPL | Stock | 172.95 | 172.95 | 172.86 | 172.86 | 1250.0 |
| 2023-09-27 04:06:00 | AAPL | Stock | 172.99 | 172.99 | 172.9 | 172.9 | 621.0 |
| 2023-09-27 04:07:00 | AAPL | Stock | 172.96 | 173.0 | 172.96 | 173.0 | 400.0 |
| 2023-09-27 04:08:00 | AAPL | Stock | 172.98 | 172.98 | 172.98 | 172.98 | 117.0 |
| 2023-09-27 04:10:00 | AAPL | Stock | 173.05 | 173.05 | 173.05 | 173.05 | 100.0 |
| 2023-09-27 04:11:00 | AAPL | Stock | 172.98 | 172.98 | 172.96 | 172.96 | 1215.0 |
| 2023-09-27 04:12:00 | AAPL | Stock | 172.96 | 172.96 | 172.92 | 172.92 | 1000.0 |
| 2023-09-27 04:14:00 | AAPL | Stock | 172.88 | 172.88 | 172.85 | 172.85 | 1151.0 |
| 2023-09-27 04:16:00 | AAPL | Stock | 172.84 | 172.88 | 172.83 | 172.83 | 790.0 |
| 2023-09-27 04:20:00 | AAPL | Stock | 172.83 | 172.83 | 172.83 | 172.83 | 202.0 |
| 2023-09-27 04:21:00 | AAPL | Stock | 172.83 | 172.88 | 172.83 | 172.88 | 549.0 |
| 2023-09-27 04:22:00 | AAPL | Stock | 172.87 | 172.89 | 172.87 | 172.89 | 1204.0 |
| 2023-09-27 04:25:00 | AAPL | Stock | 172.98 | 172.98 | 172.98 | 172.98 | 100.0 |
| 2023-09-27 04:29:00 | AAPL | Stock | 172.88 | 172.88 | 172.88 | 172.88 | 100.0 |
| 2023-09-27 04:31:00 | AAPL | Stock | 172.95 | 172.97 | 172.95 | 172.95 | 483.0 |
| 2023-09-27 04:32:00 | AAPL | Stock | 172.98 | 172.98 | 172.98 | 172.98 | 100.0 |
| 2023-09-27 04:33:00 | AAPL | Stock | 172.96 | 172.96 | 172.96 | 172.96 | 279.0 |
| 2023-09-27 04:34:00 | AAPL | Stock | 173.0 | 173.03 | 172.99 | 172.99 | 558.0 |
| 2023-09-27 04:41:00 | AAPL | Stock | 172.96 | 172.98 | 172.96 | 172.98 | 1152.0 |
| 2023-09-27 04:46:00 | AAPL | Stock | 172.95 | 172.95 | 172.95 | 172.95 | 325.0 |
| 2023-09-27 05:06:00 | AAPL | Stock | 172.9 | 172.9 | 172.9 | 172.9 | 100.0 |
| 2023-09-27 05:08:00 | AAPL | Stock | 172.88 | 172.88 | 172.88 | 172.88 | 150.0 |
| 2023-09-27 05:12:00 | AAPL | Stock | 172.83 | 172.83 | 172.83 | 172.83 | 202.0 |
| 2023-09-27 05:15:00 | AAPL | Stock | 172.86 | 172.86 | 172.86 | 172.86 | 100.0 |
| 2023-09-27 05:18:00 | AAPL | Stock | 172.86 | 172.86 | 172.86 | 172.86 | 481.0 |
| 2023-09-27 05:24:00 | AAPL | Stock | 172.88 | 172.88 | 172.88 | 172.88 | 125.0 |
| 2023-09-27 05:31:00 | AAPL | Stock | 172.88 | 172.88 | 172.88 | 172.88 | 134.0 |
| 2023-09-27 05:40:00 | AAPL | Stock | 172.78 | 172.78 | 172.76 | 172.76 | 324.0 |
| 2023-09-27 05:45:00 | AAPL | Stock | 172.62 | 172.66 | 172.62 | 172.66 | 2331.0 |
| 2023-09-27 05:46:00 | AAPL | Stock | 172.66 | 172.66 | 172.66 | 172.66 | 200.0 |
| 2023-09-27 05:55:00 | AAPL | Stock | 172.67 | 172.67 | 172.67 | 172.67 | 300.0 |
| 2023-09-27 06:00:00 | AAPL | Stock | 172.69 | 172.7 | 172.69 | 172.7 | 438.0 |
| 2023-09-27 06:02:00 | AAPL | Stock | 172.69 | 172.69 | 172.69 | 172.69 | 190.0 |
| 2023-09-27 06:04:00 | AAPL | Stock | 172.6 | 172.6 | 172.6 | 172.6 | 100.0 |
| 2023-09-27 06:09:00 | AAPL | Stock | 172.62 | 172.62 | 172.6 | 172.6 | 852.0 |
| 2023-09-27 06:14:00 | AAPL | Stock | 172.55 | 172.55 | 172.55 | 172.55 | 448.0 |
| 2023-09-27 06:15:00 | AAPL | Stock | 172.54 | 172.54 | 172.54 | 172.54 | 200.0 |
| 2023-09-27 06:16:00 | AAPL | Stock | 172.57 | 172.6 | 172.57 | 172.6 | 1661.0 |
| 2023-09-27 06:18:00 | AAPL | Stock | 172.65 | 172.65 | 172.65 | 172.65 | 235.0 |
| 2023-09-27 06:22:00 | AAPL | Stock | 172.7 | 172.7 | 172.7 | 172.7 | 132.0 |
| 2023-09-27 06:24:00 | AAPL | Stock | 172.65 | 172.7 | 172.65 | 172.7 | 427.0 |
| 2023-09-27 06:25:00 | AAPL | Stock | 172.69 | 172.7 | 172.69 | 172.7 | 1064.0 |
| 2023-09-27 06:27:00 | AAPL | Stock | 172.74 | 172.74 | 172.74 | 172.74 | 263.0 |
| 2023-09-27 06:30:00 | AAPL | Stock | 172.8 | 172.8 | 172.8 | 172.8 | 100.0 |
| 2023-09-27 06:32:00 | AAPL | Stock | 172.84 | 172.84 | 172.84 | 172.84 | 400.0 |
> showing 50 of 1,233,023 rows — these rows as CSV