PREVIEW / stock_1hour / 2014-11-26

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-11-26.parquet
  size:    1.0 MB
  rows:    47,868
  symbols: 3,567

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-11-26 04:00:00	AAPL	Stock	29.5	29.555	29.5	29.5	41080.0
2014-11-26 05:00:00	AAPL	Stock	29.4975	29.5025	29.4675	29.475	15180.0
2014-11-26 06:00:00	AAPL	Stock	29.465	29.5	29.4625	29.5	57852.0
2014-11-26 07:00:00	AAPL	Stock	29.4925	29.505	29.455	29.465	194072.0
2014-11-26 08:00:00	AAPL	Stock	29.485	29.59	29.4	29.535	854304.0
2014-11-26 09:00:00	AAPL	Stock	29.52	29.7475	29.4575	29.6882	28617100.0
2014-11-26 10:00:00	AAPL	Stock	29.6888	29.775	29.61	29.68	29140772.0
2014-11-26 11:00:00	AAPL	Stock	29.6782	29.755	29.58	29.595	18359928.0
2014-11-26 12:00:00	AAPL	Stock	29.5975	29.685	29.525	29.635	17342868.0
2014-11-26 13:00:00	AAPL	Stock	29.6375	29.7025	29.5925	29.5975	10237652.0
2014-11-26 14:00:00	AAPL	Stock	29.6025	29.655	29.5975	29.64	9589448.0
2014-11-26 15:00:00	AAPL	Stock	29.64	29.76	29.62	29.7475	24487440.0
2014-11-26 16:00:00	AAPL	Stock	29.75	29.76	29.6642	29.755	12590764.0
2014-11-26 17:00:00	AAPL	Stock	29.7575	29.775	29.7525	29.7725	159612.0
2014-11-26 18:00:00	AAPL	Stock	29.775	29.785	29.7725	29.78	99332.0
2014-11-26 19:00:00	AAPL	Stock	29.78	29.7875	29.765	29.785	127244.0
2014-11-26 04:00:00	MSFT	Stock	47.53	47.53	47.53	47.53	200.0
2014-11-26 06:00:00	MSFT	Stock	47.49	47.49	47.49	47.49	200.0
2014-11-26 07:00:00	MSFT	Stock	47.55	47.55	47.55	47.55	100.0
2014-11-26 08:00:00	MSFT	Stock	47.6	47.6	47.49	47.5	6757.0
2014-11-26 09:00:00	MSFT	Stock	47.5	47.51	47.28	47.3	2920013.0
2014-11-26 10:00:00	MSFT	Stock	47.31	47.485	47.28	47.455	3962685.0
2014-11-26 11:00:00	MSFT	Stock	47.46	47.565	47.44	47.53	3214849.0
2014-11-26 12:00:00	MSFT	Stock	47.53	47.94	47.5	47.9	2946147.0
2014-11-26 13:00:00	MSFT	Stock	47.9	47.99	47.82	47.96	1704108.0
2014-11-26 14:00:00	MSFT	Stock	47.97	47.98	47.82	47.825	1715310.0
2014-11-26 15:00:00	MSFT	Stock	47.82	47.84	47.73	47.75	5166151.0
2014-11-26 16:00:00	MSFT	Stock	47.75	47.864	47.47	47.74	4560451.0
2014-11-26 17:00:00	MSFT	Stock	47.74	47.75	47.74	47.75	2270.0
2014-11-26 18:00:00	MSFT	Stock	47.75	47.75	47.75	47.75	1100.0
2014-11-26 19:00:00	MSFT	Stock	47.79	47.79	47.79	47.79	200.0
2014-11-26 09:00:00	NVDA	Stock	0.5128	0.5175	0.511	0.516	21449320.0
2014-11-26 10:00:00	NVDA	Stock	0.516	0.5192	0.5155	0.5163	36079120.0
2014-11-26 11:00:00	NVDA	Stock	0.5165	0.5182	0.5161	0.5181	23352480.0
2014-11-26 12:00:00	NVDA	Stock	0.5181	0.519	0.517	0.517	15213720.0
2014-11-26 13:00:00	NVDA	Stock	0.5171	0.52	0.517	0.52	14760200.0
2014-11-26 14:00:00	NVDA	Stock	0.52	0.523	0.5198	0.5228	29147840.0
2014-11-26 15:00:00	NVDA	Stock	0.5229	0.5235	0.5207	0.5228	48955960.0
2014-11-26 16:00:00	NVDA	Stock	0.523	0.523	0.5178	0.5187	4497320.0
2014-11-26 06:00:00	AMZN	Stock	16.765	16.765	16.765	16.765	2000.0
2014-11-26 07:00:00	AMZN	Stock	16.7795	16.7795	16.7625	16.765	30000.0
2014-11-26 08:00:00	AMZN	Stock	16.7625	16.7795	16.6865	16.742	72440.0
2014-11-26 09:00:00	AMZN	Stock	16.7165	16.7325	16.5875	16.6075	5457180.0
2014-11-26 10:00:00	AMZN	Stock	16.6058	16.723	16.6	16.6945	6078280.0
2014-11-26 11:00:00	AMZN	Stock	16.6975	16.719	16.64	16.715	4324800.0
2014-11-26 12:00:00	AMZN	Stock	16.715	16.7195	16.667	16.688	2751840.0
2014-11-26 13:00:00	AMZN	Stock	16.6855	16.695	16.6365	16.6705	3845180.0
2014-11-26 14:00:00	AMZN	Stock	16.6705	16.6705	16.6115	16.6465	3399400.0
2014-11-26 15:00:00	AMZN	Stock	16.6475	16.685	16.63	16.679	6601100.0
2014-11-26 16:00:00	AMZN	Stock	16.6785	16.68	16.6595	16.6785	1196900.0

> showing 50 of 47,868 rows — these rows as CSV

> unlock the full archive -- $79 one-time