PREVIEW / stock_daily / 2016-09-01

all stock daily files

  file:    by_date/stock_daily/2016/2016-09-01.parquet
  size:    218 KB
  rows:    6,512
  symbols: 3,209

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-09-01	AAPL	Stock	26.535	26.7	26.405	26.6825	106806000.0
2016-09-01	MSFT	Stock	57.01	57.82	57.01	57.59	26075400.0
2016-09-01	NVDA	Stock	1.5348	1.5845	1.5335	1.5788	428492000.0
2016-09-01	AMZN	Stock	38.545	38.602	38.3375	38.531	35846000.0
2016-09-01	GOOGL	Stock	39.599	39.6445	39.3165	39.57	26069200.0
2016-09-01	META	Stock	126.38	126.63	125.6	126.17	13536100.0
2016-09-01	TSLA	Stock	13.934	14.0733	13.3667	13.3847	119146500.0
2016-09-01	TLT	Stock	138.62	140.1	138.57	139.77	9149133.0
2016-09-01	ES	Stock	53.96	54.0	53.49	53.59	1134100.0
2016-09-01	CL	Stock	74.38	74.43	73.87	74.27	3016300.0
2016-09-01	A	Stock	47.03	47.22	46.81	46.99	1257900.0
2016-09-01	AA.B-DELISTED	Stock	34.41	34.65	34.27	34.4	67960.0
2016-09-01	AAAP-DELISTED	Stock	34.32	34.8	34.0	34.36	37085.0
2016-09-01	AABA-DELISTED	Stock	42.78	43.095	42.72	42.92	5186020.0
2016-09-01	AAC-DELISTED	Stock	19.6	19.62	19.06	19.24	166193.0
2016-09-01	AACG	Stock	4.56	4.56	4.25	4.25	2700.0
2016-09-01	AAIC-DELISTED	Stock	14.9	14.96	14.58	14.84	148804.0
2016-09-01	AAL	Stock	36.53	36.71	35.88	36.24	6940600.0
2016-09-01	AAMC-DELISTED	Stock	4.1338	4.3794	4.1118	4.25	49970.0
2016-09-01	AAME	Stock	3.65	3.66	3.62	3.66	3700.0
2016-09-01	AAMI	Stock	13.55	13.66	13.2	13.42	236700.0
2016-09-01	AAOI	Stock	16.94	17.45	16.64	17.14	259900.0
2016-09-01	AAON	Stock	18.8067	19.1067	18.6667	19.08	167250.0
2016-09-01	AAP	Stock	158.2	159.62	157.75	158.76	721400.0
2016-09-01	AAT	Stock	44.17	44.35	43.88	44.04	88500.0
2016-09-01	AAU-DELISTED	Stock	1.31	1.38	1.3	1.35	344686.0
2016-09-01	AAUAF-DELISTED	Stock	1.31	1.38	1.3	1.35	349487.0
2016-09-01	AAV-DELISTED	Stock	6.75	6.89	6.75	6.855	51845.0
2016-09-01	AAWW-DELISTED	Stock	37.15	38.14	37.005	38.13	391393.0
2016-09-01	AAXJ	Stock	58.95	59.06	58.69	59.04	645357.0
2016-09-01	AAXN-DELISTED	Stock	27.21	27.58	26.45	26.86	1070478.0
2016-09-01	AB	Stock	21.96	22.06	21.57	21.59	219200.0
2016-09-01	ABAC-DELISTED	Stock	0.74	0.7683	0.69	0.7301	34229.0
2016-09-01	ABAX-DELISTED	Stock	50.37	50.74	49.96	50.4	88660.0
2016-09-01	ABB-DELISTED	Stock	21.64	22.1	21.59	22.06	2749570.0
2016-09-01	ABBNY-DELISTED	Stock	21.64	22.1	21.59	22.07	2812286.0
2016-09-01	ABBV	Stock	64.1	64.14	63.61	64.03	5126700.0
2016-09-01	ABC-DELISTED	Stock	87.01	87.72	86.58	87.16	1087184.0
2016-09-01	ABCB	Stock	35.0	35.07	34.56	34.99	231200.0
2016-09-01	ABCD-DELISTED	Stock	4.78	4.78	4.6	4.68	16295.0
2016-09-01	ABCO-DELISTED	Stock	42.2	42.45	41.81	42.19	187492.0
2016-09-01	ABDC-DELISTED	Stock	12.64	12.64	12.5	12.6	26207.0
2016-09-01	ABE-DELISTED	Stock	12.52	12.52	12.52	12.52	200.0
2016-09-01	ABEO	Stock	107.5	108.25	102.5	107.25	4332.0
2016-09-01	ABEV	Stock	5.86	6.09	5.86	6.09	29564700.0
2016-09-01	ABG	Stock	53.7	54.99	53.7	54.27	239900.0
2016-09-01	ABIL-DELISTED	Stock	4.46	4.6	4.4	4.49	21496.0
2016-09-01	ABM	Stock	38.29	38.66	38.08	38.66	148200.0
2016-09-01	ABMD-DELISTED	Stock	117.98	118.57	117.05	117.62	256099.0
2016-09-01	ABR	Stock	7.85	7.85	7.72	7.72	71200.0

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

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