PREVIEW / stock_daily / 2013-08-23

all stock daily files

  file:    by_date/stock_daily/2013/2013-08-23.parquet
  size:    212 KB
  rows:    6,374
  symbols: 3,529

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-08-23	AAPL	Stock	17.9739	17.9768	17.8339	17.8936	222731600.0
2013-08-23	MSFT	Stock	35.17	35.2	34.0	34.75	225493800.0
2013-08-23	NVDA	Stock	0.3745	0.3775	0.3733	0.374	245120000.0
2013-08-23	AMZN	Stock	14.5605	14.575	14.395	14.5005	39238000.0
2013-08-23	META	Stock	39.0	40.63	38.93	40.55	86442300.0
2013-08-23	TSLA	Stock	10.4667	10.82	10.3333	10.7893	193978500.0
2013-08-23	TLT	Stock	103.01	104.39	102.74	104.29	17441179.0
2013-08-23	ES	Stock	41.31	41.72	41.11	41.71	1548700.0
2013-08-23	CL	Stock	58.51	59.08	58.44	59.03	2728900.0
2013-08-23	A	Stock	34.3062	34.3348	34.0057	34.1059	2377998.0
2013-08-23	AABA-DELISTED	Stock	28.31	28.32	27.81	27.99	12688827.0
2013-08-23	AACG	Stock	5.1	5.1	5.1	5.1	600.0
2013-08-23	AAIC-DELISTED	Stock	23.53	23.809	23.46	23.63	85543.0
2013-08-23	AAME	Stock	3.88	3.94	3.57	3.91	42800.0
2013-08-23	AAMRQ-DELISTED	Stock	3.082	3.14	3.08	3.14	5607494.0
2013-08-23	AAON	Stock	11.0444	11.1378	10.7822	10.9111	120600.0
2013-08-23	AAP	Stock	82.04	83.17	81.77	83.01	479100.0
2013-08-23	AAT	Stock	29.94	30.16	29.87	30.15	318000.0
2013-08-23	AAU-DELISTED	Stock	1.91	1.9499	1.82	1.87	188268.0
2013-08-23	AAUAF-DELISTED	Stock	1.91	1.9499	1.82	1.87	188568.0
2013-08-23	AAV-DELISTED	Stock	3.62	3.74	3.56	3.71	133697.0
2013-08-23	AAWW-DELISTED	Stock	46.99	47.44	46.38	47.26	191984.0
2013-08-23	AAXJ	Stock	54.66	54.89	54.52	54.79	344743.0
2013-08-23	AAXN-DELISTED	Stock	11.4	11.47	11.27	11.39	898416.0
2013-08-23	AB	Stock	19.5	19.8	19.45	19.62	472000.0
2013-08-23	ABAC-DELISTED	Stock	1.0	1.05	0.96	0.9899	126795.0
2013-08-23	ABAX-DELISTED	Stock	41.28	41.71	40.87	41.26	96673.0
2013-08-23	ABB-DELISTED	Stock	22.54	22.71	22.48	22.69	701443.0
2013-08-23	ABBNY-DELISTED	Stock	22.54	22.71	22.48	22.7	825418.0
2013-08-23	ABBV	Stock	43.01	43.5	42.85	43.43	2738100.0
2013-08-23	ABC-DELISTED	Stock	57.41	57.63	57.1	57.45	1490996.0
2013-08-23	ABCB	Stock	18.94	19.5	18.82	19.44	107200.0
2013-08-23	ABCD-DELISTED	Stock	1.41	1.59	1.35	1.54	125925.0
2013-08-23	ABCO-DELISTED	Stock	56.79	56.81	56.01	56.8	88453.0
2013-08-23	ABE-DELISTED	Stock	19.15	19.16	19.0401	19.07	6707.0
2013-08-23	ABEO	Stock	425.0	425.0	375.0	412.5	20.0
2013-08-23	ABFS-DELISTED	Stock	25.3	25.3	24.75	25.02	287348.0
2013-08-23	ABG	Stock	50.2	50.5	49.54	50.02	155100.0
2013-08-23	ABM	Stock	25.47	25.86	25.35	25.82	100900.0
2013-08-23	ABMD-DELISTED	Stock	22.53	22.53	22.29	22.42	100569.0
2013-08-23	ABR	Stock	7.0	7.1	6.9	7.1	59000.0
2013-08-23	ABR.A-DELISTED	Stock	23.5	24.2799	22.8736	24.2799	4076.0
2013-08-23	ABR.B-DELISTED	Stock	22.5	22.5501	22.5	22.55	800.0
2013-08-23	ABT	Stock	34.85	34.87	34.43	34.84	4017400.0
2013-08-23	ABTL-DELISTED	Stock	6.025	6.087	5.9	6.06	58006.0
2013-08-23	ABUS	Stock	5.24	5.24	5.15	5.2	22700.0
2013-08-23	ABV-DELISTED	Stock	34.8	35.1	34.43	35.06	2830413.0
2013-08-23	ABX-DELISTED	Stock	19.59	20.3	19.38	20.06	17878306.0
2013-08-23	ACAD	Stock	20.53	20.81	20.34	20.63	942300.0
2013-08-23	ACAS-DELISTED	Stock	12.97	13.08	12.88	13.06	2642170.0

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

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