PREVIEW / stock_daily / 2012-11-08

all stock daily files

  file:    by_date/stock_daily/2012/2012-11-08.parquet
  size:    199 KB
  rows:    6,157
  symbols: 3,478

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-08	AAPL	Stock	20.0225	20.0796	19.1175	19.2054	1056146000.0
2012-11-08	MSFT	Stock	29.12	29.37	28.8	28.81	49841800.0
2012-11-08	NVDA	Stock	0.3188	0.327	0.3163	0.317	839024000.0
2012-11-08	AMZN	Stock	11.611	11.6725	11.355	11.3675	59648000.0
2012-11-08	META	Stock	20.52	20.73	19.98	19.99	34254600.0
2012-11-08	TSLA	Stock	2.0673	2.1253	2.0627	2.0873	19110000.0
2012-11-08	TLT	Stock	123.79	125.86	123.43	125.84	8580376.0
2012-11-08	ES	Stock	38.29	38.83	38.22	38.22	981200.0
2012-11-08	CL	Stock	52.43	52.59	52.0	52.035	2874800.0
2012-11-08	A	Stock	26.8813	26.9313	26.3519	26.3805	4281655.0
2012-11-08	AABA-DELISTED	Stock	17.3	17.5	17.23	17.24	20266620.0
2012-11-08	AACC-DELISTED	Stock	5.43	5.48	4.96	4.96	38029.0
2012-11-08	AACG	Stock	4.78	4.96	4.75	4.76	5400.0
2012-11-08	AAIC-DELISTED	Stock	21.04	21.389	20.68	20.68	153919.0
2012-11-08	AAME	Stock	2.92	2.92	2.81	2.92	2400.0
2012-11-08	AAMRQ-DELISTED	Stock	0.369	0.373	0.369	0.37	1004070.0
2012-11-08	AAON	Stock	5.9348	6.0741	5.8015	5.8459	373613.0
2012-11-08	AAP	Stock	79.65	81.46	79.2	79.4	2073400.0
2012-11-08	AAT	Stock	27.47	27.64	26.71	26.78	110200.0
2012-11-08	AAU-DELISTED	Stock	2.56	2.67	2.52	2.63	100827.0
2012-11-08	AAUAF-DELISTED	Stock	2.55	2.66	2.51	2.64	101610.0
2012-11-08	AAV-DELISTED	Stock	3.46	3.46	3.3	3.38	147262.0
2012-11-08	AAWW-DELISTED	Stock	43.06	43.25	42.53	43.12	182248.0
2012-11-08	AAXJ	Stock	56.69	57.02	56.13	56.17	265137.0
2012-11-08	AAXN-DELISTED	Stock	8.16	8.25	7.97	8.08	433713.0
2012-11-08	AB	Stock	16.23	16.5	16.0	16.03	429000.0
2012-11-08	ABAC-DELISTED	Stock	1.07	1.2	1.02	1.05	9725.0
2012-11-08	ABAX-DELISTED	Stock	36.36	37.71	36.15	37.17	177855.0
2012-11-08	ABB-DELISTED	Stock	18.44	18.54	18.22	18.27	2401967.0
2012-11-08	ABBNY-DELISTED	Stock	18.44	18.54	18.22	18.28	2512064.0
2012-11-08	ABC-DELISTED	Stock	40.65	40.85	39.93	40.34	2886571.0
2012-11-08	ABCB	Stock	10.67	10.77	10.6	10.61	72600.0
2012-11-08	ABCD-DELISTED	Stock	0.6701	0.75	0.67	0.73	8040.0
2012-11-08	ABCO-DELISTED	Stock	47.16	47.64	46.23	46.23	132802.0
2012-11-08	ABCW-DELISTED	Stock	0.36	0.4	0.36	0.4	6906.0
2012-11-08	ABE-DELISTED	Stock	20.15	20.15	19.67	20.01	4152.0
2012-11-08	ABEO	Stock	375.0	375.0	375.0	375.0	54.0
2012-11-08	ABFS-DELISTED	Stock	7.98	7.98	7.34	7.34	656239.0
2012-11-08	ABG	Stock	30.43	30.74	29.35	29.49	164200.0
2012-11-08	ABM	Stock	19.13	19.32	18.84	19.16	319700.0
2012-11-08	ABMD-DELISTED	Stock	13.08	13.1986	12.87	12.89	878056.0
2012-11-08	ABR	Stock	5.31	5.31	5.26	5.26	116800.0
2012-11-08	ABT	Stock	31.0143	31.1294	30.4529	30.4577	17642559.0
2012-11-08	ABTL-DELISTED	Stock	4.06	4.24	4.05	4.05	9480.0
2012-11-08	ABUS	Stock	4.63	5.19	4.5	5.19	197000.0
2012-11-08	ABV-DELISTED	Stock	40.52	40.76	39.72	39.98	2035684.0
2012-11-08	ABVA-DELISTED	Stock	4.33	4.35	4.3	4.35	2400.0
2012-11-08	ABX-DELISTED	Stock	36.29	36.83	35.825	36.4602	8121788.0
2012-11-08	ACAD	Stock	2.32	2.32	2.22	2.24	1174500.0
2012-11-08	ACAS-DELISTED	Stock	11.64	11.745	11.465	11.48	3605681.0

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

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