PREVIEW / stock_daily / 2019-09-09

all stock daily files

  file:    by_date/stock_daily/2019/2019-09-09.parquet
  size:    220 KB
  rows:    6,598
  symbols: 2,527

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-09-09	AAPL	Stock	53.71	54.11	52.7675	53.5425	109237600.0
2019-09-09	MSFT	Stock	139.59	139.75	136.46	137.52	25773900.0
2019-09-09	NVDA	Stock	4.4975	4.5995	4.496	4.5125	417524000.0
2019-09-09	AMZN	Stock	92.05	92.5	91.2305	91.5675	59990000.0
2019-09-09	GOOGL	Stock	60.354	61.0275	59.6585	60.2635	31859160.0
2019-09-09	META	Stock	187.73	188.98	185.85	188.76	14722400.0
2019-09-09	TSLA	Stock	15.3333	15.584	15.282	15.4527	72040500.0
2019-09-09	TLT	Stock	143.83	144.0	143.19	143.2	15862660.0
2019-09-09	ES	Stock	81.82	82.44	81.58	81.8	2888700.0
2019-09-09	CL	Stock	74.6	74.6	72.86	73.19	5153000.0
2019-09-09	A	Stock	74.39	74.59	73.67	74.18	2996900.0
2019-09-09	AA	Stock	19.27	20.42	19.27	20.3	4241600.0
2019-09-09	AABA-DELISTED	Stock	69.96	70.153	69.88	70.12	8307349.0
2019-09-09	AAC-DELISTED	Stock	0.5896	0.75	0.5732	0.5904	562252.0
2019-09-09	AACG	Stock	1.88	1.92	1.86	1.86	9900.0
2019-09-09	AAIC-DELISTED	Stock	5.07	5.21	5.07	5.2	274105.0
2019-09-09	AAIC.C-DELISTED	Stock	21.96	22.05	21.8	21.96	11875.0
2019-09-09	AAL	Stock	27.79	28.75	27.71	28.44	8561600.0
2019-09-09	AAM.A-DELISTED	Stock	26.36	26.5	26.36	26.38	9871.0
2019-09-09	AAM.B-DELISTED	Stock	26.38	26.54	26.3269	26.33	43791.0
2019-09-09	AAMC-DELISTED	Stock	2.8598	3.0824	2.8598	3.0824	3641.0
2019-09-09	AAMI	Stock	9.48	10.48	9.425	10.15	1051900.0
2019-09-09	AAOI	Stock	10.38	10.85	10.29	10.58	771800.0
2019-09-09	AAON	Stock	31.7533	31.9867	31.1267	31.6133	142800.0
2019-09-09	AAP	Stock	147.4	147.81	145.57	147.43	1039700.0
2019-09-09	AAT	Stock	47.77	48.12	47.39	47.96	524200.0
2019-09-09	AAU-DELISTED	Stock	0.66	0.6661	0.6259	0.6353	337823.0
2019-09-09	AAUAF-DELISTED	Stock	0.66	0.6661	0.6259	0.6352	346199.0
2019-09-09	AAWW-DELISTED	Stock	27.71	29.38	27.71	29.19	403429.0
2019-09-09	AAXJ	Stock	67.31	67.515	67.2	67.46	868474.0
2019-09-09	AAXN-DELISTED	Stock	62.44	62.44	59.2348	59.57	499931.0
2019-09-09	AB	Stock	28.96	29.4	28.91	29.4	117000.0
2019-09-09	ABB-DELISTED	Stock	19.61	19.72	19.55	19.69	1576337.0
2019-09-09	ABBNY-DELISTED	Stock	19.61	19.72	19.55	19.7	1703339.0
2019-09-09	ABBV	Stock	67.96	68.0	66.31	66.7	10310900.0
2019-09-09	ABC-DELISTED	Stock	86.31	87.57	86.16	87.13	963746.0
2019-09-09	ABCB	Stock	35.23	35.89	34.67	35.59	541900.0
2019-09-09	ABDC-DELISTED	Stock	8.94	8.97	8.88	8.95	10379.0
2019-09-09	ABEO	Stock	74.5	76.25	69.5	75.25	35508.0
2019-09-09	ABEV	Stock	4.58	4.64	4.58	4.6	12381100.0
2019-09-09	ABG	Stock	96.95	100.62	96.66	100.07	197200.0
2019-09-09	ABIL-DELISTED	Stock	0.63	0.64	0.581	0.605	22571.0
2019-09-09	ABM	Stock	35.32	35.32	33.78	34.94	476700.0
2019-09-09	ABMD-DELISTED	Stock	190.16	190.16	183.08	186.82	290349.0
2019-09-09	ABR	Stock	12.39	12.52	12.39	12.46	1345500.0
2019-09-09	ABR.A-DELISTED	Stock	26.16	26.16	26.065	26.16	1547.0
2019-09-09	ABR.B-DELISTED	Stock	25.7758	25.86	25.775	25.849	3058.0
2019-09-09	ABR.C-DELISTED	Stock	26.35	26.38	26.1952	26.1952	1821.0
2019-09-09	ABT	Stock	86.34	86.43	83.87	84.22	4444600.0
2019-09-09	ABTC	Stock	237300.0	247740.0	235170.0	247200.0	1.4400000000000002

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

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