PREVIEW / stock_1min / 2013-01-03
file: by_date/stock_1min/2013/2013-01-03.parquet size: 13.1 MB rows: 966,102 symbols: 2,819
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 |
|---|---|---|---|---|---|---|---|
| 2013-01-03 04:06:00 | AAPL | Stock | 19.6086 | 19.6086 | 19.6086 | 19.6086 | 2800.0 |
| 2013-01-03 04:12:00 | AAPL | Stock | 19.6036 | 19.6036 | 19.6036 | 19.6036 | 12544.0 |
| 2013-01-03 04:14:00 | AAPL | Stock | 19.6071 | 19.6071 | 19.6071 | 19.6071 | 2800.0 |
| 2013-01-03 04:19:00 | AAPL | Stock | 19.6032 | 19.6032 | 19.6032 | 19.6032 | 2800.0 |
| 2013-01-03 04:48:00 | AAPL | Stock | 19.5636 | 19.5636 | 19.5636 | 19.5636 | 2800.0 |
| 2013-01-03 04:49:00 | AAPL | Stock | 19.5636 | 19.5636 | 19.5636 | 19.5636 | 4200.0 |
| 2013-01-03 04:53:00 | AAPL | Stock | 19.5643 | 19.5643 | 19.5643 | 19.5643 | 2800.0 |
| 2013-01-03 05:45:00 | AAPL | Stock | 19.5218 | 19.5218 | 19.5218 | 19.5218 | 2800.0 |
| 2013-01-03 05:58:00 | AAPL | Stock | 19.5257 | 19.5257 | 19.5257 | 19.5257 | 2800.0 |
| 2013-01-03 06:00:00 | AAPL | Stock | 19.5004 | 19.5004 | 19.5004 | 19.5004 | 6972.0 |
| 2013-01-03 06:07:00 | AAPL | Stock | 19.5254 | 19.5254 | 19.5254 | 19.5254 | 14000.0 |
| 2013-01-03 06:58:00 | AAPL | Stock | 19.5386 | 19.5386 | 19.5386 | 19.5386 | 2800.0 |
| 2013-01-03 07:09:00 | AAPL | Stock | 19.5389 | 19.5389 | 19.5386 | 19.5386 | 29400.0 |
| 2013-01-03 07:12:00 | AAPL | Stock | 19.5296 | 19.5296 | 19.5179 | 19.5179 | 8400.0 |
| 2013-01-03 07:13:00 | AAPL | Stock | 19.5175 | 19.5175 | 19.5175 | 19.5175 | 2800.0 |
| 2013-01-03 07:14:00 | AAPL | Stock | 19.5061 | 19.5061 | 19.5036 | 19.5036 | 8400.0 |
| 2013-01-03 07:15:00 | AAPL | Stock | 19.5036 | 19.5036 | 19.5036 | 19.5036 | 2800.0 |
| 2013-01-03 07:16:00 | AAPL | Stock | 19.5 | 19.5 | 19.5 | 19.5 | 14000.0 |
| 2013-01-03 07:17:00 | AAPL | Stock | 19.5 | 19.5107 | 19.5 | 19.5107 | 13720.0 |
| 2013-01-03 07:24:00 | AAPL | Stock | 19.5321 | 19.5321 | 19.5321 | 19.5321 | 2800.0 |
| 2013-01-03 07:25:00 | AAPL | Stock | 19.5186 | 19.5186 | 19.5186 | 19.5186 | 8400.0 |
| 2013-01-03 07:26:00 | AAPL | Stock | 19.5186 | 19.5186 | 19.5186 | 19.5186 | 11200.0 |
| 2013-01-03 07:32:00 | AAPL | Stock | 19.5321 | 19.5321 | 19.5321 | 19.5321 | 2800.0 |
| 2013-01-03 07:33:00 | AAPL | Stock | 19.5193 | 19.5193 | 19.5193 | 19.5193 | 2800.0 |
| 2013-01-03 07:43:00 | AAPL | Stock | 19.5111 | 19.5114 | 19.5 | 19.5089 | 22400.0 |
| 2013-01-03 07:44:00 | AAPL | Stock | 19.5025 | 19.5025 | 19.5007 | 19.5007 | 5600.0 |
| 2013-01-03 07:48:00 | AAPL | Stock | 19.5111 | 19.5193 | 19.5111 | 19.5193 | 50400.0 |
| 2013-01-03 07:49:00 | AAPL | Stock | 19.5057 | 19.5057 | 19.5007 | 19.5007 | 142800.0 |
| 2013-01-03 07:51:00 | AAPL | Stock | 19.4954 | 19.5 | 19.4954 | 19.4996 | 42868.0 |
| 2013-01-03 07:52:00 | AAPL | Stock | 19.5 | 19.5 | 19.5 | 19.5 | 53200.0 |
| 2013-01-03 07:53:00 | AAPL | Stock | 19.5 | 19.5 | 19.5 | 19.5 | 12040.0 |
| 2013-01-03 07:54:00 | AAPL | Stock | 19.4996 | 19.4996 | 19.4989 | 19.4989 | 5600.0 |
| 2013-01-03 07:58:00 | AAPL | Stock | 19.4996 | 19.5 | 19.4996 | 19.5 | 5600.0 |
| 2013-01-03 08:00:00 | AAPL | Stock | 19.5 | 19.5193 | 19.4854 | 19.4993 | 118188.0 |
| 2013-01-03 08:01:00 | AAPL | Stock | 19.4861 | 19.5011 | 19.4857 | 19.4993 | 52220.0 |
| 2013-01-03 08:02:00 | AAPL | Stock | 19.5104 | 19.5104 | 19.4964 | 19.5 | 28000.0 |
| 2013-01-03 08:04:00 | AAPL | Stock | 19.5207 | 19.5229 | 19.5021 | 19.5021 | 16072.0 |
| 2013-01-03 08:05:00 | AAPL | Stock | 19.5018 | 19.5018 | 19.5011 | 19.5011 | 11200.0 |
| 2013-01-03 08:07:00 | AAPL | Stock | 19.5007 | 19.5007 | 19.4861 | 19.4861 | 49700.0 |
| 2013-01-03 08:08:00 | AAPL | Stock | 19.49 | 19.49 | 19.49 | 19.49 | 7000.0 |
| 2013-01-03 08:09:00 | AAPL | Stock | 19.49 | 19.4929 | 19.4893 | 19.4929 | 26180.0 |
| 2013-01-03 08:10:00 | AAPL | Stock | 19.4893 | 19.4893 | 19.4893 | 19.4893 | 5600.0 |
| 2013-01-03 08:11:00 | AAPL | Stock | 19.4893 | 19.4893 | 19.4893 | 19.4893 | 11900.0 |
| 2013-01-03 08:13:00 | AAPL | Stock | 19.4893 | 19.4893 | 19.4893 | 19.4893 | 2800.0 |
| 2013-01-03 08:14:00 | AAPL | Stock | 19.4821 | 19.4821 | 19.4821 | 19.4821 | 5600.0 |
| 2013-01-03 08:15:00 | AAPL | Stock | 19.4993 | 19.5179 | 19.4821 | 19.5004 | 57400.0 |
| 2013-01-03 08:16:00 | AAPL | Stock | 19.5146 | 19.5179 | 19.5146 | 19.5179 | 33600.0 |
| 2013-01-03 08:17:00 | AAPL | Stock | 19.5093 | 19.6082 | 19.505 | 19.5179 | 56504.0 |
| 2013-01-03 08:18:00 | AAPL | Stock | 19.5154 | 19.5154 | 19.5071 | 19.5071 | 5600.0 |
| 2013-01-03 08:19:00 | AAPL | Stock | 19.5164 | 19.5179 | 19.5089 | 19.5179 | 23800.0 |
> showing 50 of 966,102 rows — these rows as CSV