PREVIEW / stock_daily / 2019-12-16

all stock daily files

  file:    by_date/stock_daily/2019/2019-12-16.parquet
  size:    223 KB
  rows:    6,647
  symbols: 2,473

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-16	AAPL	Stock	69.25	70.1975	69.245	69.965	128186000.0
2019-12-16	MSFT	Stock	155.11	155.9	154.82	155.53	24144200.0
2019-12-16	NVDA	Stock	5.6475	5.7015	5.6193	5.6288	320976000.0
2019-12-16	AMZN	Stock	88.35	88.475	87.8525	88.4605	62904000.0
2019-12-16	GOOGL	Stock	67.75	68.1765	67.5305	68.035	28129140.0
2019-12-16	META	Stock	195.27	199.12	194.81	197.92	14911500.0
2019-12-16	TSLA	Stock	24.17	25.574	24.1667	25.4333	272613000.0
2019-12-16	TLT	Stock	138.4	138.46	137.43	137.79	9160997.0
2019-12-16	ES	Stock	81.48	82.05	81.19	82.05	1439100.0
2019-12-16	CL	Stock	68.84	69.23	68.52	68.87	3371200.0
2019-12-16	A	Stock	84.47	84.97	84.0	84.45	1371200.0
2019-12-16	AA	Stock	20.99	21.395	20.88	20.98	3211800.0
2019-12-16	AACG	Stock	1.45	1.52	1.45	1.5	12300.0
2019-12-16	AAIC-DELISTED	Stock	5.82	5.83	5.45	5.53	1566620.0
2019-12-16	AAIC.C-DELISTED	Stock	21.6	21.61	21.45	21.45	8431.0
2019-12-16	AAL	Stock	27.62	28.35	27.6	27.92	6997300.0
2019-12-16	AAM.A-DELISTED	Stock	26.67	26.67	26.507	26.58	27477.0
2019-12-16	AAM.B-DELISTED	Stock	27.19	27.19	26.92	27.0829	23992.0
2019-12-16	AAMC-DELISTED	Stock	4.1912	4.1912	3.9676	4.0914	13382.0
2019-12-16	AAME	Stock	1.77	1.84	1.76	1.82	6900.0
2019-12-16	AAMI	Stock	10.28	10.54	9.98	10.02	1362500.0
2019-12-16	AAOI	Stock	11.0	11.28	10.99	11.07	471000.0
2019-12-16	AAON	Stock	33.6	33.6667	32.5467	32.6933	283500.0
2019-12-16	AAP	Stock	155.47	155.62	153.4	153.5	659200.0
2019-12-16	AAT	Stock	44.73	44.94	44.34	44.89	470400.0
2019-12-16	AAU-DELISTED	Stock	0.51	0.53	0.5071	0.5185	242458.0
2019-12-16	AAUAF-DELISTED	Stock	0.51	0.53	0.5071	0.5185	263129.0
2019-12-16	AAWW-DELISTED	Stock	28.0	28.545	27.65	27.77	297551.0
2019-12-16	AAXJ	Stock	72.01	72.18	71.9	72.02	1848493.0
2019-12-16	AAXN-DELISTED	Stock	72.7	74.66	72.68	73.17	530340.0
2019-12-16	AB	Stock	30.25	30.92	30.12	30.23	491300.0
2019-12-16	ABB-DELISTED	Stock	23.78	23.9	23.74	23.79	1814189.0
2019-12-16	ABBNY-DELISTED	Stock	23.79	23.9	23.74	23.79	1901313.0
2019-12-16	ABBV	Stock	88.38	90.12	88.26	89.43	6723300.0
2019-12-16	ABC-DELISTED	Stock	85.43	86.66	85.04	85.95	795372.0
2019-12-16	ABCB	Stock	44.39	44.9	44.39	44.57	417400.0
2019-12-16	ABDC-DELISTED	Stock	9.13	9.2	9.11	9.13	37899.0
2019-12-16	ABEO	Stock	92.0	108.5	88.25	105.5	51684.0
2019-12-16	ABEOW-DELISTED	Stock	0.04	0.16	0.0322	0.149	13289.0
2019-12-16	ABEV	Stock	4.68	4.72	4.65	4.67	14832600.0
2019-12-16	ABG	Stock	117.25	117.97	115.06	115.71	198800.0
2019-12-16	ABIL-DELISTED	Stock	0.55	0.5801	0.5213	0.525	108697.0
2019-12-16	ABM	Stock	37.52	37.93	37.38	37.48	443700.0
2019-12-16	ABMD-DELISTED	Stock	179.09	179.99	172.279	176.32	537018.0
2019-12-16	ABR	Stock	14.2	14.42	14.2	14.21	914600.0
2019-12-16	ABR.A-DELISTED	Stock	26.14	26.35	26.13	26.2757	2240.0
2019-12-16	ABR.B-DELISTED	Stock	25.75	25.79	25.67	25.7498	20085.0
2019-12-16	ABR.C-DELISTED	Stock	26.07	26.97	26.07	26.79	10528.0
2019-12-16	ABT	Stock	86.95	87.1	86.3	86.4	3843700.0
2019-12-16	ABTC	Stock	348300.0	357000.0	324300.0	328800.0	6.066666666666666

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

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