PREVIEW / stock_1min / 2009-07-01
file: by_date/stock_1min/2009/2009-07-01.parquet size: 12.8 MB rows: 991,603 symbols: 2,685
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 |
|---|---|---|---|---|---|---|---|
| 2009-07-01 07:07:00 | AAPL | Stock | 5.1071 | 5.1071 | 5.1071 | 5.1071 | 14000.0 |
| 2009-07-01 07:20:00 | AAPL | Stock | 5.1114 | 5.1114 | 5.1114 | 5.1114 | 8400.0 |
| 2009-07-01 07:31:00 | AAPL | Stock | 5.1118 | 5.1118 | 5.1118 | 5.1118 | 4200.0 |
| 2009-07-01 07:37:00 | AAPL | Stock | 5.1143 | 5.1143 | 5.1143 | 5.1143 | 5600.0 |
| 2009-07-01 07:52:00 | AAPL | Stock | 5.1161 | 5.1161 | 5.1161 | 5.1161 | 2800.0 |
| 2009-07-01 08:00:00 | AAPL | Stock | 5.1086 | 5.1086 | 5.1086 | 5.1086 | 2800.0 |
| 2009-07-01 08:02:00 | AAPL | Stock | 5.1136 | 5.1136 | 5.1125 | 5.1125 | 16800.0 |
| 2009-07-01 08:03:00 | AAPL | Stock | 5.1143 | 5.1161 | 5.1143 | 5.1161 | 11760.0 |
| 2009-07-01 08:04:00 | AAPL | Stock | 5.1071 | 5.1086 | 5.1071 | 5.1086 | 8400.0 |
| 2009-07-01 08:05:00 | AAPL | Stock | 5.1143 | 5.1143 | 5.1143 | 5.1143 | 28000.0 |
| 2009-07-01 08:09:00 | AAPL | Stock | 5.1161 | 5.1161 | 5.1139 | 5.1143 | 63448.0 |
| 2009-07-01 08:12:00 | AAPL | Stock | 5.1136 | 5.1143 | 5.1136 | 5.1143 | 28000.0 |
| 2009-07-01 08:13:00 | AAPL | Stock | 5.1143 | 5.1143 | 5.1143 | 5.1143 | 2800.0 |
| 2009-07-01 08:15:00 | AAPL | Stock | 5.1093 | 5.1093 | 5.1082 | 5.1082 | 64316.0 |
| 2009-07-01 08:16:00 | AAPL | Stock | 5.1057 | 5.1064 | 5.1057 | 5.1064 | 28000.0 |
| 2009-07-01 08:19:00 | AAPL | Stock | 5.1014 | 5.1014 | 5.1014 | 5.1014 | 2800.0 |
| 2009-07-01 08:20:00 | AAPL | Stock | 5.1004 | 5.1004 | 5.1004 | 5.1004 | 8400.0 |
| 2009-07-01 08:23:00 | AAPL | Stock | 5.1032 | 5.1032 | 5.1032 | 5.1032 | 2800.0 |
| 2009-07-01 08:24:00 | AAPL | Stock | 5.1057 | 5.1057 | 5.1057 | 5.1057 | 2800.0 |
| 2009-07-01 08:25:00 | AAPL | Stock | 5.1061 | 5.1068 | 5.1061 | 5.1068 | 8400.0 |
| 2009-07-01 08:26:00 | AAPL | Stock | 5.1007 | 5.1014 | 5.0982 | 5.1014 | 78036.0 |
| 2009-07-01 08:27:00 | AAPL | Stock | 5.0868 | 5.0868 | 5.0868 | 5.0868 | 170800.0 |
| 2009-07-01 08:28:00 | AAPL | Stock | 5.105 | 5.1068 | 5.1046 | 5.1068 | 28000.0 |
| 2009-07-01 08:29:00 | AAPL | Stock | 5.1064 | 5.1068 | 5.1064 | 5.1068 | 45640.0 |
| 2009-07-01 08:31:00 | AAPL | Stock | 5.1107 | 5.1107 | 5.1107 | 5.1107 | 19600.0 |
| 2009-07-01 08:32:00 | AAPL | Stock | 5.1075 | 5.1089 | 5.1075 | 5.1075 | 22400.0 |
| 2009-07-01 08:35:00 | AAPL | Stock | 5.1104 | 5.1125 | 5.1089 | 5.1125 | 25200.0 |
| 2009-07-01 08:36:00 | AAPL | Stock | 5.1125 | 5.1125 | 5.1125 | 5.1125 | 8400.0 |
| 2009-07-01 08:37:00 | AAPL | Stock | 5.1107 | 5.1107 | 5.1107 | 5.1107 | 8400.0 |
| 2009-07-01 08:38:00 | AAPL | Stock | 5.1089 | 5.1089 | 5.1068 | 5.1071 | 20720.0 |
| 2009-07-01 08:40:00 | AAPL | Stock | 5.1029 | 5.1029 | 5.0868 | 5.1014 | 158032.0 |
| 2009-07-01 08:41:00 | AAPL | Stock | 5.1011 | 5.1011 | 5.0975 | 5.1 | 25200.0 |
| 2009-07-01 08:42:00 | AAPL | Stock | 5.0986 | 5.1 | 5.0986 | 5.1 | 19600.0 |
| 2009-07-01 08:43:00 | AAPL | Stock | 5.1011 | 5.1014 | 5.1011 | 5.1011 | 22400.0 |
| 2009-07-01 08:44:00 | AAPL | Stock | 5.1014 | 5.1014 | 5.1014 | 5.1014 | 2800.0 |
| 2009-07-01 08:46:00 | AAPL | Stock | 5.1018 | 5.1018 | 5.1018 | 5.1018 | 7280.0 |
| 2009-07-01 08:47:00 | AAPL | Stock | 5.0989 | 5.0989 | 5.0989 | 5.0989 | 14700.0 |
| 2009-07-01 08:48:00 | AAPL | Stock | 5.0968 | 5.0968 | 5.0943 | 5.0943 | 25340.0 |
| 2009-07-01 08:50:00 | AAPL | Stock | 5.0968 | 5.0968 | 5.0968 | 5.0968 | 2800.0 |
| 2009-07-01 08:51:00 | AAPL | Stock | 5.0868 | 5.0982 | 5.0868 | 5.0982 | 559020.0 |
| 2009-07-01 08:53:00 | AAPL | Stock | 5.0996 | 5.0996 | 5.0996 | 5.0996 | 11200.0 |
| 2009-07-01 08:57:00 | AAPL | Stock | 5.1 | 5.1 | 5.1 | 5.1 | 4200.0 |
| 2009-07-01 08:58:00 | AAPL | Stock | 5.1014 | 5.1014 | 5.1014 | 5.1014 | 19040.0 |
| 2009-07-01 08:59:00 | AAPL | Stock | 5.1025 | 5.1029 | 5.1018 | 5.1029 | 102144.0 |
| 2009-07-01 09:00:00 | AAPL | Stock | 5.1046 | 5.1046 | 5.1046 | 5.1046 | 2800.0 |
| 2009-07-01 09:01:00 | AAPL | Stock | 5.1068 | 5.1104 | 5.1068 | 5.1104 | 7000.0 |
| 2009-07-01 09:02:00 | AAPL | Stock | 5.1068 | 5.1068 | 5.1068 | 5.1068 | 35700.0 |
| 2009-07-01 09:04:00 | AAPL | Stock | 5.1068 | 5.1068 | 5.1068 | 5.1068 | 6300.0 |
| 2009-07-01 09:06:00 | AAPL | Stock | 5.1068 | 5.1071 | 5.1068 | 5.1071 | 58800.0 |
| 2009-07-01 09:07:00 | AAPL | Stock | 5.1075 | 5.1075 | 5.1075 | 5.1075 | 2800.0 |
> showing 50 of 991,603 rows — these rows as CSV