PREVIEW / stock_1min / 2000-09-29
file: by_date/stock_1min/2000/2000-09-29.parquet size: 2.6 MB rows: 222,757 symbols: 1,005
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-09-29 08:00:00 | AAPL | Stock | 0.5089 | 0.529 | 0.4933 | 0.5045 | 10287200.0 |
| 2000-09-29 08:01:00 | AAPL | Stock | 0.5285 | 0.5502 | 0.4911 | 0.5 | 26689600.0 |
| 2000-09-29 08:02:00 | AAPL | Stock | 0.4978 | 0.5625 | 0.4933 | 0.4978 | 29792000.0 |
| 2000-09-29 08:03:00 | AAPL | Stock | 0.5491 | 0.5513 | 0.4955 | 0.5402 | 1232000.0 |
| 2000-09-29 08:04:00 | AAPL | Stock | 0.5402 | 0.5402 | 0.4978 | 0.5022 | 3528000.0 |
| 2000-09-29 08:05:00 | AAPL | Stock | 0.5 | 0.5201 | 0.4989 | 0.5 | 4603200.0 |
| 2000-09-29 08:06:00 | AAPL | Stock | 0.5 | 0.5 | 0.4978 | 0.4978 | 2234400.0 |
| 2000-09-29 08:07:00 | AAPL | Stock | 0.4955 | 0.5022 | 0.4922 | 0.4955 | 7700000.0 |
| 2000-09-29 08:08:00 | AAPL | Stock | 0.4955 | 0.5 | 0.4933 | 0.5 | 1176000.0 |
| 2000-09-29 08:09:00 | AAPL | Stock | 0.5 | 0.5022 | 0.4978 | 0.5 | 1411200.0 |
| 2000-09-29 08:10:00 | AAPL | Stock | 0.5 | 0.5223 | 0.4978 | 0.5 | 4205600.0 |
| 2000-09-29 08:11:00 | AAPL | Stock | 0.5 | 0.5089 | 0.4955 | 0.5 | 1724800.0 |
| 2000-09-29 08:12:00 | AAPL | Stock | 0.4955 | 0.5 | 0.4955 | 0.5 | 4418400.0 |
| 2000-09-29 08:13:00 | AAPL | Stock | 0.5 | 0.5017 | 0.4994 | 0.5 | 2693600.0 |
| 2000-09-29 08:14:00 | AAPL | Stock | 0.5011 | 0.5022 | 0.5 | 0.5 | 5051200.0 |
| 2000-09-29 08:15:00 | AAPL | Stock | 0.5011 | 0.5011 | 0.4978 | 0.4978 | 3460800.0 |
| 2000-09-29 08:16:00 | AAPL | Stock | 0.4989 | 0.5 | 0.4955 | 0.4978 | 8808800.0 |
| 2000-09-29 08:17:00 | AAPL | Stock | 0.4967 | 0.4989 | 0.4967 | 0.4989 | 218400.0 |
| 2000-09-29 08:18:00 | AAPL | Stock | 0.4989 | 0.5 | 0.4978 | 0.4989 | 3024000.0 |
| 2000-09-29 08:19:00 | AAPL | Stock | 0.4978 | 0.5 | 0.4967 | 0.5 | 912800.0 |
| 2000-09-29 08:20:00 | AAPL | Stock | 0.4978 | 0.519 | 0.4955 | 0.4955 | 2133600.0 |
| 2000-09-29 08:21:00 | AAPL | Stock | 0.4955 | 0.4978 | 0.4933 | 0.4967 | 3225600.0 |
| 2000-09-29 08:22:00 | AAPL | Stock | 0.4955 | 0.4967 | 0.4866 | 0.4888 | 21929600.0 |
| 2000-09-29 08:23:00 | AAPL | Stock | 0.49 | 0.4967 | 0.4877 | 0.4911 | 16716000.0 |
| 2000-09-29 08:24:00 | AAPL | Stock | 0.4922 | 0.4922 | 0.4888 | 0.4911 | 11312000.0 |
| 2000-09-29 08:25:00 | AAPL | Stock | 0.4911 | 0.5 | 0.49 | 0.4922 | 4580800.0 |
| 2000-09-29 08:26:00 | AAPL | Stock | 0.4933 | 0.4955 | 0.4911 | 0.4944 | 918400.0 |
| 2000-09-29 08:27:00 | AAPL | Stock | 0.4955 | 0.5 | 0.4944 | 0.4994 | 1646400.0 |
| 2000-09-29 08:28:00 | AAPL | Stock | 0.4978 | 0.4994 | 0.4955 | 0.4978 | 2172800.0 |
| 2000-09-29 08:29:00 | AAPL | Stock | 0.4967 | 0.4978 | 0.4944 | 0.4955 | 1993600.0 |
| 2000-09-29 08:30:00 | AAPL | Stock | 0.495 | 0.5095 | 0.495 | 0.4955 | 4480000.0 |
| 2000-09-29 08:31:00 | AAPL | Stock | 0.4967 | 0.4978 | 0.4944 | 0.4967 | 3024000.0 |
| 2000-09-29 08:32:00 | AAPL | Stock | 0.4978 | 0.4978 | 0.4933 | 0.4955 | 8584800.0 |
| 2000-09-29 08:33:00 | AAPL | Stock | 0.4944 | 0.4978 | 0.4933 | 0.4978 | 10404800.0 |
| 2000-09-29 08:34:00 | AAPL | Stock | 0.4967 | 0.4978 | 0.4955 | 0.4967 | 1713600.0 |
| 2000-09-29 08:35:00 | AAPL | Stock | 0.4967 | 0.4978 | 0.4967 | 0.4967 | 1260000.0 |
| 2000-09-29 08:36:00 | AAPL | Stock | 0.4967 | 0.5 | 0.4955 | 0.5 | 2923200.0 |
| 2000-09-29 08:37:00 | AAPL | Stock | 0.4978 | 0.4978 | 0.4944 | 0.4955 | 3813600.0 |
| 2000-09-29 08:38:00 | AAPL | Stock | 0.4955 | 0.4978 | 0.4955 | 0.4978 | 4474400.0 |
| 2000-09-29 08:39:00 | AAPL | Stock | 0.4972 | 0.5 | 0.4972 | 0.4978 | 3707200.0 |
| 2000-09-29 08:40:00 | AAPL | Stock | 0.4978 | 0.5 | 0.4955 | 0.4955 | 4659200.0 |
| 2000-09-29 08:41:00 | AAPL | Stock | 0.4955 | 0.4978 | 0.4944 | 0.4955 | 4670400.0 |
| 2000-09-29 08:42:00 | AAPL | Stock | 0.4955 | 0.4967 | 0.4933 | 0.4955 | 32267200.0 |
| 2000-09-29 08:43:00 | AAPL | Stock | 0.4955 | 0.4989 | 0.4944 | 0.4967 | 2480800.0 |
| 2000-09-29 08:44:00 | AAPL | Stock | 0.4972 | 0.5 | 0.4944 | 0.4955 | 17236800.0 |
| 2000-09-29 08:45:00 | AAPL | Stock | 0.4967 | 0.4978 | 0.4933 | 0.4955 | 11485600.0 |
| 2000-09-29 08:46:00 | AAPL | Stock | 0.495 | 0.4961 | 0.4888 | 0.4911 | 15450400.0 |
| 2000-09-29 08:47:00 | AAPL | Stock | 0.49 | 0.4933 | 0.4888 | 0.4911 | 6244000.0 |
| 2000-09-29 08:48:00 | AAPL | Stock | 0.4911 | 0.4944 | 0.4888 | 0.4933 | 5807200.0 |
| 2000-09-29 08:49:00 | AAPL | Stock | 0.4944 | 0.4955 | 0.4911 | 0.4911 | 9816800.0 |
> showing 50 of 222,757 rows — these rows as CSV