PREVIEW / stock_1min / 2014-05-06
file: by_date/stock_1min/2014/2014-05-06.parquet size: 14.2 MB rows: 1,053,307 symbols: 2,867
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 |
|---|---|---|---|---|---|---|---|
| 2014-05-06 04:00:00 | AAPL | Stock | 21.5354 | 21.5354 | 21.5354 | 21.5354 | 2800.0 |
| 2014-05-06 04:01:00 | AAPL | Stock | 21.5357 | 21.5357 | 21.5357 | 21.5357 | 5600.0 |
| 2014-05-06 04:03:00 | AAPL | Stock | 21.5429 | 21.5429 | 21.5396 | 21.5396 | 13160.0 |
| 2014-05-06 04:11:00 | AAPL | Stock | 21.5446 | 21.5446 | 21.5446 | 21.5446 | 5600.0 |
| 2014-05-06 04:12:00 | AAPL | Stock | 21.5446 | 21.5696 | 21.5446 | 21.5696 | 19600.0 |
| 2014-05-06 04:13:00 | AAPL | Stock | 21.5693 | 21.5693 | 21.5693 | 21.5693 | 11200.0 |
| 2014-05-06 04:14:00 | AAPL | Stock | 21.5821 | 21.5821 | 21.5821 | 21.5821 | 2800.0 |
| 2014-05-06 04:16:00 | AAPL | Stock | 21.5693 | 21.5693 | 21.5693 | 21.5693 | 16800.0 |
| 2014-05-06 04:19:00 | AAPL | Stock | 21.5464 | 21.5464 | 21.5464 | 21.5464 | 2800.0 |
| 2014-05-06 04:20:00 | AAPL | Stock | 21.4911 | 21.4911 | 21.4911 | 21.4911 | 4200.0 |
| 2014-05-06 04:39:00 | AAPL | Stock | 21.5289 | 21.5289 | 21.5289 | 21.5289 | 2800.0 |
| 2014-05-06 04:51:00 | AAPL | Stock | 21.5289 | 21.5289 | 21.5289 | 21.5289 | 2800.0 |
| 2014-05-06 05:23:00 | AAPL | Stock | 21.5286 | 21.5286 | 21.5286 | 21.5286 | 12880.0 |
| 2014-05-06 06:00:00 | AAPL | Stock | 21.5357 | 21.5357 | 21.5357 | 21.5357 | 13440.0 |
| 2014-05-06 06:04:00 | AAPL | Stock | 21.5357 | 21.5357 | 21.5357 | 21.5357 | 41356.0 |
| 2014-05-06 06:10:00 | AAPL | Stock | 21.5179 | 21.5179 | 21.5179 | 21.5179 | 2800.0 |
| 2014-05-06 06:18:00 | AAPL | Stock | 21.5318 | 21.5318 | 21.5318 | 21.5318 | 2800.0 |
| 2014-05-06 06:41:00 | AAPL | Stock | 21.5286 | 21.5286 | 21.5286 | 21.5286 | 11200.0 |
| 2014-05-06 06:45:00 | AAPL | Stock | 21.5286 | 21.5286 | 21.5286 | 21.5286 | 2800.0 |
| 2014-05-06 06:56:00 | AAPL | Stock | 21.5286 | 21.5286 | 21.5286 | 21.5286 | 2800.0 |
| 2014-05-06 06:57:00 | AAPL | Stock | 21.5286 | 21.5286 | 21.5286 | 21.5286 | 2800.0 |
| 2014-05-06 06:59:00 | AAPL | Stock | 21.5071 | 21.5071 | 21.5 | 21.5 | 18284.0 |
| 2014-05-06 07:01:00 | AAPL | Stock | 21.5 | 21.52 | 21.5 | 21.5186 | 32116.0 |
| 2014-05-06 07:03:00 | AAPL | Stock | 21.5182 | 21.5182 | 21.5125 | 21.5179 | 11200.0 |
| 2014-05-06 07:04:00 | AAPL | Stock | 21.5182 | 21.5182 | 21.5021 | 21.5179 | 14000.0 |
| 2014-05-06 07:05:00 | AAPL | Stock | 21.5036 | 21.5179 | 21.5036 | 21.5179 | 11200.0 |
| 2014-05-06 07:06:00 | AAPL | Stock | 21.5175 | 21.5175 | 21.5175 | 21.5175 | 2800.0 |
| 2014-05-06 07:07:00 | AAPL | Stock | 21.5143 | 21.5143 | 21.5143 | 21.5143 | 2800.0 |
| 2014-05-06 07:08:00 | AAPL | Stock | 21.5179 | 21.5214 | 21.5179 | 21.5214 | 5880.0 |
| 2014-05-06 07:10:00 | AAPL | Stock | 21.5243 | 21.5243 | 21.5179 | 21.5179 | 21392.0 |
| 2014-05-06 07:13:00 | AAPL | Stock | 21.5139 | 21.5179 | 21.5139 | 21.5179 | 14728.0 |
| 2014-05-06 07:16:00 | AAPL | Stock | 21.5179 | 21.5179 | 21.5179 | 21.5179 | 2800.0 |
| 2014-05-06 07:17:00 | AAPL | Stock | 21.5118 | 21.5118 | 21.5104 | 21.5104 | 12964.0 |
| 2014-05-06 07:19:00 | AAPL | Stock | 21.5071 | 21.5175 | 21.5071 | 21.5175 | 12712.0 |
| 2014-05-06 07:20:00 | AAPL | Stock | 21.5175 | 21.5175 | 21.5157 | 21.5175 | 22400.0 |
| 2014-05-06 07:21:00 | AAPL | Stock | 21.5157 | 21.5157 | 21.5089 | 21.5089 | 9632.0 |
| 2014-05-06 07:24:00 | AAPL | Stock | 21.5193 | 21.5193 | 21.5193 | 21.5193 | 2800.0 |
| 2014-05-06 07:30:00 | AAPL | Stock | 21.5039 | 21.5039 | 21.5039 | 21.5039 | 2800.0 |
| 2014-05-06 07:31:00 | AAPL | Stock | 21.5089 | 21.5164 | 21.5089 | 21.5129 | 19040.0 |
| 2014-05-06 07:33:00 | AAPL | Stock | 21.5086 | 21.5086 | 21.5086 | 21.5086 | 2800.0 |
| 2014-05-06 07:35:00 | AAPL | Stock | 21.5175 | 21.5175 | 21.5175 | 21.5175 | 8400.0 |
| 2014-05-06 07:38:00 | AAPL | Stock | 21.5111 | 21.5111 | 21.5111 | 21.5111 | 4200.0 |
| 2014-05-06 07:39:00 | AAPL | Stock | 21.5175 | 21.5179 | 21.5175 | 21.5179 | 5600.0 |
| 2014-05-06 07:40:00 | AAPL | Stock | 21.5179 | 21.5179 | 21.5179 | 21.5179 | 5600.0 |
| 2014-05-06 07:41:00 | AAPL | Stock | 21.5179 | 21.5179 | 21.5179 | 21.5179 | 11200.0 |
| 2014-05-06 07:43:00 | AAPL | Stock | 21.5175 | 21.5175 | 21.5175 | 21.5175 | 5600.0 |
| 2014-05-06 07:45:00 | AAPL | Stock | 21.5175 | 21.5179 | 21.5175 | 21.5179 | 24864.0 |
| 2014-05-06 07:47:00 | AAPL | Stock | 21.5143 | 21.5143 | 21.5143 | 21.5143 | 7560.0 |
| 2014-05-06 07:52:00 | AAPL | Stock | 21.5086 | 21.5086 | 21.5079 | 21.5086 | 15120.0 |
| 2014-05-06 07:53:00 | AAPL | Stock | 21.5086 | 21.5086 | 21.5043 | 21.5043 | 52080.0 |
> showing 50 of 1,053,307 rows — these rows as CSV