PREVIEW / stock_daily / 2019-11-21

all stock daily files

  file:    by_date/stock_daily/2019/2019-11-21.parquet
  size:    221 KB
  rows:    6,597
  symbols: 2,447

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-21	AAPL	Stock	65.9225	66.0025	65.295	65.5025	121395200.0
2019-11-21	MSFT	Stock	149.4	149.8	148.5	149.48	18576100.0
2019-11-21	NVDA	Stock	5.275	5.331	5.2328	5.2545	288388000.0
2019-11-21	AMZN	Stock	87.15	87.3435	86.518	86.7355	53258000.0
2019-11-21	GOOGL	Stock	64.9625	65.556	64.5375	65.007	25546760.0
2019-11-21	META	Stock	197.42	199.09	196.86	197.93	12131000.0
2019-11-21	TSLA	Stock	23.634	24.056	23.6	23.6553	91650000.0
2019-11-21	TLT	Stock	139.64	140.08	139.12	139.72	5981899.0
2019-11-21	ES	Stock	82.49	82.84	81.24	82.22	2851000.0
2019-11-21	CL	Stock	67.52	67.7	66.71	66.75	3432900.0
2019-11-21	A	Stock	78.97	78.97	77.31	78.3	2142200.0
2019-11-21	AA	Stock	20.43	20.7	20.105	20.15	2470200.0
2019-11-21	AACG	Stock	1.81	1.87	1.75	1.85	59700.0
2019-11-21	AAIC-DELISTED	Stock	5.67	5.72	5.6589	5.69	231063.0
2019-11-21	AAIC.C-DELISTED	Stock	21.87	21.87	21.44	21.7	5740.0
2019-11-21	AAL	Stock	28.27	28.48	27.84	27.93	6071800.0
2019-11-21	AAM.A-DELISTED	Stock	26.5316	26.59	26.509	26.5568	8127.0
2019-11-21	AAM.B-DELISTED	Stock	27.07	27.07	26.9565	27.05	9156.0
2019-11-21	AAMC-DELISTED	Stock	3.6706	3.747	3.5661	3.7059	7796.0
2019-11-21	AAME	Stock	1.79	2.0	1.46	2.0	3600.0
2019-11-21	AAMI	Stock	9.51	9.53	9.34	9.45	426900.0
2019-11-21	AAOI	Stock	10.27	10.31	9.85	10.2	483200.0
2019-11-21	AAON	Stock	33.0667	33.0667	31.8267	32.2467	387000.0
2019-11-21	AAP	Stock	162.15	163.18	158.2	158.33	635900.0
2019-11-21	AAT	Stock	46.73	46.85	45.88	46.11	497800.0
2019-11-21	AAU-DELISTED	Stock	0.5	0.5	0.4629	0.47	265565.0
2019-11-21	AAUAF-DELISTED	Stock	0.5	0.5	0.4629	0.47	270790.0
2019-11-21	AAWW-DELISTED	Stock	24.55	24.815	24.06	24.4	181828.0
2019-11-21	AAXJ	Stock	69.69	69.82	69.53	69.82	649143.0
2019-11-21	AAXN-DELISTED	Stock	72.0	73.07	71.225	71.85	746492.0
2019-11-21	AB	Stock	29.28	29.44	29.02	29.23	125900.0
2019-11-21	ABB-DELISTED	Stock	21.76	21.78	21.645	21.705	1476962.0
2019-11-21	ABBNY-DELISTED	Stock	21.76	21.78	21.645	21.69	1554037.0
2019-11-21	ABBV	Stock	86.79	86.87	85.55	86.52	9614100.0
2019-11-21	ABC-DELISTED	Stock	87.57	88.71	87.01	88.33	788289.0
2019-11-21	ABCB	Stock	43.54	43.54	42.43	42.81	304600.0
2019-11-21	ABDC-DELISTED	Stock	8.97	9.05	8.9378	9.03	23110.0
2019-11-21	ABEO	Stock	61.0	62.25	58.25	60.5	7140.0
2019-11-21	ABEV	Stock	4.24	4.29	4.2	4.28	14742500.0
2019-11-21	ABG	Stock	109.07	109.44	107.08	108.93	128600.0
2019-11-21	ABIL-DELISTED	Stock	0.345	0.36	0.32	0.33	111982.0
2019-11-21	ABM	Stock	38.77	38.78	37.83	37.91	168500.0
2019-11-21	ABMD-DELISTED	Stock	185.52	188.0	178.74	186.58	536687.0
2019-11-21	ABR	Stock	15.17	15.17	14.92	14.92	803500.0
2019-11-21	ABR.A-DELISTED	Stock	25.8	25.85	25.8	25.8	4002.0
2019-11-21	ABR.B-DELISTED	Stock	25.68	25.69	25.6387	25.6436	900.0
2019-11-21	ABR.C-DELISTED	Stock	25.9354	26.17	25.71	26.0313	2570.0
2019-11-21	ABT	Stock	83.72	83.8	82.36	83.68	5211400.0
2019-11-21	ABTC	Stock	144600.0	172500.0	142800.0	160500.0	7.533333333333333
2019-11-21	ABTS	Stock	35.25	36.3	34.05	36.3	1433.0

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

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