PREVIEW / stock_daily / 2020-01-27

all stock daily files

  file:    by_date/stock_daily/2020/2020-01-27.parquet
  size:    222 KB
  rows:    6,607
  symbols: 2,414

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
2020-01-27	AAPL	Stock	77.515	77.9425	76.22	77.2375	161940000.0
2020-01-27	MSFT	Stock	161.15	163.38	160.2	162.28	32078100.0
2020-01-27	NVDA	Stock	5.956	6.0562	5.8058	6.005	470536000.0
2020-01-27	AMZN	Stock	91.0	92.05	90.767	91.417	70570000.0
2020-01-27	GOOGL	Stock	71.577	71.829	70.975	71.5865	34131320.0
2020-01-27	META	Stock	213.1	216.06	212.5	214.87	13810700.0
2020-01-27	TSLA	Stock	36.1327	37.6293	35.952	37.2013	204121500.0
2020-01-27	TLT	Stock	143.95	144.29	143.5004	144.29	10935243.0
2020-01-27	ES	Stock	91.68	92.14	91.14	91.37	1727100.0
2020-01-27	CL	Stock	70.15	70.79	69.77	70.1	3688100.0
2020-01-27	A	Stock	86.54	87.17	86.21	86.56	1868000.0
2020-01-27	AA	Stock	15.01	15.325	14.8	14.87	6596100.0
2020-01-27	AACG	Stock	1.34	1.37	1.25	1.31	9200.0
2020-01-27	AAIC-DELISTED	Stock	5.77	5.8	5.72	5.76	277931.0
2020-01-27	AAIC.C-DELISTED	Stock	22.2	22.2	22.125	22.15	3118.0
2020-01-27	AAL	Stock	26.57	26.6	25.37	26.11	21573800.0
2020-01-27	AAM.A-DELISTED	Stock	26.94	26.995	26.94	26.96	11532.0
2020-01-27	AAM.B-DELISTED	Stock	27.42	27.42	27.23	27.32	8674.0
2020-01-27	AAMC-DELISTED	Stock	3.7848	3.9294	3.7848	3.9294	5450.0
2020-01-27	AAME	Stock	1.78	1.97	1.78	1.8	1100.0
2020-01-27	AAMI	Stock	9.3	9.35	9.24	9.27	269100.0
2020-01-27	AAOI	Stock	13.47	13.56	13.07	13.26	585700.0
2020-01-27	AAON	Stock	34.9	35.7933	34.9	35.6	122850.0
2020-01-27	AAP	Stock	139.89	141.66	139.06	139.06	937300.0
2020-01-27	AAT	Stock	47.47	47.79	47.22	47.61	223200.0
2020-01-27	AAU-DELISTED	Stock	0.54	0.542	0.51	0.51	254307.0
2020-01-27	AAUAF-DELISTED	Stock	0.54	0.542	0.51	0.5155	281178.0
2020-01-27	AAWW-DELISTED	Stock	23.89	24.63	23.27	23.81	373040.0
2020-01-27	AAXJ	Stock	69.84	71.01	69.57	70.68	1037100.0
2020-01-27	AAXN-DELISTED	Stock	78.59	79.455	77.82	77.9	828409.0
2020-01-27	AB	Stock	33.05	33.49	33.0	33.42	181000.0
2020-01-27	ABB-DELISTED	Stock	23.36	23.47	23.22	23.23	1839018.0
2020-01-27	ABBNY-DELISTED	Stock	23.36	23.47	23.22	23.24	1936506.0
2020-01-27	ABBV	Stock	85.05	85.93	84.0	84.02	13832000.0
2020-01-27	ABC-DELISTED	Stock	87.94	88.25	86.53	87.51	1356427.0
2020-01-27	ABCB	Stock	40.6	41.11	40.1	40.57	524400.0
2020-01-27	ABDC-DELISTED	Stock	9.47	9.48	9.4344	9.48	27158.0
2020-01-27	ABEO	Stock	65.75	65.75	59.25	59.5	79804.0
2020-01-27	ABEV	Stock	4.41	4.44	4.36	4.38	23897800.0
2020-01-27	ABG	Stock	97.81	101.16	97.41	100.06	101800.0
2020-01-27	ABM	Stock	38.36	39.48	38.36	39.05	490800.0
2020-01-27	ABMD-DELISTED	Stock	179.11	183.7212	178.0	181.57	444629.0
2020-01-27	ABR	Stock	14.66	14.7	14.48	14.64	699800.0
2020-01-27	ABR.A-DELISTED	Stock	26.45	26.45	26.428	26.45	1050.0
2020-01-27	ABR.B-DELISTED	Stock	26.25	26.25	26.25	26.25	100.0
2020-01-27	ABR.C-DELISTED	Stock	26.75	26.75	26.75	26.75	100.0
2020-01-27	ABT	Stock	89.11	90.0	88.89	89.59	4482200.0
2020-01-27	ABTC	Stock	255000.0	267000.0	252000.0	252300.0	2.013333333333333
2020-01-27	ABTX-DELISTED	Stock	36.17	36.7	36.0	36.48	48620.0
2020-01-27	ABUS	Stock	3.14	3.14	2.92	2.95	254000.0

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

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