PREVIEW / stock_daily / 2017-05-08

all stock daily files

  file:    by_date/stock_daily/2017/2017-05-08.parquet
  size:    214 KB
  rows:    6,456
  symbols: 3,019

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-08	AAPL	Stock	37.2575	38.425	37.2575	38.2525	195009600.0
2017-05-08	MSFT	Stock	68.97	69.05	68.42	68.94	18566100.0
2017-05-08	NVDA	Stock	2.6085	2.61	2.5578	2.5693	365240000.0
2017-05-08	AMZN	Stock	47.0475	47.4525	46.9605	47.452	68314000.0
2017-05-08	GOOGL	Stock	47.3725	48.0495	47.3698	47.9345	37533800.0
2017-05-08	META	Stock	150.71	151.08	149.74	151.06	15827500.0
2017-05-08	TSLA	Stock	20.7267	20.9193	20.388	20.4793	105097500.0
2017-05-08	TLT	Stock	121.11	121.14	120.53	120.63	8057780.0
2017-05-08	ES	Stock	59.68	59.81	59.37	59.76	1133300.0
2017-05-08	CL	Stock	71.83	72.08	71.65	71.84	2177600.0
2017-05-08	A	Stock	56.65	56.82	55.93	56.32	2190000.0
2017-05-08	AA	Stock	31.37	31.37	30.66	31.02	3795700.0
2017-05-08	AAAP-DELISTED	Stock	37.47	37.54	36.61	36.96	18303.0
2017-05-08	AABA-DELISTED	Stock	48.71	48.96	48.51	48.85	8505233.0
2017-05-08	AAC-DELISTED	Stock	7.11	7.24	7.0	7.17	54105.0
2017-05-08	AACG	Stock	3.75	3.9	3.62	3.83	44500.0
2017-05-08	AAIC-DELISTED	Stock	14.37	14.4601	14.25	14.35	286795.0
2017-05-08	AAL	Stock	44.6	45.05	44.52	44.94	6190700.0
2017-05-08	AAM.A-DELISTED	Stock	25.7	25.7	25.58	25.65	72283.0
2017-05-08	AAMC-DELISTED	Stock	21.0588	21.8088	21.0588	21.8088	2421.0
2017-05-08	AAMI	Stock	14.99	15.35	14.99	15.31	286200.0
2017-05-08	AAOI	Stock	57.15	60.0	56.55	57.39	5314600.0
2017-05-08	AAON	Stock	24.1333	24.6333	24.0333	24.6	195750.0
2017-05-08	AAP	Stock	145.17	147.06	144.76	146.97	838200.0
2017-05-08	AAT	Stock	41.53	41.53	40.38	40.5	513500.0
2017-05-08	AAU-DELISTED	Stock	1.39	1.39	1.27	1.305	419783.0
2017-05-08	AAUAF-DELISTED	Stock	1.39	1.39	1.27	1.31	431453.0
2017-05-08	AAV-DELISTED	Stock	6.1	6.2	6.076	6.2	67766.0
2017-05-08	AAWW-DELISTED	Stock	52.15	52.75	52.023	52.4	175367.0
2017-05-08	AAXJ	Stock	64.67	64.82	64.52	64.53	878684.0
2017-05-08	AAXN-DELISTED	Stock	24.84	25.07	24.59	25.05	619858.0
2017-05-08	AB	Stock	20.95	21.0	20.8	20.85	281500.0
2017-05-08	ABAC-DELISTED	Stock	1.67	1.73	1.65	1.65	4467.0
2017-05-08	ABAX-DELISTED	Stock	47.55	47.93	47.55	47.93	69219.0
2017-05-08	ABB-DELISTED	Stock	24.54	24.64	24.49	24.62	2566356.0
2017-05-08	ABBNY-DELISTED	Stock	24.54	24.64	24.49	24.63	2693442.0
2017-05-08	ABBV	Stock	66.94	66.95	66.14	66.21	4497400.0
2017-05-08	ABC-DELISTED	Stock	86.21	86.98	86.02	86.59	1422326.0
2017-05-08	ABCB	Stock	46.9	47.3	46.65	47.15	104200.0
2017-05-08	ABCD-DELISTED	Stock	5.21	5.3999	5.2	5.39	27700.0
2017-05-08	ABCO-DELISTED	Stock	51.3	51.4	50.7	51.2	221721.0
2017-05-08	ABDC-DELISTED	Stock	14.28	14.5	14.21	14.48	61010.0
2017-05-08	ABE-DELISTED	Stock	13.67	13.67	13.55	13.57	4780.0
2017-05-08	ABEO	Stock	138.75	142.5	138.75	141.25	6076.0
2017-05-08	ABEOW-DELISTED	Stock	2.75	2.75	2.75	2.75	100.0
2017-05-08	ABEV	Stock	5.9	5.91	5.84	5.88	25065200.0
2017-05-08	ABG	Stock	59.6	60.0	58.85	59.15	174500.0
2017-05-08	ABIL-DELISTED	Stock	0.8	0.8	0.75	0.75	3551.0
2017-05-08	ABM	Stock	43.46	43.63	42.94	43.08	169400.0
2017-05-08	ABMD-DELISTED	Stock	132.3	133.97	130.02	130.82	297439.0

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

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