PREVIEW / stock_daily / 2020-11-20

all stock daily files

  file:    by_date/stock_daily/2020/2020-11-20.parquet
  size:    234 KB
  rows:    7,084
  symbols: 2,537

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-20	AAPL	Stock	118.64	118.77	117.29	117.34	73604300.0
2020-11-20	MSFT	Stock	212.2	213.29	210.0	210.39	22843100.0
2020-11-20	NVDA	Stock	13.454	13.4945	13.065	13.0878	341088000.0
2020-11-20	AMZN	Stock	155.851	156.6445	154.9025	154.97	67488000.0
2020-11-20	GOOGL	Stock	88.1	88.4181	86.75	86.819	27706440.0
2020-11-20	META	Stock	272.56	273.0	269.41	269.7	18114700.0
2020-11-20	TSLA	Stock	165.9967	167.5	163.02	163.2033	98735700.0
2020-11-20	TLT	Stock	160.525	161.54	160.39	161.51	7247351.0
2020-11-20	ES	Stock	88.17	89.41	87.82	88.63	1395200.0
2020-11-20	CL	Stock	85.52	86.41	85.12	85.16	3719000.0
2020-11-20	A	Stock	108.64	112.3	108.32	110.89	2775400.0
2020-11-20	AA	Stock	18.89	19.23	18.605	18.82	4749800.0
2020-11-20	AACG	Stock	1.18	1.18	1.14	1.15	32600.0
2020-11-20	AACQ-DELISTED	Stock	9.8391	9.89	9.8	9.89	29641.0
2020-11-20	AACQU-DELISTED	Stock	10.3	10.3	10.26	10.26	45683.0
2020-11-20	AACQW-DELISTED	Stock	1.33	1.38	1.2	1.2	55038.0
2020-11-20	AAIC-DELISTED	Stock	3.02	3.07	2.94	3.06	164850.0
2020-11-20	AAIC.C-DELISTED	Stock	20.11	20.11	19.73	19.95	3175.0
2020-11-20	AAL	Stock	12.8	12.91	12.46	12.53	58685500.0
2020-11-20	AAM.A-DELISTED	Stock	26.52	26.64	26.5049	26.5731	6980.0
2020-11-20	AAM.B-DELISTED	Stock	27.62	27.62	27.45	27.454	13400.0
2020-11-20	AAMC-DELISTED	Stock	6.6588	6.7647	6.6588	6.7647	3505.0
2020-11-20	AAME	Stock	2.17	2.21	2.17	2.21	5100.0
2020-11-20	AAMI	Stock	18.06	18.32	18.01	18.22	315500.0
2020-11-20	AAOI	Stock	7.74	8.13	7.74	7.92	690000.0
2020-11-20	AAON	Stock	43.3667	44.1467	42.7667	43.6467	566850.0
2020-11-20	AAP	Stock	145.91	147.09	143.88	144.33	1334400.0
2020-11-20	AAT	Stock	28.74	28.84	28.4	28.54	268600.0
2020-11-20	AAU-DELISTED	Stock	1.12	1.12	1.05	1.08	292254.0
2020-11-20	AAUAF-DELISTED	Stock	1.12	1.12	1.05	1.08	301275.0
2020-11-20	AAWW-DELISTED	Stock	54.17	54.7599	52.86	53.39	418858.0
2020-11-20	AAXJ	Stock	85.52	86.01	85.34	85.77	643803.0
2020-11-20	AAXN-DELISTED	Stock	124.44	125.45	121.81	124.95	281789.0
2020-11-20	AB	Stock	31.43	31.78	31.3	31.68	183600.0
2020-11-20	ABB-DELISTED	Stock	26.59	26.695	26.51	26.64	1365778.0
2020-11-20	ABBNY-DELISTED	Stock	26.59	26.695	26.51	26.65	1584402.0
2020-11-20	ABBV	Stock	99.95	101.83	98.62	100.84	9682500.0
2020-11-20	ABC-DELISTED	Stock	101.44	101.78	99.74	100.48	666867.0
2020-11-20	ABCB	Stock	33.4	33.98	32.93	33.91	261900.0
2020-11-20	ABCM-DELISTED	Stock	18.73	19.37	18.6666	19.1	44223.0
2020-11-20	ABEO	Stock	33.75	35.0	32.75	34.25	42036.0
2020-11-20	ABEV	Stock	2.74	2.77	2.69	2.69	16573800.0
2020-11-20	ABG	Stock	119.88	120.71	115.5	117.04	178100.0
2020-11-20	ABM	Stock	38.08	38.51	37.65	38.25	395500.0
2020-11-20	ABMD-DELISTED	Stock	270.55	272.66	267.8	267.8	86590.0
2020-11-20	ABR	Stock	13.29	13.42	13.13	13.29	915700.0
2020-11-20	ABR.A-DELISTED	Stock	25.43	25.43	25.288	25.288	1115.0
2020-11-20	ABR.B-DELISTED	Stock	25.25	25.25	25.15	25.15	1429.0
2020-11-20	ABR.C-DELISTED	Stock	25.65	25.83	25.63	25.83	1112.0
2020-11-20	ABST-DELISTED	Stock	9.67	9.934	9.5	9.82	123983.0

> showing 50 of 7,084 rows — these rows as CSV

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