PREVIEW / stock_daily / 2012-12-11

all stock daily files

  file:    by_date/stock_daily/2012/2012-12-11.parquet
  size:    204 KB
  rows:    6,248
  symbols: 3,519

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-11	AAPL	Stock	19.2775	19.6271	19.1918	19.3354	592345600.0
2012-12-11	MSFT	Stock	27.05	27.49	27.05	27.32	52282800.0
2012-12-11	NVDA	Stock	0.31	0.3203	0.3093	0.3163	816724000.0
2012-12-11	AMZN	Stock	12.425	12.674	12.3325	12.5345	83704000.0
2012-12-11	META	Stock	28.07	28.24	27.66	27.98	77099100.0
2012-12-11	TSLA	Stock	2.3067	2.3667	2.2973	2.352	23589000.0
2012-12-11	TLT	Stock	124.26	124.31	123.83	124.0303	3777883.0
2012-12-11	ES	Stock	39.25	39.65	39.2	39.53	1458400.0
2012-12-11	CL	Stock	53.535	54.1	53.495	53.94	2862600.0
2012-12-11	A	Stock	27.7182	28.5694	27.7039	28.3977	6233822.0
2012-12-11	AABA-DELISTED	Stock	19.53	19.63	19.43	19.53	18563705.0
2012-12-11	AACC-DELISTED	Stock	4.56	4.62	4.5	4.56	24003.0
2012-12-11	AACG	Stock	3.8	4.08	3.72	3.73	21900.0
2012-12-11	AAIC-DELISTED	Stock	22.17	22.57	22.14	22.47	196621.0
2012-12-11	AAME	Stock	2.9	2.94	2.9	2.94	1000.0
2012-12-11	AAMRQ-DELISTED	Stock	0.5775	0.628	0.555	0.595	6417160.0
2012-12-11	AAON	Stock	6.1837	6.2193	6.1274	6.1748	233550.0
2012-12-11	AAP	Stock	73.1	73.34	72.54	72.83	980100.0
2012-12-11	AAT	Stock	27.29	27.29	27.03	27.14	91300.0
2012-12-11	AAU-DELISTED	Stock	3.23	3.2999	3.21	3.24	210135.0
2012-12-11	AAUAF-DELISTED	Stock	3.23	3.2999	3.21	3.24	210735.0
2012-12-11	AAV-DELISTED	Stock	3.27	3.39	3.27	3.33	176903.0
2012-12-11	AAWW-DELISTED	Stock	43.02	43.84	42.91	43.07	123463.0
2012-12-11	AAXJ	Stock	59.55	59.79	59.4	59.66	370846.0
2012-12-11	AAXN-DELISTED	Stock	8.19	8.28	8.14	8.21	413864.0
2012-12-11	AB	Stock	16.78	16.94	16.63	16.77	375400.0
2012-12-11	ABAC-DELISTED	Stock	0.93	0.973	0.85	0.85	8655.0
2012-12-11	ABAX-DELISTED	Stock	38.49	39.2	38.3	38.89	72384.0
2012-12-11	ABB-DELISTED	Stock	19.93	20.08	19.92	20.02	1452669.0
2012-12-11	ABBNY-DELISTED	Stock	19.93	20.08	19.92	20.03	1488958.0
2012-12-11	ABC-DELISTED	Stock	42.9	43.18	42.39	43.125	4674038.0
2012-12-11	ABCB	Stock	12.17	12.28	12.0	12.15	258400.0
2012-12-11	ABCD-DELISTED	Stock	1.0	1.1602	1.0	1.05	13196.0
2012-12-11	ABCO-DELISTED	Stock	48.66	49.75	48.29	49.1	182628.0
2012-12-11	ABCW-DELISTED	Stock	0.3899	0.3899	0.38	0.38	14019.0
2012-12-11	ABE-DELISTED	Stock	20.67	20.94	20.46	20.53	7744.0
2012-12-11	ABEO	Stock	300.0	312.5	287.5	287.5	63.0
2012-12-11	ABFS-DELISTED	Stock	9.24	9.24	9.01	9.1	422970.0
2012-12-11	ABG	Stock	30.88	30.95	30.44	30.76	185700.0
2012-12-11	ABM	Stock	20.0	20.37	19.81	20.15	604500.0
2012-12-11	ABMD-DELISTED	Stock	13.55	13.99	13.44	13.83	1176195.0
2012-12-11	ABR	Stock	5.08	5.27	5.08	5.26	124500.0
2012-12-11	ABT	Stock	31.3453	31.8347	31.3357	31.7484	16099000.0
2012-12-11	ABTL-DELISTED	Stock	3.87	3.87	3.782	3.827	2743.0
2012-12-11	ABUS	Stock	5.21	5.21	4.93	4.99	62600.0
2012-12-11	ABV-DELISTED	Stock	42.64	42.65	42.24	42.44	1601966.0
2012-12-11	ABVA-DELISTED	Stock	4.75	4.83	4.71	4.73	3493.0
2012-12-11	ABX-DELISTED	Stock	34.19	34.42	34.0	34.01	4702630.0
2012-12-11	ACAD	Stock	4.2	4.48	4.2	4.43	3158600.0
2012-12-11	ACAS-DELISTED	Stock	12.0	12.1	11.96	12.1	3943441.0

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

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