PREVIEW / stock_daily / 2013-06-28

all stock daily files

  file:    by_date/stock_daily/2013/2013-06-28.parquet
  size:    210 KB
  rows:    6,334
  symbols: 3,515

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-06-28	AAPL	Stock	13.9771	14.2954	13.8882	14.1618	578516400.0
2013-06-28	MSFT	Stock	34.38	34.79	34.34	34.54	65545500.0
2013-06-28	NVDA	Stock	0.3502	0.3545	0.3458	0.351	431536000.0
2013-06-28	AMZN	Stock	13.8095	13.9915	13.8095	13.8845	63866000.0
2013-06-28	META	Stock	24.68	24.98	24.42	24.88	96778900.0
2013-06-28	TSLA	Stock	7.238	7.296	7.114	7.1573	86229000.0
2013-06-28	TLT	Stock	109.01	110.48	108.7199	110.43	12017001.0
2013-06-28	ES	Stock	41.71	42.34	41.36	42.02	3032700.0
2013-06-28	CL	Stock	57.1	57.67	56.8	57.29	5508900.0
2013-06-28	A	Stock	30.7582	30.98	30.5651	30.5866	7767707.0
2013-06-28	AABA-DELISTED	Stock	25.43	25.54	24.89	25.105	26586908.0
2013-06-28	AACG	Stock	4.25	4.25	4.25	4.25	200.0
2013-06-28	AAIC-DELISTED	Stock	26.38	26.78	26.16	26.74	241579.0
2013-06-28	AAMC-DELISTED	Stock	76.4853	79.4118	76.4853	79.4118	2907.0
2013-06-28	AAME	Stock	3.89	3.91	3.83	3.9	8300.0
2013-06-28	AAMRQ-DELISTED	Stock	3.975	4.11	3.95	4.03	2699535.0
2013-06-28	AAON	Stock	9.8104	10.0089	9.4815	9.8015	658125.0
2013-06-28	AAP	Stock	80.01	81.75	79.7	81.17	831400.0
2013-06-28	AAT	Stock	31.1	31.11	30.74	30.86	226500.0
2013-06-28	AAU-DELISTED	Stock	1.22	1.42	1.22	1.41	214908.0
2013-06-28	AAUAF-DELISTED	Stock	1.22	1.42	1.22	1.41	215008.0
2013-06-28	AAV-DELISTED	Stock	3.86	3.95	3.83	3.93	115113.0
2013-06-28	AAWW-DELISTED	Stock	43.73	44.61	43.68	43.75	315329.0
2013-06-28	AAXJ	Stock	54.48	54.865	54.26	54.77	684230.0
2013-06-28	AAXN-DELISTED	Stock	8.59	8.7	8.43	8.51	862165.0
2013-06-28	AB	Stock	21.71	21.77	20.59	20.82	484200.0
2013-06-28	ABAC-DELISTED	Stock	0.56	0.6049	0.54	0.57	41731.0
2013-06-28	ABAX-DELISTED	Stock	46.67	47.97	46.5	47.5	174243.0
2013-06-28	ABB-DELISTED	Stock	21.68	21.74	21.55	21.66	1314662.0
2013-06-28	ABBNY-DELISTED	Stock	21.68	21.74	21.55	21.66	1386708.0
2013-06-28	ABBV	Stock	42.53	42.97	41.32	41.34	10753100.0
2013-06-28	ABC-DELISTED	Stock	55.5	56.33	55.03	55.82	3145233.0
2013-06-28	ABCB	Stock	16.62	17.0	16.62	16.85	274600.0
2013-06-28	ABCD-DELISTED	Stock	1.22	1.26	1.22	1.26	600.0
2013-06-28	ABCO-DELISTED	Stock	54.41	55.31	53.95	54.57	159666.0
2013-06-28	ABCW-DELISTED	Stock	0.56	0.58	0.56	0.56	4730.0
2013-06-28	ABE-DELISTED	Stock	19.25	20.01	19.2	19.9	13046.0
2013-06-28	ABFS-DELISTED	Stock	22.0	23.45	22.0	22.88	1945744.0
2013-06-28	ABG	Stock	40.01	40.66	39.88	40.1	403300.0
2013-06-28	ABM	Stock	24.59	24.99	24.48	24.51	458400.0
2013-06-28	ABMD-DELISTED	Stock	21.3	21.75	21.3	21.57	639070.0
2013-06-28	ABR	Stock	6.25	6.37	6.05	6.28	191400.0
2013-06-28	ABR.A-DELISTED	Stock	24.98	25.0	24.8	24.8	16050.0
2013-06-28	ABR.B-DELISTED	Stock	24.262	24.29	23.948	24.29	4920.0
2013-06-28	ABT	Stock	35.3	35.82	34.87	34.88	20356100.0
2013-06-28	ABTL-DELISTED	Stock	4.56	4.76	4.56	4.76	34978.0
2013-06-28	ABUS	Stock	4.74	4.82	4.61	4.7	25200.0
2013-06-28	ABV-DELISTED	Stock	35.65	38.08	35.65	37.35	7058185.0
2013-06-28	ABX-DELISTED	Stock	14.73	15.92	14.67	15.76	30656903.0
2013-06-28	ACAD	Stock	18.43	18.56	17.81	18.15	12198700.0

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

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