PREVIEW / stock_daily / 2017-05-12

all stock daily files

  file:    by_date/stock_daily/2017/2017-05-12.parquet
  size:    215 KB
  rows:    6,438
  symbols: 3,013

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
2017-05-12	AAPL	Stock	38.675	39.105	38.6675	39.025	130108000.0
2017-05-12	MSFT	Stock	68.61	68.61	68.04	68.38	18714100.0
2017-05-12	NVDA	Stock	3.1658	3.24	3.1445	3.1973	962620000.0
2017-05-12	AMZN	Stock	47.725	48.1395	47.5765	48.0675	72518000.0
2017-05-12	GOOGL	Stock	47.8925	47.899	47.603	47.757	24297020.0
2017-05-12	META	Stock	150.4	150.46	149.63	150.33	9598200.0
2017-05-12	TSLA	Stock	21.6987	21.8	21.4353	21.654	61824000.0
2017-05-12	TLT	Stock	121.01	121.49	120.98	121.39	7464184.0
2017-05-12	ES	Stock	59.44	59.97	59.44	59.88	806000.0
2017-05-12	CL	Stock	71.6	71.67	71.18	71.25	1972800.0
2017-05-12	A	Stock	56.16	56.4	55.96	56.16	1578300.0
2017-05-12	AA	Stock	31.0	32.13	30.96	31.79	3380800.0
2017-05-12	AAAP-DELISTED	Stock	36.51	36.92	36.03	36.03	51369.0
2017-05-12	AABA-DELISTED	Stock	49.68	49.75	49.44	49.65	5278734.0
2017-05-12	AAC-DELISTED	Stock	7.47	7.4717	7.15	7.18	55039.0
2017-05-12	AACG	Stock	3.53	3.73	3.53	3.56	65900.0
2017-05-12	AAIC-DELISTED	Stock	14.18	14.21	14.1	14.15	214321.0
2017-05-12	AAL	Stock	46.26	46.44	45.73	45.83	3888700.0
2017-05-12	AAM.A-DELISTED	Stock	25.81	25.83	25.7301	25.8	36752.0
2017-05-12	AAMC-DELISTED	Stock	20.6029	21.0882	20.6029	20.6324	5324.0
2017-05-12	AAME	Stock	3.65	3.65	3.55	3.55	500.0
2017-05-12	AAMI	Stock	15.17	15.23	15.015	15.03	111300.0
2017-05-12	AAOI	Stock	64.24	67.01	63.215	65.45	3004300.0
2017-05-12	AAON	Stock	24.4	24.5333	24.2	24.2	136500.0
2017-05-12	AAP	Stock	145.76	145.76	144.39	145.02	593200.0
2017-05-12	AAT	Stock	39.58	39.63	39.31	39.38	305300.0
2017-05-12	AAU-DELISTED	Stock	1.34	1.435	1.31	1.41	465920.0
2017-05-12	AAUAF-DELISTED	Stock	1.34	1.435	1.31	1.42	480016.0
2017-05-12	AAV-DELISTED	Stock	6.5	6.58	6.4	6.425	149305.0
2017-05-12	AAWW-DELISTED	Stock	50.9	51.4	49.55	49.55	172978.0
2017-05-12	AAXJ	Stock	65.79	65.98	65.72	65.94	399490.0
2017-05-12	AAXN-DELISTED	Stock	26.0	26.3	25.96	25.96	787624.0
2017-05-12	AB	Stock	21.25	21.3	20.9	21.15	481400.0
2017-05-12	ABAC-DELISTED	Stock	1.8	1.8	1.72	1.76	4580.0
2017-05-12	ABAX-DELISTED	Stock	48.6	48.95	47.31	47.35	92009.0
2017-05-12	ABB-DELISTED	Stock	24.51	24.76	24.51	24.74	2367301.0
2017-05-12	ABBNY-DELISTED	Stock	24.51	24.76	24.51	24.75	2412433.0
2017-05-12	ABBV	Stock	65.27	66.19	65.21	66.06	6093500.0
2017-05-12	ABC-DELISTED	Stock	88.61	88.97	88.44	88.75	1057490.0
2017-05-12	ABCB	Stock	44.9	45.0	44.05	44.65	219700.0
2017-05-12	ABCD-DELISTED	Stock	5.27	5.29	5.18	5.18	10670.0
2017-05-12	ABCO-DELISTED	Stock	51.25	51.8	50.9	51.45	296922.0
2017-05-12	ABDC-DELISTED	Stock	14.42	14.5	13.52	14.34	37784.0
2017-05-12	ABE-DELISTED	Stock	13.87	13.89	13.83	13.89	2397.0
2017-05-12	ABEO	Stock	160.0	163.5	150.0	156.25	34400.0
2017-05-12	ABEOW-DELISTED	Stock	3.235	3.41	3.2	3.41	4422.0
2017-05-12	ABEV	Stock	6.23	6.3	6.18	6.26	32910300.0
2017-05-12	ABG	Stock	56.2	56.55	55.5	56.2	203300.0
2017-05-12	ABIL-DELISTED	Stock	0.75	0.83	0.7001	0.701	16399.0
2017-05-12	ABM	Stock	42.48	42.53	41.92	42.24	185400.0

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

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