PREVIEW / stock_daily / 2014-08-20

all stock daily files

  file:    by_date/stock_daily/2014/2014-08-20.parquet
  size:    222 KB
  rows:    6,615
  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-08-20	AAPL	Stock	25.11	25.2725	24.9875	25.1425	210796000.0
2014-08-20	MSFT	Stock	45.34	45.4	44.9	44.95	24770500.0
2014-08-20	NVDA	Stock	0.4825	0.4848	0.48	0.4812	221468000.0
2014-08-20	AMZN	Stock	16.734	16.858	16.701	16.789	36210000.0
2014-08-20	GOOGL	Stock	29.8475	29.8495	29.65	29.7705	19372340.0
2014-08-20	META	Stock	74.97	75.18	74.62	74.81	22917000.0
2014-08-20	TSLA	Stock	16.978	17.2493	16.8667	17.0473	45418500.0
2014-08-20	TLT	Stock	116.04	116.11	115.5701	115.99	7277519.0
2014-08-20	ES	Stock	44.7	45.11	44.64	45.09	1806000.0
2014-08-20	CL	Stock	64.42	64.81	64.24	64.67	2815800.0
2014-08-20	A	Stock	41.7167	41.7811	41.4449	41.7239	2581547.0
2014-08-20	AABA-DELISTED	Stock	37.61	37.75	37.33	37.495	12110539.0
2014-08-20	AACG	Stock	4.74	4.75	4.56	4.56	4500.0
2014-08-20	AAIC-DELISTED	Stock	27.54	27.77	27.45	27.68	139764.0
2014-08-20	AAL	Stock	40.4	40.8	40.03	40.6	6504500.0
2014-08-20	AAMC-DELISTED	Stock	165.7324	174.5588	165.7324	174.5588	68218.0
2014-08-20	AAME	Stock	4.17	4.17	4.1	4.17	4900.0
2014-08-20	AAOI	Stock	19.48	19.93	19.3	19.56	169400.0
2014-08-20	AAON	Stock	12.64	12.64	12.38	12.4333	95550.0
2014-08-20	AAP	Stock	133.94	135.33	133.5	135.14	400200.0
2014-08-20	AAT	Stock	35.24	35.48	35.02	35.3	116400.0
2014-08-20	AAU-DELISTED	Stock	1.5	1.5	1.44	1.45	90845.0
2014-08-20	AAUAF-DELISTED	Stock	1.5	1.5	1.44	1.45	91970.0
2014-08-20	AAV-DELISTED	Stock	5.71	5.7608	5.6023	5.73	402880.0
2014-08-20	AAVL-DELISTED	Stock	30.93	32.375	29.851	31.6	167429.0
2014-08-20	AAWW-DELISTED	Stock	33.71	33.71	33.04	33.42	102403.0
2014-08-20	AAXJ	Stock	65.75	66.21	65.75	66.05	796276.0
2014-08-20	AAXN-DELISTED	Stock	15.98	15.9823	15.22	15.47	2897932.0
2014-08-20	AB	Stock	26.2	27.0	26.16	26.76	231500.0
2014-08-20	ABAC-DELISTED	Stock	1.96	1.98	1.91	1.98	14800.0
2014-08-20	ABAX-DELISTED	Stock	45.79	46.312	45.26	46.04	109505.0
2014-08-20	ABB-DELISTED	Stock	22.53	22.72	22.53	22.675	1203172.0
2014-08-20	ABBNY-DELISTED	Stock	22.53	22.72	22.53	22.68	1309929.0
2014-08-20	ABBV	Stock	54.82	55.18	54.69	55.06	7612200.0
2014-08-20	ABC-DELISTED	Stock	76.93	77.02	76.58	76.87	640445.0
2014-08-20	ABCB	Stock	22.63	22.67	22.28	22.36	41400.0
2014-08-20	ABCD-DELISTED	Stock	1.78	1.786	1.68	1.69	6998.0
2014-08-20	ABCO-DELISTED	Stock	50.66	51.0	50.12	50.34	189063.0
2014-08-20	ABDC-DELISTED	Stock	13.47	13.47	13.104	13.27	62050.0
2014-08-20	ABE-DELISTED	Stock	14.62	14.65	14.6001	14.62	3204.0
2014-08-20	ABEO	Stock	400.0	412.5	375.0	412.5	19.0
2014-08-20	ABEV	Stock	7.19	7.24	7.14	7.22	7429000.0
2014-08-20	ABG	Stock	69.3	69.77	68.61	69.3	124200.0
2014-08-20	ABGB-DELISTED	Stock	25.3	25.63	25.3	25.48	7130.0
2014-08-20	ABM	Stock	26.03	26.1	25.81	25.93	136100.0
2014-08-20	ABMD-DELISTED	Stock	25.58	25.625	25.0	25.12	236834.0
2014-08-20	ABR	Stock	6.94	6.97	6.92	6.93	103300.0
2014-08-20	ABR.A-DELISTED	Stock	24.64	24.69	24.64	24.69	2015.0
2014-08-20	ABR.B-DELISTED	Stock	24.25	24.25	24.1	24.1	2883.0
2014-08-20	ABR.C-DELISTED	Stock	25.03	25.05	24.97	24.9701	2700.0

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

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