PREVIEW / stock_daily / 2013-05-14

all stock daily files

  file:    by_date/stock_daily/2013/2013-05-14.parquet
  size:    212 KB
  rows:    6,349
  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
2013-05-14	AAPL	Stock	16.2089	16.2571	15.7911	15.8521	447118000.0
2013-05-14	MSFT	Stock	32.86	33.53	32.8	33.53	56870100.0
2013-05-14	NVDA	Stock	0.3602	0.3642	0.3568	0.3612	454140000.0
2013-05-14	AMZN	Stock	13.225	13.47	13.2015	13.4165	54000000.0
2013-05-14	META	Stock	26.89	27.28	26.82	27.07	24930300.0
2013-05-14	TSLA	Stock	6.2813	6.4747	5.41	5.5493	557458500.0
2013-05-14	TLT	Stock	118.35	118.44	116.54	116.56	9236243.0
2013-05-14	ES	Stock	43.47	44.07	43.39	43.94	1109100.0
2013-05-14	CL	Stock	60.5	61.675	60.5	61.675	3101000.0
2013-05-14	A	Stock	30.7439	31.5165	30.6724	31.4521	8503615.0
2013-05-14	AABA-DELISTED	Stock	26.76	26.87	26.52	26.63	14807904.0
2013-05-14	AACC-DELISTED	Stock	6.578	6.59	6.53	6.56	27533.0
2013-05-14	AACG	Stock	4.2	4.2	4.12	4.12	2900.0
2013-05-14	AAIC-DELISTED	Stock	27.89	28.15	27.82	28.04	160460.0
2013-05-14	AAMC-DELISTED	Stock	81.7647	84.7059	81.7647	82.6471	28410.0
2013-05-14	AAME	Stock	3.62	3.75	3.5	3.72	24100.0
2013-05-14	AAMRQ-DELISTED	Stock	5.45	5.98	5.45	5.79	11699838.0
2013-05-14	AAON	Stock	8.8474	8.9452	8.7852	8.9422	118800.0
2013-05-14	AAP	Stock	85.18	86.23	84.96	86.12	387700.0
2013-05-14	AAT	Stock	35.08	35.29	35.0	35.12	107300.0
2013-05-14	AAU-DELISTED	Stock	1.61	1.61	1.57	1.58	71240.0
2013-05-14	AAUAF-DELISTED	Stock	1.61	1.61	1.57	1.58	73240.0
2013-05-14	AAV-DELISTED	Stock	3.72	3.85	3.72	3.74	335335.0
2013-05-14	AAWW-DELISTED	Stock	44.35	46.49	44.35	46.0	600208.0
2013-05-14	AAXJ	Stock	60.57	60.75	60.42	60.63	371037.0
2013-05-14	AAXN-DELISTED	Stock	8.93	9.17	8.93	9.09	464424.0
2013-05-14	AB	Stock	24.46	24.89	24.12	24.6	372700.0
2013-05-14	ABAC-DELISTED	Stock	0.7	0.7227	0.68	0.69	21240.0
2013-05-14	ABAX-DELISTED	Stock	46.87	47.25	46.48	47.07	258554.0
2013-05-14	ABB-DELISTED	Stock	22.31	22.37	22.01	22.09	3020010.0
2013-05-14	ABBNY-DELISTED	Stock	22.3	22.37	22.01	22.09	3134567.0
2013-05-14	ABBV	Stock	44.09	45.52	44.09	45.35	5760300.0
2013-05-14	ABC-DELISTED	Stock	54.47	54.99	54.25	54.97	2110756.0
2013-05-14	ABCB	Stock	15.48	15.85	15.48	15.78	46700.0
2013-05-14	ABCD-DELISTED	Stock	1.18	1.3	1.07	1.1	19580.0
2013-05-14	ABCO-DELISTED	Stock	48.26	49.75	48.26	49.06	413017.0
2013-05-14	ABCW-DELISTED	Stock	0.64	0.659	0.64	0.64	22393.0
2013-05-14	ABE-DELISTED	Stock	21.69	21.7196	21.56	21.5701	7696.0
2013-05-14	ABEO	Stock	575.0	575.0	550.0	575.0	36.0
2013-05-14	ABFS-DELISTED	Stock	16.63	16.99	16.45	16.81	964397.0
2013-05-14	ABG	Stock	41.66	43.99	41.51	43.05	342700.0
2013-05-14	ABM	Stock	22.28	22.52	22.22	22.52	264300.0
2013-05-14	ABMD-DELISTED	Stock	23.3	23.4799	23.02	23.14	537382.0
2013-05-14	ABR	Stock	7.1	7.26	7.1	7.24	187100.0
2013-05-14	ABR.A-DELISTED	Stock	25.46	25.65	25.46	25.63	18484.0
2013-05-14	ABR.B-DELISTED	Stock	25.69	25.69	24.91	24.91	50393.0
2013-05-14	ABT	Stock	36.42	37.1	36.22	37.05	6309000.0
2013-05-14	ABTL-DELISTED	Stock	4.3	4.335	4.18	4.25	10183.0
2013-05-14	ABUS	Stock	4.85	4.92	4.66	4.89	67300.0
2013-05-14	ABV-DELISTED	Stock	42.84	43.41	42.78	43.26	2212905.0

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

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