PREVIEW / stock_daily / 2012-12-19

all stock daily files

  file:    by_date/stock_daily/2012/2012-12-19.parquet
  size:    202 KB
  rows:    6,239
  symbols: 3,512

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-19	AAPL	Stock	18.9811	19.0607	18.7679	18.7968	449369200.0
2012-12-19	MSFT	Stock	27.69	27.73	27.25	27.31	53519900.0
2012-12-19	NVDA	Stock	0.3163	0.32	0.315	0.3163	458544000.0
2012-12-19	AMZN	Stock	13.065	13.0835	12.884	12.8995	46000000.0
2012-12-19	META	Stock	27.83	28.22	26.95	27.41	61390300.0
2012-12-19	TSLA	Stock	2.3167	2.3507	2.3013	2.3073	19482000.0
2012-12-19	TLT	Stock	120.97	121.65	120.72	120.9104	4880495.0
2012-12-19	ES	Stock	39.61	39.77	39.22	39.45	1434300.0
2012-12-19	CL	Stock	53.575	53.75	53.01	53.015	2961200.0
2012-12-19	A	Stock	29.671	29.6853	29.0272	29.0343	6632531.0
2012-12-19	AABA-DELISTED	Stock	19.62	19.69	19.58	19.6	12277610.0
2012-12-19	AACC-DELISTED	Stock	4.56	4.62	4.49	4.56	46030.0
2012-12-19	AACG	Stock	4.9	4.99	4.8	4.8	17800.0
2012-12-19	AAIC-DELISTED	Stock	20.96	21.04	20.62	21.0	115209.0
2012-12-19	AAMC-DELISTED	Stock	23.5294	24.7059	22.9412	24.7059	81573.0
2012-12-19	AAME	Stock	2.9	2.92	2.88	2.92	2900.0
2012-12-19	AAMRQ-DELISTED	Stock	0.9045	0.949	0.885	0.949	7470319.0
2012-12-19	AAON	Stock	6.077	6.1896	5.9704	6.0148	1260900.0
2012-12-19	AAP	Stock	73.05	73.4	71.99	72.03	635800.0
2012-12-19	AAT	Stock	26.83	26.97	26.63	26.75	159600.0
2012-12-19	AAU-DELISTED	Stock	3.02	3.03	2.9	2.94	168968.0
2012-12-19	AAUAF-DELISTED	Stock	3.02	3.03	2.9	2.93	169875.0
2012-12-19	AAV-DELISTED	Stock	3.34	3.37	3.32	3.35	270211.0
2012-12-19	AAWW-DELISTED	Stock	43.18	44.635	43.18	44.49	209015.0
2012-12-19	AAXJ	Stock	59.64	59.65	59.362	59.3723	484068.0
2012-12-19	AAXN-DELISTED	Stock	8.43	8.52	8.14	8.15	1158862.0
2012-12-19	AB	Stock	17.04	17.18	16.84	16.86	272500.0
2012-12-19	ABAC-DELISTED	Stock	1.08	1.09	0.92	0.93	12318.0
2012-12-19	ABAX-DELISTED	Stock	38.57	38.57	37.82	38.12	94900.0
2012-12-19	ABB-DELISTED	Stock	20.79	20.83	20.65	20.67	1632933.0
2012-12-19	ABBNY-DELISTED	Stock	20.79	20.83	20.65	20.68	1661503.0
2012-12-19	ABC-DELISTED	Stock	43.9	43.96	43.46	43.64	2253487.0
2012-12-19	ABCB	Stock	12.52	12.52	12.38	12.4	58300.0
2012-12-19	ABCD-DELISTED	Stock	1.0401	1.13	1.0401	1.06	5840.0
2012-12-19	ABCO-DELISTED	Stock	49.21	49.76	48.87	49.33	167547.0
2012-12-19	ABCW-DELISTED	Stock	0.37	0.39	0.3302	0.35	18797.0
2012-12-19	ABE-DELISTED	Stock	21.22	21.22	20.94	21.1301	29266.0
2012-12-19	ABEO	Stock	312.5	312.5	275.0	287.5	143.0
2012-12-19	ABFS-DELISTED	Stock	9.25	9.4	9.12	9.2	170327.0
2012-12-19	ABG	Stock	31.08	31.76	30.96	31.23	130500.0
2012-12-19	ABM	Stock	20.34	20.53	20.19	20.29	214400.0
2012-12-19	ABMD-DELISTED	Stock	13.43	13.57	13.25	13.52	1139615.0
2012-12-19	ABR	Stock	5.92	6.04	5.92	5.94	288200.0
2012-12-19	ABT	Stock	31.6572	31.6956	31.2638	31.3501	18059400.0
2012-12-19	ABTL-DELISTED	Stock	3.9	3.98	3.8515	3.9	27855.0
2012-12-19	ABUS	Stock	5.15	5.15	4.95	4.95	40400.0
2012-12-19	ABV-DELISTED	Stock	42.68	43.15	42.6	42.82	1782643.0
2012-12-19	ABVA-DELISTED	Stock	4.54	4.7	4.5	4.58	6760.0
2012-12-19	ABX-DELISTED	Stock	33.91	34.06	33.5	33.82	5853543.0
2012-12-19	ACAD	Stock	4.79	4.79	4.63	4.7	1409600.0

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

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