PREVIEW / stock_daily / 2016-07-14

all stock daily files

  file:    by_date/stock_daily/2016/2016-07-14.parquet
  size:    220 KB
  rows:    6,574
  symbols: 3,274

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
2016-07-14	AAPL	Stock	24.3475	24.7475	24.33	24.6975	155676000.0
2016-07-14	MSFT	Stock	53.84	53.99	53.58	53.74	24545500.0
2016-07-14	NVDA	Stock	1.3265	1.345	1.3155	1.333	316892000.0
2016-07-14	AMZN	Stock	37.443	37.452	36.951	37.06	47810000.0
2016-07-14	GOOGL	Stock	36.697	36.807	36.5295	36.79	21407020.0
2016-07-14	META	Stock	117.5	117.64	116.7	117.29	14579700.0
2016-07-14	TSLA	Stock	14.8747	14.996	14.7367	14.7687	40137000.0
2016-07-14	TLT	Stock	139.28	139.84	139.09	139.59	10817019.0
2016-07-14	ES	Stock	57.92	58.07	57.53	57.75	2113600.0
2016-07-14	CL	Stock	74.49	75.33	74.33	74.71	5222200.0
2016-07-14	A	Stock	46.86	46.98	46.69	46.8	1192500.0
2016-07-14	AA.B-DELISTED	Stock	36.8	37.0	36.43	36.53	38268.0
2016-07-14	AAAP-DELISTED	Stock	31.0	31.0	30.5001	31.0	214157.0
2016-07-14	AABA-DELISTED	Stock	37.85	38.35	37.85	37.96	9921202.0
2016-07-14	AAC-DELISTED	Stock	22.71	23.09	22.7	22.93	50793.0
2016-07-14	AACG	Stock	4.29	4.34	4.01	4.34	7200.0
2016-07-14	AAIC-DELISTED	Stock	13.34	13.34	13.18	13.23	177445.0
2016-07-14	AAL	Stock	35.11	36.19	35.0	35.88	16884400.0
2016-07-14	AAMC-DELISTED	Stock	4.1088	4.1824	3.9265	3.9794	98532.0
2016-07-14	AAME	Stock	4.0	4.25	4.0	4.2	1100.0
2016-07-14	AAMI	Stock	13.81	14.01	13.81	13.91	118200.0
2016-07-14	AAOI	Stock	11.71	11.785	11.451	11.56	217000.0
2016-07-14	AAON	Stock	19.1333	19.1333	18.6067	18.66	114300.0
2016-07-14	AAP	Stock	163.46	165.46	162.44	164.96	575300.0
2016-07-14	AAT	Stock	44.52	44.65	44.2	44.57	299700.0
2016-07-14	AAU-DELISTED	Stock	1.5	1.59	1.45	1.54	626511.0
2016-07-14	AAUAF-DELISTED	Stock	1.5	1.59	1.45	1.54	629906.0
2016-07-14	AAV-DELISTED	Stock	5.85	6.13	5.85	6.1	118194.0
2016-07-14	AAWW-DELISTED	Stock	43.26	43.41	42.95	43.08	117465.0
2016-07-14	AAXJ	Stock	56.68	56.95	56.58	56.8	557057.0
2016-07-14	AAXN-DELISTED	Stock	27.17	27.74	27.1	27.65	1025580.0
2016-07-14	AB	Stock	23.66	23.86	23.29	23.41	181200.0
2016-07-14	ABAC-DELISTED	Stock	0.8	0.8	0.8	0.8	200.0
2016-07-14	ABAX-DELISTED	Stock	53.64	53.7	52.8	53.22	94790.0
2016-07-14	ABB-DELISTED	Stock	20.0	20.09	19.91	19.95	2549132.0
2016-07-14	ABBNY-DELISTED	Stock	20.0	20.09	19.91	19.95	3024571.0
2016-07-14	ABBV	Stock	63.7	64.14	62.94	63.62	12090100.0
2016-07-14	ABC-DELISTED	Stock	85.35	86.12	85.255	85.95	1835951.0
2016-07-14	ABCB	Stock	30.9	30.92	30.55	30.86	144300.0
2016-07-14	ABCD-DELISTED	Stock	4.89	4.91	4.86	4.88	4619.0
2016-07-14	ABCO-DELISTED	Stock	39.78	40.32	39.02	39.65	222947.0
2016-07-14	ABDC-DELISTED	Stock	12.31	12.42	12.15	12.15	41064.0
2016-07-14	ABE-DELISTED	Stock	12.63	12.64	12.58	12.63	838.0
2016-07-14	ABEO	Stock	61.0	61.0	57.75	59.25	4656.0
2016-07-14	ABEV	Stock	5.88	5.92	5.82	5.88	12178800.0
2016-07-14	ABG	Stock	57.01	58.09	57.01	57.64	124900.0
2016-07-14	ABIL-DELISTED	Stock	4.43	4.69	4.42	4.54	27715.0
2016-07-14	ABM	Stock	37.37	37.47	36.93	37.04	217900.0
2016-07-14	ABMD-DELISTED	Stock	118.39	118.69	116.935	117.8	414297.0
2016-07-14	ABR	Stock	7.25	7.3	7.19	7.29	100800.0

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

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