PREVIEW / stock_daily / 2013-09-06

all stock daily files

  file:    by_date/stock_daily/2013/2013-09-06.parquet
  size:    212 KB
  rows:    6,363
  symbols: 3,517

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-09-06	AAPL	Stock	17.8014	17.835	17.4982	17.7936	359525600.0
2013-09-06	MSFT	Stock	31.31	31.39	31.13	31.15	75434900.0
2013-09-06	NVDA	Stock	0.3738	0.3758	0.3692	0.372	226756000.0
2013-09-06	AMZN	Stock	14.7665	14.944	14.54	14.793	45840000.0
2013-09-06	META	Stock	43.09	44.61	42.4	43.95	117535700.0
2013-09-06	TSLA	Stock	11.238	11.3133	11.01	11.1313	129295500.0
2013-09-06	TLT	Stock	103.25	103.82	102.81	103.05	9478829.0
2013-09-06	ES	Stock	40.42	40.78	40.2	40.25	4731100.0
2013-09-06	CL	Stock	57.76	58.23	57.47	58.0	2752700.0
2013-09-06	A	Stock	34.1273	34.1845	33.7124	33.927	1863394.0
2013-09-06	AABA-DELISTED	Stock	28.35	28.5	27.82	28.18	10406014.0
2013-09-06	AACG	Stock	4.58	4.58	4.58	4.58	100.0
2013-09-06	AAIC-DELISTED	Stock	23.48	23.51	23.05	23.39	102725.0
2013-09-06	AAME	Stock	3.94	3.94	3.8	3.82	16500.0
2013-09-06	AAMRQ-DELISTED	Stock	3.33	3.42	3.24	3.27	4826257.0
2013-09-06	AAON	Stock	10.8533	11.0089	10.6	10.9511	222075.0
2013-09-06	AAP	Stock	80.04	80.39	78.91	79.12	546800.0
2013-09-06	AAT	Stock	29.2	29.54	28.86	29.33	63600.0
2013-09-06	AAU-DELISTED	Stock	1.715	1.76	1.68	1.69	109584.0
2013-09-06	AAUAF-DELISTED	Stock	1.71	1.75	1.68	1.7	110023.0
2013-09-06	AAV-DELISTED	Stock	3.71	3.82	3.66	3.8	140914.0
2013-09-06	AAWW-DELISTED	Stock	46.7	46.79	45.53	46.36	221430.0
2013-09-06	AAXJ	Stock	57.03	57.399	56.59	57.12	158374.0
2013-09-06	AAXN-DELISTED	Stock	12.3	12.42	11.88	12.13	858730.0
2013-09-06	AB	Stock	20.19	20.37	19.86	20.01	303600.0
2013-09-06	ABAC-DELISTED	Stock	0.8199	0.8199	0.8	0.8	32760.0
2013-09-06	ABAX-DELISTED	Stock	40.39	40.53	39.41	40.09	110800.0
2013-09-06	ABB-DELISTED	Stock	22.19	22.33	22.06	22.22	1439198.0
2013-09-06	ABBNY-DELISTED	Stock	22.19	22.33	22.06	22.23	1453208.0
2013-09-06	ABBV	Stock	43.53	44.35	42.89	43.89	3992200.0
2013-09-06	ABC-DELISTED	Stock	58.2	58.625	57.47	58.24	823604.0
2013-09-06	ABCB	Stock	19.34	19.34	18.62	19.21	25600.0
2013-09-06	ABCD-DELISTED	Stock	1.4	1.53	1.4	1.5	27654.0
2013-09-06	ABCO-DELISTED	Stock	56.99	58.0	55.4	57.9	122593.0
2013-09-06	ABE-DELISTED	Stock	18.48	18.618	18.45	18.5358	4094.0
2013-09-06	ABEO	Stock	462.5	500.0	462.5	500.0	39.0
2013-09-06	ABFS-DELISTED	Stock	25.94	25.94	25.025	25.89	523723.0
2013-09-06	ABG	Stock	52.11	52.79	50.61	51.89	261600.0
2013-09-06	ABM	Stock	25.6	25.6	24.84	25.3	204300.0
2013-09-06	ABMD-DELISTED	Stock	24.04	24.15	23.24	23.86	106425.0
2013-09-06	ABR	Stock	7.04	7.09	6.94	7.0	37400.0
2013-09-06	ABR.A-DELISTED	Stock	24.29	24.6	24.26	24.3899	2500.0
2013-09-06	ABR.B-DELISTED	Stock	23.929	23.929	23.315	23.315	1270.0
2013-09-06	ABT	Stock	33.72	33.75	33.25	33.5	6664200.0
2013-09-06	ABTL-DELISTED	Stock	6.79	7.098	6.72	7.02	106798.0
2013-09-06	ABUS	Stock	5.62	5.64	5.53	5.53	18300.0
2013-09-06	ABV-DELISTED	Stock	35.66	35.95	35.29	35.37	1967182.0
2013-09-06	ABX-DELISTED	Stock	19.33	19.519	19.03	19.07	14564664.0
2013-09-06	ACAD	Stock	21.37	21.7	20.6	21.41	1454900.0
2013-09-06	ACAS-DELISTED	Stock	12.99	13.09	12.86	13.05	1861292.0

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

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