PREVIEW / stock_daily / 2012-12-18

all stock daily files

  file:    by_date/stock_daily/2012/2012-12-18.parquet
  size:    204 KB
  rows:    6,275
  symbols: 3,531

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-18	AAPL	Stock	18.75	19.1036	18.5804	19.0679	625685200.0
2012-12-18	MSFT	Stock	27.25	27.63	27.14	27.56	50486900.0
2012-12-18	NVDA	Stock	0.3135	0.3175	0.3125	0.314	416436000.0
2012-12-18	AMZN	Stock	12.7285	13.1555	12.7285	13.02	99220000.0
2012-12-18	META	Stock	26.96	27.91	26.9	27.71	60512900.0
2012-12-18	TSLA	Stock	2.284	2.338	2.284	2.306	23308500.0
2012-12-18	TLT	Stock	121.4	121.78	119.9	120.51	12024123.0
2012-12-18	ES	Stock	39.29	39.7	38.91	39.68	1740100.0
2012-12-18	CL	Stock	53.21	53.675	52.995	53.63	3721400.0
2012-12-18	A	Stock	29.1559	29.8569	29.0773	29.6066	6499022.0
2012-12-18	AABA-DELISTED	Stock	19.72	19.755	19.58	19.63	17017444.0
2012-12-18	AACC-DELISTED	Stock	4.5	4.615	4.44	4.55	81460.0
2012-12-18	AACG	Stock	4.34	5.06	4.26	4.96	61500.0
2012-12-18	AAIC-DELISTED	Stock	20.77	21.01	20.6	20.98	134729.0
2012-12-18	AAMC-DELISTED	Stock	19.1176	26.1765	19.1176	23.5294	141124.0
2012-12-18	AAME	Stock	2.94	2.94	2.94	2.94	100.0
2012-12-18	AAMRQ-DELISTED	Stock	0.86	0.92	0.85	0.887	12951452.0
2012-12-18	AAON	Stock	6.0948	6.1393	6.0652	6.0919	258863.0
2012-12-18	AAP	Stock	73.31	73.42	72.69	72.9	1168900.0
2012-12-18	AAT	Stock	26.77	27.08	26.77	26.87	231200.0
2012-12-18	AAU-DELISTED	Stock	3.0	3.07	2.96	3.05	260469.0
2012-12-18	AAUAF-DELISTED	Stock	3.0	3.07	2.96	3.05	268669.0
2012-12-18	AAV-DELISTED	Stock	3.34	3.41	3.32	3.37	805907.0
2012-12-18	AAWW-DELISTED	Stock	42.02	43.37	42.02	43.3	383674.0
2012-12-18	AAXJ	Stock	59.27	59.58	58.96	59.53	679700.0
2012-12-18	AAXN-DELISTED	Stock	7.84	8.46	7.7	8.46	1580023.0
2012-12-18	AB	Stock	16.59	17.16	16.55	17.14	513600.0
2012-12-18	ABAC-DELISTED	Stock	1.0	1.0799	0.9101	1.0	12840.0
2012-12-18	ABAX-DELISTED	Stock	37.51	38.48	37.025	38.47	92322.0
2012-12-18	ABB-DELISTED	Stock	20.57	20.72	20.54	20.71	1459511.0
2012-12-18	ABBNY-DELISTED	Stock	20.57	20.72	20.54	20.72	1504353.0
2012-12-18	ABC-DELISTED	Stock	43.76	44.02	43.55	43.92	1939600.0
2012-12-18	ABCB	Stock	12.3	12.54	12.2	12.48	51700.0
2012-12-18	ABCD-DELISTED	Stock	1.09	1.12	1.0	1.04	5095.0
2012-12-18	ABCO-DELISTED	Stock	48.93	50.04	48.7001	49.52	203747.0
2012-12-18	ABCW-DELISTED	Stock	0.33	0.37	0.32	0.37	24259.0
2012-12-18	ABE-DELISTED	Stock	20.64	21.17	20.4501	21.12	23812.0
2012-12-18	ABEO	Stock	287.5	312.5	287.5	300.0	40.0
2012-12-18	ABFS-DELISTED	Stock	9.09	9.35	8.91	9.23	281839.0
2012-12-18	ABG	Stock	30.65	31.36	30.57	31.03	255500.0
2012-12-18	ABM	Stock	20.27	20.5	20.12	20.5	239200.0
2012-12-18	ABMD-DELISTED	Stock	13.65	13.86	13.37	13.45	1836625.0
2012-12-18	ABR	Stock	5.77	5.89	5.73	5.85	186600.0
2012-12-18	ABT	Stock	31.2494	31.7148	31.0527	31.6332	21209879.0
2012-12-18	ABTL-DELISTED	Stock	3.87	3.9194	3.81	3.811	3479.0
2012-12-18	ABUS	Stock	5.03	5.22	5.03	5.15	29700.0
2012-12-18	ABV-DELISTED	Stock	42.15	42.75	42.07	42.7	1495894.0
2012-12-18	ABVA-DELISTED	Stock	4.7	4.7	4.6101	4.65	2524.0
2012-12-18	ABX-DELISTED	Stock	34.46	34.49	33.66	33.96	7297375.0
2012-12-18	ACAD	Stock	4.91	4.91	4.77	4.83	940900.0

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

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