PREVIEW / stock_daily / 2015-03-26

all stock daily files

  file:    by_date/stock_daily/2015/2015-03-26.parquet
  size:    222 KB
  rows:    6,588
  symbols: 3,491

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-26	AAPL	Stock	30.69	31.22	30.65	31.06	190291600.0
2015-03-26	MSFT	Stock	41.22	41.61	40.92	41.21	37495600.0
2015-03-26	NVDA	Stock	0.5152	0.5265	0.5115	0.5242	311920000.0
2015-03-26	AMZN	Stock	18.4795	18.57	18.2825	18.3675	58600000.0
2015-03-26	GOOGL	Stock	28.2325	28.3595	27.9155	28.182	49842820.0
2015-03-26	META	Stock	82.72	83.77	82.14	83.01	32794800.0
2015-03-26	TSLA	Stock	12.928	12.986	12.6467	12.694	61920000.0
2015-03-26	TLT	Stock	131.05	131.14	129.181	129.45	9536292.0
2015-03-26	ES	Stock	50.14	50.6	49.54	49.91	929600.0
2015-03-26	CL	Stock	68.72	69.21	68.48	68.74	2890600.0
2015-03-26	A	Stock	40.68	40.97	40.37	40.7	1573400.0
2015-03-26	AA.B-DELISTED	Stock	43.75	44.0799	43.6	43.805	38985.0
2015-03-26	AABA-DELISTED	Stock	43.8	44.67	43.68	44.47	15243970.0
2015-03-26	AAC-DELISTED	Stock	27.69	28.6	27.69	28.09	42827.0
2015-03-26	AACG	Stock	3.7	4.0	3.7	3.97	7900.0
2015-03-26	AAIC-DELISTED	Stock	25.34	25.35	25.03	25.05	412572.0
2015-03-26	AAL	Stock	50.84	51.69	50.25	51.27	14242700.0
2015-03-26	AAMC-DELISTED	Stock	57.3529	58.5441	56.4912	56.4941	23797.0
2015-03-26	AAME	Stock	3.98	4.02	3.97	4.02	900.0
2015-03-26	AAMI	Stock	18.28	18.32	17.82	17.96	89600.0
2015-03-26	AAOI	Stock	13.71	13.72	13.12	13.32	241200.0
2015-03-26	AAON	Stock	15.5667	15.7	15.5133	15.68	112500.0
2015-03-26	AAP	Stock	147.63	150.33	146.7	149.41	828200.0
2015-03-26	AAT	Stock	42.93	43.25	42.75	42.9	141400.0
2015-03-26	AAU-DELISTED	Stock	0.9399	0.95	0.9224	0.93	40743.0
2015-03-26	AAUAF-DELISTED	Stock	0.95	0.96	0.93	0.93	41211.0
2015-03-26	AAV-DELISTED	Stock	5.39	5.45	5.28	5.32	173690.0
2015-03-26	AAVL-DELISTED	Stock	41.1	42.0	37.6535	38.42	723870.0
2015-03-26	AAWW-DELISTED	Stock	46.34	46.64	44.53	44.64	139035.0
2015-03-26	AAXJ	Stock	63.05	63.12	62.73	62.98	552639.0
2015-03-26	AAXN-DELISTED	Stock	24.17	24.3799	23.7901	24.22	847343.0
2015-03-26	AB	Stock	30.0	30.27	29.94	30.17	206300.0
2015-03-26	ABAC-DELISTED	Stock	1.5	1.5097	1.5	1.5097	200.0
2015-03-26	ABAX-DELISTED	Stock	64.3	65.28	63.42	64.22	133900.0
2015-03-26	ABB-DELISTED	Stock	21.35	21.4	21.2	21.27	1109099.0
2015-03-26	ABBNY-DELISTED	Stock	21.35	21.4	21.2	21.27	1213044.0
2015-03-26	ABBV	Stock	57.98	58.09	57.22	57.27	10853900.0
2015-03-26	ABC-DELISTED	Stock	111.5	113.05	110.54	112.11	2115685.0
2015-03-26	ABCB	Stock	26.13	26.53	26.02	26.43	140000.0
2015-03-26	ABCD-DELISTED	Stock	3.21	3.3	3.2	3.22	36415.0
2015-03-26	ABCO-DELISTED	Stock	50.56	51.65	50.45	51.12	133822.0
2015-03-26	ABCW-DELISTED	Stock	34.98	34.98	34.94	34.98	3574.0
2015-03-26	ABDC-DELISTED	Stock	13.93	13.93	13.67	13.82	64600.0
2015-03-26	ABE-DELISTED	Stock	12.62	12.62	12.44	12.57	13839.0
2015-03-26	ABEO	Stock	75.75	77.5	74.5	75.0	820.0
2015-03-26	ABEV	Stock	5.77	5.78	5.64	5.67	16587700.0
2015-03-26	ABG	Stock	79.62	80.8	79.01	80.05	244400.0
2015-03-26	ABGB-DELISTED	Stock	16.63	16.88	16.62	16.72	28714.0
2015-03-26	ABM	Stock	31.56	31.95	31.24	31.73	198400.0
2015-03-26	ABMD-DELISTED	Stock	71.0	71.01	68.67	69.04	456109.0

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

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