PREVIEW / stock_daily / 2016-06-22

all stock daily files

  file:    by_date/stock_daily/2016/2016-06-22.parquet
  size:    218 KB
  rows:    6,554
  symbols: 3,278

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-22	AAPL	Stock	24.0625	24.2225	23.8375	23.8875	116876400.0
2016-06-22	MSFT	Stock	51.08	51.46	50.95	50.99	28816800.0
2016-06-22	NVDA	Stock	1.1842	1.192	1.1788	1.1808	202620000.0
2016-06-22	AMZN	Stock	35.829	35.85	35.3785	35.53	45210000.0
2016-06-22	GOOGL	Stock	35.7025	35.7105	35.294	35.5235	29057680.0
2016-06-22	META	Stock	114.65	114.74	113.61	113.91	14846300.0
2016-06-22	TSLA	Stock	13.298	13.73	13.05	13.1107	356136000.0
2016-06-22	TLT	Stock	133.5	133.99	133.2539	133.76	5773676.0
2016-06-22	ES	Stock	57.3	57.3	56.69	56.69	1175200.0
2016-06-22	CL	Stock	71.98	72.5	71.88	72.25	3564600.0
2016-06-22	A	Stock	46.15	46.47	45.95	46.03	2411900.0
2016-06-22	AA.B-DELISTED	Stock	34.12	35.03	34.0801	34.45	77744.0
2016-06-22	AAAP-DELISTED	Stock	28.3	28.99	28.25	28.64	42265.0
2016-06-22	AABA-DELISTED	Stock	37.37	37.52	37.17	37.37	5403233.0
2016-06-22	AAC-DELISTED	Stock	19.67	20.32	19.28	19.93	144385.0
2016-06-22	AACG	Stock	5.15	5.19	5.0	5.0	4100.0
2016-06-22	AAIC-DELISTED	Stock	13.75	13.75	13.49	13.49	200711.0
2016-06-22	AAL	Stock	30.05	30.33	29.82	29.89	6675900.0
2016-06-22	AAMC-DELISTED	Stock	5.0765	5.2485	4.65	4.7147	131063.0
2016-06-22	AAME	Stock	3.96	3.96	3.95	3.95	900.0
2016-06-22	AAMI	Stock	14.46	14.612	14.16	14.27	219200.0
2016-06-22	AAOI	Stock	10.1	10.35	10.06	10.3	278600.0
2016-06-22	AAON	Stock	17.4267	17.6	17.3133	17.44	168300.0
2016-06-22	AAP	Stock	154.57	155.25	153.09	153.16	716800.0
2016-06-22	AAT	Stock	40.85	41.09	40.78	40.84	104100.0
2016-06-22	AAU-DELISTED	Stock	1.2	1.24	1.16	1.177	229229.0
2016-06-22	AAUAF-DELISTED	Stock	1.2	1.24	1.16	1.177	232570.0
2016-06-22	AAV-DELISTED	Stock	5.68	5.68	5.46	5.51	59034.0
2016-06-22	AAWW-DELISTED	Stock	43.35	43.35	41.555	42.05	292928.0
2016-06-22	AAXJ	Stock	54.16	54.38	53.98	53.99	952925.0
2016-06-22	AAXN-DELISTED	Stock	23.24	23.88	23.22	23.68	792893.0
2016-06-22	AB	Stock	23.03	23.31	22.96	23.23	142200.0
2016-06-22	ABAC-DELISTED	Stock	0.79	0.79	0.7299	0.73	12545.0
2016-06-22	ABAX-DELISTED	Stock	46.11	46.64	45.27	45.29	60218.0
2016-06-22	ABB-DELISTED	Stock	21.36	21.42	21.235	21.26	1282266.0
2016-06-22	ABBNY-DELISTED	Stock	21.36	21.42	21.235	21.26	1328472.0
2016-06-22	ABBV	Stock	60.0	61.18	59.92	60.39	6718600.0
2016-06-22	ABC-DELISTED	Stock	76.57	77.48	76.07	77.09	1767294.0
2016-06-22	ABCB	Stock	29.47	29.97	29.47	29.58	129800.0
2016-06-22	ABCD-DELISTED	Stock	4.6	4.6	4.55	4.58	25750.0
2016-06-22	ABCO-DELISTED	Stock	35.06	35.76	34.82	35.49	383013.0
2016-06-22	ABDC-DELISTED	Stock	12.38	12.39	12.15	12.18	65907.0
2016-06-22	ABE-DELISTED	Stock	12.07	12.125	12.03	12.03	1531.0
2016-06-22	ABEO	Stock	68.5	69.5	62.5	67.0	1632.0
2016-06-22	ABEV	Stock	5.45	5.47	5.36	5.37	11628600.0
2016-06-22	ABG	Stock	55.01	55.13	54.24	54.35	246800.0
2016-06-22	ABIL-DELISTED	Stock	4.3	4.43	4.2101	4.4	22649.0
2016-06-22	ABM	Stock	36.54	36.71	36.3	36.36	240600.0
2016-06-22	ABMD-DELISTED	Stock	101.49	103.11	101.037	101.7	344685.0
2016-06-22	ABR	Stock	6.77	6.84	6.77	6.8	71400.0

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

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