PREVIEW / stock_daily / 2019-11-19

all stock daily files

  file:    by_date/stock_daily/2019/2019-11-19.parquet
  size:    222 KB
  rows:    6,628
  symbols: 2,472

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-19	AAPL	Stock	66.975	67.0	66.3475	66.5725	76167200.0
2019-11-19	MSFT	Stock	150.88	151.33	150.2	150.39	23935700.0
2019-11-19	NVDA	Stock	5.2758	5.2995	5.1412	5.1998	414564000.0
2019-11-19	AMZN	Stock	87.8495	88.034	87.1515	87.6395	45416000.0
2019-11-19	GOOGL	Stock	66.3315	66.3315	65.5885	65.6295	21872580.0
2019-11-19	META	Stock	197.4	200.0	196.86	199.32	19056800.0
2019-11-19	TSLA	Stock	23.45	23.9993	23.1867	23.968	115872000.0
2019-11-19	TLT	Stock	138.37	139.24	138.37	139.16	7893300.0
2019-11-19	ES	Stock	81.88	82.64	81.53	82.2	1794200.0
2019-11-19	CL	Stock	67.13	67.31	66.52	67.16	3710400.0
2019-11-19	A	Stock	78.17	79.49	77.84	79.29	1704800.0
2019-11-19	AA	Stock	21.03	21.032	20.44	20.57	2341100.0
2019-11-19	AACG	Stock	1.7	1.74	1.7	1.74	6000.0
2019-11-19	AAIC-DELISTED	Stock	5.72	5.77	5.7	5.7	235170.0
2019-11-19	AAIC.C-DELISTED	Stock	21.872	21.88	21.73	21.86	3729.0
2019-11-19	AAL	Stock	28.93	29.38	28.73	29.29	5965500.0
2019-11-19	AAM.A-DELISTED	Stock	26.595	26.65	26.551	26.6	6355.0
2019-11-19	AAM.B-DELISTED	Stock	26.92	27.03	26.9	27.02	20121.0
2019-11-19	AAMC-DELISTED	Stock	3.5353	3.75	3.5353	3.75	6504.0
2019-11-19	AAME	Stock	1.6	1.73	1.6	1.72	6400.0
2019-11-19	AAMI	Stock	9.63	9.71	9.44	9.62	253100.0
2019-11-19	AAOI	Stock	10.55	10.55	10.02	10.25	624500.0
2019-11-19	AAON	Stock	33.5667	33.9133	33.5667	33.7933	154950.0
2019-11-19	AAP	Stock	163.22	163.62	161.22	161.98	714500.0
2019-11-19	AAT	Stock	47.16	47.16	46.8	47.02	214700.0
2019-11-19	AAU-DELISTED	Stock	0.53	0.5309	0.5159	0.5188	178385.0
2019-11-19	AAUAF-DELISTED	Stock	0.53	0.5309	0.5159	0.5167	188280.0
2019-11-19	AAWW-DELISTED	Stock	25.2	25.33	24.4	25.33	191878.0
2019-11-19	AAXJ	Stock	70.8	70.8	70.45	70.57	615938.0
2019-11-19	AAXN-DELISTED	Stock	67.87	69.11	67.64	68.49	431671.0
2019-11-19	AB	Stock	29.6	29.63	29.33	29.44	156500.0
2019-11-19	ABB-DELISTED	Stock	22.05	22.05	21.89	21.91	1125943.0
2019-11-19	ABBNY-DELISTED	Stock	22.05	22.05	21.89	21.91	1183178.0
2019-11-19	ABBV	Stock	89.26	90.41	88.91	89.02	7504800.0
2019-11-19	ABC-DELISTED	Stock	87.57	88.14	87.0	87.82	507800.0
2019-11-19	ABCB	Stock	43.25	43.44	42.85	43.33	277600.0
2019-11-19	ABDC-DELISTED	Stock	8.9606	9.02	8.934	9.02	19019.0
2019-11-19	ABEO	Stock	55.0	59.25	55.0	58.25	7648.0
2019-11-19	ABEOW-DELISTED	Stock	0.1	0.1	0.1	0.1	900.0
2019-11-19	ABEV	Stock	4.15	4.2	4.12	4.2	12610300.0
2019-11-19	ABG	Stock	111.02	111.06	109.43	109.5	142800.0
2019-11-19	ABIL-DELISTED	Stock	0.35	0.35	0.3031	0.3251	77173.0
2019-11-19	ABM	Stock	38.5	38.95	38.33	38.76	215600.0
2019-11-19	ABMD-DELISTED	Stock	180.0	189.09	172.09	184.34	1754662.0
2019-11-19	ABR	Stock	15.04	15.15	15.03	15.06	919000.0
2019-11-19	ABR.A-DELISTED	Stock	25.92	25.9292	25.8458	25.85	5526.0
2019-11-19	ABR.B-DELISTED	Stock	25.6	25.6	25.52	25.5347	3819.0
2019-11-19	ABR.C-DELISTED	Stock	26.15	26.15	25.77	25.88	15030.0
2019-11-19	ABT	Stock	84.62	84.64	83.9	84.29	4152100.0
2019-11-19	ABTC	Stock	150300.0	154080.0	136500.0	150900.0	5.226666666666667

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

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