PREVIEW / stock_daily / 2019-11-12

all stock daily files

  file:    by_date/stock_daily/2019/2019-11-12.parquet
  size:    221 KB
  rows:    6,574
  symbols: 2,451

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-11-12	AAPL	Stock	65.3875	65.6975	65.23	65.49	87388800.0
2019-11-12	MSFT	Stock	146.28	147.57	146.06	147.07	18641600.0
2019-11-12	NVDA	Stock	5.243	5.2965	5.2078	5.2403	283504000.0
2019-11-12	AMZN	Stock	88.733	89.311	88.5955	88.9	40752000.0
2019-11-12	GOOGL	Stock	64.9285	65.4675	64.712	64.8605	28886840.0
2019-11-12	META	Stock	190.0	195.06	189.74	194.47	17615500.0
2019-11-12	TSLA	Stock	23.1267	23.358	22.936	23.3287	110391000.0
2019-11-12	TLT	Stock	135.28	135.9499	134.788	135.62	5773630.0
2019-11-12	ES	Stock	79.27	79.53	78.9	79.19	1413700.0
2019-11-12	CL	Stock	66.67	66.97	66.53	66.64	3315900.0
2019-11-12	A	Stock	77.0	77.55	76.72	77.05	1008400.0
2019-11-12	AA	Stock	22.33	23.02	22.06	22.18	3105100.0
2019-11-12	AACG	Stock	1.71	1.72	1.7	1.7	8100.0
2019-11-12	AAIC-DELISTED	Stock	5.81	5.87	5.75	5.85	317440.0
2019-11-12	AAIC.C-DELISTED	Stock	21.6	21.9595	21.6	21.9028	6739.0
2019-11-12	AAL	Stock	30.58	30.67	29.4	29.52	8662900.0
2019-11-12	AAM.A-DELISTED	Stock	26.47	26.6	26.47	26.5	18717.0
2019-11-12	AAM.B-DELISTED	Stock	27.0	27.05	26.89	26.96	22348.0
2019-11-12	AAMC-DELISTED	Stock	3.6	3.6	3.2353	3.3609	14644.0
2019-11-12	AAME	Stock	1.82	1.92	1.66	1.76	11000.0
2019-11-12	AAMI	Stock	9.97	10.04	9.955	10.0	278100.0
2019-11-12	AAOI	Stock	12.2	12.58	11.26	11.66	1408700.0
2019-11-12	AAON	Stock	33.4667	33.7733	33.4133	33.5133	169500.0
2019-11-12	AAP	Stock	157.95	160.41	154.31	156.14	4357300.0
2019-11-12	AAT	Stock	47.04	47.25	46.17	46.26	201300.0
2019-11-12	AAU-DELISTED	Stock	0.45	0.46	0.43	0.45	362655.0
2019-11-12	AAUAF-DELISTED	Stock	0.45	0.46	0.43	0.45	371820.0
2019-11-12	AAWW-DELISTED	Stock	26.29	26.88	25.86	26.25	218363.0
2019-11-12	AAXJ	Stock	70.64	70.73	70.33	70.47	2760219.0
2019-11-12	AAXN-DELISTED	Stock	64.48	64.75	63.34	64.01	554502.0
2019-11-12	AB	Stock	29.36	29.9	29.25	29.63	407900.0
2019-11-12	ABB-DELISTED	Stock	21.75	21.91	21.7	21.825	1185769.0
2019-11-12	ABBNY-DELISTED	Stock	21.75	21.91	21.7	21.82	1238287.0
2019-11-12	ABBV	Stock	85.6	88.28	85.55	86.44	12165900.0
2019-11-12	ABC-DELISTED	Stock	84.5	86.49	84.11	85.53	833746.0
2019-11-12	ABCB	Stock	44.24	44.73	43.89	44.46	258600.0
2019-11-12	ABDC-DELISTED	Stock	8.94	9.02	8.76	9.02	45856.0
2019-11-12	ABEO	Stock	62.5	64.75	57.0	57.25	13000.0
2019-11-12	ABEOW-DELISTED	Stock	0.14	0.14	0.12	0.12	2680.0
2019-11-12	ABEV	Stock	4.13	4.16	4.11	4.13	11064500.0
2019-11-12	ABG	Stock	109.55	111.71	108.0	109.33	309700.0
2019-11-12	ABIL-DELISTED	Stock	0.4166	0.4166	0.389	0.3901	88343.0
2019-11-12	ABM	Stock	37.74	38.71	37.59	38.31	190600.0
2019-11-12	ABMD-DELISTED	Stock	220.4	227.28	218.36	223.36	354416.0
2019-11-12	ABR	Stock	15.05	15.09	14.81	14.91	1998900.0
2019-11-12	ABR.A-DELISTED	Stock	26.22	26.28	26.127	26.2399	2740.0
2019-11-12	ABR.B-DELISTED	Stock	26.1738	26.1738	26.1738	26.1738	547.0
2019-11-12	ABR.C-DELISTED	Stock	26.5653	26.5653	26.5653	26.5653	675.0
2019-11-12	ABT	Stock	83.66	84.78	83.66	84.34	3701400.0
2019-11-12	ABTC	Stock	123900.0	125700.0	115500.0	117000.0	1.7066666666666668

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

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