PREVIEW / stock_daily / 2014-05-22

all stock daily files

  file:    by_date/stock_daily/2014/2014-05-22.parquet
  size:    218 KB
  rows:    6,524
  symbols: 3,547

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-05-22	AAPL	Stock	21.6643	21.7804	21.575	21.6882	200760000.0
2014-05-22	MSFT	Stock	40.29	40.35	39.85	40.1	20201800.0
2014-05-22	NVDA	Stock	0.455	0.4605	0.455	0.458	130364000.0
2014-05-22	AMZN	Stock	15.2525	15.427	15.1505	15.2455	51536000.0
2014-05-22	GOOGL	Stock	27.61	27.898	27.55	27.7725	42995140.0
2014-05-22	META	Stock	60.94	61.48	60.4	60.52	54200000.0
2014-05-22	TSLA	Stock	13.3567	13.792	13.304	13.6587	93217500.0
2014-05-22	TLT	Stock	112.26	112.4	111.79	112.1	6495711.0
2014-05-22	ES	Stock	45.23	45.65	45.15	45.49	878100.0
2014-05-22	CL	Stock	66.71	66.8	66.37	66.61	2679200.0
2014-05-22	A	Stock	39.3419	39.8498	39.2632	39.7282	2357168.0
2014-05-22	AABA-DELISTED	Stock	34.6	34.86	34.2648	34.705	15331789.0
2014-05-22	AACG	Stock	4.59	4.62	4.58	4.58	7300.0
2014-05-22	AAIC-DELISTED	Stock	26.9	26.94	26.76	26.88	139150.0
2014-05-22	AAL	Stock	38.3	38.88	38.3	38.72	6414500.0
2014-05-22	AAMC-DELISTED	Stock	269.0853	272.5882	264.706	266.7971	19608.0
2014-05-22	AAME	Stock	3.5	3.63	3.29	3.5	12800.0
2014-05-22	AAOI	Stock	18.35	19.04	18.016	18.66	106600.0
2014-05-22	AAON	Stock	13.4578	13.6089	13.3156	13.5156	158850.0
2014-05-22	AAP	Stock	122.11	123.67	122.11	122.5	638200.0
2014-05-22	AAT	Stock	33.7	34.04	33.59	33.78	109000.0
2014-05-22	AAU-DELISTED	Stock	1.35	1.35	1.33	1.33	74522.0
2014-05-22	AAUAF-DELISTED	Stock	1.35	1.35	1.33	1.33	74801.0
2014-05-22	AAV-DELISTED	Stock	5.76	5.78	5.6	5.68	264896.0
2014-05-22	AAWW-DELISTED	Stock	36.06	37.07	35.807	36.65	200454.0
2014-05-22	AAXJ	Stock	62.06	62.14	61.9605	62.1	240681.0
2014-05-22	AAXN-DELISTED	Stock	13.06	13.155	12.97	13.08	380187.0
2014-05-22	AB	Stock	24.02	24.09	23.55	23.72	230700.0
2014-05-22	ABAC-DELISTED	Stock	2.1	2.13	2.0401	2.13	42695.0
2014-05-22	ABAX-DELISTED	Stock	41.71	41.9799	41.372	41.64	96897.0
2014-05-22	ABB-DELISTED	Stock	23.6	23.66	23.52	23.605	1125874.0
2014-05-22	ABBNY-DELISTED	Stock	23.6	23.66	23.52	23.62	1336969.0
2014-05-22	ABBV	Stock	53.29	54.34	52.94	53.63	4486400.0
2014-05-22	ABC-DELISTED	Stock	70.78	71.66	70.58	71.35	1605541.0
2014-05-22	ABCB	Stock	20.35	20.84	20.35	20.62	160200.0
2014-05-22	ABCD-DELISTED	Stock	2.3	2.34	2.2	2.21	41130.0
2014-05-22	ABCO-DELISTED	Stock	48.45	49.23	47.77	47.87	185432.0
2014-05-22	ABDC-DELISTED	Stock	14.8	15.04	14.8	14.84	16340.0
2014-05-22	ABE-DELISTED	Stock	14.09	14.15	14.08	14.0901	12596.0
2014-05-22	ABEO	Stock	537.5	587.5	500.0	587.5	25.0
2014-05-22	ABEV	Stock	7.49	7.51	7.46	7.5	5334000.0
2014-05-22	ABG	Stock	64.42	64.87	63.63	63.84	207000.0
2014-05-22	ABGB-DELISTED	Stock	20.52	20.61	20.26	20.28	4800.0
2014-05-22	ABIL-DELISTED	Stock	9.75	9.78	9.75	9.76	3170.0
2014-05-22	ABM	Stock	26.32	26.47	26.07	26.39	109200.0
2014-05-22	ABMD-DELISTED	Stock	20.99	21.49	20.85	21.38	212835.0
2014-05-22	ABR	Stock	7.03	7.1	7.02	7.09	53300.0
2014-05-22	ABR.A-DELISTED	Stock	24.28	24.3	24.22	24.23	20533.0
2014-05-22	ABR.B-DELISTED	Stock	23.79	23.85	23.66	23.78	29551.0
2014-05-22	ABR.C-DELISTED	Stock	24.845	24.85	24.8	24.83	4503.0

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

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