PREVIEW / stock_1min / 2000-06-01
file: by_date/stock_1min/2000/2000-06-01.parquet size: 2.3 MB rows: 200,640 symbols: 949
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 |
|---|---|---|---|---|---|---|---|
| 2000-06-01 08:01:00 | AAPL | Stock | 0.7503 | 0.7503 | 0.7503 | 0.7503 | 156800.0 |
| 2000-06-01 08:31:00 | AAPL | Stock | 0.7556 | 0.7567 | 0.7556 | 0.7567 | 89600.0 |
| 2000-06-01 08:39:00 | AAPL | Stock | 0.75 | 0.75 | 0.75 | 0.75 | 33600.0 |
| 2000-06-01 08:42:00 | AAPL | Stock | 0.7545 | 0.7545 | 0.7545 | 0.7545 | 134400.0 |
| 2000-06-01 08:46:00 | AAPL | Stock | 0.7573 | 0.7595 | 0.7573 | 0.7573 | 168000.0 |
| 2000-06-01 08:49:00 | AAPL | Stock | 0.7645 | 0.7667 | 0.7589 | 0.7623 | 481600.0 |
| 2000-06-01 08:50:00 | AAPL | Stock | 0.769 | 0.769 | 0.7628 | 0.7679 | 280000.0 |
| 2000-06-01 08:51:00 | AAPL | Stock | 0.7656 | 0.7656 | 0.76 | 0.7634 | 324800.0 |
| 2000-06-01 08:52:00 | AAPL | Stock | 0.7634 | 0.7667 | 0.7634 | 0.7656 | 67200.0 |
| 2000-06-01 08:53:00 | AAPL | Stock | 0.7656 | 0.7662 | 0.7277 | 0.7321 | 2083200.0 |
| 2000-06-01 08:54:00 | AAPL | Stock | 0.7321 | 0.7366 | 0.7299 | 0.731 | 963200.0 |
| 2000-06-01 08:55:00 | AAPL | Stock | 0.7321 | 0.7327 | 0.7277 | 0.7277 | 571200.0 |
| 2000-06-01 08:56:00 | AAPL | Stock | 0.75 | 0.75 | 0.7288 | 0.7321 | 425600.0 |
| 2000-06-01 08:57:00 | AAPL | Stock | 0.7277 | 0.7321 | 0.7277 | 0.731 | 156800.0 |
| 2000-06-01 08:58:00 | AAPL | Stock | 0.7321 | 0.7321 | 0.7313 | 0.7321 | 190400.0 |
| 2000-06-01 08:59:00 | AAPL | Stock | 0.7288 | 0.7294 | 0.7238 | 0.7254 | 459200.0 |
| 2000-06-01 09:00:00 | AAPL | Stock | 0.7254 | 0.7254 | 0.7232 | 0.7232 | 33600.0 |
| 2000-06-01 09:01:00 | AAPL | Stock | 0.7277 | 0.7277 | 0.7254 | 0.7254 | 123200.0 |
| 2000-06-01 09:02:00 | AAPL | Stock | 0.7277 | 0.7277 | 0.7243 | 0.7277 | 302400.0 |
| 2000-06-01 09:03:00 | AAPL | Stock | 0.7277 | 0.7277 | 0.7232 | 0.7232 | 280000.0 |
| 2000-06-01 09:04:00 | AAPL | Stock | 0.7277 | 0.7277 | 0.7232 | 0.7232 | 280000.0 |
| 2000-06-01 09:05:00 | AAPL | Stock | 0.721 | 0.721 | 0.721 | 0.721 | 112000.0 |
| 2000-06-01 09:06:00 | AAPL | Stock | 0.7199 | 0.7199 | 0.7188 | 0.7188 | 156800.0 |
| 2000-06-01 09:07:00 | AAPL | Stock | 0.7154 | 0.7188 | 0.7143 | 0.7188 | 515200.0 |
| 2000-06-01 09:08:00 | AAPL | Stock | 0.7199 | 0.7232 | 0.7199 | 0.7229 | 280000.0 |
| 2000-06-01 09:09:00 | AAPL | Stock | 0.7199 | 0.7215 | 0.7188 | 0.7193 | 526400.0 |
| 2000-06-01 09:10:00 | AAPL | Stock | 0.7188 | 0.7213 | 0.7188 | 0.7213 | 112000.0 |
| 2000-06-01 09:11:00 | AAPL | Stock | 0.7215 | 0.7266 | 0.721 | 0.7266 | 246400.0 |
| 2000-06-01 09:15:00 | AAPL | Stock | 0.7266 | 0.7366 | 0.7232 | 0.7232 | 246400.0 |
| 2000-06-01 09:16:00 | AAPL | Stock | 0.7232 | 0.7238 | 0.7232 | 0.7238 | 134400.0 |
| 2000-06-01 09:17:00 | AAPL | Stock | 0.7238 | 0.726 | 0.7238 | 0.7243 | 168000.0 |
| 2000-06-01 09:18:00 | AAPL | Stock | 0.7243 | 0.7277 | 0.7243 | 0.7277 | 89600.0 |
| 2000-06-01 09:19:00 | AAPL | Stock | 0.7288 | 0.7288 | 0.7277 | 0.7277 | 212800.0 |
| 2000-06-01 09:20:00 | AAPL | Stock | 0.7266 | 0.7321 | 0.7266 | 0.7321 | 201600.0 |
| 2000-06-01 09:21:00 | AAPL | Stock | 0.7321 | 0.7321 | 0.7277 | 0.7277 | 112000.0 |
| 2000-06-01 09:24:00 | AAPL | Stock | 0.7282 | 0.7299 | 0.7266 | 0.7299 | 268800.0 |
| 2000-06-01 09:25:00 | AAPL | Stock | 0.7316 | 0.7321 | 0.7305 | 0.7305 | 448000.0 |
| 2000-06-01 09:26:00 | AAPL | Stock | 0.7305 | 0.731 | 0.7305 | 0.731 | 179200.0 |
| 2000-06-01 09:27:00 | AAPL | Stock | 0.7277 | 0.7305 | 0.7277 | 0.7277 | 627200.0 |
| 2000-06-01 09:28:00 | AAPL | Stock | 0.7299 | 0.7305 | 0.7277 | 0.7299 | 985600.0 |
| 2000-06-01 09:29:00 | AAPL | Stock | 0.7299 | 0.7321 | 0.7299 | 0.7299 | 347200.0 |
| 2000-06-01 09:30:00 | AAPL | Stock | 0.7299 | 0.731 | 0.7288 | 0.7294 | 1948800.0 |
| 2000-06-01 09:31:00 | AAPL | Stock | 0.7296 | 0.7321 | 0.7294 | 0.7299 | 7358400.0 |
| 2000-06-01 09:32:00 | AAPL | Stock | 0.7294 | 0.7366 | 0.7294 | 0.7333 | 6787200.0 |
| 2000-06-01 09:33:00 | AAPL | Stock | 0.7296 | 0.7388 | 0.7294 | 0.7366 | 4457600.0 |
| 2000-06-01 09:34:00 | AAPL | Stock | 0.7405 | 0.7411 | 0.7338 | 0.7366 | 3516800.0 |
| 2000-06-01 09:35:00 | AAPL | Stock | 0.7344 | 0.7377 | 0.7305 | 0.7305 | 4356800.0 |
| 2000-06-01 09:36:00 | AAPL | Stock | 0.7321 | 0.7344 | 0.7277 | 0.7277 | 3819200.0 |
| 2000-06-01 09:37:00 | AAPL | Stock | 0.7282 | 0.7282 | 0.7243 | 0.7254 | 4278400.0 |
| 2000-06-01 09:38:00 | AAPL | Stock | 0.7271 | 0.7333 | 0.7221 | 0.7254 | 5633600.0 |
> showing 50 of 200,640 rows — these rows as CSV