PREVIEW / stock_daily / 2014-01-06

all stock daily files

  file:    by_date/stock_daily/2014/2014-01-06.parquet
  size:    217 KB
  rows:    6,450
  symbols: 3,534

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-01-06	AAPL	Stock	19.1946	19.5286	19.0571	19.4261	412610800.0
2014-01-06	MSFT	Stock	36.85	36.89	36.11	36.13	43603700.0
2014-01-06	NVDA	Stock	0.3958	0.4	0.392	0.397	409492000.0
2014-01-06	AMZN	Stock	19.7925	19.85	19.421	19.6815	63412000.0
2014-01-06	META	Stock	54.42	57.26	54.05	57.2	68852600.0
2014-01-06	TSLA	Stock	10.0	10.0267	9.6827	9.8	80416500.0
2014-01-06	TLT	Stock	102.38	103.0	102.37	102.6	7796228.0
2014-01-06	ES	Stock	41.64	41.64	41.28	41.55	2159200.0
2014-01-06	CL	Stock	64.44	64.55	63.99	64.14	2583500.0
2014-01-06	A	Stock	41.0587	41.2732	40.4578	40.515	2484665.0
2014-01-06	AABA-DELISTED	Stock	40.05	40.32	39.75	39.93	11838621.0
2014-01-06	AACG	Stock	4.0	4.09	3.94	3.94	14700.0
2014-01-06	AAIC-DELISTED	Stock	26.46	26.5	26.25	26.34	123523.0
2014-01-06	AAL	Stock	26.62	27.2	26.6	27.03	11271400.0
2014-01-06	AAMC-DELISTED	Stock	272.0588	272.0588	264.7059	267.9794	59670.0
2014-01-06	AAME	Stock	4.05	4.05	4.02	4.03	11500.0
2014-01-06	AAOI	Stock	14.35	14.49	14.1	14.33	64100.0
2014-01-06	AAON	Stock	14.2	14.2	13.8089	13.8533	256500.0
2014-01-06	AAP	Stock	113.1	113.91	111.44	111.8	1030200.0
2014-01-06	AAT	Stock	31.79	32.0	31.59	31.64	115800.0
2014-01-06	AAU-DELISTED	Stock	1.25	1.31	1.25	1.3	133030.0
2014-01-06	AAUAF-DELISTED	Stock	1.25	1.31	1.25	1.3	133785.0
2014-01-06	AAV-DELISTED	Stock	4.33	4.3899	4.31	4.37	47894.0
2014-01-06	AAWW-DELISTED	Stock	40.67	41.0	40.05	40.32	235473.0
2014-01-06	AAXJ	Stock	57.99	57.99	57.56	57.64	1116778.0
2014-01-06	AAXN-DELISTED	Stock	15.79	15.92	15.29	15.66	955318.0
2014-01-06	AB	Stock	21.91	22.25	21.76	21.78	314800.0
2014-01-06	ABAC-DELISTED	Stock	2.1588	2.24	2.0899	2.135	22504.0
2014-01-06	ABAX-DELISTED	Stock	40.19	41.24	40.0	41.09	164661.0
2014-01-06	ABB-DELISTED	Stock	25.74	25.79	25.67	25.73	2072180.0
2014-01-06	ABBNY-DELISTED	Stock	25.74	25.79	25.67	25.74	2435002.0
2014-01-06	ABBV	Stock	52.7	52.7	50.03	50.39	11871100.0
2014-01-06	ABC-DELISTED	Stock	70.34	70.54	69.35	69.68	1086001.0
2014-01-06	ABCB	Stock	20.81	21.06	20.7	20.9	62800.0
2014-01-06	ABCD-DELISTED	Stock	1.8	1.93	1.721	1.8998	56927.0
2014-01-06	ABCO-DELISTED	Stock	61.99	61.99	59.76	60.07	180431.0
2014-01-06	ABE-DELISTED	Stock	13.79	13.79	13.65	13.718	13067.0
2014-01-06	ABEO	Stock	325.0	337.5	325.0	337.5	6.0
2014-01-06	ABEV	Stock	7.06	7.07	6.95	6.98	6413200.0
2014-01-06	ABFS-DELISTED	Stock	33.88	33.99	33.2501	33.56	304710.0
2014-01-06	ABG	Stock	53.02	53.28	52.6	52.71	207700.0
2014-01-06	ABGB-DELISTED	Stock	15.36	15.36	15.19	15.33	7234.0
2014-01-06	ABM	Stock	28.53	28.67	28.28	28.33	202200.0
2014-01-06	ABMD-DELISTED	Stock	27.23	27.94	27.06	27.27	216921.0
2014-01-06	ABR	Stock	6.77	6.94	6.77	6.94	82300.0
2014-01-06	ABR.A-DELISTED	Stock	24.25	24.4	24.25	24.3	3625.0
2014-01-06	ABR.B-DELISTED	Stock	22.61	22.61	22.61	22.61	542.0
2014-01-06	ABT	Stock	39.19	39.69	39.11	39.15	10130400.0
2014-01-06	ABTL-DELISTED	Stock	14.4	14.4	13.529	14.205	279054.0
2014-01-06	ABUS	Stock	7.87	7.87	7.66	7.76	18000.0

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

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