PREVIEW / stock_daily / 2012-09-19

all stock daily files

  file:    by_date/stock_daily/2012/2012-09-19.parquet
  size:    200 KB
  rows:    6,152
  symbols: 3,487

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-09-19	AAPL	Stock	25.0093	25.1425	24.9846	25.075	326874800.0
2012-09-19	MSFT	Stock	31.09	31.19	31.04	31.05	48871900.0
2012-09-19	NVDA	Stock	0.3395	0.3475	0.3355	0.3428	451936000.0
2012-09-19	AMZN	Stock	12.9725	13.142	12.9265	13.084	52736000.0
2012-09-19	META	Stock	21.99	23.37	21.77	23.29	78782800.0
2012-09-19	TSLA	Stock	2.0667	2.116	2.0627	2.07	15727500.0
2012-09-19	TLT	Stock	121.34	121.38	120.61	121.11	5903699.0
2012-09-19	ES	Stock	36.84	37.09	36.68	37.01	1816900.0
2012-09-19	CL	Stock	53.005	53.19	52.77	52.945	3657200.0
2012-09-19	A	Stock	28.2761	28.6195	28.1545	28.5265	4122422.0
2012-09-19	AABA-DELISTED	Stock	15.96	16.13	15.84	15.865	30310830.0
2012-09-19	AACC-DELISTED	Stock	7.04	7.39	6.94	7.37	19793.0
2012-09-19	AACG	Stock	4.47	4.47	4.43	4.43	3000.0
2012-09-19	AAIC-DELISTED	Stock	24.8	25.49	24.79	24.91	420006.0
2012-09-19	AAME	Stock	2.74	2.75	2.61	2.75	5600.0
2012-09-19	AAMRQ-DELISTED	Stock	0.423	0.426	0.4	0.407	3477070.0
2012-09-19	AAON	Stock	6.077	6.1007	5.923	6.0	155925.0
2012-09-19	AAP	Stock	67.32	69.33	67.32	68.28	1566800.0
2012-09-19	AAT	Stock	27.86	27.86	27.49	27.5	129900.0
2012-09-19	AAU-DELISTED	Stock	2.98	3.061	2.9301	3.0	246676.0
2012-09-19	AAUAF-DELISTED	Stock	2.98	3.061	2.9301	3.0	256096.0
2012-09-19	AAV-DELISTED	Stock	3.74	3.77	3.73	3.75	108564.0
2012-09-19	AAWW-DELISTED	Stock	55.29	56.66	55.17	56.52	162451.0
2012-09-19	AAXJ	Stock	56.6	56.7	56.35	56.6	376426.0
2012-09-19	AAXN-DELISTED	Stock	5.99	5.99	5.75	5.775	695884.0
2012-09-19	AB	Stock	15.6	15.75	15.33	15.56	211400.0
2012-09-19	ABAC-DELISTED	Stock	1.18	1.35	1.18	1.35	39086.0
2012-09-19	ABAX-DELISTED	Stock	36.69	37.32	36.43	37.05	83620.0
2012-09-19	ABB-DELISTED	Stock	19.63	19.86	19.53	19.77	1911436.0
2012-09-19	ABBNY-DELISTED	Stock	19.63	19.86	19.53	19.78	1928400.0
2012-09-19	ABC-DELISTED	Stock	38.26	38.5	38.17	38.19	2453862.0
2012-09-19	ABCB	Stock	12.63	12.79	12.57	12.65	29400.0
2012-09-19	ABCD-DELISTED	Stock	1.09	1.0901	1.03	1.06	9300.0
2012-09-19	ABCO-DELISTED	Stock	47.14	48.03	46.69	47.48	226899.0
2012-09-19	ABCW-DELISTED	Stock	0.385	0.42	0.38	0.39	38973.0
2012-09-19	ABE-DELISTED	Stock	20.35	20.36	20.21	20.28	21800.0
2012-09-19	ABEO	Stock	512.5	562.5	512.5	550.0	14.0
2012-09-19	ABFS-DELISTED	Stock	8.26	8.28	8.02	8.04	637203.0
2012-09-19	ABG	Stock	28.38	28.64	28.1	28.39	290800.0
2012-09-19	ABM	Stock	19.0	19.08	18.81	18.91	203900.0
2012-09-19	ABMD-DELISTED	Stock	21.03	21.3	20.78	21.23	453742.0
2012-09-19	ABR	Stock	6.38	6.38	6.16	6.33	64500.0
2012-09-19	ABT	Stock	33.135	33.3941	33.1206	33.2741	11461651.0
2012-09-19	ABTL-DELISTED	Stock	3.61	3.61	3.56	3.56	8816.0
2012-09-19	ABUS	Stock	3.87	3.99	3.7	3.8	17000.0
2012-09-19	ABV-DELISTED	Stock	37.83	38.15	37.75	37.97	1834142.0
2012-09-19	ABVA-DELISTED	Stock	4.85	4.99	4.6	4.61	2300.0
2012-09-19	ABX-DELISTED	Stock	42.37	42.94	42.08	42.74	8321947.0
2012-09-19	ACAD	Stock	2.25	2.52	2.21	2.44	3179000.0
2012-09-19	ACAS-DELISTED	Stock	11.66	11.83	11.63	11.79	1833607.0

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

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