PREVIEW / stock_daily / 2012-07-31

all stock daily files

  file:    by_date/stock_daily/2012/2012-07-31.parquet
  size:    199 KB
  rows:    6,161
  symbols: 3,514

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-07-31	AAPL	Stock	21.5439	21.8464	21.5257	21.8129	462327600.0
2012-07-31	MSFT	Stock	29.48	29.71	29.33	29.47	37620900.0
2012-07-31	NVDA	Stock	0.3333	0.3433	0.3328	0.3385	387788000.0
2012-07-31	AMZN	Stock	11.755	11.815	11.5805	11.665	69072000.0
2012-07-31	META	Stock	23.37	23.37	21.61	21.71	56179400.0
2012-07-31	TSLA	Stock	1.836	1.8647	1.8233	1.828	23626500.0
2012-07-31	TLT	Stock	129.81	129.88	128.58	129.7	7448593.0
2012-07-31	ES	Stock	40.43	40.51	39.23	39.88	3541900.0
2012-07-31	CL	Stock	53.625	53.86	53.43	53.68	3465000.0
2012-07-31	A	Stock	27.2031	27.6896	27.196	27.3891	3054350.0
2012-07-31	AABA-DELISTED	Stock	16.0	16.06	15.81	15.83	13665970.0
2012-07-31	AACC-DELISTED	Stock	5.76	6.028	5.35	5.82	115132.0
2012-07-31	AAIC-DELISTED	Stock	22.88	22.89	22.255	22.36	94321.0
2012-07-31	AAME	Stock	2.75	2.75	2.75	2.75	600.0
2012-07-31	AAMRQ-DELISTED	Stock	0.51	0.52	0.5	0.507	450541.0
2012-07-31	AAON	Stock	5.5052	5.6207	5.3956	5.4133	127575.0
2012-07-31	AAP	Stock	70.51	71.58	69.97	70.15	1089500.0
2012-07-31	AAT	Stock	26.48	26.48	25.71	26.0	361700.0
2012-07-31	AAU-DELISTED	Stock	2.13	2.15	2.06	2.13	86760.0
2012-07-31	AAUAF-DELISTED	Stock	2.13	2.15	2.06	2.13	86960.0
2012-07-31	AAV-DELISTED	Stock	3.92	3.94	3.84	3.88	204552.0
2012-07-31	AAWW-DELISTED	Stock	44.88	46.1	44.88	45.36	256888.0
2012-07-31	AAXJ	Stock	53.15	53.4	52.98	52.98	298257.0
2012-07-31	AAXN-DELISTED	Stock	5.42	5.49	5.39	5.4	686249.0
2012-07-31	AB	Stock	12.13	12.28	12.0	12.12	176100.0
2012-07-31	ABAC-DELISTED	Stock	1.0399	1.04	0.74	0.84	18436.0
2012-07-31	ABAX-DELISTED	Stock	35.8	36.53	35.48	35.7	164445.0
2012-07-31	ABB-DELISTED	Stock	17.3	17.47	17.28	17.35	2496146.0
2012-07-31	ABBNY-DELISTED	Stock	17.3	17.47	17.28	17.35	2546636.0
2012-07-31	ABC-DELISTED	Stock	39.48	40.2	39.06	39.68	8583231.0
2012-07-31	ABCB	Stock	12.05	12.18	11.88	11.94	29100.0
2012-07-31	ABCO-DELISTED	Stock	45.22	45.66	44.94	44.98	281801.0
2012-07-31	ABCW-DELISTED	Stock	0.43	0.45	0.4	0.45	11587.0
2012-07-31	ABE-DELISTED	Stock	19.31	19.35	19.31	19.31	1950.0
2012-07-31	ABEO	Stock	700.0	925.0	687.5	912.5	26.0
2012-07-31	ABFS-DELISTED	Stock	13.21	14.35	12.87	13.69	975932.0
2012-07-31	ABG	Stock	26.05	26.36	25.78	26.16	263300.0
2012-07-31	ABM	Stock	18.71	18.85	18.41	18.6	376700.0
2012-07-31	ABMD-DELISTED	Stock	22.35	22.72	22.16	22.55	296061.0
2012-07-31	ABR	Stock	5.36	5.4	5.36	5.39	49500.0
2012-07-31	ABT	Stock	31.9835	32.089	31.8059	31.8155	14637140.0
2012-07-31	ABTL-DELISTED	Stock	3.7	3.89	3.7	3.84	9224.0
2012-07-31	ABUS	Stock	3.37	3.59	3.37	3.51	32200.0
2012-07-31	ABV-DELISTED	Stock	39.27	39.59	38.49	38.53	5665476.0
2012-07-31	ABVA-DELISTED	Stock	4.4	4.45	4.4	4.45	3347.0
2012-07-31	ABX-DELISTED	Stock	33.24	33.5	32.73	32.88	7339159.0
2012-07-31	ACAD	Stock	1.67	1.67	1.58	1.61	258500.0
2012-07-31	ACAS-DELISTED	Stock	9.83	10.0	9.82	9.97	4845698.0
2012-07-31	ACAT-DELISTED	Stock	43.39	44.85	43.31	44.0	293486.0
2012-07-31	ACC-DELISTED	Stock	47.36	47.83	47.36	47.62	1016718.0

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

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