PREVIEW / stock_daily / 2012-04-04

all stock daily files

  file:    by_date/stock_daily/2012/2012-04-04.parquet
  size:    199 KB
  rows:    6,154
  symbols: 3,527

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-04-04	AAPL	Stock	22.2982	22.3521	22.0357	22.2968	572980800.0
2012-04-04	MSFT	Stock	31.66	31.69	31.05	31.21	49455900.0
2012-04-04	NVDA	Stock	0.3713	0.376	0.364	0.3662	495896000.0
2012-04-04	AMZN	Stock	9.8475	9.884	9.618	9.6995	109138000.0
2012-04-04	TSLA	Stock	2.3513	2.366	2.3127	2.3333	67227000.0
2012-04-04	TLT	Stock	111.77	112.12	111.41	112.1001	10095599.0
2012-04-04	ES	Stock	37.07	37.22	36.8	37.03	3007600.0
2012-04-04	CL	Stock	48.79	49.125	48.785	48.925	3540400.0
2012-04-04	A	Stock	31.7167	31.7954	31.0086	31.2876	3342338.0
2012-04-04	AABA-DELISTED	Stock	15.15	15.34	15.0	15.2784	20567424.0
2012-04-04	AACC-DELISTED	Stock	4.97	4.9893	4.81	4.85	38525.0
2012-04-04	AACG	Stock	7.04	7.11	6.45	6.63	19300.0
2012-04-04	AAIC-DELISTED	Stock	22.99	22.99	22.5	22.7	92030.0
2012-04-04	AAME	Stock	2.85	2.89	2.83	2.89	2400.0
2012-04-04	AAMRQ-DELISTED	Stock	0.483	0.51	0.483	0.502	4777371.0
2012-04-04	AAON	Stock	5.84	5.8904	5.7393	5.8904	161325.0
2012-04-04	AAP	Stock	89.11	90.04	88.67	89.73	736400.0
2012-04-04	AAT	Stock	22.77	23.11	22.77	23.0	74800.0
2012-04-04	AAU-DELISTED	Stock	2.56	2.56	2.42	2.49	155502.0
2012-04-04	AAUAF-DELISTED	Stock	2.56	2.56	2.42	2.49	155702.0
2012-04-04	AAV-DELISTED	Stock	3.24	3.26	3.16	3.19	293840.0
2012-04-04	AAWW-DELISTED	Stock	48.85	49.18	48.1	48.68	179916.0
2012-04-04	AAXJ	Stock	56.05	56.13	55.699	56.0	186884.0
2012-04-04	AAXN-DELISTED	Stock	4.26	4.28	4.16	4.18	324749.0
2012-04-04	AB	Stock	15.41	15.54	15.1	15.33	175500.0
2012-04-04	ABAC-DELISTED	Stock	1.61	1.68	1.61	1.64	3512.0
2012-04-04	ABAX-DELISTED	Stock	28.88	29.79	28.2	28.53	93216.0
2012-04-04	ABB-DELISTED	Stock	19.95	20.05	19.855	19.98	2813936.0
2012-04-04	ABBNY-DELISTED	Stock	19.95	20.05	19.855	19.98	2881081.0
2012-04-04	ABC-DELISTED	Stock	38.4	38.79	38.3	38.48	2064315.0
2012-04-04	ABCB	Stock	13.06	13.09	12.84	12.97	46000.0
2012-04-04	ABCD-DELISTED	Stock	2.61	2.75	2.55	2.58	14278.0
2012-04-04	ABCO-DELISTED	Stock	43.04	43.88	42.54	42.68	260828.0
2012-04-04	ABCW-DELISTED	Stock	0.9438	1.0036	0.9036	0.9438	28100.0
2012-04-04	ABD-DELISTED	Stock	12.41	12.41	11.94	12.04	442490.0
2012-04-04	ABE-DELISTED	Stock	19.61	19.61	19.38	19.38	4076.0
2012-04-04	ABEO	Stock	1437.5	1487.5	1375.0	1487.5	67.0
2012-04-04	ABFS-DELISTED	Stock	19.09	19.34	18.71	19.25	216403.0
2012-04-04	ABG	Stock	28.22	28.74	28.05	28.25	358700.0
2012-04-04	ABH-DELISTED	Stock	13.83	13.88	13.72	13.83	226595.0
2012-04-04	ABM	Stock	23.73	23.9	23.59	23.85	339300.0
2012-04-04	ABMD-DELISTED	Stock	21.91	21.95	21.36	21.55	313245.0
2012-04-04	ABR	Stock	5.38	5.39	5.15	5.24	50300.0
2012-04-04	ABT	Stock	29.3254	30.0211	29.1478	29.4885	29653397.0
2012-04-04	ABTL-DELISTED	Stock	4.8005	4.9127	4.7252	4.75	11341.0
2012-04-04	ABUS	Stock	2.6	2.8	2.54	2.64	6400.0
2012-04-04	ABV-DELISTED	Stock	41.5	41.5	40.63	40.89	4165672.0
2012-04-04	ABVA-DELISTED	Stock	4.13	4.137	4.02	4.074	2450.0
2012-04-04	ABVT-DELISTED	Stock	82.86	82.95	82.85	82.88	414423.0
2012-04-04	ABX-DELISTED	Stock	42.15	42.48	40.46	41.3	14384786.0

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

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