PREVIEW / stock_daily / 2014-11-17

all stock daily files

  file:    by_date/stock_daily/2014/2014-11-17.parquet
  size:    223 KB
  rows:    6,670
  symbols: 3,574

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-17	AAPL	Stock	28.5675	29.32	28.325	28.4975	186986800.0
2014-11-17	MSFT	Stock	49.41	49.71	49.14	49.46	30318600.0
2014-11-17	NVDA	Stock	0.4925	0.4978	0.4892	0.4925	158732000.0
2014-11-17	AMZN	Stock	16.322	16.4	15.9015	16.1525	95698000.0
2014-11-17	GOOGL	Stock	27.7595	27.7595	27.222	27.332	33612420.0
2014-11-17	META	Stock	74.88	75.66	73.88	74.24	28701200.0
2014-11-17	TSLA	Stock	17.166	17.2667	16.8013	16.932	60385500.0
2014-11-17	TLT	Stock	119.78	119.79	118.88	119.19	4726190.0
2014-11-17	ES	Stock	48.81	49.52	48.71	49.44	860600.0
2014-11-17	CL	Stock	67.48	67.97	67.34	67.92	1950200.0
2014-11-17	A	Stock	41.57	41.7	41.21	41.24	2697200.0
2014-11-17	AA.B-DELISTED	Stock	52.61	52.61	52.316	52.47	36297.0
2014-11-17	AABA-DELISTED	Stock	51.83	52.42	50.94	52.37	33556101.0
2014-11-17	AAC-DELISTED	Stock	26.99	29.67	26.0	28.1	159490.0
2014-11-17	AACG	Stock	3.94	3.95	3.87	3.9	5100.0
2014-11-17	AAIC-DELISTED	Stock	27.27	27.44	27.2	27.23	106056.0
2014-11-17	AAL	Stock	43.97	44.58	43.63	43.69	8691700.0
2014-11-17	AAMC-DELISTED	Stock	141.1765	146.75	141.1765	144.2647	14066.0
2014-11-17	AAME	Stock	3.82	3.88	3.81	3.85	3000.0
2014-11-17	AAMI	Stock	15.69	16.29	15.4	15.75	448500.0
2014-11-17	AAOI	Stock	12.16	12.21	11.8	11.88	348700.0
2014-11-17	AAON	Stock	13.9267	13.9533	13.6	13.6467	229350.0
2014-11-17	AAP	Stock	145.21	147.03	145.21	145.83	557800.0
2014-11-17	AAT	Stock	38.62	38.96	38.48	38.89	84600.0
2014-11-17	AAU-DELISTED	Stock	1.1	1.18	1.08	1.13	128492.0
2014-11-17	AAUAF-DELISTED	Stock	1.1	1.18	1.08	1.14	130313.0
2014-11-17	AAV-DELISTED	Stock	4.81	5.12	4.8	5.03	375083.0
2014-11-17	AAVL-DELISTED	Stock	33.96	34.5673	32.81	32.81	54955.0
2014-11-17	AAWW-DELISTED	Stock	41.62	41.76	40.775	41.18	229834.0
2014-11-17	AAXJ	Stock	62.23	62.23	62.03	62.17	1249956.0
2014-11-17	AAXN-DELISTED	Stock	20.11	20.2	19.48	19.5	2431079.0
2014-11-17	AB	Stock	26.34	26.49	26.05	26.25	133800.0
2014-11-17	ABAC-DELISTED	Stock	2.22	2.33	2.22	2.28	25215.0
2014-11-17	ABAX-DELISTED	Stock	54.63	55.56	54.385	54.68	153608.0
2014-11-17	ABB-DELISTED	Stock	22.33	22.345	22.25	22.28	783005.0
2014-11-17	ABBNY-DELISTED	Stock	22.33	22.345	22.25	22.28	828791.0
2014-11-17	ABBV	Stock	64.08	65.41	64.03	65.04	7117100.0
2014-11-17	ABC-DELISTED	Stock	88.83	89.7	88.57	89.01	1441328.0
2014-11-17	ABCB	Stock	25.7	25.85	25.53	25.64	64700.0
2014-11-17	ABCD-DELISTED	Stock	1.74	1.8899	1.74	1.82	2273.0
2014-11-17	ABCO-DELISTED	Stock	46.04	46.35	45.3	45.53	187413.0
2014-11-17	ABCW-DELISTED	Stock	30.0	30.8	29.9	30.8	1546.0
2014-11-17	ABDC-DELISTED	Stock	12.79	12.8899	12.65	12.75	39368.0
2014-11-17	ABE-DELISTED	Stock	13.77	13.88	13.7	13.7	7509.0
2014-11-17	ABEO	Stock	150.0	175.0	150.0	171.25	64.0
2014-11-17	ABEV	Stock	6.19	6.21	6.08	6.14	11535200.0
2014-11-17	ABG	Stock	73.72	74.58	72.81	73.2	250800.0
2014-11-17	ABGB-DELISTED	Stock	11.4	11.82	11.22	11.48	1350601.0
2014-11-17	ABM	Stock	27.17	27.33	27.03	27.04	104300.0
2014-11-17	ABMD-DELISTED	Stock	33.1	34.05	32.95	33.77	722558.0

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

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