PREVIEW / stock_1min / 2005-04-12
file: by_date/stock_1min/2005/2005-04-12.parquet size: 6.8 MB rows: 558,642 symbols: 1,609
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 |
|---|---|---|---|---|---|---|---|
| 2005-04-12 07:48:00 | AAPL | Stock | 1.5157 | 1.5157 | 1.5157 | 1.5157 | 2800.0 |
| 2005-04-12 07:49:00 | AAPL | Stock | 1.5143 | 1.5143 | 1.5143 | 1.5143 | 2800.0 |
| 2005-04-12 07:53:00 | AAPL | Stock | 1.5086 | 1.5086 | 1.5057 | 1.5086 | 128800.0 |
| 2005-04-12 07:54:00 | AAPL | Stock | 1.5086 | 1.5086 | 1.5086 | 1.5086 | 14000.0 |
| 2005-04-12 07:55:00 | AAPL | Stock | 1.5086 | 1.5086 | 1.5086 | 1.5086 | 8400.0 |
| 2005-04-12 08:00:00 | AAPL | Stock | 1.5071 | 1.5132 | 1.5071 | 1.5107 | 157920.0 |
| 2005-04-12 08:01:00 | AAPL | Stock | 1.5125 | 1.5143 | 1.5086 | 1.5107 | 309400.0 |
| 2005-04-12 08:02:00 | AAPL | Stock | 1.5107 | 1.5125 | 1.5107 | 1.5125 | 36400.0 |
| 2005-04-12 08:03:00 | AAPL | Stock | 1.5107 | 1.5107 | 1.5107 | 1.5107 | 12600.0 |
| 2005-04-12 08:04:00 | AAPL | Stock | 1.5132 | 1.5139 | 1.5125 | 1.5132 | 140000.0 |
| 2005-04-12 08:05:00 | AAPL | Stock | 1.5132 | 1.5132 | 1.5132 | 1.5132 | 268520.0 |
| 2005-04-12 08:06:00 | AAPL | Stock | 1.5129 | 1.5132 | 1.5125 | 1.5125 | 187040.0 |
| 2005-04-12 08:07:00 | AAPL | Stock | 1.5114 | 1.5143 | 1.5114 | 1.5125 | 531720.0 |
| 2005-04-12 08:08:00 | AAPL | Stock | 1.5125 | 1.5143 | 1.5125 | 1.5125 | 222320.0 |
| 2005-04-12 08:09:00 | AAPL | Stock | 1.5139 | 1.515 | 1.5129 | 1.515 | 178640.0 |
| 2005-04-12 08:10:00 | AAPL | Stock | 1.5154 | 1.5168 | 1.5143 | 1.5154 | 177408.0 |
| 2005-04-12 08:11:00 | AAPL | Stock | 1.5161 | 1.5168 | 1.5146 | 1.5154 | 408800.0 |
| 2005-04-12 08:12:00 | AAPL | Stock | 1.5154 | 1.5161 | 1.5154 | 1.5157 | 76048.0 |
| 2005-04-12 08:13:00 | AAPL | Stock | 1.5154 | 1.5161 | 1.515 | 1.5161 | 95200.0 |
| 2005-04-12 08:14:00 | AAPL | Stock | 1.5161 | 1.5161 | 1.515 | 1.5161 | 46620.0 |
| 2005-04-12 08:15:00 | AAPL | Stock | 1.5161 | 1.5161 | 1.5143 | 1.5143 | 108444.0 |
| 2005-04-12 08:16:00 | AAPL | Stock | 1.5139 | 1.5146 | 1.5129 | 1.5143 | 167160.0 |
| 2005-04-12 08:17:00 | AAPL | Stock | 1.5143 | 1.5146 | 1.5143 | 1.5146 | 25200.0 |
| 2005-04-12 08:18:00 | AAPL | Stock | 1.5146 | 1.5146 | 1.5146 | 1.5146 | 25200.0 |
| 2005-04-12 08:19:00 | AAPL | Stock | 1.5157 | 1.5175 | 1.5157 | 1.5171 | 107072.0 |
| 2005-04-12 08:20:00 | AAPL | Stock | 1.5171 | 1.5207 | 1.515 | 1.5196 | 464100.0 |
| 2005-04-12 08:21:00 | AAPL | Stock | 1.5204 | 1.5204 | 1.5179 | 1.5182 | 106400.0 |
| 2005-04-12 08:22:00 | AAPL | Stock | 1.5179 | 1.5179 | 1.5154 | 1.5161 | 312340.0 |
| 2005-04-12 08:23:00 | AAPL | Stock | 1.5175 | 1.5179 | 1.5171 | 1.5179 | 338800.0 |
| 2005-04-12 08:24:00 | AAPL | Stock | 1.5179 | 1.5182 | 1.5175 | 1.5175 | 327600.0 |
| 2005-04-12 08:25:00 | AAPL | Stock | 1.5179 | 1.5179 | 1.5175 | 1.5179 | 59556.0 |
| 2005-04-12 08:26:00 | AAPL | Stock | 1.5182 | 1.5182 | 1.5179 | 1.5179 | 45304.0 |
| 2005-04-12 08:27:00 | AAPL | Stock | 1.5179 | 1.5196 | 1.5179 | 1.5196 | 70000.0 |
| 2005-04-12 08:28:00 | AAPL | Stock | 1.5193 | 1.5204 | 1.5193 | 1.5196 | 50400.0 |
| 2005-04-12 08:29:00 | AAPL | Stock | 1.5196 | 1.5196 | 1.5143 | 1.5186 | 173600.0 |
| 2005-04-12 08:30:00 | AAPL | Stock | 1.5189 | 1.5189 | 1.5161 | 1.5175 | 220164.0 |
| 2005-04-12 08:31:00 | AAPL | Stock | 1.5157 | 1.5186 | 1.5157 | 1.5186 | 40404.0 |
| 2005-04-12 08:32:00 | AAPL | Stock | 1.5182 | 1.5196 | 1.5168 | 1.5193 | 89600.0 |
| 2005-04-12 08:33:00 | AAPL | Stock | 1.5196 | 1.5207 | 1.5179 | 1.5179 | 315196.0 |
| 2005-04-12 08:34:00 | AAPL | Stock | 1.5175 | 1.5189 | 1.5161 | 1.5189 | 61600.0 |
| 2005-04-12 08:35:00 | AAPL | Stock | 1.5193 | 1.5214 | 1.5179 | 1.5214 | 148400.0 |
| 2005-04-12 08:36:00 | AAPL | Stock | 1.5189 | 1.5196 | 1.5179 | 1.5186 | 73780.0 |
| 2005-04-12 08:37:00 | AAPL | Stock | 1.5182 | 1.5189 | 1.5179 | 1.5179 | 137256.0 |
| 2005-04-12 08:38:00 | AAPL | Stock | 1.5175 | 1.5175 | 1.5157 | 1.5161 | 95200.0 |
| 2005-04-12 08:39:00 | AAPL | Stock | 1.5154 | 1.5157 | 1.5132 | 1.5132 | 50400.0 |
| 2005-04-12 08:40:00 | AAPL | Stock | 1.5139 | 1.5143 | 1.5129 | 1.5143 | 198800.0 |
| 2005-04-12 08:41:00 | AAPL | Stock | 1.5129 | 1.5129 | 1.5107 | 1.5125 | 396480.0 |
| 2005-04-12 08:42:00 | AAPL | Stock | 1.5139 | 1.5143 | 1.5125 | 1.5129 | 399868.0 |
| 2005-04-12 08:43:00 | AAPL | Stock | 1.5139 | 1.5143 | 1.5139 | 1.5143 | 43792.0 |
| 2005-04-12 08:44:00 | AAPL | Stock | 1.5143 | 1.5161 | 1.5143 | 1.5146 | 151200.0 |
> showing 50 of 558,642 rows — these rows as CSV