PREVIEW / stock_daily / 2019-09-20

all stock daily files

  file:    by_date/stock_daily/2019/2019-09-20.parquet
  size:    223 KB
  rows:    6,615
  symbols: 2,517

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-20	AAPL	Stock	55.345	55.64	54.3675	54.4325	221652400.0
2019-09-20	MSFT	Stock	141.01	141.65	138.25	139.44	39167300.0
2019-09-20	NVDA	Stock	4.4225	4.4462	4.307	4.3173	350244000.0
2019-09-20	AMZN	Stock	91.0855	91.5315	89.046	89.708	106838000.0
2019-09-20	GOOGL	Stock	61.682	62.14	61.179	61.492	38754860.0
2019-09-20	META	Stock	190.66	193.1	188.12	189.93	19934200.0
2019-09-20	TSLA	Stock	16.4327	16.4633	15.8773	16.0413	95295000.0
2019-09-20	TLT	Stock	140.77	141.98	140.44	141.89	13377236.0
2019-09-20	ES	Stock	83.3	83.62	82.91	83.26	3282200.0
2019-09-20	CL	Stock	71.02	71.26	70.76	70.95	4770000.0
2019-09-20	A	Stock	78.22	78.74	77.91	77.97	4605500.0
2019-09-20	AA	Stock	22.04	22.096	21.5	21.7	5090200.0
2019-09-20	AABA-DELISTED	Stock	70.32	70.59	70.28	70.5	9018605.0
2019-09-20	AAC-DELISTED	Stock	0.7958	0.8	0.755	0.78	230909.0
2019-09-20	AACG	Stock	1.81	1.84	1.78	1.8	4000.0
2019-09-20	AAIC-DELISTED	Stock	5.55	5.64	5.49	5.59	899928.0
2019-09-20	AAIC.C-DELISTED	Stock	21.04	21.2593	21.04	21.17	2348.0
2019-09-20	AAL	Stock	28.2	28.44	27.96	27.99	6885400.0
2019-09-20	AAM.A-DELISTED	Stock	26.49	26.49	26.43	26.46	8418.0
2019-09-20	AAM.B-DELISTED	Stock	26.65	26.65	26.46	26.54	36244.0
2019-09-20	AAMC-DELISTED	Stock	3.1118	3.2353	3.0882	3.2353	12090.0
2019-09-20	AAME	Stock	2.95	2.95	2.51	2.51	7100.0
2019-09-20	AAMI	Stock	10.55	10.78	10.24	10.24	4769600.0
2019-09-20	AAOI	Stock	10.95	11.47	10.94	11.15	618700.0
2019-09-20	AAON	Stock	32.9867	33.22	31.9133	32.6	583350.0
2019-09-20	AAP	Stock	152.93	156.8	152.69	155.69	1050500.0
2019-09-20	AAT	Stock	47.41	47.58	46.77	46.87	761000.0
2019-09-20	AAU-DELISTED	Stock	0.7101	0.72	0.71	0.7145	89432.0
2019-09-20	AAUAF-DELISTED	Stock	0.7101	0.72	0.71	0.7145	102184.0
2019-09-20	AAWW-DELISTED	Stock	24.52	24.85	23.6	24.5	702430.0
2019-09-20	AAXJ	Stock	68.02	68.14	67.38	67.5	754616.0
2019-09-20	AAXN-DELISTED	Stock	63.09	64.14	62.1645	63.49	765820.0
2019-09-20	AB	Stock	29.35	29.57	29.29	29.36	74000.0
2019-09-20	ABB-DELISTED	Stock	20.17	20.23	20.06	20.07	960188.0
2019-09-20	ABBNY-DELISTED	Stock	20.17	20.23	20.06	20.07	1017950.0
2019-09-20	ABBV	Stock	72.0	73.0	72.0	72.39	12968700.0
2019-09-20	ABC-DELISTED	Stock	84.95	86.46	84.76	85.12	1729848.0
2019-09-20	ABCB	Stock	39.24	40.24	39.16	39.68	2092700.0
2019-09-20	ABDC-DELISTED	Stock	8.98	9.02	8.95	9.02	42504.0
2019-09-20	ABEO	Stock	80.75	85.0	79.75	81.5	31896.0
2019-09-20	ABEV	Stock	4.64	4.67	4.58	4.63	24583500.0
2019-09-20	ABG	Stock	100.49	101.94	100.09	100.93	304700.0
2019-09-20	ABIL-DELISTED	Stock	0.6099	0.63	0.59	0.593	59539.0
2019-09-20	ABM	Stock	36.28	36.64	35.77	35.96	695700.0
2019-09-20	ABMD-DELISTED	Stock	193.0	196.49	191.68	192.65	783482.0
2019-09-20	ABR	Stock	13.07	13.2	13.02	13.19	1323400.0
2019-09-20	ABR.A-DELISTED	Stock	26.09	26.09	26.0	26.0052	2200.0
2019-09-20	ABR.B-DELISTED	Stock	25.8393	25.8393	25.8393	25.8393	2600.0
2019-09-20	ABR.C-DELISTED	Stock	26.54	26.55	26.43	26.5	1800.0
2019-09-20	ABT	Stock	83.51	83.88	82.87	83.58	7130100.0

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

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