PREVIEW / stock_daily / 2017-12-18

all stock daily files

  file:    by_date/stock_daily/2017/2017-12-18.parquet
  size:    218 KB
  rows:    6,527
  symbols: 2,922

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-12-18	AAPL	Stock	43.72	44.3	43.715	44.105	117684400.0
2017-12-18	MSFT	Stock	87.12	87.5	86.23	86.38	22283800.0
2017-12-18	NVDA	Stock	4.83	4.9505	4.8	4.9475	477704000.0
2017-12-18	AMZN	Stock	59.3685	59.739	59.0455	59.529	58952000.0
2017-12-18	GOOGL	Stock	53.8225	54.3245	53.5185	54.2545	30292020.0
2017-12-18	META	Stock	181.01	181.3	179.75	180.82	17265400.0
2017-12-18	TSLA	Stock	22.9933	23.1153	22.5053	22.5913	82143000.0
2017-12-18	TLT	Stock	127.97	128.0	126.91	127.18	7239706.0
2017-12-18	ES	Stock	64.58	64.83	63.85	63.91	1426300.0
2017-12-18	CL	Stock	74.15	74.77	73.98	73.99	3252200.0
2017-12-18	A	Stock	67.89	68.51	67.48	67.66	2306300.0
2017-12-18	AA	Stock	42.81	44.69	42.76	44.57	3175100.0
2017-12-18	AAAP-DELISTED	Stock	81.59	81.69	81.56	81.66	344458.0
2017-12-18	AABA-DELISTED	Stock	70.54	70.74	69.95	70.14	6242532.0
2017-12-18	AAC-DELISTED	Stock	8.45	8.83	8.43	8.58	172616.0
2017-12-18	AACG	Stock	5.39	5.42	5.15	5.25	9200.0
2017-12-18	AAIC-DELISTED	Stock	12.58	12.67	12.45	12.54	455876.0
2017-12-18	AAL	Stock	51.25	51.66	51.25	51.49	3235900.0
2017-12-18	AAM.A-DELISTED	Stock	26.12	26.3	26.1	26.3	21159.0
2017-12-18	AAMC-DELISTED	Stock	22.8971	24.6765	22.8824	23.9118	6691.0
2017-12-18	AAME	Stock	3.3	3.7	3.3	3.7	8000.0
2017-12-18	AAMI	Stock	16.9	17.22	16.9	16.95	522700.0
2017-12-18	AAOI	Stock	39.1	40.399	39.1	39.27	1128100.0
2017-12-18	AAON	Stock	23.6667	24.3667	23.6333	23.9667	265350.0
2017-12-18	AAP	Stock	101.34	103.1	100.65	102.71	844800.0
2017-12-18	AAT	Stock	39.36	39.79	39.1	39.4	286000.0
2017-12-18	AAU-DELISTED	Stock	0.9299	0.9668	0.92	0.9651	150701.0
2017-12-18	AAUAF-DELISTED	Stock	0.9299	0.9668	0.92	0.954	159987.0
2017-12-18	AAV-DELISTED	Stock	3.8	3.95	3.8	3.85	216793.0
2017-12-18	AAWW-DELISTED	Stock	58.0	58.695	57.95	58.2	102519.0
2017-12-18	AAXJ	Stock	75.79	76.05	75.77	75.88	1889866.0
2017-12-18	AAXN-DELISTED	Stock	26.4	27.06	26.4	27.0	593002.0
2017-12-18	AB	Stock	25.25	25.8	25.1	25.65	319700.0
2017-12-18	ABAC-DELISTED	Stock	3.09	3.1357	3.0799	3.0799	24162.0
2017-12-18	ABAX-DELISTED	Stock	48.2	49.27	48.2	49.0	72051.0
2017-12-18	ABB-DELISTED	Stock	26.41	26.56	26.41	26.44	1522872.0
2017-12-18	ABBNY-DELISTED	Stock	26.41	26.56	26.41	26.43	1569974.0
2017-12-18	ABBV	Stock	97.67	99.1	97.55	98.19	4768300.0
2017-12-18	ABC-DELISTED	Stock	92.84	92.95	91.755	92.41	1619313.0
2017-12-18	ABCB	Stock	48.65	49.45	48.65	49.45	264100.0
2017-12-18	ABCD-DELISTED	Stock	5.66	5.77	5.31	5.5	91480.0
2017-12-18	ABDC-DELISTED	Stock	8.41	8.59	8.4	8.5	188412.0
2017-12-18	ABE-DELISTED	Stock	14.19	14.42	14.19	14.38	7858.0
2017-12-18	ABEO	Stock	416.25	431.25	362.5	380.0	50480.0
2017-12-18	ABEOW-DELISTED	Stock	10.2997	10.2997	10.05	10.05	400.0
2017-12-18	ABEV	Stock	6.29	6.36	6.28	6.31	8167900.0
2017-12-18	ABG	Stock	65.65	66.8	65.25	66.45	237300.0
2017-12-18	ABIL-DELISTED	Stock	0.4259	0.45	0.39	0.42	49253.0
2017-12-18	ABLX-DELISTED	Stock	24.6	24.82	24.43	24.62	70788.0
2017-12-18	ABM	Stock	37.52	38.28	37.42	38.11	940300.0

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

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