PREVIEW / stock_daily / 2017-12-19

all stock daily files

  file:    by_date/stock_daily/2017/2017-12-19.parquet
  size:    217 KB
  rows:    6,510
  symbols: 2,917

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-19	AAPL	Stock	43.7575	43.8475	43.5225	43.635	109745600.0
2017-12-19	MSFT	Stock	86.35	86.35	85.27	85.83	23524800.0
2017-12-19	NVDA	Stock	4.938	4.9432	4.874	4.9028	373100000.0
2017-12-19	AMZN	Stock	59.4575	59.6485	58.957	59.369	51756000.0
2017-12-19	GOOGL	Stock	54.151	54.2488	53.6135	53.989	26350380.0
2017-12-19	META	Stock	179.95	180.08	178.22	179.51	14920600.0
2017-12-19	TSLA	Stock	22.684	22.766	22.02	22.0733	102375000.0
2017-12-19	TLT	Stock	126.32	126.38	125.07	125.53	11045782.0
2017-12-19	ES	Stock	63.84	63.97	62.54	62.59	1341500.0
2017-12-19	CL	Stock	74.7	75.5	74.67	74.85	4352200.0
2017-12-19	A	Stock	67.94	68.05	67.49	67.75	1469400.0
2017-12-19	AA	Stock	44.67	46.54	44.66	46.52	5960200.0
2017-12-19	AAAP-DELISTED	Stock	81.55	81.68	81.52	81.57	535070.0
2017-12-19	AABA-DELISTED	Stock	69.7	70.3626	69.38	70.19	13267296.0
2017-12-19	AAC-DELISTED	Stock	8.58	8.74	8.36	8.42	164065.0
2017-12-19	AACG	Stock	5.23	5.26	5.06	5.06	8800.0
2017-12-19	AAIC-DELISTED	Stock	12.56	12.589	12.32	12.36	556976.0
2017-12-19	AAL	Stock	51.6	51.81	51.28	51.44	3019800.0
2017-12-19	AAM.A-DELISTED	Stock	26.16	26.34	26.11	26.34	32331.0
2017-12-19	AAMC-DELISTED	Stock	25.7941	25.7941	23.3235	24.1029	3815.0
2017-12-19	AAME	Stock	3.4	3.75	3.4	3.75	5100.0
2017-12-19	AAMI	Stock	16.96	17.08	16.81	16.85	337600.0
2017-12-19	AAOI	Stock	39.41	42.57	39.31	42.07	2169600.0
2017-12-19	AAON	Stock	24.0	24.0333	23.5333	23.5667	154200.0
2017-12-19	AAP	Stock	102.45	102.86	99.39	99.73	1333500.0
2017-12-19	AAT	Stock	39.39	39.44	37.9	38.01	272800.0
2017-12-19	AAU-DELISTED	Stock	0.96	0.97	0.9221	0.9633	244095.0
2017-12-19	AAUAF-DELISTED	Stock	0.96	0.97	0.9221	0.96	247047.0
2017-12-19	AAV-DELISTED	Stock	3.85	3.95	3.8	3.95	117922.0
2017-12-19	AAWW-DELISTED	Stock	58.4	58.91	57.8298	58.7	115366.0
2017-12-19	AAXJ	Stock	74.81	74.81	74.345	74.52	3122222.0
2017-12-19	AAXN-DELISTED	Stock	27.09	27.09	26.3304	26.5	478465.0
2017-12-19	AB	Stock	25.7	25.76	25.2	25.4	257300.0
2017-12-19	ABAC-DELISTED	Stock	3.08	3.08	2.96	3.0	7687.0
2017-12-19	ABAX-DELISTED	Stock	49.02	49.92	48.63	49.07	116495.0
2017-12-19	ABB-DELISTED	Stock	26.61	26.63	26.49	26.59	1018440.0
2017-12-19	ABBNY-DELISTED	Stock	26.61	26.63	26.49	26.59	1082247.0
2017-12-19	ABBV	Stock	98.42	98.55	97.7	97.92	2817700.0
2017-12-19	ABC-DELISTED	Stock	92.67	94.44	92.33	93.75	1737351.0
2017-12-19	ABCB	Stock	49.5	49.6	48.85	49.1	241700.0
2017-12-19	ABCD-DELISTED	Stock	5.618	5.84	5.54	5.79	108967.0
2017-12-19	ABDC-DELISTED	Stock	8.5	8.54	8.31	8.5	185008.0
2017-12-19	ABE-DELISTED	Stock	14.3	14.315	14.25	14.25	17857.0
2017-12-19	ABEO	Stock	380.0	396.25	366.5	383.25	24248.0
2017-12-19	ABEOW-DELISTED	Stock	10.265	10.265	10.265	10.265	109.0
2017-12-19	ABEV	Stock	6.21	6.24	6.15	6.2	7706800.0
2017-12-19	ABG	Stock	66.75	66.75	64.9	65.15	157300.0
2017-12-19	ABIL-DELISTED	Stock	0.441	0.441	0.4	0.41	27545.0
2017-12-19	ABLX-DELISTED	Stock	24.49	24.76	24.49	24.58	70298.0
2017-12-19	ABM	Stock	38.11	38.6	38.02	38.5	988700.0

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

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