PREVIEW / stock_daily / 2012-12-17

all stock daily files

  file:    by_date/stock_daily/2012/2012-12-17.parquet
  size:    202 KB
  rows:    6,262
  symbols: 3,540

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-17	AAPL	Stock	18.1761	18.5714	17.9011	18.5296	757607200.0
2012-12-17	MSFT	Stock	26.79	27.22	26.68	27.1	42046100.0
2012-12-17	NVDA	Stock	0.314	0.3158	0.3088	0.3135	445232000.0
2012-12-17	AMZN	Stock	12.4905	12.7	12.463	12.693	45540000.0
2012-12-17	META	Stock	26.77	27.0	26.32	26.75	57742500.0
2012-12-17	TSLA	Stock	2.2513	2.3	2.25	2.2933	12373500.0
2012-12-17	TLT	Stock	123.5	123.52	121.71	121.75	6869984.0
2012-12-17	ES	Stock	38.79	39.31	38.75	39.27	3043800.0
2012-12-17	CL	Stock	52.98	53.35	52.85	53.105	2951200.0
2012-12-17	A	Stock	28.598	29.1774	28.4478	29.1416	4829531.0
2012-12-17	AABA-DELISTED	Stock	19.72	19.74	19.53	19.69	14554940.0
2012-12-17	AACC-DELISTED	Stock	4.5	4.596	4.431	4.55	92553.0
2012-12-17	AACG	Stock	4.07	4.6	4.0	4.5	121700.0
2012-12-17	AAIC-DELISTED	Stock	20.82	21.07	20.42	20.73	180784.0
2012-12-17	AAMC-DELISTED	Stock	9.2647	19.1176	9.2647	19.1176	221609.0
2012-12-17	AAME	Stock	2.91	2.94	2.91	2.94	600.0
2012-12-17	AAMRQ-DELISTED	Stock	0.79	0.89	0.79	0.8485	8450342.0
2012-12-17	AAON	Stock	6.077	6.1481	6.0622	6.1067	345938.0
2012-12-17	AAP	Stock	72.93	73.49	72.63	73.05	731000.0
2012-12-17	AAT	Stock	26.84	26.95	26.7	26.8	186400.0
2012-12-17	AAU-DELISTED	Stock	3.06	3.06	2.9	2.98	294260.0
2012-12-17	AAUAF-DELISTED	Stock	3.06	3.06	2.9	3.0	296760.0
2012-12-17	AAV-DELISTED	Stock	3.31	3.37	3.27	3.37	221173.0
2012-12-17	AAWW-DELISTED	Stock	41.74	42.08	41.5	42.03	128017.0
2012-12-17	AAXJ	Stock	59.68	59.88	59.527	59.82	364856.0
2012-12-17	AAXN-DELISTED	Stock	7.67	7.98	7.61	7.66	1356428.0
2012-12-17	AB	Stock	16.77	16.96	16.5	16.6	513000.0
2012-12-17	ABAC-DELISTED	Stock	0.87	1.0	0.87	0.95	22400.0
2012-12-17	ABAX-DELISTED	Stock	36.95	37.5	36.64	37.5	75981.0
2012-12-17	ABB-DELISTED	Stock	20.36	20.49	20.36	20.49	1576640.0
2012-12-17	ABBNY-DELISTED	Stock	20.36	20.49	20.36	20.49	1725166.0
2012-12-17	ABC-DELISTED	Stock	43.36	43.78	43.27	43.78	2624042.0
2012-12-17	ABCB	Stock	12.11	12.3	12.0	12.27	58600.0
2012-12-17	ABCD-DELISTED	Stock	1.02	1.15	0.95	1.03	13999.0
2012-12-17	ABCO-DELISTED	Stock	48.79	49.44	48.37	49.03	135799.0
2012-12-17	ABCW-DELISTED	Stock	0.3301	0.3699	0.3301	0.35	13787.0
2012-12-17	ABE-DELISTED	Stock	20.45	20.724	20.45	20.72	19841.0
2012-12-17	ABEO	Stock	287.5	312.5	287.5	300.0	18.0
2012-12-17	ABFS-DELISTED	Stock	9.09	9.15	9.0	9.09	171115.0
2012-12-17	ABG	Stock	29.28	30.75	29.11	30.72	256500.0
2012-12-17	ABM	Stock	20.28	20.45	20.17	20.25	255400.0
2012-12-17	ABMD-DELISTED	Stock	12.92	13.12	12.83	12.97	435057.0
2012-12-17	ABR	Stock	5.7	5.85	5.66	5.76	267200.0
2012-12-17	ABT	Stock	31.4653	31.5181	31.2014	31.283	16745519.0
2012-12-17	ABTL-DELISTED	Stock	3.85	3.9999	3.85	3.9	4988.0
2012-12-17	ABUS	Stock	4.9	5.09	4.84	5.09	32200.0
2012-12-17	ABV-DELISTED	Stock	42.17	42.31	41.845	42.2	2428489.0
2012-12-17	ABVA-DELISTED	Stock	4.7	4.7	4.7	4.7	1000.0
2012-12-17	ABX-DELISTED	Stock	34.25	34.56	34.01	34.48	4329956.0
2012-12-17	ACAD	Stock	4.81	4.92	4.81	4.87	1303200.0

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

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