PREVIEW / stock_daily / 2014-05-23

all stock daily files

  file:    by_date/stock_daily/2014/2014-05-23.parquet
  size:    218 KB
  rows:    6,524
  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-05-23	AAPL	Stock	21.6875	21.9546	21.6596	21.9332	232209600.0
2014-05-23	MSFT	Stock	40.37	40.37	40.0	40.12	18020000.0
2014-05-23	NVDA	Stock	0.4605	0.4645	0.4578	0.4622	182656000.0
2014-05-23	AMZN	Stock	15.273	15.6175	15.245	15.612	61058000.0
2014-05-23	GOOGL	Stock	27.9065	28.25	27.7085	28.19	53453480.0
2014-05-23	META	Stock	60.41	61.45	60.15	61.35	38294000.0
2014-05-23	TSLA	Stock	13.6353	13.8507	13.5	13.82	60102000.0
2014-05-23	TLT	Stock	112.52	112.91	112.45	112.7	3835231.0
2014-05-23	ES	Stock	45.51	45.61	45.22	45.23	744100.0
2014-05-23	CL	Stock	66.8	67.16	66.5	66.73	3253500.0
2014-05-23	A	Stock	39.8069	40.2146	39.4707	40.186	4907819.0
2014-05-23	AABA-DELISTED	Stock	34.85	35.08	34.51	35.02	15575162.0
2014-05-23	AACG	Stock	4.56	4.57	4.55	4.56	11800.0
2014-05-23	AAIC-DELISTED	Stock	26.97	27.33	26.93	27.33	195593.0
2014-05-23	AAL	Stock	38.53	39.5	38.53	39.11	9864400.0
2014-05-23	AAMC-DELISTED	Stock	270.4588	288.2353	270.4588	277.0588	66769.0
2014-05-23	AAME	Stock	3.6	3.61	3.47	3.59	1400.0
2014-05-23	AAOI	Stock	18.7	18.88	18.32	18.76	60000.0
2014-05-23	AAON	Stock	13.5244	13.9067	13.3911	13.9022	153225.0
2014-05-23	AAP	Stock	122.98	123.71	122.49	123.24	512700.0
2014-05-23	AAT	Stock	33.88	34.3	33.84	34.27	138100.0
2014-05-23	AAU-DELISTED	Stock	1.32	1.35	1.32	1.34	30357.0
2014-05-23	AAUAF-DELISTED	Stock	1.32	1.35	1.32	1.34	30707.0
2014-05-23	AAV-DELISTED	Stock	5.71	5.78	5.66	5.78	180065.0
2014-05-23	AAWW-DELISTED	Stock	36.75	37.03	36.47	36.69	87241.0
2014-05-23	AAXJ	Stock	62.2	62.26	62.14	62.15	338101.0
2014-05-23	AAXN-DELISTED	Stock	13.06	13.38	12.99	13.35	574012.0
2014-05-23	AB	Stock	23.73	23.73	23.4	23.6	274200.0
2014-05-23	ABAC-DELISTED	Stock	2.14	2.21	2.1299	2.21	75901.0
2014-05-23	ABAX-DELISTED	Stock	41.77	41.86	41.49	41.74	71741.0
2014-05-23	ABB-DELISTED	Stock	23.74	23.89	23.711	23.84	1531985.0
2014-05-23	ABBNY-DELISTED	Stock	23.74	23.89	23.711	23.85	4992417.0
2014-05-23	ABBV	Stock	53.94	54.38	53.84	53.95	3023500.0
2014-05-23	ABC-DELISTED	Stock	71.55	71.71	71.1518	71.64	1039934.0
2014-05-23	ABCB	Stock	20.67	20.97	20.67	20.9	50500.0
2014-05-23	ABCD-DELISTED	Stock	2.3282	2.3282	2.23	2.31	1274.0
2014-05-23	ABCO-DELISTED	Stock	47.94	48.98	47.63	48.34	263520.0
2014-05-23	ABDC-DELISTED	Stock	14.8	15.0	14.8	14.95	3215.0
2014-05-23	ABE-DELISTED	Stock	14.15	14.18	14.1301	14.17	4261.0
2014-05-23	ABEO	Stock	525.0	587.5	525.0	587.5	4.0
2014-05-23	ABEV	Stock	7.45	7.47	7.39	7.4	3527000.0
2014-05-23	ABG	Stock	63.65	64.19	63.52	64.05	284000.0
2014-05-23	ABGB-DELISTED	Stock	20.32	20.4799	20.26	20.4799	994.0
2014-05-23	ABIL-DELISTED	Stock	9.8	9.96	9.77	9.77	11196.0
2014-05-23	ABM	Stock	26.41	27.54	26.3	27.25	302300.0
2014-05-23	ABMD-DELISTED	Stock	21.45	21.54	20.85	21.1	284056.0
2014-05-23	ABR	Stock	7.13	7.14	7.04	7.1	63600.0
2014-05-23	ABR.A-DELISTED	Stock	24.3	24.3	24.22	24.25	13851.0
2014-05-23	ABR.B-DELISTED	Stock	23.7899	23.7899	23.55	23.76	2300.0
2014-05-23	ABR.C-DELISTED	Stock	24.85	24.87	24.8408	24.87	5546.0

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

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