PREVIEW / stock_daily / 2019-12-20

all stock daily files

  file:    by_date/stock_daily/2019/2019-12-20.parquet
  size:    224 KB
  rows:    6,610
  symbols: 2,449

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-12-20	AAPL	Stock	70.5575	70.6625	69.64	69.86	275978000.0
2019-12-20	MSFT	Stock	157.35	158.49	156.29	157.41	53477500.0
2019-12-20	NVDA	Stock	5.9533	6.0098	5.934	5.9842	603044000.0
2019-12-20	AMZN	Stock	89.981	90.1485	89.1225	89.325	103016000.0
2019-12-20	GOOGL	Stock	68.155	68.2	67.5365	67.561	50276980.0
2019-12-20	META	Stock	207.48	207.71	203.43	206.3	27306900.0
2019-12-20	TSLA	Stock	27.3527	27.5333	26.6793	27.0393	221290500.0
2019-12-20	TLT	Stock	136.13	136.69	135.93	136.65	5455919.0
2019-12-20	ES	Stock	83.98	85.33	83.83	84.59	4670700.0
2019-12-20	CL	Stock	69.1	69.3	68.76	68.85	6008000.0
2019-12-20	A	Stock	84.94	85.31	84.32	85.19	2287800.0
2019-12-20	AA	Stock	21.58	21.65	20.98	21.23	5139800.0
2019-12-20	AACG	Stock	1.5	1.58	1.5	1.51	8500.0
2019-12-20	AAIC-DELISTED	Stock	5.71	5.8	5.64	5.67	3091226.0
2019-12-20	AAIC.C-DELISTED	Stock	21.48	21.48	21.44	21.46	8920.0
2019-12-20	AAL	Stock	28.67	29.05	28.49	29.04	12277100.0
2019-12-20	AAM.A-DELISTED	Stock	26.62	26.6265	26.5596	26.6206	8687.0
2019-12-20	AAM.B-DELISTED	Stock	27.1994	27.28	27.1408	27.28	10561.0
2019-12-20	AAME	Stock	2.01	2.01	1.84	1.85	5100.0
2019-12-20	AAMI	Stock	10.16	10.21	10.055	10.2	1393800.0
2019-12-20	AAOI	Stock	11.3	11.31	11.085	11.12	609700.0
2019-12-20	AAON	Stock	32.9	33.5067	32.6	33.24	994050.0
2019-12-20	AAP	Stock	157.77	158.7	156.09	158.12	1269200.0
2019-12-20	AAT	Stock	44.98	45.3	44.75	44.95	675800.0
2019-12-20	AAU-DELISTED	Stock	0.51	0.52	0.4906	0.5007	210962.0
2019-12-20	AAUAF-DELISTED	Stock	0.51	0.52	0.4906	0.5007	224002.0
2019-12-20	AAWW-DELISTED	Stock	28.07	28.075	26.65	27.65	530567.0
2019-12-20	AAXJ	Stock	72.98	73.125	72.885	73.0	575467.0
2019-12-20	AAXN-DELISTED	Stock	70.54	71.43	70.2	71.25	746919.0
2019-12-20	AB	Stock	30.0	30.12	29.85	29.98	211400.0
2019-12-20	ABB-DELISTED	Stock	24.08	24.1	23.84	23.855	2148686.0
2019-12-20	ABBNY-DELISTED	Stock	24.09	24.1	23.84	23.84	2686408.0
2019-12-20	ABBV	Stock	90.4	91.99	89.15	89.29	19134800.0
2019-12-20	ABC-DELISTED	Stock	84.52	85.76	83.8	85.66	1367913.0
2019-12-20	ABCB	Stock	43.81	43.81	43.05	43.21	1559900.0
2019-12-20	ABDC-DELISTED	Stock	9.12	9.17	9.12	9.12	23664.0
2019-12-20	ABEO	Stock	73.75	86.5	70.25	78.0	570392.0
2019-12-20	ABEOW-DELISTED	Stock	0.07	0.0704	0.0698	0.0698	5800.0
2019-12-20	ABEV	Stock	4.53	4.61	4.53	4.57	8535000.0
2019-12-20	ABG	Stock	118.89	119.13	117.83	117.92	247000.0
2019-12-20	ABIL-DELISTED	Stock	0.528	0.57	0.515	0.5587	19845.0
2019-12-20	ABM	Stock	39.05	39.74	38.58	38.7	1423900.0
2019-12-20	ABMD-DELISTED	Stock	168.8	168.8	162.25	162.89	1516835.0
2019-12-20	ABR	Stock	14.53	14.76	14.38	14.61	1990800.0
2019-12-20	ABR.A-DELISTED	Stock	26.2773	26.325	26.2701	26.325	1864.0
2019-12-20	ABR.B-DELISTED	Stock	25.75	25.75	25.7183	25.7183	547.0
2019-12-20	ABR.C-DELISTED	Stock	26.61	26.6596	26.6	26.6596	644.0
2019-12-20	ABT	Stock	88.99	89.24	86.63	86.66	11606500.0
2019-12-20	ABTC	Stock	337200.0	338700.0	308400.0	309000.0	7.533333333333333
2019-12-20	ABTS	Stock	28.5	28.5	25.5	25.5	373.0

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

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