PREVIEW / stock_daily / 2014-06-19

all stock daily files

  file:    by_date/stock_daily/2014/2014-06-19.parquet
  size:    220 KB
  rows:    6,563
  symbols: 3,566

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-06-19	AAPL	Stock	23.0725	23.075	22.835	22.965	142112000.0
2014-06-19	MSFT	Stock	41.57	41.77	41.33	41.51	19828200.0
2014-06-19	NVDA	Stock	0.4808	0.4832	0.475	0.4785	474592000.0
2014-06-19	AMZN	Stock	16.763	16.945	16.299	16.35	106412000.0
2014-06-19	GOOGL	Stock	28.0575	28.25	27.8334	28.2495	52610780.0
2014-06-19	META	Stock	65.46	65.58	64.21	64.34	34245000.0
2014-06-19	TSLA	Stock	15.2587	15.6873	15.1333	15.186	131896500.0
2014-06-19	TLT	Stock	112.51	112.56	110.74	110.96	14217289.0
2014-06-19	ES	Stock	46.9	47.31	46.71	46.79	2934400.0
2014-06-19	CL	Stock	68.91	69.45	68.91	69.43	3072200.0
2014-06-19	A	Stock	42.3462	42.5894	41.5951	41.9313	4403001.0
2014-06-19	AABA-DELISTED	Stock	35.14	35.2	34.52	34.68	14121901.0
2014-06-19	AACG	Stock	4.75	4.78	4.61	4.68	6400.0
2014-06-19	AAIC-DELISTED	Stock	27.92	27.97	27.73	27.84	270930.0
2014-06-19	AAL	Stock	42.82	43.49	42.66	43.06	14116000.0
2014-06-19	AAMC-DELISTED	Stock	322.0412	324.7059	320.0	323.2412	32694.0
2014-06-19	AAME	Stock	3.98	4.02	3.93	3.94	5400.0
2014-06-19	AAOI	Stock	23.13	23.2	22.41	23.15	238400.0
2014-06-19	AAON	Stock	14.9244	15.0222	14.5022	14.7244	220950.0
2014-06-19	AAP	Stock	130.0	130.51	127.33	128.84	620200.0
2014-06-19	AAT	Stock	34.48	34.65	34.28	34.62	97200.0
2014-06-19	AAU-DELISTED	Stock	1.43	1.5204	1.43	1.49	556868.0
2014-06-19	AAUAF-DELISTED	Stock	1.41	1.5	1.41	1.49	568586.0
2014-06-19	AAV-DELISTED	Stock	7.07	7.1	6.92	6.94	431403.0
2014-06-19	AAWW-DELISTED	Stock	37.3	37.3	36.1	36.26	160094.0
2014-06-19	AAXJ	Stock	62.9	62.97	62.72	62.87	901627.0
2014-06-19	AAXN-DELISTED	Stock	14.0	14.0	13.62	13.695	586962.0
2014-06-19	AB	Stock	25.87	26.1	25.54	25.9	315400.0
2014-06-19	ABAC-DELISTED	Stock	2.2012	2.35	2.2	2.21	167349.0
2014-06-19	ABAX-DELISTED	Stock	43.36	43.52	43.06	43.39	87532.0
2014-06-19	ABB-DELISTED	Stock	23.38	23.38	23.25	23.29	819068.0
2014-06-19	ABBNY-DELISTED	Stock	23.38	23.38	23.25	23.28	849009.0
2014-06-19	ABBV	Stock	54.14	54.81	53.92	54.19	3952800.0
2014-06-19	ABC-DELISTED	Stock	72.18	72.42	71.64	71.94	1164295.0
2014-06-19	ABCB	Stock	21.8	21.8	21.52	21.7	32300.0
2014-06-19	ABCD-DELISTED	Stock	2.0	2.1	1.97	2.02	5410.0
2014-06-19	ABCO-DELISTED	Stock	52.38	52.82	51.56	52.0	231057.0
2014-06-19	ABDC-DELISTED	Stock	14.3001	14.49	14.25	14.45	52563.0
2014-06-19	ABE-DELISTED	Stock	14.52	14.52	14.29	14.29	16516.0
2014-06-19	ABEO	Stock	400.0	400.0	400.0	400.0	18.0
2014-06-19	ABEV	Stock	7.1	7.11	7.01	7.1	10658300.0
2014-06-19	ABG	Stock	64.58	64.95	64.5	64.7	147200.0
2014-06-19	ABGB-DELISTED	Stock	28.46	28.59	28.34	28.3856	6946.0
2014-06-19	ABM	Stock	26.47	26.78	26.37	26.62	289100.0
2014-06-19	ABMD-DELISTED	Stock	23.45	23.45	23.0201	23.38	95511.0
2014-06-19	ABR	Stock	7.09	7.13	7.05	7.09	312700.0
2014-06-19	ABR.A-DELISTED	Stock	24.349	24.39	24.34	24.37	10669.0
2014-06-19	ABR.B-DELISTED	Stock	23.96	24.0	23.7901	23.96	4600.0
2014-06-19	ABR.C-DELISTED	Stock	25.05	25.05	25.04	25.05	1700.0
2014-06-19	ABRN-DELISTED	Stock	24.92	24.92	24.81	24.85	14975.0

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

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