PREVIEW / stock_1min / 2008-03-12
file: by_date/stock_1min/2008/2008-03-12.parquet size: 12.6 MB rows: 1,030,752 symbols: 2,666
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 |
|---|---|---|---|---|---|---|---|
| 2008-03-12 05:53:00 | AAPL | Stock | 4.5593 | 4.5593 | 4.5593 | 4.5593 | 8400.0 |
| 2008-03-12 06:30:00 | AAPL | Stock | 4.5739 | 4.5739 | 4.5739 | 4.5739 | 8400.0 |
| 2008-03-12 06:37:00 | AAPL | Stock | 4.5775 | 4.5775 | 4.5775 | 4.5775 | 5600.0 |
| 2008-03-12 06:54:00 | AAPL | Stock | 4.5689 | 4.5689 | 4.5689 | 4.5689 | 8400.0 |
| 2008-03-12 07:06:00 | AAPL | Stock | 4.5593 | 4.5593 | 4.5593 | 4.5593 | 2800.0 |
| 2008-03-12 07:25:00 | AAPL | Stock | 4.5618 | 4.5618 | 4.5618 | 4.5618 | 5600.0 |
| 2008-03-12 07:26:00 | AAPL | Stock | 4.5618 | 4.5618 | 4.5618 | 4.5618 | 2800.0 |
| 2008-03-12 07:27:00 | AAPL | Stock | 4.5618 | 4.5618 | 4.5618 | 4.5618 | 4480.0 |
| 2008-03-12 07:31:00 | AAPL | Stock | 4.5614 | 4.5614 | 4.5596 | 4.5596 | 12012.0 |
| 2008-03-12 07:32:00 | AAPL | Stock | 4.5596 | 4.5596 | 4.5596 | 4.5596 | 14000.0 |
| 2008-03-12 07:34:00 | AAPL | Stock | 4.5607 | 4.5607 | 4.5586 | 4.5586 | 12684.0 |
| 2008-03-12 07:35:00 | AAPL | Stock | 4.5607 | 4.5614 | 4.5607 | 4.5614 | 9016.0 |
| 2008-03-12 07:38:00 | AAPL | Stock | 4.5625 | 4.5625 | 4.5607 | 4.5607 | 10808.0 |
| 2008-03-12 07:39:00 | AAPL | Stock | 4.5596 | 4.5596 | 4.5589 | 4.5589 | 9464.0 |
| 2008-03-12 07:41:00 | AAPL | Stock | 4.5557 | 4.5557 | 4.5557 | 4.5557 | 5600.0 |
| 2008-03-12 07:42:00 | AAPL | Stock | 4.5557 | 4.5557 | 4.5557 | 4.5557 | 2800.0 |
| 2008-03-12 07:43:00 | AAPL | Stock | 4.5557 | 4.5557 | 4.5557 | 4.5557 | 22400.0 |
| 2008-03-12 07:44:00 | AAPL | Stock | 4.5532 | 4.5571 | 4.5475 | 4.5571 | 37800.0 |
| 2008-03-12 07:46:00 | AAPL | Stock | 4.56 | 4.56 | 4.56 | 4.56 | 3500.0 |
| 2008-03-12 07:49:00 | AAPL | Stock | 4.5496 | 4.5518 | 4.5496 | 4.5496 | 28000.0 |
| 2008-03-12 07:51:00 | AAPL | Stock | 4.5482 | 4.5482 | 4.54 | 4.5482 | 39200.0 |
| 2008-03-12 07:53:00 | AAPL | Stock | 4.5486 | 4.5486 | 4.545 | 4.5464 | 17864.0 |
| 2008-03-12 07:54:00 | AAPL | Stock | 4.5446 | 4.545 | 4.5429 | 4.5429 | 22400.0 |
| 2008-03-12 07:56:00 | AAPL | Stock | 4.5464 | 4.5475 | 4.5464 | 4.5475 | 8400.0 |
| 2008-03-12 07:57:00 | AAPL | Stock | 4.5482 | 4.5482 | 4.5482 | 4.5482 | 7000.0 |
| 2008-03-12 07:58:00 | AAPL | Stock | 4.5479 | 4.5482 | 4.5479 | 4.5482 | 66080.0 |
| 2008-03-12 07:59:00 | AAPL | Stock | 4.5482 | 4.55 | 4.5482 | 4.5496 | 16800.0 |
| 2008-03-12 08:00:00 | AAPL | Stock | 4.5464 | 4.5482 | 4.5429 | 4.5482 | 53592.0 |
| 2008-03-12 08:01:00 | AAPL | Stock | 4.5436 | 4.5482 | 4.5361 | 4.5396 | 131264.0 |
| 2008-03-12 08:02:00 | AAPL | Stock | 4.5411 | 4.5411 | 4.5325 | 4.5325 | 124516.0 |
| 2008-03-12 08:03:00 | AAPL | Stock | 4.5314 | 4.5339 | 4.5254 | 4.5321 | 172508.0 |
| 2008-03-12 08:04:00 | AAPL | Stock | 4.5318 | 4.5318 | 4.5196 | 4.5232 | 174132.0 |
| 2008-03-12 08:05:00 | AAPL | Stock | 4.5232 | 4.5232 | 4.5161 | 4.5182 | 123452.0 |
| 2008-03-12 08:06:00 | AAPL | Stock | 4.5182 | 4.5232 | 4.5179 | 4.5232 | 18200.0 |
| 2008-03-12 08:07:00 | AAPL | Stock | 4.5196 | 4.5196 | 4.5125 | 4.5179 | 155372.0 |
| 2008-03-12 08:08:00 | AAPL | Stock | 4.5193 | 4.5214 | 4.515 | 4.5179 | 251132.0 |
| 2008-03-12 08:09:00 | AAPL | Stock | 4.5175 | 4.5179 | 4.5161 | 4.5161 | 64932.0 |
| 2008-03-12 08:10:00 | AAPL | Stock | 4.5161 | 4.5161 | 4.5161 | 4.5161 | 2800.0 |
| 2008-03-12 08:11:00 | AAPL | Stock | 4.5175 | 4.5179 | 4.5161 | 4.5161 | 36400.0 |
| 2008-03-12 08:12:00 | AAPL | Stock | 4.5161 | 4.5161 | 4.5125 | 4.5125 | 132188.0 |
| 2008-03-12 08:13:00 | AAPL | Stock | 4.5136 | 4.5136 | 4.5129 | 4.5129 | 14000.0 |
| 2008-03-12 08:14:00 | AAPL | Stock | 4.5132 | 4.5157 | 4.5129 | 4.5139 | 57400.0 |
| 2008-03-12 08:15:00 | AAPL | Stock | 4.5129 | 4.5157 | 4.5129 | 4.5157 | 21868.0 |
| 2008-03-12 08:16:00 | AAPL | Stock | 4.5164 | 4.5164 | 4.5143 | 4.5143 | 9800.0 |
| 2008-03-12 08:17:00 | AAPL | Stock | 4.5143 | 4.5168 | 4.5143 | 4.5168 | 8400.0 |
| 2008-03-12 08:18:00 | AAPL | Stock | 4.5179 | 4.5179 | 4.5175 | 4.5175 | 16800.0 |
| 2008-03-12 08:19:00 | AAPL | Stock | 4.5175 | 4.525 | 4.5154 | 4.5221 | 171388.0 |
| 2008-03-12 08:20:00 | AAPL | Stock | 4.5229 | 4.5246 | 4.5229 | 4.5236 | 37800.0 |
| 2008-03-12 08:21:00 | AAPL | Stock | 4.5236 | 4.5236 | 4.5196 | 4.5196 | 43400.0 |
| 2008-03-12 08:22:00 | AAPL | Stock | 4.5214 | 4.5236 | 4.5193 | 4.5221 | 62916.0 |
> showing 50 of 1,030,752 rows — these rows as CSV