PREVIEW / stock_daily / 2019-01-03

all stock daily files

  file:    by_date/stock_daily/2019/2019-01-03.parquet
  size:    218 KB
  rows:    6,525
  symbols: 2,648

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
2019-01-03	AAPL	Stock	35.995	36.43	35.5	35.5475	365248800.0
2019-01-03	MSFT	Stock	100.1	100.19	97.2	97.4	42579100.0
2019-01-03	NVDA	Stock	3.3448	3.379	3.1922	3.1998	705552000.0
2019-01-03	AMZN	Stock	76.0005	76.9	74.8555	75.014	139512000.0
2019-01-03	GOOGL	Stock	52.5335	53.313	51.1185	51.2735	41959140.0
2019-01-03	META	Stock	134.69	137.17	131.12	131.74	22717900.0
2019-01-03	TSLA	Stock	20.4667	20.6267	19.8253	20.024	104478000.0
2019-01-03	TLT	Stock	122.29	123.86	122.2267	123.54	21187045.0
2019-01-03	ES	Stock	63.55	64.2	63.2	63.45	1272100.0
2019-01-03	CL	Stock	59.19	59.99	58.87	58.97	4156100.0
2019-01-03	A	Stock	65.53	65.78	62.0	63.27	5383900.0
2019-01-03	AA	Stock	26.12	26.85	25.53	26.24	2979900.0
2019-01-03	AABA-DELISTED	Stock	56.48	56.85	55.09	55.49	8027830.0
2019-01-03	AAC-DELISTED	Stock	1.61	1.675	1.57	1.59	136865.0
2019-01-03	AACG	Stock	0.99	1.0	0.94	0.94	43300.0
2019-01-03	AAIC-DELISTED	Stock	7.28	7.38	7.27	7.31	497546.0
2019-01-03	AAL	Stock	31.69	31.85	28.81	30.06	16822000.0
2019-01-03	AAM.A-DELISTED	Stock	23.0	23.0	22.65	22.9	34234.0
2019-01-03	AAM.B-DELISTED	Stock	22.679	22.75	22.5	22.62	61481.0
2019-01-03	AAMC-DELISTED	Stock	9.2059	9.2059	8.9142	8.9142	3080.0
2019-01-03	AAME	Stock	2.51	2.72	2.5	2.65	6900.0
2019-01-03	AAMI	Stock	11.09	11.395	11.0	11.14	570300.0
2019-01-03	AAOI	Stock	15.51	15.8	15.015	15.06	398400.0
2019-01-03	AAON	Stock	23.3	23.3867	22.3467	22.5133	247500.0
2019-01-03	AAP	Stock	158.23	164.07	157.74	162.85	1514700.0
2019-01-03	AAT	Stock	39.37	39.96	39.04	39.31	166400.0
2019-01-03	AAU-DELISTED	Stock	0.7	0.738	0.6837	0.6886	135735.0
2019-01-03	AAUAF-DELISTED	Stock	0.7	0.738	0.6837	0.6886	141148.0
2019-01-03	AAWW-DELISTED	Stock	41.2	42.395	39.88	40.6	232262.0
2019-01-03	AAXJ	Stock	62.19	62.26	61.55	61.6	1505789.0
2019-01-03	AAXN-DELISTED	Stock	44.34	44.697	42.42	43.29	852992.0
2019-01-03	AB	Stock	27.23	28.0	26.97	27.47	532200.0
2019-01-03	ABAC-DELISTED	Stock	1.18	1.29	1.061	1.205	97310.0
2019-01-03	ABB-DELISTED	Stock	18.85	18.88	18.61	18.62	1423458.0
2019-01-03	ABBNY-DELISTED	Stock	18.85	18.88	18.61	18.62	1942898.0
2019-01-03	ABBV	Stock	88.64	88.8	86.08	86.29	7653200.0
2019-01-03	ABC-DELISTED	Stock	74.14	74.71	72.91	73.38	1309635.0
2019-01-03	ABCB	Stock	31.73	32.47	31.42	31.84	434500.0
2019-01-03	ABDC-DELISTED	Stock	6.63	6.83	6.56	6.77	30416.0
2019-01-03	ABEO	Stock	175.75	177.75	162.75	165.5	21540.0
2019-01-03	ABEV	Stock	4.26	4.29	4.17	4.24	21264400.0
2019-01-03	ABG	Stock	67.7	68.5	66.77	67.84	154100.0
2019-01-03	ABIL-DELISTED	Stock	1.91	1.93	1.8328	1.909	243960.0
2019-01-03	ABM	Stock	31.22	31.81	30.79	30.95	720600.0
2019-01-03	ABMD-DELISTED	Stock	307.25	311.7353	293.658	302.29	511841.0
2019-01-03	ABR	Stock	10.14	10.37	10.13	10.34	853600.0
2019-01-03	ABR.B-DELISTED	Stock	25.173	25.173	25.173	25.173	300.0
2019-01-03	ABR.C-DELISTED	Stock	26.19	26.19	26.079	26.079	762.0
2019-01-03	ABT	Stock	68.74	68.88	65.5	66.22	10570700.0
2019-01-03	ABTC	Stock	301050.0	303900.0	301050.0	303000.0	0.06666666666666667

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

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