PREVIEW / stock_daily / 2019-12-05

all stock daily files

  file:    by_date/stock_daily/2019/2019-12-05.parquet
  size:    221 KB
  rows:    6,573
  symbols: 2,432

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-12-05	AAPL	Stock	65.9475	66.4725	65.6825	66.395	74424400.0
2019-12-05	MSFT	Stock	150.05	150.32	149.48	149.93	17869100.0
2019-12-05	NVDA	Stock	5.2575	5.2733	5.1878	5.2185	184884000.0
2019-12-05	AMZN	Stock	88.175	88.175	87.0	87.024	56476000.0
2019-12-05	GOOGL	Stock	66.35	66.399	65.716	66.348	24412620.0
2019-12-05	META	Stock	199.86	201.29	198.21	199.36	9740400.0
2019-12-05	TSLA	Stock	22.1887	22.2947	21.8167	22.0247	55869000.0
2019-12-05	TLT	Stock	138.66	139.44	138.6	139.12	7274024.0
2019-12-05	ES	Stock	82.78	82.9	81.97	82.16	2420300.0
2019-12-05	CL	Stock	67.86	67.92	67.36	67.82	4056500.0
2019-12-05	A	Stock	80.89	81.74	80.5	81.53	1900000.0
2019-12-05	AA	Stock	19.86	20.01	19.75	19.87	4065900.0
2019-12-05	AACG	Stock	1.73	1.73	1.66	1.7	5400.0
2019-12-05	AAIC-DELISTED	Stock	5.85	5.8798	5.81	5.84	210825.0
2019-12-05	AAIC.C-DELISTED	Stock	22.11	22.1454	21.9	22.1	7804.0
2019-12-05	AAL	Stock	27.46	27.57	27.05	27.24	4994500.0
2019-12-05	AAM.A-DELISTED	Stock	26.12	26.13	26.1	26.1185	13539.0
2019-12-05	AAM.B-DELISTED	Stock	26.61	26.61	26.27	26.33	34018.0
2019-12-05	AAMC-DELISTED	Stock	3.8824	4.1176	3.8735	4.0156	65991.0
2019-12-05	AAME	Stock	1.7	1.7	1.55	1.55	9000.0
2019-12-05	AAMI	Stock	9.64	9.75	9.55	9.56	233300.0
2019-12-05	AAOI	Stock	10.48	10.605	10.37	10.46	286800.0
2019-12-05	AAON	Stock	32.3267	32.8	32.3067	32.7533	214050.0
2019-12-05	AAP	Stock	152.89	153.48	151.82	152.29	1603000.0
2019-12-05	AAT	Stock	47.52	47.63	47.1	47.51	262400.0
2019-12-05	AAU-DELISTED	Stock	0.54	0.55	0.531	0.5422	180919.0
2019-12-05	AAUAF-DELISTED	Stock	0.54	0.55	0.531	0.5422	191349.0
2019-12-05	AAWW-DELISTED	Stock	24.9	25.15	24.3	24.67	188303.0
2019-12-05	AAXJ	Stock	69.53	69.84	69.51	69.71	634868.0
2019-12-05	AAXN-DELISTED	Stock	72.36	73.874	72.02	72.86	273075.0
2019-12-05	AB	Stock	28.6	28.85	28.4	28.66	342300.0
2019-12-05	ABB-DELISTED	Stock	22.4	22.43	22.28	22.41	1663923.0
2019-12-05	ABBNY-DELISTED	Stock	22.4	22.43	22.28	22.42	1883148.0
2019-12-05	ABBV	Stock	87.25	87.25	86.26	86.72	6072100.0
2019-12-05	ABC-DELISTED	Stock	88.09	88.89	87.23	87.81	720002.0
2019-12-05	ABCB	Stock	43.33	43.64	43.19	43.23	354300.0
2019-12-05	ABDC-DELISTED	Stock	8.99	9.02	8.968	8.99	18169.0
2019-12-05	ABEO	Stock	73.0	77.25	68.75	69.0	37964.0
2019-12-05	ABEOW-DELISTED	Stock	0.08	0.08	0.08	0.08	1930.0
2019-12-05	ABEV	Stock	4.3	4.33	4.26	4.32	13638500.0
2019-12-05	ABG	Stock	110.38	112.25	109.35	109.49	166200.0
2019-12-05	ABIL-DELISTED	Stock	0.562	0.5899	0.501	0.5566	273724.0
2019-12-05	ABM	Stock	37.65	37.93	37.45	37.66	240000.0
2019-12-05	ABMD-DELISTED	Stock	194.04	195.46	188.71	188.99	239438.0
2019-12-05	ABR	Stock	14.9	14.93	14.68	14.72	1275300.0
2019-12-05	ABR.A-DELISTED	Stock	26.22	26.27	26.1	26.27	3649.0
2019-12-05	ABR.B-DELISTED	Stock	25.89	25.89	25.815	25.815	700.0
2019-12-05	ABR.C-DELISTED	Stock	26.1082	26.18	26.05	26.1147	2600.0
2019-12-05	ABT	Stock	85.12	85.42	84.33	85.24	3279900.0
2019-12-05	ABTC	Stock	328500.0	336390.0	300360.0	316200.0	12.266666666666666

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

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