PREVIEW / stock_daily / 2012-12-14

all stock daily files

  file:    by_date/stock_daily/2012/2012-12-14.parquet
  size:    201 KB
  rows:    6,218
  symbols: 3,508

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-14	AAPL	Stock	18.3839	18.5046	18.0564	18.2068	1009579200.0
2012-12-14	MSFT	Stock	27.11	27.13	26.7	26.81	42077500.0
2012-12-14	NVDA	Stock	0.3145	0.318	0.3123	0.3148	338660000.0
2012-12-14	AMZN	Stock	12.5055	12.595	12.3895	12.4595	50538000.0
2012-12-14	META	Stock	28.18	28.33	26.76	26.81	91631600.0
2012-12-14	TSLA	Stock	2.252	2.2933	2.2393	2.254	15345000.0
2012-12-14	TLT	Stock	123.19	123.71	123.081	123.6	3833049.0
2012-12-14	ES	Stock	39.11	39.26	38.59	38.69	3343600.0
2012-12-14	CL	Stock	53.08	53.5	52.85	52.92	3452400.0
2012-12-14	A	Stock	28.412	28.8054	28.3977	28.505	3679396.0
2012-12-14	AABA-DELISTED	Stock	19.41	19.72	19.4	19.64	17317203.0
2012-12-14	AACC-DELISTED	Stock	4.46	4.59	4.41	4.46	13517.0
2012-12-14	AACG	Stock	3.93	4.25	3.77	4.04	108600.0
2012-12-14	AAIC-DELISTED	Stock	21.16	21.31	20.7208	20.85	99173.0
2012-12-14	AAMC-DELISTED	Stock	5.5882	8.8235	5.5882	8.8235	491657.0
2012-12-14	AAME	Stock	2.95	2.95	2.93	2.94	1300.0
2012-12-14	AAMRQ-DELISTED	Stock	0.7465	0.797	0.723	0.786	6719295.0
2012-12-14	AAON	Stock	6.0059	6.1007	5.9793	6.0593	103275.0
2012-12-14	AAP	Stock	72.97	73.56	72.42	72.59	686900.0
2012-12-14	AAT	Stock	26.68	27.02	26.67	26.68	113900.0
2012-12-14	AAU-DELISTED	Stock	3.19	3.2	3.01	3.06	293001.0
2012-12-14	AAUAF-DELISTED	Stock	3.19	3.2	3.01	3.06	293201.0
2012-12-14	AAV-DELISTED	Stock	3.35	3.37	3.32	3.35	165980.0
2012-12-14	AAWW-DELISTED	Stock	41.37	42.04	41.18	41.65	130996.0
2012-12-14	AAXJ	Stock	59.85	59.98	59.68	59.84	287516.0
2012-12-14	AAXN-DELISTED	Stock	7.65	7.74	7.55	7.66	589599.0
2012-12-14	AB	Stock	17.2	17.2	16.73	16.8	400900.0
2012-12-14	ABAC-DELISTED	Stock	0.92	0.92	0.92	0.92	433.0
2012-12-14	ABAX-DELISTED	Stock	37.14	37.62	36.52	36.77	80582.0
2012-12-14	ABB-DELISTED	Stock	20.26	20.44	20.24	20.35	1529562.0
2012-12-14	ABBNY-DELISTED	Stock	20.26	20.44	20.24	20.36	1621200.0
2012-12-14	ABC-DELISTED	Stock	42.71	43.38	42.62	43.36	2660509.0
2012-12-14	ABCB	Stock	12.0	12.15	12.0	12.08	44900.0
2012-12-14	ABCD-DELISTED	Stock	1.02	1.14	1.0	1.03	50150.0
2012-12-14	ABCO-DELISTED	Stock	48.59	49.12	48.39	48.61	51888.0
2012-12-14	ABCW-DELISTED	Stock	0.36	0.3699	0.35	0.35	10190.0
2012-12-14	ABE-DELISTED	Stock	20.44	20.57	20.4201	20.57	3425.0
2012-12-14	ABEO	Stock	300.0	325.0	287.5	287.5	60.0
2012-12-14	ABFS-DELISTED	Stock	8.71	9.08	8.57	9.05	263187.0
2012-12-14	ABG	Stock	29.4	29.82	28.84	29.21	323400.0
2012-12-14	ABM	Stock	20.29	20.45	20.2	20.24	226400.0
2012-12-14	ABMD-DELISTED	Stock	13.08	13.23	12.78	12.9	383431.0
2012-12-14	ABR	Stock	5.71	5.72	5.63	5.66	102600.0
2012-12-14	ABT	Stock	31.1822	31.4461	31.1678	31.3549	13712797.0
2012-12-14	ABTL-DELISTED	Stock	3.98	4.0011	3.84	3.93	4721.0
2012-12-14	ABUS	Stock	4.9	4.9	4.84	4.84	4600.0
2012-12-14	ABV-DELISTED	Stock	42.19	42.39	41.62	42.11	3623662.0
2012-12-14	ABX-DELISTED	Stock	34.29	34.48	33.95	34.22	5090349.0
2012-12-14	ACAD	Stock	4.71	4.8	4.62	4.76	1723800.0
2012-12-14	ACAS-DELISTED	Stock	12.195	12.29	12.105	12.2	3400915.0

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

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