PREVIEW / stock_daily / 2019-12-09

all stock daily files

  file:    by_date/stock_daily/2019/2019-12-09.parquet
  size:    222 KB
  rows:    6,585
  symbols: 2,444

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-09	AAPL	Stock	67.5	67.7	66.2275	66.73	128042400.0
2019-12-09	MSFT	Stock	151.07	152.21	150.91	151.36	16687400.0
2019-12-09	NVDA	Stock	5.2812	5.3592	5.2725	5.3042	211880000.0
2019-12-09	AMZN	Stock	87.533	88.3445	87.2805	87.4755	48856000.0
2019-12-09	GOOGL	Stock	66.943	67.8776	66.8035	67.1495	31137780.0
2019-12-09	META	Stock	200.65	203.14	200.21	201.34	11954800.0
2019-12-09	TSLA	Stock	22.4393	22.9633	22.3387	22.6353	135346500.0
2019-12-09	TLT	Stock	138.99	139.11	138.57	138.65	4155592.0
2019-12-09	ES	Stock	81.26	81.27	80.25	80.72	2030600.0
2019-12-09	CL	Stock	68.25	68.67	68.01	68.6	3610200.0
2019-12-09	A	Stock	82.34	82.47	81.55	81.62	1913800.0
2019-12-09	AA	Stock	20.67	20.81	20.12	20.25	5420600.0
2019-12-09	AACG	Stock	1.62	1.66	1.62	1.62	5400.0
2019-12-09	AAIC-DELISTED	Stock	5.92	5.97	5.86	5.89	370287.0
2019-12-09	AAIC.C-DELISTED	Stock	22.0561	22.063	21.951	21.9665	6688.0
2019-12-09	AAL	Stock	27.62	27.83	27.46	27.49	4474400.0
2019-12-09	AAM.A-DELISTED	Stock	26.1064	26.21	26.1064	26.19	14920.0
2019-12-09	AAM.B-DELISTED	Stock	26.5547	26.61	26.425	26.59	8836.0
2019-12-09	AAMC-DELISTED	Stock	4.1176	4.2206	3.9853	4.0294	55199.0
2019-12-09	AAME	Stock	1.99	2.0	1.75	2.0	4800.0
2019-12-09	AAMI	Stock	9.83	10.19	9.83	10.12	492100.0
2019-12-09	AAOI	Stock	10.36	10.45	10.19	10.32	351000.0
2019-12-09	AAON	Stock	33.4267	33.7667	32.8867	32.9467	290550.0
2019-12-09	AAP	Stock	154.24	154.44	150.5	151.57	1900000.0
2019-12-09	AAT	Stock	47.39	47.69	47.17	47.66	390300.0
2019-12-09	AAU-DELISTED	Stock	0.5051	0.515	0.4825	0.4975	233135.0
2019-12-09	AAUAF-DELISTED	Stock	0.5051	0.515	0.4825	0.4975	275763.0
2019-12-09	AAWW-DELISTED	Stock	25.89	26.6	25.86	26.52	206542.0
2019-12-09	AAXJ	Stock	70.06	70.24	69.78	69.82	355971.0
2019-12-09	AAXN-DELISTED	Stock	71.89	73.7	71.52	72.3	425613.0
2019-12-09	AB	Stock	28.9	29.15	28.45	28.67	969300.0
2019-12-09	ABB-DELISTED	Stock	22.58	22.73	22.47	22.685	3320087.0
2019-12-09	ABBNY-DELISTED	Stock	22.58	22.73	22.47	22.68	3465920.0
2019-12-09	ABBV	Stock	87.22	87.72	86.38	86.44	5582700.0
2019-12-09	ABC-DELISTED	Stock	88.24	88.24	86.28	86.38	616020.0
2019-12-09	ABCB	Stock	43.14	43.53	43.03	43.34	274800.0
2019-12-09	ABDC-DELISTED	Stock	8.96	9.07	8.93	9.03	20740.0
2019-12-09	ABEO	Stock	80.0	85.5	73.0	73.5	148440.0
2019-12-09	ABEOW-DELISTED	Stock	0.066	0.13	0.066	0.13	1789.0
2019-12-09	ABEV	Stock	4.38	4.46	4.36	4.43	12547200.0
2019-12-09	ABG	Stock	110.45	111.31	110.05	110.1	215200.0
2019-12-09	ABIL-DELISTED	Stock	0.61	0.61	0.53	0.583	177128.0
2019-12-09	ABM	Stock	38.04	38.34	37.96	38.16	322100.0
2019-12-09	ABMD-DELISTED	Stock	189.3	189.83	179.54	181.64	520328.0
2019-12-09	ABR	Stock	14.81	14.87	14.76	14.77	584600.0
2019-12-09	ABR.A-DELISTED	Stock	26.27	26.27	26.27	26.27	740.0
2019-12-09	ABR.B-DELISTED	Stock	25.69	25.7569	25.67	25.7569	1266.0
2019-12-09	ABR.C-DELISTED	Stock	26.28	26.28	26.28	26.28	487.0
2019-12-09	ABT	Stock	85.12	85.42	83.83	83.87	4227000.0
2019-12-09	ABTC	Stock	312000.0	370200.0	312000.0	353700.0	12.0

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

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