PREVIEW / stock_1min / 2024-09-13
file: by_date/stock_1min/2024/2024-09-13.parquet size: 19.5 MB rows: 1,223,122 symbols: 860
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 |
|---|---|---|---|---|---|---|---|
| 2024-09-13 04:04:00 | AAPL | Stock | 222.7 | 222.7 | 222.68 | 222.68 | 200.0 |
| 2024-09-13 04:05:00 | AAPL | Stock | 222.8 | 222.8 | 222.8 | 222.8 | 200.0 |
| 2024-09-13 04:16:00 | AAPL | Stock | 222.96 | 222.96 | 222.96 | 222.96 | 100.0 |
| 2024-09-13 04:17:00 | AAPL | Stock | 222.98 | 222.98 | 222.98 | 222.98 | 100.0 |
| 2024-09-13 04:19:00 | AAPL | Stock | 222.97 | 222.97 | 222.97 | 222.97 | 300.0 |
| 2024-09-13 04:20:00 | AAPL | Stock | 222.97 | 222.98 | 222.95 | 222.95 | 751.0 |
| 2024-09-13 04:22:00 | AAPL | Stock | 222.97 | 222.97 | 222.96 | 222.97 | 400.0 |
| 2024-09-13 04:23:00 | AAPL | Stock | 222.98 | 223.0 | 222.98 | 223.0 | 1777.0 |
| 2024-09-13 04:25:00 | AAPL | Stock | 222.9 | 222.92 | 222.9 | 222.9 | 500.0 |
| 2024-09-13 04:34:00 | AAPL | Stock | 222.9 | 222.9 | 222.9 | 222.9 | 100.0 |
| 2024-09-13 04:45:00 | AAPL | Stock | 222.98 | 222.98 | 222.98 | 222.98 | 324.0 |
| 2024-09-13 04:46:00 | AAPL | Stock | 223.0 | 223.0 | 223.0 | 223.0 | 1283.0 |
| 2024-09-13 04:47:00 | AAPL | Stock | 223.08 | 223.08 | 223.08 | 223.08 | 100.0 |
| 2024-09-13 04:53:00 | AAPL | Stock | 223.0 | 223.0 | 223.0 | 223.0 | 100.0 |
| 2024-09-13 04:54:00 | AAPL | Stock | 222.92 | 222.92 | 222.92 | 222.92 | 100.0 |
| 2024-09-13 04:56:00 | AAPL | Stock | 222.9 | 222.9 | 222.9 | 222.9 | 100.0 |
| 2024-09-13 04:58:00 | AAPL | Stock | 222.91 | 222.91 | 222.91 | 222.91 | 100.0 |
| 2024-09-13 04:59:00 | AAPL | Stock | 222.95 | 222.95 | 222.95 | 222.95 | 329.0 |
| 2024-09-13 05:06:00 | AAPL | Stock | 223.0 | 223.03 | 223.0 | 223.03 | 300.0 |
| 2024-09-13 05:07:00 | AAPL | Stock | 223.03 | 223.03 | 223.01 | 223.03 | 500.0 |
| 2024-09-13 05:08:00 | AAPL | Stock | 223.05 | 223.09 | 223.05 | 223.09 | 300.0 |
| 2024-09-13 05:10:00 | AAPL | Stock | 223.05 | 223.05 | 223.05 | 223.05 | 133.0 |
| 2024-09-13 05:22:00 | AAPL | Stock | 223.06 | 223.06 | 223.06 | 223.06 | 300.0 |
| 2024-09-13 05:23:00 | AAPL | Stock | 223.07 | 223.1 | 223.07 | 223.1 | 2221.0 |
| 2024-09-13 05:32:00 | AAPL | Stock | 223.24 | 223.24 | 223.24 | 223.24 | 200.0 |
| 2024-09-13 05:34:00 | AAPL | Stock | 223.31 | 223.31 | 223.31 | 223.31 | 100.0 |
| 2024-09-13 05:40:00 | AAPL | Stock | 223.26 | 223.26 | 223.26 | 223.26 | 100.0 |
| 2024-09-13 05:42:00 | AAPL | Stock | 223.26 | 223.26 | 223.26 | 223.26 | 313.0 |
| 2024-09-13 05:51:00 | AAPL | Stock | 223.22 | 223.22 | 223.22 | 223.22 | 100.0 |
| 2024-09-13 06:00:00 | AAPL | Stock | 223.17 | 223.17 | 223.13 | 223.13 | 436.0 |
| 2024-09-13 06:01:00 | AAPL | Stock | 223.17 | 223.17 | 223.17 | 223.17 | 200.0 |
| 2024-09-13 06:05:00 | AAPL | Stock | 223.13 | 223.13 | 223.13 | 223.13 | 146.0 |
| 2024-09-13 06:07:00 | AAPL | Stock | 223.2 | 223.2 | 223.2 | 223.2 | 710.0 |
| 2024-09-13 06:10:00 | AAPL | Stock | 223.16 | 223.16 | 223.16 | 223.16 | 100.0 |
| 2024-09-13 06:13:00 | AAPL | Stock | 223.17 | 223.17 | 223.17 | 223.17 | 194.0 |
| 2024-09-13 06:14:00 | AAPL | Stock | 223.2 | 223.2 | 223.2 | 223.2 | 200.0 |
| 2024-09-13 06:16:00 | AAPL | Stock | 223.19 | 223.19 | 223.19 | 223.19 | 103.0 |
| 2024-09-13 06:17:00 | AAPL | Stock | 223.2 | 223.2 | 223.2 | 223.2 | 117.0 |
| 2024-09-13 06:20:00 | AAPL | Stock | 223.14 | 223.14 | 223.14 | 223.14 | 100.0 |
| 2024-09-13 06:21:00 | AAPL | Stock | 223.2 | 223.26 | 223.19 | 223.26 | 1280.0 |
| 2024-09-13 06:22:00 | AAPL | Stock | 223.3 | 223.3 | 223.3 | 223.3 | 220.0 |
| 2024-09-13 06:23:00 | AAPL | Stock | 223.4 | 223.46 | 223.4 | 223.45 | 1604.0 |
| 2024-09-13 06:38:00 | AAPL | Stock | 223.34 | 223.39 | 223.34 | 223.38 | 4173.0 |
| 2024-09-13 06:39:00 | AAPL | Stock | 223.4 | 223.4 | 223.4 | 223.4 | 572.0 |
| 2024-09-13 06:40:00 | AAPL | Stock | 223.4 | 223.4 | 223.4 | 223.4 | 514.0 |
| 2024-09-13 06:41:00 | AAPL | Stock | 223.4 | 223.4 | 223.4 | 223.4 | 300.0 |
| 2024-09-13 06:42:00 | AAPL | Stock | 223.4 | 223.4 | 223.4 | 223.4 | 181.0 |
| 2024-09-13 06:43:00 | AAPL | Stock | 223.4 | 223.42 | 223.4 | 223.42 | 1500.0 |
| 2024-09-13 06:47:00 | AAPL | Stock | 223.42 | 223.42 | 223.42 | 223.42 | 178.0 |
| 2024-09-13 06:52:00 | AAPL | Stock | 223.43 | 223.45 | 223.43 | 223.45 | 239.0 |
> showing 50 of 1,223,122 rows — these rows as CSV