PREVIEW / stock_daily / 2012-03-06

all stock daily files

  file:    by_date/stock_daily/2012/2012-03-06.parquet
  size:    199 KB
  rows:    6,149
  symbols: 3,535

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-03-06	AAPL	Stock	18.7021	19.0604	18.4364	18.9379	810238800.0
2012-03-06	MSFT	Stock	31.54	31.98	31.49	31.56	51932900.0
2012-03-06	NVDA	Stock	0.3672	0.3703	0.3615	0.368	471400000.0
2012-03-06	AMZN	Stock	8.934	9.175	8.902	9.0545	112244000.0
2012-03-06	TSLA	Stock	2.2167	2.2187	2.1747	2.2073	8607000.0
2012-03-06	TLT	Stock	117.45	118.11	117.44	117.63	6299634.0
2012-03-06	ES	Stock	36.39	36.47	35.8	35.91	1371700.0
2012-03-06	CL	Stock	46.715	46.905	46.425	46.67	5260200.0
2012-03-06	A	Stock	30.2504	30.422	29.9642	30.2432	5251587.0
2012-03-06	AABA-DELISTED	Stock	14.6	14.69	14.35	14.41	12266741.0
2012-03-06	AACC-DELISTED	Stock	4.81	4.94	4.2	4.39	60913.0
2012-03-06	AACG	Stock	5.9	5.9	5.49	5.77	3400.0
2012-03-06	AAIC-DELISTED	Stock	22.9	23.03	22.8	22.84	46269.0
2012-03-06	AAME	Stock	2.75	2.85	2.7	2.73	15700.0
2012-03-06	AAMRQ-DELISTED	Stock	0.4501	0.459	0.44	0.453	2410170.0
2012-03-06	AAON	Stock	5.4104	5.4844	5.2919	5.3067	184275.0
2012-03-06	AAP	Stock	86.39	87.28	85.88	87.01	1314800.0
2012-03-06	AAT	Stock	22.08	22.44	21.9	21.93	168800.0
2012-03-06	AAU-DELISTED	Stock	2.74	2.79	2.61	2.68	269500.0
2012-03-06	AAUAF-DELISTED	Stock	2.74	2.79	2.61	2.67	272200.0
2012-03-06	AAV-DELISTED	Stock	3.74	3.75	3.59	3.6	448479.0
2012-03-06	AAWW-DELISTED	Stock	41.99	42.06	40.94	41.55	429168.0
2012-03-06	AAXJ	Stock	56.03	56.03	55.305	55.515	1492018.0
2012-03-06	AAXN-DELISTED	Stock	4.04	4.07	3.98	3.99	373831.0
2012-03-06	AB	Stock	14.52	14.52	14.25	14.35	268200.0
2012-03-06	ABAC-DELISTED	Stock	1.62	1.67	1.58	1.58	7835.0
2012-03-06	ABAX-DELISTED	Stock	26.5	27.21	26.46	26.96	137432.0
2012-03-06	ABB-DELISTED	Stock	19.65	19.67	19.32	19.45	3229135.0
2012-03-06	ABBNY-DELISTED	Stock	19.65	19.67	19.32	19.45	3391112.0
2012-03-06	ABC-DELISTED	Stock	36.36	36.805	36.2	36.28	3262343.0
2012-03-06	ABCB	Stock	11.52	11.75	11.52	11.52	32600.0
2012-03-06	ABCD-DELISTED	Stock	2.87	2.89	2.85	2.88	18471.0
2012-03-06	ABCO-DELISTED	Stock	40.9	41.24	40.23	40.91	606160.0
2012-03-06	ABCW-DELISTED	Stock	0.3916	0.4317	0.3916	0.4317	56020.0
2012-03-06	ABD-DELISTED	Stock	11.44	11.54	11.23	11.33	461260.0
2012-03-06	ABE-DELISTED	Stock	19.22	19.4	19.02	19.05	12642.0
2012-03-06	ABEO	Stock	1537.5	1537.5	1325.0	1437.5	54.0
2012-03-06	ABFS-DELISTED	Stock	17.66	18.02	17.3	17.45	321997.0
2012-03-06	ABG	Stock	26.43	26.5	26.02	26.25	346500.0
2012-03-06	ABH-DELISTED	Stock	15.0	15.04	14.58	14.61	179404.0
2012-03-06	ABM	Stock	22.06	23.04	22.02	22.79	455800.0
2012-03-06	ABMD-DELISTED	Stock	20.0	20.11	19.32	19.55	769407.0
2012-03-06	ABR	Stock	4.92	5.06	4.9	4.94	66400.0
2012-03-06	ABT	Stock	27.4206	27.459	27.0079	27.0367	17748854.0
2012-03-06	ABTL-DELISTED	Stock	4.9032	4.9226	4.6994	4.75	20055.0
2012-03-06	ABUS	Stock	2.57	2.74	2.25	2.25	8200.0
2012-03-06	ABV-DELISTED	Stock	39.4	39.45	38.9	39.12	1651026.0
2012-03-06	ABVA-DELISTED	Stock	3.83	4.59	3.83	3.883	4500.0
2012-03-06	ABVT-DELISTED	Stock	70.52	70.52	67.5	68.88	460711.0
2012-03-06	ABX-DELISTED	Stock	45.93	45.94	45.14	45.72	7692323.0

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

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