PREVIEW / stock_daily / 2012-06-26

all stock daily files

  file:    by_date/stock_daily/2012/2012-06-26.parquet
  size:    197 KB
  rows:    6,145
  symbols: 3,505

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
2012-06-26	AAPL	Stock	20.4046	20.5175	20.2618	20.4296	276536400.0
2012-06-26	MSFT	Stock	30.0	30.27	29.94	30.02	38421300.0
2012-06-26	NVDA	Stock	0.3165	0.3205	0.312	0.3183	437152000.0
2012-06-26	AMZN	Stock	11.0725	11.3195	11.0725	11.2805	75082000.0
2012-06-26	META	Stock	32.69	33.44	32.5	33.1	24858700.0
2012-06-26	TSLA	Stock	2.1367	2.1567	2.0927	2.1073	39208500.0
2012-06-26	TLT	Stock	126.11	126.95	125.94	126.34	5359664.0
2012-06-26	ES	Stock	37.61	38.23	37.61	38.01	1671700.0
2012-06-26	CL	Stock	49.83	50.275	49.74	50.05	3040600.0
2012-06-26	A	Stock	27.1817	27.3605	26.9099	27.1745	3521842.0
2012-06-26	AABA-DELISTED	Stock	15.42	15.42	15.19	15.345	12697640.0
2012-06-26	AACC-DELISTED	Stock	6.68	6.9	6.35	6.4	181134.0
2012-06-26	AACG	Stock	4.16	4.16	4.16	4.16	500.0
2012-06-26	AAIC-DELISTED	Stock	23.1	23.1	22.2311	22.5	194880.0
2012-06-26	AAME	Stock	2.69	2.7	2.68	2.7	600.0
2012-06-26	AAMRQ-DELISTED	Stock	0.485	0.535	0.485	0.52	2260109.0
2012-06-26	AAON	Stock	5.5556	5.5911	5.4607	5.5081	225788.0
2012-06-26	AAP	Stock	65.21	66.25	62.78	65.85	2508000.0
2012-06-26	AAT	Stock	23.36	23.6	23.18	23.37	161600.0
2012-06-26	AAU-DELISTED	Stock	2.14	2.19	2.1	2.15	75328.0
2012-06-26	AAUAF-DELISTED	Stock	2.14	2.19	2.1	2.15	75528.0
2012-06-26	AAV-DELISTED	Stock	2.55	2.6	2.52	2.6	221604.0
2012-06-26	AAWW-DELISTED	Stock	41.49	42.23	40.45	40.8	251046.0
2012-06-26	AAXJ	Stock	50.67	50.77	50.21	50.58	1151683.0
2012-06-26	AAXN-DELISTED	Stock	5.27	5.51	5.23	5.4	411115.0
2012-06-26	AB	Stock	12.25	12.31	11.99	12.03	115000.0
2012-06-26	ABAC-DELISTED	Stock	1.11	1.141	1.07	1.14	34552.0
2012-06-26	ABAX-DELISTED	Stock	35.48	35.48	35.03	35.09	57617.0
2012-06-26	ABB-DELISTED	Stock	15.39	15.55	15.26	15.49	2469239.0
2012-06-26	ABBNY-DELISTED	Stock	15.4	15.55	15.26	15.49	2601115.0
2012-06-26	ABC-DELISTED	Stock	37.81	38.0	37.57	37.71	1740619.0
2012-06-26	ABCB	Stock	11.72	12.11	11.54	11.99	51400.0
2012-06-26	ABCD-DELISTED	Stock	1.05	1.09	0.96	1.0	48799.0
2012-06-26	ABCO-DELISTED	Stock	47.83	48.32	47.69	48.06	149663.0
2012-06-26	ABCW-DELISTED	Stock	0.45	0.53	0.45	0.45	3704.0
2012-06-26	ABE-DELISTED	Stock	18.0	18.14	17.97	18.14	5823.0
2012-06-26	ABEO	Stock	787.5	975.0	787.5	875.0	55.0
2012-06-26	ABFS-DELISTED	Stock	12.09	12.16	11.78	11.84	208616.0
2012-06-26	ABG	Stock	22.39	22.5	21.25	22.18	689300.0
2012-06-26	ABM	Stock	19.51	19.95	19.38	19.84	359000.0
2012-06-26	ABMD-DELISTED	Stock	20.77	21.26	20.59	21.0	221839.0
2012-06-26	ABR	Stock	5.14	5.19	5.1	5.18	114400.0
2012-06-26	ABT	Stock	29.8148	30.0307	29.762	29.9155	7469154.0
2012-06-26	ABTL-DELISTED	Stock	4.0082	4.0603	3.6975	3.8	17547.0
2012-06-26	ABUS	Stock	1.99	1.99	1.99	1.99	900.0
2012-06-26	ABV-DELISTED	Stock	36.96	37.08	36.56	36.955	2215064.0
2012-06-26	ABVA-DELISTED	Stock	4.23	4.39	4.22	4.29	5355.0
2012-06-26	ABVT-DELISTED	Stock	83.95	83.96	83.93	83.95	117867.0
2012-06-26	ABX-DELISTED	Stock	37.74	38.14	36.58	36.93	8622327.0
2012-06-26	ACAD	Stock	1.53	1.58	1.51	1.55	326900.0

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

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