PREVIEW / stock_daily / 2014-04-14

all stock daily files

  file:    by_date/stock_daily/2014/2014-04-14.parquet
  size:    219 KB
  rows:    6,544
  symbols: 3,562

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-04-14	AAPL	Stock	18.6393	18.6486	18.4718	18.6314	205674000.0
2014-04-14	MSFT	Stock	39.11	39.41	38.9	39.18	32006600.0
2014-04-14	NVDA	Stock	0.456	0.4598	0.453	0.458	290184000.0
2014-04-14	AMZN	Stock	15.8835	16.024	15.564	15.7955	85870000.0
2014-04-14	GOOGL	Stock	27.183	27.651	27.026	27.26	50827960.0
2014-04-14	META	Stock	60.09	60.45	57.78	58.89	72325000.0
2014-04-14	TSLA	Stock	13.84	13.896	12.9607	13.206	115545000.0
2014-04-14	TLT	Stock	110.48	110.7	110.3	110.44	4142596.0
2014-04-14	ES	Stock	45.63	45.81	45.33	45.67	1868100.0
2014-04-14	CL	Stock	65.66	66.01	65.53	65.86	3040300.0
2014-04-14	A	Stock	38.0472	38.0901	37.4177	37.6609	3971159.0
2014-04-14	AABA-DELISTED	Stock	33.55	34.04	33.04	33.445	24464874.0
2014-04-14	AACG	Stock	4.1	4.29	4.05	4.1	23500.0
2014-04-14	AAIC-DELISTED	Stock	25.7	25.74	25.19	25.33	265143.0
2014-04-14	AAL	Stock	34.0	34.77	32.77	33.37	13465400.0
2014-04-14	AAMC-DELISTED	Stock	288.2	291.7647	278.8294	280.2941	53026.0
2014-04-14	AAME	Stock	3.51	3.53	3.46	3.53	1000.0
2014-04-14	AAOI	Stock	20.84	21.75	20.65	21.53	158500.0
2014-04-14	AAON	Stock	11.5511	11.8	11.4	11.72	303300.0
2014-04-14	AAP	Stock	117.25	118.55	115.76	117.2	659000.0
2014-04-14	AAT	Stock	32.95	33.06	32.42	32.65	105800.0
2014-04-14	AAU-DELISTED	Stock	1.39	1.44	1.38	1.38	46547.0
2014-04-14	AAUAF-DELISTED	Stock	1.39	1.44	1.38	1.38	47902.0
2014-04-14	AAV-DELISTED	Stock	5.4	5.51	5.3801	5.46	698382.0
2014-04-14	AAWW-DELISTED	Stock	34.54	34.78	34.3	34.57	127471.0
2014-04-14	AAXJ	Stock	60.87	60.99	60.58	60.84	417331.0
2014-04-14	AAXN-DELISTED	Stock	16.95	17.24	16.49	16.78	816492.0
2014-04-14	AB	Stock	25.23	25.47	24.84	25.27	238300.0
2014-04-14	ABAC-DELISTED	Stock	1.91	2.0	1.8701	1.97	34200.0
2014-04-14	ABAX-DELISTED	Stock	40.54	40.54	38.52	39.03	135488.0
2014-04-14	ABB-DELISTED	Stock	25.51	25.635	25.285	25.51	1292290.0
2014-04-14	ABBNY-DELISTED	Stock	25.51	25.635	25.285	25.52	1323623.0
2014-04-14	ABBV	Stock	47.1	47.5	46.21	46.83	7290800.0
2014-04-14	ABC-DELISTED	Stock	64.44	64.68	63.85	64.51	1271636.0
2014-04-14	ABCB	Stock	22.65	22.82	22.16	22.45	84600.0
2014-04-14	ABCD-DELISTED	Stock	2.13	2.17	2.1121	2.17	12842.0
2014-04-14	ABCO-DELISTED	Stock	58.55	59.43	57.49	59.22	179682.0
2014-04-14	ABE-DELISTED	Stock	13.5	13.5	13.4099	13.44	9548.0
2014-04-14	ABEO	Stock	537.5	600.0	500.0	575.0	34.0
2014-04-14	ABEV	Stock	7.82	7.83	7.72	7.77	8128300.0
2014-04-14	ABFS-DELISTED	Stock	36.55	36.9	35.33	36.02	264730.0
2014-04-14	ABG	Stock	53.53	54.47	53.25	53.51	252400.0
2014-04-14	ABGB-DELISTED	Stock	22.25	22.46	22.07	22.26	12159.0
2014-04-14	ABIL-DELISTED	Stock	9.64	9.64	9.64	9.64	496.0
2014-04-14	ABM	Stock	27.46	27.48	26.98	27.13	156400.0
2014-04-14	ABMD-DELISTED	Stock	23.81	24.2	23.5601	24.02	311184.0
2014-04-14	ABR	Stock	6.93	6.95	6.77	6.83	116900.0
2014-04-14	ABR.A-DELISTED	Stock	24.86	25.079	24.81	24.949	1300.0
2014-04-14	ABR.B-DELISTED	Stock	23.08	23.1	22.9901	23.0999	2134.0
2014-04-14	ABR.C-DELISTED	Stock	24.85	24.87	24.78	24.7801	11122.0

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

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