PREVIEW / stock_daily / 2015-07-07

all stock daily files

  file:    by_date/stock_daily/2015/2015-07-07.parquet
  size:    225 KB
  rows:    6,683
  symbols: 3,502

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
2015-07-07	AAPL	Stock	31.4725	31.5375	30.9425	31.4225	187787200.0
2015-07-07	MSFT	Stock	44.34	44.49	43.32	44.3	36435800.0
2015-07-07	NVDA	Stock	0.5013	0.5032	0.479	0.4948	594252000.0
2015-07-07	AMZN	Stock	21.784	21.8865	21.2785	21.836	69084000.0
2015-07-07	GOOGL	Stock	27.3715	27.55	26.9925	27.5015	33595180.0
2015-07-07	META	Stock	87.8	87.85	85.23	87.22	33059900.0
2015-07-07	TSLA	Stock	18.3333	18.3467	17.3847	17.8587	91576500.0
2015-07-07	TLT	Stock	119.66	120.49	118.95	119.26	16160105.0
2015-07-07	ES	Stock	46.55	47.75	46.53	47.38	3802800.0
2015-07-07	CL	Stock	66.14	67.38	65.96	67.31	2893500.0
2015-07-07	A	Stock	39.53	39.79	39.14	39.79	2927800.0
2015-07-07	AA.B-DELISTED	Stock	39.6799	40.25	38.6601	40.25	20361.0
2015-07-07	AABA-DELISTED	Stock	38.24	38.38	36.575	38.23	18415159.0
2015-07-07	AAC-DELISTED	Stock	45.35	45.35	42.7	43.19	265493.0
2015-07-07	AACG	Stock	5.0	5.1	4.45	4.9	65100.0
2015-07-07	AAIC-DELISTED	Stock	19.8	19.98	19.71	19.95	355298.0
2015-07-07	AAL	Stock	39.93	40.74	39.26	40.67	10375900.0
2015-07-07	AAMC-DELISTED	Stock	41.4853	41.8824	40.6029	41.3971	18734.0
2015-07-07	AAME	Stock	3.58	3.71	3.58	3.64	2800.0
2015-07-07	AAMI	Stock	17.49	17.49	16.91	17.35	370800.0
2015-07-07	AAOI	Stock	17.15	17.426	15.88	17.19	314100.0
2015-07-07	AAON	Stock	15.1733	15.1733	14.8667	15.08	168300.0
2015-07-07	AAP	Stock	164.74	165.2	161.68	163.53	1345100.0
2015-07-07	AAT	Stock	40.41	40.95	40.29	40.7	146400.0
2015-07-07	AAU-DELISTED	Stock	0.8001	0.81	0.78	0.8099	151028.0
2015-07-07	AAUAF-DELISTED	Stock	0.8001	0.81	0.78	0.81	156001.0
2015-07-07	AAV-DELISTED	Stock	6.41	6.41	6.15	6.32	86814.0
2015-07-07	AAVL-DELISTED	Stock	16.32	16.42	15.77	15.96	424473.0
2015-07-07	AAWW-DELISTED	Stock	54.71	55.01	53.25	54.17	267062.0
2015-07-07	AAXJ	Stock	60.3	60.68	59.65	60.63	3519737.0
2015-07-07	AAXN-DELISTED	Stock	32.36	32.7	31.31	32.61	1346852.0
2015-07-07	AB	Stock	29.31	29.35	28.94	29.16	153800.0
2015-07-07	ABAC-DELISTED	Stock	1.14	1.3	1.03	1.06	70818.0
2015-07-07	ABAX-DELISTED	Stock	51.05	51.55	50.23	51.25	68205.0
2015-07-07	ABB-DELISTED	Stock	20.16	20.51	19.96	20.46	4122168.0
2015-07-07	ABBNY-DELISTED	Stock	20.16	20.51	19.96	20.46	5525996.0
2015-07-07	ABBV	Stock	68.42	68.79	67.32	68.56	7821600.0
2015-07-07	ABC-DELISTED	Stock	108.74	108.79	107.01	108.6	1007866.0
2015-07-07	ABCB	Stock	25.29	25.5	24.75	25.41	127100.0
2015-07-07	ABCD-DELISTED	Stock	4.75	4.818	4.57	4.66	479968.0
2015-07-07	ABCO-DELISTED	Stock	54.34	55.07	53.69	54.77	273418.0
2015-07-07	ABCW-DELISTED	Stock	40.95	41.24	40.46	41.21	29014.0
2015-07-07	ABDC-DELISTED	Stock	12.4	12.5	12.1	12.35	36941.0
2015-07-07	ABE-DELISTED	Stock	12.68	12.68	12.53	12.56	5249.0
2015-07-07	ABEO	Stock	116.25	121.25	115.5	120.75	16788.0
2015-07-07	ABEOW-DELISTED	Stock	1.24	1.95	1.24	1.65	9229.0
2015-07-07	ABEV	Stock	6.03	6.06	5.93	6.01	13366400.0
2015-07-07	ABG	Stock	91.0	91.84	89.95	91.78	262300.0
2015-07-07	ABGB-DELISTED	Stock	15.28	15.76	15.11	15.72	17656.0
2015-07-07	ABIL-DELISTED	Stock	9.97	9.97	9.9001	9.95	222927.0

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

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