PREVIEW / stock_daily / 2016-06-21

all stock daily files

  file:    by_date/stock_daily/2016/2016-06-21.parquet
  size:    218 KB
  rows:    6,542
  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-21	AAPL	Stock	23.735	24.0875	23.67	23.9775	142185600.0
2016-06-21	MSFT	Stock	50.2	51.43	50.16	51.19	34097800.0
2016-06-21	NVDA	Stock	1.194	1.1973	1.18	1.1818	212508000.0
2016-06-21	AMZN	Stock	35.786	35.92	35.636	35.791	42750000.0
2016-06-21	GOOGL	Stock	35.5025	35.769	35.233	35.444	30318360.0
2016-06-21	META	Stock	114.12	115.21	113.97	114.38	19166300.0
2016-06-21	TSLA	Stock	14.712	14.838	14.5873	14.6407	67935000.0
2016-06-21	TLT	Stock	134.29	134.58	133.46	133.54	6005848.0
2016-06-21	ES	Stock	56.81	57.35	56.53	57.03	1205800.0
2016-06-21	CL	Stock	72.03	72.14	71.73	71.8	3072000.0
2016-06-21	A	Stock	46.21	46.33	45.76	46.16	2112900.0
2016-06-21	AA.B-DELISTED	Stock	34.24	34.41	33.63	34.34	14961.0
2016-06-21	AAAP-DELISTED	Stock	28.45	28.85	27.745	28.11	65541.0
2016-06-21	AABA-DELISTED	Stock	37.37	37.55	37.2	37.405	4997437.0
2016-06-21	AAC-DELISTED	Stock	19.52	19.73	19.09	19.62	94699.0
2016-06-21	AACG	Stock	5.34	5.34	5.34	5.34	500.0
2016-06-21	AAIC-DELISTED	Stock	13.65	13.735	13.45	13.66	197951.0
2016-06-21	AAL	Stock	30.29	30.39	29.69	30.02	8922900.0
2016-06-21	AAMC-DELISTED	Stock	5.1824	5.2941	4.9971	5.0	50942.0
2016-06-21	AAME	Stock	3.91	3.93	3.87	3.93	900.0
2016-06-21	AAMI	Stock	14.33	14.7	14.12	14.46	237200.0
2016-06-21	AAOI	Stock	10.25	10.265	9.92	10.1	152400.0
2016-06-21	AAON	Stock	17.5067	17.6733	17.2733	17.3533	139950.0
2016-06-21	AAP	Stock	155.56	156.31	153.89	154.44	806800.0
2016-06-21	AAT	Stock	40.77	41.1	40.62	40.92	76700.0
2016-06-21	AAU-DELISTED	Stock	1.25	1.26	1.2	1.21	278155.0
2016-06-21	AAUAF-DELISTED	Stock	1.25	1.26	1.2	1.21	280569.0
2016-06-21	AAV-DELISTED	Stock	5.68	5.7	5.6	5.64	39327.0
2016-06-21	AAWW-DELISTED	Stock	44.22	44.22	42.75	43.27	140804.0
2016-06-21	AAXJ	Stock	54.01	54.33	53.84	54.15	630672.0
2016-06-21	AAXN-DELISTED	Stock	23.3	23.4	22.965	23.11	293178.0
2016-06-21	AB	Stock	23.06	23.26	22.83	22.96	163100.0
2016-06-21	ABAC-DELISTED	Stock	0.8	0.8	0.751	0.78	1440.0
2016-06-21	ABAX-DELISTED	Stock	45.5674	46.2	45.32	45.99	72307.0
2016-06-21	ABB-DELISTED	Stock	21.2	21.36	21.07	21.28	1568006.0
2016-06-21	ABBNY-DELISTED	Stock	21.2	21.36	21.07	21.29	1651108.0
2016-06-21	ABBV	Stock	60.2	60.4	59.75	59.98	6366500.0
2016-06-21	ABC-DELISTED	Stock	76.49	76.7805	76.05	76.55	1075332.0
2016-06-21	ABCB	Stock	29.47	29.54	29.1	29.42	147500.0
2016-06-21	ABCD-DELISTED	Stock	4.63	4.66	4.57	4.595	9105.0
2016-06-21	ABCO-DELISTED	Stock	35.14	35.53	34.78	35.16	275319.0
2016-06-21	ABDC-DELISTED	Stock	12.25	12.3	12.06	12.13	24331.0
2016-06-21	ABE-DELISTED	Stock	12.0	12.069	11.97	11.998	3521.0
2016-06-21	ABEO	Stock	69.5	71.5	64.5	69.0	2764.0
2016-06-21	ABEV	Stock	5.5	5.51	5.41	5.43	8490800.0
2016-06-21	ABG	Stock	57.37	57.88	54.77	54.82	335200.0
2016-06-21	ABIL-DELISTED	Stock	4.3	4.43	4.21	4.33	22605.0
2016-06-21	ABM	Stock	36.32	36.7	36.08	36.54	257700.0
2016-06-21	ABMD-DELISTED	Stock	101.57	103.1441	100.5101	101.75	411003.0
2016-06-21	ABR	Stock	6.86	6.86	6.78	6.79	83500.0

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

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