PREVIEW / stock_1min / 2001-10-18
file: by_date/stock_1min/2001/2001-10-18.parquet size: 3.3 MB rows: 263,141 symbols: 1,096
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 |
|---|---|---|---|---|---|---|---|
| 2001-10-18 08:00:00 | AAPL | Stock | 0.3071 | 0.3071 | 0.3054 | 0.3054 | 336000.0 |
| 2001-10-18 08:01:00 | AAPL | Stock | 0.308 | 0.308 | 0.308 | 0.308 | 22400.0 |
| 2001-10-18 08:07:00 | AAPL | Stock | 0.3036 | 0.3036 | 0.3036 | 0.3036 | 28000.0 |
| 2001-10-18 08:11:00 | AAPL | Stock | 0.3029 | 0.3029 | 0.3027 | 0.3027 | 11200.0 |
| 2001-10-18 08:12:00 | AAPL | Stock | 0.3027 | 0.3027 | 0.3027 | 0.3027 | 16800.0 |
| 2001-10-18 08:28:00 | AAPL | Stock | 0.3036 | 0.3036 | 0.3036 | 0.3036 | 112000.0 |
| 2001-10-18 08:34:00 | AAPL | Stock | 0.3029 | 0.3036 | 0.3029 | 0.3029 | 28000.0 |
| 2001-10-18 08:35:00 | AAPL | Stock | 0.3036 | 0.3036 | 0.3036 | 0.3036 | 5600.0 |
| 2001-10-18 08:44:00 | AAPL | Stock | 0.3036 | 0.3036 | 0.3036 | 0.3036 | 5600000.0 |
| 2001-10-18 08:51:00 | AAPL | Stock | 0.3036 | 0.3036 | 0.3036 | 0.3036 | 11200.0 |
| 2001-10-18 08:52:00 | AAPL | Stock | 0.3036 | 0.3036 | 0.3036 | 0.3036 | 5600.0 |
| 2001-10-18 08:58:00 | AAPL | Stock | 0.3036 | 0.3036 | 0.3036 | 0.3036 | 11200.0 |
| 2001-10-18 09:00:00 | AAPL | Stock | 0.3036 | 0.3036 | 0.3036 | 0.3036 | 16800.0 |
| 2001-10-18 09:03:00 | AAPL | Stock | 0.3036 | 0.3036 | 0.3036 | 0.3036 | 11200.0 |
| 2001-10-18 09:06:00 | AAPL | Stock | 0.3018 | 0.305 | 0.3018 | 0.305 | 123200.0 |
| 2001-10-18 09:08:00 | AAPL | Stock | 0.3063 | 0.3063 | 0.3063 | 0.3063 | 11200.0 |
| 2001-10-18 09:13:00 | AAPL | Stock | 0.3068 | 0.3068 | 0.3068 | 0.3068 | 11200.0 |
| 2001-10-18 09:14:00 | AAPL | Stock | 0.3071 | 0.3071 | 0.3071 | 0.3071 | 5600.0 |
| 2001-10-18 09:15:00 | AAPL | Stock | 0.3054 | 0.3063 | 0.3054 | 0.3063 | 16800.0 |
| 2001-10-18 09:16:00 | AAPL | Stock | 0.3063 | 0.3063 | 0.3063 | 0.3063 | 162400.0 |
| 2001-10-18 09:18:00 | AAPL | Stock | 0.3063 | 0.3063 | 0.3063 | 0.3063 | 112000.0 |
| 2001-10-18 09:19:00 | AAPL | Stock | 0.3071 | 0.3088 | 0.3071 | 0.3088 | 336000.0 |
| 2001-10-18 09:20:00 | AAPL | Stock | 0.3089 | 0.3089 | 0.3089 | 0.3089 | 56000.0 |
| 2001-10-18 09:21:00 | AAPL | Stock | 0.3064 | 0.3064 | 0.3064 | 0.3064 | 11200.0 |
| 2001-10-18 09:22:00 | AAPL | Stock | 0.308 | 0.308 | 0.308 | 0.308 | 11200.0 |
| 2001-10-18 09:23:00 | AAPL | Stock | 0.3089 | 0.3089 | 0.308 | 0.308 | 134400.0 |
| 2001-10-18 09:24:00 | AAPL | Stock | 0.308 | 0.308 | 0.308 | 0.308 | 11200.0 |
| 2001-10-18 09:25:00 | AAPL | Stock | 0.3089 | 0.3089 | 0.308 | 0.308 | 22400.0 |
| 2001-10-18 09:26:00 | AAPL | Stock | 0.308 | 0.3082 | 0.308 | 0.3082 | 128800.0 |
| 2001-10-18 09:27:00 | AAPL | Stock | 0.308 | 0.3084 | 0.308 | 0.3084 | 627200.0 |
| 2001-10-18 09:28:00 | AAPL | Stock | 0.3084 | 0.3088 | 0.3084 | 0.3088 | 308000.0 |
| 2001-10-18 09:29:00 | AAPL | Stock | 0.3086 | 0.3089 | 0.3086 | 0.3088 | 554400.0 |
| 2001-10-18 09:30:00 | AAPL | Stock | 0.3088 | 0.31 | 0.3088 | 0.3098 | 7543200.0 |
| 2001-10-18 09:31:00 | AAPL | Stock | 0.3093 | 0.3109 | 0.3091 | 0.3109 | 1551200.0 |
| 2001-10-18 09:32:00 | AAPL | Stock | 0.3111 | 0.312 | 0.3091 | 0.3107 | 1377600.0 |
| 2001-10-18 09:33:00 | AAPL | Stock | 0.3107 | 0.3109 | 0.3089 | 0.3091 | 3528000.0 |
| 2001-10-18 09:34:00 | AAPL | Stock | 0.3098 | 0.3098 | 0.3089 | 0.3091 | 1248800.0 |
| 2001-10-18 09:35:00 | AAPL | Stock | 0.3091 | 0.3098 | 0.3089 | 0.3095 | 1702400.0 |
| 2001-10-18 09:36:00 | AAPL | Stock | 0.3091 | 0.3109 | 0.3091 | 0.3095 | 7470400.0 |
| 2001-10-18 09:37:00 | AAPL | Stock | 0.3105 | 0.3105 | 0.3096 | 0.3098 | 4138400.0 |
| 2001-10-18 09:38:00 | AAPL | Stock | 0.3102 | 0.3111 | 0.3098 | 0.3111 | 1920800.0 |
| 2001-10-18 09:39:00 | AAPL | Stock | 0.3113 | 0.3125 | 0.3107 | 0.3118 | 2626400.0 |
| 2001-10-18 09:40:00 | AAPL | Stock | 0.3116 | 0.3132 | 0.3116 | 0.3129 | 1820000.0 |
| 2001-10-18 09:41:00 | AAPL | Stock | 0.313 | 0.3143 | 0.3125 | 0.3141 | 5622400.0 |
| 2001-10-18 09:42:00 | AAPL | Stock | 0.3141 | 0.3146 | 0.313 | 0.3134 | 1640800.0 |
| 2001-10-18 09:43:00 | AAPL | Stock | 0.3139 | 0.3168 | 0.3131 | 0.3166 | 1008000.0 |
| 2001-10-18 09:44:00 | AAPL | Stock | 0.3166 | 0.3189 | 0.3166 | 0.3182 | 1282400.0 |
| 2001-10-18 09:45:00 | AAPL | Stock | 0.3185 | 0.3188 | 0.3179 | 0.3186 | 3528000.0 |
| 2001-10-18 09:46:00 | AAPL | Stock | 0.3184 | 0.3188 | 0.3179 | 0.318 | 3337600.0 |
| 2001-10-18 09:47:00 | AAPL | Stock | 0.318 | 0.3204 | 0.318 | 0.3204 | 3824800.0 |
> showing 50 of 263,141 rows — these rows as CSV