PREVIEW / stock_daily / 2014-09-19

all stock daily files

  file:    by_date/stock_daily/2014/2014-09-19.parquet
  size:    224 KB
  rows:    6,657
  symbols: 3,590

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
2014-09-19	AAPL	Stock	25.5725	25.5875	25.125	25.24	283609600.0
2014-09-19	MSFT	Stock	46.81	47.57	46.6	47.52	202522400.0
2014-09-19	NVDA	Stock	0.4875	0.488	0.4763	0.477	601316000.0
2014-09-19	AMZN	Stock	16.38	16.638	16.2785	16.566	137724000.0
2014-09-19	GOOGL	Stock	29.9745	30.27	29.888	30.27	83892600.0
2014-09-19	META	Stock	77.4	78.3	76.44	77.91	76671000.0
2014-09-19	TSLA	Stock	17.1993	17.4287	17.018	17.288	102163500.0
2014-09-19	TLT	Stock	113.58	114.68	113.2	114.6	13237138.0
2014-09-19	ES	Stock	45.46	45.57	45.25	45.45	1926400.0
2014-09-19	CL	Stock	65.6	65.67	65.23	65.28	5260800.0
2014-09-19	A	Stock	42.0744	42.1888	41.5594	41.6667	3039252.0
2014-09-19	AABA-DELISTED	Stock	42.42	43.19	39.55	40.93	227364425.0
2014-09-19	AACG	Stock	4.43	4.53	4.4	4.41	30300.0
2014-09-19	AAIC-DELISTED	Stock	27.3	27.55	27.2199	27.49	471584.0
2014-09-19	AAL	Stock	38.06	38.25	36.63	36.63	17589900.0
2014-09-19	AAMC-DELISTED	Stock	206.5529	213.6706	206.5529	211.9559	55634.0
2014-09-19	AAME	Stock	3.88	3.9	3.63	3.63	8500.0
2014-09-19	AAOI	Stock	18.56	18.72	17.79	18.08	172000.0
2014-09-19	AAON	Stock	12.4667	12.4667	12.1933	12.22	301950.0
2014-09-19	AAP	Stock	133.73	133.73	131.38	131.76	989600.0
2014-09-19	AAT	Stock	33.36	33.69	33.17	33.55	208700.0
2014-09-19	AAU-DELISTED	Stock	1.48	1.5407	1.4	1.42	261588.0
2014-09-19	AAUAF-DELISTED	Stock	1.46	1.52	1.4	1.42	266461.0
2014-09-19	AAV-DELISTED	Stock	5.5	5.51	5.26	5.32	404668.0
2014-09-19	AAVL-DELISTED	Stock	31.53	32.141	30.5	31.0	314600.0
2014-09-19	AAWW-DELISTED	Stock	36.17	36.25	34.64	35.11	313367.0
2014-09-19	AAXJ	Stock	64.26	64.26	63.66	63.85	378509.0
2014-09-19	AAXN-DELISTED	Stock	17.07	17.07	16.08	16.14	2847763.0
2014-09-19	AB	Stock	27.61	27.68	27.16	27.47	134300.0
2014-09-19	ABAC-DELISTED	Stock	1.95	1.96	1.8201	1.96	63156.0
2014-09-19	ABAX-DELISTED	Stock	53.13	53.98	52.68	52.86	246167.0
2014-09-19	ABB-DELISTED	Stock	23.16	23.17	22.94	23.0	1311748.0
2014-09-19	ABBNY-DELISTED	Stock	23.16	23.17	22.94	23.0	1359049.0
2014-09-19	ABBV	Stock	59.84	59.93	59.01	59.06	13986900.0
2014-09-19	ABC-DELISTED	Stock	77.47	78.12	77.32	77.36	2621648.0
2014-09-19	ABCB	Stock	22.92	23.1	22.23	22.32	154700.0
2014-09-19	ABCD-DELISTED	Stock	1.45	1.48	1.36	1.4101	72497.0
2014-09-19	ABCO-DELISTED	Stock	48.48	48.65	46.66	47.01	320630.0
2014-09-19	ABDC-DELISTED	Stock	13.86	13.93	13.56	13.71	30060.0
2014-09-19	ABE-DELISTED	Stock	14.35	14.36	14.24	14.24	7885.0
2014-09-19	ABEO	Stock	325.0	337.5	300.0	337.5	11.0
2014-09-19	ABEV	Stock	6.87	6.95	6.8	6.91	28572600.0
2014-09-19	ABG	Stock	66.5	66.67	65.37	65.37	281700.0
2014-09-19	ABGB-DELISTED	Stock	27.79	27.82	27.44	27.46	3928.0
2014-09-19	ABIL-DELISTED	Stock	9.75	9.75	9.75	9.75	100.0
2014-09-19	ABM	Stock	27.6	27.74	27.2	27.23	451100.0
2014-09-19	ABMD-DELISTED	Stock	25.52	25.83	25.34	25.37	344139.0
2014-09-19	ABR	Stock	6.67	7.0	6.65	7.0	341700.0
2014-09-19	ABR.A-DELISTED	Stock	24.6999	24.6999	24.5729	24.59	2000.0
2014-09-19	ABR.B-DELISTED	Stock	24.06	24.14	24.06	24.1122	3435.0

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

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