PREVIEW / stock_daily / 2016-06-06

all stock daily files

  file:    by_date/stock_daily/2016/2016-06-06.parquet
  size:    220 KB
  rows:    6,593
  symbols: 3,304

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-06	AAPL	Stock	24.4975	25.4725	24.3875	24.6575	93170000.0
2016-06-06	MSFT	Stock	51.99	52.35	51.89	52.13	18243300.0
2016-06-06	NVDA	Stock	1.165	1.174	1.15	1.156	322512000.0
2016-06-06	AMZN	Stock	36.325	36.575	36.221	36.3365	54096000.0
2016-06-06	GOOGL	Stock	36.925	36.925	36.4145	36.503	29992960.0
2016-06-06	META	Stock	118.62	119.43	118.36	118.79	12744700.0
2016-06-06	TSLA	Stock	14.5333	14.7267	14.3633	14.712	33742500.0
2016-06-06	TLT	Stock	132.78	132.89	132.105	132.24	7573732.0
2016-06-06	ES	Stock	56.16	56.34	55.58	55.82	1497500.0
2016-06-06	CL	Stock	71.6	72.07	71.41	71.84	2287900.0
2016-06-06	A	Stock	45.72	46.01	45.72	45.86	2359000.0
2016-06-06	AA.B-DELISTED	Stock	33.88	34.6	33.88	34.55	30738.0
2016-06-06	AAAP-DELISTED	Stock	30.96	30.96	30.1401	30.9	34313.0
2016-06-06	AABA-DELISTED	Stock	36.65	37.2	36.52	37.08	7978902.0
2016-06-06	AAC-DELISTED	Stock	21.39	21.96	20.99	21.75	153472.0
2016-06-06	AACG	Stock	5.31	5.36	5.07	5.34	29500.0
2016-06-06	AAIC-DELISTED	Stock	13.53	13.75	13.52	13.75	243832.0
2016-06-06	AAL	Stock	30.77	31.3	30.38	31.26	8335400.0
2016-06-06	AAMC-DELISTED	Stock	6.7441	8.5765	6.7206	7.1676	494125.0
2016-06-06	AAME	Stock	3.69	3.69	3.63	3.63	2200.0
2016-06-06	AAMI	Stock	15.0	15.1	14.76	14.8	322200.0
2016-06-06	AAOI	Stock	10.94	11.55	10.94	11.41	505700.0
2016-06-06	AAON	Stock	18.4133	18.5667	18.26	18.34	258300.0
2016-06-06	AAP	Stock	150.71	150.72	148.51	150.24	855200.0
2016-06-06	AAT	Stock	41.35	41.69	40.58	40.98	194800.0
2016-06-06	AAU-DELISTED	Stock	1.15	1.18	1.11	1.12	456372.0
2016-06-06	AAUAF-DELISTED	Stock	1.15	1.18	1.11	1.12	458418.0
2016-06-06	AAV-DELISTED	Stock	6.0	6.17	6.0	6.13	74892.0
2016-06-06	AAWW-DELISTED	Stock	42.76	45.39	42.76	45.13	472128.0
2016-06-06	AAXJ	Stock	54.3	54.82	54.295	54.7	814212.0
2016-06-06	AAXN-DELISTED	Stock	22.76	23.04	22.75	22.96	585660.0
2016-06-06	AB	Stock	23.51	23.97	23.51	23.74	183900.0
2016-06-06	ABAC-DELISTED	Stock	0.64	0.8	0.62	0.7126	48086.0
2016-06-06	ABAX-DELISTED	Stock	46.34	46.62	46.05	46.435	96228.0
2016-06-06	ABB-DELISTED	Stock	21.2	21.31	21.115	21.22	1373605.0
2016-06-06	ABBNY-DELISTED	Stock	21.2	21.31	21.115	21.22	1672223.0
2016-06-06	ABBV	Stock	62.13	62.99	61.87	62.82	16403400.0
2016-06-06	ABC-DELISTED	Stock	76.3	76.645	75.95	76.46	1331121.0
2016-06-06	ABCB	Stock	31.37	32.01	31.28	31.94	151700.0
2016-06-06	ABCD-DELISTED	Stock	4.63	4.69	4.63	4.64	8260.0
2016-06-06	ABCO-DELISTED	Stock	33.73	34.18	33.15	34.0	246391.0
2016-06-06	ABDC-DELISTED	Stock	12.26	12.3999	12.2366	12.25	30195.0
2016-06-06	ABE-DELISTED	Stock	12.26	12.46	12.05	12.43	20182.0
2016-06-06	ABEO	Stock	75.5	78.75	74.75	78.5	2028.0
2016-06-06	ABEOW-DELISTED	Stock	1.01	1.13	1.0	1.12	9000.0
2016-06-06	ABEV	Stock	5.53	5.56	5.5	5.54	8846000.0
2016-06-06	ABG	Stock	54.62	55.67	54.1	55.54	220000.0
2016-06-06	ABIL-DELISTED	Stock	3.3	3.74	3.28	3.66	86159.0
2016-06-06	ABM	Stock	34.2	34.29	34.04	34.11	248000.0
2016-06-06	ABMD-DELISTED	Stock	101.64	102.14	100.76	101.86	285393.0

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

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