PREVIEW / stock_daily / 2012-09-06

all stock daily files

  file:    by_date/stock_daily/2012/2012-09-06.parquet
  size:    199 KB
  rows:    6,152
  symbols: 3,496

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-06	AAPL	Stock	24.0418	24.2246	23.9571	24.1525	391196400.0
2012-09-06	MSFT	Stock	30.5	31.36	30.46	31.35	48371700.0
2012-09-06	NVDA	Stock	0.3355	0.3522	0.3353	0.3433	657296000.0
2012-09-06	AMZN	Stock	12.4115	12.635	12.36	12.569	107228000.0
2012-09-06	META	Stock	18.74	19.26	18.72	18.96	46066500.0
2012-09-06	TSLA	Stock	1.8667	1.9267	1.86	1.9033	12625500.0
2012-09-06	TLT	Stock	125.53	125.53	124.55	124.61	6505163.0
2012-09-06	ES	Stock	37.85	38.21	37.66	38.16	984400.0
2012-09-06	CL	Stock	53.545	53.82	53.44	53.745	3355800.0
2012-09-06	A	Stock	26.5451	26.8526	26.2589	26.8097	6688591.0
2012-09-06	AABA-DELISTED	Stock	15.13	15.15	14.96	15.12	15522691.0
2012-09-06	AACC-DELISTED	Stock	6.88	7.15	6.7	6.78	58713.0
2012-09-06	AACG	Stock	4.39	4.5	4.39	4.5	3900.0
2012-09-06	AAIC-DELISTED	Stock	22.83	23.0	22.75	22.8	82346.0
2012-09-06	AAME	Stock	2.58	2.7	2.52	2.7	8800.0
2012-09-06	AAMRQ-DELISTED	Stock	0.4795	0.4795	0.4652	0.4685	1040981.0
2012-09-06	AAON	Stock	5.4963	5.6119	5.4341	5.5793	203513.0
2012-09-06	AAP	Stock	70.54	72.13	70.3	71.32	1057700.0
2012-09-06	AAT	Stock	27.51	28.07	27.46	27.96	182700.0
2012-09-06	AAU-DELISTED	Stock	2.73	2.76	2.6399	2.6399	185212.0
2012-09-06	AAUAF-DELISTED	Stock	2.72	2.75	2.6301	2.65	190300.0
2012-09-06	AAV-DELISTED	Stock	3.46	3.55	3.46	3.53	117335.0
2012-09-06	AAWW-DELISTED	Stock	51.94	54.14	51.82	53.51	376506.0
2012-09-06	AAXJ	Stock	52.54	53.359	52.5	53.27	269609.0
2012-09-06	AAXN-DELISTED	Stock	5.4	5.531	5.39	5.42	410495.0
2012-09-06	AB	Stock	14.33	14.59	14.3	14.39	437200.0
2012-09-06	ABAC-DELISTED	Stock	1.19	1.234	1.07	1.2	27187.0
2012-09-06	ABAX-DELISTED	Stock	37.44	38.5	37.15	38.17	171268.0
2012-09-06	ABB-DELISTED	Stock	17.69	17.96	17.68	17.91	2842985.0
2012-09-06	ABBNY-DELISTED	Stock	17.69	17.96	17.68	17.91	3082288.0
2012-09-06	ABC-DELISTED	Stock	38.33	38.835	38.31	38.62	2483380.0
2012-09-06	ABCB	Stock	12.19	12.41	12.07	12.35	66700.0
2012-09-06	ABCD-DELISTED	Stock	1.0	1.03	0.9999	1.015	24389.0
2012-09-06	ABCO-DELISTED	Stock	45.92	47.14	45.92	47.06	224052.0
2012-09-06	ABCW-DELISTED	Stock	0.435	0.435	0.435	0.435	1855.0
2012-09-06	ABE-DELISTED	Stock	19.42	19.81	19.42	19.8	7127.0
2012-09-06	ABEO	Stock	650.0	712.5	650.0	662.5	1.0
2012-09-06	ABFS-DELISTED	Stock	9.19	9.19	8.79	8.81	402599.0
2012-09-06	ABG	Stock	28.42	29.54	28.42	29.34	479500.0
2012-09-06	ABM	Stock	18.56	20.09	18.31	19.4	1247000.0
2012-09-06	ABMD-DELISTED	Stock	22.85	23.37	22.64	23.27	387593.0
2012-09-06	ABR	Stock	5.71	5.75	5.52	5.68	34800.0
2012-09-06	ABT	Stock	31.6524	32.113	31.5804	32.1082	12316382.0
2012-09-06	ABTL-DELISTED	Stock	3.64	3.7466	3.6	3.65	20304.0
2012-09-06	ABUS	Stock	3.2	3.41	3.2	3.3	11000.0
2012-09-06	ABV-DELISTED	Stock	37.03	38.17	37.03	37.95	2125995.0
2012-09-06	ABVA-DELISTED	Stock	4.45	4.8472	4.41	4.5	2950.0
2012-09-06	ABX-DELISTED	Stock	38.63	38.98	38.1701	38.98	8050898.0
2012-09-06	ACAD	Stock	1.85	1.85	1.74	1.75	644900.0
2012-09-06	ACAS-DELISTED	Stock	11.3	11.48	11.2	11.24	3323430.0

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

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