PREVIEW / etf_daily / 2015-05-26

all etf daily files

  file:    by_date/etf_daily/2015/2015-05-26.parquet
  size:    47 KB
  rows:    1,182

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
2015-05-26	SPY	ETF	212.4	212.91	210.2	210.7	124308600.0
2015-05-26	QQQ	ETF	110.23	110.38	108.76	109.2	25488437.0
2015-05-26	IWM	ETF	123.94	124.04	122.52	123.24	44037800.0
2015-05-26	DIA	ETF	181.93	181.93	179.79	180.37	5529700.0
2015-05-26	GLD	ETF	113.84	114.23	113.7	113.91	5769600.0
2015-05-26	TLT	ETF	120.84	122.55	120.74	122.46	10469700.0
2015-05-26	AADR	ETF	39.92	39.92	39.77	39.77	300.0
2015-05-26	AAXJ	ETF	68.42	68.42	67.72	67.89	602400.0
2015-05-26	ACTX	ETF	3.54	3.54	2.95	3.54	136.0
2015-05-26	ACWF	ETF	25.21	25.21	25.1299	25.1299	5400.0
2015-05-26	ACWI	ETF	62.43	62.55	61.75	61.89	624900.0
2015-05-26	ACWV	ETF	73.15	73.27	72.41	72.66	246500.0
2015-05-26	ACWX	ETF	46.91	47.06	46.5	46.57	146002.0
2015-05-26	ADRE	ETF	36.94	36.94	36.45	36.56	9603.0
2015-05-26	AFK	ETF	26.2	26.2	25.9	25.97	64732.0
2015-05-26	AFTY	ETF	24.4	24.4	23.8	23.835	81300.0
2015-05-26	AGG	ETF	109.8	110.1	109.75	110.06	2775000.0
2015-05-26	AGQ	ETF	41.66	42.39	41.5	41.63	225900.0
2015-05-26	AGZ	ETF	113.15	113.59	113.15	113.54	16428.0
2015-05-26	AGZD	ETF	24.42	24.455	24.4	24.415	9600.0
2015-05-26	AIA	ETF	54.09	54.09	53.5051	53.6799	28990.0
2015-05-26	AIQ	ETF	20.0	20.0	19.05	19.36	26495.0
2015-05-26	AIRR	ETF	18.11	18.17	18.06	18.14	25100.0
2015-05-26	AIVI	ETF	45.9	45.9	45.33	45.49	76600.0
2015-05-26	AMJ	ETF	44.98	44.98	44.35	44.54	764988.0
2015-05-26	AMLP	ETF	84.2	84.3	83.55	83.75	632580.0
2015-05-26	AMZA	ETF	223.8	223.85	220.0	220.4	3670.0
2015-05-26	ANGL	ETF	27.69	27.69	27.53	27.62	11300.0
2015-05-26	AOA	ETF	48.9	48.9	48.35	48.44	37500.0
2015-05-26	AOK	ETF	33.07	33.07	32.89	33.01	204155.0
2015-05-26	AOM	ETF	35.99	35.99	35.7	35.83	186560.0
2015-05-26	AOR	ETF	41.68	41.68	41.25	41.36	67234.0
2015-05-26	ARGT	ETF	21.54	21.55	21.17	21.18	40400.0
2015-05-26	ARKG	ETF	23.25	23.25	22.79	22.89	5300.0
2015-05-26	ARKK	ETF	21.45	21.45	21.24	21.31	3400.0
2015-05-26	ARKQ	ETF	20.11	20.11	19.92	19.92	700.0
2015-05-26	ARKW	ETF	23.36	23.36	23.154	23.157	3300.0
2015-05-26	ASEA	ETF	15.75	15.75	15.56	15.6	4300.0
2015-05-26	ASHR	ETF	54.97	54.97	53.52	53.6	4248600.0
2015-05-26	ASHS	ETF	66.14	72.25	66.14	68.4	294200.0
2015-05-26	ATMP	ETF	30.6	30.6	30.08	30.19	137500.0
2015-05-26	AWAY	ETF	28.53	28.66	27.89	28.16	633565.0
2015-05-26	BAB	ETF	28.99	29.21	28.9624	29.19	130534.0
2015-05-26	BAL	ETF	43.38	43.38	42.8816	42.94	5454.0
2015-05-26	BALT	ETF	1.5	1.55	1.47	1.53	602145.0
2015-05-26	BAR	ETF	2.609	2.6503	2.608	2.6503	38550.0
2015-05-26	BBC	ETF	34.6	34.79	34.06	34.529	20558.0
2015-05-26	BBH	ETF	135.27	135.27	133.07	133.67	127600.0
2015-05-26	BBP	ETF	32.45	32.45	32.06	32.34	4200.0
2015-05-26	BCHP	ETF	20.47	20.47	20.36	20.36	1169.0

> showing 50 of 1,182 rows — these rows as CSV

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