PREVIEW / stock_daily / 2012-06-12

all stock daily files

  file:    by_date/stock_daily/2012/2012-06-12.parquet
  size:    197 KB
  rows:    6,161
  symbols: 3,524

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-12	AAPL	Stock	20.5164	20.5936	20.2393	20.5771	435380400.0
2012-06-12	MSFT	Stock	29.1	29.3	28.84	29.29	35337900.0
2012-06-12	NVDA	Stock	0.31	0.3158	0.3095	0.3128	496128000.0
2012-06-12	AMZN	Stock	10.8825	10.9	10.726	10.821	56666000.0
2012-06-12	META	Stock	27.48	27.77	26.96	27.4	15816800.0
2012-06-12	TSLA	Stock	1.9487	1.9893	1.9207	1.9773	8535000.0
2012-06-12	TLT	Stock	124.97	125.63	124.5	124.63	10921679.0
2012-06-12	ES	Stock	37.33	37.43	36.92	37.4	1782200.0
2012-06-12	CL	Stock	49.995	50.095	49.645	50.025	3719600.0
2012-06-12	A	Stock	27.8541	28.269	27.5751	28.2332	2518916.0
2012-06-12	AABA-DELISTED	Stock	15.35	15.52	15.26	15.47	16394622.0
2012-06-12	AACC-DELISTED	Stock	5.66	5.85	5.6	5.66	22924.0
2012-06-12	AACG	Stock	5.1	5.1	4.76	4.76	1300.0
2012-06-12	AAIC-DELISTED	Stock	22.04	22.39	21.8	22.32	39063.0
2012-06-12	AAME	Stock	2.71	2.74	2.69	2.72	1600.0
2012-06-12	AAMRQ-DELISTED	Stock	0.442	0.459	0.44	0.455	1166872.0
2012-06-12	AAON	Stock	5.7215	5.8104	5.5941	5.763	154913.0
2012-06-12	AAP	Stock	72.38	73.48	72.07	73.35	660700.0
2012-06-12	AAT	Stock	22.95	23.08	22.72	23.04	99800.0
2012-06-12	AAU-DELISTED	Stock	2.18	2.3	2.14	2.22	118556.0
2012-06-12	AAUAF-DELISTED	Stock	2.22	2.3299	2.18	2.22	116950.0
2012-06-12	AAV-DELISTED	Stock	2.75	2.77	2.7	2.71	139804.0
2012-06-12	AAWW-DELISTED	Stock	44.12	44.865	43.33	44.41	157499.0
2012-06-12	AAXJ	Stock	51.26	51.66	51.113	51.65	223385.0
2012-06-12	AAXN-DELISTED	Stock	5.29	5.34	5.19	5.32	615581.0
2012-06-12	AB	Stock	11.92	11.97	11.71	11.84	328100.0
2012-06-12	ABAC-DELISTED	Stock	1.37	1.38	1.35	1.35	3512.0
2012-06-12	ABAX-DELISTED	Stock	32.9	33.55	32.6	33.29	95781.0
2012-06-12	ABB-DELISTED	Stock	16.25	16.42	16.16	16.42	2394754.0
2012-06-12	ABBNY-DELISTED	Stock	16.25	16.43	16.16	16.43	2396038.0
2012-06-12	ABC-DELISTED	Stock	36.47	37.02	36.21	37.02	2289813.0
2012-06-12	ABCB	Stock	11.35	11.57	11.28	11.5	52000.0
2012-06-12	ABCD-DELISTED	Stock	1.33	1.37	1.14	1.15	86018.0
2012-06-12	ABCO-DELISTED	Stock	47.65	47.94	46.94	47.89	169302.0
2012-06-12	ABCW-DELISTED	Stock	0.4016	0.4016	0.4016	0.4016	970.0
2012-06-12	ABE-DELISTED	Stock	17.9	17.929	17.85	17.92	5480.0
2012-06-12	ABEO	Stock	937.5	937.5	875.0	937.5	2.0
2012-06-12	ABFS-DELISTED	Stock	11.95	12.0	11.47	11.52	333101.0
2012-06-12	ABG	Stock	24.39	24.62	23.92	24.35	423800.0
2012-06-12	ABM	Stock	20.41	20.53	20.3	20.5	209700.0
2012-06-12	ABMD-DELISTED	Stock	21.26	21.63	20.62	21.47	348515.0
2012-06-12	ABR	Stock	5.31	5.34	5.25	5.25	256900.0
2012-06-12	ABT	Stock	29.5173	29.7428	29.3638	29.7284	8711546.0
2012-06-12	ABTL-DELISTED	Stock	3.7503	3.8997	3.6998	3.8997	27686.0
2012-06-12	ABUS	Stock	1.99	2.07	1.98	2.07	12300.0
2012-06-12	ABV-DELISTED	Stock	36.26	36.67	36.06	36.63	3583472.0
2012-06-12	ABVA-DELISTED	Stock	4.3	4.31	4.22	4.25	5989.0
2012-06-12	ABVT-DELISTED	Stock	83.6	83.67	83.56	83.6	406931.0
2012-06-12	ABX-DELISTED	Stock	38.76	39.2	38.04	38.5	9805945.0
2012-06-12	ACAD	Stock	1.34	1.38	1.34	1.35	111300.0

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

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