PREVIEW / stock_daily / 2020-11-04

all stock daily files

  file:    by_date/stock_daily/2020/2020-11-04.parquet
  size:    228 KB
  rows:    6,975
  symbols: 2,482

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-11-04	AAPL	Stock	114.14	115.59	112.35	114.95	138235500.0
2020-11-04	MSFT	Stock	214.02	218.32	212.42	216.39	42311800.0
2020-11-04	NVDA	Stock	13.3893	13.8275	13.337	13.7942	410228000.0
2020-11-04	AMZN	Stock	157.9995	162.2425	156.9865	162.058	136780000.0
2020-11-04	GOOGL	Stock	85.279	88.5015	85.15	87.2925	71342980.0
2020-11-04	META	Stock	281.0	288.94	278.62	287.38	35364400.0
2020-11-04	TSLA	Stock	143.54	145.1333	139.0333	140.3267	96429300.0
2020-11-04	TLT	Stock	161.64	162.17	160.54	161.08	21570835.0
2020-11-04	ES	Stock	92.9	93.05	90.99	91.29	1389900.0
2020-11-04	CL	Stock	83.35	85.64	83.09	83.86	5653400.0
2020-11-04	A	Stock	108.07	109.8	107.24	108.49	1357300.0
2020-11-04	AA	Stock	13.65	13.65	12.86	13.19	6122700.0
2020-11-04	AACG	Stock	1.17	1.18	1.12	1.13	32300.0
2020-11-04	AACQ-DELISTED	Stock	9.64	9.75	9.64	9.72	118225.0
2020-11-04	AACQU-DELISTED	Stock	10.02	10.13	9.98	10.1	1148370.0
2020-11-04	AACQW-DELISTED	Stock	1.18	1.19	1.07	1.15	62074.0
2020-11-04	AAIC-DELISTED	Stock	2.69	2.84	2.68	2.78	319405.0
2020-11-04	AAL	Stock	11.21	11.31	10.93	11.01	45281300.0
2020-11-04	AAM.A-DELISTED	Stock	25.99	26.3	25.99	26.15	22538.0
2020-11-04	AAM.B-DELISTED	Stock	26.83	27.01	26.68	26.7672	32009.0
2020-11-04	AAMC-DELISTED	Stock	6.5353	6.7647	6.5059	6.7588	7402.0
2020-11-04	AAME	Stock	2.05	2.06	2.05	2.05	1500.0
2020-11-04	AAMI	Stock	13.82	14.58	13.68	14.48	713900.0
2020-11-04	AAOI	Stock	9.17	9.3	8.825	9.07	579000.0
2020-11-04	AAON	Stock	40.0667	40.2467	38.8533	39.7733	231000.0
2020-11-04	AAP	Stock	158.37	159.55	154.86	155.53	791900.0
2020-11-04	AAT	Stock	21.76	22.2	21.38	21.48	318000.0
2020-11-04	AAU-DELISTED	Stock	1.05	1.08	0.996	1.0099	466913.0
2020-11-04	AAUAF-DELISTED	Stock	1.05	1.08	0.996	1.01	494739.0
2020-11-04	AAWW-DELISTED	Stock	62.14	63.6999	61.52	62.0	347099.0
2020-11-04	AAXJ	Stock	80.93	82.81	80.93	82.58	2236775.0
2020-11-04	AAXN-DELISTED	Stock	103.01	107.41	103.0	105.05	439068.0
2020-11-04	AB	Stock	30.21	30.36	29.39	30.26	434400.0
2020-11-04	ABB-DELISTED	Stock	25.59	25.985	25.38	25.68	1775692.0
2020-11-04	ABBNY-DELISTED	Stock	25.59	25.985	25.38	25.69	1978932.0
2020-11-04	ABBV	Stock	93.14	97.49	92.67	94.5	25849000.0
2020-11-04	ABC-DELISTED	Stock	103.0	107.37	102.78	104.94	1286814.0
2020-11-04	ABCB	Stock	30.18	30.45	28.52	28.71	499400.0
2020-11-04	ABCM-DELISTED	Stock	19.96	20.87	19.94	20.37	57862.0
2020-11-04	ABEO	Stock	26.25	27.25	25.75	25.75	46484.0
2020-11-04	ABEV	Stock	2.29	2.31	2.25	2.25	22650000.0
2020-11-04	ABG	Stock	111.13	114.21	111.0	113.5	136700.0
2020-11-04	ABM	Stock	35.99	36.82	35.49	35.84	235500.0
2020-11-04	ABMD-DELISTED	Stock	267.07	271.995	262.78	266.97	207933.0
2020-11-04	ABR	Stock	12.76	13.05	12.42	12.67	1703400.0
2020-11-04	ABR.A-DELISTED	Stock	25.796	25.8	25.796	25.8	200.0
2020-11-04	ABR.B-DELISTED	Stock	25.611	25.611	25.611	25.611	250.0
2020-11-04	ABR.C-DELISTED	Stock	25.9	26.1666	25.83	25.98	13115.0
2020-11-04	ABST-DELISTED	Stock	11.27	11.81	11.27	11.8	53591.0
2020-11-04	ABT	Stock	110.17	114.23	110.11	111.53	7421200.0

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

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