PREVIEW / stock_daily / 2014-03-25

all stock daily files

  file:    by_date/stock_daily/2014/2014-03-25.parquet
  size:    219 KB
  rows:    6,494
  symbols: 3,531

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-25	AAPL	Stock	19.3393	19.4911	19.2711	19.4639	282293200.0
2014-03-25	MSFT	Stock	40.66	40.99	39.96	40.34	43193100.0
2014-03-25	NVDA	Stock	0.4662	0.4668	0.4578	0.4612	304424000.0
2014-03-25	AMZN	Stock	17.7015	17.9485	17.442	17.7355	88914000.0
2014-03-25	META	Stock	64.89	66.19	63.78	64.89	68786000.0
2014-03-25	TSLA	Stock	14.9427	15.1367	14.5267	14.696	117981000.0
2014-03-25	TLT	Stock	108.41	108.82	108.17	108.59	5032172.0
2014-03-25	ES	Stock	44.84	44.97	44.45	44.77	1418500.0
2014-03-25	CL	Stock	63.72	64.3	63.31	63.77	3161400.0
2014-03-25	A	Stock	39.6996	40.2074	39.3276	39.4564	2414765.0
2014-03-25	AABA-DELISTED	Stock	37.0	37.07	35.86	35.92	30832632.0
2014-03-25	AACG	Stock	4.05	4.18	3.97	4.02	56600.0
2014-03-25	AAIC-DELISTED	Stock	27.26	27.28	26.86	26.99	4345848.0
2014-03-25	AAL	Stock	36.88	38.2	36.86	37.9	10418400.0
2014-03-25	AAMC-DELISTED	Stock	311.7647	324.5882	311.7647	319.15	37009.0
2014-03-25	AAME	Stock	3.73	3.73	3.65	3.7	3100.0
2014-03-25	AAOI	Stock	26.0	26.75	24.92	25.43	209600.0
2014-03-25	AAON	Stock	12.8889	12.9156	12.6133	12.8267	230175.0
2014-03-25	AAP	Stock	125.23	125.71	123.13	123.56	846400.0
2014-03-25	AAT	Stock	33.6	33.89	32.95	33.44	221600.0
2014-03-25	AAU-DELISTED	Stock	1.34	1.39	1.33	1.37	92614.0
2014-03-25	AAUAF-DELISTED	Stock	1.34	1.39	1.33	1.37	93647.0
2014-03-25	AAV-DELISTED	Stock	4.4	4.45	4.323	4.42	134707.0
2014-03-25	AAWW-DELISTED	Stock	33.9	35.11	33.9	34.99	432586.0
2014-03-25	AAXJ	Stock	57.72	57.98	57.58	57.8	437929.0
2014-03-25	AAXN-DELISTED	Stock	17.99	18.95	17.87	18.91	1738580.0
2014-03-25	AB	Stock	25.6	25.81	25.13	25.41	274700.0
2014-03-25	ABAC-DELISTED	Stock	1.74	1.82	1.74	1.82	11354.0
2014-03-25	ABAX-DELISTED	Stock	37.95	38.34	37.05	37.39	72918.0
2014-03-25	ABB-DELISTED	Stock	24.87	25.11	24.72	25.06	2597149.0
2014-03-25	ABBNY-DELISTED	Stock	24.87	25.11	24.72	25.07	2962257.0
2014-03-25	ABBV	Stock	51.68	52.1	51.5	51.69	6127200.0
2014-03-25	ABC-DELISTED	Stock	64.61	65.31	63.98	64.57	1789201.0
2014-03-25	ABCB	Stock	23.8	23.9	23.7	23.73	138000.0
2014-03-25	ABCD-DELISTED	Stock	2.2	2.2	2.08	2.09	88301.0
2014-03-25	ABCO-DELISTED	Stock	66.33	67.0	64.79	64.88	222814.0
2014-03-25	ABE-DELISTED	Stock	12.77	12.78	12.73	12.74	101586.0
2014-03-25	ABEO	Stock	600.0	725.0	600.0	725.0	39.0
2014-03-25	ABEV	Stock	7.25	7.28	7.16	7.21	8084900.0
2014-03-25	ABFS-DELISTED	Stock	36.52	37.08	35.1001	36.32	174925.0
2014-03-25	ABG	Stock	55.87	56.26	54.4	55.11	381100.0
2014-03-25	ABGB-DELISTED	Stock	25.0	25.0	22.07	22.28	11152.0
2014-03-25	ABIL-DELISTED	Stock	9.64	9.64	9.64	9.64	265.0
2014-03-25	ABM	Stock	28.8	28.85	28.48	28.65	167800.0
2014-03-25	ABMD-DELISTED	Stock	27.59	27.72	26.99	27.2	532804.0
2014-03-25	ABR	Stock	6.73	6.82	6.67	6.68	225300.0
2014-03-25	ABR.A-DELISTED	Stock	24.479	24.8	24.39	24.54	10650.0
2014-03-25	ABR.B-DELISTED	Stock	22.9899	22.9899	22.841	22.85	7681.0
2014-03-25	ABR.C-DELISTED	Stock	25.0	25.0	24.8	24.84	18550.0
2014-03-25	ABT	Stock	38.49	38.7	38.08	38.4	8209600.0

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

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