PREVIEW / stock_daily / 2016-06-20

all stock daily files

  file:    by_date/stock_daily/2016/2016-06-20.parquet
  size:    219 KB
  rows:    6,564
  symbols: 3,277

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-06-20	AAPL	Stock	24.0	24.1425	23.7575	23.775	137647600.0
2016-06-20	MSFT	Stock	50.64	50.83	50.03	50.07	35607900.0
2016-06-20	NVDA	Stock	1.1868	1.2042	1.186	1.189	293768000.0
2016-06-20	AMZN	Stock	35.675	36.0655	35.5405	35.7005	73544000.0
2016-06-20	GOOGL	Stock	35.5155	35.7935	35.2705	35.3065	45654500.0
2016-06-20	META	Stock	113.77	114.72	112.75	113.37	20785400.0
2016-06-20	TSLA	Stock	14.6333	14.9167	14.5487	14.6467	53332500.0
2016-06-20	TLT	Stock	134.24	134.55	134.01	134.16	7365885.0
2016-06-20	ES	Stock	56.85	57.04	56.32	56.82	1425000.0
2016-06-20	CL	Stock	71.9	72.4	71.61	71.64	2557400.0
2016-06-20	A	Stock	45.57	46.35	45.57	46.14	3161300.0
2016-06-20	AA.B-DELISTED	Stock	33.62	34.44	33.62	33.9799	32898.0
2016-06-20	AAAP-DELISTED	Stock	28.94	29.83	27.94	28.73	37454.0
2016-06-20	AABA-DELISTED	Stock	37.27	37.68	37.24	37.29	8411311.0
2016-06-20	AAC-DELISTED	Stock	19.7	20.02	19.53	19.55	70744.0
2016-06-20	AACG	Stock	5.08	5.08	4.85	4.99	2900.0
2016-06-20	AAIC-DELISTED	Stock	13.59	13.78	13.527	13.65	258643.0
2016-06-20	AAL	Stock	29.75	30.39	29.64	29.71	8359300.0
2016-06-20	AAMC-DELISTED	Stock	5.4882	5.6706	5.1794	5.1794	73824.0
2016-06-20	AAME	Stock	3.84	3.96	3.84	3.91	1000.0
2016-06-20	AAMI	Stock	14.49	14.57	14.21	14.21	255000.0
2016-06-20	AAOI	Stock	10.28	10.67	10.17	10.2	327700.0
2016-06-20	AAON	Stock	17.4733	17.7	17.4267	17.48	187200.0
2016-06-20	AAP	Stock	155.74	157.27	155.34	155.58	704900.0
2016-06-20	AAT	Stock	40.74	41.26	40.67	40.7	112700.0
2016-06-20	AAU-DELISTED	Stock	1.2	1.26	1.15	1.26	555169.0
2016-06-20	AAUAF-DELISTED	Stock	1.2	1.26	1.15	1.25	562947.0
2016-06-20	AAV-DELISTED	Stock	5.69	5.82	5.62	5.71	84147.0
2016-06-20	AAWW-DELISTED	Stock	44.01	45.21	44.0	44.05	191909.0
2016-06-20	AAXJ	Stock	53.9	54.17	53.79	53.84	415351.0
2016-06-20	AAXN-DELISTED	Stock	23.16	23.59	22.93	23.34	581474.0
2016-06-20	AB	Stock	23.23	23.68	23.04	23.05	195100.0
2016-06-20	ABAC-DELISTED	Stock	0.79	0.8	0.76	0.79	11516.0
2016-06-20	ABAX-DELISTED	Stock	45.31	46.3399	44.82	45.36	88105.0
2016-06-20	ABB-DELISTED	Stock	20.98	21.08	20.92	20.945	1019996.0
2016-06-20	ABBNY-DELISTED	Stock	20.98	21.08	20.92	20.95	1066492.0
2016-06-20	ABBV	Stock	60.64	61.18	60.06	60.11	7076500.0
2016-06-20	ABC-DELISTED	Stock	76.25	77.22	76.13	76.37	2270269.0
2016-06-20	ABCB	Stock	29.66	30.01	29.42	29.47	137900.0
2016-06-20	ABCD-DELISTED	Stock	4.64	4.7	4.63	4.63	19691.0
2016-06-20	ABCO-DELISTED	Stock	34.63	35.52	34.37	35.22	310792.0
2016-06-20	ABDC-DELISTED	Stock	12.2	12.5	12.1385	12.25	80742.0
2016-06-20	ABE-DELISTED	Stock	12.0	12.0589	11.98	11.98	5944.0
2016-06-20	ABEO	Stock	73.0	73.5	69.5	70.0	2560.0
2016-06-20	ABEV	Stock	5.48	5.56	5.41	5.45	10098400.0
2016-06-20	ABG	Stock	56.73	58.97	56.73	57.86	263400.0
2016-06-20	ABIL-DELISTED	Stock	4.13	4.3799	4.06	4.28	41684.0
2016-06-20	ABM	Stock	36.68	36.91	36.24	36.28	615000.0
2016-06-20	ABMD-DELISTED	Stock	100.0	102.84	99.61	101.7	538347.0
2016-06-20	ABR	Stock	6.84	6.94	6.84	6.84	65600.0

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

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