PREVIEW / stock_daily / 2014-11-26

all stock daily files

  file:    by_date/stock_daily/2014/2014-11-26.parquet
  size:    222 KB
  rows:    6,653
  symbols: 3,569

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
2014-11-26	AAPL	Stock	29.485	29.775	29.4575	29.75	163073200.0
2014-11-26	MSFT	Stock	47.49	47.99	47.28	47.75	27163600.0
2014-11-26	NVDA	Stock	0.5112	0.5235	0.511	0.523	219264000.0
2014-11-26	AMZN	Stock	16.689	16.7325	16.5875	16.6785	39672000.0
2014-11-26	GOOGL	Stock	27.4615	27.494	27.2615	27.3865	29605880.0
2014-11-26	META	Stock	75.53	77.78	75.51	77.62	32695300.0
2014-11-26	TSLA	Stock	16.556	16.6	16.44	16.5627	29718000.0
2014-11-26	TLT	Stock	121.64	121.8666	121.47	121.53	4339146.0
2014-11-26	ES	Stock	49.58	49.85	49.53	49.64	1714300.0
2014-11-26	CL	Stock	68.47	68.74	68.33	68.69	1895200.0
2014-11-26	A	Stock	42.68	42.87	42.53	42.74	1752700.0
2014-11-26	AA.B-DELISTED	Stock	53.41	54.11	53.4	54.11	137068.0
2014-11-26	AABA-DELISTED	Stock	51.56	52.26	51.52	51.925	12933462.0
2014-11-26	AAC-DELISTED	Stock	28.32	29.43	27.84	28.86	31201.0
2014-11-26	AACG	Stock	3.87	3.97	3.85	3.85	4800.0
2014-11-26	AAIC-DELISTED	Stock	28.16	28.16	27.83	28.08	130592.0
2014-11-26	AAL	Stock	44.31	45.75	44.0	44.97	12798600.0
2014-11-26	AAMC-DELISTED	Stock	159.7206	163.2353	159.7206	163.0882	15980.0
2014-11-26	AAMI	Stock	15.43	15.75	15.405	15.69	79600.0
2014-11-26	AAOI	Stock	11.86	11.99	11.35	11.62	690200.0
2014-11-26	AAON	Stock	14.06	14.2067	13.92	14.1	165600.0
2014-11-26	AAP	Stock	145.86	146.38	144.75	145.71	644000.0
2014-11-26	AAT	Stock	38.71	39.19	38.71	39.07	177500.0
2014-11-26	AAU-DELISTED	Stock	1.05	1.07	1.05	1.06	43158.0
2014-11-26	AAUAF-DELISTED	Stock	1.04	1.06	1.04	1.06	43871.0
2014-11-26	AAV-DELISTED	Stock	4.96	5.04	4.87	4.9	182941.0
2014-11-26	AAVL-DELISTED	Stock	38.51	40.82	38.31	40.24	223544.0
2014-11-26	AAWW-DELISTED	Stock	44.94	45.47	44.56	45.05	146495.0
2014-11-26	AAXJ	Stock	63.12	63.48	63.12	63.45	866627.0
2014-11-26	AAXN-DELISTED	Stock	21.55	22.35	21.14	21.87	8880797.0
2014-11-26	AB	Stock	27.3	27.39	27.11	27.23	159300.0
2014-11-26	ABAC-DELISTED	Stock	2.05	2.07	1.88	2.02	14796.0
2014-11-26	ABAX-DELISTED	Stock	56.91	57.519	56.82	57.24	214216.0
2014-11-26	ABB-DELISTED	Stock	22.94	22.96	22.85	22.91	572482.0
2014-11-26	ABBNY-DELISTED	Stock	22.94	22.96	22.85	22.89	611608.0
2014-11-26	ABBV	Stock	68.34	68.86	67.88	68.7	4046000.0
2014-11-26	ABC-DELISTED	Stock	90.22	90.7999	89.5	90.09	866492.0
2014-11-26	ABCB	Stock	25.85	25.85	25.24	25.71	199800.0
2014-11-26	ABCD-DELISTED	Stock	1.74	1.81	1.74	1.7999	1700.0
2014-11-26	ABCO-DELISTED	Stock	42.7	43.17	42.5	42.62	178660.0
2014-11-26	ABCW-DELISTED	Stock	29.99	30.0	29.99	30.0	13048.0
2014-11-26	ABDC-DELISTED	Stock	13.05	13.1499	12.83	12.98	41590.0
2014-11-26	ABE-DELISTED	Stock	14.28	14.38	14.25	14.26	11792.0
2014-11-26	ABEO	Stock	176.25	176.25	176.25	176.25	88.0
2014-11-26	ABEV	Stock	6.63	6.68	6.6	6.63	7105900.0
2014-11-26	ABG	Stock	75.49	76.17	75.07	75.77	274400.0
2014-11-26	ABGB-DELISTED	Stock	13.3	13.55	13.17	13.42	52904.0
2014-11-26	ABM	Stock	27.24	27.36	27.09	27.22	130600.0
2014-11-26	ABMD-DELISTED	Stock	35.58	36.37	35.31	35.75	348795.0
2014-11-26	ABR	Stock	6.78	6.92	6.74	6.9	77900.0

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

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