PREVIEW / etf_daily / 2015-05-12

all etf daily files

  file:    by_date/etf_daily/2015/2015-05-12.parquet
  size:    48 KB
  rows:    1,176

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-12	SPY	ETF	209.61	210.63	208.62	209.98	119727600.0
2015-05-12	QQQ	ETF	107.63	108.33	106.8	107.78	33665017.0
2015-05-12	IWM	ETF	122.35	122.92	120.87	122.49	34961600.0
2015-05-12	DIA	ETF	180.1	181.23	179.27	180.72	4742800.0
2015-05-12	GLD	ETF	114.1	114.67	114.06	114.5	3256700.0
2015-05-12	TLT	ETF	119.14	120.63	118.82	119.84	15861700.0
2015-05-12	AADR	ETF	40.43	40.43	40.36	40.36	1000.0
2015-05-12	AAXJ	ETF	66.64	66.9	66.45	66.79	960400.0
2015-05-12	ACTX	ETF	2.95	2.95	2.36	2.891	4098.0
2015-05-12	ACWF	ETF	25.12	25.12	25.0	25.01	5273.0
2015-05-12	ACWI	ETF	61.88	62.11	61.67	61.97	586800.0
2015-05-12	ACWV	ETF	72.86	73.01	72.5	72.92	105000.0
2015-05-12	ACWX	ETF	46.84	46.9999	46.72	46.88	120627.0
2015-05-12	ADRE	ETF	36.88	37.14	36.88	37.0379	2060.0
2015-05-12	AFK	ETF	26.46	26.69	26.42	26.52	24177.0
2015-05-12	AFTY	ETF	22.19	22.378	22.141	22.37	28300.0
2015-05-12	AGG	ETF	109.5	109.76	109.38	109.58	1394900.0
2015-05-12	AGQ	ETF	39.96	41.15	39.95	40.82	186800.0
2015-05-12	AGZ	ETF	113.14	113.2199	112.96	113.1588	10001.0
2015-05-12	AGZD	ETF	24.525	24.525	24.455	24.52	27200.0
2015-05-12	AIA	ETF	52.5	52.736	52.282	52.68	18718.0
2015-05-12	AIQ	ETF	20.5	20.7	20.5	20.59	9992.0
2015-05-12	AIRR	ETF	17.9	18.13	17.9	18.11	4200.0
2015-05-12	AIVI	ETF	46.11	46.36	46.08	46.24	25400.0
2015-05-12	AMJ	ETF	44.08	44.5424	43.9698	44.37	540601.0
2015-05-12	AMLP	ETF	84.2	84.9	83.9	84.65	839640.0
2015-05-12	AMZA	ETF	218.6	220.0	218.6	219.0	570.0
2015-05-12	ANGL	ETF	27.58	27.58	27.49	27.56	8600.0
2015-05-12	AOA	ETF	48.32	48.42	48.11	48.39	14200.0
2015-05-12	AOK	ETF	32.88	32.92	32.7101	32.91	44753.0
2015-05-12	AOM	ETF	35.63	35.74	35.5475	35.72	37186.0
2015-05-12	AOR	ETF	41.26	41.329	41.0901	41.29	74759.0
2015-05-12	ARGT	ETF	21.89	22.04	21.8	22.03	6100.0
2015-05-12	ARKG	ETF	22.85	22.85	22.81	22.81	700.0
2015-05-12	ARKK	ETF	20.9	20.9	20.9	20.9	100.0
2015-05-12	ARKQ	ETF	19.71	19.71	19.71	19.71	100.0
2015-05-12	ARKW	ETF	22.17	22.32	22.17	22.24	1400.0
2015-05-12	ASEA	ETF	15.78	15.78	15.78	15.78	200.0
2015-05-12	ASHR	ETF	48.38	48.55	48.16	48.54	1551600.0
2015-05-12	ASHS	ETF	56.3	56.78	56.3	56.53	93500.0
2015-05-12	ATMP	ETF	29.84	30.05	29.75	29.98	28000.0
2015-05-12	AWAY	ETF	27.12	27.21	26.67	26.75	1541357.0
2015-05-12	BAB	ETF	29.07	29.18	28.97	29.09	81661.0
2015-05-12	BAL	ETF	44.29	44.31	43.88	44.14	10004.0
2015-05-12	BALT	ETF	1.42	1.46	1.39	1.45	307538.0
2015-05-12	BAR	ETF	2.626	2.6855	2.626	2.6855	19880.0
2015-05-12	BBC	ETF	33.23	33.4408	32.4	33.2	15366.0
2015-05-12	BBH	ETF	129.56	130.93	128.58	130.41	76400.0
2015-05-12	BBP	ETF	31.6	31.6	30.83	31.5	9200.0
2015-05-12	BCM	ETF	32.45	32.589	32.45	32.53	1512.0

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

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