PREVIEW / stock_daily / 2016-06-23

all stock daily files

  file:    by_date/stock_daily/2016/2016-06-23.parquet
  size:    219 KB
  rows:    6,576
  symbols: 3,280

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
2016-06-23	AAPL	Stock	23.985	24.0725	23.8125	24.025	128960800.0
2016-06-23	MSFT	Stock	51.28	52.06	51.15	51.91	29028800.0
2016-06-23	NVDA	Stock	1.192	1.2135	1.1912	1.2122	297880000.0
2016-06-23	AMZN	Stock	35.775	36.106	35.625	36.104	56500000.0
2016-06-23	GOOGL	Stock	35.5275	35.744	35.0125	35.7435	42500560.0
2016-06-23	META	Stock	114.37	115.09	113.54	115.08	16176900.0
2016-06-23	TSLA	Stock	13.046	13.17	12.8087	13.0933	151960500.0
2016-06-23	TLT	Stock	132.61	133.32	132.08	132.23	9029115.0
2016-06-23	ES	Stock	56.72	56.81	56.14	56.42	1770700.0
2016-06-23	CL	Stock	72.64	72.73	72.34	72.67	2015300.0
2016-06-23	A	Stock	46.5	46.68	46.39	46.68	1487900.0
2016-06-23	AA.B-DELISTED	Stock	34.497	35.1499	34.497	34.7039	18046.0
2016-06-23	AAAP-DELISTED	Stock	28.98	29.22	28.375	28.58	100748.0
2016-06-23	AABA-DELISTED	Stock	37.64	37.78	37.41	37.775	6648354.0
2016-06-23	AAC-DELISTED	Stock	20.22	20.54	19.81	20.47	69092.0
2016-06-23	AACG	Stock	5.15	5.32	4.96	4.96	3400.0
2016-06-23	AAIC-DELISTED	Stock	13.53	13.78	13.53	13.73	252258.0
2016-06-23	AAL	Stock	30.25	30.49	29.77	30.33	9139900.0
2016-06-23	AAMC-DELISTED	Stock	4.7912	4.9824	4.7647	4.7794	103227.0
2016-06-23	AAME	Stock	4.02	4.04	3.96	3.96	1100.0
2016-06-23	AAMI	Stock	14.47	14.91	14.46	14.53	659900.0
2016-06-23	AAOI	Stock	10.39	10.53	10.29	10.51	227000.0
2016-06-23	AAON	Stock	17.6333	17.92	17.6333	17.9067	155400.0
2016-06-23	AAP	Stock	154.44	155.11	153.71	154.93	831100.0
2016-06-23	AAT	Stock	40.87	41.12	40.85	41.04	98300.0
2016-06-23	AAU-DELISTED	Stock	1.17	1.24	1.17	1.2216	286676.0
2016-06-23	AAUAF-DELISTED	Stock	1.17	1.24	1.17	1.2216	287929.0
2016-06-23	AAV-DELISTED	Stock	5.59	5.61	5.5	5.53	51761.0
2016-06-23	AAWW-DELISTED	Stock	42.56	43.09	42.0	43.09	215160.0
2016-06-23	AAXJ	Stock	54.56	55.08	54.44	55.05	1001098.0
2016-06-23	AAXN-DELISTED	Stock	23.94	24.0834	23.7	23.95	546204.0
2016-06-23	AB	Stock	23.45	23.6	23.11	23.21	207500.0
2016-06-23	ABAC-DELISTED	Stock	0.7107	0.789	0.7107	0.78	1583.0
2016-06-23	ABAX-DELISTED	Stock	45.62	47.11	45.07	47.11	93012.0
2016-06-23	ABB-DELISTED	Stock	21.54	21.64	21.39	21.62	1311249.0
2016-06-23	ABBNY-DELISTED	Stock	21.54	21.64	21.39	21.62	1349096.0
2016-06-23	ABBV	Stock	60.86	61.32	60.62	61.31	5328200.0
2016-06-23	ABC-DELISTED	Stock	77.66	77.77	77.03	77.52	2065089.0
2016-06-23	ABCB	Stock	29.97	30.43	29.87	30.42	113200.0
2016-06-23	ABCD-DELISTED	Stock	4.59	4.61	4.55	4.6	38455.0
2016-06-23	ABCO-DELISTED	Stock	35.77	36.45	35.4801	35.77	340116.0
2016-06-23	ABDC-DELISTED	Stock	12.22	12.35	12.15	12.2	50716.0
2016-06-23	ABE-DELISTED	Stock	12.15	12.27	12.138	12.27	3896.0
2016-06-23	ABEO	Stock	69.0	69.0	65.0	67.75	2820.0
2016-06-23	ABEV	Stock	5.45	5.54	5.44	5.54	5416500.0
2016-06-23	ABG	Stock	55.16	56.04	54.82	55.8	117300.0
2016-06-23	ABIL-DELISTED	Stock	4.4	4.4	4.27	4.3499	17856.0
2016-06-23	ABM	Stock	36.65	36.93	36.53	36.78	396800.0
2016-06-23	ABMD-DELISTED	Stock	102.69	104.27	101.52	104.25	491476.0
2016-06-23	ABR	Stock	6.82	6.82	6.78	6.8	48400.0

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

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