PREVIEW / stock_daily / 2016-07-15

all stock daily files

  file:    by_date/stock_daily/2016/2016-07-15.parquet
  size:    219 KB
  rows:    6,552
  symbols: 3,265

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-07-15	AAPL	Stock	24.73	24.825	24.625	24.695	120548000.0
2016-07-15	MSFT	Stock	53.95	54.0	53.21	53.7	32024400.0
2016-07-15	NVDA	Stock	1.316	1.3235	1.296	1.3175	428616000.0
2016-07-15	AMZN	Stock	37.3275	37.3275	36.7025	36.772	62428000.0
2016-07-15	GOOGL	Stock	37.05	37.05	36.732	36.7815	32341740.0
2016-07-15	META	Stock	117.74	118.28	116.58	116.86	16646000.0
2016-07-15	TSLA	Stock	14.8347	14.85	14.6427	14.6933	33513000.0
2016-07-15	TLT	Stock	138.89	139.11	138.18	138.39	9958624.0
2016-07-15	ES	Stock	57.81	58.13	57.69	57.87	1560900.0
2016-07-15	CL	Stock	74.94	75.29	74.5	74.72	4633500.0
2016-07-15	A	Stock	46.96	46.96	46.55	46.67	1202100.0
2016-07-15	AA.B-DELISTED	Stock	36.9	37.32	36.61	37.32	86439.0
2016-07-15	AAAP-DELISTED	Stock	30.88	30.88	30.54	30.71	12898.0
2016-07-15	AABA-DELISTED	Stock	38.09	38.185	37.68	37.71	12646756.0
2016-07-15	AAC-DELISTED	Stock	23.04	23.0999	22.5001	22.96	52099.0
2016-07-15	AACG	Stock	4.27	4.39	4.04	4.3	6100.0
2016-07-15	AAIC-DELISTED	Stock	13.28	13.29	13.16	13.26	127967.0
2016-07-15	AAL	Stock	35.51	36.06	35.32	35.89	9817100.0
2016-07-15	AAMC-DELISTED	Stock	4.0588	4.3735	3.9382	4.0294	81410.0
2016-07-15	AAMI	Stock	14.01	14.18	13.78	14.16	102500.0
2016-07-15	AAOI	Stock	11.65	11.88	11.384	11.76	214500.0
2016-07-15	AAON	Stock	18.8067	18.96	18.64	18.74	165300.0
2016-07-15	AAP	Stock	165.45	165.79	164.39	164.59	677100.0
2016-07-15	AAT	Stock	44.73	44.85	44.2	44.72	309600.0
2016-07-15	AAU-DELISTED	Stock	1.5	1.57	1.43	1.45	538780.0
2016-07-15	AAUAF-DELISTED	Stock	1.5	1.57	1.43	1.45	544755.0
2016-07-15	AAV-DELISTED	Stock	6.13	6.334	6.08	6.29	165656.0
2016-07-15	AAWW-DELISTED	Stock	43.31	43.45	42.73	43.19	105932.0
2016-07-15	AAXJ	Stock	56.91	56.91	56.58	56.72	554756.0
2016-07-15	AAXN-DELISTED	Stock	27.71	27.855	27.12	27.22	607609.0
2016-07-15	AB	Stock	23.5	23.96	23.27	23.66	167800.0
2016-07-15	ABAC-DELISTED	Stock	0.8134	0.8134	0.7751	0.8	4228.0
2016-07-15	ABAX-DELISTED	Stock	53.57	54.14	52.75	53.85	140933.0
2016-07-15	ABB-DELISTED	Stock	19.95	20.02	19.87	20.0	1551588.0
2016-07-15	ABBNY-DELISTED	Stock	19.95	20.02	19.87	20.0	1588569.0
2016-07-15	ABBV	Stock	63.82	64.17	63.13	63.32	8827500.0
2016-07-15	ABC-DELISTED	Stock	86.26	86.52	84.92	85.51	2030682.0
2016-07-15	ABCB	Stock	31.03	31.32	30.8	31.21	176700.0
2016-07-15	ABCD-DELISTED	Stock	4.91	4.95	4.87	4.94	9693.0
2016-07-15	ABCO-DELISTED	Stock	39.94	40.1	39.15	39.25	117240.0
2016-07-15	ABDC-DELISTED	Stock	12.1	12.3	12.1	12.11	36622.0
2016-07-15	ABE-DELISTED	Stock	12.51	12.6	12.51	12.54	9500.0
2016-07-15	ABEO	Stock	58.25	61.25	58.25	60.5	2116.0
2016-07-15	ABEV	Stock	5.82	5.83	5.73	5.78	7816600.0
2016-07-15	ABG	Stock	57.82	57.82	57.29	57.51	231500.0
2016-07-15	ABIL-DELISTED	Stock	4.6	4.66	4.52	4.53	13281.0
2016-07-15	ABM	Stock	37.16	37.26	36.77	37.25	264000.0
2016-07-15	ABMD-DELISTED	Stock	117.92	118.55	116.6	117.17	254648.0
2016-07-15	ABR	Stock	7.25	7.28	7.19	7.2	94100.0
2016-07-15	ABR.A-DELISTED	Stock	25.4	25.77	25.4	25.77	2128.0

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

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