PREVIEW / stock_1min / 2004-11-24
file: by_date/stock_1min/2004/2004-11-24.parquet size: 6.0 MB rows: 503,751 symbols: 1,540
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 |
|---|---|---|---|---|---|---|---|
| 2004-11-24 08:00:00 | AAPL | Stock | 1.0946 | 1.0946 | 1.0946 | 1.0946 | 22400.0 |
| 2004-11-24 08:01:00 | AAPL | Stock | 1.1009 | 1.1009 | 1.1009 | 1.1009 | 22400.0 |
| 2004-11-24 08:03:00 | AAPL | Stock | 1.1009 | 1.1009 | 1.1009 | 1.1009 | 5600.0 |
| 2004-11-24 08:11:00 | AAPL | Stock | 1.0982 | 1.0982 | 1.0982 | 1.0982 | 11200.0 |
| 2004-11-24 08:14:00 | AAPL | Stock | 1.1007 | 1.1009 | 1.1007 | 1.1009 | 22400.0 |
| 2004-11-24 08:15:00 | AAPL | Stock | 1.1007 | 1.1009 | 1.1 | 1.1 | 22400.0 |
| 2004-11-24 08:17:00 | AAPL | Stock | 1.1 | 1.1 | 1.1 | 1.1 | 112000.0 |
| 2004-11-24 08:18:00 | AAPL | Stock | 1.1009 | 1.1009 | 1.1009 | 1.1009 | 58800.0 |
| 2004-11-24 08:20:00 | AAPL | Stock | 1.1016 | 1.1016 | 1.1016 | 1.1016 | 5600.0 |
| 2004-11-24 08:21:00 | AAPL | Stock | 1.1016 | 1.1016 | 1.1016 | 1.1016 | 16800.0 |
| 2004-11-24 08:23:00 | AAPL | Stock | 1.1034 | 1.1034 | 1.1034 | 1.1034 | 56000.0 |
| 2004-11-24 08:26:00 | AAPL | Stock | 1.1027 | 1.1027 | 1.1027 | 1.1027 | 56000.0 |
| 2004-11-24 08:27:00 | AAPL | Stock | 1.1045 | 1.1045 | 1.1045 | 1.1045 | 33600.0 |
| 2004-11-24 08:28:00 | AAPL | Stock | 1.1048 | 1.1048 | 1.1048 | 1.1048 | 56000.0 |
| 2004-11-24 08:29:00 | AAPL | Stock | 1.1063 | 1.1071 | 1.1063 | 1.1071 | 235200.0 |
| 2004-11-24 08:30:00 | AAPL | Stock | 1.1071 | 1.1089 | 1.1071 | 1.1071 | 154000.0 |
| 2004-11-24 08:31:00 | AAPL | Stock | 1.1071 | 1.1071 | 1.1055 | 1.1071 | 151200.0 |
| 2004-11-24 08:33:00 | AAPL | Stock | 1.1064 | 1.1064 | 1.1064 | 1.1064 | 5600.0 |
| 2004-11-24 08:34:00 | AAPL | Stock | 1.1063 | 1.1063 | 1.1063 | 1.1063 | 11200.0 |
| 2004-11-24 08:38:00 | AAPL | Stock | 1.1039 | 1.1063 | 1.1036 | 1.1063 | 95200.0 |
| 2004-11-24 08:39:00 | AAPL | Stock | 1.1068 | 1.1068 | 1.1066 | 1.1068 | 22400.0 |
| 2004-11-24 08:40:00 | AAPL | Stock | 1.1045 | 1.1045 | 1.1045 | 1.1045 | 5600.0 |
| 2004-11-24 08:41:00 | AAPL | Stock | 1.1066 | 1.1066 | 1.1066 | 1.1066 | 5600.0 |
| 2004-11-24 08:43:00 | AAPL | Stock | 1.1039 | 1.1039 | 1.1039 | 1.1039 | 11200.0 |
| 2004-11-24 08:44:00 | AAPL | Stock | 1.1039 | 1.1039 | 1.1039 | 1.1039 | 14504.0 |
| 2004-11-24 08:45:00 | AAPL | Stock | 1.1041 | 1.1041 | 1.1036 | 1.1039 | 82152.0 |
| 2004-11-24 08:47:00 | AAPL | Stock | 1.1036 | 1.1036 | 1.1036 | 1.1036 | 5600.0 |
| 2004-11-24 08:48:00 | AAPL | Stock | 1.1036 | 1.1036 | 1.1036 | 1.1036 | 10808.0 |
| 2004-11-24 08:49:00 | AAPL | Stock | 1.1027 | 1.1027 | 1.1027 | 1.1027 | 44800.0 |
| 2004-11-24 08:52:00 | AAPL | Stock | 1.1018 | 1.1018 | 1.1018 | 1.1018 | 128800.0 |
| 2004-11-24 08:53:00 | AAPL | Stock | 1.1018 | 1.1027 | 1.1018 | 1.1027 | 19600.0 |
| 2004-11-24 08:54:00 | AAPL | Stock | 1.1036 | 1.1036 | 1.1036 | 1.1036 | 16800.0 |
| 2004-11-24 08:55:00 | AAPL | Stock | 1.1027 | 1.1027 | 1.1027 | 1.1027 | 5600.0 |
| 2004-11-24 08:56:00 | AAPL | Stock | 1.1027 | 1.1027 | 1.1027 | 1.1027 | 11200.0 |
| 2004-11-24 08:57:00 | AAPL | Stock | 1.1027 | 1.1027 | 1.1027 | 1.1027 | 5600.0 |
| 2004-11-24 08:59:00 | AAPL | Stock | 1.1027 | 1.1027 | 1.1027 | 1.1027 | 39200.0 |
| 2004-11-24 09:02:00 | AAPL | Stock | 1.1027 | 1.1027 | 1.1027 | 1.1027 | 28000.0 |
| 2004-11-24 09:03:00 | AAPL | Stock | 1.1018 | 1.1018 | 1.1018 | 1.1018 | 11200.0 |
| 2004-11-24 09:04:00 | AAPL | Stock | 1.1018 | 1.1027 | 1.1009 | 1.1009 | 1114008.0 |
| 2004-11-24 09:05:00 | AAPL | Stock | 1.1009 | 1.1009 | 1.1009 | 1.1009 | 5600.0 |
| 2004-11-24 09:06:00 | AAPL | Stock | 1.1009 | 1.1009 | 1.1009 | 1.1009 | 5600.0 |
| 2004-11-24 09:08:00 | AAPL | Stock | 1.1002 | 1.1002 | 1.1002 | 1.1002 | 22400.0 |
| 2004-11-24 09:10:00 | AAPL | Stock | 1.1002 | 1.1002 | 1.1002 | 1.1002 | 11200.0 |
| 2004-11-24 09:12:00 | AAPL | Stock | 1.1002 | 1.1002 | 1.1002 | 1.1002 | 11200.0 |
| 2004-11-24 09:14:00 | AAPL | Stock | 1.1002 | 1.1002 | 1.1002 | 1.1002 | 44800.0 |
| 2004-11-24 09:22:00 | AAPL | Stock | 1.1002 | 1.1002 | 1.1002 | 1.1002 | 34608.0 |
| 2004-11-24 09:23:00 | AAPL | Stock | 1.1 | 1.1002 | 1.1 | 1.1002 | 106120.0 |
| 2004-11-24 09:24:00 | AAPL | Stock | 1.0988 | 1.0988 | 1.0988 | 1.0988 | 11200.0 |
| 2004-11-24 09:25:00 | AAPL | Stock | 1.0982 | 1.1 | 1.0982 | 1.0995 | 56000.0 |
| 2004-11-24 09:26:00 | AAPL | Stock | 1.0993 | 1.1 | 1.0993 | 1.1 | 22400.0 |
> showing 50 of 503,751 rows — these rows as CSV