PREVIEW / stock_daily / 2012-11-09

all stock daily files

  file:    by_date/stock_daily/2012/2012-11-09.parquet
  size:    199 KB
  rows:    6,178
  symbols: 3,485

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-11-09	AAPL	Stock	19.3007	19.8171	19.0614	19.5379	929913600.0
2012-11-09	MSFT	Stock	28.88	29.19	28.81	28.83	43291200.0
2012-11-09	NVDA	Stock	0.3188	0.3225	0.3038	0.3048	846280000.0
2012-11-09	AMZN	Stock	11.313	11.5485	11.23	11.3155	61850000.0
2012-11-09	META	Stock	19.96	20.0	19.13	19.21	42295500.0
2012-11-09	TSLA	Stock	2.04	2.062	1.99	2.0213	12945000.0
2012-11-09	TLT	Stock	125.63	125.98	125.18	125.98	5036872.0
2012-11-09	ES	Stock	38.09	38.39	38.05	38.14	1172700.0
2012-11-09	CL	Stock	51.91	52.345	51.835	51.935	2813600.0
2012-11-09	A	Stock	26.2017	26.5737	26.1516	26.402	5475127.0
2012-11-09	AABA-DELISTED	Stock	17.23	17.52	17.18	17.25	23553635.0
2012-11-09	AACC-DELISTED	Stock	5.03	5.36	4.99	5.09	27513.0
2012-11-09	AACG	Stock	4.78	4.78	4.72	4.77	1000.0
2012-11-09	AAIC-DELISTED	Stock	20.5	20.75	20.09	20.5	253458.0
2012-11-09	AAME	Stock	2.86	2.92	2.83	2.9	2900.0
2012-11-09	AAMRQ-DELISTED	Stock	0.3711	0.3729	0.3601	0.3601	432517.0
2012-11-09	AAON	Stock	5.7985	5.9467	5.6326	5.6533	202838.0
2012-11-09	AAP	Stock	78.39	80.76	77.99	78.41	1818000.0
2012-11-09	AAT	Stock	26.78	27.45	26.78	27.43	102500.0
2012-11-09	AAU-DELISTED	Stock	2.62	2.72	2.59	2.67	86954.0
2012-11-09	AAUAF-DELISTED	Stock	2.62	2.72	2.59	2.67	87318.0
2012-11-09	AAV-DELISTED	Stock	3.38	3.44	3.35	3.44	150497.0
2012-11-09	AAWW-DELISTED	Stock	42.77	43.22	42.47	42.52	206438.0
2012-11-09	AAXJ	Stock	56.16	56.82	56.14	56.52	335154.0
2012-11-09	AAXN-DELISTED	Stock	8.02	8.22	8.01	8.05	440782.0
2012-11-09	AB	Stock	15.96	16.16	15.89	16.06	212900.0
2012-11-09	ABAC-DELISTED	Stock	1.0	1.0	0.945	0.99	9030.0
2012-11-09	ABAX-DELISTED	Stock	37.11	37.3	36.4	36.76	96860.0
2012-11-09	ABB-DELISTED	Stock	18.14	18.38	18.14	18.2	1692865.0
2012-11-09	ABBNY-DELISTED	Stock	18.14	18.38	18.14	18.19	1729868.0
2012-11-09	ABC-DELISTED	Stock	40.25	40.8183	40.0288	40.47	2248753.0
2012-11-09	ABCB	Stock	10.54	10.74	10.51	10.55	20100.0
2012-11-09	ABCD-DELISTED	Stock	0.75	1.05	0.58	0.7699	52768.0
2012-11-09	ABCO-DELISTED	Stock	46.0	46.21	45.1	45.44	696477.0
2012-11-09	ABCW-DELISTED	Stock	0.4	0.43	0.36	0.42	32038.0
2012-11-09	ABE-DELISTED	Stock	20.05	20.06	20.03	20.06	1700.0
2012-11-09	ABEO	Stock	375.0	375.0	375.0	375.0	47.0
2012-11-09	ABFS-DELISTED	Stock	7.34	7.52	7.2181	7.29	307853.0
2012-11-09	ABG	Stock	29.29	29.79	28.58	29.31	237100.0
2012-11-09	ABM	Stock	19.06	19.29	18.9	19.02	136200.0
2012-11-09	ABMD-DELISTED	Stock	12.73	13.29	12.5	13.27	675580.0
2012-11-09	ABR	Stock	5.31	5.44	5.31	5.38	96500.0
2012-11-09	ABT	Stock	30.784	31.2638	30.5537	31.1102	19119842.0
2012-11-09	ABTL-DELISTED	Stock	4.06	4.21	4.0	4.12	15869.0
2012-11-09	ABUS	Stock	5.41	5.44	4.81	5.0	135200.0
2012-11-09	ABV-DELISTED	Stock	39.58	39.78	39.35	39.465	2037521.0
2012-11-09	ABVA-DELISTED	Stock	4.3	4.4	4.3	4.35	6690.0
2012-11-09	ABX-DELISTED	Stock	36.9	36.91	36.02	36.05	5809019.0
2012-11-09	ACAD	Stock	2.18	2.37	2.18	2.27	1327300.0
2012-11-09	ACAS-DELISTED	Stock	11.41	11.48	11.28	11.37	4620268.0

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

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