PREVIEW / stock_daily / 2016-03-01

all stock daily files

  file:    by_date/stock_daily/2016/2016-03-01.parquet
  size:    218 KB
  rows:    6,573
  symbols: 3,347

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-03-01	AAPL	Stock	24.4125	25.1925	24.355	25.1325	201628400.0
2016-03-01	MSFT	Stock	50.97	52.59	50.92	52.58	33024500.0
2016-03-01	NVDA	Stock	0.786	0.8188	0.7848	0.8188	348700000.0
2016-03-01	AMZN	Stock	27.8145	28.9625	27.8	28.952	100770000.0
2016-03-01	GOOGL	Stock	36.065	37.1165	35.932	37.1085	60111060.0
2016-03-01	META	Stock	107.83	109.82	107.6	109.82	26817300.0
2016-03-01	TSLA	Stock	12.95	13.0633	12.18	12.4233	100683000.0
2016-03-01	TLT	Stock	130.82	130.85	128.32	128.43	13729116.0
2016-03-01	ES	Stock	54.5	54.87	53.8	54.23	2106500.0
2016-03-01	CL	Stock	66.06	67.39	65.93	67.33	3629600.0
2016-03-01	A	Stock	37.63	38.66	37.61	38.59	2759500.0
2016-03-01	AA.B-DELISTED	Stock	30.6	31.39	30.54	31.1	56735.0
2016-03-01	AAAP-DELISTED	Stock	33.15	33.65	31.88	32.8995	41458.0
2016-03-01	AABA-DELISTED	Stock	32.04	32.85	32.04	32.8	13498971.0
2016-03-01	AAC-DELISTED	Stock	20.4	20.92	20.24	20.35	91428.0
2016-03-01	AACG	Stock	5.06	5.12	4.55	4.83	14700.0
2016-03-01	AAIC-DELISTED	Stock	12.25	12.43	12.04	12.43	214715.0
2016-03-01	AAL	Stock	41.44	42.02	41.06	41.83	7885800.0
2016-03-01	AAMC-DELISTED	Stock	5.0088	5.2412	4.7118	5.0882	26452.0
2016-03-01	AAME	Stock	4.18	4.18	4.18	4.18	400.0
2016-03-01	AAMI	Stock	11.51	11.91	11.42	11.87	115100.0
2016-03-01	AAOI	Stock	18.17	18.42	17.7	18.33	267200.0
2016-03-01	AAON	Stock	16.7733	17.42	16.7733	17.0067	306150.0
2016-03-01	AAP	Stock	149.92	153.54	149.29	153.35	622100.0
2016-03-01	AAT	Stock	37.32	37.59	37.27	37.58	175700.0
2016-03-01	AAU-DELISTED	Stock	0.7405	0.76	0.641	0.709	411476.0
2016-03-01	AAUAF-DELISTED	Stock	0.7405	0.76	0.641	0.709	412362.0
2016-03-01	AAV-DELISTED	Stock	5.12	5.126	5.03	5.12	219967.0
2016-03-01	AAVL-DELISTED	Stock	5.16	5.46	4.96	5.44	304811.0
2016-03-01	AAWW-DELISTED	Stock	36.46	37.865	36.38	37.39	377429.0
2016-03-01	AAXJ	Stock	50.18	50.9	50.11	50.85	776798.0
2016-03-01	AAXN-DELISTED	Stock	19.11	19.57	18.52	19.44	2494223.0
2016-03-01	AB	Stock	19.99	20.43	19.99	20.17	449300.0
2016-03-01	ABAC-DELISTED	Stock	0.6	0.63	0.5998	0.62	19050.0
2016-03-01	ABAX-DELISTED	Stock	39.49	39.49	37.85	39.02	354652.0
2016-03-01	ABB-DELISTED	Stock	17.97	18.22	17.92	18.21	1274993.0
2016-03-01	ABBNY-DELISTED	Stock	17.97	18.22	17.92	18.2	1371627.0
2016-03-01	ABBV	Stock	54.78	56.34	54.24	56.34	7106000.0
2016-03-01	ABC-DELISTED	Stock	86.8	87.73	86.47	87.43	1628308.0
2016-03-01	ABCB	Stock	27.25	27.77	27.18	27.59	150700.0
2016-03-01	ABCD-DELISTED	Stock	4.4	4.443	4.3	4.44	17894.0
2016-03-01	ABCO-DELISTED	Stock	29.49	30.04	28.675	29.84	572256.0
2016-03-01	ABCW-DELISTED	Stock	42.22	42.58	41.89	42.3501	115531.0
2016-03-01	ABDC-DELISTED	Stock	10.41	10.54	10.16	10.18	27309.0
2016-03-01	ABE-DELISTED	Stock	10.66	10.7301	10.66	10.7301	3501.0
2016-03-01	ABEO	Stock	57.5	57.5	51.25	52.5	5392.0
2016-03-01	ABEV	Stock	4.39	4.63	4.39	4.62	21734600.0
2016-03-01	ABG	Stock	59.02	59.77	58.05	59.11	535800.0
2016-03-01	ABGB-DELISTED	Stock	0.7	0.75	0.7	0.725	7339.0
2016-03-01	ABIL-DELISTED	Stock	7.18	7.45	7.11	7.2	30474.0

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

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