PREVIEW / stock_daily / 2020-02-25

all stock daily files

  file:    by_date/stock_daily/2020/2020-02-25.parquet
  size:    223 KB
  rows:    6,641
  symbols: 2,417

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-02-25	AAPL	Stock	75.2375	75.6325	71.5325	72.02	230673600.0
2020-02-25	MSFT	Stock	174.2	174.84	167.65	168.07	68073300.0
2020-02-25	NVDA	Stock	6.9075	6.9698	6.449	6.5513	1055496000.0
2020-02-25	AMZN	Stock	101.321	101.73	97.921	98.637	124382000.0
2020-02-25	GOOGL	Stock	71.55	71.8424	69.021	69.316	51579320.0
2020-02-25	META	Stock	202.25	203.5	195.95	196.77	21433500.0
2020-02-25	TSLA	Stock	56.6	57.1067	52.4667	53.3273	259357500.0
2020-02-25	TLT	Stock	150.21	151.7553	150.14	151.05	20802922.0
2020-02-25	ES	Stock	95.31	96.17	93.09	93.38	2102400.0
2020-02-25	CL	Stock	74.4	74.99	73.52	73.8	5739500.0
2020-02-25	A	Stock	80.7	80.88	77.69	77.95	2768000.0
2020-02-25	AA	Stock	15.48	15.52	14.3	14.5	6280500.0
2020-02-25	AACG	Stock	1.05	1.24	1.05	1.14	87100.0
2020-02-25	AAIC-DELISTED	Stock	6.61	6.61	6.175	6.24	517434.0
2020-02-25	AAIC.C-DELISTED	Stock	23.045	23.52	22.86	22.9502	12802.0
2020-02-25	AAL	Stock	25.62	25.75	23.05	23.12	22296900.0
2020-02-25	AAM.A-DELISTED	Stock	26.8	26.81	26.41	26.54	27408.0
2020-02-25	AAM.B-DELISTED	Stock	27.48	27.48	26.755	26.82	24803.0
2020-02-25	AAMC-DELISTED	Stock	8.3	9.0441	7.6588	8.4059	104193.0
2020-02-25	AAME	Stock	2.32	2.45	2.25	2.4	2700.0
2020-02-25	AAMI	Stock	10.6	10.89	10.26	10.26	956100.0
2020-02-25	AAOI	Stock	10.72	10.825	10.1	10.195	664500.0
2020-02-25	AAON	Stock	36.04	36.04	35.0467	35.3467	318150.0
2020-02-25	AAP	Stock	140.78	140.78	136.14	137.6	1565700.0
2020-02-25	AAT	Stock	45.33	45.33	43.83	44.06	236600.0
2020-02-25	AAU-DELISTED	Stock	0.425	0.4377	0.4175	0.4298	191630.0
2020-02-25	AAUAF-DELISTED	Stock	0.425	0.4377	0.4175	0.4298	197653.0
2020-02-25	AAWW-DELISTED	Stock	29.01	29.06	25.5	26.26	614101.0
2020-02-25	AAXJ	Stock	70.11	70.25	68.78	68.78	1235621.0
2020-02-25	AAXN-DELISTED	Stock	82.82	84.22	79.14	79.49	580197.0
2020-02-25	AB	Stock	33.02	33.54	31.68	32.35	869100.0
2020-02-25	ABB-DELISTED	Stock	22.82	22.83	22.27	22.32	2604060.0
2020-02-25	ABBNY-DELISTED	Stock	22.82	22.83	22.27	22.32	2770467.0
2020-02-25	ABBV	Stock	93.32	93.46	88.11	89.18	11366400.0
2020-02-25	ABC-DELISTED	Stock	95.36	95.77	92.78	92.95	1733247.0
2020-02-25	ABCB	Stock	39.48	39.48	37.91	38.0	519900.0
2020-02-25	ABEO	Stock	98.5	101.75	92.5	97.25	70948.0
2020-02-25	ABEV	Stock	3.6	3.64	3.57	3.61	32193100.0
2020-02-25	ABG	Stock	97.99	98.26	96.23	97.0	248800.0
2020-02-25	ABM	Stock	37.26	37.26	35.7	35.73	235100.0
2020-02-25	ABMD-DELISTED	Stock	167.0	167.0	157.8947	158.86	456459.0
2020-02-25	ABR	Stock	14.49	14.5	13.51	13.82	3802600.0
2020-02-25	ABR.A-DELISTED	Stock	26.08	26.09	25.81	25.8128	11674.0
2020-02-25	ABR.B-DELISTED	Stock	25.7612	25.78	25.47	25.52	15267.0
2020-02-25	ABR.C-DELISTED	Stock	26.5	26.5	26.16	26.2944	3186.0
2020-02-25	ABT	Stock	84.93	85.37	80.78	81.13	7021800.0
2020-02-25	ABTC	Stock	217200.0	236100.0	217200.0	230100.0	5.466666666666667
2020-02-25	ABTX-DELISTED	Stock	36.86	36.86	35.61	35.8	51269.0
2020-02-25	ABUS	Stock	3.02	3.08	2.91	3.0	348400.0
2020-02-25	ACA	Stock	43.58	43.58	40.83	41.02	283652.0

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

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