PREVIEW / stock_daily / 2012-09-12

all stock daily files

  file:    by_date/stock_daily/2012/2012-09-12.parquet
  size:    199 KB
  rows:    6,135
  symbols: 3,479

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-12	AAPL	Stock	23.8161	23.925	23.4286	23.9211	712233200.0
2012-09-12	MSFT	Stock	30.94	31.18	30.73	30.78	32775800.0
2012-09-12	NVDA	Stock	0.3388	0.3415	0.3355	0.3398	322608000.0
2012-09-12	AMZN	Stock	12.825	12.889	12.675	12.7815	45464000.0
2012-09-12	META	Stock	20.76	21.16	20.28	20.93	121584000.0
2012-09-12	TSLA	Stock	1.86	1.9053	1.8533	1.8853	17178000.0
2012-09-12	TLT	Stock	122.22	122.41	121.68	122.01	7040901.0
2012-09-12	ES	Stock	37.92	37.97	37.59	37.59	1213400.0
2012-09-12	CL	Stock	51.43	51.765	51.25	51.31	4108000.0
2012-09-12	A	Stock	27.1245	27.3391	26.8169	26.8169	6568922.0
2012-09-12	AABA-DELISTED	Stock	15.3	15.55	15.28	15.41	20856589.0
2012-09-12	AACC-DELISTED	Stock	6.79	6.88	6.7	6.88	13767.0
2012-09-12	AACG	Stock	4.48	4.5	4.39	4.4	6300.0
2012-09-12	AAIC-DELISTED	Stock	23.68	23.94	23.44	23.48	100712.0
2012-09-12	AAME	Stock	2.75	2.75	2.68	2.7	5800.0
2012-09-12	AAMRQ-DELISTED	Stock	0.458	0.4605	0.45	0.451	802017.0
2012-09-12	AAON	Stock	5.6474	5.6474	5.5022	5.5526	98213.0
2012-09-12	AAP	Stock	70.67	70.94	70.04	70.59	661500.0
2012-09-12	AAT	Stock	27.45	27.56	27.35	27.39	220500.0
2012-09-12	AAU-DELISTED	Stock	2.84	2.88	2.7	2.8	208519.0
2012-09-12	AAUAF-DELISTED	Stock	2.84	2.88	2.7	2.77	213919.0
2012-09-12	AAV-DELISTED	Stock	3.71	3.71	3.61	3.66	260217.0
2012-09-12	AAWW-DELISTED	Stock	56.99	56.99	55.81	56.98	182769.0
2012-09-12	AAXJ	Stock	54.68	54.92	54.6325	54.87	171673.0
2012-09-12	AAXN-DELISTED	Stock	5.47	5.55	5.39	5.45	652084.0
2012-09-12	AB	Stock	14.94	15.19	14.72	14.75	522800.0
2012-09-12	ABAC-DELISTED	Stock	1.14	1.14	1.11	1.11	3700.0
2012-09-12	ABAX-DELISTED	Stock	35.56	35.7699	34.66	35.008	125075.0
2012-09-12	ABB-DELISTED	Stock	19.1	19.21	18.99	19.05	2194299.0
2012-09-12	ABBNY-DELISTED	Stock	19.1	19.21	18.99	19.06	2232884.0
2012-09-12	ABC-DELISTED	Stock	37.74	38.6	37.52	37.91	2406168.0
2012-09-12	ABCB	Stock	12.28	12.45	12.19	12.26	57700.0
2012-09-12	ABCD-DELISTED	Stock	0.9811	1.06	0.9811	1.03	10700.0
2012-09-12	ABCO-DELISTED	Stock	46.19	46.39	45.89	46.25	120923.0
2012-09-12	ABCW-DELISTED	Stock	0.381	0.44	0.381	0.42	19553.0
2012-09-12	ABE-DELISTED	Stock	20.07	20.0875	20.0	20.03	3718.0
2012-09-12	ABEO	Stock	662.5	825.0	650.0	825.0	37.0
2012-09-12	ABFS-DELISTED	Stock	8.52	8.6	8.29	8.35	287056.0
2012-09-12	ABG	Stock	28.76	29.51	28.48	28.9	457500.0
2012-09-12	ABM	Stock	18.79	18.86	18.61	18.71	345300.0
2012-09-12	ABMD-DELISTED	Stock	20.48	20.89	20.39	20.6	367177.0
2012-09-12	ABR	Stock	5.7	5.74	5.6	5.63	65300.0
2012-09-12	ABT	Stock	32.3049	32.5688	32.209	32.5496	12207586.0
2012-09-12	ABTL-DELISTED	Stock	3.62	3.67	3.61	3.67	1685.0
2012-09-12	ABUS	Stock	3.31	3.31	3.25	3.25	8300.0
2012-09-12	ABV-DELISTED	Stock	37.94	38.07	36.84	37.33	2654005.0
2012-09-12	ABVA-DELISTED	Stock	4.71	4.71	4.71	4.71	100.0
2012-09-12	ABX-DELISTED	Stock	39.84	39.89	38.64	39.7	8687625.0
2012-09-12	ACAD	Stock	2.1	2.13	2.0	2.1	1218800.0
2012-09-12	ACAS-DELISTED	Stock	11.5	11.7	11.48	11.688	2897794.0

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

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