PREVIEW / stock_daily / 2010-08-13

all stock daily files

  file:    by_date/stock_daily/2010/2010-08-13.parquet
  size:    188 KB
  rows:    5,917
  symbols: 3,473

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
2010-08-13	AAPL	Stock	8.9875	8.9957	8.8961	8.8964	354869200.0
2010-08-13	MSFT	Stock	24.35	24.67	24.24	24.4	45263500.0
2010-08-13	NVDA	Stock	0.2312	0.238	0.2308	0.2348	1797392000.0
2010-08-13	AMZN	Stock	6.303	6.374	6.213	6.2345	79532000.0
2010-08-13	TSLA	Stock	1.212	1.23	1.1773	1.2213	9510000.0
2010-08-13	TLT	Stock	101.62	102.45	101.48	102.29	7844008.0
2010-08-13	ES	Stock	28.46	29.0	28.46	28.75	961100.0
2010-08-13	CL	Stock	38.37	38.585	38.15	38.195	4805400.0
2010-08-13	A	Stock	19.5923	19.9213	19.5279	19.5637	3420906.0
2010-08-13	AABA-DELISTED	Stock	13.81	13.955	13.76	13.83	7798305.0
2010-08-13	AACC-DELISTED	Stock	4.06	4.46	3.94	4.0	32415.0
2010-08-13	AACG	Stock	2.92	2.95	2.91	2.95	700.0
2010-08-13	AAI-DELISTED	Stock	4.58	4.61	4.47	4.59	4341441.0
2010-08-13	AAIC-DELISTED	Stock	20.12	20.12	19.46	19.92	62314.0
2010-08-13	AAME	Stock	1.3	1.3	1.3	1.3	200.0
2010-08-13	AAON	Stock	4.4484	4.5037	4.4444	4.4444	219712.0
2010-08-13	AAP	Stock	54.61	54.78	53.94	54.26	1118200.0
2010-08-13	AATI-DELISTED	Stock	3.08	3.09	3.0	3.0	180145.0
2010-08-13	AAU-DELISTED	Stock	1.89	1.97	1.82	1.83	1459309.0
2010-08-13	AAUAF-DELISTED	Stock	1.89	1.97	1.82	1.83	1462459.0
2010-08-13	AAV-DELISTED	Stock	5.82	6.18	5.82	6.0	529867.0
2010-08-13	AAWW-DELISTED	Stock	45.96	46.2	45.03	45.64	395970.0
2010-08-13	AAXJ	Stock	54.92	55.29	54.92	55.11	157786.0
2010-08-13	AAXN-DELISTED	Stock	3.96	4.04	3.87	3.88	367107.0
2010-08-13	AB	Stock	25.98	26.39	25.77	26.11	300300.0
2010-08-13	ABAC-DELISTED	Stock	3.8	4.43	3.8	4.39	103525.0
2010-08-13	ABAX-DELISTED	Stock	19.5	19.59	19.12	19.4	86858.0
2010-08-13	ABB-DELISTED	Stock	18.94	19.06	18.89	18.95	1101794.0
2010-08-13	ABBC-DELISTED	Stock	9.4	9.53	9.4	9.51	65152.0
2010-08-13	ABBNY-DELISTED	Stock	18.94	19.06	18.89	18.93	1119934.0
2010-08-13	ABC-DELISTED	Stock	29.01	29.13	28.69	29.03	1609292.0
2010-08-13	ABCB	Stock	8.78	8.82	8.53	8.55	51600.0
2010-08-13	ABCD-DELISTED	Stock	3.23	3.27	3.1	3.18	593369.0
2010-08-13	ABCO-DELISTED	Stock	21.37	21.43	21.04	21.2	130725.0
2010-08-13	ABCW-DELISTED	Stock	0.6195	0.6473	0.6195	0.6205	41820.0
2010-08-13	ABD-DELISTED	Stock	5.93	6.03	5.89	5.99	410870.0
2010-08-13	ABE-DELISTED	Stock	16.94	17.19	16.94	17.14	11700.0
2010-08-13	ABEO	Stock	2500.0	2525.0	2312.5	2487.5	32.0
2010-08-13	ABFS-DELISTED	Stock	20.31	20.78	19.7	19.71	202493.0
2010-08-13	ABG	Stock	13.12	13.33	12.85	12.88	132900.0
2010-08-13	ABII-DELISTED	Stock	75.56	75.76	75.29	75.34	97751.0
2010-08-13	ABK-DELISTED	Stock	0.69	0.7	0.65	0.6515	12489948.0
2010-08-13	ABM	Stock	20.2	20.44	20.0	20.15	156900.0
2010-08-13	ABMD-DELISTED	Stock	9.77	9.93	9.7	9.9	138115.0
2010-08-13	ABR	Stock	5.07	5.29	4.99	5.03	66300.0
2010-08-13	ABT	Stock	24.0476	24.1147	23.9468	24.0188	10601917.0
2010-08-13	ABTL-DELISTED	Stock	4.5236	4.7076	4.3	4.3	23073.0
2010-08-13	ABV-DELISTED	Stock	104.53	105.5	103.48	104.25	476196.0
2010-08-13	ABVT-DELISTED	Stock	50.16	50.3796	49.49	49.52	106758.0
2010-08-13	ABX-DELISTED	Stock	43.25	43.45	42.83	42.95	5487286.0

> showing 50 of 5,917 rows — these rows as CSV

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