PREVIEW / stock_daily / 2014-12-12

all stock daily files

  file:    by_date/stock_daily/2014/2014-12-12.parquet
  size:    223 KB
  rows:    6,656
  symbols: 3,550

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2014-12-12	AAPL	Stock	27.615	27.9675	27.395	27.4325	224112400.0
2014-12-12	MSFT	Stock	46.78	47.73	46.67	46.95	34248400.0
2014-12-12	NVDA	Stock	0.4998	0.5043	0.4902	0.4908	323964000.0
2014-12-12	AMZN	Stock	15.1995	15.532	15.1505	15.366	63070000.0
2014-12-12	GOOGL	Stock	26.372	26.612	26.073	26.0755	47430860.0
2014-12-12	META	Stock	77.16	78.88	77.02	77.83	28091600.0
2014-12-12	TSLA	Stock	13.6547	14.112	13.6333	13.8	107607000.0
2014-12-12	TLT	Stock	125.45	126.35	125.02	126.3	9317388.0
2014-12-12	ES	Stock	51.43	52.08	51.12	51.14	1189800.0
2014-12-12	CL	Stock	68.77	69.6	68.56	68.57	3369900.0
2014-12-12	A	Stock	40.2	40.62	39.71	39.72	2333400.0
2014-12-12	AA.B-DELISTED	Stock	47.7	48.47	47.65	47.69	138978.0
2014-12-12	AABA-DELISTED	Stock	49.55	51.17	49.48	50.24	19021069.0
2014-12-12	AAC-DELISTED	Stock	29.6	30.83	29.04	29.95	53732.0
2014-12-12	AACG	Stock	3.44	3.48	3.15	3.48	23300.0
2014-12-12	AAIC-DELISTED	Stock	27.35	27.35	26.81	26.96	331284.0
2014-12-12	AAL	Stock	51.68	51.7	49.9	49.97	15364000.0
2014-12-12	AAMC-DELISTED	Stock	131.4265	132.9412	128.8235	132.6471	21811.0
2014-12-12	AAME	Stock	3.88	3.88	3.8	3.88	1700.0
2014-12-12	AAMI	Stock	15.9	16.22	15.65	15.87	199000.0
2014-12-12	AAOI	Stock	9.81	9.96	9.48	9.64	250500.0
2014-12-12	AAON	Stock	13.9867	14.2733	13.9333	13.9467	215550.0
2014-12-12	AAP	Stock	158.92	161.99	158.92	160.25	857500.0
2014-12-12	AAT	Stock	39.23	39.55	39.07	39.12	103800.0
2014-12-12	AAU-DELISTED	Stock	1.01	1.03	0.9559	0.96	271818.0
2014-12-12	AAUAF-DELISTED	Stock	0.98	1.0	0.925	0.96	282083.0
2014-12-12	AAV-DELISTED	Stock	4.4	4.67	4.36	4.62	241588.0
2014-12-12	AAVL-DELISTED	Stock	49.46	51.83	49.0	50.5	187308.0
2014-12-12	AAWW-DELISTED	Stock	47.15	48.23	46.48	46.66	333530.0
2014-12-12	AAXJ	Stock	60.37	60.65	59.95	59.96	497285.0
2014-12-12	AAXN-DELISTED	Stock	22.9	23.88	22.8	23.18	3128092.0
2014-12-12	AB	Stock	24.9	25.26	24.22	24.24	405700.0
2014-12-12	ABAC-DELISTED	Stock	1.95	1.95	1.78	1.78	32205.0
2014-12-12	ABAX-DELISTED	Stock	56.01	57.56	55.89	57.19	94986.0
2014-12-12	ABB-DELISTED	Stock	21.03	21.095	20.71	20.72	1840280.0
2014-12-12	ABBNY-DELISTED	Stock	21.03	21.095	20.71	20.72	2006716.0
2014-12-12	ABBV	Stock	66.53	67.17	65.01	65.27	9215500.0
2014-12-12	ABC-DELISTED	Stock	91.88	92.53	90.92	90.98	1523669.0
2014-12-12	ABCB	Stock	25.21	25.52	25.16	25.21	56600.0
2014-12-12	ABCD-DELISTED	Stock	1.635	1.669	1.52	1.59	27800.0
2014-12-12	ABCO-DELISTED	Stock	43.9	46.25	43.82	46.03	688400.0
2014-12-12	ABCW-DELISTED	Stock	30.3	30.4	30.11	30.3	2300.0
2014-12-12	ABDC-DELISTED	Stock	11.94	11.99	11.41	11.5	77682.0
2014-12-12	ABE-DELISTED	Stock	13.65	13.65	13.22	13.22	8314.0
2014-12-12	ABEO	Stock	150.0	168.75	150.0	150.0	16.0
2014-12-12	ABEV	Stock	5.92	5.94	5.81	5.86	10873800.0
2014-12-12	ABG	Stock	74.38	75.69	74.27	74.64	413600.0
2014-12-12	ABGB-DELISTED	Stock	12.87	12.87	12.37	12.37	41744.0
2014-12-12	ABIL-DELISTED	Stock	9.78	9.7895	9.78	9.78	500.0
2014-12-12	ABM	Stock	27.1	27.45	27.1	27.28	233400.0

> showing 50 of 6,656 rows — these rows as CSV

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