PREVIEW / stock_daily / 2019-05-09

all stock daily files

  file:    by_date/stock_daily/2019/2019-05-09.parquet
  size:    219 KB
  rows:    6,514
  symbols: 2,562

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-05-09	AAPL	Stock	50.1	50.42	49.165	50.18	139634400.0
2019-05-09	MSFT	Stock	124.29	125.79	123.57	125.5	27235800.0
2019-05-09	NVDA	Stock	4.2785	4.2883	4.135	4.2548	660248000.0
2019-05-09	AMZN	Stock	95.0	95.47	93.8	94.9935	106166000.0
2019-05-09	GOOGL	Stock	58.13	58.7035	57.732	58.3985	29555040.0
2019-05-09	META	Stock	187.2	189.77	186.26	188.65	12967000.0
2019-05-09	TSLA	Stock	16.1333	16.2453	15.796	16.132	100671000.0
2019-05-09	TLT	Stock	125.11	125.3	124.31	124.92	9412288.0
2019-05-09	ES	Stock	70.5	70.88	70.06	70.45	984500.0
2019-05-09	CL	Stock	70.74	71.08	70.31	70.85	2415200.0
2019-05-09	A	Stock	75.67	77.06	74.85	77.0	1717500.0
2019-05-09	AA	Stock	24.4	24.9	23.88	24.81	2633800.0
2019-05-09	AABA-DELISTED	Stock	71.21	72.88	70.05	72.3515	6219509.0
2019-05-09	AAC-DELISTED	Stock	1.65	2.1	1.65	1.9	269348.0
2019-05-09	AACG	Stock	2.01	2.1	1.91	1.91	473300.0
2019-05-09	AAIC-DELISTED	Stock	7.62	7.62	7.5	7.59	374945.0
2019-05-09	AAIC.C-DELISTED	Stock	23.45	23.51	23.45	23.47	2874.0
2019-05-09	AAL	Stock	33.39	34.02	33.06	33.95	4500100.0
2019-05-09	AAM.A-DELISTED	Stock	25.5591	25.59	25.5101	25.59	17336.0
2019-05-09	AAM.B-DELISTED	Stock	25.5	25.55	25.5	25.55	27884.0
2019-05-09	AAMC-DELISTED	Stock	6.7941	7.1294	6.4399	7.0265	38536.0
2019-05-09	AAMI	Stock	13.67	13.72	13.52	13.63	239700.0
2019-05-09	AAOI	Stock	11.12	11.6	10.425	10.93	2239600.0
2019-05-09	AAON	Stock	31.24	31.98	31.1333	31.6467	169050.0
2019-05-09	AAP	Stock	157.32	160.01	156.18	159.89	883600.0
2019-05-09	AAT	Stock	45.21	45.57	44.71	45.31	182700.0
2019-05-09	AAU-DELISTED	Stock	0.4819	0.4836	0.46	0.46	290894.0
2019-05-09	AAUAF-DELISTED	Stock	0.4819	0.4836	0.46	0.46	293800.0
2019-05-09	AAWW-DELISTED	Stock	42.54	42.97	42.06	42.24	147805.0
2019-05-09	AAXJ	Stock	68.04	68.745	67.46	68.45	3213644.0
2019-05-09	AAXN-DELISTED	Stock	66.49	67.2967	65.02	66.61	683191.0
2019-05-09	AB	Stock	28.6	29.06	28.25	28.99	233500.0
2019-05-09	ABB-DELISTED	Stock	18.85	19.06	18.8	19.01	1953998.0
2019-05-09	ABBNY-DELISTED	Stock	18.85	19.06	18.8	19.0	2036395.0
2019-05-09	ABBV	Stock	77.51	78.13	76.73	77.91	3792200.0
2019-05-09	ABC-DELISTED	Stock	77.73	79.79	77.17	79.18	1178998.0
2019-05-09	ABCB	Stock	35.85	36.56	35.42	36.48	171100.0
2019-05-09	ABDC-DELISTED	Stock	8.35	8.42	8.29	8.42	28166.0
2019-05-09	ABEO	Stock	193.75	196.5	190.25	194.25	12884.0
2019-05-09	ABEV	Stock	4.46	4.5	4.4	4.42	26688400.0
2019-05-09	ABG	Stock	78.98	80.45	78.33	80.26	124200.0
2019-05-09	ABIL-DELISTED	Stock	1.45	1.45	1.35	1.35	80351.0
2019-05-09	ABM	Stock	37.68	38.31	37.32	38.18	229200.0
2019-05-09	ABMD-DELISTED	Stock	257.0	263.5	252.71	261.87	499521.0
2019-05-09	ABR	Stock	12.9	12.96	12.61	12.89	2420700.0
2019-05-09	ABR.A-DELISTED	Stock	26.239	26.275	26.239	26.275	500.0
2019-05-09	ABR.B-DELISTED	Stock	25.85	25.85	25.7829	25.8233	1400.0
2019-05-09	ABR.C-DELISTED	Stock	26.38	26.48	26.38	26.48	5809.0
2019-05-09	ABT	Stock	75.66	76.48	74.88	76.42	3736700.0
2019-05-09	ABTC	Stock	305700.0	306000.0	304800.0	305100.0	0.6666666666666666

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

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