PREVIEW / stock_1min / 2023-10-18
file: by_date/stock_1min/2023/2023-10-18.parquet size: 19.2 MB rows: 1,202,434 symbols: 1,319
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-10-18 04:06:00 | AAPL | Stock | 176.66 | 176.66 | 176.66 | 176.66 | 944.0 |
| 2023-10-18 04:12:00 | AAPL | Stock | 176.65 | 176.65 | 176.64 | 176.64 | 715.0 |
| 2023-10-18 04:28:00 | AAPL | Stock | 176.62 | 176.62 | 176.62 | 176.62 | 389.0 |
| 2023-10-18 04:34:00 | AAPL | Stock | 176.6 | 176.6 | 176.6 | 176.6 | 700.0 |
| 2023-10-18 04:48:00 | AAPL | Stock | 176.72 | 176.72 | 176.72 | 176.72 | 779.0 |
| 2023-10-18 04:49:00 | AAPL | Stock | 176.72 | 176.73 | 176.72 | 176.73 | 1049.0 |
| 2023-10-18 05:04:00 | AAPL | Stock | 176.61 | 176.61 | 176.61 | 176.61 | 500.0 |
| 2023-10-18 05:13:00 | AAPL | Stock | 176.7 | 176.73 | 176.7 | 176.73 | 424.0 |
| 2023-10-18 05:24:00 | AAPL | Stock | 176.6 | 176.61 | 176.6 | 176.6 | 646.0 |
| 2023-10-18 05:28:00 | AAPL | Stock | 176.43 | 176.43 | 176.38 | 176.38 | 1331.0 |
| 2023-10-18 05:29:00 | AAPL | Stock | 176.38 | 176.38 | 176.38 | 176.38 | 207.0 |
| 2023-10-18 05:30:00 | AAPL | Stock | 176.38 | 176.38 | 176.32 | 176.32 | 278.0 |
| 2023-10-18 05:31:00 | AAPL | Stock | 176.25 | 176.25 | 176.18 | 176.18 | 4311.0 |
| 2023-10-18 05:32:00 | AAPL | Stock | 176.13 | 176.13 | 176.13 | 176.13 | 354.0 |
| 2023-10-18 05:33:00 | AAPL | Stock | 176.13 | 176.13 | 176.1 | 176.1 | 289.0 |
| 2023-10-18 05:34:00 | AAPL | Stock | 176.0 | 176.0 | 175.8 | 175.8 | 1865.0 |
| 2023-10-18 05:37:00 | AAPL | Stock | 176.11 | 176.11 | 176.11 | 176.11 | 300.0 |
| 2023-10-18 05:39:00 | AAPL | Stock | 176.02 | 176.02 | 176.0 | 176.0 | 313.0 |
| 2023-10-18 05:40:00 | AAPL | Stock | 175.91 | 175.91 | 175.81 | 175.81 | 342.0 |
| 2023-10-18 05:42:00 | AAPL | Stock | 175.83 | 175.83 | 175.83 | 175.83 | 157.0 |
| 2023-10-18 05:44:00 | AAPL | Stock | 175.9 | 175.9 | 175.89 | 175.89 | 500.0 |
| 2023-10-18 05:45:00 | AAPL | Stock | 175.9 | 175.9 | 175.9 | 175.9 | 1570.0 |
| 2023-10-18 05:46:00 | AAPL | Stock | 175.89 | 175.89 | 175.89 | 175.89 | 172.0 |
| 2023-10-18 05:47:00 | AAPL | Stock | 175.9 | 175.9 | 175.9 | 175.9 | 100.0 |
| 2023-10-18 05:50:00 | AAPL | Stock | 175.93 | 175.93 | 175.93 | 175.93 | 212.0 |
| 2023-10-18 05:54:00 | AAPL | Stock | 176.04 | 176.04 | 176.04 | 176.04 | 100.0 |
| 2023-10-18 05:59:00 | AAPL | Stock | 176.02 | 176.02 | 176.02 | 176.02 | 200.0 |
| 2023-10-18 06:00:00 | AAPL | Stock | 176.1 | 176.1 | 176.1 | 176.1 | 320.0 |
| 2023-10-18 06:02:00 | AAPL | Stock | 176.08 | 176.08 | 176.08 | 176.08 | 100.0 |
| 2023-10-18 06:03:00 | AAPL | Stock | 176.1 | 176.1 | 176.1 | 176.1 | 200.0 |
| 2023-10-18 06:06:00 | AAPL | Stock | 176.12 | 176.12 | 176.12 | 176.12 | 370.0 |
| 2023-10-18 06:12:00 | AAPL | Stock | 176.12 | 176.12 | 176.12 | 176.12 | 580.0 |
| 2023-10-18 06:17:00 | AAPL | Stock | 176.1 | 176.1 | 176.1 | 176.1 | 500.0 |
| 2023-10-18 06:21:00 | AAPL | Stock | 176.03 | 176.03 | 176.02 | 176.02 | 644.0 |
| 2023-10-18 06:23:00 | AAPL | Stock | 176.02 | 176.02 | 176.02 | 176.02 | 1700.0 |
| 2023-10-18 06:27:00 | AAPL | Stock | 176.01 | 176.01 | 175.97 | 175.97 | 1200.0 |
| 2023-10-18 06:32:00 | AAPL | Stock | 175.95 | 175.95 | 175.95 | 175.95 | 2180.0 |
| 2023-10-18 06:39:00 | AAPL | Stock | 175.9 | 175.9 | 175.9 | 175.9 | 1000.0 |
| 2023-10-18 06:40:00 | AAPL | Stock | 175.82 | 175.82 | 175.82 | 175.82 | 958.0 |
| 2023-10-18 06:41:00 | AAPL | Stock | 175.89 | 175.89 | 175.89 | 175.89 | 200.0 |
| 2023-10-18 06:42:00 | AAPL | Stock | 175.85 | 175.85 | 175.85 | 175.85 | 346.0 |
| 2023-10-18 06:43:00 | AAPL | Stock | 175.82 | 175.82 | 175.82 | 175.82 | 200.0 |
| 2023-10-18 06:46:00 | AAPL | Stock | 175.89 | 175.9 | 175.89 | 175.9 | 1837.0 |
| 2023-10-18 06:48:00 | AAPL | Stock | 175.82 | 175.82 | 175.8 | 175.8 | 414.0 |
| 2023-10-18 06:49:00 | AAPL | Stock | 175.7 | 175.7 | 175.7 | 175.7 | 256.0 |
| 2023-10-18 06:51:00 | AAPL | Stock | 175.79 | 175.79 | 175.79 | 175.79 | 300.0 |
| 2023-10-18 06:54:00 | AAPL | Stock | 175.78 | 175.78 | 175.77 | 175.77 | 266.0 |
| 2023-10-18 06:57:00 | AAPL | Stock | 175.84 | 175.84 | 175.83 | 175.84 | 1966.0 |
| 2023-10-18 06:58:00 | AAPL | Stock | 175.83 | 175.84 | 175.83 | 175.84 | 753.0 |
| 2023-10-18 07:00:00 | AAPL | Stock | 175.98 | 175.99 | 175.84 | 175.85 | 3480.0 |
> showing 50 of 1,202,434 rows — these rows as CSV