PREVIEW / stock_daily / 2012-12-20

all stock daily files

  file:    by_date/stock_daily/2012/2012-12-20.parquet
  size:    202 KB
  rows:    6,222
  symbols: 3,516

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-12-20	AAPL	Stock	18.9286	18.9357	18.5314	18.6332	481689600.0
2012-12-20	MSFT	Stock	27.36	27.68	27.15	27.68	52607300.0
2012-12-20	NVDA	Stock	0.3175	0.3178	0.3125	0.316	334332000.0
2012-12-20	AMZN	Stock	12.918	13.1205	12.827	13.075	51692000.0
2012-12-20	META	Stock	27.49	27.6	27.13	27.36	35574800.0
2012-12-20	TSLA	Stock	2.3007	2.3193	2.27	2.2953	13818000.0
2012-12-20	TLT	Stock	121.29	121.64	120.62	120.93	4567812.0
2012-12-20	ES	Stock	39.57	39.72	39.22	39.45	1780800.0
2012-12-20	CL	Stock	53.02	53.28	52.675	52.895	2994200.0
2012-12-20	A	Stock	29.0272	29.6066	28.9127	29.5851	5324563.0
2012-12-20	AABA-DELISTED	Stock	19.58	19.71	19.41	19.7	24387582.0
2012-12-20	AACC-DELISTED	Stock	4.61	4.61	4.4	4.51	93754.0
2012-12-20	AACG	Stock	4.8	4.97	4.79	4.9	16300.0
2012-12-20	AAIC-DELISTED	Stock	20.95	21.22	20.95	21.06	133732.0
2012-12-20	AAMC-DELISTED	Stock	24.7059	24.7059	23.5294	23.6029	101215.0
2012-12-20	AAME	Stock	2.93	2.93	2.84	2.89	9500.0
2012-12-20	AAMRQ-DELISTED	Stock	0.9503	0.988	0.85	0.856	14512142.0
2012-12-20	AAON	Stock	6.0148	6.0385	5.9348	5.9881	598388.0
2012-12-20	AAP	Stock	72.27	72.91	71.47	71.68	442100.0
2012-12-20	AAT	Stock	26.84	27.57	26.78	27.45	125800.0
2012-12-20	AAU-DELISTED	Stock	2.94	3.01	2.84	2.98	228674.0
2012-12-20	AAUAF-DELISTED	Stock	2.93	3.0	2.83	2.99	229740.0
2012-12-20	AAV-DELISTED	Stock	3.33	3.35	3.31	3.34	180056.0
2012-12-20	AAWW-DELISTED	Stock	44.65	44.65	43.65	43.9	239026.0
2012-12-20	AAXJ	Stock	59.44	59.66	59.23	59.66	412972.0
2012-12-20	AAXN-DELISTED	Stock	8.39	8.87	8.2	8.75	1538563.0
2012-12-20	AB	Stock	16.9	17.23	16.83	16.98	335400.0
2012-12-20	ABAC-DELISTED	Stock	0.89	0.9399	0.87	0.87	15774.0
2012-12-20	ABAX-DELISTED	Stock	38.05	38.51	37.39	37.77	107616.0
2012-12-20	ABB-DELISTED	Stock	20.75	20.84	20.63	20.79	1347064.0
2012-12-20	ABBNY-DELISTED	Stock	20.75	20.84	20.63	20.8	1404837.0
2012-12-20	ABC-DELISTED	Stock	43.74	43.81	43.47	43.81	2274169.0
2012-12-20	ABCB	Stock	12.45	12.59	12.37	12.5	39700.0
2012-12-20	ABCD-DELISTED	Stock	1.1	1.19	1.0601	1.11	22663.0
2012-12-20	ABCO-DELISTED	Stock	49.25	49.72	48.64	49.36	167530.0
2012-12-20	ABCW-DELISTED	Stock	0.35	0.36	0.32	0.3251	30516.0
2012-12-20	ABE-DELISTED	Stock	21.24	21.24	20.9701	21.2	21856.0
2012-12-20	ABEO	Stock	275.0	312.5	275.0	287.5	60.0
2012-12-20	ABFS-DELISTED	Stock	9.21	9.36	9.08	9.34	226978.0
2012-12-20	ABG	Stock	31.32	31.4	30.87	31.39	204500.0
2012-12-20	ABM	Stock	20.31	20.41	20.15	20.33	176600.0
2012-12-20	ABMD-DELISTED	Stock	13.65	13.7	13.47	13.62	632990.0
2012-12-20	ABR	Stock	5.99	6.09	5.97	6.05	152300.0
2012-12-20	ABT	Stock	31.3789	31.4653	31.235	31.4509	11484368.0
2012-12-20	ABTL-DELISTED	Stock	3.8501	3.94	3.81	3.87	3775.0
2012-12-20	ABUS	Stock	5.04	5.35	4.98	5.01	33900.0
2012-12-20	ABV-DELISTED	Stock	42.67	42.84	41.79	41.88	2333542.0
2012-12-20	ABVA-DELISTED	Stock	4.5	4.7	4.5	4.7	7254.0
2012-12-20	ABX-DELISTED	Stock	33.5	33.68	32.81	33.63	10157740.0
2012-12-20	ACAD	Stock	4.83	4.88	4.72	4.75	1029100.0

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

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