PREVIEW / stock_daily / 2014-08-11

all stock daily files

  file:    by_date/stock_daily/2014/2014-08-11.parquet
  size:    221 KB
  rows:    6,617
  symbols: 3,575

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-08-11	AAPL	Stock	23.8175	24.02	23.71	23.9975	146340000.0
2014-08-11	MSFT	Stock	43.26	43.45	43.02	43.2	20351600.0
2014-08-11	NVDA	Stock	0.4755	0.4775	0.4713	0.4725	344624000.0
2014-08-11	AMZN	Stock	15.924	16.019	15.844	15.9165	49372000.0
2014-08-11	GOOGL	Stock	28.95	28.9845	28.7649	28.8625	24067140.0
2014-08-11	META	Stock	73.46	73.91	73.06	73.44	24591000.0
2014-08-11	TSLA	Stock	17.032	17.5827	17.0	17.288	121519500.0
2014-08-11	TLT	Stock	115.65	115.82	115.29	115.51	6669325.0
2014-08-11	ES	Stock	43.52	43.71	43.2	43.28	1229100.0
2014-08-11	CL	Stock	65.34	65.7	65.01	65.06	4085500.0
2014-08-11	A	Stock	39.6567	39.8069	39.3848	39.485	1751275.0
2014-08-11	AABA-DELISTED	Stock	36.1	36.15	35.75	35.785	8098466.0
2014-08-11	AACG	Stock	4.45	4.64	4.44	4.49	17100.0
2014-08-11	AAIC-DELISTED	Stock	26.76	27.0	26.66	26.96	174449.0
2014-08-11	AAL	Stock	37.79	38.37	37.35	37.97	9015800.0
2014-08-11	AAMC-DELISTED	Stock	174.4118	176.4706	174.4118	176.4706	3016.0
2014-08-11	AAME	Stock	4.19	4.25	3.94	4.25	7800.0
2014-08-11	AAOI	Stock	18.38	18.61	18.13	18.25	155700.0
2014-08-11	AAON	Stock	12.8867	13.1533	12.56	12.7333	262500.0
2014-08-11	AAP	Stock	125.81	126.39	124.58	125.25	526800.0
2014-08-11	AAT	Stock	34.72	35.17	34.61	35.06	133800.0
2014-08-11	AAU-DELISTED	Stock	1.49	1.53	1.44	1.47	303599.0
2014-08-11	AAUAF-DELISTED	Stock	1.48	1.52	1.44	1.48	306930.0
2014-08-11	AAV-DELISTED	Stock	5.55	5.63	5.43	5.5	449638.0
2014-08-11	AAVL-DELISTED	Stock	23.59	24.7399	23.55	23.65	42000.0
2014-08-11	AAWW-DELISTED	Stock	33.27	34.43	32.84	34.17	197061.0
2014-08-11	AAXJ	Stock	64.73	65.03	64.67	64.91	201144.0
2014-08-11	AAXN-DELISTED	Stock	12.43	12.49	12.141	12.38	616506.0
2014-08-11	AB	Stock	25.6	25.84	25.25	25.28	265800.0
2014-08-11	ABAC-DELISTED	Stock	2.03	2.03	1.9999	2.0	17928.0
2014-08-11	ABAX-DELISTED	Stock	45.61	45.92	44.87	45.08	157509.0
2014-08-11	ABB-DELISTED	Stock	22.58	22.63	22.51	22.52	719379.0
2014-08-11	ABBNY-DELISTED	Stock	22.58	22.63	22.51	22.53	765036.0
2014-08-11	ABBV	Stock	53.0	53.65	52.77	53.31	10074600.0
2014-08-11	ABC-DELISTED	Stock	75.77	76.39	75.53	75.89	1144030.0
2014-08-11	ABCB	Stock	21.89	22.25	21.81	22.15	174900.0
2014-08-11	ABCD-DELISTED	Stock	1.781	1.87	1.751	1.84	22262.0
2014-08-11	ABCO-DELISTED	Stock	49.37	50.14	49.24	49.89	175961.0
2014-08-11	ABDC-DELISTED	Stock	12.99	13.0	12.7	12.77	80867.0
2014-08-11	ABE-DELISTED	Stock	14.39	14.4899	14.39	14.46	4261.0
2014-08-11	ABEO	Stock	337.5	350.0	325.0	350.0	23.0
2014-08-11	ABEV	Stock	6.88	6.97	6.85	6.94	13550900.0
2014-08-11	ABG	Stock	67.46	69.5	67.46	69.28	175200.0
2014-08-11	ABGB-DELISTED	Stock	25.1	25.26	25.04	25.055	4421.0
2014-08-11	ABIL-DELISTED	Stock	9.75	9.75	9.75	9.75	1000.0
2014-08-11	ABM	Stock	25.38	25.61	25.18	25.48	195800.0
2014-08-11	ABMD-DELISTED	Stock	25.41	25.8	25.19	25.68	140593.0
2014-08-11	ABR	Stock	7.08	7.1	7.01	7.06	181400.0
2014-08-11	ABR.A-DELISTED	Stock	24.98	25.0	24.94	24.9601	13427.0
2014-08-11	ABR.B-DELISTED	Stock	24.5001	24.64	24.5	24.5	6496.0

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

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