PREVIEW / stock_daily / 2012-03-12

all stock daily files

  file:    by_date/stock_daily/2012/2012-03-12.parquet
  size:    199 KB
  rows:    6,161
  symbols: 3,536

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-12	AAPL	Stock	19.6064	19.7143	19.5357	19.7143	407282400.0
2012-03-12	MSFT	Stock	31.97	32.2	31.82	32.04	34073600.0
2012-03-12	NVDA	Stock	0.372	0.3745	0.3638	0.3648	299948000.0
2012-03-12	AMZN	Stock	9.2065	9.27	9.11	9.1695	51752000.0
2012-03-12	TSLA	Stock	2.3127	2.4193	2.3067	2.4007	29449500.0
2012-03-12	TLT	Stock	116.32	116.52	115.87	115.95	5280557.0
2012-03-12	ES	Stock	36.87	37.18	36.71	37.11	1272400.0
2012-03-12	CL	Stock	47.165	47.31	46.995	47.24	2965800.0
2012-03-12	A	Stock	31.7883	31.9456	31.03	31.2017	3690580.0
2012-03-12	AABA-DELISTED	Stock	14.66	14.76	14.48	14.49	11200934.0
2012-03-12	AACC-DELISTED	Stock	4.71	4.83	4.41	4.73	30737.0
2012-03-12	AACG	Stock	6.1	6.32	6.1	6.21	5200.0
2012-03-12	AAIC-DELISTED	Stock	23.81	24.41	23.81	24.15	94786.0
2012-03-12	AAME	Stock	2.96	2.96	2.84	2.85	7500.0
2012-03-12	AAMRQ-DELISTED	Stock	0.4815	0.489	0.47	0.4725	1136385.0
2012-03-12	AAON	Stock	5.4963	5.5437	5.437	5.4667	85725.0
2012-03-12	AAP	Stock	87.39	87.91	86.97	87.49	615400.0
2012-03-12	AAT	Stock	22.05	22.05	21.33	21.7	305200.0
2012-03-12	AAU-DELISTED	Stock	2.88	2.93	2.73	2.91	92120.0
2012-03-12	AAUAF-DELISTED	Stock	2.87	2.93	2.73	2.91	92920.0
2012-03-12	AAV-DELISTED	Stock	3.67	3.67	3.59	3.6	507067.0
2012-03-12	AAWW-DELISTED	Stock	43.86	43.86	42.04	42.88	216707.0
2012-03-12	AAXJ	Stock	57.13	57.13	56.74	56.9	203633.0
2012-03-12	AAXN-DELISTED	Stock	4.04	4.1	4.02	4.05	272029.0
2012-03-12	AB	Stock	15.23	15.51	15.09	15.4	277500.0
2012-03-12	ABAC-DELISTED	Stock	1.69	1.75	1.611	1.75	27639.0
2012-03-12	ABAX-DELISTED	Stock	27.39	27.53	27.08	27.25	44417.0
2012-03-12	ABB-DELISTED	Stock	20.3	20.33	20.12	20.28	1909070.0
2012-03-12	ABBNY-DELISTED	Stock	20.3	20.33	20.12	20.3	1912104.0
2012-03-12	ABC-DELISTED	Stock	37.79	38.05	37.695	37.72	1941521.0
2012-03-12	ABCB	Stock	11.97	12.03	11.76	11.85	33100.0
2012-03-12	ABCD-DELISTED	Stock	2.84	3.02	2.81	3.0	22166.0
2012-03-12	ABCO-DELISTED	Stock	41.69	42.11	41.03	42.08	196321.0
2012-03-12	ABCW-DELISTED	Stock	0.5522	0.5522	0.502	0.5321	15140.0
2012-03-12	ABD-DELISTED	Stock	11.82	11.98	11.61	11.92	228590.0
2012-03-12	ABE-DELISTED	Stock	19.39	19.39	19.23	19.35	30112.0
2012-03-12	ABEO	Stock	1437.5	1437.5	1350.0	1412.5	28.0
2012-03-12	ABFS-DELISTED	Stock	18.59	18.59	18.09	18.28	172597.0
2012-03-12	ABG	Stock	27.2	27.2	26.58	26.97	265300.0
2012-03-12	ABH-DELISTED	Stock	14.95	15.1	14.79	15.08	171603.0
2012-03-12	ABM	Stock	23.24	23.55	22.91	23.4	253100.0
2012-03-12	ABMD-DELISTED	Stock	21.9	22.15	21.8	21.87	623656.0
2012-03-12	ABR	Stock	5.35	5.45	5.33	5.34	37500.0
2012-03-12	ABT	Stock	27.7324	28.0251	27.7324	27.9388	14106503.0
2012-03-12	ABTL-DELISTED	Stock	4.8599	4.9032	4.7484	4.8	44986.0
2012-03-12	ABUS	Stock	2.5	2.5	2.32	2.43	9200.0
2012-03-12	ABV-DELISTED	Stock	40.75	41.34	40.666	41.31	1590398.0
2012-03-12	ABVA-DELISTED	Stock	4.09	4.23	4.09	4.11	1030.0
2012-03-12	ABVT-DELISTED	Stock	71.75	72.0	71.06	71.94	84754.0
2012-03-12	ABX-DELISTED	Stock	45.53	45.86	45.23	45.61	3711573.0

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

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