PREVIEW / stock_daily / 2015-03-23

all stock daily files

  file:    by_date/stock_daily/2015/2015-03-23.parquet
  size:    223 KB
  rows:    6,641
  symbols: 3,508

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-03-23	AAPL	Stock	31.78	31.9625	31.63	31.8025	150838800.0
2015-03-23	MSFT	Stock	42.88	43.13	42.78	42.86	26246100.0
2015-03-23	NVDA	Stock	0.5692	0.5768	0.5675	0.5678	426012000.0
2015-03-23	AMZN	Stock	18.9035	19.0885	18.747	18.7555	44786000.0
2015-03-23	GOOGL	Stock	28.3	28.482	28.153	28.2685	30233720.0
2015-03-23	META	Stock	83.92	84.96	83.3	84.43	27357300.0
2015-03-23	TSLA	Stock	13.2333	13.3667	13.1647	13.3087	39474000.0
2015-03-23	TLT	Stock	131.7	131.75	130.99	131.35	5555506.0
2015-03-23	ES	Stock	51.11	51.61	51.03	51.47	1197800.0
2015-03-23	CL	Stock	69.65	70.39	69.3	70.17	3123400.0
2015-03-23	A	Stock	42.12	42.44	42.0	42.2	1835400.0
2015-03-23	AA.B-DELISTED	Stock	44.1	44.55	43.8	44.27	48876.0
2015-03-23	AABA-DELISTED	Stock	45.27	45.54	44.71	44.71	7896962.0
2015-03-23	AAC-DELISTED	Stock	30.67	30.99	27.72	28.83	225766.0
2015-03-23	AACG	Stock	3.95	4.0	3.85	3.98	8600.0
2015-03-23	AAIC-DELISTED	Stock	25.2	25.52	25.2	25.52	355448.0
2015-03-23	AAL	Stock	55.47	55.93	54.37	54.4	19042000.0
2015-03-23	AAMC-DELISTED	Stock	58.8235	59.7059	58.8235	59.5588	13865.0
2015-03-23	AAME	Stock	3.94	4.05	3.94	4.05	2800.0
2015-03-23	AAMI	Stock	18.75	18.95	18.48	18.74	137600.0
2015-03-23	AAOI	Stock	13.85	14.46	13.77	13.95	232200.0
2015-03-23	AAON	Stock	15.5467	15.76	15.4867	15.68	129600.0
2015-03-23	AAP	Stock	151.06	152.22	149.49	149.51	1037000.0
2015-03-23	AAT	Stock	44.52	45.0	44.16	44.56	122100.0
2015-03-23	AAU-DELISTED	Stock	0.9	0.93	0.881	0.92	84795.0
2015-03-23	AAUAF-DELISTED	Stock	0.9	0.95	0.9	0.92	83830.0
2015-03-23	AAV-DELISTED	Stock	5.3	5.39	5.22	5.25	110414.0
2015-03-23	AAVL-DELISTED	Stock	44.38	44.87	42.97	43.08	291442.0
2015-03-23	AAWW-DELISTED	Stock	47.25	47.65	46.85	47.3	160506.0
2015-03-23	AAXJ	Stock	63.98	63.98	63.58	63.77	942694.0
2015-03-23	AAXN-DELISTED	Stock	24.05	24.6201	24.01	24.29	1120834.0
2015-03-23	AB	Stock	30.94	31.0	30.28	30.51	304700.0
2015-03-23	ABAC-DELISTED	Stock	1.54	1.54	1.46	1.4768	10347.0
2015-03-23	ABAX-DELISTED	Stock	65.77	65.83	63.11	63.81	131980.0
2015-03-23	ABB-DELISTED	Stock	21.625	21.67	21.52	21.54	1729824.0
2015-03-23	ABBNY-DELISTED	Stock	21.625	21.67	21.52	21.55	1958375.0
2015-03-23	ABBV	Stock	60.05	61.19	59.62	60.48	7926400.0
2015-03-23	ABC-DELISTED	Stock	113.74	114.53	113.13	113.65	1679387.0
2015-03-23	ABCB	Stock	25.9	26.05	25.85	26.03	173200.0
2015-03-23	ABCD-DELISTED	Stock	3.16	3.25	3.12	3.2099	42877.0
2015-03-23	ABCO-DELISTED	Stock	53.02	53.02	52.18	52.77	123516.0
2015-03-23	ABCW-DELISTED	Stock	35.13	35.13	34.4	35.12	4531.0
2015-03-23	ABDC-DELISTED	Stock	13.78	14.3	13.77	14.21	36147.0
2015-03-23	ABE-DELISTED	Stock	12.67	12.67	12.59	12.6101	26045.0
2015-03-23	ABEO	Stock	79.75	83.0	73.75	77.5	2100.0
2015-03-23	ABEV	Stock	5.83	6.01	5.82	5.98	18070300.0
2015-03-23	ABG	Stock	79.46	82.3	79.37	81.74	409800.0
2015-03-23	ABGB-DELISTED	Stock	17.47	17.5311	17.35	17.43	11084.0
2015-03-23	ABIL-DELISTED	Stock	9.9	9.91	9.85	9.91	800.0
2015-03-23	ABM	Stock	32.27	32.5	32.06	32.17	240700.0

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

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