PREVIEW / stock_daily / 2019-08-22

all stock daily files

  file:    by_date/stock_daily/2019/2019-08-22.parquet
  size:    219 KB
  rows:    6,574
  symbols: 2,515

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-08-22	AAPL	Stock	53.2975	53.61	52.6875	53.115	89014800.0
2019-08-22	MSFT	Stock	138.66	139.2	136.29	137.78	18697000.0
2019-08-22	NVDA	Stock	4.2905	4.3333	4.2475	4.287	303488000.0
2019-08-22	AMZN	Stock	91.4	91.4705	90.005	90.233	53070000.0
2019-08-22	GOOGL	Stock	59.69	59.939	58.9455	59.576	17358300.0
2019-08-22	META	Stock	183.43	184.11	179.91	182.04	10821400.0
2019-08-22	TSLA	Stock	14.8533	15.0267	14.548	14.81	98385000.0
2019-08-22	TLT	Stock	144.0	144.7	143.48	143.6	13880305.0
2019-08-22	ES	Stock	79.48	79.91	79.05	79.77	1408200.0
2019-08-22	CL	Stock	72.66	73.29	72.37	73.04	1526600.0
2019-08-22	A	Stock	72.45	72.77	71.25	71.74	1644000.0
2019-08-22	AA	Stock	18.46	18.545	17.905	18.05	2999300.0
2019-08-22	AABA-DELISTED	Stock	69.58	69.69	69.42	69.53	7022160.0
2019-08-22	AAC-DELISTED	Stock	0.632	0.65	0.5652	0.5902	252666.0
2019-08-22	AACG	Stock	1.83	1.99	1.82	1.89	103500.0
2019-08-22	AAIC-DELISTED	Stock	5.27	5.32	5.23	5.24	485203.0
2019-08-22	AAL	Stock	26.46	26.98	26.34	26.53	5957900.0
2019-08-22	AAM.A-DELISTED	Stock	26.7218	26.7852	26.66	26.7565	6686.0
2019-08-22	AAM.B-DELISTED	Stock	26.7686	26.93	26.74	26.87	20109.0
2019-08-22	AAMC-DELISTED	Stock	2.5471	2.9441	2.5471	2.9294	12294.0
2019-08-22	AAME	Stock	2.65	2.65	2.65	2.65	600.0
2019-08-22	AAMI	Stock	9.33	9.47	9.27	9.29	405600.0
2019-08-22	AAOI	Stock	9.65	9.8	9.35	9.38	256100.0
2019-08-22	AAON	Stock	31.8533	32.3533	31.28	31.4133	251700.0
2019-08-22	AAP	Stock	136.65	138.55	136.08	137.5	1306700.0
2019-08-22	AAT	Stock	46.9	47.27	46.59	47.22	134000.0
2019-08-22	AAU-DELISTED	Stock	0.77	0.785	0.7452	0.7797	165571.0
2019-08-22	AAUAF-DELISTED	Stock	0.77	0.785	0.7452	0.7797	175208.0
2019-08-22	AAWW-DELISTED	Stock	26.78	27.045	26.435	26.66	148413.0
2019-08-22	AAXJ	Stock	64.93	64.97	64.42	64.66	679498.0
2019-08-22	AAXN-DELISTED	Stock	60.53	62.625	60.35	62.38	525489.0
2019-08-22	AB	Stock	28.39	28.49	28.2	28.45	258400.0
2019-08-22	ABB-DELISTED	Stock	18.73	18.75	18.5535	18.64	696566.0
2019-08-22	ABBNY-DELISTED	Stock	18.73	18.75	18.5535	18.64	764831.0
2019-08-22	ABBV	Stock	67.87	68.03	66.81	67.52	6495700.0
2019-08-22	ABC-DELISTED	Stock	86.56	87.12	85.33	85.53	751356.0
2019-08-22	ABCB	Stock	36.92	37.07	36.43	36.7	166100.0
2019-08-22	ABDC-DELISTED	Stock	8.9	8.9	8.82	8.84	92839.0
2019-08-22	ABEO	Stock	55.5	55.75	51.0	51.0	17688.0
2019-08-22	ABEV	Stock	4.63	4.67	4.49	4.59	34970000.0
2019-08-22	ABG	Stock	90.93	92.03	90.37	91.25	88100.0
2019-08-22	ABIL-DELISTED	Stock	0.659	0.72	0.659	0.6601	91740.0
2019-08-22	ABM	Stock	38.86	39.16	38.39	38.46	221800.0
2019-08-22	ABMD-DELISTED	Stock	197.3	200.0	194.8	195.54	257773.0
2019-08-22	ABR	Stock	12.57	12.62	12.47	12.62	1001000.0
2019-08-22	ABR.A-DELISTED	Stock	25.85	25.9	25.85	25.9	1400.0
2019-08-22	ABR.B-DELISTED	Stock	25.63	25.77	25.62	25.7699	2285.0
2019-08-22	ABR.C-DELISTED	Stock	26.25	26.25	26.25	26.25	600.0
2019-08-22	ABT	Stock	84.92	85.31	83.64	84.37	3207000.0
2019-08-22	ABTC	Stock	284400.0	284400.0	259500.0	260700.0	2.3066666666666666

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

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