PREVIEW / stock_daily / 2016-11-21

all stock daily files

  file:    by_date/stock_daily/2016/2016-11-21.parquet
  size:    216 KB
  rows:    6,530
  symbols: 3,165

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-11-21	AAPL	Stock	27.53	27.9975	27.5025	27.9325	117058400.0
2016-11-21	MSFT	Stock	60.5	60.97	60.42	60.86	19652600.0
2016-11-21	NVDA	Stock	2.3522	2.3588	2.31	2.3245	436436000.0
2016-11-21	AMZN	Stock	38.3	39.0175	38.2555	39.0	92292000.0
2016-11-21	GOOGL	Stock	38.905	39.3275	38.815	39.24	32616700.0
2016-11-21	META	Stock	118.2	121.95	117.8	121.77	35415400.0
2016-11-21	TSLA	Stock	12.336	12.5927	12.294	12.3013	65415000.0
2016-11-21	TLT	Stock	121.21	121.475	120.89	121.15	6488066.0
2016-11-21	ES	Stock	51.94	52.37	51.94	52.2	1440100.0
2016-11-21	CL	Stock	65.86	66.38	65.82	66.22	3494600.0
2016-11-21	A	Stock	45.22	45.24	44.65	44.97	2540100.0
2016-11-21	AA	Stock	30.89	30.98	29.501	30.69	2986000.0
2016-11-21	AAAP-DELISTED	Stock	35.7	36.09	35.69	35.95	48167.0
2016-11-21	AABA-DELISTED	Stock	41.44	41.48	40.94	41.11	10794554.0
2016-11-21	AAC-DELISTED	Stock	10.23	10.23	9.09	9.24	270746.0
2016-11-21	AACG	Stock	4.13	4.14	3.9	3.93	3000.0
2016-11-21	AAIC-DELISTED	Stock	15.95	15.97	15.76	15.89	212162.0
2016-11-21	AAL	Stock	46.46	46.75	45.95	46.08	6651400.0
2016-11-21	AAMC-DELISTED	Stock	8.5147	8.5147	8.0882	8.1176	28376.0
2016-11-21	AAME	Stock	4.0	4.0	4.0	4.0	600.0
2016-11-21	AAMI	Stock	14.76	14.88	14.66	14.81	431200.0
2016-11-21	AAOI	Stock	26.9	27.28	25.54	26.21	301500.0
2016-11-21	AAON	Stock	21.9333	22.1	21.7333	21.9333	235350.0
2016-11-21	AAP	Stock	162.75	167.39	162.0	166.9	764100.0
2016-11-21	AAT	Stock	40.23	40.47	39.86	39.95	180800.0
2016-11-21	AAU-DELISTED	Stock	1.08	1.13	1.08	1.1199	193231.0
2016-11-21	AAUAF-DELISTED	Stock	1.08	1.13	1.08	1.1199	195148.0
2016-11-21	AAV-DELISTED	Stock	6.9	7.1	6.9	6.95	86552.0
2016-11-21	AAWW-DELISTED	Stock	50.4	51.35	50.15	50.6	130327.0
2016-11-21	AAXJ	Stock	55.88	56.08	55.78	55.91	568004.0
2016-11-21	AAXN-DELISTED	Stock	27.78	28.0	27.021	27.32	979442.0
2016-11-21	AB	Stock	23.3	23.5	23.05	23.5	214400.0
2016-11-21	ABAC-DELISTED	Stock	2.77	2.77	2.55	2.71	23637.0
2016-11-21	ABAX-DELISTED	Stock	52.14	52.81	51.77	52.23	78856.0
2016-11-21	ABB-DELISTED	Stock	20.66	20.75	20.625	20.68	1638785.0
2016-11-21	ABBNY-DELISTED	Stock	20.66	20.75	20.625	20.68	1699854.0
2016-11-21	ABBV	Stock	60.7	60.8	60.2	60.42	6328300.0
2016-11-21	ABC-DELISTED	Stock	78.62	79.34	77.84	78.46	2311993.0
2016-11-21	ABCB	Stock	42.45	43.05	42.1	43.0	122600.0
2016-11-21	ABCD-DELISTED	Stock	5.13	5.13	4.94	5.04	26992.0
2016-11-21	ABCO-DELISTED	Stock	35.95	37.05	35.55	37.025	311907.0
2016-11-21	ABDC-DELISTED	Stock	11.85	12.03	11.565	11.92	57497.0
2016-11-21	ABE-DELISTED	Stock	11.297	11.297	11.297	11.297	189.0
2016-11-21	ABEO	Stock	182.5	185.0	178.75	181.25	7128.0
2016-11-21	ABEOW-DELISTED	Stock	3.75	3.76	3.59	3.76	2840.0
2016-11-21	ABEV	Stock	5.13	5.19	5.12	5.18	10762700.0
2016-11-21	ABG	Stock	58.95	59.7	58.5	58.9	230500.0
2016-11-21	ABIL-DELISTED	Stock	3.05	3.5196	3.04	3.33	30661.0
2016-11-21	ABM	Stock	44.1	44.52	43.72	44.33	251700.0
2016-11-21	ABMD-DELISTED	Stock	113.12	116.11	112.92	115.81	512318.0

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

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