PREVIEW / stock_daily / 2012-06-13

all stock daily files

  file:    by_date/stock_daily/2012/2012-06-13.parquet
  size:    197 KB
  rows:    6,127
  symbols: 3,504

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-13	AAPL	Stock	20.5186	20.66	20.3707	20.4343	293580000.0
2012-06-13	MSFT	Stock	29.22	29.44	29.05	29.13	32984600.0
2012-06-13	NVDA	Stock	0.3125	0.3133	0.303	0.3045	494276000.0
2012-06-13	AMZN	Stock	10.776	10.869	10.676	10.7365	46504000.0
2012-06-13	META	Stock	27.66	28.1	27.1	27.27	17102800.0
2012-06-13	TSLA	Stock	1.97	2.0427	1.9647	1.9847	12661500.0
2012-06-13	TLT	Stock	124.85	126.28	124.38	125.86	11100169.0
2012-06-13	ES	Stock	37.24	37.83	37.13	37.58	1826500.0
2012-06-13	CL	Stock	49.8	50.275	49.665	50.105	3333000.0
2012-06-13	A	Stock	28.0401	28.4907	27.7682	27.897	2873449.0
2012-06-13	AABA-DELISTED	Stock	15.47	15.49	15.27	15.34	14622289.0
2012-06-13	AACC-DELISTED	Stock	5.58	5.89	5.58	5.86	24250.0
2012-06-13	AACG	Stock	4.76	4.76	4.62	4.76	2200.0
2012-06-13	AAIC-DELISTED	Stock	22.29	22.73	22.1	22.53	119217.0
2012-06-13	AAME	Stock	2.69	2.72	2.61	2.65	2700.0
2012-06-13	AAMRQ-DELISTED	Stock	0.45	0.46	0.443	0.456	459760.0
2012-06-13	AAON	Stock	5.7481	5.7481	5.5793	5.6326	138713.0
2012-06-13	AAP	Stock	72.9	73.17	70.44	70.54	1360500.0
2012-06-13	AAT	Stock	22.9	23.08	22.63	22.7	125300.0
2012-06-13	AAU-DELISTED	Stock	2.25	2.31	2.21	2.22	78594.0
2012-06-13	AAUAF-DELISTED	Stock	2.25	2.31	2.21	2.22	79208.0
2012-06-13	AAV-DELISTED	Stock	2.66	2.76	2.59	2.65	190339.0
2012-06-13	AAWW-DELISTED	Stock	44.19	44.49	42.59	42.83	187606.0
2012-06-13	AAXJ	Stock	51.65	51.89	51.34	51.37	332695.0
2012-06-13	AAXN-DELISTED	Stock	5.31	5.32	5.18	5.2	843580.0
2012-06-13	AB	Stock	11.62	11.98	11.61	11.86	504200.0
2012-06-13	ABAC-DELISTED	Stock	1.47	1.47	1.32	1.44	5200.0
2012-06-13	ABAX-DELISTED	Stock	33.31	33.85	33.31	33.65	184373.0
2012-06-13	ABB-DELISTED	Stock	15.98	16.22	15.88	16.07	4225026.0
2012-06-13	ABBNY-DELISTED	Stock	15.98	16.22	15.88	16.06	4513333.0
2012-06-13	ABC-DELISTED	Stock	36.9	37.06	36.35	36.46	2024153.0
2012-06-13	ABCB	Stock	11.45	11.79	11.42	11.64	45900.0
2012-06-13	ABCD-DELISTED	Stock	1.15	1.17	1.11	1.15	37538.0
2012-06-13	ABCO-DELISTED	Stock	47.92	47.92	47.23	47.48	204373.0
2012-06-13	ABCW-DELISTED	Stock	0.4619	0.4619	0.4016	0.4418	6130.0
2012-06-13	ABE-DELISTED	Stock	17.83	17.9	17.83	17.84	6953.0
2012-06-13	ABEO	Stock	875.0	937.5	812.5	937.5	10.0
2012-06-13	ABFS-DELISTED	Stock	11.45	11.53	10.95	10.95	506248.0
2012-06-13	ABG	Stock	24.19	24.49	23.45	23.56	433300.0
2012-06-13	ABM	Stock	20.39	20.7	20.24	20.34	245000.0
2012-06-13	ABMD-DELISTED	Stock	21.43	21.86	20.62	20.95	326042.0
2012-06-13	ABR	Stock	5.21	5.3	5.21	5.26	92500.0
2012-06-13	ABT	Stock	29.6133	29.6996	29.4261	29.5125	10736348.0
2012-06-13	ABTL-DELISTED	Stock	3.899	3.901	3.751	3.901	8250.0
2012-06-13	ABUS	Stock	1.97	1.97	1.94	1.95	1000.0
2012-06-13	ABV-DELISTED	Stock	36.04	36.77	36.02	36.33	3010248.0
2012-06-13	ABVA-DELISTED	Stock	4.39	4.4	4.08	4.08	10873.0
2012-06-13	ABVT-DELISTED	Stock	83.64	83.75	83.58	83.73	337395.0
2012-06-13	ABX-DELISTED	Stock	39.01	39.05	38.2	38.49	9445029.0
2012-06-13	ACAD	Stock	1.35	1.42	1.34	1.38	165200.0

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

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