PREVIEW / stock_daily / 2012-06-29

all stock daily files

  file:    by_date/stock_daily/2012/2012-06-29.parquet
  size:    201 KB
  rows:    6,229
  symbols: 3,558

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-29	AAPL	Stock	20.6429	20.8571	20.5089	20.8571	421500800.0
2012-06-29	MSFT	Stock	30.45	30.69	30.14	30.59	55227200.0
2012-06-29	NVDA	Stock	0.3388	0.3462	0.3385	0.3455	616508000.0
2012-06-29	AMZN	Stock	11.235	11.4175	11.1855	11.4175	72288000.0
2012-06-29	META	Stock	31.92	31.99	30.76	31.1	19526900.0
2012-06-29	TSLA	Stock	2.1867	2.1867	2.0667	2.086	16887000.0
2012-06-29	TLT	Stock	125.03	125.63	124.63	125.2	8882175.0
2012-06-29	ES	Stock	38.84	39.09	38.47	38.81	1510000.0
2012-06-29	CL	Stock	51.37	52.165	50.985	52.05	5399200.0
2012-06-29	A	Stock	27.432	28.1116	27.432	28.0687	3698828.0
2012-06-29	AABA-DELISTED	Stock	15.61	15.83	15.53	15.825	13346472.0
2012-06-29	AACC-DELISTED	Stock	6.63	6.82	6.57	6.78	65321.0
2012-06-29	AACG	Stock	4.19	4.34	4.19	4.25	2800.0
2012-06-29	AAIC-DELISTED	Stock	21.5	21.9	21.2205	21.71	254068.0
2012-06-29	AAME	Stock	2.75	2.75	2.72	2.75	4200.0
2012-06-29	AAMRQ-DELISTED	Stock	0.569	0.575	0.54	0.549	2178486.0
2012-06-29	AAON	Stock	5.5378	5.6474	5.523	5.5852	288900.0
2012-06-29	AAP	Stock	66.41	68.3	66.41	68.22	1225700.0
2012-06-29	AAT	Stock	23.95	24.38	23.86	24.25	142000.0
2012-06-29	AAU-DELISTED	Stock	2.08	2.11	2.01	2.1001	135141.0
2012-06-29	AAUAF-DELISTED	Stock	2.08	2.11	2.01	2.1	136641.0
2012-06-29	AAV-DELISTED	Stock	3.0	3.07	2.9099	2.95	410271.0
2012-06-29	AAWW-DELISTED	Stock	41.86	43.898	41.62	43.5	230845.0
2012-06-29	AAXJ	Stock	52.36	52.61	52.14	52.61	714647.0
2012-06-29	AAXN-DELISTED	Stock	5.1	5.32	5.01	5.235	457895.0
2012-06-29	AB	Stock	12.61	12.98	12.6	12.69	321400.0
2012-06-29	ABAC-DELISTED	Stock	1.23	1.23	1.18	1.206	19800.0
2012-06-29	ABAX-DELISTED	Stock	36.01	37.1	35.69	37.06	144000.0
2012-06-29	ABB-DELISTED	Stock	16.18	16.32	16.14	16.32	2883983.0
2012-06-29	ABBNY-DELISTED	Stock	16.19	16.32	16.14	16.32	2976888.0
2012-06-29	ABC-DELISTED	Stock	39.08	39.35	38.92	39.35	1893886.0
2012-06-29	ABCB	Stock	12.45	12.77	12.38	12.6	68000.0
2012-06-29	ABCD-DELISTED	Stock	1.01	1.04	0.9401	1.04	22299.0
2012-06-29	ABCO-DELISTED	Stock	49.12	49.59	48.91	49.59	233341.0
2012-06-29	ABCW-DELISTED	Stock	0.45	0.46	0.45	0.45	18000.0
2012-06-29	ABE-DELISTED	Stock	18.68	19.05	18.23	18.81	45435.0
2012-06-29	ABEO	Stock	812.5	837.5	687.5	812.5	196.0
2012-06-29	ABFS-DELISTED	Stock	12.45	12.93	12.43	12.6	334086.0
2012-06-29	ABG	Stock	23.1	23.99	22.79	23.69	544900.0
2012-06-29	ABM	Stock	20.28	20.4	19.46	19.56	706400.0
2012-06-29	ABMD-DELISTED	Stock	22.48	22.92	22.15	22.82	529941.0
2012-06-29	ABR	Stock	5.42	5.42	5.33	5.35	67400.0
2012-06-29	ABT	Stock	30.333	30.9327	30.2754	30.9327	26008128.0
2012-06-29	ABTL-DELISTED	Stock	3.6993	3.8255	3.6061	3.75	29637.0
2012-06-29	ABUS	Stock	2.05	2.11	2.05	2.11	4600.0
2012-06-29	ABV-DELISTED	Stock	37.69	38.64	37.69	38.33	5067548.0
2012-06-29	ABVT-DELISTED	Stock	83.99	83.99	83.94	83.95	593260.0
2012-06-29	ABX-DELISTED	Stock	37.66	37.77	36.87	37.59	8410952.0
2012-06-29	ACAD	Stock	1.85	1.87	1.75	1.76	750100.0
2012-06-29	ACAS-DELISTED	Stock	9.9801	10.08	9.91	10.08	4284891.0

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

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