PREVIEW / stock_daily / 2013-05-09

all stock daily files

  file:    by_date/stock_daily/2013/2013-05-09.parquet
  size:    209 KB
  rows:    6,306
  symbols: 3,509

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-09	AAPL	Stock	16.4218	16.5357	16.2707	16.3132	398487600.0
2013-05-09	MSFT	Stock	32.85	33.0	32.59	32.66	46417800.0
2013-05-09	NVDA	Stock	0.3413	0.3493	0.3408	0.3478	566800000.0
2013-05-09	AMZN	Stock	12.9365	13.1775	12.844	13.008	55386000.0
2013-05-09	META	Stock	27.08	27.55	26.85	27.04	33457200.0
2013-05-09	TSLA	Stock	4.6747	5.0513	4.246	4.6267	429075000.0
2013-05-09	TLT	Stock	120.51	121.32	119.98	120.04	7526916.0
2013-05-09	ES	Stock	44.48	44.52	43.43	43.56	1989300.0
2013-05-09	CL	Stock	60.17	60.355	59.895	60.095	3025200.0
2013-05-09	A	Stock	30.7368	30.9013	30.4936	30.8727	4415863.0
2013-05-09	AABA-DELISTED	Stock	26.41	26.49	26.14	26.23	10557764.0
2013-05-09	AACC-DELISTED	Stock	6.52	6.53	6.505	6.51	204717.0
2013-05-09	AAIC-DELISTED	Stock	27.95	28.0476	27.68	27.74	140021.0
2013-05-09	AAMC-DELISTED	Stock	67.7206	81.7647	64.5588	76.4412	180839.0
2013-05-09	AAME	Stock	3.55	3.55	3.4	3.43	11900.0
2013-05-09	AAMRQ-DELISTED	Stock	4.94	5.21	4.93	5.03	9742959.0
2013-05-09	AAON	Stock	8.4178	9.0133	8.4148	8.9096	414788.0
2013-05-09	AAP	Stock	84.92	85.7	84.59	84.72	428100.0
2013-05-09	AAT	Stock	35.67	35.72	35.14	35.19	201100.0
2013-05-09	AAU-DELISTED	Stock	1.62	1.69	1.5802	1.61	107975.0
2013-05-09	AAUAF-DELISTED	Stock	1.62	1.69	1.5802	1.61	108275.0
2013-05-09	AAV-DELISTED	Stock	3.8	3.86	3.74	3.75	275900.0
2013-05-09	AAWW-DELISTED	Stock	44.71	44.91	44.13	44.51	343376.0
2013-05-09	AAXJ	Stock	61.34	61.465	61.0	61.22	419206.0
2013-05-09	AAXN-DELISTED	Stock	8.98	9.17	8.915	9.0	490358.0
2013-05-09	AB	Stock	25.2	25.45	25.01	25.29	272400.0
2013-05-09	ABAC-DELISTED	Stock	0.7	0.73	0.681	0.69	7800.0
2013-05-09	ABAX-DELISTED	Stock	45.44	45.716	44.8235	45.61	135299.0
2013-05-09	ABB-DELISTED	Stock	23.03	23.03	22.675	22.72	1276019.0
2013-05-09	ABBNY-DELISTED	Stock	23.03	23.03	22.675	22.74	1282183.0
2013-05-09	ABBV	Stock	43.34	44.45	43.25	44.24	5046900.0
2013-05-09	ABC-DELISTED	Stock	54.91	55.09	54.49	54.8	1657627.0
2013-05-09	ABCB	Stock	15.61	15.8	15.5	15.51	56300.0
2013-05-09	ABCD-DELISTED	Stock	0.95	1.01	0.95	1.01	18989.0
2013-05-09	ABCO-DELISTED	Stock	46.0	46.1	45.37	45.64	387331.0
2013-05-09	ABCW-DELISTED	Stock	0.66	0.66	0.641	0.641	4170.0
2013-05-09	ABE-DELISTED	Stock	22.16	22.16	21.8666	21.94	8648.0
2013-05-09	ABEO	Stock	575.0	575.0	562.5	562.5	9.0
2013-05-09	ABFS-DELISTED	Stock	15.61	17.18	15.5	16.73	1323695.0
2013-05-09	ABG	Stock	42.52	42.65	41.54	41.76	137400.0
2013-05-09	ABM	Stock	22.36	22.44	22.08	22.19	331800.0
2013-05-09	ABMD-DELISTED	Stock	20.5	21.32	20.41	21.07	630980.0
2013-05-09	ABR	Stock	7.62	7.62	7.41	7.53	127800.0
2013-05-09	ABR.A-DELISTED	Stock	26.1	26.13	26.06	26.0601	8740.0
2013-05-09	ABT	Stock	36.19	36.36	36.0	36.18	4861500.0
2013-05-09	ABTL-DELISTED	Stock	4.25	4.34	4.18	4.34	14764.0
2013-05-09	ABUS	Stock	4.63	4.64	4.59	4.6	13000.0
2013-05-09	ABV-DELISTED	Stock	41.67	42.66	41.4	42.1	4118648.0
2013-05-09	ABX-DELISTED	Stock	21.1	21.7	20.77	20.91	19694123.0
2013-05-09	ACAD	Stock	11.6	12.25	11.6	11.93	1708900.0

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

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