PREVIEW / stock_5min / 2014-01-09
file: by_date/stock_5min/2014/2014-01-09.parquet size: 5.5 MB rows: 363,608 symbols: 3,519
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-01-09 04:00:00 | AAPL | Stock | 19.4586 | 19.4875 | 19.4586 | 19.4875 | 8400.0 |
| 2014-01-09 04:05:00 | AAPL | Stock | 19.5225 | 19.5225 | 19.5225 | 19.5225 | 2800.0 |
| 2014-01-09 04:30:00 | AAPL | Stock | 19.4971 | 19.4971 | 19.4971 | 19.4971 | 2800.0 |
| 2014-01-09 04:40:00 | AAPL | Stock | 19.4643 | 19.4643 | 19.4643 | 19.4643 | 2800.0 |
| 2014-01-09 05:05:00 | AAPL | Stock | 19.4864 | 19.4929 | 19.4864 | 19.4929 | 12600.0 |
| 2014-01-09 05:30:00 | AAPL | Stock | 19.4743 | 19.4743 | 19.4743 | 19.4743 | 2800.0 |
| 2014-01-09 05:35:00 | AAPL | Stock | 19.4821 | 19.4821 | 19.4821 | 19.4821 | 2800.0 |
| 2014-01-09 05:50:00 | AAPL | Stock | 19.4979 | 19.4979 | 19.4979 | 19.4979 | 2800.0 |
| 2014-01-09 06:40:00 | AAPL | Stock | 19.4821 | 19.4821 | 19.4821 | 19.4821 | 2800.0 |
| 2014-01-09 06:45:00 | AAPL | Stock | 19.4714 | 19.4714 | 19.4714 | 19.4714 | 2800.0 |
| 2014-01-09 06:55:00 | AAPL | Stock | 19.4739 | 19.4846 | 19.4714 | 19.4846 | 11200.0 |
| 2014-01-09 07:00:00 | AAPL | Stock | 19.4714 | 19.4946 | 19.4714 | 19.4946 | 35784.0 |
| 2014-01-09 07:05:00 | AAPL | Stock | 19.4886 | 19.4986 | 19.4886 | 19.4986 | 28000.0 |
| 2014-01-09 07:10:00 | AAPL | Stock | 19.4961 | 19.5018 | 19.4961 | 19.5 | 52080.0 |
| 2014-01-09 07:15:00 | AAPL | Stock | 19.5007 | 19.5096 | 19.5 | 19.5096 | 25200.0 |
| 2014-01-09 07:20:00 | AAPL | Stock | 19.5086 | 19.5086 | 19.5014 | 19.5014 | 8400.0 |
| 2014-01-09 07:25:00 | AAPL | Stock | 19.5007 | 19.5007 | 19.5007 | 19.5007 | 2800.0 |
| 2014-01-09 07:35:00 | AAPL | Stock | 19.5086 | 19.5179 | 19.5086 | 19.5179 | 98672.0 |
| 2014-01-09 07:40:00 | AAPL | Stock | 19.5196 | 19.5357 | 19.5143 | 19.5357 | 62160.0 |
| 2014-01-09 07:45:00 | AAPL | Stock | 19.5318 | 19.5757 | 19.5318 | 19.5446 | 123004.0 |
| 2014-01-09 07:50:00 | AAPL | Stock | 19.5518 | 19.5557 | 19.5379 | 19.5379 | 45080.0 |
| 2014-01-09 07:55:00 | AAPL | Stock | 19.5357 | 19.5364 | 19.5357 | 19.5361 | 16800.0 |
| 2014-01-09 08:00:00 | AAPL | Stock | 19.4843 | 19.5482 | 19.4843 | 19.5446 | 260204.0 |
| 2014-01-09 08:05:00 | AAPL | Stock | 19.5464 | 19.5464 | 19.5179 | 19.5179 | 96152.0 |
| 2014-01-09 08:10:00 | AAPL | Stock | 19.52 | 19.52 | 19.51 | 19.5132 | 29400.0 |
| 2014-01-09 08:15:00 | AAPL | Stock | 19.5046 | 19.5246 | 19.5036 | 19.5225 | 117600.0 |
| 2014-01-09 08:20:00 | AAPL | Stock | 19.5204 | 19.5214 | 19.5143 | 19.52 | 53956.0 |
| 2014-01-09 08:25:00 | AAPL | Stock | 19.5161 | 19.5207 | 19.5161 | 19.5207 | 37436.0 |
| 2014-01-09 08:30:00 | AAPL | Stock | 19.5146 | 19.5146 | 19.5054 | 19.5082 | 90580.0 |
| 2014-01-09 08:35:00 | AAPL | Stock | 19.5175 | 19.5175 | 19.5 | 19.5029 | 41496.0 |
| 2014-01-09 08:40:00 | AAPL | Stock | 19.5071 | 19.5071 | 19.5064 | 19.5064 | 12600.0 |
| 2014-01-09 08:45:00 | AAPL | Stock | 19.5004 | 19.5021 | 19.4875 | 19.4893 | 119168.0 |
| 2014-01-09 08:50:00 | AAPL | Stock | 19.4957 | 19.5036 | 19.4957 | 19.5025 | 47964.0 |
| 2014-01-09 08:55:00 | AAPL | Stock | 19.5111 | 19.5214 | 19.5093 | 19.5211 | 74704.0 |
| 2014-01-09 09:00:00 | AAPL | Stock | 19.5147 | 19.5179 | 19.4993 | 19.5143 | 121492.0 |
| 2014-01-09 09:05:00 | AAPL | Stock | 19.5179 | 19.5346 | 19.5164 | 19.525 | 127092.0 |
| 2014-01-09 09:10:00 | AAPL | Stock | 19.5282 | 19.5339 | 19.5225 | 19.5286 | 102676.0 |
| 2014-01-09 09:15:00 | AAPL | Stock | 19.5214 | 19.5214 | 19.5136 | 19.5179 | 36400.0 |
| 2014-01-09 09:20:00 | AAPL | Stock | 19.5179 | 19.5286 | 19.5179 | 19.5186 | 57036.0 |
| 2014-01-09 09:25:00 | AAPL | Stock | 19.52 | 19.5339 | 19.5179 | 19.5286 | 218932.0 |
| 2014-01-09 09:30:00 | AAPL | Stock | 19.5286 | 19.535 | 19.47 | 19.4751 | 9707040.0 |
| 2014-01-09 09:35:00 | AAPL | Stock | 19.4793 | 19.5239 | 19.4696 | 19.4871 | 7956452.0 |
| 2014-01-09 09:40:00 | AAPL | Stock | 19.4929 | 19.4934 | 19.4464 | 19.4646 | 5602156.0 |
| 2014-01-09 09:45:00 | AAPL | Stock | 19.4629 | 19.4939 | 19.4504 | 19.4771 | 3198300.0 |
| 2014-01-09 09:50:00 | AAPL | Stock | 19.4754 | 19.4893 | 19.4521 | 19.4743 | 2788940.0 |
| 2014-01-09 09:55:00 | AAPL | Stock | 19.475 | 19.5107 | 19.4586 | 19.5096 | 4328100.0 |
| 2014-01-09 10:00:00 | AAPL | Stock | 19.51 | 19.5175 | 19.4532 | 19.4746 | 4543588.0 |
| 2014-01-09 10:05:00 | AAPL | Stock | 19.4746 | 19.4802 | 19.4096 | 19.4396 | 5789784.0 |
| 2014-01-09 10:10:00 | AAPL | Stock | 19.4417 | 19.4521 | 19.3939 | 19.4046 | 4684904.0 |
| 2014-01-09 10:15:00 | AAPL | Stock | 19.405 | 19.4261 | 19.3689 | 19.4261 | 4303824.0 |
> showing 50 of 363,608 rows — these rows as CSV