PREVIEW / stock_daily / 2014-03-26

all stock daily files

  file:    by_date/stock_daily/2014/2014-03-26.parquet
  size:    218 KB
  rows:    6,494
  symbols: 3,532

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-03-26	AAPL	Stock	19.5186	19.6071	19.245	19.2779	299768000.0
2014-03-26	MSFT	Stock	40.48	40.71	39.6	39.79	41977500.0
2014-03-26	NVDA	Stock	0.4655	0.4742	0.4468	0.4508	557756000.0
2014-03-26	AMZN	Stock	17.8565	17.88	17.17	17.1705	82414000.0
2014-03-26	META	Stock	64.74	64.95	60.37	60.39	97503900.0
2014-03-26	TSLA	Stock	14.7967	14.84	14.09	14.1973	103609500.0
2014-03-26	TLT	Stock	108.55	109.475	108.48	109.44	7147736.0
2014-03-26	ES	Stock	44.82	45.05	44.57	44.57	1429900.0
2014-03-26	CL	Stock	63.87	64.55	63.7	64.27	2737000.0
2014-03-26	A	Stock	39.628	40.0501	39.4564	39.4635	3579859.0
2014-03-26	AABA-DELISTED	Stock	36.24	36.74	35.45	35.45	19878564.0
2014-03-26	AACG	Stock	4.07	4.24	3.91	3.95	34900.0
2014-03-26	AAIC-DELISTED	Stock	27.05	27.18	26.8	26.94	866178.0
2014-03-26	AAL	Stock	38.15	38.26	36.64	36.7	7318200.0
2014-03-26	AAMC-DELISTED	Stock	319.1176	323.0882	312.4882	316.0794	139845.0
2014-03-26	AAME	Stock	3.68	3.75	3.68	3.7	13500.0
2014-03-26	AAOI	Stock	25.5	25.74	23.98	24.27	468900.0
2014-03-26	AAON	Stock	12.9467	12.9467	12.3867	12.4311	238725.0
2014-03-26	AAP	Stock	124.36	124.51	122.68	122.75	593100.0
2014-03-26	AAT	Stock	33.84	34.1	32.99	33.04	111500.0
2014-03-26	AAU-DELISTED	Stock	1.4	1.4	1.34	1.37	99268.0
2014-03-26	AAUAF-DELISTED	Stock	1.4	1.4	1.34	1.37	100357.0
2014-03-26	AAV-DELISTED	Stock	4.44	4.5501	4.43	4.5	741297.0
2014-03-26	AAWW-DELISTED	Stock	35.25	35.25	33.9	34.2	329553.0
2014-03-26	AAXJ	Stock	58.19	58.3	57.83	57.83	418676.0
2014-03-26	AAXN-DELISTED	Stock	19.27	19.73	18.815	18.85	1768058.0
2014-03-26	AB	Stock	25.5	25.94	25.45	25.49	342200.0
2014-03-26	ABAC-DELISTED	Stock	1.8	1.82	1.7501	1.7867	17550.0
2014-03-26	ABAX-DELISTED	Stock	37.71	37.78	37.02	37.59	150464.0
2014-03-26	ABB-DELISTED	Stock	25.28	25.36	25.065	25.11	1443570.0
2014-03-26	ABBNY-DELISTED	Stock	25.28	25.36	25.065	25.1	1546230.0
2014-03-26	ABBV	Stock	52.0	52.34	51.46	51.5	5684900.0
2014-03-26	ABC-DELISTED	Stock	64.92	65.59	64.7799	64.86	2050147.0
2014-03-26	ABCB	Stock	23.77	23.81	23.4	23.4	104100.0
2014-03-26	ABCD-DELISTED	Stock	2.1	2.11	2.03	2.06	40726.0
2014-03-26	ABCO-DELISTED	Stock	65.1	65.1	63.15	63.26	181630.0
2014-03-26	ABE-DELISTED	Stock	12.83	12.87	12.775	12.81	66286.0
2014-03-26	ABEO	Stock	737.5	737.5	662.5	712.5	58.0
2014-03-26	ABEV	Stock	7.22	7.27	7.14	7.18	13656600.0
2014-03-26	ABFS-DELISTED	Stock	36.5	37.12	35.34	35.64	250818.0
2014-03-26	ABG	Stock	55.4	55.61	54.33	54.75	444100.0
2014-03-26	ABGB-DELISTED	Stock	22.54	22.81	22.4	22.65	36797.0
2014-03-26	ABM	Stock	28.75	28.77	28.18	28.19	156100.0
2014-03-26	ABMD-DELISTED	Stock	27.29	27.55	26.29	26.34	278720.0
2014-03-26	ABR	Stock	6.7	6.77	6.67	6.67	105200.0
2014-03-26	ABR.A-DELISTED	Stock	24.5	24.9	24.5	24.75	2925.0
2014-03-26	ABR.B-DELISTED	Stock	22.91	22.97	22.69	22.75	11249.0
2014-03-26	ABR.C-DELISTED	Stock	24.9899	24.99	24.69	24.7	9902.0
2014-03-26	ABT	Stock	38.55	39.14	38.39	38.56	8174800.0
2014-03-26	ABTL-DELISTED	Stock	12.67	12.94	12.168	12.22	244990.0

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

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