PREVIEW / stock_1hour / 2015-12-07

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-12-07.parquet
  size:    1.0 MB
  rows:    49,546
  symbols: 3,420

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
2015-12-07 04:00:00	AAPL	Stock	29.81	29.88	29.81	29.86	29352.0
2015-12-07 05:00:00	AAPL	Stock	29.8375	29.8775	29.8375	29.8525	6288.0
2015-12-07 06:00:00	AAPL	Stock	29.8325	29.84	29.815	29.8375	21880.0
2015-12-07 07:00:00	AAPL	Stock	29.815	29.8325	29.78	29.7975	124800.0
2015-12-07 08:00:00	AAPL	Stock	29.7875	29.82	29.7025	29.725	380228.0
2015-12-07 09:00:00	AAPL	Stock	29.7225	29.965	29.6325	29.782	24754552.0
2015-12-07 10:00:00	AAPL	Stock	29.7825	29.8375	29.58	29.6325	21945508.0
2015-12-07 11:00:00	AAPL	Stock	29.6275	29.665	29.5025	29.5962	13498144.0
2015-12-07 12:00:00	AAPL	Stock	29.595	29.595	29.495	29.51	9991960.0
2015-12-07 13:00:00	AAPL	Stock	29.51	29.5775	29.4975	29.5675	10280720.0
2015-12-07 14:00:00	AAPL	Stock	29.5675	29.625	29.485	29.51	12542696.0
2015-12-07 15:00:00	AAPL	Stock	29.51	29.62	29.4525	29.5675	19751312.0
2015-12-07 16:00:00	AAPL	Stock	29.57	29.62	29.5345	29.6	6314788.0
2015-12-07 17:00:00	AAPL	Stock	29.6	29.6125	29.595	29.5975	17044.0
2015-12-07 18:00:00	AAPL	Stock	29.605	29.605	29.595	29.595	17160.0
2015-12-07 19:00:00	AAPL	Stock	29.59	29.59	29.5625	29.565	28460.0
2015-12-07 04:00:00	MSFT	Stock	55.99	55.99	55.99	55.99	500.0
2015-12-07 05:00:00	MSFT	Stock	56.0	56.0	56.0	56.0	300.0
2015-12-07 06:00:00	MSFT	Stock	55.98	55.98	55.81	55.97	500.0
2015-12-07 07:00:00	MSFT	Stock	55.95	56.08	55.95	56.0	4680.0
2015-12-07 08:00:00	MSFT	Stock	56.0	56.08	55.75	55.79	13617.0
2015-12-07 09:00:00	MSFT	Stock	55.76	55.88	55.32	55.51	3370214.0
2015-12-07 10:00:00	MSFT	Stock	55.5	55.64	55.43	55.58	4518202.0
2015-12-07 11:00:00	MSFT	Stock	55.57	55.61	55.335	55.54	3089611.0
2015-12-07 12:00:00	MSFT	Stock	55.53	55.6	55.34	55.37	2081486.0
2015-12-07 13:00:00	MSFT	Stock	55.36	55.61	55.29	55.57	2822923.0
2015-12-07 14:00:00	MSFT	Stock	55.57	55.795	55.5	55.51	3103161.0
2015-12-07 15:00:00	MSFT	Stock	55.515	55.97	55.41	55.82	7519068.0
2015-12-07 16:00:00	MSFT	Stock	55.81	55.96	55.632	55.82	2330219.0
2015-12-07 17:00:00	MSFT	Stock	55.84	55.87	55.82	55.82	3350.0
2015-12-07 18:00:00	MSFT	Stock	55.87	55.9	55.83	55.9	680.0
2015-12-07 19:00:00	MSFT	Stock	55.81	55.9	55.81	55.81	1703.0
2015-12-07 07:00:00	NVDA	Stock	0.8405	0.8405	0.8405	0.8405	76000.0
2015-12-07 08:00:00	NVDA	Stock	0.8438	0.8472	0.8422	0.8422	84000.0
2015-12-07 09:00:00	NVDA	Stock	0.8422	0.8443	0.832	0.8358	33735520.0
2015-12-07 10:00:00	NVDA	Stock	0.8358	0.8388	0.8316	0.8329	43556600.0
2015-12-07 11:00:00	NVDA	Stock	0.8328	0.8363	0.827	0.8346	51248520.0
2015-12-07 12:00:00	NVDA	Stock	0.8345	0.835	0.8275	0.8288	31165520.0
2015-12-07 13:00:00	NVDA	Stock	0.829	0.83	0.826	0.83	29796360.0
2015-12-07 14:00:00	NVDA	Stock	0.8298	0.831	0.8262	0.8273	35355800.0
2015-12-07 15:00:00	NVDA	Stock	0.827	0.8288	0.8252	0.828	66457840.0
2015-12-07 16:00:00	NVDA	Stock	0.8278	0.831	0.8266	0.83	33091480.0
2015-12-07 17:00:00	NVDA	Stock	0.8302	0.8302	0.83	0.83	12000.0
2015-12-07 19:00:00	NVDA	Stock	0.8295	0.8295	0.8295	0.8295	64400.0
2015-12-07 04:00:00	AMZN	Stock	33.685	33.7505	33.685	33.7505	4000.0
2015-12-07 06:00:00	AMZN	Stock	33.772	33.772	33.75	33.75	22000.0
2015-12-07 07:00:00	AMZN	Stock	33.7	33.805	33.7	33.805	64660.0
2015-12-07 08:00:00	AMZN	Stock	33.751	33.771	33.6365	33.655	289540.0
2015-12-07 09:00:00	AMZN	Stock	33.6995	33.773	33.3785	33.4182	9898040.0
2015-12-07 10:00:00	AMZN	Stock	33.406	33.4625	33.1625	33.2295	12107380.0

> showing 50 of 49,546 rows — these rows as CSV

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